prices as (

case when symbol = 'USDC' then 'aYeiUSDC'

when symbol = 'USDT' then 'aYeiUSDT'

when symbol in ('WETH') then 'aYeiWETH'

when symbol in ('ETH') then 'aYeifrxETH'

when symbol in ('SFRXETH.PICA') then 'aYeisfrxETH'

when symbol = 'SFRAX.PICA' then 'aYeisFRAX'

when symbol = 'BUSD' then 'aYeiFRAX'

when symbol = 'SEI' then 'aYeiISEI'

end as asset,

avg(price) as price

from osmosis.price.ez_prices where symbol in ('USDC','USDT', 'BUSD','SEI', 'WSEI', 'ETH','WETH','FRAXETH', 'SFRXETH.PICA','SFRAX.PICA')

and recorded_hour>=current_date

group by 1

UNION ALL

CASE

WHEN symbol = 'SEI' THEN 'aYeiWSEI'

END AS asset,

AVG(price) AS price

FROM osmosis.price.ez_prices

WHERE symbol = 'SEI'

AND recorded_hour >= current_date

GROUP BY 1

),

deposits as (

select

symbol as asset

,

count(DISTINCT tx_hash) as deposits