drone-mostafatop user copy
Updated 2023-05-05
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
›
⌄
with
tops as (SELECT
ORIGIN_FROM_ADDRESS,
sum (AMOUNT_IN_USD) as USD
FROM avalanche.core.ez_dex_swaps
WHERE AMOUNT_IN_USD > 0
GROUP BY 1 ORDER by USD DESC LIMIT 10)
SELECT
ORIGIN_FROM_ADDRESS as User,
sum (AMOUNT_IN_USD) as USD
FROM avalanche.core.ez_dex_swaps
WHERE AMOUNT_IN_USD > 0
AND
ORIGIN_FROM_ADDRESS in (SELECT ORIGIN_FROM_ADDRESS FROM tops)
GROUP BY 1
Run a query to Download Data