SELECT

DISTINCT address

FROM

ethereum.core.fact_token_transfers

LEFT outer join ethereum.core.dim_labels on address = to_address

WHERE

label ilike '%alameda%'

OR label ilike 'ftx'

),

Flow_IN as (

SELECT

symbol as Symbol_IN,

sum(amount_usd) as "Inflow Volume"

FROM

ethereum.core.ez_token_transfers

WHERE

to_address IN (

SELECT

*

FROM

ALAMEDA_FTX_Addresses

)

AND symbol in ('USDT', 'USDC', 'DAI', 'TUSD', 'BUSD')

AND block_timestamp BETWEEN '2022-11-02' and '2022-11-09'

GROUP BY

1

),

Flow_OUT as (

SELECT

symbol as Symbol_OUT,

sum(amount_usd) as "Outflow Volume"

FROM

ethereum.core.ez_token_transfers

WHERE

from_address IN (