> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# optimismgateway_v1_optimism
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.optimismgateway_v1_optimism.SynthetixBridgeToBaseV3_WithdrawalInitiated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***