Metiocrenumber of votes per day
Updated 2022-05-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- Return the last 60 days proposal votes
WITH all_proposals AS
(SELECT block_timestamp :: DATE AS DATE,
attribute_value AS proposal
FROM osmosis.core.fact_msg_attributes
WHERE block_timestamp > CURRENT_DATE()-60
AND msg_type = 'proposal_vote'
AND attribute_key = 'proposal_id')
-- Count daily terra and non-terra governance votes
SELECT date,
CASE
WHEN proposal IN ('172', '222', '223', '224', '225', '226', '227', '228', '230', '234') THEN 'terra'
ELSE 'non-terra'
END AS prop_type,
COUNT(prop_type)
FROM all_proposals
GROUP BY date, prop_type
ORDER BY date ASC;
Run a query to Download Data