select *

from solana.core.dim_labels

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

Inflow as(select

avg(swap_to_amount/swap_from_amount) as price,

sum(amount*price) as "Inflow volume(USD)"

from solana.core.fact_transfers a join solana.fact_swaps b on a.block_timestamp::date = b.block_timestamp::date and a.mint = b.swap_from_mint

where tx_to in (select distinct address from ftx)

and a.block_timestamp >= CURRENT_DATE - 28

and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

and swap_to_amount > 0

and swap_from_amount > 0

and succeeded = 'TRUE'

group by 1

), Outflow as(select

avg(swap_to_amount/swap_from_amount) as price,

sum(amount*price)*(-1) as "Outflow volume(USD)"

from solana.core.fact_transfers a join solana.fact_swaps b on a.block_timestamp::date = b.block_timestamp::date and a.mint = b.swap_from_mint

where tx_from in (select distinct address from ftx)

and a.block_timestamp >= CURRENT_DATE - 28

and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

and swap_to_amount > 0

and swap_from_amount > 0

and succeeded = 'TRUE'

group by 1)

"Inflow volume(USD)",

"Outflow volume(USD)",

"Inflow volume(USD)" - "Outflow volume(USD)" as "Netflow volume(USD)"

from Inflow,Outflow