seaport_v1_celo - Token Terminal Docs

Tables

SeaportV5_OrderFulfilled_event

Event logs recording successful order executions on the Seaport v1.5 decentralized exchange protocol. Contains offer items, consideration items (payments and fees), order participants (offerer, recipient, zone), and order hash for tracking marketplace trades across NFTs (ERC-721/ERC-1155) and fungible tokens.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_offerer`	`STRING`	Address of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
`in_zone`	`STRING`	Contract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_offer`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING>>`	Array of items being offered by the seller in the order. Each item specifies the token type, contract address, token identifier, and quantity being sold.
`in_consideration`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>>`	Array of items requested by the seller in exchange for the offered items. Each item specifies the token type, contract address, token identifier, amount, and recipient address for payment distribution including seller proceeds and marketplace fees.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

⌘I