with alamedaftx as (

select *

from solana.core.dim_labels

where label like '%alameda%' or label like 'ftx%' or address_name ilike '%alameda%' or address_name ilike 'ftx%'),

Inflowt as (

select case when mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'

when mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'

when mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'

when mint = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'

when mint = 'EnuaX3ogrr2CaoAPjtaKHAoBNWok32BMcRozuf32s2QF' then 'BUSD'

when mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'

when mint = '9iLH8T7zoWhY7sBmj1WK9ENbWdS1nL8n9wAxaeRitTa6' then 'USH'

when mint = 'EYpdBuyAHSbdaAyD1sKkxyLWbAP8uUW9h6uvdhK74ij1' then 'DAI'

else null end as Symbol_IN,

sum (amount) as Inflow_Volume

from solana.core.fact_transfers

where tx_to in (select distinct address from alamedaftx)

and tx_from not in (select distinct address from alamedaftx)

and Symbol_IN is not null

and block_timestamp > CURRENT_DATE - 30

group by 1),

Outflowt as (

select case when mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'

when mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'

when mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'

when mint = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'

when mint = 'EnuaX3ogrr2CaoAPjtaKHAoBNWok32BMcRozuf32s2QF' then 'BUSD'

when mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'

when mint = '9iLH8T7zoWhY7sBmj1WK9ENbWdS1nL8n9wAxaeRitTa6' then 'USH'

when mint = 'EYpdBuyAHSbdaAyD1sKkxyLWbAP8uUW9h6uvdhK74ij1' then 'DAI'

else null end as Symbol_Out,

sum (amount) as Outflow_Volume

from solana.core.fact_transfers