Pine AnalyticsRealms Proposal votes
    Updated 2025-01-12
    SELECT
    block_timestamp,
    tx_id,
    voter,
    proposal,
    realms_id,
    vote_choice,
    vote_rank,
    vote_weight

    from solana.gov.fact_proposal_votes
    where realms_id in (
    '84pGFuy1Y27ApK67ApethaPvexeDWA66zNV8gm38TVeQ',
    'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE',
    'GWe1VYTRMujAtGVhSLwSn4YPsXBLe5qfkzNAYAKD44Nk',
    '3xErzZCdfiDGjKCR4PQF1FVoA8CYXdmS4MknLTZ8U5sA',
    'HCee9GwadG6meBDPJC3X6vumyTZ2BbeQAZEyxK2PhfYb',
    'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip',
    'F9V4Lwo49aUe8fFujMbU6uhdFyDRqKY54WpzdpncUSk9',
    '3YADdZuLqfZ8ZHnxDNMnMs77qbVdhioe6yi3b4i3hfNA',
    '5PP7vKjJyLw1MR55LoexRsCj3CpZj9MdD6aNXRrvxG42',
    'EKCVQN6vYgTkE52QXa6vvr6ZLjEXpEynx8fsEmTWQ1uF',
    '4RaA3cPnHeoV3m2Z7JmMjhPaRM8ycWBDiFcGJSXPXYmE',
    '8tu9NmrKQEZK9BkVa2KNYjAMQX7qDZfL9n5f7LxDLJLw',
    'GDaLwof8UxAsQZjBgtiWepyV73rkKpdPVUMFVEAwMw1r',
    'BiLhzxXqUX1ckdQGjZRNSd3Fha36XwVJhJFS4x1NePeR',
    '7vrFDrK9GRNX7YZXbo7N3kvta7Pbn6W1hCXQ6C7WBxG9',
    '66Du7mXgS2KMQBUk6m9h3TszMjqZqdWhsG3Duuf69VNW'
    )
    and succeeded
    order by block_timestamp DESC



    QueryRunArchived: QueryRun has been archived