HOUR,

AMOUNT,

SUM(AMOUNT) OVER (ORDER BY HOUR) as CUMULATIVE_BRIDGED_AMOUNT

(

SELECT

date_trunc('hour', BLOCK_TIMESTAMP) as HOUR,

SUM(AMOUNT) as AMOUNT

FROM

ethereum.core.ez_ETH_transfers

WHERE

AMOUNT > 0

AND HOUR > '{{start_date_optimism}}'

AND HOUR < '{{end_date_optimism}}'

AND ORIGIN_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

AND ORIGIN_FUNCTION_SIGNATURE in ('0xb1a1a882', '0x9a2ac6d5', '0x')

GROUP BY HOUR

ORDER BY

HOUR

) AS subquery

ORDER BY HOUR