chrisfdpast_24h_average_trade_size
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
AVG(AMOUNT_IN_USD) as average_trade_size
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