with tb1 as (select
count(distinct VOTER) as total_voters
from osmosis.core.fact_governance_votes
where tx_id is not NULL
)
select
PROPOSAL_ID as pp,
date_trunc('day',BLOCK_TIMESTAMP) as date,
(count (distinct VOTER))/total_voters*100 as share_of_voters
from osmosis.core.fact_governance_votes,tb1
where tx_id is not NULL
group by 1,2,total_voters