with ftx_labels as (
select label, address
from ethereum.core.dim_labels
where (
label like any ('ftx%') or
address_name like any ('ftx%')
)
),
ftx_addresses as (
select distinct(address) as ftx_address from ftx_labels
),
outflow as (
select
symbol,
count(distinct(tx_hash)) as txn_num_outflow,
sum (amount_usd) as amount_usd_outflow
from ethereum.core.ez_token_transfers
where exists (select * from ftx_addresses where from_address = ftx_address)
and not exists (select * from ftx_addresses where to_address = ftx_address)
and amount_usd > 0
and block_timestamp >= '2022-11-06'
group by 1
)
select * from outflow
order by amount_usd_outflow desc
limit 10