hessSTPS
    Updated 5 hours ago
    with sei AS (select block_timestamp,
    tx_hash
    from sei.core_evm.fact_transactions
    where block_timestamp::date >= current_date - 30
    and status = 'SUCCESS'
    )
    ,
    txns as (select trunc(block_timestamp,'second') as seconds,
    count(DISTINCT tx_hash) as txns
    from sei
    group by 1
    )

    select trunc(seconds,'day') as daily,
    avg(txns) as "Avg TPS",
    median(txns) as "Median TPS",
    max(txns) as "Max TPS"
    from txns
    group by 1
    order by 1 asc


    Last run: about 5 hours ago
    DAILY
    Avg TPS
    Median TPS
    Max TPS
    1
    2025-05-05 00:00:00.00010.0025238232
    2
    2025-05-06 00:00:00.0009.2356238109
    3
    2025-05-07 00:00:00.0009.1208338208
    4
    2025-05-08 00:00:00.00011.48026910251
    5
    2025-05-09 00:00:00.00011.1317869223
    6
    2025-05-10 00:00:00.0008.5449097199
    7
    2025-05-11 00:00:00.0006.9041925297
    8
    2025-05-12 00:00:00.0008.5010057233
    9
    2025-05-13 00:00:00.00010.2818999200
    10
    2025-05-14 00:00:00.00013.5888729249
    11
    2025-05-15 00:00:00.00015.83140514420
    12
    2025-05-16 00:00:00.00011.35782810135
    13
    2025-05-17 00:00:00.00010.0725948100
    14
    2025-05-18 00:00:00.0007.9559046155
    15
    2025-05-19 00:00:00.00011.7551959174
    16
    2025-05-20 00:00:00.00010.6638157183
    17
    2025-05-21 00:00:00.0009.9947588182
    18
    2025-05-22 00:00:00.00010.0530867182
    19
    2025-05-23 00:00:00.00012.0517769160
    20
    2025-05-24 00:00:00.00011.3682189227
    31
    1KB
    11s