PapasotUniswapv3 LPs
    Updated 2022-03-31
    -- 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',creation_time) as block_day,
    COUNT(creation_tx)
    FROM ethereum.dex_liquidity_pools
    WHERE
    platform = 'uniswap-v3' AND
    block_day > '2021-11-01'
    GROUP BY block_day
    ORDER BY block_day
    Run a query to Download Data