with algo_price as (

select

block_hour::date as day_price

,avg (price_usd) as avg_price

from algorand.core.ez_price_pool_balances

where asset_id = '0'

and block_hour::date>=CURRENT_DATE-30

group by 1

,flow_price as (

select

timestamp::date as day_price

,avg (price_usd) as avg_price

from flow.core.fact_prices

where source = 'coinmarketcap'

and symbol = 'FLOW'

and timestamp::date>=CURRENT_DATE-30

group by 1

,osmo_price as (

select

recorded_at::date as day_price

,avg (price) as avg_price

from osmosis.core.dim_prices

where symbol = 'OSMO'

and provider = 'coinmarketcap'

and recorded_at::date>=CURRENT_DATE-30

group by 1

,sol_price as(

select

block_timestamp::date as day_price

,avg (swap_to_amount/swap_from_amount) as avg_price