select *

from ethereum.core.dim_labels

where label ilike '%ftx%' or address_name ilike '%ftx%'

),

Eth_to_FTX as (

select

block_timestamp::date as Inflow_Date,

symbol as Symbol_IN,

sum (amount_usd) as Inflow_Volume

from ethereum.core.ez_token_transfers

where to_address in (select distinct address from ftxtable)

and from_address not in (select distinct address from ftxtable)

and block_timestamp::date BETWEEN '2022-11-05' and '2022-11-18'

group by 1,2

union ALL

select

block_timestamp::date as Inflow_Date,

'ETH' as symbol_in,

sum (amount_usd) as Inflow_Volume

from ethereum.core.ez_eth_transfers

where eth_to_address in (select distinct address from ftxtable)

and eth_from_address not in (select distinct address from ftxtable)

and block_timestamp::date BETWEEN '2022-11-05' and '2022-11-18'

group by 1,2

),

FTX_to_Eth as (

select

block_timestamp::date as Outflow_Date,

symbol as Symbol_Out,

sum(amount_usd) as Outflow_Volume

from ethereum.core.ez_token_transfers

where from_address in (select distinct address from ftxtable)