SELECT

SYMBOL_IN AS Stablecoins,

SUM(DISTINCT AMOUNT_IN_USD) AS total_volume_usd,

count (DISTINCT tx_hash) as transactions_traded,

count (DISTINCT origin_from_address) as Number_Of_Traders,

AVG(DISTINCT AMOUNT_IN_USD) as Average_volume

FROM

polygon.defi.ez_dex_swaps

WHERE

block_timestamp >= '2024-01-01'

and AMOUNT_IN_USD is not NULL

and

SYMBOL_IN IN ('USDT', 'USDC', 'DAI', 'BUSD', 'TUSD', 'UST', 'USDD', 'USDA')

GROUP BY

SYMBOL_IN

ORDER BY

total_volume_usd DESC