feyikemispecific-green
Updated 2025-01-23
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
Platform,
COUNT(DISTINCT TX_HASH) AS Total_Trades,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Total_Traders,
SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS Total_Traded_Volume
FROM
avalanche.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP :: Date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'
GROUP BY 1
ORDER BY 3 DESC
Limit 10
QueryRunArchived: QueryRun has been archived