chrisfdpast_24h DEX_volume
Updated 2023-12-11
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
›
⌄
-- forked from DEX_volume @ https://flipsidecrypto.xyz/edit/queries/00663fa1-ee50-4afb-8b57-f3686e0342f9
-- Query DEX Volume
WITH dex_slugs(dex) as (
select * from
values
('uniswap v3'),
('uniswap v1'),
('uniswap v2'),
('curve'),
('maverick protocol'),
('sushiswap'),
('dodo'),
('pancakeswap amm'),
('balancer v2'),
('balancer v1')
)
--Only five protocols available as per
select *
--DISTINCT(chain)
--DISTINCT(protocol)
from external.defillama.fact_dex_volume
where exists (select 1 from dex_slugs where dex_slugs.dex = external.defillama.fact_dex_volume.protocol)
and date > dateadd('day', -2, current_date())
and chain = 'ethereum'
order by 1 asc
LIMIT 9
Run a query to Download Data