select staker_class, case when staker_class='Shrimp' then '0 < vTHOR holding < 100' when staker_class='Tuna' then '100 < vTHOR holding < 1000' when staker_class='Shark' then '1000 < vTHOR holding < 10000' when staker_class='Whale' then ' 10000 < vTHOR holding' end as bag_size_vTHOR, count(distinct user_address) as n_unique_address from(with dox as (select * from (select tx_from_address, count(date) as n_stake_day from (select date(t) as date , tx_from_address, sum(nb) as tnb, sum(pb) as tpb, tnb-tpb as stake, case when stake>0 then 'Stake' else 'Doesnt Stake' end as stake_activity from (with thor_acn as (select tx_id from ethereum.events_emitted where --event_name='DelegateVotesChanged' and -- tx_id='0x1811392f80a36e6ccf8d1c8e48bcbb92038c280a1a4579a67e9a59f349e6a140' and contract_name='thorswap: thor token' and event_name='Approval'), thor_v as ( select * from ethereum.events_emitted where event_name='DelegateVotesChanged' and tx_to_address='0x815c23eca83261b6ec689b60cc4a58b54bc24d8d' and block_timestamp>='2022-05-01' ) select thor_acn.tx_id, block_timestamp as t, event_inputs, event_inputs:newBalance/1e18 as nb, event_inputs:previousBalance/1e18 as pb, tx_from_address, tx_to_address, contract_address from thor_acn inner join thor_v on thor_acn.tx_id=thor_v.tx_id) group by 1, 2 order by 1 ) where stake_activity='Stake' group by 1 order by 1) ), bal as ( select * from ethereum.erc20_balances where balance_date='2022-05-20' ) select user_address, symbol, balance, case when balance>0 and balance<100 then 'Shrimp' when balance>=100 and balance<1000 then 'Tuna' when balance>=1000 and balance<10000 then 'Shark' else 'Whale' end as staker_class from dox inner join bal on dox.tx_from_address=bal.user_address where symbol='vTHOR' ) group by 1 order by 2 asc

$THOR Staking Distribution