hessAverage Daily TPS Per chain
    Updated 2024-02-14
    with zk_import as ( select * from (
    SELECT
    livequery.live.udf_api (
    'https://api.dune.com/api/v1/query/3145263/results?api_key=nPlMJ4JjTsMZcIo0C6kGSt5rpbcoXujU') as resp)
    ,
    table(FLATTEN(parse_json(resp:data:"result":"rows"))))
    ,
    final as (select TO_TIMESTAMP(value:"date") as date,
    'Zksync' as chain,
    value:"total_tx" as total_tx,
    total_tx/86400 as tps
    from zk_import
    where date >= '2023-08-15'
    UNION
    select date(block_timestamp) as date,
    'Sei' as chain,
    count(DISTINCT tx_id) as total_tx,
    total_tx/86400 as tps
    from sei.core.fact_transactions
    where block_timestamp::date >= '2023-08-15'
    and TX_SUCCEEDED = 'true'
    group by 1,2
    UNION
    select date(block_timestamp) as date,
    'Arbitrum' as chain,
    count(DISTINCT tx_hash) as total_tx,
    total_tx/86400 as tps
    from arbitrum.core.fact_transactions
    where block_timestamp::date >= '2023-08-15'
    and STATUS = 'SUCCESS'
    group by 1,2
    UNION
    select date(block_timestamp) as date,
    'Optimism' as chain,
    count(DISTINCT tx_hash) as total_tx,
    total_tx/86400 as tps
    Last run: 12 months ago
    DATE
    CHAIN
    TOTAL_TX
    TPS
    DATE_DAY
    PRIOR_DATE_DAY
    NEXT_DATE_DAY
    PRIOR_YEAR_DATE_DAY
    PRIOR_YEAR_OVER_YEAR_DATE_DAY
    DAY_OF_WEEK
    DAY_OF_WEEK_ISO
    DAY_OF_WEEK_NAME
    DAY_OF_WEEK_NAME_SHORT
    DAY_OF_MONTH
    DAY_OF_YEAR
    WEEK_START_DATE
    WEEK_END_DATE
    PRIOR_YEAR_WEEK_START_DATE
    PRIOR_YEAR_WEEK_END_DATE
    WEEK_OF_YEAR
    ISO_WEEK_START_DATE
    ISO_WEEK_END_DATE
    PRIOR_YEAR_ISO_WEEK_START_DATE
    PRIOR_YEAR_ISO_WEEK_END_DATE
    ISO_WEEK_OF_YEAR
    PRIOR_YEAR_WEEK_OF_YEAR
    PRIOR_YEAR_ISO_WEEK_OF_YEAR
    MONTH_OF_YEAR
    MONTH_NAME
    MONTH_NAME_SHORT
    MONTH_START_DATE
    MONTH_END_DATE
    PRIOR_YEAR_MONTH_START_DATE
    PRIOR_YEAR_MONTH_END_DATE
    QUARTER_OF_YEAR
    QUARTER_START_DATE
    QUARTER_END_DATE
    YEAR_NUMBER
    YEAR_START_DATE
    YEAR_END_DATE
    1
    2023-11-01 00:00:00.000Near
    1658829
    19.199412023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    2
    2023-11-01 00:00:00.000Atom
    82228
    0.9517132023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    3
    2023-11-01 00:00:00.000Arbitrum
    1016743
    11.7678592023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    4
    2023-11-01 00:00:00.000Avalanche
    180734
    2.0918292023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    5
    2023-11-01 00:00:00.000Optimism
    277239
    3.2087852023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    6
    2023-11-01 00:00:00.000Osmosis
    201317
    2.3300582023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    7
    2023-11-01 00:00:00.000Zksync
    626581
    7.2520949072023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    8
    2023-11-01 00:00:00.000Ethereum
    1079099
    12.4895722023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    9
    2023-11-01 00:00:00.000Base
    298151
    3.4508222023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    10
    2023-11-01 00:00:00.000Flow
    456405
    5.2824652023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    11
    2023-11-01 00:00:00.000Solana
    18968431
    219.5420252023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    12
    2023-11-01 00:00:00.000Polygon
    2453545
    28.3975122023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    13
    2023-11-01 00:00:00.000BSC
    3096903
    35.8437852023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    14
    2023-11-01 00:00:00.000Sei
    4034834
    46.6994682023-11-01 00:00:00.0002023-10-31 00:00:00.0002023-11-02 00:00:00.0002022-11-01 00:00:00.0002022-11-02 00:00:00.00043WednesdayWed13052023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    15
    2023-11-02 00:00:00.000Atom
    70042
    0.8106712023-11-02 00:00:00.0002023-11-01 00:00:00.0002023-11-03 00:00:00.0002022-11-02 00:00:00.0002022-11-03 00:00:00.00054ThursdayThu23062023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    16
    2023-11-02 00:00:00.000Sei
    3967099
    45.9154982023-11-02 00:00:00.0002023-11-01 00:00:00.0002023-11-03 00:00:00.0002022-11-02 00:00:00.0002022-11-03 00:00:00.00054ThursdayThu23062023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    17
    2023-11-02 00:00:00.000Arbitrum
    975238
    11.2874772023-11-02 00:00:00.0002023-11-01 00:00:00.0002023-11-03 00:00:00.0002022-11-02 00:00:00.0002022-11-03 00:00:00.00054ThursdayThu23062023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    18
    2023-11-02 00:00:00.000Osmosis
    173408
    2.0070372023-11-02 00:00:00.0002023-11-01 00:00:00.0002023-11-03 00:00:00.0002022-11-02 00:00:00.0002022-11-03 00:00:00.00054ThursdayThu23062023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    19
    2023-11-02 00:00:00.000Near
    1512458
    17.5053012023-11-02 00:00:00.0002023-11-01 00:00:00.0002023-11-03 00:00:00.0002022-11-02 00:00:00.0002022-11-03 00:00:00.00054ThursdayThu23062023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    20
    2023-11-02 00:00:00.000Ethereum
    1024653
    11.859412023-11-02 00:00:00.0002023-11-01 00:00:00.0002023-11-03 00:00:00.0002022-11-02 00:00:00.0002022-11-03 00:00:00.00054ThursdayThu23062023-10-29 00:00:00.0002023-11-04 00:00:00.0002022-10-30 00:00:00.0002022-11-05 00:00:00.000442023-10-30 00:00:00.0002023-11-05 00:00:00.0002022-10-31 00:00:00.0002022-11-06 00:00:00.00044444411NovemberNov2023-11-01 00:00:00.0002023-11-30 00:00:00.0002022-11-01 00:00:00.0002022-11-30 00:00:00.00042023-10-01 00:00:00.0002023-12-31 00:00:00.00020232023-01-01 00:00:00.0002023-12-31 00:00:00.000
    ...
    420
    273KB
    772s