bertatop_10_percent_holders
Updated 2022-01-27
9
1
2
3
4
5
6
7
›
⌄
with tab1 as (SELECT DISTINCT address, balance FROM terra.daily_balances
WHERE currency = 'LUNA' AND date = '2022-01-26' AND balance > 0 and address != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
ORDER BY balance DESC LIMIT 339088)
--tab2 as (SELECT DISTINCT address, balance FROM terra.daily_balances
-- WHERE currency = 'LUNA' AND date = '2022-01-26' AND balance > 0 and address != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
-- ORDER BY balance DESC LIMIT 339088)
select sum(balance) as top_10_percent_holders from tab1
Run a query to Download Data