Updated 2024-04-04
    SELECT
    *
    from
    base.defi.ez_dex_swaps
    WHERE
    TOKEN_OUT = '0xd02c83c1d519adf4b5da39c4eefd10fbed192773'
    ORDER BY
    block_timestamp
    LIMIT
    100

    -- with a as (
    -- SELECT
    -- *
    -- FROM
    -- base.defi.ez_dex_swaps
    -- WHERE
    -- TOKEN_OUT = '0xd02c83c1d519adf4b5da39c4eefd10fbed192773'
    -- ),
    -- b as (
    -- SELECT
    -- *
    -- FROM
    -- base.defi.ez_dex_swaps
    -- WHERE
    -- TOKEN_OUT = '0xAaF2cDd7ff7D88A321Da49eFA9fdCC9226cBF3eB'
    -- ), -- select * from a join b on a.swapper = b.swapper
    -- c AS (
    -- select
    -- a.block_timestamp,
    -- a.ORIGIN_FROM_ADDRESS as swapper,
    -- b.ORIGIN_FROM_ADDRESS as signer
    -- from
    -- a
    -- join b on a.ORIGIN_FROM_ADDRESS = b.ORIGIN_FROM_ADDRESS
    -- ORDER by
    QueryRunArchived: QueryRun has been archived