par_rnpangolin 02
Updated 2024-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
POOL_NAME,
COUNT (DISTINCT TX_HASH) AS Swaps,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Swappers,
SUM(coalesce(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS USD_volume,
FROM
avalanche.defi.ez_dex_swaps
WHERE
PLATFORM = 'pangolin'
AND BLOCK_TIMESTAMP :: date >= current_date -30
GROUP BY
1
having
USD_volume > 0
ORDER BY
4 DESC
LIMIT
10
QueryRunArchived: QueryRun has been archived