-- $THOR Staking Distribution -- Q95. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out -- more about how the community has embraced the staking rewards. -- What is the distribution of $THOR currently staked? Are there any notable whales? You will need to -- calculate the net amount staked + unstaked to get the current amount. -- Payout 24.83 RUNE -- Grand Prize 74.5 RUNE -- Level Intermediate WITH a AS ( SELECT DISTINCT tx_id FROM ethereum.events_emitted WHERE block_timestamp >= '2022-05-04' AND contract_address = LOWER('0xa5f2211B9b8170F694421f2046281775E8468044') ), b AS ( SELECT DISTINCT e.tx_id FROM ethereum.events_emitted e JOIN a ON a.tx_id = e.tx_id WHERE block_timestamp >= '2022-05-04' AND tx_to_address = LOWER('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') AND event_name = 'Deposit' ), c AS ( SELECT DISTINCT e.tx_id FROM ethereum.events_emitted e JOIN b ON b.tx_id = e.tx_id WHERE block_timestamp >= '2022-05-04' AND tx_to_address = LOWER('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') AND event_name = 'DelegateVotesChanged' ), staking_txns as ( SELECT block_timestamp::date AS date , CASE WHEN e.event_name = 'Transfer' AND contract_address = '0xa5f2211b9b8170f694421f2046281775e8468044' AND LENGTH(event_inputs:value::string) <= 25 THEN CAST(event_inputs:value::string AS INT) * POWER(10, -18) ELSE 0 END AS thor_amt , * FROM ETHEREUM.events_emitted e JOIN c ON c.tx_id = e.tx_id WHERE block_timestamp >= '2022-05-04' -- Started on 04 May, 2022 and thor_amt > 0 ), a2 AS ( SELECT DISTINCT tx_id FROM ethereum.events_emitted WHERE block_timestamp >= '2022-05-04' -- Started on 04 May, 2022 AND contract_address = LOWER('0xa5f2211B9b8170F694421f2046281775E8468044') ), b2 AS ( SELECT DISTINCT e.tx_id FROM ethereum.events_emitted e JOIN a2 ON a2.tx_id = e.tx_id WHERE block_timestamp >= '2022-05-04' -- Started on 04 May, 2022 AND tx_to_address = LOWER('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') AND event_name = 'Withdraw' ), c2 AS ( SELECT DISTINCT e.tx_id FROM ethereum.events_emitted e JOIN b2 ON b2.tx_id = e.tx_id WHERE block_timestamp >= '2022-05-04' -- Started on 04 May, 2022 AND tx_to_address = LOWER('0x815c23eca83261b6ec689b60cc4a58b54bc24d8d') AND event_name = 'DelegateVotesChanged' ), unstaking_txns as ( SELECT block_timestamp::date AS date , CASE WHEN e.event_name = 'Transfer' AND contract_address = '0xa5f2211b9b8170f694421f2046281775e8468044' AND LENGTH(event_inputs:value::string) <= 25 THEN CAST(event_inputs:value::string AS INT) * POWER(10, -18) ELSE 0 END AS thor_amt , * FROM ETHEREUM.events_emitted e JOIN c2 ON c2.tx_id = e.tx_id WHERE block_timestamp >= '2022-05-04' -- Started on 04 May, 2022 and thor_amt > 0 ), staking_amount as ( select tx_from_address as wallet, sum(thor_amt) as amount from staking_txns group by wallet ), ustaking_amount as ( select tx_from_address as wallet, sum(thor_amt) * -1 as amount from unstaking_txns group by wallet ), wallet_amounts as ( select * from ( select wallet, sum(amount) as thor_staked from ( select * from ustaking_amount union select * from staking_amount ) group by wallet order by thor_staked desc ) where thor_staked > 0 ) select count(distinct wallet) as n_wallets, CASE WHEN thor_staked > 0 and thor_staked <= 1 THEN 'a.0-1' WHEN thor_staked > 1 and thor_staked <= 10 THEN 'b.1-10' WHEN thor_staked > 10 and thor_staked <= 50 THEN 'c.10-50' WHEN thor_staked > 50 and thor_staked <= 1e2 THEN 'd.50-100' WHEN thor_staked > 1e2 and thor_staked <= 1e3 THEN 'e.100-1000' WHEN thor_staked > 1e3 and thor_staked <= 1e4 THEN 'f.1K-10K' WHEN thor_staked > 1e4 and thor_staked <= 1e5 THEN 'g.10K-100K' WHEN thor_staked > 1e5 and thor_staked <= 1e6 THEN 'h.100K-1M' WHEN thor_staked > 1e6 and thor_staked <= 1e7 THEN 'i.1M-10M' WHEN thor_staked > 1e7 and thor_staked <= 1e8 THEN 'j.10M-100M' WHEN thor_staked > 1e8 THEN 'k.> 100M' END as category from wallet_amounts group by category order by category

Thor-95.$THOR Staking Distribution