graham | Flipside Analyst

    graham

    Joined May 9, 2022
    //
    28Upvotes
    MonkeDAO Voting Break-Down

    MonkeDAO Voting Break-Down

    May 13, 2022 - 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

    graham