PapasotCurve daily users
    Updated 2022-05-01
    -- USDC-USDT univ3 & curve

    SELECT
    date_trunc('day',block_timestamp) as block_day,
    platform,
    count(DISTINCT(from_address)) as Users,
    SUM(amount_usd) as Volume

    FROM ethereum.dex_swaps
    WHERE

    block_day >= '2021-11-13' AND
    platform = 'curve' AND
    amount_usd < 1000000000
    GROUP BY block_day,platform
    ORDER BY block_day



    Run a query to Download Data