misaghlbtmp
Updated 2022-04-06
999
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 total_voters as (
SELECT
instructions[0]:data AS data ,
signers[0] as wallet,
COUNT(1) AS n,
SUM(ARRAY_SIZE(inner_instructions)) AS total_votes,
case when data = 'Yjf5DvKUCfa2bPkYz4AiWs' then 'yes' when data = 'Yjf5DvKUCfa2Rh5YBEg7FM' then 'no' end as yes_no
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' or data = 'Yjf5DvKUCfa2Rh5YBEg7FM')
GROUP BY wallet, data
),
yes_voters as (
SELECT
instructions[0]:data AS data ,
signers[0] as wallet
-- case when data = 'Yjf5DvKUCfa2bPkYz4AiWs' then 'yes' when data = 'Yjf5DvKUCfa2Rh5YBEg7FM' then 'no' end as yes_no
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 wallet, data
),
no_voters as (
SELECT
instructions[0]:data AS data ,
signers[0] as wallet
-- case when data = 'Yjf5DvKUCfa2bPkYz4AiWs' then 'yes' when data = 'Yjf5DvKUCfa2Rh5YBEg7FM' then 'no' end as yes_no
FROM solana.fact_transactions
WHERE block_timestamp <= '2022-03-05'
AND block_timestamp >= '2022-02-15'
Run a query to Download Data