weth_v1_base

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
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	40000000000000	0x4200000000000000000000000000000000000006	false	19	6733844	2023-11-17T21:37:15.000Z	0x65d30c1ba6c5f098a2b0feb150d40d8bdc3aae0bbc7ef309ec21bb1d4f7b87a6
0x001b71fad769b3cd47fd4c9849c704fdfabf6096	1700000000000000000	0x4200000000000000000000000000000000000006	false	18	6716077	2023-11-17T11:45:01.000Z	0x0d707626464cc12c3323b3f8cac4ace5ab6316a8c1d2d49fd35a100f20298af9
0x016222aa9d31c94a8697307c33fbbecf0f2a06b1	230000000000000	0x4200000000000000000000000000000000000006	false	17	6714752	2023-11-17T11:00:51.000Z	0x3f08b8f7e1a6fdcc9e2edcb018d0f3014ba2dfe94f5a1486e8ecfbec5f5d1902

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_base.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
0x00000000edb4489cb49fe07246f39345c9f838cd	23805792576	0x4200000000000000000000000000000000000006	false	36	7986796	2023-12-16T21:42:19.000Z	0xbfec8615a5f99b4fc90b7532f8437aa4d81458a4e81a277368183af33eba7306
0x00010a9bbde3f6ec395c179e36f1df24e59bd824	1132900460279808	0x4200000000000000000000000000000000000006	false	10	7957074	2023-12-16T05:11:35.000Z	0x9511f305d369d5cc8785ee8ba60529480c87a261bddf585da91b6ecf3124e589
0x001bf8ea6606d5e5019897b9ec32d1662fc857d6	1890000000000000000	0x4200000000000000000000000000000000000006	false	0	7949827	2023-12-16T01:10:01.000Z	0x53889a93977e0d2745be6f87da9a60892c3affb137e63c99009093ffb1712015

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_base.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