headitmanagerTPS With Vote
    Updated 2022-02-21
    select count(*)/(24*60*60) as TPS, block_timestamp::date as date
    from solana.events
    where succeeded = TRUE and
    block_timestamp::date >='2022-02-01'
    and block_timestamp::date != CURRENT_DATE
    Group by date
    order by date