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

date_trunc('hour', block_timestamp) as hour,

label,

sum (amount_usd) as amount_usd_outflow,

count(distinct(tx_hash)) as txn_num_outflow,

row_number() over (partition by hour order by amount_usd_outflow desc) as rank

from ethereum.core.ez_token_transfers a

join ethereum.core.dim_labels b on b.address = a.to_address

where exists (select * from ftx_addresses where from_address = ftx_address)

and not exists (select * from ftx_addresses where to_address = ftx_address)

and symbol is not null

and block_timestamp::date >= '2022-11-06'

group by 1, 2

qualify rank <= 10

select * from outflow

order by hour, amount_usd_outflow desc