block_timestamp::date as day,

count(distinct tx_id) as vote_count,

count(distinct voter) as voter_count,

case

when vote_option = '1' then 'Yes'

when vote_option = '2' then 'No'

when vote_option = '3' then 'Abstain'

when vote_option = '4' then 'No With VETO'

end as status

from osmosis.core.fact_governance_votes

where proposal_id = '362'

and TX_STATUS = 'SUCCEEDED'

group by status, day