binhachonMonkeDAO Vote - No voters with their transactions
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
›
⌄
with voter_data as (
select
block_timestamp,
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, 3
),
NFT_metadata as (
select
distinct mint
from solana.dim_nft_metadata
where contract_name = 'Solana Monkey Business'
and mint is not null
)
select * from solana.nfts
where mint in (select mint from NFT_metadata)
and posttokenbalances[0]:owner::string in (select acct_0 from voter_data)
order by block_timestamp desc
Run a query to Download Data