weth_v1_bob

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
0x01dbe3111b658dd9033e78c8a8c1a6410e9cb8f0	11174600000000000	0x4200000000000000000000000000000000000006	false	3943748	2024-07-12T01:58:03.000Z	0x47235577504930dcbf1c33eb488a3deea14c72d23749ed494aa8a29dcc382339
0x0e9e167754a8933b2321f6ac8ddd2645846842ed	3000000000000000	0x4200000000000000000000000000000000000006	false	3950874	2024-07-12T05:55:35.000Z	0xc158272d35d550906033618275b0b49fa9fe26439953f33c0acbb5ca658627f3
0x0ea6ee8164028d7af73be1a73ffc3a68abad9c0b	3200000000000000	0x4200000000000000000000000000000000000006	false	3956905	2024-07-12T09:16:37.000Z	0xa122726eb1b29199a5323be7373d2694b53ef6095399ccf89da8d5e9e70bbfba

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_bob.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
0xbbcef623918de74017b17ff2888f4fe6211e17d8	1000000000000000	0x4200000000000000000000000000000000000006	false	8798324	2024-11-01T10:57:15.000Z	0x1f1197cbdeedc1b0f31b95e9494b61b3735888519c490fb429b9b5417d843d95
0x471f6506215083559e52f7fabaf391a09f3cd159	1000000000000000	0x4200000000000000000000000000000000000006	false	8789723	2024-11-01T06:10:33.000Z	0x2cb2433d994c1b7d42fd36e1a4df816d6b5b70177a81cc90ba1baaa2c583b588
0xee61ad386685ebef89c39fed745b55b64a109153	5000000000000000	0x4200000000000000000000000000000000000006	false	8810493	2024-11-01T17:42:53.000Z	0x24ae5b454725eea6e0a8152902b72198d09ef99336b5c5b7ff89d15140c4b120

Example Query

Query with partition filter

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