LTirrellluna_circulating_supply_3
    Updated 2022-01-25
    select
    address,
    balance,
    address_label_type,
    address_label_subtype,
    address_name
    from
    terra.daily_balances
    where
    date = '2022-01-23'
    and currency = 'LUNA'
    and balance <=1 and balance >0.1
    and balance_type = 'liquid'
    and (
    ADDRESS_LABEL is NULL
    or ADDRESS_LABEL != 'terraform'
    )
    and (
    ADDRESS_NAME is NULL
    or ADDRESS_NAME != 'terra mint/burns swap fees'
    )
    and (
    ADDRESS_LABEL_SUBTYPE is NULL
    or ADDRESS_LABEL_SUBTYPE != 'staking'
    )

    order by
    balance desc

    Run a query to Download Data