mevprotocol_v1_ethereum

Tables

MevEth_Deposit_event

Deposit events from the MevEth liquid staking token contract on Ethereum, recording ETH stakes converted to mevETH shares with depositor addresses and amounts. Used for tracking user deposits into the MEV Protocol staking vault and analyzing share-to-asset conversion rates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_caller	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	0x5877bf640e6b65710f11000b5fee5626377a69ad	110000000000000000	0x5877bf640e6b65710f11000b5fee5626377a69ad	110000000000000000	154	18472080	2023-10-31T19:05:23.000Z	0x72291e3d9ff24000ccf0c9d60beae54c80f086623d27e874de8b3730cbeb93ea
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	0x090e058942e62a428c506af4b06dc37318b9cdc8	10000000000000000	0x090e058942e62a428c506af4b06dc37318b9cdc8	10000000000000000	146	18467517	2023-10-31T03:44:35.000Z	0x051aa2268b884d2e5d14b0dafaa662c78063d608faf65a982b3b43f99588cf2b
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	0xa4a2ffe1538f429e8d5a21adab35085f680b1a4a	180000000000000000	0xa4a2ffe1538f429e8d5a21adab35085f680b1a4a	180000000000000000	191	18591742	2023-11-17T12:57:23.000Z	0x1dccc20b4940d37ae0f698e6a29b7e86f83747aa6a9a5dcc4a564245f0b5dfdc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mevprotocol_v1_ethereum.MevEth_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MevEth_deposit_function

ETH deposit transactions into the MevEth liquid staking protocol on Ethereum, recording ETH amounts deposited and mevETH shares minted to receiver addresses. Enables analysis of staking inflows, share-to-asset exchange rates, and user deposit patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`out_shares`	`STRING`	Number of shares issued or burned as a result of the transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

gas	value	status	gas_used	in_assets	signature	out_shares	to_address	in_receiver	block_number	from_address	block_timestamp	transaction_hash
126537	102000000000000000	true	84358	102000000000000000	0x6e553f65	101216675566109289	0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	0x76cf98ef4facc8590b4a0b896e8fb6f7d5f999af	18958671	0x76cf98ef4facc8590b4a0b896e8fb6f7d5f999af	2024-01-08T00:09:59.000Z	0x6785cb41edfdddfc847ffc60d4ccb6945dabe4923f8a1dbfbccacb4542887c92
126501	250000000000000000	true	84334	250000000000000000	0x6e553f65	250000000000000000	0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	0x176ce2bef56c165400d017ba400088446d7c2fd7	18482268	0x176ce2bef56c165400d017ba400088446d7c2fd7	2023-11-02T05:17:59.000Z	0x2085ab391b292888948a17c4572c3826543b7f8d1989c6d1f2f73584d94e8846
126537	2000000000000000000	true	84358	2000000000000000000	0x6e553f65	1984654928449073674	0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	0x885a2fd4eb68e717dfc89e8cf2c42b138ca936aa	18850743	0x885a2fd4eb68e717dfc89e8cf2c42b138ca936aa	2023-12-23T19:58:11.000Z	0x9045e8657e707983e98e703cc6bdff7bddca05c49c3adfd8b6a2873bc0248088

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mevprotocol_v1_ethereum.MevEth_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MevEth_Rewards_event

Rewards distribution events from the MevEth liquid staking protocol on Ethereum, capturing ETH rewards sent to the protocol contract from MEV (Maximal Extractable Value) and staking operations. Used for tracking protocol revenue flows and reward distribution patterns to stakers.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	173592000000000000000	0x617c8de5bde54ffbb8d92716cc947858ca38f582	203	18732861	2023-12-07T07:14:35.000Z	0xcc7197623bfca90e415167f77101b5032d2378316d9331a9a3ea5ddec5f4cbfa
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	388830831274877728	0x617c8de5bde54ffbb8d92716cc947858ca38f582	129	19288610	2024-02-23T06:49:35.000Z	0xe89580515a5174fff1feb8066bf6ae7b32760f6cec92552c1a15ed770b824b3e
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	7827602275470820823	0x617c8de5bde54ffbb8d92716cc947858ca38f582	408	19205590	2024-02-11T15:03:35.000Z	0x59e803a4b16b1ea6adad17ae332e7b13c57c84abbefea46608ca4dd7e37803b8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mevprotocol_v1_ethereum.MevEth_Rewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MevEth_Withdraw_event

Withdrawal events from the MEV Protocol’s mevETH liquid staking token on Ethereum, recording users redeeming shares for underlying ETH assets. Tracks share-to-asset conversion ratios for analyzing protocol yield and redemption activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_caller	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	0xc03d7825d2b3ec9d73d581802ab49301c4ebb4d5	251498832153438431	0xc03d7825d2b3ec9d73d581802ab49301c4ebb4d5	249592819468545107	264	0xc03d7825d2b3ec9d73d581802ab49301c4ebb4d5	18948397	2024-01-06T13:15:23.000Z	0x7ff5c8c4bf9a9f680b2acd8b97e4e3f10f7c534b845559ed527bd3554b980a7a
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	0xc03d7825d2b3ec9d73d581802ab49301c4ebb4d5	725498265986927591	0xc03d7825d2b3ec9d73d581802ab49301c4ebb4d5	719999992799999998	218	0xc03d7825d2b3ec9d73d581802ab49301c4ebb4d5	18948408	2024-01-06T13:17:47.000Z	0xd5df3a7bc3ee988a4b3263d60cd698d93be8ba45e84db1aeca4f0eb21e327e4e
0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	false	0x3cdfd2e8bc356054646cb2c91046c98be1a8ed61	49215438432923029294	0x3cdfd2e8bc356054646cb2c91046c98be1a8ed61	48908851218802044948	144	0x3cdfd2e8bc356054646cb2c91046c98be1a8ed61	18766146	2023-12-11T23:10:11.000Z	0x4c9e1a40aeda14f783c5e1aed4035974a69114f4959f90cb5caeb649f41bd7c6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mevprotocol_v1_ethereum.MevEth_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MevEth_withdraw_function

Withdrawal function calls from the MevEth liquid staking protocol on Ethereum, recording conversions of mevETH shares back to ETH assets. Contains owner addresses, asset and share amounts, and transaction details for analyzing unstaking activity and redemption patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`out_shares`	`STRING`	Number of shares issued or burned as a result of the transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

gas	status	gas_used	in_owner	in_assets	signature	out_shares	to_address	in_receiver	block_number	from_address	block_timestamp	transaction_hash
124839	true	92473	0xe2d27f6242e848d310b000cc355a4c1e470fe779	3486690584191899196	0xb460af94	3389719547635707498	0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	0xe2d27f6242e848d310b000cc355a4c1e470fe779	19858308	0xe2d27f6242e848d310b000cc355a4c1e470fe779	2024-05-13T03:07:23.000Z	0xf57a219707ee4383e3d8835a6ec4fb7d65aff282aa1d96f743bf943eebbb42dc
124865	true	92497	0x6e377e571b5976e56d88c7e9f367fb3ba7c00e7a	500000050000000001	0xb460af94	486094171381329313	0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	0x6e377e571b5976e56d88c7e9f367fb3ba7c00e7a	19858167	0x6e377e571b5976e56d88c7e9f367fb3ba7c00e7a	2024-05-13T02:39:11.000Z	0x2fe5509a9bc329b8bfc6e46356478db71f3ceeac4883f208dc27f6b097f2582e
170235	true	92473	0x3af637465aea69f009004283095b1569e764ecd9	5541340771252457556	0xb460af94	5357357343598187879	0x24ae2da0f361aa4be46b48eb19c91e02c5e4f27e	0x3af637465aea69f009004283095b1569e764ecd9	20224686	0x3af637465aea69f009004283095b1569e764ecd9	2024-07-03T08:07:11.000Z	0xdaed18ab0313d635ce226973ab65fb6b5cb80bceb553bdb911cffb33ea43be50

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mevprotocol_v1_ethereum.MevEth_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

MevEth_Deposit_event

MevEth_deposit_function

MevEth_Rewards_event

MevEth_Withdraw_event

MevEth_withdraw_function

​Tables

​MevEth_Deposit_event

​MevEth_deposit_function

​MevEth_Rewards_event

​MevEth_Withdraw_event

​MevEth_withdraw_function

Tables

MevEth_Deposit_event

MevEth_deposit_function

MevEth_Rewards_event

MevEth_Withdraw_event

MevEth_withdraw_function