Skip to main content

​
Tables

​
Seaport_OrderFulfilled_event

Order fulfillment events from the Seaport NFT marketplace protocol containing offered items, consideration items, offerer address, recipient address, order hash, and zone validator contract. Tracks completed NFT and token exchanges with detailed payment distribution data.
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_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_offererSTRINGAddress of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
in_zoneSTRINGContract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_fulfillerSTRINGEthereum address of the party who fulfilled or matched the Seaport order, enabling the trade to complete. Appears as the zero address when the fulfiller is not explicitly tracked or when orders are self-fulfilled.
in_offerARRAY<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_considerationARRAY<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.
addressin_zoneremovedin_offerlog_indexin_offererblock_numberin_fulfillerin_orderHashblock_timestampin_considerationtransaction_hash
0x00000000006c3852cbef3e08e8df289169ede5810x004c00500000ad104d7dbd00e3ae0a5c00560c00false[]1690xb5a02ac7d0b96f32f5ba8874c25435aae68d248a160734150x00000000000000000000000000000000000000000x47a392bd61d1cf4fad72536e294f83be2021163bea07988fb52addee5fbad5562022-11-29T04:59:23.000Z[]0x81454ae57cecd7cf976830f3104d785401a45a3754f1d09a76d5c123a17e5b8c
0x00000000006c3852cbef3e08e8df289169ede5810x004c00500000ad104d7dbd00e3ae0a5c00560c00false[]1620xb85492afc686d5ca405e3cd4f50b05d358c75ede160734840x00000000000000000000000000000000000000000x73b0c621c51f7ef638abdf0e03a636104d4ff660d91cde6e8d020a78943cb22d2022-11-29T05:13:11.000Z[]0x02dd8a1ce09053108b32871bd3906313d31f2e8ab9d70f824b3a8d661368e324
0x00000000006c3852cbef3e08e8df289169ede5810x004c00500000ad104d7dbd00e3ae0a5c00560c00false[]990xeb45156afec97cbfd51f0464251e044ed4689c72160749030x00000000000000000000000000000000000000000xc0a72b28d8ab75aa25de5fc0cdc929feed7c6f926ff920d4ab8268c0f7a7f8f42022-11-29T09:58:47.000Z[]0xb07592405cf29515e5ad0f743fc4cea73688bb1a68dcb983c28da9a4495aceb4
Query with partition filter
SELECT *
FROM `tt-contracts.opensea_v2_ethereum.Seaport_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100