optimismgateway_v1_ethereum

Tables

BitBTCL1Bridge_ERC20DepositInitiated_event

ERC20 token deposit events from Ethereum L1 to Optimism L2 via the BitBTC bridge, capturing token addresses, amounts, sender/recipient accounts, and associated transaction data. Used for tracking cross-chain BitBTC token transfers and analyzing bridge activity between Ethereum mainnet and Optimism.

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
0x3e579180cf01f0e2abf6ff4d566b7891fbf9b868	0xaba2c5f108f7e820c049d5af70b16ac266c8f128	false	0x	0x3e579180cf01f0e2abf6ff4d566b7891fbf9b868	98	500000000000000	0x3c513db8bdc3806e4489d62c3d549a5aaf6a4e97	0xc98b98d17435aa00830c87ea02474c5007e1f272	13813063	2021-12-16T00:46:59.000Z	0x6d7f1942033cf843af2b02b458270c7a76bcefcdfe7594fbc7c338ad4ff3755e
0x3e579180cf01f0e2abf6ff4d566b7891fbf9b868	0xaba2c5f108f7e820c049d5af70b16ac266c8f128	false	0x	0x3e579180cf01f0e2abf6ff4d566b7891fbf9b868	195	100000000000000	0x3c513db8bdc3806e4489d62c3d549a5aaf6a4e97	0xc98b98d17435aa00830c87ea02474c5007e1f272	13731699	2021-12-03T05:13:56.000Z	0x97ca8b18eb4ca9d153b73a4ad8cf1e4d328f5d9482a32a319d835a0f36e535fc

Example Query

Query with partition filter

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

BridgeDeposit_EtherReceived_event

ETH deposit events received by the Optimism Gateway bridge contract on Ethereum mainnet. Used for tracking cross-chain ETH transfers from L1 to Optimism L2, including depositor addresses and amounts in wei.

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_emitter`	`STRING`	Ethereum address that initiated the ether deposit to the Optimism Gateway bridge contract. Hex-encoded, 0x-prefixed 40-character string representing the source account on L1.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_emitter	block_number	block_timestamp	transaction_hash
0x324c7ec7fb2bc61646ac2f22f6d06ab29b6c87a3	false	2000000000000000	356	0xd3e3b95ed0edc914bf0a0d78ac758d735392a3a4	13912756	2021-12-31T11:02:14.000Z	0xa80f49ccd7b0d121b56466ec81c0735a4d224cb76ed18b33a58cca2f79ffaf22
0x324c7ec7fb2bc61646ac2f22f6d06ab29b6c87a3	false	2000000000000000	297	0xd3e3b95ed0edc914bf0a0d78ac758d735392a3a4	13912540	2021-12-31T10:14:53.000Z	0x412098b75ba3790c255b85ebe426a8803bb7053906ed080c7430cd7fa0fcc8c0
0x324c7ec7fb2bc61646ac2f22f6d06ab29b6c87a3	false	2000000000000000	236	0xd3e3b95ed0edc914bf0a0d78ac758d735392a3a4	13912538	2021-12-31T10:14:35.000Z	0xd4700b8f83ef05e3ca70e1e9f323d62bc0b4dd9b76a868fd82685a7bf39b3def

Example Query

Query with partition filter

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

L1DAITokenBridge_ERC20DepositInitiated_event

DAI token deposit events initiated on Ethereum L1 for bridging to Optimism L2 via the canonical DAI bridge. Tracks deposit amount, sender/recipient addresses, and L1/L2 token addresses for analyzing DAI cross-chain transfer 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__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
0x0f853e0871eb8960fb837774d09162a601313b3a	0x10e6593cdda8c58a1d0f14c5164b376352a55f2f	false	0x	0x0f853e0871eb8960fb837774d09162a601313b3a	324	10000000000000000000000	0x6b175474e89094c44da98b954eedeac495271d0f	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	16806240	2023-03-11T17:11:59.000Z	0xde4278b1a47f4db6215b4817b5591ebfe0ed9ad7d32bfc5ebd02b73950f03115
0x24a7e2f78c3ac4181996e415f7dbea1a71994952	0x10e6593cdda8c58a1d0f14c5164b376352a55f2f	false	0x	0x24a7e2f78c3ac4181996e415f7dbea1a71994952	6	97844250190210936958892	0x6b175474e89094c44da98b954eedeac495271d0f	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	16805018	2023-03-11T13:03:35.000Z	0x5f52c9310c5a8ebfa0c8ecfe7b80f0d2841c63a416ad8e639018e4f88c3052bb
0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	0x10e6593cdda8c58a1d0f14c5164b376352a55f2f	false	0x	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	141	12865377215722672853617	0x6b175474e89094c44da98b954eedeac495271d0f	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	16802695	2023-03-11T05:13:59.000Z	0x925d3f79e2d7cfd99a53c9ee2c24c60f9a3b008b6e40ecb7645eccc55113f36f

Example Query

Query with partition filter

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

L1ECOBridge_ERC20DepositInitiated_event

ERC20 deposit initiation events from the Optimism Gateway L1ECOBridge contract on Ethereum mainnet, capturing cross-chain token transfers from Layer 1 to Optimism Layer 2. Records sender and recipient addresses, token amounts, and L1/L2 token pair mappings for tracking 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__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
0xa455656ca265aa17a15238692ae00fad0de5be74	0xaa029bbdc947f5205fba0f3c11b592420b58f824	false	0x	0xa455656ca265aa17a15238692ae00fad0de5be74	304	7455910303481493446735635939542426721440	0x8dbf9a4c99580fc7fd4024ee08f3994420035727	0xe7bc9b3a936f122f08aac3b1fac3c3ec29a78874	18254778	2023-10-01T09:25:11.000Z	0x597233aba06e4cd2042022391e01337d3b7f96f622f2dec7dad953d6fe8feba6
0x5dd1b4c6132c175944c226fc89a8739b8bd9904e	0xaa029bbdc947f5205fba0f3c11b592420b58f824	false	0x	0x5dd1b4c6132c175944c226fc89a8739b8bd9904e	182	922888085976254174400000000000000000000	0x8dbf9a4c99580fc7fd4024ee08f3994420035727	0xe7bc9b3a936f122f08aac3b1fac3c3ec29a78874	17711426	2023-07-17T07:14:47.000Z	0x52eaae38c4c65b8437bbb6baad597d0efa51b600854ed7565cd1685c1670e9fd
0x5dd1b4c6132c175944c226fc89a8739b8bd9904e	0xaa029bbdc947f5205fba0f3c11b592420b58f824	false	0x	0x5dd1b4c6132c175944c226fc89a8739b8bd9904e	147	1493142022421407642383715775566613942736	0x8dbf9a4c99580fc7fd4024ee08f3994420035727	0xe7bc9b3a936f122f08aac3b1fac3c3ec29a78874	17714511	2023-07-17T17:37:35.000Z	0xaadd24ba0442333108d8255c5df7e6dd02816e2d371ae3a201f86aea2096648b

Example Query

Query with partition filter

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

L1ERC20TokenBridge_ERC20DepositInitiated_event

ERC20 token deposit events from Ethereum Layer 1 to Optimism Layer 2 through the standard token bridge, capturing token addresses, amounts, sender and recipient accounts for cross-chain transfer 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`	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
0x224e69025a2f705c8f31efb6694398f8fd09ac5c	0x76943c0d61395d8f2edf9060e1533529cae05de6	false	0x	0x224e69025a2f705c8f31efb6694398f8fd09ac5c	178	42000000000000000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	15564642	2022-09-19T02:38:59.000Z	0xda5cb3e0947c029d1f5e8b9e8619c003b5666cca2942251f8a7f5a389f2ec9fc
0x50fa50fa2032d85eb2dda303929bf56886aa9afb	0x76943c0d61395d8f2edf9060e1533529cae05de6	false	0x	0x50fa50fa2032d85eb2dda303929bf56886aa9afb	104	2500000000000000000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	16172809	2022-12-13T02:30:35.000Z	0xdce6cd4d12c7fa89479dc9ac91caa38e2ac40c419d913afb07aec51c069b7025
0x3ffba13e5e713cc435271a1c4a50ffcfa835f9d4	0x76943c0d61395d8f2edf9060e1533529cae05de6	false	0x	0x3ffba13e5e713cc435271a1c4a50ffcfa835f9d4	242	235000000000000000000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	17605035	2023-07-02T08:06:47.000Z	0xf5b68c3241e53e27e28a25eaff4bdcc630f2aaa111e395e5793b1c229c615ef9

Example Query

Query with partition filter

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

L1StandardBridge_ERC20DepositInitiated_event

ERC-20 token deposit events from Ethereum L1 to Optimism L2 via the standard bridge contract. Tracks token transfers including sender, recipient, token addresses on both layers, and deposit amounts for analyzing cross-chain 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.
`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
0xc381c8a237d51fdaa725d6b520df82d58141fcf9	0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	0xc381c8a237d51fdaa725d6b520df82d58141fcf9	false	18116471	239	0x08d32b0da63e2c3bcf8019c9c5d849d7a9d791e6	0x1da650c3b2daa8aa9ff6f661d4156ce24d08a062	14666450	0x	2022-04-27T12:23:51.000Z	0x2a7f96086bcf1e2bc3edde86021f6e0a096df5742e604273e435515bc47d09ef
0x4db7e0a6474f39f4fbffd96bd0b39c83a9f291c8	0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	0x4db7e0a6474f39f4fbffd96bd0b39c83a9f291c8	false	500000000	272	0x08d32b0da63e2c3bcf8019c9c5d849d7a9d791e6	0x1da650c3b2daa8aa9ff6f661d4156ce24d08a062	14664835	0x	2022-04-27T06:12:52.000Z	0x8fea67254e700de40d3f5f8df047d701f5edffb42502a81113784532eaac9159
0x5596d991bf7753f0f14e1c5b59abbea626725401	0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	0x5596d991bf7753f0f14e1c5b59abbea626725401	false	5556050318215653093897065	160	0x15ee120fd69bec86c1d38502299af7366a41d1a6	0x5029c236320b8f15ef0a657054b84d90bfbeded3	14663448	0x	2022-04-27T01:04:45.000Z	0x4e53882796845af6b0ee285fb0d76bde2d541589b3cbd6ad30647269139b1e09

Example Query

Query with partition filter

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

L1StandardBridge_ETHDepositInitiated_event

ETH deposit events from Optimism’s L1 Standard Bridge contract on Ethereum mainnet, capturing cross-chain transfers initiated from Layer 1 to Optimism Layer 2. Used for tracking bridge volume, user migration patterns, and cross-layer liquidity 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_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
0x5ca6a8da19dbdc8e5903964d2c160db17a2db915	0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	0x5ca6a8da19dbdc8e5903964d2c160db17a2db915	false	300000000000000	185	12919912	0x	2021-07-29T09:24:18.000Z	0xdbb9c83e749b7d6b5dab98a5a93b11538a34e4b7a4e77bd5ca06ad21e941a77c
0x0307cc53d1e6e651ee3ebf437cbe6bd56b394c7a	0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	0x0307cc53d1e6e651ee3ebf437cbe6bd56b394c7a	false	1000000000000000	315	12919879	0x	2021-07-29T09:18:52.000Z	0x7a1e674c93a6670be7fd2f95d01c94296b78cf356e151fe73205020163577741
0xc688cc5298ce97cf5b82a88229f3a40e3bf25530	0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	0xc688cc5298ce97cf5b82a88229f3a40e3bf25530	false	1000000000000000	172	12922179	0x	2021-07-29T18:00:37.000Z	0xee667cfea21ad279acce80e0b90be67b7a53b9e8fb180509f3993ad2ffb1ce93

Example Query

Query with partition filter

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

L1USXTokenBridge_ERC20DepositInitiated_event

ERC20 deposit events from Ethereum L1 to Optimism L2 for USX token bridging via the Optimism Gateway. Records include sender/recipient addresses, token amounts, and L1/L2 token contract mappings for tracking cross-chain USX 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.
`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
0x96a2699644a7be70a4f6bf4d42548f765399d649	0xc5b1ec605738ef73a4efc562274c1c0b6609cf59	false	0x	0x96a2699644a7be70a4f6bf4d42548f765399d649	214	319145579276255120061092	0x0a5e677a6a24b2f1a2bf4f3bffc443231d2fdec8	0xbfd291da8a403daaf7e5e9dc1ec0aceacd4848b9	16101732	2022-12-03T03:54:47.000Z	0x386c019b90999220fa41db60ac7ac4369b459e62f3d13240d4c98e6c740d2198
0xa2d89de92cf97404eb371743779f4caaba09b10e	0xc5b1ec605738ef73a4efc562274c1c0b6609cf59	false	0x	0xa2d89de92cf97404eb371743779f4caaba09b10e	312	200000000000000000000000	0x0a5e677a6a24b2f1a2bf4f3bffc443231d2fdec8	0xbfd291da8a403daaf7e5e9dc1ec0aceacd4848b9	16097549	2022-12-02T13:53:47.000Z	0xe0ba4f20541d8569b3a57951cd5ed985bc28fb5739f0379423ffa0025beb2650
0x15fe8337a6e23629fa09dc6e0f8b041d681ec995	0xc5b1ec605738ef73a4efc562274c1c0b6609cf59	false	0x	0x15fe8337a6e23629fa09dc6e0f8b041d681ec995	252	9000003552000000000000	0x0a5e677a6a24b2f1a2bf4f3bffc443231d2fdec8	0xbfd291da8a403daaf7e5e9dc1ec0aceacd4848b9	15258002	2022-08-01T17:29:39.000Z	0xeaf6e855083564f4480b55fcfab6b8fb64dcc4a3cf7118427fb819289b365343

Example Query

Query with partition filter

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

OVML1ETHGatewayV1_DepositInitiated_event

ETH deposit events initiated through Optimism’s Layer 1 gateway contract on Ethereum mainnet. Captures bridging activity with sender, recipient, and amount data for tracking cross-chain ETH transfers to Optimism.

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
0x784f99e298604199b0be861b3e61dc63ecf82d72	0xe681f80966a8b1ffadecf8068bd6f99034791c95	false	0x784f99e298604199b0be861b3e61dc63ecf82d72	267	2500000000000000	12650110	2021-06-17T05:37:03.000Z	0x3dd702feef95766103ccbe6b43bd098addb776aaa29538c6b5a0802b14d7b580
0xa993ad31ef46873c0193448dbb2f04c0d3854731	0xe681f80966a8b1ffadecf8068bd6f99034791c95	false	0xa993ad31ef46873c0193448dbb2f04c0d3854731	156	4000000000000000	12578102	2021-06-06T02:02:20.000Z	0x84c4922bad2aa6d5259a09707712d1f45ba91004e4338e9866ac77cfe9df8e60
0x375c4952dfe5d5f0eae142f73cf8138ad496a722	0xe681f80966a8b1ffadecf8068bd6f99034791c95	false	0x375c4952dfe5d5f0eae142f73cf8138ad496a722	158	20000000000000000	12646749	2021-06-16T17:06:19.000Z	0xe860d6cbcb0df3f91f78a1b0a25ce4fff75bf25030e53e9dd3c3e90ab098eac2

Example Query

Query with partition filter

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

OVML1ETHGatewayV2_DepositInitiated_event

ETH deposit events initiated through Optimism’s L1 gateway contract on Ethereum mainchain, recording cross-chain transfers from Ethereum to Optimism L2. Tracks sender addresses, recipient addresses, and deposit amounts in wei for analyzing bridge activity and fund flows between L1 and L2.

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
0x1db3439a222c519ab44bb1144fc28167b4fa6ee6	0xf20c38fcddf0c790319fd7431d17ea0c2bc9959c	false	0x1db3439a222c519ab44bb1144fc28167b4fa6ee6	138	100000000000000000	12272962	2021-04-19T21:36:11.000Z	0x22779602d4de7bb144594d539f755941b4b2845be9cef44641be9f98eaedc8aa
0x200aabfdb21beb86250ffe93cac78dc9b9fa3e7d	0xf20c38fcddf0c790319fd7431d17ea0c2bc9959c	false	0x200aabfdb21beb86250ffe93cac78dc9b9fa3e7d	228	50000000000000000	12385685	2021-05-07T06:56:12.000Z	0xf4496d8d30fad40f0b64446339244f89e05a901b1b938caad13ead8df66d4b6c
0x2f8f8fbf095345577b901d88efa8ba4ec3fe8e39	0xf20c38fcddf0c790319fd7431d17ea0c2bc9959c	false	0x2f8f8fbf095345577b901d88efa8ba4ec3fe8e39	280	1000000000000	12239739	2021-04-14T18:09:28.000Z	0x2b864d3a3b60b09f49bfdf49ac2e8a7724b15cdf942ba19f318e90ee3a9f4a75

Example Query

Query with partition filter

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

SynthetixBridgeToOptimismV1_Deposit_event

SNX token deposit events from Ethereum mainnet to Optimism Layer 2 via Synthetix’s official bridge contract. Records user accounts, deposit amounts in wei, and transaction details for tracking cross-chain SNX migrations.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x045e507925d2e05d114534d0810a1abd94aca8d6	false	1009272737885925288593	116	0xcedf17dfafa947cd0e205fe2a3a183cf2fb3a0bc	11995761	2021-03-08T04:44:38.000Z	0x4392f274b44f55cd1ac24fbe5e6555625085ff7c3e3275995dd85f236448e13d
0x045e507925d2e05d114534d0810a1abd94aca8d6	false	2205547743238740331353	157	0xb7d865c7c63d758db991b191e9c80c3867b34b8e	11995381	2021-03-08T03:21:07.000Z	0x9b27f5ac01c929f4b7028939135a2b45777dbe20ca0afcde6ff7ee19b13b1c22
0x045e507925d2e05d114534d0810a1abd94aca8d6	false	110472300000000000000	302	0x8968a2ab1bf4e7120316583792965943b90acb64	11998705	2021-03-08T15:43:40.000Z	0x844fdfb23f7f96f4aecdddd2f41d5e13cf1570d22a4e625786f2d8bf327ca3b2

Example Query

Query with partition filter

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

SynthetixBridgeToOptimismV1_RewardDeposit_event

Reward deposit events from Synthetix bridge transfers from Ethereum mainnet to Optimism L2. Tracks SNX staking reward amounts and recipient accounts for analyzing cross-chain incentive distribution.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x045e507925d2e05d114534d0810a1abd94aca8d6	false	25000000000000000000000	202	0xde910777c787903f78c89e7a0bf7f4c435cbb1fe	12066564	2021-03-19T02:46:52.000Z	0x4ac6c95cf5da7579f1c5fbc3a2951e17f3b9fbf6153c98033b1658d75051799b
0x045e507925d2e05d114534d0810a1abd94aca8d6	false	25000000000000000000000	79	0xde910777c787903f78c89e7a0bf7f4c435cbb1fe	12387330	2021-05-07T13:11:17.000Z	0x15b300fc1538e5b64ecdc6e37871b34eaadc5ae074c52bec2f1b2c4250206951
0x045e507925d2e05d114534d0810a1abd94aca8d6	false	25000000000000000000000	169	0xde910777c787903f78c89e7a0bf7f4c435cbb1fe	11838244	2021-02-11T23:21:41.000Z	0xcf8adc5934b1363d59b7605e9ef17b44ffc28148d176b27291ee22b9f3b481dd

Example Query

Query with partition filter

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

SynthetixBridgeToOptimismV2_DepositInitiated_event

Deposit initiation events from Synthetix’s Ethereum-to-Optimism bridge contract, capturing SNX token transfers being bridged from Ethereum mainnet to Optimism L2. Used for tracking cross-chain token migration activity 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__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
0x196d44adcdf5083a1effd9a8922683fcfc110f5e	0xc51f137e19f1ae6944887388fd12b2b6dfd12594	false	0x196d44adcdf5083a1effd9a8922683fcfc110f5e	513	395166182384185186240	14580993	2022-04-14T02:57:56.000Z	0xb8e63b54ac89ee903f4eadc345b22591d6e24687af9c26eaa6b1c0b5521a4144
0x30cf8aa72c4e69e35e0e48e785176704d6d70c7d	0xc51f137e19f1ae6944887388fd12b2b6dfd12594	false	0x30cf8aa72c4e69e35e0e48e785176704d6d70c7d	227	48835599736072671319378	14583228	2022-04-14T11:16:50.000Z	0x6fa34f2a594dd7ddb666dfe79dfd454271a633318bcd186ccbb16d8cdeb185f4
0x4c9f4cb5f421435a04f7562b5758b9bd12f34680	0xc51f137e19f1ae6944887388fd12b2b6dfd12594	false	0x4c9f4cb5f421435a04f7562b5758b9bd12f34680	327	1318500000000000000000	14582916	2022-04-14T10:07:38.000Z	0x0dbf5e5fa112443ce7973147531f7ca8e4fb22d14cfbb669a9ae5685d77b40a0

Example Query

Query with partition filter

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

SynthetixBridgeToOptimismV2_RewardDepositInitiated_event

Reward deposit events from Synthetix’s Ethereum-to-Optimism bridge contract (v2), capturing SNX token transfers initiated for cross-chain staking rewards. Used for tracking reward migration flows and analyzing cross-chain incentive distribution 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xc51f137e19f1ae6944887388fd12b2b6dfd12594	false	425174700000000000000000	35	0x29c295b046a73cde593f21f63091b072d407e3f2	14490622	2022-03-31T00:00:14.000Z	0xe7129a02c25503494964b43c9c382500fcd69666563db4eb8a4945fb6d8cae75
0xc51f137e19f1ae6944887388fd12b2b6dfd12594	false	556978900000000000000000	52	0x29c295b046a73cde593f21f63091b072d407e3f2	14580227	2022-04-14T00:01:22.000Z	0xa6f05535499557b7a8a94902f27715195842165c96370a262db74de7cb893818
0xc51f137e19f1ae6944887388fd12b2b6dfd12594	false	912997320400000000000000	94	0x29c295b046a73cde593f21f63091b072d407e3f2	14713965	2022-05-05T00:00:33.000Z	0x534de9c85bfa3ac646ef51faa0ac27a4267bc82e2418aebce72fab6d827a8d2d

Example Query

Query with partition filter

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

SynthetixBridgeToOptimismV3_DepositInitiated_event

SNX token deposit events from Ethereum mainnet to Optimism Layer 2 via the Synthetix bridge contract. Records user-initiated cross-chain transfers with sender, recipient, and token amounts for tracking bridge activity and migration 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__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
0x764f4909251f81976a0a2dcebce95333e4c27517	0x39ea01a0298c315d149a490e34b59dbf2ec7e48f	false	0x764f4909251f81976a0a2dcebce95333e4c27517	263	4213080000010000000000	15123721	2022-07-11T21:14:36.000Z	0x7fd286ab8bae0a2bcd03596718603b8a63d0a580c494756c74a8dfd4d4d91308
0xd7f544e39530e8f4217e6e232c52bbb4c0f36ee0	0x39ea01a0298c315d149a490e34b59dbf2ec7e48f	false	0xd7f544e39530e8f4217e6e232c52bbb4c0f36ee0	263	50000000000000000000000	15122237	2022-07-11T15:55:14.000Z	0x9f55d71adf8a1ace9486fc7fb81b2fcae4c0fb4a3c3dce8e1153544aee8ed3a2
0xe0654abc5fb4917ac59237f8b9f75316982cf0bf	0x39ea01a0298c315d149a490e34b59dbf2ec7e48f	false	0xe0654abc5fb4917ac59237f8b9f75316982cf0bf	520	302119000000000000000	15124007	2022-07-11T22:22:00.000Z	0xd4e86b14101feca1abc30096d039aecd0f22887a2429fde108267d5c12d6171c

Example Query

Query with partition filter

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

SynthetixBridgeToOptimismV3_RewardDepositInitiated_event

Reward deposit events from the Synthetix bridge contract on Ethereum L1 initiating SNX token transfers to Optimism L2. Tracks cross-chain reward migrations with account addresses and token amounts for monitoring staking incentive flows.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x39ea01a0298c315d149a490e34b59dbf2ec7e48f	false	130178000000000000000000	83	0x29c295b046a73cde593f21f63091b072d407e3f2	17531464	2023-06-22T00:00:11.000Z	0xb7d613fb4289185df42de1b6323c4ebff26affd02c27ee0b050bb8ee3d533be7
0x39ea01a0298c315d149a490e34b59dbf2ec7e48f	false	130178000000000000000000	34	0x29c295b046a73cde593f21f63091b072d407e3f2	17233414	2023-05-11T00:00:11.000Z	0xece9a57a68d190b7199a077e4afd7acbd8103828d73bc596411b2fef0df5ad5b
0x39ea01a0298c315d149a490e34b59dbf2ec7e48f	false	217135000000000000000000	30	0x29c295b046a73cde593f21f63091b072d407e3f2	16437130	2023-01-19T00:00:11.000Z	0x5d7a5311a3fc63a8389559b1e0e5a2de432bbf85c396da52debdd2fc8a3a257d

Example Query

Query with partition filter

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

TeleportrDeposit_EtherReceived_event

Ethereum deposit events from Optimism’s Teleportr fast bridge contract, recording ETH deposits with amounts (in wei), deposit IDs, and depositor addresses. Used for tracking cross-chain bridging activity and analyzing Teleportr 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_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_emitter`	`STRING`	Ethereum address of the user who initiated the Teleportr deposit on the source chain. Hex-encoded, 0x-prefixed 40-character string representing the original depositor’s wallet address.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_emitter	block_number	in_depositId	block_timestamp	transaction_hash
0x52ec2f3d7c5977a8e558c8d9c6000b615098e8fc	false	100000000000000	441	0x4337e5f8e38582af88f55dec23d5923d6ba3818e	14925434	49191	2022-06-08T07:15:54.000Z	0x361ece9570209edaf8b9f94665de4e316c4ac375b3bfd1002ac6699f8ab5be5f
0x52ec2f3d7c5977a8e558c8d9c6000b615098e8fc	false	100000000000000	104	0x9fd94aef0f95919267081557a3cb550bceb8bb84	14926069	49246	2022-06-08T09:54:40.000Z	0xcb689573f14c3e5876ee6c4ad482aa8de6007ac436450b3f8176e748f9869483
0x52ec2f3d7c5977a8e558c8d9c6000b615098e8fc	false	100000000000000	205	0xf96e38bce53dbbaa6cb16e7a48c481cb7a97f61e	14928063	49477	2022-06-08T17:53:18.000Z	0x54019c785c0af970bad48bec6f768445f78bf4a58d049d67c91b649eb1d36f78

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BitBTCL1Bridge_ERC20DepositInitiated_event

BridgeDeposit_EtherReceived_event

L1DAITokenBridge_ERC20DepositInitiated_event

L1ECOBridge_ERC20DepositInitiated_event

L1ERC20TokenBridge_ERC20DepositInitiated_event

L1StandardBridge_ERC20DepositInitiated_event

L1StandardBridge_ETHDepositInitiated_event

L1USXTokenBridge_ERC20DepositInitiated_event

OVML1ETHGatewayV1_DepositInitiated_event

OVML1ETHGatewayV2_DepositInitiated_event

SynthetixBridgeToOptimismV1_Deposit_event

SynthetixBridgeToOptimismV1_RewardDeposit_event

SynthetixBridgeToOptimismV2_DepositInitiated_event

SynthetixBridgeToOptimismV2_RewardDepositInitiated_event

SynthetixBridgeToOptimismV3_DepositInitiated_event

SynthetixBridgeToOptimismV3_RewardDepositInitiated_event

TeleportrDeposit_EtherReceived_event

​Tables

​BitBTCL1Bridge_ERC20DepositInitiated_event

​BridgeDeposit_EtherReceived_event

​L1DAITokenBridge_ERC20DepositInitiated_event

​L1ECOBridge_ERC20DepositInitiated_event

​L1ERC20TokenBridge_ERC20DepositInitiated_event

​L1StandardBridge_ERC20DepositInitiated_event

​L1StandardBridge_ETHDepositInitiated_event

​L1USXTokenBridge_ERC20DepositInitiated_event

​OVML1ETHGatewayV1_DepositInitiated_event

​OVML1ETHGatewayV2_DepositInitiated_event

​SynthetixBridgeToOptimismV1_Deposit_event

​SynthetixBridgeToOptimismV1_RewardDeposit_event

​SynthetixBridgeToOptimismV2_DepositInitiated_event

​SynthetixBridgeToOptimismV2_RewardDepositInitiated_event

​SynthetixBridgeToOptimismV3_DepositInitiated_event

​SynthetixBridgeToOptimismV3_RewardDepositInitiated_event

​TeleportrDeposit_EtherReceived_event

Tables

BitBTCL1Bridge_ERC20DepositInitiated_event

BridgeDeposit_EtherReceived_event

L1DAITokenBridge_ERC20DepositInitiated_event

L1ECOBridge_ERC20DepositInitiated_event

L1ERC20TokenBridge_ERC20DepositInitiated_event

L1StandardBridge_ERC20DepositInitiated_event

L1StandardBridge_ETHDepositInitiated_event

L1USXTokenBridge_ERC20DepositInitiated_event

OVML1ETHGatewayV1_DepositInitiated_event

OVML1ETHGatewayV2_DepositInitiated_event

SynthetixBridgeToOptimismV1_Deposit_event

SynthetixBridgeToOptimismV1_RewardDeposit_event

SynthetixBridgeToOptimismV2_DepositInitiated_event

SynthetixBridgeToOptimismV2_RewardDepositInitiated_event

SynthetixBridgeToOptimismV3_DepositInitiated_event

SynthetixBridgeToOptimismV3_RewardDepositInitiated_event

TeleportrDeposit_EtherReceived_event