strawbettyLUNA Circulate Supply since past 90 days
    Updated 2022-07-07
    with daily_balances as (
    SELECT date_trunc('day', date) as day, balance
    FROM terra.daily_balances
    WHERE currency = 'LUNA' AND balance > 0 AND address_label IS NULL AND date > CURRENT_DATE - 90
    ORDER BY balance DESC
    )

    SELECT day, sum(balance) as circulating_supply
    FROM daily_balances
    group by day
    Run a query to Download Data