princefarzamStaked Luna per month
    Updated 2022-03-19

    -- 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
    Run a query to Download Data