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
0x00000000000001ad428e4906ae43d8f9852d0dd60x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“190000000000000000”,“itemType”:0,“identifier”:“0”}]2590x197c55a7939e872c3ef2e3e82dabcc0764d79ffa168053740x8a58a1c8c76695a55390155b6a41dc07fa7a8e2714c72ebd8026fac8f11b1d260x197c55a7939e872c3ef2e3e82dabcc0764d79ffa2023-03-11T14:15:59.000Z[]0x02eaeef9e92df28c00faa915a0c465707c737826a11567e1a5e133f29c16b955
0x00000000000001ad428e4906ae43d8f9852d0dd60x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“30000000000000000”,“itemType”:0,“identifier”:“0”}]5940x4e7897e7f341d2ca85e9c3ef4348c7bdfd505b3b168081220xcb01bcb5a4d8dac0dc0d2a03d7c111f657505006dbe9b62df8232a231e9cf2790x4e7897e7f341d2ca85e9c3ef4348c7bdfd505b3b2023-03-11T23:32:59.000Z[]0x314aa1fa5b4f0ec7ff731a3de7dddc2d7d456d755ee7350836284759c3dacdb1
0x00000000000001ad428e4906ae43d8f9852d0dd60x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“300000000000000000”,“itemType”:0,“identifier”:“0”}]3750xdcf184272d39b156ad38fc44b6f493b19e2d3d33168018200x4df5393896888045b5537f04b4728c0420478af9afbbbb32afe54f2876a11f530xdcf184272d39b156ad38fc44b6f493b19e2d3d332023-03-11T02:16:47.000Z[]0xda0f40a1dd3b0f038a1a13d55d692ad16ec5d2ac545bbbe04c4b0b164b16128c
Query with partition filter
SELECT *
FROM `tt-contracts.seaport_v4_ethereum.Seaport_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100