PapasotUniswapv3 swaps (USD volume)
    Updated 2022-11-28
    -- The price of UNI has been trending downwards since the start of 2022.

    -- How is UNI price correlated with trading volume? Does this have an effect on the number of liquidity providers?

    SELECT
    date_trunc('day',block_timestamp) as block_day,
    SUM(amount_usd)
    FROM ethereum.dex_swaps
    WHERE
    platform = 'uniswap-v3' AND
    block_day > '2021-12-01' AND
    block_day <> '2022-01-04'
    GROUP BY block_day
    ORDER BY block_day



    Run a query to Download Data