par_rn dragonswap 05
Updated 2024-12-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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,
AVG(coalesce(amount_in_usd, amount_out_usd)) AS AVG_USD_volume,
MEDIAN(coalesce(amount_in_usd, amount_out_usd)) AS MEDIAN_USD_volume,
MAX(coalesce(amount_in_usd, amount_out_usd)) AS MAX_USD_volume
FROM
kaia.defi.ez_dex_swaps
WHERE
platform = 'dragonswap-v3'
AND BLOCK_TIMESTAMP :: date >= current_date -30
having
USD_volume > 0
QueryRunArchived: QueryRun has been archived