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
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1000000000000000”,“itemType”:0,“identifier”:“0”}]2840xe590ae610bb85faf7d833326da68c788f1538e36176982700xa5992bf685d78ee77e576cca8759561bd757a89c6c1d6ecb946620d8b1bf14df0xe590ae610bb85faf7d833326da68c788f1538e362023-07-15T10:42:11.000Z[]0x59c0e2d2edfb37b3948e4d85be46e3ce1819d2131c0910770810dc4863565a11
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“360000000000000000”,“itemType”:0,“identifier”:“0”}]5170x376ffeff9820826a564a1ba05a464b9923862418177017920x85ca2cf2fc3ee266eef477576fd8904bd593df852b1840a6b6c821c50fbf49480x376ffeff9820826a564a1ba05a464b99238624182023-07-15T22:42:23.000Z[]0x461d5d8137e3f0c08fdc49b3295c4afbe883522c1f9e0f89f6f504d8dc6ab172
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“10000000000000000”,“itemType”:0,“identifier”:“0”}]1960xd7dd9612a21f7c249fb7f33e9c2e9144345e162b177009790x75850af2a0bf65cc1011518a93101dbf75865331424f3c48bd560fef84c3f9140xd7dd9612a21f7c249fb7f33e9c2e9144345e162b2023-07-15T19:56:47.000Z[]0x480c981963782bee9b571c95e9fd7e2bfe0a3cd58f26db3f6f1202993fd15f63
Query with partition filter
SELECT *
FROM `tt-contracts.seaport_v5_ethereum.Seaport_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100