Weekday traded Vol

feyikemiWeekday traded Vol

Updated 2025-03-25

--Weekday analysis learned from Ali3n https://flipsidecrypto.xyz/Ali3N/dashboards

SELECT

DAYNAME(TO_DATE(block_timestamp::date)) AS Weekday,

COUNT(DISTINCT tx_hash) AS Total_Trades,

COUNT(DISTINCT swapper) AS Total_Traders,

SUM(COALESCE(amount_in_usd, amount_out_usd)) AS Total_Traded_Volume

FROM aptos.defi.ez_dex_swaps

WHERE block_timestamp::DATE >= '{{Start_Date}}'

AND amount_in_usd < 1e6

AND amount_out_usd < 1e6

GROUP BY 1

ORDER BY Total_Traded_Volume DESC

Last run: about 2 months ago

	WEEKDAY	TOTAL_TRADES	TOTAL_TRADERS	TOTAL_TRADED_VOLUME
1	Tue	4088185	418032	1450685142.26469
2	Mon	4076451	368974	1441254553.80005
3	Fri	3603062	341659	1365210613.24696
4	Wed	3832999	363557	1351228564.36458
5	Thu	3730958	417072	1334472179.1722
6	Sun	3320263	343287	1127315498.26365
7	Sat	3184419	317611	1116390368.83169

280B

17s