weth_v1_worldchain

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	block_number	block_timestamp	transaction_hash
0x7a250d5630b4cf539739df2c5dacb4c659f2488d	1000000000000000	0x4200000000000000000000000000000000000006	false	4324674	2024-10-03T19:49:47.000Z	0x6e67ba58de60bb26f504991be53efbe3b27ea0995954e055a87df5801bf7f069
0x07964f135f276412b3182a3b2407b8dd45000000	7976000000000000	0x4200000000000000000000000000000000000006	false	6573326	2024-11-24T21:04:51.000Z	0x76d5600e00beffa70037b39e5ae8e460564ac45288f3957bb2651a339df30e46
0x07964f135f276412b3182a3b2407b8dd45000000	10568200000000000	0x4200000000000000000000000000000000000006	false	6560055	2024-11-24T13:42:29.000Z	0x882bb01cd4d8835d41bda26134fe6749e87dc50dd252b8ebb14f0ef180bb690f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_worldchain.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
0x000000000004ebb9d0b43ecec041ecaec8b7f423	32436707500875	0x4200000000000000000000000000000000000006	false	3	13836236	2025-05-12T00:01:51.000Z	0xebd2aa4fe02f3981b6f0569c8b0898a587194beda144f34136cbd6f66db8bd52
0x000000000004ebb9d0b43ecec041ecaec8b7f423	8614193393143	0x4200000000000000000000000000000000000006	false	0	13836797	2025-05-12T00:20:33.000Z	0x30f14fa83bf6816769ae7b8690723e358d2cf4f1317e28fcaf34c05b03df4fac
0x000000000004ebb9d0b43ecec041ecaec8b7f423	515342330190458	0x4200000000000000000000000000000000000006	false	0	13836855	2025-05-12T00:22:29.000Z	0x1f1a66d79cb691e9ed9aa08172364d91f2518bb3718d194db6c4708d023423df

Example Query

Query with partition filter

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