LTirrellterradash_daily-balance
    Updated 2022-04-25
    -- select
    -- date,
    -- sum(balance)

    -- from terra.daily_balances
    -- where currency='LUNA'
    -- and balance_type = 'liquid'
    -- and address_label not in (
    -- 'terraform'
    -- )
    -- and date>'2022-04-18'
    -- group by date
    -- order by date

    -- select
    -- date ,
    -- sum(balance) as "LUNA Circulating Supply"
    -- from terra.daily_balances
    -- where date >= '2021-04-18'
    -- and currency = 'LUNA'
    -- -- and address_label_type is NULL
    -- and address_label not in (
    -- 'terraform'
    -- )
    -- group by date, 'balance_type'
    -- order by date

    select
    round(
    sum(balance) / pow(10, 6),
    2
    ) as "Balance (Mil)",
    case
    when address = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' then 'bLUNA' --anchor hub
    else balance_type
    end as type
    Run a query to Download Data