nitsUntitled Query
    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