with price_table as (

select

date(recorded_at) as date,

lower (symbol) as symbol,

avg (price) as daily_price

from osmosis.core.dim_prices

group by 1,2),

from_axelar as (select

date(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP,

case currency

when 'aevmos' then 'evmos'

when 'afet' then 'fet'

when 'dai-wei' then 'axldai'

when 'dot-planck' then 'xcdot' --no exist

when 'eeur' then 'eeur'

when 'inj' then 'inj'

when 'uatom' then 'atom'

when 'uaxl' then 'axl'

when 'wbtc-satoshi' then 'axlwbtc'

when 'usdt' then 'sdt' --no exist

when 'wei' then 'wei' --no exist

when 'mkr-wei' then 'axlmkr' --no exist

when 'factory:kujira1qk00h5atutpsv900x202pxx42npjr9thg58dnqpa72f2p7m2luase444a7:uusk' then 'factory1' --no exist

when 'gravity0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2' then 'gravity1' --no exist

when 'gravity0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48' then 'gravity2' --no exist

when 'gravity0x6B175474E89094C44Da98b954EedeAC495271d0F' then 'gravity3' --no exist

when 'uluna' then 'luna'

when 'ukuji' then 'kuji'

when 'umntl' then 'mntl'

when 'ustars' then 'stars'

when 'uregen' then 'regen'

when 'uusdt' then 'usdt' --no exist

when 'uumee' then 'umee'

when 'uusd' then 'usd' --no exist