recorded_hour::date as date,

lower(

CASE id

WHEN 'tether' THEN 'usdt'

WHEN 'usd-coin' THEN 'usdc'

WHEN 'the-sandbox' THEN 'sand'

WHEN 'pangolin' THEN 'png'

WHEN 'yield-yak' THEN 'yak'

WHEN 'wrapped-avax' THEN 'wavax'

ELSE id

END

) as symbol,

avg(close) as price_usd

from

crosschain.core.fact_hourly_prices

where symbol = 'uion'