alleriaLUNA Total Supply Past Year - 2021
    Updated 2022-05-08
    select
    date,
    CASE
    WHEN address in ('terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6', 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw',
    'terra1wqmfu6w725sal3nvr0ggy49mmtwqgc6tyf4anp', 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f') THEN 'Non-Circulating'
    ELSE 'Circulating'
    END as category,
    SUM(balance) as total_supply
    from terra.daily_balances
    --where address != 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw'
    --AND address != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
    --AND address != 'terra1wqmfu6w725sal3nvr0ggy49mmtwqgc6tyf4anp'
    --AND address != 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f'
    WHERE address !='terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'
    AND currency = 'LUNA'
    AND date >= '2021-01-01'
    AND date < '2022-01-01'
    GROUP BY date, category
    ORDER BY DATE ASC
    Run a query to Download Data