Skip to main content

​
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.
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 instance on Base chain. Hex-encoded, 0x-prefixed 40-character string representing the deployed AMM contract for this prediction market.
in_conditionalTokensSTRINGContract 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_collateralTokenSTRINGContract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_conditionIdsARRAY<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_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
100000000000000000xc397d5d70cb3b56b26dd5c2824d49a96c4dabf50false170x4a81ae1a07b50966349b2c75b31bf0e74d05b516177909772024-07-30T20:28:21.000Z[“0xb734b7c8c26e4e5cada088009869780af09dbe4a30b5c880c983ef0177c57a35”]0xfea547fe872a6393ab6088932f421199249a1dbb6616b0d7cafbc5d15931e6620x42000000000000000000000000000000000000060xc9c98965297bc527861c898329ee280632b76e180x0a59dec6023cadfcca7ace5f1df5f0315d4977da
100000000000000000xc397d5d70cb3b56b26dd5c2824d49a96c4dabf50false1700x4a81ae1a07b50966349b2c75b31bf0e74d05b516177912342024-07-30T20:36:55.000Z[“0x03703b72f4effcc1943b17ea1203fca2daaba01e0e16152d604f2148be6ad163”]0xecb65b0cd846381958561abe375d3160ea18986ad55b81a46d644634d0c5dd7a0x42000000000000000000000000000000000000060xc9c98965297bc527861c898329ee280632b76e180x99060a9118841f15352e2052957b10e5482ae9fe
100000000000000000xc397d5d70cb3b56b26dd5c2824d49a96c4dabf50false10x4a81ae1a07b50966349b2c75b31bf0e74d05b516177815892024-07-30T15:15:25.000Z[“0x6ef9178099530a57151e2e3517d587e8f52456c7b649c8d9e43aaad058f69963”]0x9a2110538c967349affebc220174360739dff73adc5c37dc919ccc1e101394220x833589fcd6edb6e08f4c7c32d4f71b54bda029130xc9c98965297bc527861c898329ee280632b76e180x74e6ee1c94ae65dca39495fb015b887c95646c20
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