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_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
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_orderHashin_recipientblock_timestampin_considerationtransaction_hash
0x00000000006c3852cbef3e08e8df289169ede5810x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“100”,“itemType”:0,“identifier”:“0”}]230xfb4d3eb37bde8fa4b52c60aabe55b3cd9908ec73169263760x6a5ed774e4f767fdf325f30d5bbc1a55befb3b8f707ee59c186c61ea610d5fec0x00000000000000000000000000000000000000002023-03-28T14:18:11.000Z[]0x2b32aa32e0a5e19b9b7a4fdce6a581493158daa98c76103b301455598dd7da9e
0x00000000006c3852cbef3e08e8df289169ede5810x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“100”,“itemType”:0,“identifier”:“0”}]660xfb4d3eb37bde8fa4b52c60aabe55b3cd9908ec73169279270x69833dba40b7ee330e23ce5af220213f194ca194b7ddec2e1b698493700587220x00000000000000000000000000000000000000002023-03-28T19:32:47.000Z[]0x559d6575edd3d8e1e6a09f7a591758a3238bf07ef091da071fa8d7de64e420af
0x00000000006c3852cbef3e08e8df289169ede5810x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“100”,“itemType”:0,“identifier”:“0”}]620xfb4d3eb37bde8fa4b52c60aabe55b3cd9908ec73169291180x83d9f29f83f2e239011144a62776a80def26af2538b3c0777ec93e24041529300x00000000000000000000000000000000000000002023-03-28T23:33:35.000Z[]0x617d9d9ec9a12949747a4e538d4a6d6c9e8b45361efeb3b317adf9e8cd690c94
Query with partition filter
SELECT *
FROM `tt-contracts.seaport_v2_ethereum.Seaport_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100