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

( SELECT DISTINCT TX_HASH, BLOCK_TIMESTAMP, AMOUNT

FROM ethereum.core.ez_ETH_transfers

WHERE

AMOUNT > 0

AND BLOCK_TIMESTAMP > '{{start_date_arbitrum}}'

AND BLOCK_TIMESTAMP < '{{end_date_arbitrum}}'

AND ORIGIN_TO_ADDRESS = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f'

AND ORIGIN_FUNCTION_SIGNATURE in ('0x439370b1','0x0f4d14e9') -- Deposit ETH

)

GROUP BY HOUR

ORDER BY

HOUR

) AS subquery

ORDER BY HOUR