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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

Sample Data

in_id	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x758d5329fd72137a10e643726531fc5ef3ca4d81923aef85708be60372732fb2	0x95afbc0fccf974b41380f24e562f15b6dd90fac8	false	0x2da5aff074f1a864ad01c4e6e8757a382bec9e8a	809	9434600769457549276	53943467476783991137	38252130	2025-11-16T11:46:47.000Z	0x05ef484538f6c2e4d679367f7d231600d4c574880e83e2c7ee9f2631649c0466
0xa900d06df8073e50a50971720d6d3470d00e64198da3b03c82388f247e0d13c1	0x95afbc0fccf974b41380f24e562f15b6dd90fac8	false	0x63242a4ea82847b20e506b63b0e2e2eff0cc6cb0	129	1899835632333809167090	428993325202619990370	38233635	2025-11-16T01:30:17.000Z	0xd585a83908aceacad7e598339b50c631842752418b8d46f63a46681de3f30650
0xec34ff1708e11b4a0887bc5d9d88771dabc4fdbda765e301e54899b92bfa5d7e	0x95afbc0fccf974b41380f24e562f15b6dd90fac8	false	0x63242a4ea82847b20e506b63b0e2e2eff0cc6cb0	391	14585536416455754	924320916086657616	38234485	2025-11-16T01:58:37.000Z	0xca8d8bc2f6eb0035f730dc40036e1b8421fc4048ffd6694ec3fcbc3676a7efed

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

DailyEpochGauge_Claimed_event

DailyEpochGauge_RewardsAdded_event

DeliHook_PoolFeeSet_event

DeliHookConstantProduct_Burn_event

DeliHookConstantProduct_HookSwap_event

DeliHookConstantProduct_Mint_event

DeliHookConstantProduct_PairCreated_event

DeliHookConstantProduct_Sync_event

FeeProcessor_FeeCollected_event

IncentiveGauge_Claimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​DailyEpochGauge_Claimed_event

​DailyEpochGauge_RewardsAdded_event

​DeliHook_PoolFeeSet_event

​DeliHookConstantProduct_Burn_event

​DeliHookConstantProduct_HookSwap_event

​DeliHookConstantProduct_Mint_event

​DeliHookConstantProduct_PairCreated_event

​DeliHookConstantProduct_Sync_event

​FeeProcessor_FeeCollected_event

​IncentiveGauge_Claimed_event

Tables

DailyEpochGauge_Claimed_event

DailyEpochGauge_RewardsAdded_event

DeliHook_PoolFeeSet_event

DeliHookConstantProduct_Burn_event

DeliHookConstantProduct_HookSwap_event

DeliHookConstantProduct_Mint_event

DeliHookConstantProduct_PairCreated_event

DeliHookConstantProduct_Sync_event

FeeProcessor_FeeCollected_event

IncentiveGauge_Claimed_event