with Tia_price as (

select hour::date date ,

'TIA' symbol ,

'9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8' address ,

median (PRICE) as price

from crosschain.price.ez_prices_hourly

where blockchain = 'cosmos'

and token_address = 'ibc/D79E7D83AB399BFFF93433E54FAA480C191248FC556924A2A8351AE2638B3877'

and hour::date > '2024-08-01'

group by 1,2,3

union

select hour::date date ,

'stTIA' symbol ,

'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM' address ,

median (PRICE) as price

from crosschain.price.ez_prices_hourly

where blockchain = 'cosmos'

and token_address = 'ibc/698350B8A61D575025F3ED13E9AC9C0F45C89DEFE92F76D5838F1D3C1A7FF7C9'

and hour::date > '2024-08-01'

group by 1,2,3

),

ETH_price as (

select

HOUR::date date ,

'ETH' symbol,

'So11111111111111111111111111111111111111112' ADDRESS ,

median (price) as price

from crosschain.price.ez_prices_hourly