boomer77monthly v2 vs v3
Updated 2021-08-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with v2 as
(SELECT
date_trunc('month',block_timestamp) as month,
sum(amount_usd) as IN_V2,
direction,
platform
from ethereum.dex_swaps
where amount_usd < 20000000 and platform = 'uniswap-v2' and direction = 'IN'
group by 1,3,4),
v3 as
(SELECT
date_trunc('month',block_timestamp) as month,
sum(amount_usd) as IN_V3,
direction,
platform
from ethereum.dex_swaps
where amount_usd < 20000000 and platform = 'uniswap-v3' and direction = 'IN'
group by 1,3,4)
select A.month, A.IN_V2, B.IN_V3
from v2 A
join v3 B on A.month = B.month
order by 1 desc
Run a query to Download Data