andreafiandro2023-10-04 09:43 AM
    Updated 2023-10-04
    SELECT
    TX_HASH,
    BLOCK_TIMESTAMP,
    AMOUNT
    FROM
    ethereum.core.ez_ETH_transfers
    WHERE
    AMOUNT > 0
    AND BLOCK_TIMESTAMP > '{{start_date_zksync}}'
    AND BLOCK_TIMESTAMP < '{{end_date_zksync}}'
    AND ORIGIN_TO_ADDRESS = '0x32400084c286cf3e17e7b677ea9583e60a000324'
    AND ORIGIN_FUNCTION_SIGNATURE in ('0xeb672419') -- Deposit ETH\
    ORDER BY
    AMOUNT DESC
    Run a query to Download Data