LTirrellluna_circulating_supply_3
Updated 2022-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
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