andreafiandroarbitrum Bridge
    Updated 2023-10-10
    SELECT
    HOUR,
    AMOUNT,
    SUM(AMOUNT) OVER (ORDER BY HOUR) as CUMULATIVE_BRIDGED_AMOUNT
    FROM
    (
    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
    Run a query to Download Data