messarisolana vote txs
    Updated 10 hours ago
    select
    date(block_timestamp) as date,
    sum(num_votes) as votes
    from
    solana.gov.fact_votes_agg_block
    group by 1
    having date is not null
    order by 1 desc
    Last run: about 10 hours ago
    DATE
    VOTES
    1
    2025-04-07 00:00:00.000229796458
    2
    2025-04-06 00:00:00.000279993428
    3
    2025-04-05 00:00:00.000280027818
    4
    2025-04-04 00:00:00.000279533379
    5
    2025-04-03 00:00:00.000278857491
    6
    2025-04-02 00:00:00.000278962306
    7
    2025-04-01 00:00:00.000275471852
    8
    2025-03-31 00:00:00.000278353601
    9
    2025-03-30 00:00:00.000279623032
    10
    2025-03-29 00:00:00.000277632760
    11
    2025-03-28 00:00:00.000272731670
    12
    2025-03-27 00:00:00.000279686147
    13
    2025-03-26 00:00:00.000280640463
    14
    2025-03-25 00:00:00.000283007531
    15
    2025-03-24 00:00:00.000281573873
    16
    2025-03-23 00:00:00.000283192714
    17
    2025-03-22 00:00:00.000284114137
    18
    2025-03-21 00:00:00.000283656908
    19
    2025-03-20 00:00:00.000284100171
    20
    2025-03-19 00:00:00.000285071194
    ...
    1645
    61KB
    3s