C4CList of top 10 Excluded foundation's addresses UST owners on Terra
Updated 2022-03-31Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT top 10 balance as "UST ",address
from terra.daily_balances
where date = (select max(date) from terra.daily_balances)
and currency='UST'
and address != 'terra1wfz7h3aqf4cjmjcvc6s8lxdhh7k30nkczyf0mj'
and address != 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc'
and address != 'terra1qr2k6yjjd5p2kaewqvg93ag74k6gyjr7re37fs'
and address != 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl'
and address != 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f'
and address != 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
and address != 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8'
and address != 'terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u'
and address != 'terra1m6ywlgn6wrjuagcmmezzz2a029gtldhey5k552'
and address != 'terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe'
and address != 'terra1g6llg3zed35nd3mh9zx6n64tfw3z67w2c48tn2'
and address != 'terra1l7xu2rl3c7qmtx3r5sd2tz25glf6jh8ul7aag7'
and address != 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'
order by 1 DESC;
Run a query to Download Data