alleria[Solana] Vote! Main
    Updated 2022-02-12
    WITH
    votes as (
    SELECT
    a.block_id,
    a.block_timestamp,
    date_trunc('hour', a.block_timestamp) as hourly,
    tx_count,
    num_votes,
    num_votes / tx_count as ratio
    FROM solana.blocks a
    INNER JOIN solana.votes_block_agg b ON (a.block_id = b.block_id)
    WHERE a.block_timestamp >= '2022-02-01'
    ORDER BY a.block_id DESC
    )

    SELECT
    'Vote Transactions' as category,
    sum(num_votes) as total_votes
    FROM votes

    UNION ALL

    SELECT
    'Non-votes Transactions' as category,
    sum(tx_count) - sum(num_votes) as total_non_votes
    FROM votes
    Run a query to Download Data