SELECT Min(price_usd) as min_luna_price, Max(price_usd) as max_luna_price, Avg(price_usd) AS avg_luna_price,
date_trunc('day', block_timestamp) AS date, stddev(price_usd) AS std_luna_deviation,
std_luna_deviation/avg_luna_price AS std_luna_percent
FROM terra.oracle_prices
WHERE block_timestamp > DATEADD(day, -14, getdate()) AND symbol = 'LUNA'
GROUP BY date ORDER BY date limit 20000;