faralpatop 3 swaps platforms
Updated 2023-04-13
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
›
⌄
with top3_dexs as (
SELECT
distinct platform,
count(distinct tx_hash) as tx_count,
count(distinct ORIGIN_FROM_ADDRESS) as active_wallets
from
ethereum.core.ez_dex_swaps
where
date(block_timestamp) between current_date()-91 and current_date()-1
group by platform
order by active_wallets DESC
limit 3
)
SELECT
date(block_timestamp) as date,
count(distinct tx_hash) as tx_count,
count(distinct ORIGIN_FROM_ADDRESS) as active_wallets,
platform
from
ethereum.core.ez_dex_swaps
where
date(block_timestamp) between current_date()-91 and current_date()-1
and platform in (select distinct platform from top3_dexs)
group by date,platform
Run a query to Download Data