Sbhn_NPRealms All stats
Updated 2022-08-31
9
1
2
3
4
5
6
›
⌄
select count(distinct(tx_id)) as vote_count,count(distinct(voter)) as voter_count,vote_count/voter_count as avg_vote_per_voter,count(distinct(proposal)) as proposal_count,
min(block_timestamp)::date as creation_date,
max(block_timestamp)::date as latest_proposal_date
from solana.core.fact_proposal_votes
where governance_platform = 'realms'
and succeeded = 'TRUE'
Run a query to Download Data