date_trunc('day', recorded_at) AS date2,

symbol,

avg(price) as eth_price,

max(price) as maxeth,

min(price) as mineth,

STDDEV(price) as stveth,

stveth/eth_price as eth_pct

FROM osmosis.core.dim_prices

where SYMBOL = 'OSMO'

and recorded_at > CURRENT_DATE - 30

group by 1,2

order by 1 ASC

),

luna as (

date_trunc('day', recorded_hour) AS date2,

id as symbol,

avg(close) as eth_price,

max(close) as maxeth,

min(close) as mineth,

STDDEV(close) as stveth,

stveth/eth_price as eth_pct

FROM crosschain.core.fact_hourly_prices

where id = 'terra-luna-2'

and recorded_hour > CURRENT_DATE - 30

group by 1,2

order by 1 ASC

select * from luna

union select * from btc

order by 1 ASC