Skip to main content

Tables

FixedProductMarketMakerFactory_FixedProductMarketMakerCreation_event

Prediction market creation events from Limitless protocol’s Fixed Product Market Maker factory contract on Base, recording deployed market maker addresses with their associated conditional tokens, collateral tokens, fee rates, and condition identifiers. Used for tracking new prediction market deployments and analyzing market creation patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_creatorSTRINGAddress of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
in_fixedProductMarketMakerSTRINGContract address of the newly created Fixed Product Market Maker (FPMM) automated market maker contract. Hex-encoded, 0x-prefixed 40-character string representing the deployed prediction market instance on Base.
in_conditionalTokensSTRINGContract address of the Conditional Tokens framework contract that manages the outcome tokens for this prediction market. This is the core ERC1155 contract that mints and tracks conditional token positions based on resolved conditions.
in_collateralTokenSTRINGContract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_conditionIdsARRAY<STRING>Array of condition identifiers for the prediction market, with each condition representing a specific question or outcome being tracked. Typically contains a single 32-byte hex-encoded condition ID referencing the ConditionalTokens contract.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_feeaddressremovedlog_indexin_creatorblock_numberblock_timestampin_conditionIdstransaction_hashin_collateralTokenin_conditionalTokensin_fixedProductMarketMaker
100000000000000000x8e50578aca3c5e2ef5ed2aa4bd66429b5e44c16efalse1830x98b4a5d0205537796b5f996f31552e874ccd2d3f157090352024-06-12T15:50:17.000Z[β€œ0x968e609b1c0e7d60c31e861df3828c6e94e8d6fa26e747b0436f767bce3e3414”]0x6fed875dc7d68c1b12d8f58d253ad499cd4add30fd85bb6dfdf9ae103727826f0x42000000000000000000000000000000000000060x15a61459d65d89a25a9e91e0dc9fc695987915050x9b5771534a7f037b941eedd9d9457562e4f5b8df
100000000000000000x8e50578aca3c5e2ef5ed2aa4bd66429b5e44c16efalse1240x98b4a5d0205537796b5f996f31552e874ccd2d3f157094232024-06-12T16:03:13.000Z[β€œ0x38814f8b1ddfbdb161dfc06ad07c92eeea081edc91ef5c92032f0e9864937e98”]0x7f80e73784a2a4d9cab04bda6c1b09b58340da256ba8371c125617481243013e0x42000000000000000000000000000000000000060x15a61459d65d89a25a9e91e0dc9fc695987915050xc554ca66ab61b5a477c48fbc510f7744f05048fa
1000000000000000000x8e50578aca3c5e2ef5ed2aa4bd66429b5e44c16efalse430x98b4a5d0205537796b5f996f31552e874ccd2d3f148819572024-05-24T12:21:01.000Z[β€œ0xada622de7412558ee1f492c14939cdea0dd276f07a11db337d816071e03b4d6c”]0x058324aea68878f7f0f39a54da935eccdcc5404a2bc779adc83774c0f5a5ac560x42000000000000000000000000000000000000060x15a61459d65d89a25a9e91e0dc9fc695987915050xefb58db22ac58336050cf5c403eb097517f4803c
Query with partition filter
SELECT *
FROM `tt-contracts.limitless_v1_base.FixedProductMarketMakerFactory_FixedProductMarketMakerCreation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100