jangob2023-06-30 09:16 AM
    Updated 2023-06-30
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    POOL_NAME,
    PLATFORM,
    AMOUNT_IN,
    SYMBOL_IN,
    AMOUNT_OUT,
    SYMBOL_OUT,
    TOKEN_IN
    FROM
    ethereum.core.ez_dex_swaps
    WHERE
    (
    TOKEN_IN = LOWER('0x6468e79A80C0eaB0F9A2B574c8d5bC374Af59414')
    OR TOKEN_OUT = LOWER('0x6468e79A80C0eaB0F9A2B574c8d5bC374Af59414')
    )
    AND (SYMBOL_IN = 'USDC' OR SYMBOL_OUT = 'USDC')
    AND BLOCK_TIMESTAMP >= '2023-06-29 06:00:00'
    Run a query to Download Data