MonkeDAO Validator

How many unique wallets delegated their staked SOL to the MonkeDAO validator between 1st February 2022 and 17th February 2022? And what was the amount of staked SOL delegated?

Background/context

MonkeDAO is a decentralised autonomous organisation (DAO) launched by a community of Solana Monkey Business (SMB) NFT owners. It was the first NFT DAO to set up a validator. SOL token holders could delegate their staked SOL with the MonkeDAO validator (or any validators) to earn rewards. Commissions from running the validator help fund the MonkeDAO and all its initiatives.

How popular had the MonkeDAO validator been? How many wallets delegated? Though not asked for in the bounty question, I have also looked into the amount of staked SOL delegated.

Headline metrics

There were 41 unique wallets delegating a total of 4,138.3 staked SOL to the MonkeDAO validator. The full list of wallets and amount delegated is as follows:

Daily trend

Data is sourced from the solana.events table.

Steps:

Identify all staking transactions with the MonkeDAO validator by filtering for event_type = 'delegate' and instruction:parsed:info:voteAccount = 'DfpdmTsSCBPxCDwZwgBMfjjV8mF8xHkGRcXP8dJBVmrq' (MonkeDAO validator's vote key)
Source the amount of SOL staked from event_type = 'createAccount' and event_type = 'split' for tx_id identified in Step 1.

Appendix - notes on methodology

The chart below shows:

Bar chart - the daily number of delegations (defined as number of unique staking transactions);
Line chart - the daily amount of SOL delegated.

Note that in the table under the "Headline metrics" section, the amount delegated is null for wallet "8dbR8MtEnfJj6E1GA2qvZFJQ4oh8bXbzfird2L3J7uVe". This is because its staking transaction to the MonkeDAO validator happened over 2 separate transactions. The query does not work with this edge case. I've checked that the wallet had a negligible staked amount in its stake account as at 17 February 2022.