manifoldxyz_v1_optimism

Tables

Marketplace_BidEvent_event

Bid placement and removal events from Manifold marketplace protocol on Optimism, tracking bidder addresses, bid amounts, and associated listing identifiers. Used for analyzing NFT marketplace bidding activity, price discovery patterns, and user participation across listings.

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_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_bidder`	`STRING`	Address of the account that placed the bid in the auction or marketplace. 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	removed	in_amount	in_bidder	log_index	in_referrer	block_number	in_listingId	block_timestamp	transaction_hash
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	100000000000000	0x6140f00e4ff3936702e68744f2b5978885464cbb	20	0x0000000000000000000000000000000000000000	105928011	7	2023-06-22T17:26:39.000Z	0x5e675ce38327ef57eab36ada67ff8fb1c838153a26331cbd5d39492f06627b01
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	10000000000000	0x6140f00e4ff3936702e68744f2b5978885464cbb	38	0x0000000000000000000000000000000000000000	105923154	1	2023-06-22T14:44:45.000Z	0x9a95143050dc7444db4a31c56fc851fc84e2b2cf556f399a5189d566c60ddeec
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	10000000000000	0x6140f00e4ff3936702e68744f2b5978885464cbb	34	0x0000000000000000000000000000000000000000	105928218	8	2023-06-22T17:33:33.000Z	0x17dc9f783c39baaa471d8bc7fb3b9980d686ecd5015b9b25de8cec03d62b3c95

Example Query

Query with partition filter

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

Marketplace_CreateListing_event

Listing creation events from Manifold marketplace protocol on Optimism, capturing auction and sale parameters including listing type, duration, pricing (initial amounts and minimum bid increments in basis points), and fee structures. Used for analyzing NFT marketplace activity, auction mechanics, and seller behavior patterns.

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_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_marketplaceBPS`	`STRING`	Marketplace fee expressed in basis points (BPS) where 10000 BPS equals 100%. Typically set to 0 in sample data, indicating no platform fee charged by the Manifold marketplace.
`in_referrerBPS`	`STRING`	Basis points (BPS) representing the referrer fee percentage for the listing. Stored as a string representing an integer where 10000 BPS equals 100%, commonly set to 0 indicating no referrer fee.
`in_listingType`	`INT64`	Enumerated code indicating the sale mechanism type for the marketplace listing. Common values include 1 for auction-style listings and 2 for fixed-price or offer-based sales.
`in_totalAvailable`	`STRING`	Total quantity of items available for sale in this marketplace listing. Typically set to 1 for single NFT auctions, but can be higher for batch or multi-edition sales.
`in_totalPerSale`	`STRING`	Number of tokens or items sold per transaction in this marketplace listing. Typically set to 1 for individual NFT sales or auctions.
`in_startTime`	`STRING`	Start timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
`in_endTime`	`STRING`	End timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
`in_initialAmount`	`STRING`	Initial price or starting bid amount for the listing in wei (smallest unit of the payment token). For auctions, represents the minimum bid; for fixed-price sales, represents the purchase price.
`in_extensionInterval`	`STRING`	Time period in seconds that extends auction duration when bids are placed near end time. Typically set to 60 or 600 seconds to prevent last-second sniping.
`in_minIncrementBPS`	`STRING`	Minimum bid increment required for auction listings, expressed in basis points (BPS) where 100 BPS equals 1%. Commonly set to 500 BPS (5%) based on sample data, or 0 for fixed-price sales.
`in_erc20`	`STRING`	Contract address of the ERC20 token being redeemed or registered. Hex-encoded, 0x-prefixed, 42-character string or zero address for native tokens.
`in_identityVerifier`	`STRING`	Contract address of optional identity verification service used to restrict listing participation. Zero address (0x000…000) indicates no verification required.

Sample Data

address	removed	in_erc20	log_index	in_endTime	block_number	in_listingId	in_listingType	block_timestamp	in_totalPerSale	in_initialAmount	transaction_hash	in_totalAvailable	in_minIncrementBPS	in_identityVerifier	in_extensionInterval
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	0x0000000000000000000000000000000000000000	22	86400	105894705	4	2	2023-06-21T22:56:27.000Z	1	10000000000000	0x118bc50604eac77dca03434b92a2cc0e68a8991e79b03249287fea20985254cb	1	0	0x0000000000000000000000000000000000000000	0
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	0x0000000000000000000000000000000000000000	33	86400	105891747	2	2	2023-06-21T21:17:51.000Z	1	1000000000000000	0xa9a93b40e6aeb03632966513f27fc26cf79f00eb4bb64a0050cd027a83d9d13e	1	0	0x0000000000000000000000000000000000000000	0
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	0x0000000000000000000000000000000000000000	4	300	105886568	1	1	2023-06-21T18:25:13.000Z	1	10000000000000	0xa6709e0e9d997912cd840eacaaf613b11c09aa096c8863a717a673765223f532	1	500	0x0000000000000000000000000000000000000000	60

Example Query

Query with partition filter

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

Marketplace_PurchaseEvent_event

Purchase events from the Manifold marketplace contract on Optimism, recording NFT sales with buyer addresses, listing IDs, payment amounts (in wei), and optional referrer addresses. Used for tracking marketplace transaction history and analyzing buyer behavior across Manifold listings.

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_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_count`	`STRING`	Number of items or tokens involved in the transaction. Numeric string representation.
`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_buyer	in_count	in_amount	log_index	in_referrer	block_number	in_listingId	block_timestamp	transaction_hash
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	0xff748e6b10082a435b9b0ecccf358c42c7f34dc0	1	10000000000000000	63	0x0000000000000000000000000000000000000000	107829640	41	2023-08-05T17:54:17.000Z	0x9ad3b05884180387a275cde1d004813b4702892c5eae75d4e643fad44d982575
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	0xbe0ad4b82ea950e38221473e96df3d457ffd4ec6	1	10000000000000000	49	0x0000000000000000000000000000000000000000	108767138	86	2023-08-27T10:44:13.000Z	0x509357b8c5dd76db9e68b6eb9056d753b2bd97254d23180146e2c3416e61b2a6
0x5246807fb65d87b0d0a234e0f3d42374de83b421	false	0xbe0ad4b82ea950e38221473e96df3d457ffd4ec6	1	10000000000000000	34	0x0000000000000000000000000000000000000000	108767168	88	2023-08-27T10:45:13.000Z	0xe5e568a372e27223e837b9422739ce86fcb6a8894d32c3b41165c5a79e807d1d

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Marketplace_BidEvent_event

Marketplace_CreateListing_event

Marketplace_PurchaseEvent_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Marketplace_BidEvent_event

​Marketplace_CreateListing_event

​Marketplace_PurchaseEvent_event

Tables

Marketplace_BidEvent_event

Marketplace_CreateListing_event

Marketplace_PurchaseEvent_event