SELECT 'aUSD' AS Stablecoin

UNION SELECT 'YUSD'

UNION SELECT 'VEUR'

UNION SELECT 'VCHF'

UNION SELECT 'USX'

UNION SELECT 'USTC'

UNION SELECT 'USP'

UNION SELECT 'USDV'

UNION SELECT 'USDT'

UNION SELECT 'USDS'

UNION SELECT 'USDC'

UNION SELECT 'USD+'

UNION SELECT 'TUSD'

UNION SELECT 'RAI'

UNION SELECT 'NXUSD'

UNION SELECT 'NUSD'

UNION SELECT 'MONEY'

UNION SELECT 'MIM'

UNION SELECT 'LUSD'

UNION SELECT 'FRAX'

UNION SELECT 'DOLA'

UNION SELECT 'DAI'

UNION SELECT 'BUSD'

UNION SELECT 'BNUSD'

UNION SELECT 'AUSD'

UNION SELECT 'ARUSD'

),

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