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_polygon}}'

AND HOUR < '{{end_date_polygon}}'

AND ORIGIN_TO_ADDRESS = '0x2a3dd3eb832af982ec71669e178424b10dca2ede'

AND ORIGIN_FUNCTION_SIGNATURE in ('0xcd586579') -- Deposit ETH

GROUP BY HOUR

ORDER BY

HOUR

) AS subquery

ORDER BY HOUR