flipside

    Top 10 Realms Projects
    markooTop 10 Realms Projects
    Updated 2022-08-30
    with raw as (SELECT block_timestamp, tx_id, coalesce(address_name, program_name) as project, voter, proposal, vote_weight, CASE WHEN vote_choice = 'YES' THEN 1 ELSE 0 END as vote_choice
    FROM solana.core.fact_proposal_votes fpv
    LEFT JOIN (SELECT address, address_name FROM solana.core.dim_labels WHERE label LIKE '%realms%') labels ON program_name = address
    WHERE governance_platform = 'realms' AND SUCCEEDED)

    select project, count(distinct Voter) as n_voter from raw where project != 'realms general contract' group by 1 order by 2 desc limit 10
    Run a query to Download Data