djebrilNetwork-based Normalized Monthly Uniswap Token Traders
    Updated 2024-09-10
    WITH

    tokens AS (
    SELECT
    block_timestamp AS block_time,
    tx_hash,
    'ethereum' AS network,
    token_out AS token_address,
    symbol_out AS symbol,
    CASE
    WHEN amount_in <= 1000000 THEN amount_in
    WHEN amount_out <= 1000000 THEN amount_out
    END AS amount, --Flipside data issue
    ORIGIN_FROM_ADDRESS AS trader
    FROM ethereum.defi.ez_dex_swaps
    WHERE platform ilike 'uniswap%'
    AND NOT amount IS NULL
    UNION ALL
    SELECT
    block_timestamp AS block_time,
    tx_hash,
    'ethereum' AS network,
    token_in AS token_address,
    symbol_in AS symbol,
    CASE
    WHEN amount_in <= 1000000 THEN amount_in
    WHEN amount_out <= 1000000 THEN amount_out
    END AS amount, --Flipside data issue
    ORIGIN_FROM_ADDRESS AS trader
    FROM ethereum.defi.ez_dex_swaps
    WHERE platform ilike 'uniswap%'
    AND NOT amount IS NULL

    union all

    SELECT
    QueryRunArchived: QueryRun has been archived