flow as (select trunc(hour,'day') as date,

symbol,

avg(price) as price

from flow.price.ez_prices_hourly

where symbol ='FLOW' and hour>='2024-08-01'

group by 1,2

),

sei as (select trunc(RECORDED_HOUR,'day') as date,

symbol,

avg(price) as price

from osmosis.price.ez_prices

where symbol ='SEI' and RECORDED_HOUR>='2024-08-01'

group by 1,2

select * from flow union select * from sei order by 1 desc, 2