Tobi_1tricky-amber
Updated 2024-08-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
31
32
33
34
›
⌄
WITH swap_volume AS (
SELECT
FROM_ADDRESS AS address,
SUM(AMOUNT) AS total_volume
FROM
aptos.core.ez_native_transfers
WHERE
TOKEN_ADDRESS = '0x1::aptos_coin::AptosCoin'
AND SUCCESS = TRUE
GROUP BY
FROM_ADDRESS
UNION ALL
SELECT
TO_ADDRESS AS address,
SUM(AMOUNT) AS total_volume
FROM
aptos.core.ez_native_transfers
WHERE
TOKEN_ADDRESS = '0x1::aptos_coin::AptosCoin'
AND SUCCESS = TRUE
GROUP BY
TO_ADDRESS
)
SELECT
address,
SUM(total_volume) AS total_transaction_volume
FROM
swap_volume
GROUP BY
address
ORDER BY
total_transaction_volume DESC
LIMIT 10;
QueryRunArchived: QueryRun has been archived