djebrilMonthly Uniswap Top 10 Pairs by Trade Volume Ethereum
    Updated 2024-09-10
    WITH

    tokens AS (
    SELECT
    block_timestamp AS block_time,
    tx_hash,
    concat(greatest(symbol_in,symbol_out), ' - ', least(symbol_in,symbol_out)) AS pair,
    origin_from_address AS trader,
    CASE
    WHEN amount_in <= 1000000 THEN amount_in
    WHEN amount_out <= 1000000 THEN amount_out
    END AS amount, --Flipside data issue
    'Ethereum' AS chain_id
    FROM ethereum.defi.ez_dex_swaps
    WHERE platform ilike 'uniswap%'
    AND NOT pair IS NULL
    AND NOT amount IS NULL
    UNION ALL
    SELECT
    block_timestamp AS block_time,
    tx_hash,
    concat(greatest(symbol_in,symbol_out), ' - ', least(symbol_in,symbol_out)) AS pair,
    origin_from_address AS trader,
    CASE
    WHEN amount_in <= 1000000 THEN amount_in
    WHEN amount_out <= 1000000 THEN amount_out
    END AS amount, --Flipside data issue
    'Optimism' AS chain_id
    FROM optimism.defi.ez_dex_swaps
    WHERE platform ilike 'uniswap%'
    AND NOT pair IS NULL
    AND NOT amount IS NULL
    UNION ALL
    SELECT
    block_timestamp AS block_time,
    tx_hash,
    QueryRunArchived: QueryRun has been archived