opensea_v1_polygon

Tables

SeaportV1_OrderFulfilled_event

Event emitted when a Seaport protocol order is successfully executed, containing offered items, requested consideration items, order hash, offerer and recipient addresses, and zone contract for validation. Used for tracking NFT and token marketplace transactions across decentralized exchanges.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x00000000006c3852cbef3e08e8df289169ede581	0x0000000000000000000000000000000000000000	false	[{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“12000000000000000”,“itemType”:1,“identifier”:“0”}]	285	0x3ae1965e21997d1ed4fc42accf5adaddf96e6d0c	40707479	0x6973449372c7f9b28c666fe55ee576472870156268e5ad9bf7e97364d79208c3	0x0000000000000000000000000000000000000000	2023-03-24T08:44:21.000Z	[{“token”:“0x4ffa698ca3374ff154e58c8388a3aafe430dc2d3”,“amount”:“1”,“itemType”:2,“recipient”:“0x3ae1965e21997d1ed4fc42accf5adaddf96e6d0c”,“identifier”:“4020”},{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“840000000000000”,“itemType”:1,“recipient”:“0x89058b14c6c4b4a1e2678843c644ecd774bfe846”,“identifier”:“0”}]	0x0256551582607d84bba0407293c45899ec451df8f99c743142ea12a9f077ccf7
0x00000000006c3852cbef3e08e8df289169ede581	0x0000000000000000000000000000000000000000	false	[{“token”:“0x4ffa698ca3374ff154e58c8388a3aafe430dc2d3”,“amount”:“1”,“itemType”:2,“identifier”:“4020”}]	286	0xbd4a4d15105a148b66573aae38d179f5349c094f	40707479	0xf34f46b448bd3e3a92c2b645bec5fd11bb3a9febaace97bc8303bba167097bd2	0x0000000000000000000000000000000000000000	2023-03-24T08:44:21.000Z	[{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“11160000000000000”,“itemType”:1,“recipient”:“0xbd4a4d15105a148b66573aae38d179f5349c094f”,“identifier”:“0”}]	0x0256551582607d84bba0407293c45899ec451df8f99c743142ea12a9f077ccf7
0x00000000006c3852cbef3e08e8df289169ede581	0x0000000000000000000000000000000000000000	false	[{“token”:“0x4ffa698ca3374ff154e58c8388a3aafe430dc2d3”,“amount”:“1”,“itemType”:2,“identifier”:“4019”}]	270	0xbd4a4d15105a148b66573aae38d179f5349c094f	40707510	0x7389cb0fec16707fe07b8fd737ba3dc3a31528b8687990af60e4d5c5d293d556	0x0000000000000000000000000000000000000000	2023-03-24T08:45:27.000Z	[{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“11160000000000000”,“itemType”:1,“recipient”:“0xbd4a4d15105a148b66573aae38d179f5349c094f”,“identifier”:“0”}]	0x3a82e3a59115fd5bfb1eb0999d862832177fa5ee95d823e875f6f96c876a2ed6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opensea_v1_polygon.SeaportV1_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SeaportV4_OrderFulfilled_event

Event emitted when an order is successfully fulfilled in the Seaport v1.4 protocol, containing offer items, consideration items, offerer address, order hash, and recipient. Used for tracking NFT and token marketplace transactions including sales proceeds and fee distributions.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x00000000000001ad428e4906ae43d8f9852d0dd6	0x0000000000000000000000000000000000000000	false	[{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“650000000000000”,“itemType”:1,“identifier”:“0”}]	242	0x68970b9369d797b882aacdb25ee058f38a718d70	40114954	0x2ea9d8580b82f8c2f0987376657ebe5c26b06cfd2494f1b632f3d62c2de1235d	0x00252e82cea41162c01d69b9172cba822ca194f1	2023-03-08T17:20:08.000Z	[{“token”:“0x67f4732266c7300cca593c814d46bee72e40659f”,“amount”:“1”,“itemType”:2,“recipient”:“0x68970b9369d797b882aacdb25ee058f38a718d70”,“identifier”:“502528”},{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“16250000000000”,“itemType”:1,“recipient”:“0xad79e2ea4424781ec61c52cd2464f6ad525e2a5d”,“identifier”:“0”}]	0x4e3a1edc4025bc88aee39311dbbdaf16b3070d8f63947ad5e9ba69a188c5a64e
0x00000000000001ad428e4906ae43d8f9852d0dd6	0x0000000000000000000000000000000000000000	false	[{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“650000000000000”,“itemType”:1,“identifier”:“0”}]	208	0x68970b9369d797b882aacdb25ee058f38a718d70	40115006	0x684fcddccfd10c158eadeec0188f88e6ea5b3e80cdb88014e9f16f06324ec35b	0x00252e82cea41162c01d69b9172cba822ca194f1	2023-03-08T17:22:30.000Z	[{“token”:“0x67f4732266c7300cca593c814d46bee72e40659f”,“amount”:“1”,“itemType”:2,“recipient”:“0x68970b9369d797b882aacdb25ee058f38a718d70”,“identifier”:“483315”},{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“16250000000000”,“itemType”:1,“recipient”:“0xad79e2ea4424781ec61c52cd2464f6ad525e2a5d”,“identifier”:“0”}]	0x8f992a0d8d4b9c8e8e36fd9c5dd3773f3c88a0513f7ec91b0c4d50e1d006dab8
0x00000000000001ad428e4906ae43d8f9852d0dd6	0x0000000000000000000000000000000000000000	false	[{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“650000000000000”,“itemType”:1,“identifier”:“0”}]	315	0x68970b9369d797b882aacdb25ee058f38a718d70	40115025	0x531cefd68038760a9123c11ebbb3a509d44a9c9397c8062008b67660873cd9d5	0x00252e82cea41162c01d69b9172cba822ca194f1	2023-03-08T17:23:12.000Z	[{“token”:“0x67f4732266c7300cca593c814d46bee72e40659f”,“amount”:“1”,“itemType”:2,“recipient”:“0x68970b9369d797b882aacdb25ee058f38a718d70”,“identifier”:“194462”},{“token”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“amount”:“16250000000000”,“itemType”:1,“recipient”:“0xad79e2ea4424781ec61c52cd2464f6ad525e2a5d”,“identifier”:“0”}]	0x7cf5a751e84cd592d87e152801197fb65049e41304b6b6edff817fca9a5a0c3b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opensea_v1_polygon.SeaportV4_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SeaportV5_OrderFulfilled_event

Event logs recording successful order executions on the Seaport v1.5 decentralized exchange protocol. Contains offer items, consideration items (payments and fees), order participants (offerer, recipient, zone), and order hash for tracking marketplace trades across NFTs (ERC-721/ERC-1155) and fungible tokens.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0x0000000000000000000000000000000000000000	false	[{“token”:“0xf01a9815ab109b77396ef4a4f149ef176db984d0”,“amount”:“1”,“itemType”:2,“identifier”:“554”}]	366	0x0016fac66933c515417be6b9d74e7f61fd424d46	58305823	0xee5a8090833ebb09f1f761e23add70ff5a6f4f11249b4586480b432851d96fe6	0x7ff9f46ca01b133ab05ecea86e92ec6907be57de	2024-06-18T09:48:32.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“389960000000000000”,“itemType”:0,“recipient”:“0x0016fac66933c515417be6b9d74e7f61fd424d46”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“10000000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“40000000000000”,“itemType”:0,“recipient”:“0x85c2c57b349fff684b1122a755145a02dde38f79”,“identifier”:“0”}]	0x1188287829037d2d64d4b51d0dffa415c5852cbbd525509386a6112121091e8f
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0x0000000000000000000000000000000000000000	false	[{“token”:“0xf01a9815ab109b77396ef4a4f149ef176db984d0”,“amount”:“1”,“itemType”:2,“identifier”:“553”}]	367	0x0016fac66933c515417be6b9d74e7f61fd424d46	58305823	0x94c41c86430e25e8df03b9a541022e202572c9c98a503a221970cc33e562827e	0x7ff9f46ca01b133ab05ecea86e92ec6907be57de	2024-06-18T09:48:32.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“389960000000000000”,“itemType”:0,“recipient”:“0x0016fac66933c515417be6b9d74e7f61fd424d46”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“10000000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“40000000000000”,“itemType”:0,“recipient”:“0x85c2c57b349fff684b1122a755145a02dde38f79”,“identifier”:“0”}]	0x1188287829037d2d64d4b51d0dffa415c5852cbbd525509386a6112121091e8f
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0x0000000000000000000000000000000000000000	false	[{“token”:“0x0d52d602d3cd9df9ca47bb6a0deb82905f61cbee”,“amount”:“1”,“itemType”:2,“identifier”:“3009”}]	50	0x0042c856fc539eb3296770c78c96b028a8d9d734	58303334	0x409f2799628ea8667d4f3998cd0d0fc31f02f81caf4184fae6310b4b15b1e1b2	0xfbf855afd9a1156fe4175ce65e16604e6bce4df3	2024-06-18T08:20:02.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“161000000000000000”,“itemType”:0,“recipient”:“0x0042c856fc539eb3296770c78c96b028a8d9d734”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“4375000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“9625000000000000”,“itemType”:0,“recipient”:“0xcfdfa35465e6ce1e12d649905c26808809a5afac”,“identifier”:“0”}]	0xa836ec7eabbb5dacc1038ed2cbc1cc5febc809e2912a890ee2e828a205fecc92

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opensea_v1_polygon.SeaportV5_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

SeaportV1_OrderFulfilled_event

SeaportV4_OrderFulfilled_event

SeaportV5_OrderFulfilled_event

​Tables

​SeaportV1_OrderFulfilled_event

​SeaportV4_OrderFulfilled_event

​SeaportV5_OrderFulfilled_event

Tables

SeaportV1_OrderFulfilled_event

SeaportV4_OrderFulfilled_event

SeaportV5_OrderFulfilled_event