PapasotUniswapv3 USDC-USDT swaps (USD volume)
    Updated 2022-11-28
    -- USDC-USDT univ3 & curve

    SELECT
    date_trunc('day',block_timestamp) as block_day,
    platform,
    SUM(amount_usd) as Volume,
    count(DISTINCT(to_address)) as Users
    FROM ethereum.dex_swaps
    WHERE
    pool_name like 'USDC-USDT%' AND
    block_day >= '2021-11-13' AND
    platform = 'uniswap-v3'
    GROUP BY block_day,platform
    ORDER BY block_day



    Run a query to Download Data