select

date_trunc('hour', BLOCK_TIMESTAMP) as dt,

sum(raw_amount/1e18) as eth

from blast.core.fact_token_transfers

where contract_address = '0x4300000000000000000000000000000000000004'

and to_address = '0x8ab15fe88a00b03724ac91ee4ee1f998064f2e31'

group by dt

),

total_stats as (

select

*,

sum(eth) over(order by dt asc) as total_eth

from tmp

order by dt desc

select *

from total_stats

where dt >= date('2024-05-01')