flipside

    2024-06-06 07:57 AM
    i_dan2024-06-06 07:57 AM
    Updated 2024-06-06
    SELECT
    contract_address
    , COUNT(tx_hash)
    , symbol_in
    , symbol_out
    FROM
    base.defi.ez_dex_swaps
    WHERE 1=1
    AND amount_in_usd IS NULL
    GROUP BY 1, 3, 4
    ORDER BY symbol_out ASC
    -- 1 DESC --LIMIT 100
    QueryRunArchived: QueryRun has been archived