weth_v1_ink

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	address	removed	block_number	block_timestamp	transaction_hash
0x2314b13cc64afd04c36f78147b70554d910961c1	0x4200000000000000000000000000000000000006	false	2420997	2025-01-03T15:50:08.000Z	0x25aca95d8f9367bab3f206ad28d51e07810f8e5f3883161799c9832ba4fbf397
0x2314b13cc64afd04c36f78147b70554d910961c1	0x4200000000000000000000000000000000000006	false	2421101	2025-01-03T15:51:52.000Z	0x2c6fb32411d1e7612f7840383c594b74086983c252f94138551f8d0e743cf692
0x2314b13cc64afd04c36f78147b70554d910961c1	0x4200000000000000000000000000000000000006	false	2420933	2025-01-03T15:49:04.000Z	0x55de945b50169a0f50d9439c7ab98164a7fa90a103fe31926b6477e61ec5f7b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_ink.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	block_number	block_timestamp	transaction_hash
0x00bd1072565d923ee224bf7e0d5cc843ab83dddd	590000000000000000	0x4200000000000000000000000000000000000006	false	3405584	2025-01-15T01:19:55.000Z	0x15ce1ab87494abcc4781283d59cefc61802a1ed28302ae4c53aaa6111b897acd
0x0202745c59aad44344adf924f21d87c7c82ed75c	1000000000000000	0x4200000000000000000000000000000000000006	false	3441456	2025-01-15T11:17:47.000Z	0x2bd52d4a1a289f7593b9f08c2bae5950f5f100f996cc93664328b39b480ab4d3
0x026aafca26038b3c8db7709573bad8fc6f347ac9	330000000000000	0x4200000000000000000000000000000000000006	false	3451577	2025-01-15T14:06:28.000Z	0xc9585d537bb8af65e19f72d220de2ba95394b949203cad130869a8b265f869d3

Example Query

Query with partition filter

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