SELECT date_trunc('hour',block_timestamp) as hour,

sum(event_data:amount/pow(10,8)) as volume,

sum(volume)over(order by hour) as cum_vol,

count(DISTINCT event_data:address) as n_claimers

FROM aptos.core.fact_events

WHERE event_module = 'vesting' and event_resource = 'Claimed' and event_data:vesting_name = 'Airdrop'

GROUP by

1

ORDER by hour DESC