par_rnTop 5 swapped from token per Platform ( Transactions )
Updated 2022-11-26
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
›
⌄
with platforms as ( select PLATFORM , symbol_in , count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_swapper,
sum(amount_in_usd) as volume, avg(amount_in_usd) as avg_volume
from ethereum.core.ez_dex_swaps
where block_timestamp::date >= '2022-01-01'
and amount_in_usd < 1000000
group by 1,2)
,
uni_3 as ( select PLATFORM , symbol_in , total_tx
from platforms
where PLATFORM = 'uniswap-v3'
and symbol_in is not null and total_tx is not null
order by 3 desc
limit 5 )
,
uni_2 as ( select PLATFORM , symbol_in , total_tx
from platforms
where PLATFORM = 'uniswap-v2'
and symbol_in is not null and total_tx is not null
order by 3 desc
limit 5 )
,
sushi as ( select PLATFORM , symbol_in , total_tx
from platforms
where PLATFORM = 'sushiswap'
and symbol_in is not null and total_tx is not null
order by 3 desc
limit 5 )
,
curve as ( select PLATFORM , symbol_in , total_tx
from platforms
where PLATFORM = 'curve'
and symbol_in is not null and total_tx is not null
order by 3 desc
limit 5 )
,
balancer as ( select PLATFORM , symbol_in , total_tx
Run a query to Download Data