Specterplatform swapper
Updated 2025-02-25Copy Reference Fork
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
›
⌄
WITH savax_swaps AS (
SELECT
Block_timestamp,
tx_hash,
sender,
platform,
amount_in_usd,
amount_out_usd
FROM avalanche.defi.ez_dex_swaps
WHERE (symbol_in = 'sAVAX' OR symbol_out = 'sAVAX')
)
SELECT
platform,
COUNT(DISTINCT sender) AS swapper,
FROM savax_swaps
GROUP BY platform
ORDER BY swapper DESC;
LIMIT 10;
QueryRunArchived: QueryRun has been archived