PapasotCurve DAI-USDC swaps
    Updated 2022-11-28
    -- 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
    pool_name like '%USDC%' AND
    pool_name like '%DAI%' AND
    block_day >= '2021-11-13' AND
    platform = 'curve'
    GROUP BY block_day,platform
    ORDER BY block_day



    Run a query to Download Data