elvisUntitled Query
Updated 2022-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
⌄
/*
Track the wallets that voted yes and no for the SMB proposal. What were people's voting preferences based on the number of SMBs that they owned?
What have these wallets done with their SMBs since the voting?
Was the nearly unanimous voting a bullish event?
Have wallets that voted yes bought more monkes?
Were those who voted no more likely to sell after the fact and on which marketplace?
What percentage of all monke sales involved a selling wallet that voted at all?
*/
SELECT instructions[0]:accounts[6] AS acct_6 , instructions[0]:data AS data , any_value(TX_ID) ,COUNT(1) AS n , SUM(ARRAY_SIZE(inner_instructions)) AS total_votes
--SELECT *
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
Run a query to Download Data