with price as ( SELECT HOUR::date as date1, avg(close) as pr,case

when ASSET_ID = 'binance-usd' then 'BUSD'

when ASSET_ID = 'chain4energy' then 'C4E'

when ASSET_ID = 'axelar' then 'AXL'

when ASSET_ID = 'deus-finance-2' then 'DEUS'

when ASSET_ID = 'ethos-reserve-note' then 'BUSD'

when ASSET_ID = 'chain4energy' then 'ERN'

when ASSET_ID = 'ethereum' then 'ETH'

when ASSET_ID = 'frax' then 'FRAX'

when ASSET_ID = 'chihuahua-token' then 'HUAHUA'

when ASSET_ID = 'kujira' then 'KUJI'

when ASSET_ID = 'liquiddriver' then 'Lqdr'

when ASSET_ID = 'maker' then 'MKR'

when ASSET_ID = 'pepe' then 'PEPE'

when ASSET_ID = 'shiba-inu' then 'SHIB'

when ASSET_ID = 'stargaze' then 'STARS'

when ASSET_ID = 'celestia' then 'TIA'

when ASSET_ID = 'teritori' then 'TORI'

when ASSET_ID = 'uniswap' then 'UNI'

when ASSET_ID = 'wrapped-bitcoin' then 'WBTC'

when ASSET_ID = 'mimatic' then 'MAI'

when ASSET_ID = 'wrapped-steth' then 'wstETH'

when ASSET_ID = 'yieldeth-sommelier' then 'YieldETH'

when ASSET_ID = 'usd-coin' then 'USDC'

when ASSET_ID = 'tether' then 'USDT'

when ASSET_ID = 'milkyway-staked-tia' then 'milkTIA'

end as SYMBOL

from crosschain.price.fact_prices_ohlc_hourly

where

HOUR::date >= current_date - 365

and ASSET_ID in ('binance-usd'