StangFAST02 - new users' activity token in
    Updated 2023-08-03
    -- forked from 02 - new users' activity @ https://flipsidecrypto.xyz/edit/queries/a21e20ca-cd8b-4d04-b52e-6ea02f087ce3

    -- forked from 01 - new users monthly @ https://flipsidecrypto.xyz/edit/queries/8ceba136-b558-46d8-8598-abf79e95ffab

    with

    new_users AS
    (
    SELECT
    min( a.block_timestamp ) AS min_date
    , a.origin_from_address AS new_users
    FROM
    ethereum.core.ez_dex_swaps a
    WHERE
    a.platform LIKE 'uniswap%'
    GROUP BY 2
    ORDER BY 1 DESC
    )
    ,
    top_tokens AS
    (
    SELECT
    a.symbol_in AS "token"
    , sum( a.amount_in_usd ) AS "usd volume"
    FROM
    ethereum.core.ez_dex_swaps a
    INNER JOIN
    new_users b
    ON a.origin_from_address = b.new_users
    WHERE
    a.platform LIKE 'uniswap%'
    AND a.block_timestamp::date > '2023-01-01'
    AND a.amount_in_usd IS NOT NULL
    GROUP BY 1
    ORDER BY 2 DESC LIMIT 100
    )
    Run a query to Download Data