with alamedaftx as ( select *
from ethereum.core.dim_labels
where label ilike '%binance%' or address_name ilike '%binance%')
select symbol, sum (amount_usd) as Inflow_Volume
from ethereum.core.ez_token_transfers
where to_address in (select distinct address from alamedaftx)
and From_Address not in (select distinct address from alamedaftx)
and block_timestamp >= '2022-11-01'
and amount_usd > 0
group by 1
order by 2 DESC
limit 10