swaps 3 | aureasarsanedes

Updated 2 hours ago

SELECT

PLATFORM,

SUM(AMOUNT_IN_USD) AS total_volume_usd,

COUNT(*) AS total_swaps,

COUNT(distinct swapper) as distinct_swappers

FROM

aptos.defi.ez_dex_swaps

WHERE

BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)

GROUP BY

PLATFORM

ORDER BY

total_volume_usd DESC

Last run: about 2 hours ago

	PLATFORM	TOTAL_VOLUME_USD	TOTAL_SWAPS	DISTINCT_SWAPPERS
1	cellana	23965955.4796418	1140812	6988
2	liquidswap	10304227.8969915	165513	8425
3	pancake	5680718.98203766	87195	5626
4	sushi	5362406.02582142	25420	2371
5	thala	4487791.76631046	49834	2835
6	cetus	15836.108836158	26089	44
7	hippo	8455.190423177	994	4
8	auxexchange	7627.798769957	2696	249
9	animeswap	5995.142882766	23821	1122
10	batswap	1802.297435846	366	29

383B

flipside