> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# weth_v1_ethereum

> Tables in tt-contracts.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.

<Accordion title="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.                                |
</Accordion>

<Accordion title="Sample Data">
  | in\_guy                                    | in\_src                                    | in\_wad | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x8da0d80f5007ef1e431dd2127178d224e32c2ef4 | 0x59c15da29190c9e4a7eaa695b626d9c76c193615 | 0       | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | false   | 109        | 5272255       | 2018-03-17T16:19:37.000Z | 0xb65c92508f4df85b1995537c56c0a424111f54384cd7c038146d85fb8f13587f |
  | 0x8da0d80f5007ef1e431dd2127178d224e32c2ef4 | 0x68bea029960e79d74de9a8186302c2a544cc084b | 0       | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | false   | 7          | 5272330       | 2018-03-17T16:35:50.000Z | 0x0726d10196da5da8eb7981f06837c1fca4587745ff702b35c2a692dfe340cef5 |
  | 0x8da0d80f5007ef1e431dd2127178d224e32c2ef4 | 0xd90d334ce5e30b5d9d29a64c95db914d9a0aa6e1 | 0       | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | false   | 110        | 5273714       | 2018-03-17T21:55:20.000Z | 0x5970b9d16ff06c656f12dae5e2f87790ec242e7fef2533f9ba5415f6e55578f3 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.weth_v1_ethereum.WETH9_Approval_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.weth_v1_ethereum.WETH9_Deposit_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.weth_v1_ethereum.WETH9_Transfer_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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).

<Accordion title="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.                                |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.weth_v1_ethereum.WETH9_Withdrawal_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***
