blast_v2_ethereum - Token Terminal Docs

Tables

L1BlastBridge_bridgeERC20_function

ERC20 token bridge transactions from Ethereum mainnet (L1) to Blast L2, capturing deposit amounts, token addresses, gas parameters, and optional extraData for cross-chain transfers. Used for analyzing bridge volume, token flows, and user migration patterns between Ethereum and Blast.

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__localToken`	`STRING`	Contract address of the token on the source layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__remoteToken`	`STRING`	Contract address of the token on the destination layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	status	gas_used	signature	in__amount	to_address	block_number	from_address	in__extraData	in__localToken	block_timestamp	in__minGasLimit	in__remoteToken	transaction_hash
1647046	true	1028625	0x87087623	62000000000000000000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	20452631	0xdd353ba8867e80c1859e19bcdfe5679f50be5258	0x	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	2024-08-04T03:55:11.000Z	800000	0x0000000000000000000000000000000000000000	0x441edf345ce2159a49560e0bf0a0dfc7a3e5c1b7fd632882f9f95c2fdf819578
2169046	true	428254	0x87087623	29312220000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	20456369	0xfb076dc52e7b750fb7779811048993541db4e572	0x0000000000000000000000000000000000000000000000000000000000000000	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2024-08-04T16:24:59.000Z	800000	0x4300000000000000000000000000000000000003	0x668672fe71a9b4c1615a6657c2658b0e015b2ea794e3cefe7e668a728257d034
2169046	true	407446	0x87087623	4049000016	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	20456284	0x81050249d1d691b65b6fa36c186632cf7068ebff	0x0000000000000000000000000000000000000000000000000000000000000000	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2024-08-04T16:07:47.000Z	800000	0x4300000000000000000000000000000000000003	0xfd94255bff3707a0ad4d5b1f52005d58caac7a54f011dd80fc788cd664abc57d

Example Query

Query with partition filter

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

L1BlastBridge_bridgeERC20To_function

ERC-20 token bridge transactions from Ethereum L1 to Blast L2, capturing cross-chain token transfers with source/destination addresses, amounts, and gas parameters. Used for analyzing Blast bridge activity, token flow patterns, and user migration to the Layer 2 network.

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__localToken`	`STRING`	Contract address of the token on the source layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__remoteToken`	`STRING`	Contract address of the token on the destination layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	in__to	status	gas_used	signature	in__amount	to_address	block_number	from_address	in__extraData	trace_address	in__localToken	block_timestamp	in__remoteToken	transaction_hash
391167	0x7b51ed9cfd8986dd8888a293200ecbfa8dbd4f42	true	241810	0x540abf73	23428009015732804	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	23135621	0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d	0x	0,1	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	2025-08-14T00:10:11.000Z	0x0000000000000000000000000000000000000000	0x4f01cdac4da6eee0674228a46f3e524dfb04b399c5ea072c09297f9c116c21a6
318816	0x2472533e2a410c42a0275ccebee4b970698d2890	true	265202	0x540abf73	3165947164288215	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	23135754	0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d	0x	0,1	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	2025-08-14T00:36:59.000Z	0x0000000000000000000000000000000000000000	0xaa7d3949410571f29967c4e472404c857dbc61534c7f755f158a37d60fd73659
515034	0x4de9d5cefedda5f2f9cee3ea9bb992bfae0df767	true	288594	0x540abf73	157741959783867160	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	23138901	0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d	0x	0,1	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	2025-08-14T11:10:35.000Z	0x0000000000000000000000000000000000000000	0x2d8b8506fb8d5ffb2edcd92517d3624c7daa70189909bc896126e7a550a98c04

Example Query

Query with partition filter

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

L1BlastBridge_bridgeETH_function

ETH bridge transactions from Ethereum (L1) to Blast L2 through the official Blast bridge contract. Records individual bridgeETH function calls with deposit amounts, gas parameters, and execution status for analyzing L1-to-L2 migration 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.
`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__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__extraData	block_timestamp	in__minGasLimit	transaction_hash
890113	30000000000000000	true	152438	0x09fc8843	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	19316261	0x8b4a179fa7e828bf0789c82ce353a58a3e3f614d	0x	2024-02-27T03:39:47.000Z	200000	0x01ac77185f5ae172f3285e7a3a93f8c813135ca6e23bb21103dee28d0d563586
890113	100000000000	true	152438	0x09fc8843	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	19316238	0x8b4a179fa7e828bf0789c82ce353a58a3e3f614d	0x	2024-02-27T03:35:11.000Z	200000	0x6b36d2281cb1ad3923da7ec2eaf0f294d5ff63dd3dcb81cc90043706b4b36514
649713	600000000000000000	true	152438	0x09fc8843	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	19513325	0xb8f71484f9b8be8eff007057181eaf43569849c3	0x	2024-03-25T18:41:23.000Z	200000	0x9ac9818e2e3d7e708a7e881484d4e5d124ad8a72d41948e755dc71a8fedf820f

Example Query

Query with partition filter

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

L1BlastBridge_bridgeETHTo_function

ETH bridging transactions from Ethereum mainnet (L1) to Blast L2 network via the L1BlastBridge contract. Records include recipient addresses, ETH amounts, gas parameters, and optional extraData for analyzing cross-chain deposit patterns and bridge usage.

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__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	in__to	status	gas_used	signature	to_address	block_number	from_address	in__extraData	trace_address	block_timestamp	in__minGasLimit	transaction_hash
14178709	2604070038807075	0x594a109bab8d64e74f982c6f26d050fdac2ee0e7	true	223328	0xe11013dd	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	21707799	0xad3ede7d59d95ea0ae714dc48d9ac70944f7a5e0	0x	2,0,0	2025-01-26T09:28:35.000Z	200000	0x232c06158f83d10efc5e87fe710640d3603b9b0749f04eec311c1ca3fab35f01
14178709	7807246454488278	0x71ed50f754acc86fe89c64baa7a6c78a5a014ecb	true	466708	0xe11013dd	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	23029990	0xc0de31bd65f9220fa121be839909538ed2ec3133	0x	2,0,0	2025-07-30T05:55:11.000Z	200000	0xe17b81f7822cd187f870a13a305d3d97c45cc1f6f543f6746e384791aca9e9ae
847549	100000000000000	0x3f2157b3b183c369daed3085899efbf06fb0cf13	true	210998	0xe11013dd	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	20413931	0x3f2157b3b183c369daed3085899efbf06fb0cf13	0x723b6af9c31043618f499d7b57d2db44		2024-07-29T18:11:23.000Z	200000	0x0be89831293209ad01df22b29f0832e9547df2291767fc7f8307e1f3f7d9b881

Example Query

Query with partition filter

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

L1BlastBridge_ERC20BridgeFinalized_event

ERC20 token bridge completion events from Ethereum L1 to Blast L2, recording finalized withdrawals with token addresses, amounts, and recipient accounts. Useful for tracking cross-chain token flow and bridge usage patterns between Ethereum mainnet and Blast.

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_localToken`	`STRING`	Token address on the local chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_remoteToken`	`STRING`	Token address on the remote chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	in_localToken	in_remoteToken	block_timestamp	transaction_hash
0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	false	1100000000000000000	279	19329791	0x	0x6b175474e89094c44da98b954eedeac495271d0f	0x4300000000000000000000000000000000000003	2024-02-29T01:05:35.000Z	0x94943605d9b71a1b97066d3c5fa50b372e486c0082246f59b2ce7152fd7fd5f5
0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	false	3100000000000000000	120	19329203	0x	0x6b175474e89094c44da98b954eedeac495271d0f	0x4300000000000000000000000000000000000003	2024-02-28T23:07:47.000Z	0x2c33b8749ad20e2b4b6484c70ed2d87ae77708f788a307979119290ba5ecb592
0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	false	2100000000000000000	120	19315054	0x	0x6b175474e89094c44da98b954eedeac495271d0f	0x4300000000000000000000000000000000000003	2024-02-26T23:36:47.000Z	0x14e1ab663b8e42cbaf793d13c323ffe1159d12fe120a6938e16c667abd177dd2

Example Query

Query with partition filter

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

L1BlastBridge_ERC20BridgeInitiated_event

ERC20 token bridge initiation events from Ethereum L1 to Blast L2, capturing deposits with sender, recipient, token addresses (local and remote), and transfer amounts. Used for tracking cross-chain token flows and bridge volume analysis.

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_localToken`	`STRING`	Token address on the local chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_remoteToken`	`STRING`	Token address on the remote chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	in_localToken	in_remoteToken	block_timestamp	transaction_hash
0x8f36dc5348bf133941f07d4ea682354ca273d775	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x8f36dc5348bf133941f07d4ea682354ca273d775	false	3001638331454657126022	298	19336456	0x0000000000000000000000000000000000000000000000a27b2094062644da00	0xdac17f958d2ee523a2206206994597c13d831ec7	0x4300000000000000000000000000000000000003	2024-02-29T23:29:47.000Z	0x230b4af2b95e9c7f122cc7dccdd1486685a2bf717c29a15ce70419ca9c5979da
0xb3d29057fbf7cc83f498898fc516bfbdc71a4249	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0xb3d29057fbf7cc83f498898fc516bfbdc71a4249	false	20004782135691753534917	273	19335880	0x00000000000000000000000000000000000000000000043b1e334d6c50b00000	0xdac17f958d2ee523a2206206994597c13d831ec7	0x4300000000000000000000000000000000000003	2024-02-29T21:34:11.000Z	0xac3c47d6959cb0b7a41893fbde9b6cbf6f6f5d9194bb6a7031afb67b3c88e22c
0x3e7d1113c1813666b32a03c0d24c80914b5f7279	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3e7d1113c1813666b32a03c0d24c80914b5f7279	false	200101362601875074981	121	19336239	0x00000000000000000000000000000000000000000000000ad4c8316a0b0c0000	0xdac17f958d2ee523a2206206994597c13d831ec7	0x4300000000000000000000000000000000000003	2024-02-29T22:46:23.000Z	0xe81015420cac9ca28fe115746e26aafaa57f2f4d7c858029c731e62ed14478fd

Example Query

Query with partition filter

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

L1BlastBridge_ETHBridgeFinalized_event

ETH withdrawal completion events from Blast L2 bridge contract on Ethereum mainnet (Layer 1). Records finalized bridge transactions with sender, recipient addresses and ETH amounts in wei for tracking cross-chain fund 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	block_timestamp	transaction_hash
0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	false	40000000000000000	262	19330159	0x	2024-02-29T02:19:59.000Z	0xa9caf86d45083e17000e20b2a03204716077af01cda4c7d0c89d5dc0769645a5
0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	false	10000000000000000	498	19330194	0x	2024-02-29T02:26:59.000Z	0xabb3b1b3a6b0efc1873ccabf378c60f90d30d0f37137586cdb4e153dba60affd
0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	false	21000000000000000	92	19322121	0x	2024-02-27T23:20:11.000Z	0x9c449cb9482d066a4deeb25579c50d97c5224b938c3ebcbe3f5e52e31fdbb3a6

Example Query

Query with partition filter

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

L1BlastBridge_ETHBridgeInitiated_event

ETH deposit events from Ethereum mainnet (L1) to Blast L2 bridge, capturing sender and recipient addresses with bridged amounts in wei. Used for tracking cross-chain ETH flow and bridge usage 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.
`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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	block_timestamp	transaction_hash
0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x3c872e7bcadae75bcf7ddc8ba90a2b434a96ac41	false	100000000000000000	153	19302946	0x	2024-02-25T06:56:11.000Z	0xc9cbb6a8335d44c1d2ed8c4fbe566b2adb5bf38e1922864926e1b7da26c9d0a3
0xfc067852963970d0faf0ee3523a7e2b215a845a6	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0xfc067852963970d0faf0ee3523a7e2b215a845a6	false	1200000000000000000	256	19349613	0x	2024-03-02T19:36:35.000Z	0x6c57d6b6590c0e00e7610eb9fab9332ec232a0cbe150f93a61e0a3dc1392f838
0x2246688fc52b954795bc17f63b8a6bada9ca7419	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	0x2246688fc52b954795bc17f63b8a6bada9ca7419	false	1040000000000000000	256	19348474	0x	2024-03-02T15:47:47.000Z	0x2908087c5d949a2e44354db63c3da3e29848bcb2231fe2634da764ea4d299851

Example Query

Query with partition filter

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

L1BlastBridge_finalizeBridgeERC20_function

ERC20 token withdrawal completion records from Blast L2 to Ethereum mainnet through the L1 bridge contract. Tracks finalized bridge transfers with sender/recipient addresses, token amounts, and gas consumption for analyzing cross-chain asset 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.
`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__localToken`	`STRING`	Contract address of the token on the source layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__remoteToken`	`STRING`	Contract address of the token on the destination layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	in__to	status	gas_used	in__from	signature	in__amount	to_address	block_number	from_address	in__extraData	trace_address	in__localToken	block_timestamp	in__remoteToken	transaction_hash
1300380	0x47660f6662fa3f4c76406eaeb9a7489db280c6b3	true	154117	0x47660f6662fa3f4c76406eaeb9a7489db280c6b3	0x0166a07a	140000000000000000000000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	20098008	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,4,1,1	0x6b175474e89094c44da98b954eedeac495271d0f	2024-06-15T15:12:35.000Z	0x4300000000000000000000000000000000000003	0x4f8994c17a71ee1a788a51997ebf0a97109df34e3553845c6c5220a41e95d14d
1300392	0x47660f6662fa3f4c76406eaeb9a7489db280c6b3	true	154117	0x47660f6662fa3f4c76406eaeb9a7489db280c6b3	0x0166a07a	120000000000000000000000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	20098005	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,4,1,1	0x6b175474e89094c44da98b954eedeac495271d0f	2024-06-15T15:11:59.000Z	0x4300000000000000000000000000000000000003	0xd181c33ceabfd6bae7bed8d4efa82ce965faf8dd096d68f85e6b658bde1532fe
1299438	0xf2f9033bf4a156aa1290cba6a767636eb00ccd53	true	171217	0xf2f9033bf4a156aa1290cba6a767636eb00ccd53	0x0166a07a	100000000000000000000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	20099327	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,4,1,1	0x6b175474e89094c44da98b954eedeac495271d0f	2024-06-15T19:37:11.000Z	0x4300000000000000000000000000000000000003	0x3e203634d3e3bbe6a405f76ccd2dcf29541cfc92d87097d53bc417eef75234cf

Example Query

Query with partition filter

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

L1BlastBridge_finalizeBridgeETH_function

ETH withdrawal completions from Blast L2 to Ethereum mainnet through the L1BlastBridge contract. Records finalized bridge transactions with sender addresses, ETH amounts in wei, and execution status for analyzing withdrawal flows and user 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.
`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__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	in__to	status	gas_used	in__from	signature	in__amount	to_address	block_number	from_address	in__extraData	trace_address	block_timestamp	transaction_hash
584460	2520700000000000000	0x15adb409edeea389e5daf3a870e7eb2b15320ca4	true	25158	0x15adb409edeea389e5daf3a870e7eb2b15320ca4	0x1635f5fd	2520700000000000000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	21655188	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,5,1,1	2025-01-19T01:14:47.000Z	0x1ea0c84ecbc7933479a565ef1baf9fc6e820663ffc5a77ba9702160e50046bd5
584460	1066477000000000000	0x1788b7420b519e5b623d481597338ec1e4a57062	true	25158	0x1788b7420b519e5b623d481597338ec1e4a57062	0x1635f5fd	1066477000000000000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	21658943	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,5,1,1	2025-01-19T13:50:59.000Z	0xf6bd3babd42b3b4972f755f14e0829a992d04c2009b36e134941738a816e10e4
584495	4000000000000000000	0x369486abdeaf4c204d24b51b97323f5daa266767	true	25158	0x369486abdeaf4c204d24b51b97323f5daa266767	0x1635f5fd	4000000000000000000	0x3a05e5d33d7ab3864d53aaec93c8301c1fa49115	21657521	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,5,1,1	2025-01-19T09:04:59.000Z	0x6fbdb435af3ae7515ea8da27ca251d2bb85834c2ac1a51659a2cbcea6792d564

Example Query

Query with partition filter

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

L1StandardBridge_bridgeERC20_function

ERC-20 token bridge transactions from Ethereum mainnet (L1) to Blast L2, recording token deposits with local and remote token addresses, amounts, and gas parameters. Used for analyzing cross-chain token flows and bridge usage 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__localToken`	`STRING`	Contract address of the token on the source layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__remoteToken`	`STRING`	Contract address of the token on the destination layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	status	gas_used	signature	in__amount	to_address	block_number	from_address	in__extraData	in__localToken	block_timestamp	in__minGasLimit	in__remoteToken	transaction_hash
317799	true	195524	0x87087623	1000000000000000000	0x697402166fbf2f22e970df8a6486ef171dbfc524	21426003	0xa913b7666d2b554c6bacd3c4f4875dade813baba	0x	0x865377367054516e17014ccded1e7d814edc9ce4	2024-12-18T01:01:23.000Z	500000	0x8e38179d361402f6a94767757e807146609e9b3d	0x80987ef783691c3ba1e5d9d13c02bb076ae7d4930f3d360cdb37a346d6bd3b08
308327	true	199504	0x87087623	15099900000000000000000	0x697402166fbf2f22e970df8a6486ef171dbfc524	21426012	0xa913b7666d2b554c6bacd3c4f4875dade813baba	0x	0x865377367054516e17014ccded1e7d814edc9ce4	2024-12-18T01:03:11.000Z	500000	0x8e38179d361402f6a94767757e807146609e9b3d	0xc1e338b66ecca5462f77999f7300bff6824b684586264db9240084baba671ac5
750000	true	147839	0x87087623	695860728086485426859881	0x697402166fbf2f22e970df8a6486ef171dbfc524	19985018	0x4cb6f0ef0eeb503f8065af1a6e6d5dd46197d3d9	0x	0x808688c820ab080a6ff1019f03e5ec227d9b522b	2024-05-30T20:24:47.000Z	50000	0xb9dfcd4cf589bb8090569cb52fac1b88dbe4981f	0x2dce19b031003201edafced712fbabd273ee66b560f34c7f38afca168bdead8d

Example Query

Query with partition filter

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

L1StandardBridge_bridgeERC20To_function

ERC-20 token deposit transactions from Ethereum mainnet (L1) to Blast L2 via the L1StandardBridge contract. Contains token addresses, amounts, recipient details, and gas parameters for analyzing cross-chain ERC-20 transfer activity and bridge usage 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__localToken`	`STRING`	Contract address of the token on the source layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__remoteToken`	`STRING`	Contract address of the token on the destination layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	in__to	status	gas_used	signature	in__amount	to_address	block_number	from_address	in__extraData	trace_address	in__localToken	block_timestamp	in__minGasLimit	in__remoteToken	transaction_hash
305190	0x66e655f74887e50d2ffca66bdb48e1815d41e7ef	true	123039	0x540abf73	36398306672171193185	0x697402166fbf2f22e970df8a6486ef171dbfc524	19669928	0xbe1a8fe5cb3b7e50825cef73afdf29e3fc34de33	0x	8	0x2416092f143378750bb29b79ed961ab195cceea5	2024-04-16T18:48:35.000Z	1000	0x2416092f143378750bb29b79ed961ab195cceea5	0xc9a9c13c93852a97b3f5edd65f1f9c07ec762e73aad25f1f3c5db6e666ea6008
317052	0xc313d7913c479bd1abe564be348ac24463f968be	true	130513	0x540abf73	260556307110693258	0x697402166fbf2f22e970df8a6486ef171dbfc524	19664660	0xbe1a8fe5cb3b7e50825cef73afdf29e3fc34de33	0x	8	0x2416092f143378750bb29b79ed961ab195cceea5	2024-04-16T01:05:35.000Z	1000	0x2416092f143378750bb29b79ed961ab195cceea5	0xee5d4c8e50fd29f241c3f7b8a609850f4ec552074a2b8eccb25f207630caed29
419334	0x1e6f1da02c11008ec9669a9c297d1c85f6f76075	true	125151	0x540abf73	1759321816746023373	0x697402166fbf2f22e970df8a6486ef171dbfc524	19668435	0xbe1a8fe5cb3b7e50825cef73afdf29e3fc34de33	0x	8	0x2416092f143378750bb29b79ed961ab195cceea5	2024-04-16T13:47:11.000Z	1000	0x2416092f143378750bb29b79ed961ab195cceea5	0x50bda352731a96d034e1fc1ee26664cb1312b298b3b7e2fccf5a37d4bee20f66

Example Query

Query with partition filter

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

L1StandardBridge_bridgeETH_function

ETH deposits from Ethereum mainnet (Layer 1) to Blast Layer 2 via the L1StandardBridge contract. Used for tracking bridging volume, user adoption, and cross-chain ETH flow analysis.

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__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__extraData	block_timestamp	in__minGasLimit	transaction_hash
1465171	72000000000000000	true	213591	0x09fc8843	0x697402166fbf2f22e970df8a6486ef171dbfc524	19939125	0xad73b7ef900edbc134c80d3f4b068d2cb0da1708	0x	2024-05-24T10:24:11.000Z	500000	0x829b24bbc2f7e4d7aae7b41a6db4ff7ab89666092a1e655defe3e51747c05796
1464990	10000000000000000	true	240939	0x09fc8843	0x697402166fbf2f22e970df8a6486ef171dbfc524	19810688	0x6aba0ed665e66b69f8bed135f4817ff0b100fac6	0x	2024-05-06T11:16:59.000Z	500000	0xc48afc8040213046208dc53976b9591ab7337606ca66d7fff40cf2a0b44619cb
1464990	125000000000000000	true	263565	0x09fc8843	0x697402166fbf2f22e970df8a6486ef171dbfc524	19810739	0x6aba0ed665e66b69f8bed135f4817ff0b100fac6	0x	2024-05-06T11:27:11.000Z	500000	0xf9319d9756266ad256da286fb921a5f6f19a2769d58fdca478ce9d8f7e813ac5

Example Query

Query with partition filter

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

L1StandardBridge_bridgeETHTo_function

Ethereum Layer 1 (L1) to Blast Layer 2 (L2) ETH bridge deposit transactions using the Standard Bridge contract’s bridgeETHTo function. Tracks cross-chain ETH transfers with sender addresses, recipient addresses, amounts, gas parameters, and minimum gas limits for analyzing Blast network bridging 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.
`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__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	in__to	status	gas_used	signature	to_address	block_number	from_address	in__extraData	block_timestamp	in__minGasLimit	transaction_hash
673824	804200000000000000	0xd0ce021bceff33ca74c7b26a108fbbef75bc060d	true	613698	0xe11013dd	0x697402166fbf2f22e970df8a6486ef171dbfc524	20657564	0xd0ce021bceff33ca74c7b26a108fbbef75bc060d	0x7375706572627269646765	2024-09-01T18:38:35.000Z	200000	0xa9de12eb541b1167692374c1390c511aa2ec25722d247dffff92f187e1d49bf3
284360	10000000000000000	0x5e1905fcf7ba5a3c6d0ce944a24d700deb7daf5b	true	185101	0xe11013dd	0x697402166fbf2f22e970df8a6486ef171dbfc524	19806226	0x0fb213a1af101b1429e6ad3020ad92fb0d25eb1e	0x	2024-05-05T20:18:11.000Z	100000	0x30e98ff164587993e590aa2b0a91cd8e0051955cfeaab48f6c8fefceff5cd6fe
325858	302400000000000000	0xd0ce021bceff33ca74c7b26a108fbbef75bc060d	true	294453	0xe11013dd	0x697402166fbf2f22e970df8a6486ef171dbfc524	20398222	0xd0ce021bceff33ca74c7b26a108fbbef75bc060d	0x7375706572627269646765	2024-07-27T13:35:59.000Z	200000	0x7b5c6cdad89465dd8bce32e04684a9e1f6d1fba04c659fd055e805df5e899d59

Example Query

Query with partition filter

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

L1StandardBridge_depositERC20_function

ERC-20 token deposit transactions from Ethereum L1 to Blast L2 via the standard bridge contract. Tracks bridged token pairs, amounts, gas limits, and transaction status for analyzing cross-chain asset flows and bridge 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.
`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__l1Token`	`STRING`	Token contract address on the Layer 1 blockchain. Hex-encoded, 0x-prefixed, 42-character string.
`in__l2Token`	`STRING`	Token contract address on the Layer 2 blockchain. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	status	gas_used	signature	in__amount	to_address	in__l1Token	in__l2Token	block_number	from_address	in__extraData	block_timestamp	in__minGasLimit	transaction_hash
254771	true	208354	0x58a997f6	375120542231411284333077	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x808688c820ab080a6ff1019f03e5ec227d9b522b	0xb9dfcd4cf589bb8090569cb52fac1b88dbe4981f	21090972	0x65a8f07bd9a8598e1b5b6c0a88f4779dbc077675	0x00	2024-11-01T06:21:59.000Z	100000	0xb5c48209291ed18ace0cdef3d529c43061b1517905c3a2cf16aec0f8617b677f
200339	true	149672	0x58a997f6	535110519326173784819138	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x808688c820ab080a6ff1019f03e5ec227d9b522b	0xb9dfcd4cf589bb8090569cb52fac1b88dbe4981f	20127091	0x65a8f07bd9a8598e1b5b6c0a88f4779dbc077675	0x00	2024-06-19T16:50:47.000Z	100000	0x9edfb24e95439fb7bad75f5cdb35c63f1aa21eb917e97f8cb9ccadb470924ffb
211286	true	161359	0x58a997f6	22999117938808032078512	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x9625ce7753ace1fa1865a47aae2c5c2ce4418569	0x15d24de366f69b835be19f7cf9447e770315dd80	19710363	0x65a8f07bd9a8598e1b5b6c0a88f4779dbc077675	0x00	2024-04-22T10:32:59.000Z	100000	0x10c2f6b5513d3cd5d93e72a56284ae5b720d7202545ebbbbbc37483a9eeeb77a

Example Query

Query with partition filter

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

L1StandardBridge_depositERC20To_function

ERC-20 token deposit transactions from Ethereum (L1) to Blast (L2) via the standard bridge contract, capturing token addresses on both chains, deposit amounts, recipient addresses, and gas parameters. Used for tracking cross-chain token flows and bridge activity between Ethereum mainnet and Blast Layer 2.

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__l1Token`	`STRING`	Token contract address on the Layer 1 blockchain. Hex-encoded, 0x-prefixed, 42-character string.
`in__l2Token`	`STRING`	Token contract address on the Layer 2 blockchain. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	in__to	status	gas_used	signature	in__amount	to_address	in__l1Token	in__l2Token	block_number	from_address	in__extraData	trace_address	block_timestamp	in__minGasLimit	transaction_hash
800000	0xd4a2aee94345bfa6aa1bdd3b95e8dc9d14b2ea19	true	631154	0x838b2520	2959288138098055732789248	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x808688c820ab080a6ff1019f03e5ec227d9b522b	0xb9dfcd4cf589bb8090569cb52fac1b88dbe4981f	22285568	0xd4a2aee94345bfa6aa1bdd3b95e8dc9d14b2ea19	0x00		2025-04-17T01:54:35.000Z	200000	0x8107ea140e38dd74b120eb8b1dfcb47d7fc69f42c4307a208481273e11ae218f
1012458	0xd0ce021bceff33ca74c7b26a108fbbef75bc060d	true	632376	0x838b2520	45333000000000000000000	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x9625ce7753ace1fa1865a47aae2c5c2ce4418569	0x15d24de366f69b835be19f7cf9447e770315dd80	22290250	0xd0ce021bceff33ca74c7b26a108fbbef75bc060d	0x00		2025-04-17T17:36:59.000Z	200000	0x6424a7b3a2d82ef0227bf41d7a3ab8ea6ea10f1812d2cfa0d0042b435f9bc6e5
982151	0x000f9764a2c9345df184d19a2cb935a0857af000	true	905143	0x838b2520	151945259673870000000000	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x9625ce7753ace1fa1865a47aae2c5c2ce4418569	0x15d24de366f69b835be19f7cf9447e770315dd80	23405841	0x6ddf3999a391d2160d5dbf8515dedf513e8acdaf	0x	3	2025-09-20T17:43:47.000Z	500000	0xf85e2fa48eab144a4d87a647bcd1ad0e462d39ff6d2ae0a343707c8df6195e71

Example Query

Query with partition filter

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

L1StandardBridge_depositETH_function

ETH deposit transactions from Ethereum mainnet (L1) to Blast L2 via the standard bridge contract. Used for tracking cross-chain ETH transfer volumes, gas costs, and bridge utilization 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__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__extraData	block_timestamp	in__minGasLimit	transaction_hash
800000	5441571495971112000	true	155295	0xb1a1a882	0x697402166fbf2f22e970df8a6486ef171dbfc524	19663779	0xf70da97812cb96acdf810712aa562db8dfa3dbef	0x	2024-04-15T22:07:11.000Z	100000	0xf5f3396a6e8df5ac9027f576ef1d91b67c620d7cc51be10f4e47f043c3767aaf
643820	32219765533340525000	true	193681	0xb1a1a882	0x697402166fbf2f22e970df8a6486ef171dbfc524	21114010	0xf70da97812cb96acdf810712aa562db8dfa3dbef	0x	2024-11-04T11:33:11.000Z	100000	0xc6853843c495f310f6bdc53036a9e3f580900386e415fecad15fd43220f5e7ff
643820	35339807761248686000	true	302557	0xb1a1a882	0x697402166fbf2f22e970df8a6486ef171dbfc524	20154031	0xf70da97812cb96acdf810712aa562db8dfa3dbef	0x	2024-06-23T11:16:11.000Z	100000	0xf52d1ad31a9519e1a46166c2615fc2604e624048f53eb32761897a34ab6437f4

Example Query

Query with partition filter

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

L1StandardBridge_depositETHTo_function

ETH deposits from Ethereum mainnet (L1) to Blast L2 via the standard bridge contract, capturing bridging transactions with sender/recipient addresses and ETH amounts. Used for tracking cross-chain ETH flows and bridge activity analysis.

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__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__minGasLimit`	`STRING`	Minimum gas limit required for executing the transaction on the destination layer. String-encoded integer representing the guaranteed computational units allocated for cross-layer message execution.
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	in__to	status	gas_used	signature	to_address	block_number	from_address	in__extraData	trace_address	block_timestamp	in__minGasLimit	transaction_hash
627572	172064804081309750000	0x07ae8551be970cb1cca11dd7a11f47ae82e70e67	true	145394	0x9a2ac6d5	0x697402166fbf2f22e970df8a6486ef171dbfc524	21400422	0xa679201903847f3723dc88ca7530c8b665bc51a5	0x	2	2024-12-14T11:21:11.000Z	200000	0x4a63c0fb241ba4c961284a955ac1d9d240bd42489a1f80562fec0c08f735327e
628158	482093524015185	0x9a8f92a830a5cb89a3816e3d267cb7791c16b04d	true	133840	0x9a2ac6d5	0x697402166fbf2f22e970df8a6486ef171dbfc524	21594883	0x64668fbd18b967b46dd22dc8675134d91efedd8d	0x	2	2025-01-10T15:10:35.000Z	200000	0x68a7fd5692a77316ddc71350f090d806fa3c33cdbf093a7ac2aaffb37b5e9753
7210056	9975000000000000	0x2d509190ed0172ba588407d4c2df918f955cc6e1	true	590027	0x9a2ac6d5	0x697402166fbf2f22e970df8a6486ef171dbfc524	23517869	0xc186fa914353c44b2e33ebe05f21846f1048beda	0x	23,0,1	2025-10-06T09:34:47.000Z	200000	0x399fde4dbbc3ea33d0045e370adc7112fdfe6e782a84b3bea8366ea526b94c53

Example Query

Query with partition filter

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

L1StandardBridge_ERC20BridgeFinalized_event

ERC20 token bridge completion events from Ethereum L1 to Blast L2, capturing finalized withdrawals with token addresses, amounts, and recipient accounts. Used for tracking cross-chain token flows and analyzing bridge liquidity patterns between Ethereum mainnet and Blast.

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_localToken`	`STRING`	Token address on the local chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_remoteToken`	`STRING`	Token address on the remote chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	in_localToken	in_remoteToken	block_timestamp	transaction_hash
0x8b4a179fa7e828bf0789c82ce353a58a3e3f614d	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x8b4a179fa7e828bf0789c82ce353a58a3e3f614d	false	10000000000	141	19331841	0x	0x6b175474e89094c44da98b954eedeac495271d0f	0xee311c08162283b1493027b8ffb5293e7f2fd701	2024-02-29T08:00:23.000Z	0xece31c7ea6d9d295ce2dd77a13f194d33e185e9b1da14683846577a3ea4631ff
0xa62d39ae23179d0cd49b0adafaf577f5a5b4538e	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xa62d39ae23179d0cd49b0adafaf577f5a5b4538e	false	10000	136	19580114	0x	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xf7bc58b8d8f97adc129cfc4c9f45ce3c0e1d2692	2024-04-04T04:47:35.000Z	0xc2d7bbb4249eca1b8b181c0c0bded189a4f20ac9b30a013dc69dfadf91f7ab8c
0xcc1c2a5c41796282d492b67a196bd92364de060b	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xcc1c2a5c41796282d492b67a196bd92364de060b	false	74986800	280	19679908	0x	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xf7bc58b8d8f97adc129cfc4c9f45ce3c0e1d2692	2024-04-18T04:18:35.000Z	0x0f8f325ffdc2a97024a8e07b2e75e3327e0f0cdb754e77589b07cb68aebac196

Example Query

Query with partition filter

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

L1StandardBridge_ERC20BridgeInitiated_event

ERC20 token bridge initiation events from Ethereum Layer 1 (L1) to Blast Layer 2 (L2), capturing deposit transactions with sender, recipient, token addresses (local and remote mappings), and transfer amounts. Used for analyzing cross-chain token flows and bridge volume between Ethereum mainnet and Blast.

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_localToken`	`STRING`	Token address on the local chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_remoteToken`	`STRING`	Token address on the remote chain in the bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	in_localToken	in_remoteToken	block_timestamp	transaction_hash
0xb8f03bd8c3f9e19c8d03d7500af08777983a9591	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xb8f03bd8c3f9e19c8d03d7500af08777983a9591	false	20000000000000000000000	288	19360838	0x00	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	2024-03-04T09:15:11.000Z	0x36d511016e1a9933c606527e079c0cea4bdce714a3b687958100c8a07c9b3cce
0xb8f03bd8c3f9e19c8d03d7500af08777983a9591	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xb8f03bd8c3f9e19c8d03d7500af08777983a9591	false	20000000000000000000000	495	19360857	0x00	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	2024-03-04T09:18:59.000Z	0xc8b2198b9bc5add2f279de7f0cf62d1303ca5507273f4dec10d24844c8bc1b3c
0xb8f03bd8c3f9e19c8d03d7500af08777983a9591	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xb8f03bd8c3f9e19c8d03d7500af08777983a9591	false	63302000000000000000000	294	19360878	0x00	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	2024-03-04T09:23:11.000Z	0xecdd5e6ffc42fde81e67e21792bf379a3e990b326c239414e3531b2c717999cf

Example Query

Query with partition filter

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

L1StandardBridge_ERC20DepositInitiated_event

ERC20 token deposit events from Ethereum Layer 1 to Blast Layer 2 via the standard bridge contract, capturing cross-chain token transfers with sender, recipient, token addresses, and amounts. Used for tracking bridge activity, token migration flows, and user adoption patterns between Ethereum mainnet and Blast.

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_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
`in_l2Token`	`STRING`	Contract address of the token on Layer 2. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	in_l1Token	in_l2Token	block_number	in_extraData	block_timestamp	transaction_hash
0x067782a3fc95f1393f83e25f9a3fd7b33af66a34	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x067782a3fc95f1393f83e25f9a3fd7b33af66a34	false	69001000000000000000000	361	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	19342296	0x	2024-03-01T19:04:23.000Z	0xcef635875be99e9afa1c64d87b3e7e3b816a1eda66f6579bc67587889195f755
0x067782a3fc95f1393f83e25f9a3fd7b33af66a34	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x067782a3fc95f1393f83e25f9a3fd7b33af66a34	false	60240000000000000000000	197	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	19343404	0x	2024-03-01T22:46:23.000Z	0x3f9d1c4bfac0e5f1f297009fecfef28d0dc18d83b2a3c181e394bb5e7cdc5417
0x067782a3fc95f1393f83e25f9a3fd7b33af66a34	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x067782a3fc95f1393f83e25f9a3fd7b33af66a34	false	174402000000000000000000	172	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	19338162	0x	2024-03-01T05:12:59.000Z	0x544ce0b0a4057fa0c47e535f08a9449c689e4f414b124fdf127f1ba92d69d590

Example Query

Query with partition filter

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

L1StandardBridge_ERC20WithdrawalFinalized_event

ERC-20 token withdrawal completion events from Blast L2 to Ethereum mainnet via the L1StandardBridge contract. Records finalized bridge transfers with L1/L2 token addresses, amounts, and recipient accounts for analyzing cross-chain withdrawal activity and token 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_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
`in_l2Token`	`STRING`	Contract address of the token on Layer 2. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	in_l1Token	in_l2Token	block_number	in_extraData	block_timestamp	transaction_hash
0x8b4a179fa7e828bf0789c82ce353a58a3e3f614d	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x8b4a179fa7e828bf0789c82ce353a58a3e3f614d	false	10000000000	140	0x6b175474e89094c44da98b954eedeac495271d0f	0xee311c08162283b1493027b8ffb5293e7f2fd701	19331841	0x	2024-02-29T08:00:23.000Z	0xece31c7ea6d9d295ce2dd77a13f194d33e185e9b1da14683846577a3ea4631ff
0xa62d39ae23179d0cd49b0adafaf577f5a5b4538e	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xa62d39ae23179d0cd49b0adafaf577f5a5b4538e	false	10000	135	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xf7bc58b8d8f97adc129cfc4c9f45ce3c0e1d2692	19580114	0x	2024-04-04T04:47:35.000Z	0xc2d7bbb4249eca1b8b181c0c0bded189a4f20ac9b30a013dc69dfadf91f7ab8c
0xcc1c2a5c41796282d492b67a196bd92364de060b	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xcc1c2a5c41796282d492b67a196bd92364de060b	false	74986800	279	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xf7bc58b8d8f97adc129cfc4c9f45ce3c0e1d2692	19679908	0x	2024-04-18T04:18:35.000Z	0x0f8f325ffdc2a97024a8e07b2e75e3327e0f0cdb754e77589b07cb68aebac196

Example Query

Query with partition filter

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

L1StandardBridge_ETHBridgeFinalized_event

ETH withdrawal completion events from Blast L2 to Ethereum mainnet via the L1StandardBridge contract. Tracks finalized bridge transactions with sender, recipient, and withdrawal amounts for analyzing cross-chain ETH flow and user withdrawal 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.
`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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	block_timestamp	transaction_hash
0x00e9fff4109d3bee41619973aafc479148099990	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x4200000000000000000000000000000000000019	false	10222339128373115796	241	19564878	0x	2024-04-02T01:35:23.000Z	0xf66432ffa18630e4b2ba2d4d0da1d69a0ea3f936bf2df2222e8a8aaebc4feb39
0x00e9fff4109d3bee41619973aafc479148099990	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x420000000000000000000000000000000000001a	false	26965252242737966211	151	19564877	0x	2024-04-02T01:35:11.000Z	0x3d225c82bd390abebbd40675f02c926f775cdf0c9ff103df7f620201bbbc41e9
0x00e9fff4109d3bee41619973aafc479148099990	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x4200000000000000000000000000000000000019	false	18206382965171643702	175	19929338	0x	2024-05-23T01:35:23.000Z	0x1b02f69be4e49982848caa07c5385f767e83b9ead29fa7ac60751d10eff05849

Example Query

Query with partition filter

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

L1StandardBridge_ETHBridgeInitiated_event

ETH bridge deposit events from Ethereum mainnet (L1) to Blast L2, capturing user addresses, amounts, and transaction metadata for tracking cross-chain ETH transfers initiated on the L1StandardBridge contract.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	block_timestamp	transaction_hash
0x66e7fd9081c2eb343511f001980b6b3575494518	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x66e7fd9081c2eb343511f001980b6b3575494518	false	0	51	19338199	0x	2024-03-01T05:21:11.000Z	0x30f85b22ea252e569e4a40689fc8de7fd4f76d88b5e59bd67d454962b319dc03
0xba5897b9961ddbc9a462f6523149c5b0d1de386e	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xba5897b9961ddbc9a462f6523149c5b0d1de386e	false	0	476	19343064	0x	2024-03-01T21:38:11.000Z	0x516a1ffc4763c0037ed623994fa18d08143ef0e7d7b6b0d1b1dd73a6cf3c75d6
0x0f1c5954b0a810772a98af88032cf39dfe1e7b7f	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x0f1c5954b0a810772a98af88032cf39dfe1e7b7f	false	1000000000000000	118	19339072	0x	2024-03-01T08:16:11.000Z	0x77c26a1052b95af9d56efcfeb7f6701e80b3f0caf285b366b934720571a15ed7

Example Query

Query with partition filter

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

L1StandardBridge_ETHDepositInitiated_event

ETH deposit events initiated on Ethereum L1 for bridging to Blast L2 via the standard bridge contract. Records user deposits with sender, recipient, and amount data for tracking cross-chain ETH transfers and bridge 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	block_timestamp	transaction_hash
0x93e72f95f6f76d04b91f59a0c990976945459062	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x93e72f95f6f76d04b91f59a0c990976945459062	false	999999999999999	121	19327917	0x	2024-02-28T18:48:59.000Z	0x6d244b934227d390c3d14dfe61992849ce33d27b5a728d888d3ff8cc44e2a5c1
0x030d568cd867331a59f69b50ac168dd3b94f1c5a	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x030d568cd867331a59f69b50ac168dd3b94f1c5a	false	1000000000000000	266	19326749	0x	2024-02-28T14:54:11.000Z	0xb53e5ceb2c39a4ffb331e3d0f2cadbc2407083c314274f873e428f5e4e692437
0xd6b64e44aae0938118ad0dae251b859d85351c22	0x697402166fbf2f22e970df8a6486ef171dbfc524	0xd6b64e44aae0938118ad0dae251b859d85351c22	false	1000000000000000	32	19324567	0x	2024-02-28T07:32:47.000Z	0x14bc9e0fbc93f07bde1a9c19d1d4f26afbfb7cc67e2a7350993b4d5e84a0b620

Example Query

Query with partition filter

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

L1StandardBridge_ETHWithdrawalFinalized_event

ETH withdrawal completion events from Blast’s L1StandardBridge contract on Ethereum mainnet, recording when users successfully finalize their ETH withdrawals from the Blast L2 back to Ethereum. Useful for tracking bridge outflow volumes, withdrawal patterns, and cross-chain fund movements between Blast and Ethereum.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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.
`in_extraData`	`STRING`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	in_extraData	block_timestamp	transaction_hash
0xc186fa914353c44b2e33ebe05f21846f1048beda	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x2d509190ed0172ba588407d4c2df918f955cc6e1	false	226672801733711318323	59	20445488	0x	2024-08-03T04:00:47.000Z	0x8dcc7a8021c5a6fd8e5d622fdcba61c7a4d5f5582021079b69393f8abd4a7ed9
0x00e9fff4109d3bee41619973aafc479148099990	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x420000000000000000000000000000000000001a	false	17796193397530949202	141	19822097	0x	2024-05-08T01:35:11.000Z	0x382b4a05a3900228e11addb063471aeedb1a769d788ff973b255cf696e8960ed
0xc186fa914353c44b2e33ebe05f21846f1048beda	0x697402166fbf2f22e970df8a6486ef171dbfc524	0x2d509190ed0172ba588407d4c2df918f955cc6e1	false	201418992258637163102	268	20937470	0x	2024-10-10T20:01:35.000Z	0x9448a4425e05e864630f3cdf1e45a5ea9eab10be8de2be049d0a7f6a5df6cea9

Example Query

Query with partition filter

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

L1StandardBridge_finalizeBridgeERC20_function

ERC20 token withdrawal completions from Blast L2 to Ethereum mainnet via the L1StandardBridge contract. Tracks finalized bridge transactions with token addresses, amounts, sender/recipient accounts, and execution status for analyzing withdrawal flows and bridge 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.
`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__localToken`	`STRING`	Contract address of the token on the source layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__remoteToken`	`STRING`	Contract address of the token on the destination layer. Hex-encoded, 0x-prefixed, 42-character string.
`in__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	in__to	status	gas_used	in__from	signature	in__amount	to_address	block_number	from_address	in__extraData	trace_address	in__localToken	block_timestamp	in__remoteToken	transaction_hash
1677359	0x59aee0ec17400da09f3f2c745223f371e328eda9	true	56005	0x59aee0ec17400da09f3f2c745223f371e328eda9	0x0166a07a	1393000000000000000000000	0x697402166fbf2f22e970df8a6486ef171dbfc524	21758527	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,4,1,1	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	2025-02-02T11:28:11.000Z	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	0x75b61eadfc6f503d206cc0d24fe801f337e0a24f53aaa3d637682d410d210a6c
1682886	0x59aee0ec17400da09f3f2c745223f371e328eda9	true	73105	0x59aee0ec17400da09f3f2c745223f371e328eda9	0x0166a07a	903490000000000000000000	0x697402166fbf2f22e970df8a6486ef171dbfc524	21758509	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x	0,4,1,1	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	2025-02-02T11:24:35.000Z	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	0xea2686273a10feb6f7c79daaad2f6c85bfaff55c33c69d5e1fb1fef1bc89bd8c
520029	0xe841087ce2cce9d73c7502c2d23d5329a27cdcfd	true	73784	0xe841087ce2cce9d73c7502c2d23d5329a27cdcfd	0x0166a07a	118163000000000000000000	0x697402166fbf2f22e970df8a6486ef171dbfc524	20666231	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x7375706572627269646765	0,4,1,1	0x1b6e9c73bee68102d9dd4a2627f97bff4183ab0a	2024-09-02T23:40:47.000Z	0x73c369f61c90f03eb0dd172e95c90208a28dc5bc	0x87da977081cfe67660311ba0621f7192e9d9b32194362bb8e1b13468be575586

Example Query

Query with partition filter

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

L1StandardBridge_finalizeBridgeETH_function

ETH withdrawal completions from Blast L2 to Ethereum mainnet through the L1StandardBridge contract. Records finalized bridge transactions with sender, recipient, amounts, and execution details for tracking cross-chain ETH transfers.

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__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	value	in__to	status	gas_used	in__from	signature	in__amount	to_address	block_number	from_address	in__extraData	trace_address	block_timestamp	transaction_hash
447203	5178139333068761000	0xab48dce22a13e0bf34ecd54b23f173c8e1c2e2d3	true	33018	0x6d875aa78224a67c39668b488c0388af0d4b3ca1	0x1635f5fd	5178139333068760927	0x697402166fbf2f22e970df8a6486ef171dbfc524	23646615	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x0000000000000000000000000000000000000000000000000000000000000008000000000000000000000000f70da97812cb96acdf810712aa562db8dfa3dbef00000000000000000000000000000000000000000000000047dc7249d90aa75f0000000000000000000000000000000000000000000000000000000068f200f1	0,5,1,1	2025-10-24T10:05:23.000Z	0xae7aa579c90b2350d418001b6e0ab88b1463cd1dbb7fc3831293f3b805644209
447224	5543535226142302000	0xab48dce22a13e0bf34ecd54b23f173c8e1c2e2d3	true	33018	0x6d875aa78224a67c39668b488c0388af0d4b3ca1	0x1635f5fd	5543535226142301948	0x697402166fbf2f22e970df8a6486ef171dbfc524	23646291	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x0000000000000000000000000000000000000000000000000000000000000007000000000000000000000000f70da97812cb96acdf810712aa562db8dfa3dbef0000000000000000000000000000000000000000000000004cee97ead2139efc0000000000000000000000000000000000000000000000000000000068f1f537	0,5,1,1	2025-10-24T09:00:23.000Z	0x88f1fc20ed1a89eb681aa982676efebc77de021e0fb125adbbd7484179806fe0
456005	3763934186961358300	0xab48dce22a13e0bf34ecd54b23f173c8e1c2e2d3	true	33018	0x6d875aa78224a67c39668b488c0388af0d4b3ca1	0x1635f5fd	3763934186961358358	0x697402166fbf2f22e970df8a6486ef171dbfc524	23645400	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	0x0000000000000000000000000000000000000000000000000000000000000006000000000000000000000000f70da97812cb96acdf810712aa562db8dfa3dbef000000000000000000000000000000000000000000000000343c2e336bc7ce160000000000000000000000000000000000000000000000000000000068f1cb03	0,5,1,1	2025-10-24T06:00:35.000Z	0xa4fa75c3dbf54eaf281ce1ac9bc49a80fd364b75c56965d95d8b2efe869b8587

Example Query

Query with partition filter

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

L1StandardBridge_finalizeERC20Withdrawal_function

ERC-20 token withdrawal finalizations from Blast L2 to Ethereum mainnet through the L1StandardBridge contract. Tracks cross-chain asset movement with token addresses, amounts, sender/recipient data, and transaction status for analyzing Blast bridge activity and failed withdrawal attempts.

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__l1Token`	`STRING`	Token contract address on the Layer 1 blockchain. Hex-encoded, 0x-prefixed, 42-character string.
`in__l2Token`	`STRING`	Token contract address on the Layer 2 blockchain. Hex-encoded, 0x-prefixed, 42-character string.
`in__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
50000	false	39331	0xa9f9e675	0x697402166fbf2f22e970df8a6486ef171dbfc524	20497267	0xc7471edf3e998ef66ce7a84290d6fa18b2ec222f	2024-08-10T09:18:35.000Z	0xafba35fe832b9d0faa9d3f2f4e7f18efb9487d43ff2a62fe779372df0a19c440
600000	false	39355	0xa9f9e675	0x697402166fbf2f22e970df8a6486ef171dbfc524	19583725	0xb8f03bd8c3f9e19c8d03d7500af08777983a9591	2024-04-04T16:55:59.000Z	0xd2f7862eeaf147fae28b7b6c0ed90287cfffc5c70bb56871b1d2b86cdaa14d74
50000	false	39331	0xa9f9e675	0x697402166fbf2f22e970df8a6486ef171dbfc524	20494269	0xc7471edf3e998ef66ce7a84290d6fa18b2ec222f	2024-08-09T23:16:59.000Z	0x9adfb40bb2d069d6e3e56dfd767a3ce40a61c28bc795354bc3513dc702ca7ca6

Example Query

Query with partition filter

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

L1StandardBridge_finalizeETHWithdrawal_function

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.
`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__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__extraData`	`STRING`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

OptimismPortal_depositTransaction_function

Ethereum L1 deposit transactions to Blast L2 (Optimism stack) via the OptimismPortal bridge contract. Tracks cross-chain ETH and token transfers with gas limits, recipient addresses, and calldata for analyzing bridge activity and L2 onboarding 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__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).
`in__gasLimit`	`STRING`	Maximum gas units allocated for execution of the deposited transaction on the Blast L2 chain. Specified as a string-encoded integer (typically 100000 or 512334 in samples) to ensure precision for large values.
`in__isCreation`	`BOOL`	Indicates whether the deposit transaction creates a new contract on the L2 Blast chain rather than calling an existing address. Typically false for standard token or ETH deposits to user addresses.
`in__data`	`STRING`	Additional transaction data or metadata. Hex-encoded byte string including 0x prefix.

Sample Data

gas	value	in__to	status	gas_used	in__data	in__value	signature	to_address	block_number	from_address	in__gasLimit	trace_address	in__isCreation	block_timestamp	transaction_hash
14262998	4000000000000000000	0x0be834885b66d4a97e37cb8c233f56865c0ff6a3	true	84939	0x	4000000000000000000	0xe9e05c42	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	21976317	0xca28468870beeb8e32c469eddaa68375d63f1557	100000	0,0,0	false	2025-03-04T21:49:23.000Z	0x7506c31bec4e6bfe72981d18475a60f579c0473de9b0b04295305a12ecf23e49
14262998	6600000000000000000	0x4af4134abe88d5dd9c1e7eaf550627623b331fbf	true	106452	0x	6600000000000000000	0xe9e05c42	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	21971165	0xcb442850389a4cc7ce896c8fb80fc98123bba573	100000	0,0,0	false	2025-03-04T04:33:47.000Z	0xa19047c7fcc91348eb381d80a262e622a393926326fe093edef6d8eb4b2af2c6
13141732	0	0x4200000000000000000000000000000000000007	true	519004	0xd764ad0b000100000000000000000000000000000000000000000000000000000001df040000000000000000000000003a05e5d33d7ab3864d53aaec93c8301c1fa49115000000000000000000000000430000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030d4000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000001040166a07a00000000000000000000000043000000000000000000000000000000000000030000000000000000000000006b175474e89094c44da98b954eedeac495271d0f000000000000000000000000488e33a01a85aeb9ed2af12b9dd2ae63240e3ab80000000000000000000000008a4dd70a0985fcfea3b4e4f98a84794766b9b28400000000000000000000000000000000000000000000021db512c0497813ead800000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000021b58aa71e9d87a400000000000000000000000000000000000000000000000000000000000	0	0xe9e05c42	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	21973029	0x5d4472f31bd9385709ec61305afc749f0fa8e9d0	512334	0,0,3,1,3,1,0	false	2025-03-04T10:48:35.000Z	0x7a9dffe23f6065fd6f8ea07018fbf4880b9877ac8cf85ce39bb484219cb72927

Example Query

Query with partition filter

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

OptimismPortal_finalizeWithdrawalTransaction_function

Withdrawal finalization transactions from Blast’s OptimismPortal bridge contract on Ethereum mainnet, completing user asset transfers from the Blast L2 to Ethereum. Used for analyzing bridge exit flows, withdrawal volumes, and cross-chain settlement 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_hintId`	`STRING`	Optional hint identifier to optimize withdrawal proof verification on Optimism’s bridge contract. Typically ‘0’ when provided, null when no hint is needed for proof verification.
`in__tx`	`STRUCT<nonce STRING, sender STRING, target STRING, value STRING, gasLimit STRING, data STRING>`	Structured withdrawal transaction details being finalized from Blast L2 to Ethereum mainnet. Contains encoded cross-chain message data including sender, target, nonce, gas limit, and value fields; null when withdrawal finalization fails.

Sample Data

gas	in__tx	status	gas_used	in_hintId	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
368465		false	153401		0x3dca9c41	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	19679527	0xe51cd0968035f4ea6bfa1c6e5ed99037bff7caac	2024-04-18T03:02:11.000Z	0x7e7b6666ebee901b6fc25dde8429eb6217c260e5c7a7f6b5d5dd8df8f0a6e452
368465		false	153401		0x3dca9c41	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	19679741	0xe51cd0968035f4ea6bfa1c6e5ed99037bff7caac	2024-04-18T03:45:11.000Z	0x2fb91575cb151940930440ae43aa73e87ce5252e9b405a04a172c6268ac3eca7
1552432	0	true	318112	0	0x3dca9c41	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	19681260	0x100a92f03293487e9f55fd635278d9be749511a0	2024-04-18T08:49:59.000Z	0xd5197fe62a8c113c40bb7d399954eb7a3686972c27bcd5e06568d18cb3c6192e

Example Query

Query with partition filter

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

OptimismPortal_TransactionDeposited_event

Ethereum L1 deposit events for Blast L2 via the OptimismPortal contract, recording cross-chain transaction submissions from Ethereum mainnet to Blast with sender addresses, recipient addresses, and encoded transaction data. Used for tracking L1-to-L2 bridging activity and deposit volumes.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`in_opaqueData`	`STRING`	Hex-encoded arbitrary data payload associated with the deposit transaction, typically containing calldata and gas parameters for the Layer 2 execution. This opaque data format is defined by the deposit transaction version and decoded by the Layer 2 system.

Sample Data

in_to	address	in_from	removed	log_index	block_number	in_opaqueData	block_timestamp	transaction_hash
0x4200000000000000000000000000000000000007	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	0x6e5572f31bd9385709ec61305afc749f0fa8fae1	false	188	19302451	0x00000000000000000000000000000000000000000000000003782dace9d9000000000000000000000000000000000000000000000000000003782dace9d90000000000000007cb4e00d764ad0b0001000000000000000000000000000000000000000000000000000000000000000000000000000000000000697402166fbf2f22e970df8a6486ef171dbfc524000000000000000000000000420000000000000000000000000000000000001000000000000000000000000000000000000000000000000003782dace9d900000000000000000000000000000000000000000000000000000000000000030d4000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000a41635f5fd000000000000000000000000cd1a377ea7c258cfbc54112373893fa06d18fa67000000000000000000000000cd1a377ea7c258cfbc54112373893fa06d18fa6700000000000000000000000000000000000000000000000003782dace9d900000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2024-02-25T05:16:23.000Z	0x7d4a95ffb22075b5d3adf47e33f36ebdd941ffd2a4abeabd5cefb38a3c7b2a6d
0x4200000000000000000000000000000000000007	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	0x6e5572f31bd9385709ec61305afc749f0fa8fae1	false	154	19302946	0x000000000000000000000000000000000000000000000000016345785d8a0000000000000000000000000000000000000000000000000000016345785d8a0000000000000007cb4e00d764ad0b00010000000000000000000000000000000000000000000000000000000000010000000000000000000000003a05e5d33d7ab3864d53aaec93c8301c1fa491150000000000000000000000004300000000000000000000000000000000000005000000000000000000000000000000000000000000000000016345785d8a00000000000000000000000000000000000000000000000000000000000000030d4000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000a41635f5fd0000000000000000000000003c872e7bcadae75bcf7ddc8ba90a2b434a96ac410000000000000000000000003c872e7bcadae75bcf7ddc8ba90a2b434a96ac41000000000000000000000000000000000000000000000000016345785d8a00000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2024-02-25T06:56:11.000Z	0xc9cbb6a8335d44c1d2ed8c4fbe566b2adb5bf38e1922864926e1b7da26c9d0a3
0x4300000000000000000000000000000000000005	0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	0x4b16e5d33d7ab3864d53aaec93c8301c1fa4a226	false	127	19344384	0x00000000000000000000000000000000000000000000000006f2738a1f487d0700000000000000000000000000000000000000000000000006f2738a1f487d070000000000030d4000a47a5c350000000000000000000000005f6ae08b8aeb7078cf2f96afb089d7c9f51da47d000000000000000000000000bcd2b563cdf515a52f64d2ef9e943b81beb91ce300000000000000000000000000000000000000000000000006f2738a1f487d0700000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000	2024-03-02T02:04:11.000Z	0x9054f52f23f9f26deb660c2a4f07c411797b39b6b1a0c1086147428360e6b970

Example Query

Query with partition filter

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

OptimismPortal_WithdrawalFinalized_event

Completed withdrawal records from Blast’s OptimismPortal bridge contract on Ethereum mainnet, tracking asset transfers from the Blast L2 back to Ethereum. Used for analyzing bridge activity, withdrawal success rates, and cross-chain fund 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_withdrawalHash`	`STRING`	Unique identifier (hash) for the withdrawal transaction being finalized on the L1 Ethereum chain from the Blast L2. Hex-encoded, 0x-prefixed 64-character string representing the keccak256 hash of the withdrawal parameters.
`in_hintId`	`STRING`	Hint identifier used to optimize the withdrawal finalization lookup on the OptimismPortal contract. Typically ‘0’ but can increment when multiple withdrawals are finalized in quick succession.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.

Sample Data

address	removed	in_hintId	log_index	in_success	block_number	block_timestamp	transaction_hash	in_withdrawalHash
0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	false	0	123	true	19329203	2024-02-28T23:07:47.000Z	0x2c33b8749ad20e2b4b6484c70ed2d87ae77708f788a307979119290ba5ecb592	0x2b92d4bcccf633980a3cd81a72065f80a614da5589f0b7513b25061096298781
0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	false	1	94	true	19322121	2024-02-27T23:20:11.000Z	0x9c449cb9482d066a4deeb25579c50d97c5224b938c3ebcbe3f5e52e31fdbb3a6	0x5a4619913a2713e5c234a60cc4ca43979694b77d77de703cc238f9f71dcf549b
0x0ec68c5b10f21effb74f2a5c61dfe6b08c0db6cb	false	0	123	true	19315054	2024-02-26T23:36:47.000Z	0x14e1ab663b8e42cbaf793d13c323ffe1159d12fe120a6938e16c667abd177dd2	0xbbfb0454c28fa6e367967d005d82d36696a6d6aa6607dd647345b2421a58d38a

Example Query

Query with partition filter

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

​Tables

​L1BlastBridge_bridgeERC20_function

​L1BlastBridge_bridgeERC20To_function

​L1BlastBridge_bridgeETH_function

​L1BlastBridge_bridgeETHTo_function

​L1BlastBridge_ERC20BridgeFinalized_event

​L1BlastBridge_ERC20BridgeInitiated_event

​L1BlastBridge_ETHBridgeFinalized_event

​L1BlastBridge_ETHBridgeInitiated_event

​L1BlastBridge_finalizeBridgeERC20_function

​L1BlastBridge_finalizeBridgeETH_function

​L1StandardBridge_bridgeERC20_function

​L1StandardBridge_bridgeERC20To_function

​L1StandardBridge_bridgeETH_function

​L1StandardBridge_bridgeETHTo_function

​L1StandardBridge_depositERC20_function

​L1StandardBridge_depositERC20To_function

​L1StandardBridge_depositETH_function

​L1StandardBridge_depositETHTo_function

​L1StandardBridge_ERC20BridgeFinalized_event

​L1StandardBridge_ERC20BridgeInitiated_event

​L1StandardBridge_ERC20DepositInitiated_event

​L1StandardBridge_ERC20WithdrawalFinalized_event

​L1StandardBridge_ETHBridgeFinalized_event

​L1StandardBridge_ETHBridgeInitiated_event

​L1StandardBridge_ETHDepositInitiated_event

​L1StandardBridge_ETHWithdrawalFinalized_event

​L1StandardBridge_finalizeBridgeERC20_function

​L1StandardBridge_finalizeBridgeETH_function

​L1StandardBridge_finalizeERC20Withdrawal_function

​L1StandardBridge_finalizeETHWithdrawal_function

​OptimismPortal_depositTransaction_function

​OptimismPortal_finalizeWithdrawalTransaction_function

​OptimismPortal_TransactionDeposited_event

​OptimismPortal_WithdrawalFinalized_event

Tables

L1BlastBridge_bridgeERC20_function

L1BlastBridge_bridgeERC20To_function

L1BlastBridge_bridgeETH_function

L1BlastBridge_bridgeETHTo_function

L1BlastBridge_ERC20BridgeFinalized_event

L1BlastBridge_ERC20BridgeInitiated_event

L1BlastBridge_ETHBridgeFinalized_event

L1BlastBridge_ETHBridgeInitiated_event

L1BlastBridge_finalizeBridgeERC20_function

L1BlastBridge_finalizeBridgeETH_function

L1StandardBridge_bridgeERC20_function

L1StandardBridge_bridgeERC20To_function

L1StandardBridge_bridgeETH_function

L1StandardBridge_bridgeETHTo_function

L1StandardBridge_depositERC20_function

L1StandardBridge_depositERC20To_function

L1StandardBridge_depositETH_function

L1StandardBridge_depositETHTo_function

L1StandardBridge_ERC20BridgeFinalized_event

L1StandardBridge_ERC20BridgeInitiated_event

L1StandardBridge_ERC20DepositInitiated_event

L1StandardBridge_ERC20WithdrawalFinalized_event

L1StandardBridge_ETHBridgeFinalized_event

L1StandardBridge_ETHBridgeInitiated_event

L1StandardBridge_ETHDepositInitiated_event

L1StandardBridge_ETHWithdrawalFinalized_event

L1StandardBridge_finalizeBridgeERC20_function

L1StandardBridge_finalizeBridgeETH_function

L1StandardBridge_finalizeERC20Withdrawal_function

L1StandardBridge_finalizeETHWithdrawal_function

OptimismPortal_depositTransaction_function

OptimismPortal_finalizeWithdrawalTransaction_function

OptimismPortal_TransactionDeposited_event

OptimismPortal_WithdrawalFinalized_event