select

address

from ethereum.core.dim_labels

where label ilike '%ftx%' or address_name ilike '%ftx%'

),

Price as (

select

recorded_at::date as date,

symbol,

avg(price) as avg_price

from osmosis.core.dim_prices

WHERE recorded_at >= CURRENT_DATE - 17

group by 1,2

),

Outflow as (

select

block_timestamp,

TX_HASH,

ORIGIN_FROM_ADDRESS,

to_address,

symbol,

amount_usd

from ethereum.core.ez_token_transfers

where from_address in (select distinct address from FTX_address)

and to_address not in (select distinct address from FTX_address)

and block_timestamp >= CURRENT_DATE - 17

and block_timestamp < CURRENT_DATE

union ALL

select

block_timestamp,

TX_HASH,

ORIGIN_FROM_ADDRESS,

eth_to_address as to_address,

'ETH' as symbol,

amount_usd