adambalamost swap vlm
Updated 2021-12-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select x.title,x.date time0,SUM(x.vlm)vlm from (
SELECT
'sushi' title,
date_trunc('month',block_timestamp) as date ,
sum(amount_usd) as vlm
from ethereum.dex_swaps
where token_address = '0xff56cc6b1e6ded347aa0b7676c85ab0b3d08b0fa' and platform = 'sushiswap'
and block_timestamp::date > current_date-365
group by date
UNION ALL
SELECT
'uniswap_v2' title,
date_trunc('month',block_timestamp) as date ,
sum(amount_usd) as vlm
from ethereum.dex_swaps
where token_address = '0xff56cc6b1e6ded347aa0b7676c85ab0b3d08b0fa' and platform = 'uniswap-v2'
and block_timestamp::date > current_date-365
group by date
)x
group by x.title,time0
Run a query to Download Data