PRICE ,

from base.price.ez_prices_hourly

where token_address ='0x98d0baa52b2d063e780de12f615f963fe8537553'

),

claim_txns as (

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 ,

median (price ) price ,

count (distinct user) num_claimers ,

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

sum (AMOUNT) claimed_volume ,

from claimed_amount_ left join kaito_price on hour=date

where date < current_date

group by 1