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

# pooltogether_v4_ethereum

> Tables in tt-contracts.pooltogether_v4_ethereum

## Tables

### PrizeDistributor\_ClaimedDraw\_event

Prize claim events from PoolTogether V4 on Ethereum recording when users collect winnings from specific draw IDs. Used for analyzing prize distribution patterns, winner behavior, and payout amounts across lottery draws.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_drawId`        | `STRING`    | Unique identifier for a prize draw in the PoolTogether lottery protocol. Numeric string representing the sequential draw number.                     |
  | `in_payout`        | `STRING`    | Payout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_drawId | in\_payout | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe | 0xa8b5c87a0566539bb954254d2e7fcc63b43ef5d6 | false   | 104        | 999998     | 84         | 14274732      | 2022-02-25T10:34:00.000Z | 0x89289c214d1a4d5aa9cb168de1b6fe77a17c404d88f67dd9c6c8295b4db948c4 |
  | 0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe | 0x20b54a8fa6713adb32c097e3401ed48454ae1b08 | false   | 674        | 99999984   | 186        | 18167312      | 2023-09-19T03:34:23.000Z | 0x6f645aabab17e121498c945f4ad75fea8ad99738ad7013520170c7277474d313 |
  | 0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe | 0x21b65759c6309e000703c918d146c4a6fd3c6af9 | false   | 663        | 99999984   | 150        | 18167163      | 2023-09-19T03:04:11.000Z | 0xb921b33b20589205f800fba216dd2ce191eb02af8a273a407d84f6f046105f86 |
</Accordion>

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

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

***

### Rewards\_Claimed\_event

Reward claim events from PoolTogether V4 prize savings protocol on Ethereum, tracking user addresses and token amounts distributed. Contains block-level transaction data for analyzing prize distribution patterns and claiming behavior across the protocol's no-loss lottery system.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_newTokens`     | `STRING`    | Amount of tokens claimed by the user in the event. Integer value stored as string representing the smallest token unit.                              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | log\_index | block\_number | in\_newTokens         | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | --------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x9a29401ef1856b669f55ae5b24505b3b6faeb370 | 0xbd5361a94c803d26240a6b5586710ab48ed1d9dd | false   | 126        | 13658636      | 20842719424062494753  | 2021-11-21T14:10:34.000Z | 0x82b42f78feb8465eaaaf999b02064d9bea13913da78cc7815d1b4a1fa42ee21f |
  | 0x30430419b86e9512e6d93fc2b0791d98dbeb637b | 0xaa9e424439209e642b52d3af8c875d8340566ac4 | false   | 528        | 13657230      | 17010363103787964530  | 2021-11-21T08:58:55.000Z | 0x0327da9246b16b7026e7cac7c34acd49c23bcf4c9c7289c2a1eb68a3fe480409 |
  | 0x9a29401ef1856b669f55ae5b24505b3b6faeb370 | 0x21d4e34b6469a885b8c4f220df24af0f8a654d4d | false   | 46         | 16017974      | 160824028817012292923 | 2022-11-21T11:05:11.000Z | 0x89e41e5ee47875c556bab80ec43e20c0f26955867110341ba0abe1f2313f8aaa |
</Accordion>

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

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

***

### TokenFaucet\_Claimed\_event

Token reward claims from PoolTogether V4 faucet contracts on Ethereum, recording when users claim accrued incentive tokens with claim amounts and faucet addresses. Used for analyzing reward distribution patterns and user engagement with liquidity mining programs.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_newTokens`     | `STRING`    | Amount of tokens claimed by the user in the event. Integer value stored as string representing the smallest token unit.                              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | log\_index | block\_number | in\_newTokens         | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | --------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xbd537257fad96e977b9e545be583bbf7028f30b9 | 0x122cedcbeea359a03b9e5c22ff17d171d585eb1d | false   | 232        | 16462795      | 115071250871903639    | 2023-01-22T13:59:23.000Z | 0xa0383f5deb1e7775aaf258e3c92e8329d4993f3f0dce1b5b5e299af9184d7045 |
  | 0xf362ce295f2a4eae4348ffc8cdbce8d729ccb8eb | 0x96c28f1bc8e4f08a5e98c402a9d9750517c4301b | false   | 240        | 13557972      | 301282724884490710000 | 2021-11-05T17:31:16.000Z | 0x3bfcba18f8d81014c94faf7af1df5ae2bff631e1d21d20bc6d3a87508f33902d |
  | 0x72f06a78bbaac0489067a1973b0cef61841d58bc | 0xabba3179bd6dc2e5d4e15278a7903a5208395ae7 | false   | 76         | 13556479      | 19178445111999575     | 2021-11-05T12:01:24.000Z | 0x0698eb1f47c796b2767fb61b4c31d82d3a92dcbe3a6bb385db34d1b2370439d3 |
</Accordion>

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

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

***

### TokenFaucetFactory\_ProxyCreated\_event

Factory deployment events for PoolTogether V4 token faucet proxies on Ethereum. Records proxy contract addresses created by the factory for tracking drip distribution contract deployments.

<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_proxy`         | `STRING`    | Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.                                                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_proxy                                  | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xe19fe7a9aa49585510041ecde274f6926c212c43 | false   | 0xbd537257fad96e977b9e545be583bbf7028f30b9 | 137        | 11876980      | 2021-02-17T22:08:49.000Z | 0x288342cd3fee03b989ded4debd9e933f21eb795378302225543f5761656c7c73 |
  | 0xe19fe7a9aa49585510041ecde274f6926c212c43 | false   | 0xf362ce295f2a4eae4348ffc8cdbce8d729ccb8eb | 250        | 11876960      | 2021-02-17T22:05:52.000Z | 0xb9bfcf1e28d18180445a17fc7f78000d90048dad10aff22767e0250f16da5b29 |
  | 0xe19fe7a9aa49585510041ecde274f6926c212c43 | false   | 0x72f06a78bbaac0489067a1973b0cef61841d58bc | 203        | 11877020      | 2021-02-17T22:19:55.000Z | 0xc3a899171867a294fb23521597ac71693646cbd133b6feb509b60f81536dd1da |
</Accordion>

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

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

***

### TokenFaucetFactoryV2\_ProxyCreated\_event

Factory deployment events for PoolTogether V4 token faucet proxies on Ethereum, capturing each new faucet instance creation with its proxy contract address. Used for tracking the expansion of reward distribution infrastructure across different prize pools.

<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_proxy`         | `STRING`    | Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.                                                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_proxy                                  | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xe4e9cdb3e139d7e8a41172c20b6ed17b6750f117 | false   | 0xddcf915656471b7c44217fb8c51f9888701e759a | 88         | 12603518      | 2021-06-10T00:20:20.000Z | 0x99b98a07c28d433a8e71ca1321d397d8d6745c970e38b14217e330b66036af6c |
  | 0xe4e9cdb3e139d7e8a41172c20b6ed17b6750f117 | false   | 0x30430419b86e9512e6d93fc2b0791d98dbeb637b | 284        | 12077246      | 2021-03-20T18:13:55.000Z | 0x5c969885d5ce90dd66f37e046b0575178652431a6908df616d110bda4078208e |
  | 0xe4e9cdb3e139d7e8a41172c20b6ed17b6750f117 | false   | 0xa8094ace7c4114db99f6c2a3bd01eaa883199569 | 371        | 12788874      | 2021-07-08T20:32:07.000Z | 0x707af11bd342450bc3e942473ae5a7dc58fbce2dce25e15eb48f30e16727890c |
</Accordion>

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

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

***

### TokenFaucetV2\_Claimed\_event

Token reward claim events from PoolTogether V4 on Ethereum, recording when users claim accrued tokens through the protocol's faucet mechanism. Contains user addresses, claimed token amounts (in wei), and transaction metadata for analyzing reward distribution and user engagement patterns.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_newTokens`     | `STRING`    | Amount of tokens claimed by the user in the event. Integer value stored as string representing the smallest token unit.                              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | log\_index | block\_number | in\_newTokens       | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x30430419b86e9512e6d93fc2b0791d98dbeb637b | 0x02fb37f0c8d6ebd4e2726e7914e20bb648c62418 | false   | 2          | 15761104      | 3872975059920666217 | 2022-10-16T13:54:11.000Z | 0x127ed389fab01648a840e2a3441bb609327d0053978f9121743a8cd31d3ffcb8 |
  | 0x30430419b86e9512e6d93fc2b0791d98dbeb637b | 0x8522885d735f75b3faeea5cd39ab3d1291da2c77 | false   | 257        | 12305696      | 2680732642861883382 | 2021-04-24T22:39:01.000Z | 0x97bf5be398129f8069908d7d3d58b5a5d4ae56e2e2734795b4974e942548b009 |
  | 0x30430419b86e9512e6d93fc2b0791d98dbeb637b | 0xbd6c934afa35452c30b833533a59d4986031085c | false   | 291        | 12303335      | 4986564536394987875 | 2021-04-24T14:00:11.000Z | 0x7f8b9ef1734d5ba5ee8d5ea963427459e1f92cc70f8f161653f2c32de88503e0 |
</Accordion>

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

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

***

### YieldSourcePrizePool\_Deposited\_event

PoolTogether V4 deposit events recording token contributions to yield-generating prize pools. Captures operator, recipient, token address, and deposit amount for tracking user participation in the no-loss lottery protocol.

<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_operator`      | `STRING`    | Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.                             |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_token`         | `STRING`    | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                               |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_token                                  | in\_amount | log\_index | in\_operator                               | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x761d584f1c2d43cbc3f42ecd739701a36dffaa31 | 0xd89a09084555a7d0abe7b111b1f78dfeddd638be | false   | 0xdd4d117723c257cee402285d3acf218e9a8236e1 | 10400000   | 229        | 0x761d584f1c2d43cbc3f42ecd739701a36dffaa31 | 15604869      | 2022-09-24T17:59:35.000Z | 0x03615dbfc82c5063978b52c48d663d9dab965974322a0469c63a58fdbb46fc2c |
  | 0x2d4e519634cd0887de24cb853a76036484928341 | 0xd89a09084555a7d0abe7b111b1f78dfeddd638be | false   | 0xdd4d117723c257cee402285d3acf218e9a8236e1 | 9870000    | 185        | 0x2d4e519634cd0887de24cb853a76036484928341 | 15599891      | 2022-09-24T01:20:11.000Z | 0x0a4a87b1f36ad5ed5f7ee1e12474be36fc9fbd6db2361096d005191564562b7a |
  | 0xc59292b1caf144f2877a88b120b4e71e48385569 | 0xd89a09084555a7d0abe7b111b1f78dfeddd638be | false   | 0xdd4d117723c257cee402285d3acf218e9a8236e1 | 50000000   | 226        | 0xc59292b1caf144f2877a88b120b4e71e48385569 | 15605191      | 2022-09-24T19:05:35.000Z | 0x379f85ed419a1c02dba3526d05c4321c93ba8206d492fe3f186063af250c15a2 |
</Accordion>

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

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

***

### YieldSourcePrizePool\_Withdrawal\_event

Withdrawal events from PoolTogether V4 yield source prize pools recording token redemptions and operator-authorized transfers. Tracks user address, token contract, withdrawal amount, and redeemed quantity for prize pool exit operations.

<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_operator`      | `STRING`    | Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.                                  |
  | `in_from`          | `STRING`    | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                             |
  | `in_token`         | `STRING`    | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                           |
  | `in_redeemed`      | `STRING`    | Amount of underlying yield-bearing tokens redeemed in the withdrawal operation. Numeric string representation of token quantity in smallest denomination. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_from                                   | removed | in\_token                                  | in\_amount    | log\_index | in\_operator                               | in\_redeemed  | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------- | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xd89a09084555a7d0abe7b111b1f78dfeddd638be | 0xa5c3a513645a9a00cb561fed40438e9dfe0d6a69 | false   | 0xdd4d117723c257cee402285d3acf218e9a8236e1 | 1000000000    | 285        | 0xa5c3a513645a9a00cb561fed40438e9dfe0d6a69 | 1000000000    | 15224931      | 2022-07-27T13:56:33.000Z | 0x210f222e12900bbbb56c69abf2a5e3d35cbb8ac23e267f3e4f1eea26ca1ce2ba |
  | 0xd89a09084555a7d0abe7b111b1f78dfeddd638be | 0x208b3cd5166df7ac646ca6e9393f336d3e4c4c51 | false   | 0xdd4d117723c257cee402285d3acf218e9a8236e1 | 10000000000   | 160        | 0x208b3cd5166df7ac646ca6e9393f336d3e4c4c51 | 10000000000   | 15222696      | 2022-07-27T05:50:38.000Z | 0x38c04fb7d738e2c9025f2f4a48d113957c4abf782ae20b5d18ffa1bda3d7b7fe |
  | 0xd89a09084555a7d0abe7b111b1f78dfeddd638be | 0xf63f5fcc54f5fd11f3c098053f330e032e4d9259 | false   | 0xdd4d117723c257cee402285d3acf218e9a8236e1 | 1656075000000 | 244        | 0xf63f5fcc54f5fd11f3c098053f330e032e4d9259 | 1656075000000 | 15793096      | 2022-10-21T01:08:35.000Z | 0xd49c72d7e8a0819fdd9c6d2f30d7fcbe822fe9bd79b89e160ac14ef6356b6e75 |
</Accordion>

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

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

***