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