SELECT

address

FROM

ethereum.core.dim_labels

WHERE

address_name ilike '%ftx%'

AND label_subtype = 'hot_wallet'

),

balance_tmp AS (

SELECT

contract_address,

symbol,

CASE

WHEN contract_address IN ('0xdac17f958d2ee523a2206206994597c13d831ec7','0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48','0x4fabb145d64652a948d72533023f6e7a623c7c53','0x6b175474e89094c44da98b954eedeac495271d0f','0x853d955acef822db058eb8505911ed77f175b99e','0x8e870d67f660d95d5be530380d0ec0bd388289e1',lower('0x0000000000085d4780B73119b644AE5ecd22b376'),'0x056fd409e1d7a124bd7017459dfea2f387b6d5cd',lower('0x0C10bF8FcB7Bf5412187A595ab97a3609160b5c6')) THEN 'Stablecoin'

-- usdt, usdc, buds, dai, frax, usdp, tusd, gusd, dusd

ELSE 'Other'

END AS token_type,

DATE_TRUNC('HOUR', last_activity_block_timestamp) AS hour,

current_bal

FROM

ethereum.core.ez_current_balances

WHERE

user_address IN (SELECT address FROM ftx)

),

aux_prices AS (

SELECT

MAX(hour) AS latest_today

FROM

ethereum.core.fact_hourly_token_prices

WHERE

hour::DATE = CURRENT_DATE-1

),

FINAL AS (

SELECT

b.contract_address,