Query editor
-- Ethereum Distributor Claims (Daily) - FIXEDWITH distributor_config AS (SELECT * FROM (VALUES(0xD833484b198D3d05707832cc1C2D62b520D95B8A, 'mainnet-gho-vaults-rewards-april-2025', 'TokenLogic', 'FLUID', 18, false),(0x7060FE0Dd3E31be01EFAc6B28C8D38018fD163B0, 'inst-rewards-dec-2024', 'Fluid', 'FLUID', 18, false)) AS t(contract_address, program, partner, token, decimals, exclude_expense)),log_claimed_events AS (SELECTe.block_time,e.contract_address,d.program,d.partner,d.token,d.exclude_expense,d.decimals,bytearray_to_uint256(bytearray_substring(e.data, 33, 32)) as amount_rawFROM ethereum.logs eINNER JOIN distributor_config d ON e.contract_address = d.contract_addressWHERE e.contract_address IN (0xD833484b198D3d05707832cc1C2D62b520D95B8A,0x7060FE0Dd3E31be01EFAc6B28C8D38018fD163B0)AND e.topic0 = 0x309cb1c0dc6ce0f02c0c35cc1f46bbe61ec9deb311d101b87e7d25bd0b647fd7AND e.block_time >= TIMESTAMP '2025-09-01')SELECT'ethereum' as chain,program,partner,token,exclude_expense,DATE_TRUNC('day', block_time) as date,COUNT(*) as num_claims,SUM(CAST(amount_raw AS DOUBLE) / POW(10, decimals)) as total_claimedFROM log_claimed_eventsGROUP BY 1,2,3,4,5,6ORDER BY date DESC, total_claimed DESC