select date_trunc('week', block_timestamp) as week,
case
when swap_to_mint = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'
when swap_to_mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'
else address_name end as name,
address_name,
sum(swap_to_amount) as swap_to_volume
from solana.core.fact_swaps a
left join solana.core.dim_labels b on a.swap_to_mint = b.address
where swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', --USDC
'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', --USDT
'7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT', --UXD
'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX', --USDH
'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS') --PAI
and succeeded = 'TRUE'
group by 1,2,3
order by 1