select tx_hash ,

from base.core.fact_event_logs

where contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

and ORIGIN_TO_ADDRESS ='0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'

and ORIGIN_FUNCTION_SIGNATURE = '0x69659658'

and block_timestamp::date >= '2025-02-20'

group by 1

),

claimed_amount_ as(

select date_trunc(hour,BLOCK_TIMESTAMP) date ,

TO_ADDRESS user ,

AMOUNT

from claim_txns left join base.core.ez_token_transfers using (tx_hash)

select

date ,

count (distinct user) num_claimers ,

sum (num_claimers)over ( order by date ) cum_claimers ,

sum (AMOUNT) claimed_volume ,

sum (claimed_volume) over(order by date) cum_claimed_volume ,

avg(AMOUNT) average_claimed_amount ,

median (AMOUNT) median_claimed_amount ,

min (AMOUNT) minimum_claimed_amount ,

max(amount) maximum_claimed_amount

from claimed_amount_

group by 1