What question wants??

The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?

Hint: Use the msg_attributes table and select transactions that have an appropriate msg_type for delegator voting.

Approach:

In this essay, the voting performance of Osmosis governance in the period between May 8th to 15th has been investigated.

The participation and quick reaction of governance on proposals have been analyzed in this investigation.

The methodology of this essay contains the following steps:

• Cast vote

      from osmosis.core.fact_msg_attributes 
      and msg_type = 'proposal_vote' 
      and attribute_key = 'option' for casting votes
      and attribute_key = 'proposad_id' for casting proposals
  

• Vote options

      when voting_options = '1' then 'Yes'
      when voting_options = '2' then 'Abstain'
      when voting_options = '3' then 'No'
      when voting_options = '4' then 'NoWithVeto' 
  

• Time periods

      block_timestamp>= '2022-05-08' and block_timestamp<='2022-05-13' to 8-15 May
      block_timestamp<'2022-05-08' and block_timestamp >= CURRENT_DATE-60 for previous proposals
  

Results:

The first graph illustrate the voting distribution by options.

According to this graph, the governance of Osmosis mostly votes for YES options for proposals between May 8th to 15th.

The contribution of governance on proposals between May 8th to 15th and previous proposals for past 2 months have been figured out on these contents.

Note: we should consider the days of proposals and take count the duration of each proposal on our investigation.

According to the graphs, for proposals between May 8th to 15th in just one week, the number of contribution is much more than proposals for the past 2 months.

For example for proposal no 206, the count of votes for the past 2 months is 57.6k but for proposal no 221 (between May 8-15), the count of votes is over 28k and its remarkable in comparison with votes for past 2 months.