alleriaLUNA Total Supply Past Year - 2021
Updated 2022-05-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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