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.Columns
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_fulfiller | STRING | Ethereum 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_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
Sample Data
| address | in_zone | removed | in_offer | log_index | in_offerer | block_number | in_fulfiller | in_orderHash | block_timestamp | in_consideration | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x00000000006c3852cbef3e08e8df289169ede581 | 0x004c00500000ad104d7dbd00e3ae0a5c00560c00 | false | [] | 169 | 0xb5a02ac7d0b96f32f5ba8874c25435aae68d248a | 16073415 | 0x0000000000000000000000000000000000000000 | 0x47a392bd61d1cf4fad72536e294f83be2021163bea07988fb52addee5fbad556 | 2022-11-29T04:59:23.000Z | [] | 0x81454ae57cecd7cf976830f3104d785401a45a3754f1d09a76d5c123a17e5b8c |
| 0x00000000006c3852cbef3e08e8df289169ede581 | 0x004c00500000ad104d7dbd00e3ae0a5c00560c00 | false | [] | 162 | 0xb85492afc686d5ca405e3cd4f50b05d358c75ede | 16073484 | 0x0000000000000000000000000000000000000000 | 0x73b0c621c51f7ef638abdf0e03a636104d4ff660d91cde6e8d020a78943cb22d | 2022-11-29T05:13:11.000Z | [] | 0x02dd8a1ce09053108b32871bd3906313d31f2e8ab9d70f824b3a8d661368e324 |
| 0x00000000006c3852cbef3e08e8df289169ede581 | 0x004c00500000ad104d7dbd00e3ae0a5c00560c00 | false | [] | 99 | 0xeb45156afec97cbfd51f0464251e044ed4689c72 | 16074903 | 0x0000000000000000000000000000000000000000 | 0xc0a72b28d8ab75aa25de5fc0cdc929feed7c6f926ff920d4ab8268c0f7a7f8f4 | 2022-11-29T09:58:47.000Z | [] | 0xb07592405cf29515e5ad0f743fc4cea73688bb1a68dcb983c28da9a4495aceb4 |
Example Query
Example Query
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