weth_v1_optimism

Tables

WETH9_Deposit_event

WETH9 (Wrapped Ether version 9) deposit events emitted when native ETH is converted to ERC-20 wrapped tokens. Contains recipient address and deposit amount in WAD units (18 decimal precision) for tracking ETH wrapping 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_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_dst	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x00000000000013adddc0919642d45f5d9df09502	2245000000000000	0x4200000000000000000000000000000000000006	false	12	105513154	2023-06-13T02:58:05.000Z	0xd94e4d4806c1a3722226318f4372746a70c69ddf95e8784f9f8c551d976aab3c
0x00000000000013adddc0919642d45f5d9df09502	6333000000000000	0x4200000000000000000000000000000000000006	false	20	105513040	2023-06-13T02:54:17.000Z	0x23c6b8725dfb8f5b844b978fa06bfe729c4ef892baf76c74148ff070f02a2614
0x00000000000013adddc0919642d45f5d9df09502	10225000000000000	0x4200000000000000000000000000000000000006	false	22	105512834	2023-06-13T02:47:25.000Z	0xadb61067f861f2a999c82ee089f9d11df02af4544d4930ff617bbae328b0297c

Example Query

Query with partition filter

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

WETH9_Withdrawal_event

WETH9 withdrawal events emitted when unwrapping wrapped Ether (WETH) back to native ETH. Contains withdrawing address and amount in WAD units (18 decimal precision).

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_src	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x00000000000013adddc0919642d45f5d9df09502	15905825894784114	0x4200000000000000000000000000000000000006	false	4	4798762	2022-03-24T13:44:14.000Z	0xd4828b4c2a97cba943c76d9f413673fdef78878cdc1ca6735f861c6bd6e8e25a
0x00000000000013adddc0919642d45f5d9df09502	21723617249494429	0x4200000000000000000000000000000000000006	false	4	4775270	2022-03-24T03:38:28.000Z	0x7ce17ff9131d9ec183496142081c4a7811a46301d7530ca44ecf8b20b59e8249
0x00000000000013adddc0919642d45f5d9df09502	47990813360069824	0x4200000000000000000000000000000000000006	false	4	4787106	2022-03-24T08:47:42.000Z	0x6cfe49347c9ca238a0323e086ea7f7faaed9cecc88061214eceb6e45fd8f5ff3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

WETH9_Deposit_event

WETH9_Withdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​WETH9_Deposit_event

​WETH9_Withdrawal_event

Tables

WETH9_Deposit_event

WETH9_Withdrawal_event