select hour, sum(balance) over (order by hour) as balance from (

select hour, sum(amount) as balance from (

select date_trunc('hour', block_timestamp) as hour, amount

from blast.core.ez_token_transfers

where contract_address = '0xf7bc58b8d8f97adc129cfc4c9f45ce3c0e1d2692'

and to_address = '0x0b32e91c276377b3b3cdb332e902207defe542bd'

union all

select date_trunc('hour', block_timestamp) as hour, -amount

from blast.core.ez_token_transfers

where contract_address = '0xf7bc58b8d8f97adc129cfc4c9f45ce3c0e1d2692'

and from_address = '0x0b32e91c276377b3b3cdb332e902207defe542bd') a

group by 1

order by 1 asc) b) c