date_trunc('hour', block_timestamp) as hour,

sum(

case when to_address LIKE lower('0xe1a2e68c401378050fdba9704fa8bcb1f72b98f4') then raw_amount

else -raw_amount end / power(10, 18)

) as net_deposits,

sum(net_deposits) over (ORDER by hour) as total_deposits

FROM blast.core.fact_token_transfers

where contract_address = '0x4300000000000000000000000000000000000003'

and (from_address LIKE lower('0xe1a2e68c401378050fdba9704fa8bcb1f72b98f4')

or to_address LIKE lower('0xe1a2e68c401378050fdba9704fa8bcb1f72b98f4'))

GROUP by 1

ORDER BY 1 DESC