select

date(block_timestamp) as date,

symbol as inflow_symbol,

sum(amount_usd) as total_inflow,

sum(total_inflow) over (order by date asc) as cumulative_inflow

from ethereum.core.ez_token_transfers

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

where (label LIKE '%alameda%'

OR label LIKE '%ftx%')

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

AND block_timestamp > CURRENT_DATE - 10

group by 1,2),

t2 as (

select

date(block_timestamp) as date_,

symbol as outflow_symbol,

sum(amount_usd)*-1 as total_outflow,

sum(total_outflow) over (order by date_ asc) as cumulative_outflow

from ethereum.core.ez_token_transfers

left outer join ethereum.core.dim_labels on address = from_address

where (label LIKE '%alameda%'

OR label LIKE '%ftx%')

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

AND block_timestamp > CURRENT_DATE - 10

group by 1,2)

date,inflow_symbol, total_inflow,cumulative_inflow, total_outflow , cumulative_outflow

from t1 s join t2 f on s.date = f.date_ and s.inflow_symbol = f.outflow_symbol