SELECT DISTINCT SYMBOL AS Stablecoin

FROM external.defillama.fact_stablecoin_supply

),

ClassifiedPairs AS (

SELECT

SYMBOL_IN || ' / ' || SYMBOL_OUT AS Pair,

SUM(AMOUNT_IN_USD) AS volume,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS swappers,

COUNT(DISTINCT TX_HASH) AS swaps,

CASE

WHEN SYMBOL_IN IN (SELECT Stablecoin FROM Stablecoins) OR

SYMBOL_OUT IN (SELECT Stablecoin FROM Stablecoins)

THEN 'Stablecoin-Related'

ELSE 'non-stablecoins'

END AS Pair_Type

FROM avalanche.defi.ez_dex_swaps

WHERE AMOUNT_IN_USD IS NOT NULL

AND block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days'

GROUP BY

Pair, Pair_Type

Pair_Type,

COUNT(DISTINCT Pair) AS unique_pairs,

SUM(volume) AS total_volume,

SUM(swappers) AS total_swappers,

SUM(swaps) AS total_swaps

FROM ClassifiedPairs

GROUP BY Pair_Type

ORDER BY total_volume DESC;