date_trunc (hour, a.block_timestamp) as "Date",

count (DISTINCT origin_from_address) as "Total claimers",

sum ("Total claimers") over (order by "Date") as "cumulative claimers",

sum (amount) as "Total token claimed",

sum ("Total token claimed") over (order by "Date") as "Cumulative token claimed",

sum (tx_fee) as "Total Claiming Fee (ETH)",

sum ("Total Claiming Fee (ETH)") over (order by "Date") as "Cumulative Claming Fee (ETH)",

from base.core.ez_token_transfers a join base.core.fact_transactions b on a.tx_hash = b.tx_hash

where origin_to_address = '0xf4c9fc64ed902b08c3397c48dca0342bdfd49a32'

and contract_address = '0x4ed4e862860bed51a9570b96d89af5e1b0efefed'

GROUP by 1

order by 1 desc