chrisfdDEX_past_24h_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
›
⌄
-- forked from dex__monthly_volume @ https://flipsidecrypto.xyz/edit/queries/69a5a6a0-20bf-4e29-a712-33de76ee984f
--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
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('hour', -24, current_timestamp(9)::timestamp_ntz)
and AMOUNT_IN_USD > 0
Run a query to Download Data