Query editor
-- Base Distributor Claims (Daily)WITH distributor_config AS (SELECT * FROM (VALUES(0xF36029358A684CdDD5103A4b84dC8a832c6e5b40, 'base-gho-rewards-jul-2025', 'TokenLogic', 'FLUID', 18, false),(0x94312a608246Cecfce6811Db84B3Ef4B2619054E, 'base-fluid-rewards-jul-2025', '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 base.logs eINNER JOIN distributor_config d ON e.contract_address = d.contract_addressWHERE e.contract_address IN (0xF36029358A684CdDD5103A4b84dC8a832c6e5b40,0x94312a608246Cecfce6811Db84B3Ef4B2619054E)AND e.topic0 = 0x309cb1c0dc6ce0f02c0c35cc1f46bbe61ec9deb311d101b87e7d25bd0b647fd7AND e.block_time >= TIMESTAMP '2025-09-01')SELECT'base' 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