feyikemiDEXs Summary
Updated 2025-01-23
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
›
⌄
WITH Tb1 AS (
SELECT
Platform,
COUNT(DISTINCT Tx_hash) AS Trades,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Traders,
SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD) / 2) AS Volume,
COUNT(DISTINCT block_timestamp::date) AS Total_Days
FROM
avalanche.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP :: Date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'
GROUP BY 1
)
-- Credit to Jonaso on the values style format https://flipsidecrypto.xyz/Jonaso/q/hAh4kjuMH-5P/volume-8
SELECT
INITCAP(Platform) AS DEXs,
TO_VARCHAR(Volume, '$999,999,999,999,999') AS Total_Volume,
TO_VARCHAR(Trades, '999,999,999') AS Total_Trades,
TO_VARCHAR(Traders, '999,999,999') AS Total_Traders,
TO_VARCHAR(Volume / Total_Days, '$999,999,999,999,999') AS Daily_Avg_Volume,
TO_VARCHAR(Traders / Total_Days, '999,999') AS Daily_Avg_Traders,
TO_VARCHAR(ROUND(Trades / Traders), '999,999') AS Avg_Trades_Per_Trader
FROM Tb1
ORDER BY 2 DESC
QueryRunArchived: QueryRun has been archived