avg(RUNE_USD) AS price_usd,

min(RUNE_USD) as min_price,

max(RUNE_USD) as max_price,

AVG(price_usd) OVER (ORDER BY date ROWS BETWEEN 9 PRECEDING AND CURRENT ROW) AS sma_10_days

FROM thorchain.core.fact_prices where block_timestamp>=current_date-INTERVAL '1 YEAR'

group by date ORDER BY date;