MonkeDAO Whale Voters

    A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together.

    Q51. Extension off the MonkeDAO question last week:

    A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together.

    Break down the voting behavior for the first three proposals by the following number of monkes per wallet (1 SMB, 2-3 SMBs, 4+ SMBs). Are there any patterns that you see based on number of SMBs used to vote in a wallet? Why do you think ""whales"" voted the way that they did?

    Background info: https://decrypt.co/93193/solana-monkey-business-monkedao-battling-over-future

    Hint: Voting programId : Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci

    Sample tx of a vote for question 1 (Accept SMB proposal) https://solscan.io/tx/5pTUfdXkHfG8WQhThmYW6fkVpp6oheTZRrLYD3mhANJ86XrkV75AQ8HNuj8CasHVrGHXGaep9nsNM4dTaVpYX4AB

    Sample tx of a vote for question 2 (If vote 1 was not passed, should vote 1 not succeed, should MonkeDAO membership change from holding a SMB to a NFT issued by MonkeDAO?) https://solscan.io/tx/3B8BRtfSskcRHb2jsQieUUpMXZUAxLZbHzYhd64PBAgJxzdgBVaHBqUdMcMVK3SytJmWHZbfSy4BZbF6MbUsQccT

    Sample tx of a vote for question 3 (If vote 2 succeeds, what should be the access mechanism for the DAO be?= - airdrop or entanglement? https://solscan.io/tx/GUapUn8FmTqmxkZ9RLtK4WZzhkDSEyYxApBK9r6r1F2wTHcJWfL35xav3qogvBv8EFTz4GX6C3Z1TQaiQB5byPc

    Overall Voting Results for the first 3 questions:

    Question 1: Yes (1483) No (64) Question 2: Yes (361) No (181) Question 3: Airdrop (262) Entangle (191)

    Sample query of a count of all votes: SELECT instructions[0]:accounts[6] AS acct_6 , instructions[0]:data AS data , COUNT(1) AS n , SUM(ARRAY_SIZE(inner_instructions)) AS total_votes FROM solana.fact_transactions WHERE block_timestamp <= '2022-03-05' AND block_timestamp >= '2022-02-15' AND succeeded = 'True' AND instructions[0]:programId = 'Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci' GROUP BY 1, 2

    Hint: need to count total votes as shown in sample as you can have more than 1 vote per transaction

    Hint: You will need to link the last Acct_6 with the data (can reference voting results for confirmation) to map out questions and answers.

    Hint: use solana.fact_nft_sales and solana.dim_nft_metadata

    Hint: SMB marketplace program Id: J7RagMKwSD5zJSbRQZU56ypHUtux8LRDkUpAPSKH4WPp

    Hint: Also need Magic Eden marketplace program Id: M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K