--Describe any correlations in activity between uniswap and sushiswap
--MONTHLY ANALYSIS
SELECT
date_trunc('Month', block_timestamp) "Date", platform, count(tx_hash) "Number of Transactions", count(distinct tx_hash) "Number of Unique Transactions",
count(DISTINCT origin_from_address) "Number of Unique Users", Sum(abs(amount_in_usd) + abs(amount_out_usd))/2 "Volume of transactions"
FROM ethereum.core.ez_dex_swaps
Where "Date" Between '2020-01-01' AND '2022-12-01' AND PLATFORM IN('uniswap-v2', 'uniswap-v3', 'sushiswap')
GROUP BY 1, 2