mempool_

#

Events from the execution layer p2p network

Availability

#

• EthPandaOps Clickhouse
• Public Parquet Files

Tables

#

• mempool_transaction

mempool_transaction

#

Each row represents a transaction that was seen in the mempool by a sentry client. Sentries can report the same transaction multiple times if it has been long enough since the last report.

Availability

#

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2023-07-22 to 2024-12-11
• holesky: 2024-01-08 to 2024-12-11
• sepolia: 2024-01-08 to 2024-12-11

Examples

#

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/mempool_transaction/2024/12/6.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.mempool_transaction FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

echo """
    SELECT
        *
    FROM default.mempool_transaction FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

#