with price as ( select hour::date as date,

symbol,

avg(price) as avg_price

from flow.price.ez_prices_hourly

where symbol is not null

and symbol not in ('FLOW','CEWBTC')

group by 1,2

select hour::date as date,

symbol,

avg(price) as avg_price

from ethereum.price.ez_prices_hourly

where symbol = 'ETH'

group by 1,2

select hour::date as date,

'CEWBTC' as symbol,

avg(price) as avg_price

from ethereum.price.ez_prices_hourly

where symbol = 'WBTC'

group by 1,2

select hour::date as date,

symbol,

avg(price) as avg_price

from polygon.price.ez_prices_hourly

where symbol = 'MATIC'

group by 1,2

Select TO_TIMESTAMP(value[0]::string) as date,

'BLT' as symbol,

value[1] as avg_price

from (

SELECT livequery.live.udf_api(