Tables
FixedProductMarketMakerV2Factory_FixedProductMarketMakerCreation_event
Prediction market creation events from Limitless V2 protocol on Base, recording new automated market maker (AMM) pools for conditional tokens with creator addresses, condition identifiers, collateral tokens, and fee parameters. Used for tracking market deployment activity and analyzing market maker configurations in prediction markets.Columns
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_creator | STRING | Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string. |
in_fixedProductMarketMaker | STRING | Contract address of the newly created fixed product market maker instance on Base chain. Hex-encoded, 0x-prefixed 40-character string representing the deployed AMM contract for this prediction market. |
in_conditionalTokens | STRING | Contract address of the Conditional Tokens Framework contract that manages the outcome tokens for this prediction market. This address is consistent across all markets in the sample (0xc9c98965297bc527861c898329ee280632b76e18 on Base). |
in_collateralToken | STRING | Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_conditionIds | ARRAY<STRING> | Unique identifiers representing the market conditions or outcomes being traded in the prediction market. Array of 32-byte hex-encoded hashes that define the specific conditional token positions available in each market maker instance. |
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
Sample Data
| in_fee | address | removed | log_index | in_creator | block_number | block_timestamp | in_conditionIds | transaction_hash | in_collateralToken | in_conditionalTokens | in_fixedProductMarketMaker |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10000000000000000 | 0xc397d5d70cb3b56b26dd5c2824d49a96c4dabf50 | false | 17 | 0x4a81ae1a07b50966349b2c75b31bf0e74d05b516 | 17790977 | 2024-07-30T20:28:21.000Z | [“0xb734b7c8c26e4e5cada088009869780af09dbe4a30b5c880c983ef0177c57a35”] | 0xfea547fe872a6393ab6088932f421199249a1dbb6616b0d7cafbc5d15931e662 | 0x4200000000000000000000000000000000000006 | 0xc9c98965297bc527861c898329ee280632b76e18 | 0x0a59dec6023cadfcca7ace5f1df5f0315d4977da |
| 10000000000000000 | 0xc397d5d70cb3b56b26dd5c2824d49a96c4dabf50 | false | 170 | 0x4a81ae1a07b50966349b2c75b31bf0e74d05b516 | 17791234 | 2024-07-30T20:36:55.000Z | [“0x03703b72f4effcc1943b17ea1203fca2daaba01e0e16152d604f2148be6ad163”] | 0xecb65b0cd846381958561abe375d3160ea18986ad55b81a46d644634d0c5dd7a | 0x4200000000000000000000000000000000000006 | 0xc9c98965297bc527861c898329ee280632b76e18 | 0x99060a9118841f15352e2052957b10e5482ae9fe |
| 10000000000000000 | 0xc397d5d70cb3b56b26dd5c2824d49a96c4dabf50 | false | 1 | 0x4a81ae1a07b50966349b2c75b31bf0e74d05b516 | 17781589 | 2024-07-30T15:15:25.000Z | [“0x6ef9178099530a57151e2e3517d587e8f52456c7b649c8d9e43aaad058f69963”] | 0x9a2110538c967349affebc220174360739dff73adc5c37dc919ccc1e10139422 | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 0xc9c98965297bc527861c898329ee280632b76e18 | 0x74e6ee1c94ae65dca39495fb015b887c95646c20 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.limitless_v2_base.FixedProductMarketMakerV2Factory_FixedProductMarketMakerCreation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100