DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,

AVG(PRICE_RUNE_ASSET) AS average_price

FROM

thorchain.price.fact_prices

WHERE

DATE_PART('year', BLOCK_TIMESTAMP) = 2024

GROUP BY

DATE_TRUNC('month', BLOCK_TIMESTAMP)

ORDER BY

month;