Xatu - MEV Relay events
mev_relay_ #
Events derived from MEV relays
Availability #
- Public Parquet Files
- EthPandaOps Clickhouse
Tables #
mev_relay_bid_trace #
Contains MEV relay block bids data.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2024-09-16
to2024-09-16
- holesky:
2024-09-16
to2024-09-16
- sepolia:
2024-09-16
to2024-09-16
Example - Parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/mev_relay_bid_trace/YYYY/MM/DD.parquet
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query \
"SELECT * \
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/mev_relay_bid_trace/2024/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host \
clickhouse/clickhouse-server clickhouse client -q \
"SELECT \
* \
FROM default.mev_relay_bid_trace FINAL \
WHERE \
slot_start_date_time >= NOW() - INTERVAL '1 HOUR' \
LIMIT 10"
Example - EthPandaOps Clickhouse #
Note:
FINAL
should be used when querying this table
curl -G "https://clickhouse.analytics.production.platform.ethpandaops.io" \
-u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" \
--data-urlencode "query= \
SELECT \
* \
FROM default.mev_relay_bid_trace FINAL \
WHERE \
slot_start_date_time >= NOW() - INTERVAL '1 HOUR' \
LIMIT 3 \
FORMAT Pretty \
"
Columns #
Name | Type | Description |
---|---|---|
updated_date_time | DateTime |
Timestamp when the record was last updated |
event_date_time | DateTime64(3) |
When the bid was fetched |
slot | UInt32 |
Slot number within the block bid |
slot_start_date_time | DateTime |
The start time for the slot that the bid is for |
epoch | UInt32 |
Epoch number derived from the slot that the bid is for |
epoch_start_date_time | DateTime |
The start time for the epoch that the bid is for |
wallclock_request_slot | UInt32 |
The wallclock slot when the request was sent |
wallclock_request_slot_start_date_time | DateTime |
The start time for the slot when the request was sent |
wallclock_request_epoch | UInt32 |
The wallclock epoch when the request was sent |
wallclock_request_epoch_start_date_time | DateTime |
The start time for the wallclock epoch when the request was sent |
requested_at_slot_time | UInt32 |
The time in the slot when the request was sent |
response_at_slot_time | UInt32 |
The time in the slot when the response was received |
relay_name | String |
The relay that the bid was fetched from |
parent_hash | FixedString(66) |
The parent hash of the bid |
block_number | UInt64 |
The block number of the bid |
block_hash | FixedString(66) |
The block hash of the bid |
builder_pubkey | String |
The builder pubkey of the bid |
proposer_pubkey | String |
The proposer pubkey of the bid |
proposer_fee_recipient | FixedString(42) |
The proposer fee recipient of the bid |
gas_limit | UInt64 |
The gas limit of the bid |
gas_used | UInt64 |
The gas used of the bid |
value | UInt256 |
The transaction value in float64 |
num_tx | UInt32 |
The number of transactions in the bid |
timestamp | Int64 |
The timestamp of the bid |
timestamp_ms | Int64 |
The timestamp of the bid in milliseconds |
optimistic_submission | Bool |
Whether the bid was optimistic |
meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
meta_network_name | LowCardinality(String) |
Ethereum network name |
meta_labels | Map(String, String) |
Labels associated with the event |
mev_relay_proposer_payload_delivered #
Contains MEV relay proposer payload delivered data.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2024-09-16
to2024-09-16
- holesky:
2024-09-16
to2024-09-16
- sepolia:
2024-09-16
to2024-09-16
Example - Parquet file #
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query \
"SELECT * \
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/mev_relay_proposer_payload_delivered/2024/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host \
clickhouse/clickhouse-server clickhouse client -q \
"SELECT \
* \
FROM default.mev_relay_proposer_payload_delivered FINAL \
WHERE \
slot_start_date_time >= NOW() - INTERVAL '1 HOUR' \
LIMIT 10"
Example - EthPandaOps Clickhouse #
Note:
FINAL
should be used when querying this table
curl -G "https://clickhouse.analytics.production.platform.ethpandaops.io" \
-u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" \
--data-urlencode "query= \
SELECT \
* \
FROM default.mev_relay_proposer_payload_delivered FINAL \
WHERE \
slot_start_date_time >= NOW() - INTERVAL '1 HOUR' \
LIMIT 3 \
FORMAT Pretty \
"
Columns #
Name | Type | Description |
---|---|---|
updated_date_time | DateTime |
Timestamp when the record was last updated |
event_date_time | DateTime64(3) |
When the payload was delivered |
slot | UInt32 |
Slot number within the payload |
slot_start_date_time | DateTime |
The start time for the slot that the bid is for |
epoch | UInt32 |
Epoch number derived from the slot that the bid is for |
epoch_start_date_time | DateTime |
The start time for the epoch that the bid is for |
wallclock_slot | UInt32 |
The wallclock slot when the request was sent |
wallclock_slot_start_date_time | DateTime |
The start time for the slot when the request was sent |
wallclock_epoch | UInt32 |
The wallclock epoch when the request was sent |
wallclock_epoch_start_date_time | DateTime |
The start time for the wallclock epoch when the request was sent |
block_number | UInt64 |
The block number of the payload |
relay_name | String |
The relay that delivered the payload |
block_hash | FixedString(66) |
The block hash associated with the payload |
proposer_pubkey | String |
The proposer pubkey that received the payload |
builder_pubkey | String |
The builder pubkey that sent the payload |
proposer_fee_recipient | FixedString(42) |
The proposer fee recipient of the payload |
gas_limit | UInt64 |
The gas limit of the payload |
gas_used | UInt64 |
The gas used by the payload |
num_tx | UInt32 |
The number of transactions in the payload |
meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
meta_network_name | LowCardinality(String) |
Ethereum network name |
meta_labels | Map(String, String) |
Labels associated with the event |