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

# bmx_v2_base

> Tables in tt-contracts.bmx_v2_base

## Tables

### DailyEpochGauge\_Claimed\_event

Reward claim events from BMX V2 protocol's daily epoch gauge system on Base, tracking user addresses and token amounts claimed from liquidity mining or staking programs. Used for analyzing reward distribution patterns and participant behavior across daily reward epochs.

<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_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount          | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xd8df4f5a4ae2db7ea724d1ee451806167f01f0dc | 0x3e6edba22d9ce22a7168406d26598ae20fe08e41 | false   | 912287920268930838  | 957        | 38200092      | 2025-11-15T06:52:11.000Z | 0xcc3b5bd618295257edbb0778b1f64a6603443fac08aa98e9d548a9669ce11262 |
  | 0xd8df4f5a4ae2db7ea724d1ee451806167f01f0dc | 0x606d2c436a07be40c276a6176bb1376c34e49ee9 | false   | 60751159896718215   | 1134       | 38214153      | 2025-11-15T14:40:53.000Z | 0x39d8b70e5b286d2364cdf24a57ccfb6f69ec1ca889d171b0d5db624783f432e3 |
  | 0xd8df4f5a4ae2db7ea724d1ee451806167f01f0dc | 0x606d2c436a07be40c276a6176bb1376c34e49ee9 | false   | 2838311125923142155 | 288        | 38214304      | 2025-11-15T14:45:55.000Z | 0xa26faeb43f18207f5e45f0a7fc499e257dcece29729085bcc0b89d6bfa9567f3 |
</Accordion>

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

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

***

### DailyEpochGauge\_RewardsAdded\_event

Reward distribution events from BMX v2 liquidity gauge system on Base, recording token amounts added to specific pool gauges. Used for tracking incentive allocations and yield distribution across liquidity 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_poolId`        | `STRING`    | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.                                               |
  | `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">
  | address                                    | removed | in\_amount         | in\_poolId                                                         | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------ | ------------------------------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xd8df4f5a4ae2db7ea724d1ee451806167f01f0dc | false   | 389925907634980004 | 0x8368e7746c42e25d4ee4c89d6c8702d85c3d1d0f030b94b070590a3f496daa6e | 620        | 38487438      | 2025-11-21T22:30:23.000Z | 0x02e1149ee7829f0e92856c7ac279204239a91cd9f2b111669ced152a7640b84c |
  | 0xd8df4f5a4ae2db7ea724d1ee451806167f01f0dc | false   | 765952091929112920 | 0x758d5329fd72137a10e643726531fc5ef3ca4d81923aef85708be60372732fb2 | 313        | 38448138      | 2025-11-21T00:40:23.000Z | 0x03fa746549060dc784bdb0e3edb22d616adcd1d5a49a09d7b4df30060dbeba59 |
  | 0xd8df4f5a4ae2db7ea724d1ee451806167f01f0dc | false   | 526893851955909340 | 0x02aaacb8bf6a4c3c3a99d8de43fad01348e68e314b7773fb2df3edac065e0c4e | 402        | 38454138      | 2025-11-21T04:00:23.000Z | 0x04d6d0aa0d037e310e8375c9791dc4900175b548557df8e1ec1ed2627c82aac6 |
</Accordion>

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

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

***

### DeliHook\_PoolFeeSet\_event

Pool fee configuration changes for BMX V2 liquidity pools on Base, capturing fee tier adjustments (in basis points) by pool identifier. Used for tracking fee structure evolution and pool economics analysis.

<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_poolId`        | `STRING`    | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.                                                         |
  | `in_fee`           | `STRING`    | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee | address                                    | removed | in\_poolId                                                         | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 3000    | 0x570a48f96035c2874de1c0f13c5075a05683b0cc | false   | 0xa57be3ab90a595af3b1b419f409e062db129a1676527d56c384443e6a3974ea7 | 519        | 38220549      | 2025-11-15T18:14:05.000Z | 0xf63f93680212180481553b4075bd461a2f080bfb7a9c75fa7c2e4407b6e3d70a |
  | 4000    | 0x570a48f96035c2874de1c0f13c5075a05683b0cc | false   | 0x86e8ea0cace38abfe607914ca88b4950bdd5866f8cefb6262c2706e540bc0e84 | 376        | 38448907      | 2025-11-21T01:06:01.000Z | 0x0ec87ab36b4d1d38b76330d9297da26551443243c8df2bfc5ceb453fcfe1a50a |
  | 1000    | 0x570a48f96035c2874de1c0f13c5075a05683b0cc | false   | 0x02aaacb8bf6a4c3c3a99d8de43fad01348e68e314b7773fb2df3edac065e0c4e | 852        | 38007407      | 2025-11-10T19:49:21.000Z | 0x45cc6f6206a91af9ca503a2c7d02b2e8802fd93930168f3cdb62bda8c5af5aab |
</Accordion>

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

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

***

### DeliHookConstantProduct\_Burn\_event

Liquidity removal events from BMX v2 constant product pools on Base, recording burn transactions where liquidity providers withdraw token amounts. Used for analyzing liquidity provision behavior and pool depth changes across different pool IDs.

<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_poolId`        | `STRING`    | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.                                               |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_poolId                                                         | in\_sender                                 | log\_index | in\_amount0          | in\_amount1          | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ------------------------------------------ | ---------- | -------------------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x0304492c94d8dafab67756c7b7aaf94e2c9ca709 | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0xa900d06df8073e50a50971720d6d3470d00e64198da3b03c82388f247e0d13c1 | 0x0304492c94d8dafab67756c7b7aaf94e2c9ca709 | 963        | 61488361862468084872 | 12840085783606810829 | 38147755      | 2025-11-14T01:47:37.000Z | 0xc68df1f4f2d7dbd3422e51597c7d99c53456ab712f034bdc2eecbcbb9edc0d09 |
  | 0x0304492c94d8dafab67756c7b7aaf94e2c9ca709 | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0xa900d06df8073e50a50971720d6d3470d00e64198da3b03c82388f247e0d13c1 | 0x0304492c94d8dafab67756c7b7aaf94e2c9ca709 | 530        | 29061037254130600116 | 6756251045814456002  | 38160014      | 2025-11-14T08:36:15.000Z | 0x27220284eeef55a656bc52389d8d310134b825ac36b90264c62e53dd3de30459 |
  | 0x9d2abc0cbc8f1055a5e2bce72916979fa9debf26 | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0xa900d06df8073e50a50971720d6d3470d00e64198da3b03c82388f247e0d13c1 | 0x9d2abc0cbc8f1055a5e2bce72916979fa9debf26 | 570        | 39539882046371510509 | 9102548132565657053  | 38173280      | 2025-11-14T15:58:27.000Z | 0x4c22e37e010acfc11b590b94571e1f4d2c95a28b3e0338d2dc61c15d15a1e749 |
</Accordion>

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

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

***

### DeliHookConstantProduct\_HookSwap\_event

Swap events from BMX V2's DeliHookConstantProduct hook contract on Base, recording constant product automated market maker (AMM) trades with token amounts and liquidity provider fee details. Useful for analyzing decentralized exchange activity, pricing dynamics, and fee generation within hook-enabled liquidity 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_id`               | `STRING`    | Unique identifier for the position, record, or entity within the protocol. Numeric string representation.                                                                                                                  |
  | `in_sender`           | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                        |
  | `in_amount0`          | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                                                                                       |
  | `in_amount1`          | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                                                                                       |
  | `in_hookLPfeeAmount0` | `STRING`    | Liquidity provider fee collected in token0 for this hook-enabled swap on the constant product pool. Stored as a string-encoded integer in smallest token units (wei-equivalent); typically zero when fees are not charged. |
  | `in_hookLPfeeAmount1` | `STRING`    | LP fee amount collected in token1 for this swap on the DeliHook constant product pool. Stored as a string-encoded integer in smallest token units (wei-equivalent), commonly zero when fees are not applied.               |
</Accordion>

<Accordion title="Sample Data">
  | in\_id                                                             | address                                    | removed | in\_sender                                 | log\_index | in\_amount0            | in\_amount1           | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_hookLPfeeAmount0 | in\_hookLPfeeAmount1 |
  | ------------------------------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
  | 0x758d5329fd72137a10e643726531fc5ef3ca4d81923aef85708be60372732fb2 | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x2da5aff074f1a864ad01c4e6e8757a382bec9e8a | 809        | 9434600769457549276    | 53943467476783991137  | 38252130      | 2025-11-16T11:46:47.000Z | 0x05ef484538f6c2e4d679367f7d231600d4c574880e83e2c7ee9f2631649c0466 | 0                    | 0                    |
  | 0xa900d06df8073e50a50971720d6d3470d00e64198da3b03c82388f247e0d13c1 | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x63242a4ea82847b20e506b63b0e2e2eff0cc6cb0 | 129        | 1899835632333809167090 | 428993325202619990370 | 38233635      | 2025-11-16T01:30:17.000Z | 0xd585a83908aceacad7e598339b50c631842752418b8d46f63a46681de3f30650 | 0                    | 0                    |
  | 0xec34ff1708e11b4a0887bc5d9d88771dabc4fdbda765e301e54899b92bfa5d7e | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x63242a4ea82847b20e506b63b0e2e2eff0cc6cb0 | 391        | 14585536416455754      | 924320916086657616    | 38234485      | 2025-11-16T01:58:37.000Z | 0xca8d8bc2f6eb0035f730dc40036e1b8421fc4048ffd6694ec3fcbc3676a7efed | 0                    | 0                    |
</Accordion>

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

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

***

### DeliHookConstantProduct\_Mint\_event

Liquidity provision events from BMX v2 constant product pools on Base, capturing dual-token deposit amounts when liquidity providers mint positions. Used for tracking liquidity addition activity and analyzing LP behavior across pool identifiers.

<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_poolId`        | `STRING`    | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.                                               |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_poolId                                                         | in\_sender                                 | log\_index | in\_amount0            | in\_amount1             | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ------------------------------------------ | ---------- | ---------------------- | ----------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x758d5329fd72137a10e643726531fc5ef3ca4d81923aef85708be60372732fb2 | 0xc86fc1953ac75c3f12eabcec108d6c616774e3a9 | 1004       | 2932490720288036134618 | 17911626342653673430904 | 38317650      | 2025-11-18T00:10:47.000Z | 0x58075ff409a5965e215156ca29d5b145cd95e2bbc2e6fe0d88667425f24432d9 |
  | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x758d5329fd72137a10e643726531fc5ef3ca4d81923aef85708be60372732fb2 | 0xc86fc1953ac75c3f12eabcec108d6c616774e3a9 | 650        | 6622577386897590700173 | 40450641756085818961852 | 38317887      | 2025-11-18T00:18:41.000Z | 0xba4e157f202e76c7cc0012676b503a47a62cb3a3d15f4ff741ef6296f5e71551 |
  | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x758d5329fd72137a10e643726531fc5ef3ca4d81923aef85708be60372732fb2 | 0x7c3d3c9ea0f11b162a4261a849033030b4cd3064 | 540        | 865532538518878853662  | 5350554312088507303678  | 38319590      | 2025-11-18T01:15:27.000Z | 0x49f8dd82130a5c1e54030e835afba0ee5765fcc49e03baa59b554193b498baa0 |
</Accordion>

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

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

***

### DeliHookConstantProduct\_PairCreated\_event

Liquidity pool creation events from BMX v2 constant product automated market maker (AMM) hook contract on Base. Records new trading pair deployments with currency addresses, fee tiers (0.1% to 0.8%), and unique pool identifiers for tracking DEX liquidity initialization.

<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_poolId`        | `STRING`    | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.                                                         |
  | `in_currency0`     | `STRING`    | Contract address of the first token in the pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                |
  | `in_currency1`     | `STRING`    | Contract address of the second token in the pair. Hex-encoded, 0x-prefixed, 42-character string.                                                               |
  | `in_fee`           | `STRING`    | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee | address                                    | removed | in\_poolId                                                         | log\_index | block\_number | in\_currency0                              | in\_currency1                              | block\_timestamp         | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 3000    | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x0bfb4df68d1f0cfd7c0e0bcf221a10b8474b486746bc2cb04c82d92da2501f90 | 46         | 38117726      | 0x4e74d4db6c0726ccded4656d0bce448876bb4c7a | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 2025-11-13T09:06:39.000Z | 0x2e31e35eb316be26896e7591bace0804fd7a6421f37f3a10d46217c97082a578 |
  | 3000    | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x34e58f57b43ec90526fab13f5c7e9a0e8fb65309476e581413fc76b7db2c4cb6 | 940        | 38117893      | 0x4200000000000000000000000000000000000006 | 0x4e74d4db6c0726ccded4656d0bce448876bb4c7a | 2025-11-13T09:12:13.000Z | 0xf577d054d7f8ee98b726d39b11da85ca451978d47f773c5efdef00f87df7f15a |
  | 3000    | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0xee0d59cd57b8b4f4a0bbacbba15028ca7008b5566d1e86ac8284e3a6859457e7 | 462        | 38116817      | 0x02f92800f57bcd74066f5709f1daa1a4302df875 | 0x4e74d4db6c0726ccded4656d0bce448876bb4c7a | 2025-11-13T08:36:21.000Z | 0xd915ab848d24964e6e6d12e3b68bc348d7c6da481e9f554d264896e936371fb1 |
</Accordion>

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

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

***

### DeliHookConstantProduct\_Sync\_event

Liquidity pool reserve synchronization events from BMX V2 constant product automated market maker (AMM) pools on Base. Tracks reserve balance updates for each pool identifier, enabling liquidity depth analysis and price impact modeling.

<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_poolId`        | `STRING`    | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.                                                         |
  | `in_reserve0`      | `STRING`    | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.  |
  | `in_reserve1`      | `STRING`    | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_poolId                                                         | log\_index | in\_reserve0         | in\_reserve1           | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | -------------------- | ---------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x1a2183a9e8847580fed0e0b369dc07977eab5f5b67fd9b2715f7507a95409580 | 811        | 45379566694462020120 | 4243849535969068346808 | 38576552      | 2025-11-24T00:00:51.000Z | 0x9454c68c6273bf752136bdcc2d49d4ef65d197b70eb38b2c9931b38565cfe7a8 |
  | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x1a2183a9e8847580fed0e0b369dc07977eab5f5b67fd9b2715f7507a95409580 | 834        | 45208874946502461776 | 4259872719386685390247 | 38579480      | 2025-11-24T01:38:27.000Z | 0x63cd1bcaf1ec23c2bcee85d5f7e0d2e96eca9b85635de1b2aac4aa93fbc400e7 |
  | 0x95afbc0fccf974b41380f24e562f15b6dd90fac8 | false   | 0x1a2183a9e8847580fed0e0b369dc07977eab5f5b67fd9b2715f7507a95409580 | 493        | 45638537895431644820 | 4219768247177949865298 | 38580894      | 2025-11-24T02:25:35.000Z | 0x229d9676269f6153864037e2a63c0b820da36f152e19bde339fbef6159c070ae |
</Accordion>

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

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

***

### FeeProcessor\_FeeCollected\_event

Fee collection events from BMX V2 protocol on Base, tracking total fees and their allocation between buyback and voter reward portions by liquidity pool. Used for analyzing protocol revenue distribution and fee generation across trading pairs.

<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_hook`           | `STRING`    | Contract address of the hook contract associated with this fee collection event. Hex-encoded, 0x-prefixed 40-character string representing the BMX v2 hook that triggered the fee processing.                                     |
  | `in_poolId`         | `STRING`    | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.                                                                                                                            |
  | `in_totalAmount`    | `STRING`    | Total amount involved in the transaction or operation. String-encoded integer representing the amount in the token's smallest unit.                                                                                               |
  | `in_buybackPortion` | `STRING`    | Portion of the collected fee amount allocated to token buyback operations, denominated in the smallest token unit. Typically represents approximately 97% of the total fee amount based on the protocol's fee distribution model. |
  | `in_voterPortion`   | `STRING`    | Portion of the collected fee allocated to voters, denominated in wei (smallest token unit). Typically represents approximately 3% of the total fee amount based on sample proportions.                                            |
  | `in_isInternalSwap` | `BOOL`      | Indicates whether the fee collection event resulted from an internal swap operation within the protocol. Values are true for internal swaps and false for standard user-initiated transactions.                                   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_hook                                   | removed | in\_poolId                                                         | log\_index | block\_number | in\_totalAmount   | block\_timestamp         | in\_voterPortion | transaction\_hash                                                  | in\_buybackPortion | in\_isInternalSwap |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | ------------- | ----------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------ | ------------------ |
  | 0x6506477df1d3f7c273e442fe87df50f4930b41c2 | 0x570a48f96035c2874de1c0f13c5075a05683b0cc | false   | 0x1ce5d839d3ad969091fb4fc7160bf803e4766bb2a3a7841e55a7934c1ebcac29 | 306        | 38144536      | 89081123407485861 | 2025-11-14T00:00:19.000Z | 2672433702224576 | 0xf696bc7595074802aef1b2898612c079ba59b773d08bd20a51a26efc3b7c837a | 86408689705261285  | false              |
  | 0x6506477df1d3f7c273e442fe87df50f4930b41c2 | 0x570a48f96035c2874de1c0f13c5075a05683b0cc | false   | 0x02aaacb8bf6a4c3c3a99d8de43fad01348e68e314b7773fb2df3edac065e0c4e | 311        | 38144536      | 59277598838504589 | 2025-11-14T00:00:19.000Z | 1778327965155138 | 0xf696bc7595074802aef1b2898612c079ba59b773d08bd20a51a26efc3b7c837a | 57499270873349451  | false              |
  | 0x6506477df1d3f7c273e442fe87df50f4930b41c2 | 0x570a48f96035c2874de1c0f13c5075a05683b0cc | false   | 0x95c221dfe861c2e169ed8cd2a63db99161ec281c13f1349909eb5be681a94af6 | 355        | 38144539      | 49924774771879853 | 2025-11-14T00:00:25.000Z | 1497743243156396 | 0x47b73f815780b21f25f69b8899f0a611f73888bc6e84a0b44d2e89bcad063001 | 48427031528723457  | false              |
</Accordion>

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

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

***

### IncentiveGauge\_Claimed\_event

Incentive reward claim events from BMX v2 protocol on Base, capturing user addresses, token addresses, and claimed amounts when users withdraw accumulated rewards. Used for analyzing reward distribution patterns and user incentive participation across the 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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol 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">
  | address                                    | in\_user                                   | removed | in\_token                                  | in\_amount       | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x59d7bff1934939a7cd11e029c051ba9872469213 | 0x0304492c94d8dafab67756c7b7aaf94e2c9ca709 | false   | 0x548f93779fbc992010c07467cbaf329dd5f059b7 | 1385047261184752 | 777        | 38146643      | 2025-11-14T01:10:33.000Z | 0x92d74b843e2ff13cfb3405942a900b54462befab4eebc08c8726d2df670a43f2 |
  | 0x59d7bff1934939a7cd11e029c051ba9872469213 | 0x0304492c94d8dafab67756c7b7aaf94e2c9ca709 | false   | 0x548f93779fbc992010c07467cbaf329dd5f059b7 | 473831957773731  | 728        | 38147436      | 2025-11-14T01:36:59.000Z | 0xa5230483cebc61b060b266d76ea0e564342b698d782a147b1dc720a6ed88b2f7 |
  | 0x59d7bff1934939a7cd11e029c051ba9872469213 | 0x0304492c94d8dafab67756c7b7aaf94e2c9ca709 | false   | 0x548f93779fbc992010c07467cbaf329dd5f059b7 | 191601440334520  | 215        | 38147748      | 2025-11-14T01:47:23.000Z | 0x8944bdfe902b094d4fe080f2364420ea1fd2ad85517ce9c26f8613eb47ca9cd8 |
</Accordion>

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

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

***