nitsUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with net_balances as (select address, sum(balance_usd) as net_balance from terra.daily_balances
where date = CURRENT_DATE -1
GROUP by address )
select validator_address_label, count(*) as unique_retailers, sum(net_balance)/pow as net_worth_of_validator_by_retailers, avg(net_balance) as avg_net_worth_of_validator_by_retailers
from
(select * from
(select * from
(select delegator_address, validator_address_label, sum(net_stake) as total_staked from
(select delegator_address, validator_address_label, case when action = 'delegate' then event_amount else event_amount*(-1) end as net_stake from terra.staking)
GROUP by 1,2 ) where validator_address_label is not NULL and total_staked > '0')
inner join net_balances
on delegator_address = address )
where net_balance < pow(10,3)
GROUP by 1
order by 2 desc
limit 100
Run a query to Download Data