No | WEEK | PROPOSAL | APPROVED_CNT | PROPOSALS | |
|---|---|---|---|---|---|
1 | 15 | 2024-3 | 2 | 2 | [
"DIP-9 - Transfer the management and distribution rights of DAOSquare community rewards",
"DIP-8 - DAOSquare Grants Strategy Modification"
] |
2 | 14 | 2024-1 | 4 | 4 | [
"DIP-6 - Reward to haipi.eth for his contributions in DAOSquare community",
"DIP-4 - Governance Participation Reward",
"DIP-7 - Discord channel access limit adjustment",
"DIP-5 - Reward to taurenshaman for his work on DAO Graph"
] |
3 | 13 | 2023-52 | 3 | 2 | [
"DIP-3 - 开启圣诞抽奖吗？",
"DREO-08-(Improvement of DAOSquare Governance) ",
"DIP-2 - Proposal Test"
] |
4 | 12 | 2023-51 | 1 | 1 | [
"TEST FOR STRATEGY"
] |
5 | 11 | 2023-49 | 1 | 1 | [
"DREO -07( Up the DKP3 reward of Quiz activity to 5) "
] |
6 | 10 | 2023-40 | 1 | 1 | [
"DREO-06-(DAOSquare_CN Specific Operations Plan) "
] |
7 | 9 | 2023-27 | 1 | 1 | [
"DREO-05- logo license application"
] |
8 | 8 | 2023-22 | 1 | 1 | [
"DERO-04-（Phaver×DAOSquare AMA）"
] |
9 | 7 | 2023-21 | 1 | 1 | [
"DREO-03（Family Call For Incubator Test Brief）"
] |
10 | 6 | 2023-15 | 1 | 1 | [
"DREO-02（Initiate a community call 37th ）"
] |
11 | 5 | 2023-11 | 1 | 1 | [
"DREO-1（Start Music Radio Party）"
] |
12 | 4 | 2022-40 | 1 | 1 | [
"Dcp15:建立孵化公会"
] |
13 | 3 | 2022-33 | 1 | 1 | [
"DCP14：设立给黑客上黑名单的子dao的建议"
] |
14 | 2 | 2022-15 | 2 | 2 | [
"DCP9:关于IQ额度的第二次分配申请 ",
"Dcp8:关于额度分配的改进方案"
] |
15 | 1 | 2022-12 | 1 | 1 | [
"建议把 DKP里面关于DKP5和DKP6的部分隐藏。"
] |
DAOSquareProposals by week
Updated 2024-01-08
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
cycles AS (
SELECT
ROW_NUMBER() OVER (ORDER BY MIN(proposal_start_time) ASC) AS "No",
CONCAT(EXTRACT(year FROM proposal_start_time), '-', EXTRACT(WEEK FROM proposal_start_time)) AS week,
COUNT(DISTINCT proposal_id) AS proposal,
COUNT(voter, proposal_id) AS vote_cnt,
SUM(voting_power) AS total_score,
ARRAY_AGG(DISTINCT proposal_title) AS proposals,
ARRAY_AGG(DISTINCT proposal_id) AS proposal_ids
FROM external.snapshot.ez_snapshot
WHERE space_id = '{{DAO}}'
GROUP BY week
ORDER BY MIN(proposal_start_time) DESC
)
, basic_stats AS (
SELECT
ANY_VALUE(proposal_start_time) AS proposal_start_time,
ANY_VALUE(proposal_title) AS proposal_title,
SUM(case when vote_option[0] = '1' then 1 else 0 end) AS "For", -- AND ARRAY_SIZE(choices) = 3 AND ARRAY_SIZE(vote_option) = 1
SUM(case when vote_option[0] = '1' then voting_power else 0 end) AS "ForScore", -- AND ARRAY_SIZE(choices) = 3 AND ARRAY_SIZE(vote_option) = 1
SUM(case when vote_option[0] = '2' then 1 else 0 end) AS "Against", -- AND ARRAY_SIZE(choices) = 3 AND ARRAY_SIZE(vote_option) = 1
SUM(case when vote_option[0] = '2' then voting_power else 0 end) AS "AgainstScore", -- AND ARRAY_SIZE(choices) = 3 AND ARRAY_SIZE(vote_option) = 1
SUM(case when vote_option[0] = '3' then 1 else 0 end) AS "Abstain", -- AND ARRAY_SIZE(choices) = 3 AND ARRAY_SIZE(vote_option) = 1
SUM(case when vote_option[0] = '3' then voting_power else 0 end) AS "AbstainScore", -- AND ARRAY_SIZE(choices) = 3 AND ARRAY_SIZE(vote_option) = 1
COUNT(*) AS "Total",
SUM(voting_power) AS "TotalScore",
ANY_VALUE(quorum) AS quorum,
proposal_id
FROM external.snapshot.ez_snapshot
WHERE space_id LIKE '{{DAO}}'
-- AND ARRAY_SIZE(choices) = 3 AND ARRAY_SIZE(vote_option) = 1 -- Basic voting
GROUP BY proposal_id
)
, approve_stats AS (
SELECT
Last run: about 1 year ago
15
1KB
2s