binhachonMonkeDAO Vote - No voters with their buying time
Updated 2022-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with voter_data as (
select
instructions[0]:accounts[0] as acct_0,
instructions[0]:data as data,
'Yes' as vote,
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'
and data = 'Yjf5DvKUCfa2bPkYz4AiWs'
group by 1, 2
union all
select
instructions[0]:accounts[0] as acct_0,
instructions[0]:data as data,
'No' as vote,
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'
and data = 'Yjf5DvKUCfa2Rh5YBEg7FM'
group by 1, 2
),
NFT_metadata as (
select
distinct mint
from solana.dim_nft_metadata
where contract_name = 'Solana Monkey Business'
and mint is not null
),
NFT_market_transaction as (
select
Run a query to Download Data