PapasotUniswapv2 swaps (USD amount)
    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)/2 as Daily_volume
    FROM ethereum.dex_swaps
    WHERE
    platform = 'uniswap-v3' AND
    amount_usd < 10000000000
    GROUP BY block_day
    ORDER BY block_day
    Run a query to Download Data