-- 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