base_v1_base

Tables

EntryPoint_AccountDeployed_event

ERC-4337 account abstraction deployment events from the EntryPoint contract on Base, recording smart contract wallet creation with associated factory, paymaster, and UserOperation hash. Used for analyzing account abstraction adoption, factory usage patterns, and sponsored wallet deployment 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_userOpHash`	`STRING`	Unique identifier hash for the user operation (UserOp) that triggered this account deployment in the ERC-4337 account abstraction system. Hex-encoded, 0x-prefixed 64-character string that links deployment events to specific bundled operations.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_factory`	`STRING`	Contract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
`in_paymaster`	`STRING`	Contract address of the paymaster sponsoring gas fees for this account deployment, following ERC-4337 standard. Zero address (0x000…000) indicates the account paid its own gas fees.

Sample Data

address	removed	in_sender	log_index	in_factory	block_number	in_paymaster	in_userOpHash	block_timestamp	transaction_hash
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0x1ffe4e4258aabc24c8b3aced02efa2e78bf0d393	26	0x15ba39375ee2ab563e8873c8390be6f2e2f50232	24327139	0x2faeb0760d4230ef2ac21496bb4f0b47d634fd4c	0x28117c1641f32ea08db9b5fb53e78cccb4521e00594bf9e7d69c78230fdc57c1	2024-12-29T03:40:25.000Z	0x8aea03ce5ddf92d030ef9fe1bf9e3cff96a1e2c092ed40c6d0ac3b5ddc46bf90
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0xbc669b4ebd17abac07bd8162aad39b048333840b	29	0x9406cc6185a346906296840746125a0e44976454	24350520	0x4fd9098af9ddcb41da48a1d78f91f1398965addc	0x776aae447faf49ec8383297668cf66647dd8b1a4269a0e303b032424d0cd0b05	2024-12-29T16:39:47.000Z	0x4e59a483d1e2c9bb905d8dac970617182b28c18e802e7821f76112603acbf09c
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0x44820b468f18babed566601a7a7c8146ba0c29db	30	0xb3f15a44f91a08a93a11c6fbf6a4933c623275fe	24322934	0x1c6ad754810b4385ec3c46b0340e2954350c3e00	0xcc7db38b93d5a778b8ba5b8170f4a25390abaabfb8b46600356578dc9a921afc	2024-12-29T01:20:15.000Z	0x7ef5d225b1e1ba651df5aaf2dc8dcc8369bc7e2d81e941839a68f1e4e1ca4d0c

Example Query

Query with partition filter

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

EntryPoint_BeforeExecution_event

ERC-4337 Account Abstraction EntryPoint contract events emitted before user operation execution on Base. Tracks the initialization phase of smart contract wallet transactions for analyzing account abstraction adoption and bundler 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.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	383	25141327	2025-01-17T00:00:01.000Z	0x89a67944efe41984f88cd5c32f0c5f6a164901350873438ce83d272606ace334
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	335	25141328	2025-01-17T00:00:03.000Z	0xfb86257039f901c99a28a18a960f6a26bf02187b914abba31a893fe0f15828dd
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	403	25141329	2025-01-17T00:00:05.000Z	0x53c911e2c3267db398e33b2cb3911c12bfedd0932863750debd34eae9c04d4ac

Example Query

Query with partition filter

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

EntryPoint_Deposited_event

Deposit events from ERC-4337 Account Abstraction EntryPoint contract on Base, tracking account stake deposits with cumulative total balances. Used for monitoring smart contract wallet funding and account abstraction paymaster deposit 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalDeposit`	`STRING`	Total deposit balance in wei for the account after this deposit event. String-formatted to preserve precision for large integer values common in ERC-4337 account abstraction deposits.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	in_totalDeposit	transaction_hash
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0	0x516032491ac3be1a4dff40007ad42ac94faa9b89	20735787	2024-10-07T00:28:41.000Z	4229797508366	0x35f5bf43aa0448b263f430dd4f033ee905df03a691e411b6763ccc9787d8dbda
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	2	0x126139d97d80d839d3511e600e8f191d21b0babe	20740951	2024-10-07T03:20:49.000Z	3490823258440	0x4496f5eb029b81cd891dcce5f46f0b2e2df77cc353aa96eb9455dd414e9cb21f
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	2	0x52b892c3083e778050248b899ac9324e3254df45	20773572	2024-10-07T21:28:11.000Z	1877800073760	0xfd55ed6de0431d881484c47722f5f90da4b6e312b4e400d313f54cc2857341cf

Example Query

Query with partition filter

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

EntryPoint_SignatureAggregatorChanged_event

No description available.

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_aggregator`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

EntryPoint_StakeLocked_event

ERC-4337 account abstraction stake deposit events on Base, capturing when paymaster or bundler accounts lock collateral in the EntryPoint contract. Used for tracking security deposits required to participate in UserOperation execution with stake amounts and unlock delay periods (typically 86400 seconds/24 hours).

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalStaked`	`STRING`	Total amount of stake locked by the account in the EntryPoint contract, denominated in wei (smallest unit of ETH). Values typically range from fractional ETH (1 wei) to full ETH (1e18 wei), representing collateral for ERC-4337 account abstraction operations.
`in_unstakeDelaySec`	`STRING`	Time period in seconds that staked funds must remain locked before withdrawal. Commonly set to 86400 (1 day) but can vary from 1 second to several months.

Sample Data

address	removed	in_account	block_number	in_totalStaked	block_timestamp	transaction_hash	in_unstakeDelaySec
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0x2bd45d293f1e3b790f2923fb36782170b559d84c	2671088	100000000000000000	2023-08-15T20:32:03.000Z	0x9fd0a11edb6f59ba3ba1145738c2e2752c4c2d30fa9f405e03be1a698850aabf	86400
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0x4fd9098af9ddcb41da48a1d78f91f1398965addc	2670829	1000000000000000000	2023-08-15T20:23:25.000Z	0x4c9db95e22236f1674946020c87a3fac37b742e8dbae417c680d94ee5ef5b191	86400
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0xdad1b9318cdf364668cca9bb5a73f6bc83f8a705	12183506	1000000000000000	2024-03-23T01:12:39.000Z	0xd92cc5485b25c72b20f6697d68f8d3b7a7a503950104a3a23653c8b2d77a792e	86400

Example Query

Query with partition filter

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

EntryPoint_StakeUnlocked_event

StakeUnlocked events from ERC-4337 EntryPoint contract on Base, recording when account abstraction paycasters and bundlers unlock their staked ETH after initiating withdrawal. Tracks withdrawal timestamps for analyzing staking behavior and liquidity flows in smart account infrastructure.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_withdrawTime`	`STRING`	Unix timestamp (seconds since epoch) indicating when the staked funds become eligible for withdrawal from the EntryPoint contract. Unlocked stakes cannot be withdrawn until this time has passed.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	in_withdrawTime	transaction_hash
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	266	0x54c9c65f9467ad229a3716825cdd67a52422df28	17473187	2024-07-23T11:55:21.000Z	1721735731	0x029a509522c2ab334fd88c433f6e4736f3c42ed4e81516ac41d2cb16f9baa30e
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0	0xb9f2b3f0a936817ecdb8a090b81c4405aa1f39c7	5329057	2023-10-16T09:11:01.000Z	1697533861	0x25683177b6ddedba8f9f6db29d540a4e457356794a3a726ddfbb7393819148dc
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	128	0xefcc88c0c734d541b0189a573f1b881172b9c691	14945720	2024-05-25T23:46:27.000Z	1716767187	0x72a12366e5c281a6f6536fa7478efabd95f0bcfc25478361a81454b1c2ae5707

Example Query

Query with partition filter

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

EntryPoint_StakeWithdrawn_event

Stake withdrawal events from ERC-4337 EntryPoint contract (account abstraction) on Base, recording when accounts withdraw their staked ETH. Used to track paymaster and bundler stake management and security deposit movements.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_withdrawAddress`	`STRING`	Destination address that received the withdrawn stake from the ERC-4337 EntryPoint contract. Hex-encoded, 0x-prefixed 40-character Ethereum address.
`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	log_index	in_account	block_number	block_timestamp	transaction_hash	in_withdrawAddress
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	100000000000000000	62	0xeddcbedce214755e9997ba3740b050736d61d391	19045819	2024-08-28T21:36:25.000Z	0xd4872cf586ecf4d6b4a46b5353fb1b73fc50692afa7b0066b50b950c805211a6	0x56d0573c786d3dbad5669f6ded961031ad5badd9
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	100000000000000000	79	0xd940d8e46b549dfa8fa66520721ee89e07994a0a	19045834	2024-08-28T21:36:55.000Z	0x7bcbe054cd51937847d8a9aca2b481ebd4a1ba279da36f37d67f648dfb30ff8d	0x56d0573c786d3dbad5669f6ded961031ad5badd9
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	1000000000000000000	360	0xa270ef92c1e11f1c1f95753c2e56801e8125fa83	23314127	2024-12-05T16:53:21.000Z	0x3b064a9fdb2a5e44c4135d47f18aef8b7700fc65ec74d1a939ac62e16ce195a3	0x03793d1323b9e2aa1cf45de039e206012dd096c8

Example Query

Query with partition filter

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

EntryPoint_UserOperationEvent_event

ERC-4337 Account Abstraction user operation execution events from EntryPoint contracts on Base, tracking gas-abstracted transactions with sender addresses, paymaster usage, execution status, and actual gas costs. Used for analyzing smart account activity, paymaster subsidization patterns, and user operation success 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_userOpHash`	`STRING`	Unique identifier hash for the user operation (ERC-4337 account abstraction transaction). Each UserOp generates a distinct hash used for tracking and deduplication across the EntryPoint contract.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_paymaster`	`STRING`	Contract address of the paymaster that sponsored gas fees for this user operation, or zero address if self-paid. ERC-4337 paymasters enable gasless transactions by covering operation costs on behalf of users.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.
`in_actualGasCost`	`STRING`	Actual gas cost in wei paid for executing this user operation including the base fee and priority fee. This value represents the total transaction cost and may include paymaster subsidies.
`in_actualGasUsed`	`STRING`	Amount of gas units consumed executing this user operation. Represented as a string-encoded integer, typically ranging from tens of thousands to over a million gas units.

Sample Data

address	removed	in_nonce	in_sender	log_index	in_success	block_number	in_paymaster	in_userOpHash	block_timestamp	in_actualGasCost	in_actualGasUsed	transaction_hash
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	4	0x34a79e708b248d61f5211f831865b52e8e78b2e2	5	true	14748399	0x0000000000000000000000000000000000000000	0x139893bb3d284a09c4c3799be25d7d1fa321f9bdfc35ed724143d2b9530a4b19	2024-05-21T10:09:05.000Z	36669994979655	552505	0xe5a0f647e3b5616a5c5ddca1e350091d5b6c116c7f7c7b3822a405771b4041de
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	4	0x56996fa9552d13587d81d16ea8b44d6ec6b24753	5	true	14760353	0x9d6ac51b972544251fcc0f2902e633e3f9bd3f29	0xe330f2c31484621e521952d62e3da2c9bb79c8926b3de1c51a23e6e6db447679	2024-05-21T16:47:33.000Z	78177886316541	318681	0x3ec8195c7c59aa861df387c5a54b842646e213140fd7ebebdcb53ee104d01f73
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	3	0x56996fa9552d13587d81d16ea8b44d6ec6b24753	6	true	14760339	0x9d6ac51b972544251fcc0f2902e633e3f9bd3f29	0x3532ca6522501a6b8e9d1f228b73b3bf500582dd93d4d2b25ea8398ea0dafe44	2024-05-21T16:47:05.000Z	44824357675260	184020	0x2a67c22da83d63564e09473179807f92ce620ba370abf885370d5b2e1122ac57

Example Query

Query with partition filter

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

EntryPoint_UserOperationRevertReason_event

Failed ERC-4337 account abstraction user operations on Base, emitted by the EntryPoint contract when operations revert with encoded error reasons. Used for debugging smart account transaction failures and analyzing common revert patterns across bundled operations.

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_userOpHash`	`STRING`	Unique identifier hash for the user operation (UserOp) that reverted in the ERC-4337 account abstraction flow. Hex-encoded, 0x-prefixed 64-character string that corresponds to the keccak256 hash of the UserOp parameters.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_revertReason`	`STRING`	Hex-encoded error data explaining why the UserOperation failed during execution on the ERC-4337 EntryPoint contract. Contains ABI-encoded revert messages that can be decoded to reveal specific failure reasons like balance errors or execution failures.

Sample Data

address	removed	in_nonce	in_sender	log_index	block_number	in_userOpHash	block_timestamp	in_revertReason	transaction_hash
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	64	0xf17686d65f77782dffbb20916a8aa64bba3ea668	356	24826372	0x6d9bef2082c69c5d97d1f03e01b3833d81e4cb592942b795cafd53976ce05db4	2025-01-09T17:01:31.000Z	0x08c379a0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000035053430000000000000000000000000000000000000000000000000000000000	0x6d1786cc094a8024d88283e5cc608f7c32788194062b18a0d070d9c83ab4379f
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	0	0x005c6cfc3df154da61491ea8d400cf6f3238a1a5	265	24811231	0x2747828c0ce799d461e857d532102814139759794b6ef39696c4c311c65cec88	2025-01-09T08:36:49.000Z	0x08c379a00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000742414c2335303800000000000000000000000000000000000000000000000000	0xb14ed6cff40a0f4df87762d3f0ab209a335beb347dd8d8e84da202a08cfa3903
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	13	0x27f2ed3b4c8f3f6dfce165fefca7422f6a0a7bdf	191	24813618	0x2381c55891c141c8ad8c1e16bea4404fa0c6f09495a8e5b5199b251cadb71fb8	2025-01-09T09:56:23.000Z	0x08c379a00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000742414c2335303800000000000000000000000000000000000000000000000000	0xf665068747f3631101369853135be8d4ff78769e93e7eccec13509a70f14bf9b

Example Query

Query with partition filter

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

EntryPoint_Withdrawn_event

Withdrawal events from ERC-4337 Account Abstraction EntryPoint contract on Base, capturing when accounts withdraw deposited funds from the paymaster system. Records include account addresses, withdrawal amounts in wei, and destination addresses for tracking gas deposit management and fund flows.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_withdrawAddress`	`STRING`	Destination address receiving the withdrawn funds from the EntryPoint contract. Hex-encoded, 0x-prefixed 40-character EVM address where the withdrawn amount is transferred to.
`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	log_index	in_account	block_number	block_timestamp	transaction_hash	in_withdrawAddress
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	9995642979548502	298	0xc31ad82a88609ee88e87d382509060f3490a8eb2	21797828	2024-10-31T14:30:03.000Z	0xdbc3ac60b735c4b2e5cc5911ac6e25559e48e64f912253d122b06d96716ed377	0x1c0bd46c119a1655598989e96259e86ea8065223
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	2732748967978	295	0xc31ad82a88609ee88e87d382509060f3490a8eb2	21797828	2024-10-31T14:30:03.000Z	0xdbc3ac60b735c4b2e5cc5911ac6e25559e48e64f912253d122b06d96716ed377	0x1f1166e75c322b5442a41a72e6a057c2a39b44ee
0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789	false	4180354349230	453	0xc31ad82a88609ee88e87d382509060f3490a8eb2	21797536	2024-10-31T14:20:19.000Z	0xb8a22e3647da29b79b617c72db15682c752d435b917fe1c009994aab9ac9d181	0x1f1166e75c322b5442a41a72e6a057c2a39b44ee

Example Query

Query with partition filter

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

FeeDisburser_FeesDisbursed_event

Fee distribution events from Base’s FeeDisburser contract tracking total fees collected and amounts paid to Optimism. Used for analyzing protocol revenue sharing and fee accumulation patterns over time.

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__disbursementTime`	`STRING`	Unix timestamp representing when the fee disbursement occurred. Recorded as a string-encoded integer for precision, typically matching or closely following the block timestamp.
`in__paidToOptimism`	`STRING`	Amount of fees paid to Optimism from this disbursement event, denominated in wei (smallest unit of ETH). Represents the portion of total fees allocated to the Optimism network.
`in__totalFeesDisbursed`	`STRING`	Total amount of fees distributed in this disbursement event, denominated in wei (smallest unit of ETH). Values typically range from tens to hundreds of ETH equivalent when divided by 10^18.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in__paidToOptimism	in__disbursementTime	in__totalFeesDisbursed
0x09c7bad99688a55a2e83644bfaed09e62bdcccba	false	12	6912131	2023-11-22T00:40:09.000Z	0x3a3574e0c016687f24dbdf32396d47fdd77318cd91f9f33d8ba92e6738674bf0	879644337202127058	1700613609	35185773488085082324
0x09c7bad99688a55a2e83644bfaed09e62bdcccba	false	165	20389337	2024-09-29T00:00:21.000Z	0x1f6b5388db9226b4f1ce0d264352d50ae4ee54f016084729b2cb478371fe9661	29556087660323491094	1727568021	202976437686112772548
0x09c7bad99688a55a2e83644bfaed09e62bdcccba	false	12	9805329	2024-01-28T00:00:05.000Z	0xf4b381bba5bc10f7771e8a9d1f1d8e80319a48ea9d240a9ea53f178a7ea2a235	5257058278601968526	1706400005	183803017090348683015

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

EntryPoint_AccountDeployed_event

EntryPoint_BeforeExecution_event

EntryPoint_Deposited_event

EntryPoint_SignatureAggregatorChanged_event

EntryPoint_StakeLocked_event

EntryPoint_StakeUnlocked_event

EntryPoint_StakeWithdrawn_event

EntryPoint_UserOperationEvent_event

EntryPoint_UserOperationRevertReason_event

EntryPoint_Withdrawn_event

FeeDisburser_FeesDisbursed_event

​Tables

​EntryPoint_AccountDeployed_event

​EntryPoint_BeforeExecution_event

​EntryPoint_Deposited_event

​EntryPoint_SignatureAggregatorChanged_event

​EntryPoint_StakeLocked_event

​EntryPoint_StakeUnlocked_event

​EntryPoint_StakeWithdrawn_event

​EntryPoint_UserOperationEvent_event

​EntryPoint_UserOperationRevertReason_event

​EntryPoint_Withdrawn_event

​FeeDisburser_FeesDisbursed_event

Tables

EntryPoint_AccountDeployed_event

EntryPoint_BeforeExecution_event

EntryPoint_Deposited_event

EntryPoint_SignatureAggregatorChanged_event

EntryPoint_StakeLocked_event

EntryPoint_StakeUnlocked_event

EntryPoint_StakeWithdrawn_event

EntryPoint_UserOperationEvent_event

EntryPoint_UserOperationRevertReason_event

EntryPoint_Withdrawn_event

FeeDisburser_FeesDisbursed_event