DATE(HOUR) as dayz,

symbol as symbols,

avg (price) as avg_price

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol in ('WETH', 'MATIC')

AND HOUR::date >= CURRENT_DATE - {{period}}

GROUP BY 1 , 2

UNION ALL

select

DATE(RECORDED_HOUR) as dayz,

SYMBOL as symbols,

avg(CLOSE) as avg_price

from solana.core.fact_token_prices_hourly

where SYMBOL ='SOL'

and recorded_hour::date >= CURRENT_DATE - {{period}}

group by 1 , 2

UNION ALL

DATE(RECORDED_AT) as dayz,

symbol as symbols,

avg(price) as avg_price

FROM osmosis.core.dim_prices

WHERE symbol ='ATOM'

AND RECORDED_AT::date >= CURRENT_DATE - {{period}}

GROUP by 1 , 2

UNION ALL

SELECT

DATE(HOUR) AS dayz,

symbol as symbols,