hessTPS Max and Median
    Updated 2025-03-16
    with axelar as ( select trunc(block_timestamp,'second') as second,
    count(distinct tx_id) as tps
    from axelar.core.fact_transactions
    group by 1)

    select trunc(second,'week') as Date,
    avg(tps) as Avg_tps,
    median(tps) as median_tps,
    max(tps) as max_tps
    from axelar
    group by 1
    order by 1 asc
    Last run: about 1 month ago
    DATE
    AVG_TPS
    MEDIAN_TPS
    MAX_TPS
    1
    2021-12-20 00:00:00.0004.692459510
    2
    2021-12-27 00:00:00.0004.92906655
    3
    2022-01-03 00:00:00.0004.715708119
    4
    2022-01-10 00:00:00.00010.7886881043
    5
    2022-01-17 00:00:00.0005.130341160
    6
    2022-01-24 00:00:00.0007.5918252120
    7
    2022-01-31 00:00:00.00010.2680433252
    8
    2022-02-07 00:00:00.00015.1253115165
    9
    2022-02-14 00:00:00.00016.3107455148
    10
    2022-02-21 00:00:00.00018.78058810148
    11
    2022-02-28 00:00:00.00014.7447966141
    12
    2022-03-07 00:00:00.00012.7349824160
    13
    2022-03-14 00:00:00.0007.4617141136
    14
    2022-03-21 00:00:00.0005.120019144
    15
    2022-03-28 00:00:00.0004.721899150
    16
    2022-04-04 00:00:00.0004.670674150
    17
    2022-04-11 00:00:00.0004.522938146
    18
    2022-04-18 00:00:00.0004.105167145
    19
    2022-04-25 00:00:00.0005.512348151
    20
    2022-05-02 00:00:00.0008.93137251
    ...
    169
    7KB
    30s