weth_v1_bobanetwork

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
0x0f175392971a0a90f59e2c0b40f2d7bdc2f5b6c7	210000000000000000	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	false	986419	2023-03-23T18:55:39.000Z	0x3c68a6cf5c3f6a30cf19a466b284be20a75778767bb4380fb41a81505c0da4f8
0x17c83e2b96acfb5190d63f5e46d93c107ec0b514	15100000000000000	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	false	985932	2023-03-23T00:31:15.000Z	0x726578f5ceab4559ae53e020dbec05ac370f523069849ea7a7aa4347cb274618
0x17c83e2b96acfb5190d63f5e46d93c107ec0b514	1685656486864340	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	false	986338	2023-03-23T16:31:25.000Z	0x96a2b6be5c085ed6398e311b25fb2d3b8c91751dbaec762ef81a965c62630d07

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_bobanetwork.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
0x17c83e2b96acfb5190d63f5e46d93c107ec0b514	72623395519887587	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	false	5	1045921	2023-08-10T19:17:08.000Z	0x1e4d8b342894fcdd0fdb865b4bb2216b94e915a8007269df752109302afc0078
0x17c83e2b96acfb5190d63f5e46d93c107ec0b514	768479661699321063	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	false	5	1045932	2023-08-10T19:34:16.000Z	0x763043cdcfc2dacb54f8a8770a20b93a62c59b1cd48f94baa39032b2479103cb
0x0f175392971a0a90f59e2c0b40f2d7bdc2f5b6c7	150000000000000000	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000	false	5	958901	2023-02-06T16:19:26.000Z	0x4e100a96930d9eba9e8d1d23430c0d4298dd648191f5faceb2bf9ff6a9d46be5

Example Query

Query with partition filter

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