median (balance/1e18) as "ETH_ftx"

from ethereum.core.fact_eth_balances

where user_address in ('0x59abf3837fa962d6853b4cc0a19513aa031fd32b','0x866eeecd1f248d1a0a2e0263f13594a6b8b7c01a')

group by 1),

min2 as (select hour::date as date,

avg (price) as "Price" from ethereum.core.fact_hourly_token_prices

where symbol in ('WETH')

and hour >= '2022-10-25' group by 1)

select a.date, "ETH_ftx","Price"

from min1 a join min2 b on a.date = b.date