date_trunc('month', block_timestamp) as DAY,

CASE WHEN mint LIKE 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'

WHEN mint LIKE 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'

WHEN mint LIKE '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST'

WHEN mint LIKE '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'USDX'

WHEN mint LIKE 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'

WHEN mint LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC' END as ASSET,

sum(amount) as SWAP_VOLUME

FROM solana.core.fact_transfers

where NOT (ASSET is NULL)

AND BLOCK_TIMESTAMP > '2022-01-01'

GROUP BY 1,2

ORDER BY 2,1