chrisfddex_historical_monthly_volume
Updated 2023-10-19
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
--Platform considered in the DEX volume computation
WITH dex_list(dex) as (
select * from (
values
('uniswap-v2'),
('uniswap-v3'),
('curve'),
('maverick'),
('sushiswap'),
('dodo-v1'),
('dodo-v2'),
('pancakeswap-v2'),
('pancakeswap-v3')
-- ('balancer')
))
select
date_trunc('month',BLOCK_TIMESTAMP) as time,
PLATFORM as dex,
--AMOUNT_IN,
--SYMBOL_IN,
SUM(AMOUNT_IN_USD) as volume
from ethereum.defi.ez_dex_swaps
where exists (select 1 from dex_list where dex_list.dex = ethereum.defi.ez_dex_swaps.platform)
and BLOCK_TIMESTAMP > dateadd('month', -6, current_timestamp(9)::timestamp_ntz)
and AMOUNT_IN_USD > 0
group by 1,2
order by 1 desc
Run a query to Download Data