weth_v1_ethereum

Tables

WETH9_Approval_event

ERC-20 approval events from the Wrapped Ether (WETH) contract on Ethereum, recording when token holders grant spending allowances to other addresses. Used for analyzing WETH delegation patterns and DEX (decentralized exchange) integration behavior.

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_guy`	`STRING`	Address of the spender or recipient approved to transfer tokens. 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_guy	in_src	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x8da0d80f5007ef1e431dd2127178d224e32c2ef4	0x59c15da29190c9e4a7eaa695b626d9c76c193615	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	109	5272255	2018-03-17T16:19:37.000Z	0xb65c92508f4df85b1995537c56c0a424111f54384cd7c038146d85fb8f13587f
0x8da0d80f5007ef1e431dd2127178d224e32c2ef4	0x68bea029960e79d74de9a8186302c2a544cc084b	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	7	5272330	2018-03-17T16:35:50.000Z	0x0726d10196da5da8eb7981f06837c1fca4587745ff702b35c2a692dfe340cef5
0x8da0d80f5007ef1e431dd2127178d224e32c2ef4	0xd90d334ce5e30b5d9d29a64c95db914d9a0aa6e1	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	110	5273714	2018-03-17T21:55:20.000Z	0x5970b9d16ff06c656f12dae5e2f87790ec242e7fef2533f9ba5415f6e55578f3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_ethereum.WETH9_Approval_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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
0x5427fefa711eff984124bfbb1ab6fbf5e3da1820	10000000000000000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	174	15031552	2022-06-27T00:01:55.000Z	0x4628e91c6f83f6673bcadb5a064c5bcd5c3dcdab992aeb1fd0b20639a52fb730
0x8983ad6d63d7ab3701d74e1e72fd9dadf113f3f9	660000000000000000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	197	15031552	2022-06-27T00:01:55.000Z	0xf69f432ef789af48acf1615a4ab375825bf3863f0be975f8e153d6a460312a8b
0x5427fefa711eff984124bfbb1ab6fbf5e3da1820	50000000000000000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	71	15031552	2022-06-27T00:01:55.000Z	0x5f288a74b714e68874f809f2490dcaf087d4dd32bf087ba81e1810fa31abba92

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_ethereum.WETH9_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WETH9_Transfer_event

WETH9 (Wrapped Ether) ERC-20 transfer events on Ethereum mainnet, tracking movements between addresses with transfer amounts in wei. Used for analyzing WETH token flows, liquidity movements, and identifying major holders or protocol interactions.

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_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_src	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x85c5c26dc2af5546341fc1988b9d178148b4838b	0x0004e79c978b95974dca16f56b516be0c50cc652	4897875141154601526	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	79	6786804	2018-11-28T06:58:38.000Z	0x00d23da16bcfea68ccb10ddc4bf4308d822e247da8232b44d47c9a2b2c23a147
0x14fbca95be7e99c15cc2996c6c9d841e54b79425	0x0005abcbb9533cf6f9370505ffef25393e0d2852	45000000000000000000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	52	6785290	2018-11-28T00:55:41.000Z	0x15467f9d1b35d3cb2a0224e879ccc7d644dda4ff9874bb4cc7c5e6b68fb8a3c1
0x14fbca95be7e99c15cc2996c6c9d841e54b79425	0x0005abcbb9533cf6f9370505ffef25393e0d2852	45000000000000000000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	5	6789901	2018-11-28T19:18:50.000Z	0x4ad1c96fcac98ed167714f0eaf5a6b7a537b8eb75654163b701d6073f09101c9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_ethereum.WETH9_Transfer_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
0x000000000000006f6502b7f2bbac8c30a3f67e9a	30142329069577990919	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	92	10355901	2020-06-28T18:25:00.000Z	0xc174a856756cf7a9de3daa240597c20d70f4d537abce65ffb65b1fb798be7756
0x000000000000006f6502b7f2bbac8c30a3f67e9a	3055347725172721370	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	67	10355613	2020-06-28T17:20:44.000Z	0x6a7f30102a14c6a1d9f94fffe051aa74c321f70e6efb6e7138af259e7d333cc3
0x000000000000006f6502b7f2bbac8c30a3f67e9a	12228411848624994789	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	false	167	10351601	2020-06-28T02:39:48.000Z	0x0983a7a1a3ed44abcfac8fb54c424129520bf933875dc0f06f2254dd0be67571

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.weth_v1_ethereum.WETH9_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

WETH9_Approval_event

WETH9_Deposit_event

WETH9_Transfer_event

WETH9_Withdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​WETH9_Approval_event

​WETH9_Deposit_event

​WETH9_Transfer_event

​WETH9_Withdrawal_event

Tables

WETH9_Approval_event

WETH9_Deposit_event

WETH9_Transfer_event

WETH9_Withdrawal_event