platform dependency

datavortexplatform dependency

Updated 8 days ago

WITH platform_volumes AS (

SELECT

platform,

SUM(amount_in_usd) AS total_volume,

SUM(CASE

WHEN token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'

OR token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'

THEN amount_in_usd ELSE 0

END) AS usdt_volume

FROM

aptos.defi.ez_dex_swaps

WHERE

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

GROUP BY

platform

)

SELECT

platform,

usdt_volume,

total_volume,

ROUND((usdt_volume / NULLIF(total_volume, 0)), 3) AS volume_dependency_ratio

FROM

platform_volumes

ORDER BY

volume_dependency_ratio DESC;

Last run: 8 days ago

	PLATFORM	USDT_VOLUME	TOTAL_VOLUME	VOLUME_DEPENDENCY_RATIO
1	sushi	169695151.488943	403210981.839	0.421
2	liquidswap	463504651.528411	2053115681.29188	0.226
3	cetus	247795.827774356	1493609.71474922	0.166
4	hippo	15838713.8137344	148732259.692206	0.106
5	animeswap	52173.899783858	683015.343248988	0.076
6	thala	101654785.32932	2682439239.57746	0.038
7	pancake	23280439.6648447	786760768.382343	0.03
8	auxexchange	11640.813449322	2176393.54399338	0.005
9	batswap	18453.481122983	6277566.62112765	0.003
10	cellana	117657203.256484	1396751576106.8	0

509B

flipside