date_trunc('day', hour)::date as date ,

symbol,

avg(price ) as price

FROM optimism.core.fact_hourly_token_prices

WHERE symbol in ('OP')

AND hour > CURRENT_DATE - 60

GROUP BY 1,2

UNION

SELECT

date_trunc('day', hour)::date,

symbol,

avg(price ) as price

FROM ethereum.core.fact_hourly_token_prices

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

AND hour > CURRENT_DATE - 60

GROUP BY 1,2

UNION

SELECT

date_trunc('day', block_hour)::date,

ASSET_NAME as symbol,

avg(price_usd ) as price

from algorand.defi.ez_price_pool_balances

WHERE ASSET_NAME = 'ALGO'

AND ASSET_ID = 0

AND block_hour > CURRENT_DATE - 60

GROUP BY 1,2