-- AVG staked Luna per month
SELECT
date_trunc('MONTH', date) AS month,
MAX(DAY(date)) AS days_per_month,
SUM(balance)/days_per_month AS avg_staked_luna_per_month
FROM terra.daily_balances
WHERE currency = 'LUNA'
AND balance_type = 'staked'
AND balance > '0'
AND address != 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'
AND date BETWEEN '2021-08-01' AND CURRENT_DATE
GROUP BY month