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

platform,

usdt_volume,

total_volume,

ROUND((usdt_volume / NULLIF(total_volume, 0)) * 100, 2) AS token_contribution_percentage

platform_volumes

ORDER BY

token_contribution_percentage DESC;