SELECT

date_trunc('day', block_timestamp) as date_IN,

CASE

when mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'

when mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'

when mint = 'EYpdBuyAHSbdaAyD1sKkxyLWbAP8uUW9h6uvdhK74ij1' then 'DAI'

when mint = '6nuaX3ogrr2CaoAPjtaKHAoBNWok32BMcRozuf32s2QF' then 'BUSD'

when mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'

when mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'

when mint = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'

when mint = '9iLH8T7zoWhY7sBmj1WK9ENbWdS1nL8n9wAxaeRitTa6' then 'USH'

END as Symbol_IN,

sum(amount) as "Inflow Volume"

FROM

solana.core.fact_transfers

LEFT outer JOIN solana.core.dim_labels ON TX_TO = address

WHERE

(

address_name ilike '%ftx%'

OR address_name ilike '%alameda%'

)

AND block_timestamp BETWEEN '2022-10-26' and '2022-11-02'

AND mint in (

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'EYpdBuyAHSbdaAyD1sKkxyLWbAP8uUW9h6uvdhK74ij1',

'6nuaX3ogrr2CaoAPjtaKHAoBNWok32BMcRozuf32s2QF',

'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX',

'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS',

'7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT',

'9iLH8T7zoWhY7sBmj1WK9ENbWdS1nL8n9wAxaeRitTa6'

)

GROUP BY

1,

2