date_trunc('hour', block_timestamp) as hour,

count(DISTINCT TO_ADDRESS) as claimers,

sum(amount) as tokens_claimed,

sum(tokens_claimed) over (order by hour) as total_tokens_claimed,

sum(claimers) over (order by hour) as total_claimers

FROM ethereum.core.ez_token_transfers

WHERE contract_address like lower('0x0000000000c5dc95539589fbD24BE07c6C14eCa4')

and from_address like lower('0x000000F534CaA75BD1a3950aB32D6bd24D2e6B76')

and block_timestamp > '2024-12-05'

AND ORIGIN_FUNCTION_SIGNATURE like '0xd9daa2a0'

GROUP BY 1

ORDER BY 1 DESC