select

hour as hours ,

avg(price) as price

from ethereum.core.fact_hourly_token_prices

where symbol is null and token_address is null

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

group by hours

),

btc_price as (

select

date_trunc(hour,block_timestamp) as hours,

avg(asset_usd) as price

from thorchain.prices

where block_timestamp::date >= '2022-05-01'

and pool_name = 'BTC.BTC'

group by hours

, algo_price as (

select avg(PRICE_USD)as price , BLOCK_HOUR as hours

from flipside_prod_db.algorand.prices_swap

where ASSET_ID = 0 and BLOCK_HOUR::date >= '2022-05-01'

group by BLOCK_HOUR

, sol_price as (

select

hour as hours ,

avg(price) as price

from ethereum.core.fact_hourly_token_prices

where token_address ='0xd31a59c85ae9d8edefec411d448f90841571b89c'

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

group by hours