Metiocrenumber of votes per day
    Updated 2022-05-24
    -- 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