par_rnpangolin 05
Updated 2024-12-06
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
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
HAVING
USD_volume > 0
QueryRunArchived: QueryRun has been archived