LTirrellsol_vote-distribution
    Updated 2022-10-07
    -- vote distribution
    -- adapted from: https://app.flipsidecrypto.com/dashboard/IbyarV
    WITH vote_tx AS (
    SELECT
    b.block_id,
    b.block_timestamp,
    tx_count,
    num_votes,
    num_votes / tx_count AS vote_ratio
    FROM
    solana.core.fact_votes_agg_block v
    JOIN solana.core.fact_blocks b ON v.block_id = b.block_id
    )
    SELECT
    ROUND(vote_ratio, 2) AS vote_percent,
    COUNT(DISTINCT block_id) AS blocks
    FROM
    vote_tx
    WHERE
    block_timestamp >= '2022-01-01'
    GROUP BY
    vote_percent
    ORDER BY
    vote_percent
    Run a query to Download Data