optimismgateway_v1_optimism

Tables

L2DAITokenBridge_WithdrawalInitiated_event

DAI token withdrawal events from Optimism L2 to Ethereum L1 via the official DAI bridge, capturing withdrawal amounts, sender/recipient addresses, and L1/L2 token addresses. Used for tracking cross-chain DAI flows and analyzing bridge activity 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__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__data`	`STRING`	Additional transaction data or metadata. Hex-encoded byte string including 0x prefix.

Sample Data

in__to	address	removed	in__data	in__from	log_index	in__amount	in__l1Token	in__l2Token	block_number	block_timestamp	transaction_hash
0xc186fa914353c44b2e33ebe05f21846f1048beda	0x467194771dae2967aef3ecbedd3bf9a310c76c65	false	0x	0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	8	11017997333619024267102	0x6b175474e89094c44da98b954eedeac495271d0f	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	92306803	2023-04-19T17:30:41.000Z	0xf8a2b6889192baef911a72cb0332022182d42bd307437eebcbe77450b87464aa
0xc186fa914353c44b2e33ebe05f21846f1048beda	0x467194771dae2967aef3ecbedd3bf9a310c76c65	false	0x	0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	16	2653210880516641113989	0x6b175474e89094c44da98b954eedeac495271d0f	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	21715624	2022-09-02T17:24:39.000Z	0x87693740a5d02d129c998bdc07af012f0e33338f2597b4a81ac5a223e283892a
0xc186fa914353c44b2e33ebe05f21846f1048beda	0x467194771dae2967aef3ecbedd3bf9a310c76c65	false	0x	0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	26	9752187716999727278935	0x6b175474e89094c44da98b954eedeac495271d0f	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	21618906	2022-09-02T03:05:36.000Z	0xb905f679776cc537d1e2fdaeb481e34ed26b0ee6cd987b703087f5c201623d88

Example Query

Query with partition filter

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

L2ECOBridge_WithdrawalInitiated_event

ECO token withdrawal events from Optimism L2 to Ethereum L1 through the ECO bridge contract. Tracks withdrawal initiations with sender, recipient, token addresses, and amounts for monitoring cross-chain ECO 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`	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__data`	`STRING`	Additional transaction data or metadata. Hex-encoded byte string including 0x prefix.

Sample Data

in__to	address	removed	in__data	in__from	log_index	in__amount	in__l1Token	in__l2Token	block_number	block_timestamp	transaction_hash
0x074636e8d67bd0167a901061c41c9af6e3606e0e	0xaa029bbdc947f5205fba0f3c11b592420b58f824	false	0x	0x074636e8d67bd0167a901061c41c9af6e3606e0e	14	34987865413170297992010000000000000000000	0x8dbf9a4c99580fc7fd4024ee08f3994420035727	0xe7bc9b3a936f122f08aac3b1fac3c3ec29a78874	115742197	2024-02-04T21:46:11.000Z	0x6805c72ef5397d7729d7c3dc7d68379227d6545c42d67342a595a9c702955b58
0xee8e4218a575889321c72dff71028a2cc2c7d9d3	0xaa029bbdc947f5205fba0f3c11b592420b58f824	false	0x	0xee8e4218a575889321c72dff71028a2cc2c7d9d3	40	16799081767731505153365300000000000000000	0x8dbf9a4c99580fc7fd4024ee08f3994420035727	0xe7bc9b3a936f122f08aac3b1fac3c3ec29a78874	113276871	2023-12-09T20:08:39.000Z	0x198e2a56ab1da756796f5625bff0a29f517d34462161532749e269139ce5be65
0xb2e998ce3ba32661cf5371d03ef1f4f60f87c010	0xaa029bbdc947f5205fba0f3c11b592420b58f824	false	0x00000000	0xb2e998ce3ba32661cf5371d03ef1f4f60f87c010	31	42211055276381905200000000000000000000	0x8dbf9a4c99580fc7fd4024ee08f3994420035727	0xe7bc9b3a936f122f08aac3b1fac3c3ec29a78874	105498435	2023-06-12T18:47:27.000Z	0x17c80c79ff448f2a1d052e8c7f5504627be3733110cf22739806db712c13fd2e

Example Query

Query with partition filter

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

L2ERC20TokenBridge_WithdrawalInitiated_event

ERC-20 token withdrawal events initiated from Optimism (Layer 2) back to Ethereum mainnet (Layer 1), capturing the sender, recipient, token addresses on both chains, and withdrawal amounts for analyzing cross-chain bridge activity and fund flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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__data`	`STRING`	Additional transaction data or metadata. Hex-encoded byte string including 0x prefix.

Sample Data

in__to	address	removed	in__data	in__from	log_index	in__amount	in__l1Token	in__l2Token	block_number	block_timestamp	transaction_hash
0x500bea59133e20dc63b7e88913b30348494b84ba	0x8e01013243a96601a86eb3153f0d9fa4fbfb6957	false	0x	0x500bea59133e20dc63b7e88913b30348494b84ba	4	90640796302369507245	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	111754141	2023-11-04T14:10:59.000Z	0xd3dde275159dc2dfe9d47c0fe9342ddac2bdf24e018a3e1fb72d934b91c4bf22
0x1724e18fca576e0720692df03ace7d97443f52bd	0x8e01013243a96601a86eb3153f0d9fa4fbfb6957	false	0x	0x1724e18fca576e0720692df03ace7d97443f52bd	5	87646500172329329532	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	113366214	2023-12-11T21:46:45.000Z	0x80c7357ef482d7e30489fb87de475cc97ff343f57c2221d45dff9c800ff98590
0x9b3b5eb870466e14bcd29cf9702e6671d381d7e2	0x8e01013243a96601a86eb3153f0d9fa4fbfb6957	false	0x	0x9b3b5eb870466e14bcd29cf9702e6671d381d7e2	5	28604218946100713630	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	113352299	2023-12-11T14:02:55.000Z	0xe108d897be672cceb7b4d516758408689ddb9e45db93af5e60e2f587ffc524d0

Example Query

Query with partition filter

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

L2StandardBridge_WithdrawalInitiated_event

Withdrawal initiation events from Optimism L2StandardBridge contract tracking token transfers from Layer 2 back to Ethereum mainnet (Layer 1). Maps L2 token addresses to their L1 counterparts with sender, recipient, and withdrawal amounts for cross-chain bridge 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_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
0xafca8e2986d7f2df9e5bd06c7fde76988fbaf816	0x4200000000000000000000000000000000000010	0xafca8e2986d7f2df9e5bd06c7fde76988fbaf816	false	64507180164	3	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2485558	0x	2022-01-21T01:11:39.000Z	0x7b283f1112b5bf5ab21beab43c843ba92282bf49d9454363e85dff9e392eb3a8
0x79ce1426b21bb2cfae014388ade594666ecef4c0	0x4200000000000000000000000000000000000010	0x79ce1426b21bb2cfae014388ade594666ecef4c0	false	1000000000000000	3	0x0000000000000000000000000000000000000000	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	2503358	0x	2022-01-21T08:01:51.000Z	0x200b0a82417451ce31c89673a8417f0f3e0e8b926a0d5abde17a66af1f92c97a
0x5d2b49dd577a65bb18208fb7e9be307f4b028a20	0x4200000000000000000000000000000000000010	0x5d2b49dd577a65bb18208fb7e9be307f4b028a20	false	1000000000000000	3	0x0000000000000000000000000000000000000000	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	2503398	0x	2022-01-21T08:01:51.000Z	0x47249cb1d75a661d729eecfa8aa8447fc5fd48a52607f59b1cd5c523494c98bb

Example Query

Query with partition filter

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

L2USXTokenBridge_WithdrawalInitiated_event

Withdrawal initiation events for USX token transfers from Optimism (L2) back to Ethereum mainnet (L1) through the L2 token bridge contract. Tracks withdrawal requests with token amounts, sender/recipient addresses, and corresponding L1/L2 token addresses for monitoring cross-chain USX 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`	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__data`	`STRING`	Additional transaction data or metadata. Hex-encoded byte string including 0x prefix.

Sample Data

in__to	address	removed	in__data	in__from	log_index	in__amount	in__l1Token	in__l2Token	block_number	block_timestamp	transaction_hash
0x5ef01a9ab62f700bb0bcc0f11f9cf7aa8fc543fd	0xc76cbfbafd41761279e3edb23fd831ccb74d5d67	false	0x	0x5ef01a9ab62f700bb0bcc0f11f9cf7aa8fc543fd	3	50000000000000000000	0x0a5e677a6a24b2f1a2bf4f3bffc443231d2fdec8	0xbfd291da8a403daaf7e5e9dc1ec0aceacd4848b9	883706	2021-12-07T08:10:38.000Z	0x16e5427c284836180560a137102551563ceb9913aa422597d1c925dc4d6c45df

Example Query

Query with partition filter

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

SynthetixBridgeToBaseV1_WithdrawalInitiated_event

Withdrawal events from Synthetix bridge moving assets from Optimism to Base chain, capturing sender/receiver addresses and token amounts. Useful for analyzing cross-chain migration patterns and bridge volume between these Layer 2 networks.

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 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).

Sample Data

in__to	address	removed	in__from	log_index	in__amount	block_number	block_timestamp	transaction_hash
0xa934585f2f15b813e61321754ac7247fed11d4dd	0x3f87ff1de58128ef8fcb4c807efd776e1ac72e51	false	0xa934585f2f15b813e61321754ac7247fed11d4dd	2	2322101891239662908265	315523	2021-11-21T10:58:52.000Z	0x2f11689a7d5137fa07746f3fa334462649de0d801ac878f6968285936632ea54
0x2f4bf8938ee529b4cab899762a623030dea26f2e	0x3f87ff1de58128ef8fcb4c807efd776e1ac72e51	false	0x2f4bf8938ee529b4cab899762a623030dea26f2e	2	370000000000000000000	3530513	2022-02-14T03:45:20.000Z	0xd0023ab131745ba563e6ffbbf9edb0d2081a691383d6dfbf9264c8720317aa1e
0x3f9126c939ace724be172b9f10d6553cceb0daeb	0x3f87ff1de58128ef8fcb4c807efd776e1ac72e51	false	0x3f9126c939ace724be172b9f10d6553cceb0daeb	2	126770000000000000000	3535585	2022-02-14T08:48:23.000Z	0xd2a1678da95c4f3e71aaf785b27041815261372b4f88a93fc7f1bfe594b3af38

Example Query

Query with partition filter

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

SynthetixBridgeToBaseV2_WithdrawalInitiated_event

Withdrawal initiation events from Synthetix’s bridge contract moving assets from Optimism to Base L2. Tracks user addresses, withdrawal amounts, and transaction details for cross-chain asset movement 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__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).

Sample Data

in__to	address	removed	in__from	log_index	in__amount	block_number	block_timestamp	transaction_hash
0x4fbe5303bca958b8f1ee35b5443aad9ad442e3d7	0x8f7b21bf5f8490faa63386f6f6434c6ae8d8a120	false	0x4fbe5303bca958b8f1ee35b5443aad9ad442e3d7	2	2000000000000000000000	5798897	2022-04-14T07:58:18.000Z	0x6531728e3d3208ad05c4959eb0d1a3947f4cdbce7c9d60e37e70a054f27df3b7
0x5e667d65d45cd511e7cdfbbc592196631c86c773	0x8f7b21bf5f8490faa63386f6f6434c6ae8d8a120	false	0x5e667d65d45cd511e7cdfbbc592196631c86c773	2	200000000000000000000	5800607	2022-04-14T08:44:25.000Z	0x2fa979ff76375cdeb8edaf2bc576f48734d8c8cab5947f35ad0b307ee64585ff
0xf7c35e45122075ac394a3b453e1b35f4c319e874	0x8f7b21bf5f8490faa63386f6f6434c6ae8d8a120	false	0xf7c35e45122075ac394a3b453e1b35f4c319e874	2	597550052637780646624	5826002	2022-04-14T20:43:31.000Z	0x07406ef89c89cffeaf0bcd06143519620cf810dd017b6c5682f3a5fcfe8aeced

Example Query

Query with partition filter

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

SynthetixBridgeToBaseV3_WithdrawalInitiated_event

Withdrawal initiation events from Synthetix bridge on Optimism for token transfers to Base L2. Tracks sender/receiver addresses and amounts for cross-chain asset migration analysis between Optimism and Base networks.

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 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).

Sample Data

in__to	address	removed	in__from	log_index	in__amount	block_number	block_timestamp	transaction_hash
0x09e971bbf69c17dd56d02ce9ab2f6ab5890de65d	0x136b1ec699c62b0606854056f02dc7bb80482d63	false	0x09e971bbf69c17dd56d02ce9ab2f6ab5890de65d	2	135000000000000000000	12437323	2022-06-20T07:50:29.000Z	0x23271fec1c6d5640e5f1431539770da3a08d804490dbcac59b5643301a12b604
0x74dcce073d708e695f4ec5eb6aec958aa4d16f44	0x136b1ec699c62b0606854056f02dc7bb80482d63	false	0x74dcce073d708e695f4ec5eb6aec958aa4d16f44	2	150000000000000000000	12437240	2022-06-20T07:49:12.000Z	0x388dc31413e9251ad9198ede3b99425434c51f0ab0b409f5a9c316f784f1892d
0x8b17757be7e0a532d0c27a5dd5ffd30063fc21a9	0x136b1ec699c62b0606854056f02dc7bb80482d63	false	0x8b17757be7e0a532d0c27a5dd5ffd30063fc21a9	2	190000000000000000000	12440041	2022-06-20T08:16:23.000Z	0x470eba9992c766efde43df3b3770210a4c67178f33f852f0f5a86fad9761341b

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

L2DAITokenBridge_WithdrawalInitiated_event

L2ECOBridge_WithdrawalInitiated_event

L2ERC20TokenBridge_WithdrawalInitiated_event

L2StandardBridge_WithdrawalInitiated_event

L2USXTokenBridge_WithdrawalInitiated_event

SynthetixBridgeToBaseV1_WithdrawalInitiated_event

SynthetixBridgeToBaseV2_WithdrawalInitiated_event

SynthetixBridgeToBaseV3_WithdrawalInitiated_event

​Tables

​L2DAITokenBridge_WithdrawalInitiated_event

​L2ECOBridge_WithdrawalInitiated_event

​L2ERC20TokenBridge_WithdrawalInitiated_event

​L2StandardBridge_WithdrawalInitiated_event

​L2USXTokenBridge_WithdrawalInitiated_event

​SynthetixBridgeToBaseV1_WithdrawalInitiated_event

​SynthetixBridgeToBaseV2_WithdrawalInitiated_event

​SynthetixBridgeToBaseV3_WithdrawalInitiated_event

Tables

L2DAITokenBridge_WithdrawalInitiated_event

L2ECOBridge_WithdrawalInitiated_event

L2ERC20TokenBridge_WithdrawalInitiated_event

L2StandardBridge_WithdrawalInitiated_event

L2USXTokenBridge_WithdrawalInitiated_event

SynthetixBridgeToBaseV1_WithdrawalInitiated_event

SynthetixBridgeToBaseV2_WithdrawalInitiated_event

SynthetixBridgeToBaseV3_WithdrawalInitiated_event