binhachon2. Monthly Swap Volume - Both
Updated 2021-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with dexswap as (
select distinct tx_id, block_timestamp, amount_usd, platform from ethereum.dex_swaps
where amount_usd < 100000000000
)
select date_trunc('month', block_timestamp) as blocktime, sum(amount_usd) as volume, 'Uniswap' as symbol from dexswap
where platform in ('uniswap-v2', 'uniswap-v3')
group by blocktime, symbol
union all
select date_trunc('month', block_timestamp) as blocktime, sum(amount_usd) as volume, 'Sushiswap' as symbol from dexswap
where platform = 'sushiswap'
group by blocktime, symbol
Run a query to Download Data