Swappers Depenencies Ratio

datavortexSwappers Depenencies Ratio

Updated 2025-05-12

WITH swapper_counts AS (

SELECT

platform,

COUNT(DISTINCT swapper) AS total_swappers,

COUNT(DISTINCT CASE WHEN symbol_in = 'USDT' OR symbol_out = 'USDT' THEN swapper END) AS usdt_swappers

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

GROUP BY

platform

)

SELECT

platform,

total_swappers,

usdt_swappers,

ROUND((usdt_swappers / NULLIF(total_swappers, 0)) * 100, 2) AS swapper_dependency_ratio

FROM

swapper_counts

ORDER BY

swapper_dependency_ratio DESC;

Last run: 13 days ago

	PLATFORM	TOTAL_SWAPPERS	USDT_SWAPPERS	SWAPPER_DEPENDENCY_RATIO
1	cetus	180	153	85
2	hippo	60266	27480	45.6
3	liquidswap	827902	283081	34.19
4	pancake	380652	123826	32.53
5	animeswap	46833	14018	29.93
6	sushi	80807	24049	29.76
7	auxexchange	69094	14919	21.59
8	thala	464640	90391	19.45
9	cellana	531078	68887	12.97
10	batswap	19675	1291	6.56

298B

flipside