averages | datavortex

Updated 2025-04-18

WITH date_range AS (

SELECT

DATEDIFF('day', '{{start_date}}', '{{end_date}}') AS num_days

)

SELECT symbol_in,

COUNT(DISTINCT tx_hash) AS total_transactions,

COUNT(DISTINCT origin_from_address) AS total_swappers,

SUM(amount_in_usd) AS volume_swapped,

ROUND(COUNT(DISTINCT tx_hash) / (SELECT num_days FROM date_range), 2) AS avg_swaps_per_day,

ROUND(COUNT(DISTINCT origin_from_address) / (SELECT num_days FROM date_range), 2) AS avg_swapper_per_day,

ROUND(SUM(amount_in_usd) / (SELECT num_days FROM date_range), 2) AS avg_volume_per_day

FROM polygon.defi.ez_dex_swaps

WHERE symbol_in IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')

AND block_timestamp >= '{{start_date}}'

AND block_timestamp < '{{end_date}}'

GROUP BY symbol_in;

Last run: about 1 month ago

	SYMBOL_IN	TOTAL_TRANSACTIONS	TOTAL_SWAPPERS	VOLUME_SWAPPED	AVG_SWAPS_PER_DAY	AVG_SWAPPER_PER_DAY	AVG_VOLUME_PER_DAY
1	BUSD	797	369	8599.41	26.57	12.3	286.65
2	UST	2073	433	14237.76	69.1	14.43	474.59
3	DAI	329519	55282	112783006.93	10983.97	1842.73	3759433.56
4	TUSD	187	116	1791.3	6.23	3.87	59.71
5	USDC	1511818	118924	1438670018.09	50393.93	3964.13	47955667.27
6	USDT	987815	125772	364628574.08	32927.17	4192.4	12154285.8
7	EURS	1023	290	649351.08	34.1	9.67	21645.04

367B

flipside