select 'USDC' as symbol, 18 as decimals

union all

select 'USDT' as symbol, 18 as decimals

union all

select 'CAKE' as symbol, 18 as decimals

union all

select 'AXLUSDC' as symbol, 6 as decimals

union all

select 'WETH' as symbol, 18 as decimals

union all

select 'BUSD' as symbol, 18 as decimals

union all

select 'WBNB' as symbol, 18 as decimals

union all

select 'DOT' as symbol, 18 as decimals

),

prices as (

select

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,

id as symbol,

avg(close) as price_usd

from

crosschain.core.fact_hourly_prices

where