select

hour::date as near_price_date

,avg(close) as NEAR_Price

from near.price.fact_prices_ohlc_hourly

where ASSET_ID='wrapped-near'

and near_price_date is not null

group by 1

)

,lst_aurora_price as (

select

hour::date as aurora_price_date

,avg(close) as AURORA_Price

from near.price.fact_prices_ohlc_hourly

where ASSET_ID='aurora-near'

and aurora_price_date is not null

group by 1

)

, lst_price as (

select

hour::date as price_date

,avg(price) as BRRR_Price

from near.price.ez_prices_hourly

where symbol = 'BRRR'

and hour::date>='2022-04-05'

group by 1

,lst_price_last as (

select top 1

hour::date as price_date

,avg(price) as BRRR_Price

from near.price.ez_prices_hourly

where symbol = 'BRRR'

and hour::date>='2022-04-05'

group by 1

order by hour::date desc