Skip to main content

​
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.
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”:“0x5a4da32ca55f9fa1e61b9243ed4a63b9d9aac1b8”,“amount”:“1”,“itemType”:2,“identifier”:“30”}]00x2768cb5e7573d3e9d8bc42f753fb2b30e89dfbc7216118080xb6be580418ed79aad5f5b28d3bd7b0b5370ebea7e0a436b98fbcea957de6ab600xbb303435ef03770fea27e879075378cad2dbc4382022-10-27T16:44:33.000Z[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“9750000000000000”,“itemType”:0,“recipient”:“0x2768cb5e7573d3e9d8bc42f753fb2b30e89dfbc7”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“250000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”}]0x31a765dbe700ddbeb256ceb6f43fd803dc16ab436203ee1df889c67eabcbe6f5
0x00000000006c3852cbef3e08e8df289169ede5810x0000000000000000000000000000000000000000false[{“token”:“0x5b09cd5e6f039bb6fb1240a05857abc0a75da8e1”,“amount”:“1”,“itemType”:2,“identifier”:“6149”}]70x899881ad8ea499299a18d1eddf84a31d0b58bcd1215993530xc44b44c2cbc9395c16c13bbcc06d93903306de8b4faebdbd1eff5c51fce1c30b0xe0c9714ee7ba68ddfbb3bc574ed1b11106e0ad732022-10-27T09:43:10.000Z[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“34125000000000000”,“itemType”:0,“recipient”:“0x899881ad8ea499299a18d1eddf84a31d0b58bcd1”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“875000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”}]0xe1de4809f212a8587a5fc2240beee25d0adae615d9c5da91b7b490b95f11b1bf
0x00000000006c3852cbef3e08e8df289169ede5810x0000000000000000000000000000000000000000false[{“token”:“0x5b09cd5e6f039bb6fb1240a05857abc0a75da8e1”,“amount”:“1”,“itemType”:2,“identifier”:“3789”}]20xb8cdca64d1f7ed64e1b25cd2c3a02fae994850f6215995610x32d2ad00c9895356da24116d58aac0de65536491107831c54dfcafc7f5f558680xe0c9714ee7ba68ddfbb3bc574ed1b11106e0ad732022-10-27T09:50:17.000Z[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“40950000000000000”,“itemType”:0,“recipient”:“0xb8cdca64d1f7ed64e1b25cd2c3a02fae994850f6”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1050000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”}]0xbf465ec0703c18d8bc0b12b8e228d8eb3a0688070e5ac803370f6bf06ae005ec
Query with partition filter
SELECT *
FROM `tt-contracts.seaport_v1_avalanche.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.
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”:“0x64defa3bbcb14c4e31042451c7208f1898c5d295”,“amount”:“1”,“itemType”:2,“identifier”:“2836”}]210x56aaed67a0b8234788b1e630d077242e826b79ec290836680x49419913573913a1e25295f9560565e8b93c63d41b5cdfe4cbd2e91610f589310xd6180be39ee2e388744c07178d56bb6aed4e71e52023-04-22T16:22:32.000Z[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“8750000000000000”,“itemType”:0,“recipient”:“0x56aaed67a0b8234788b1e630d077242e826b79ec”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“250000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1000000000000000”,“itemType”:0,“recipient”:“0xb443d654462449ba25a7d2324be1eb6ea13ba278”,“identifier”:“0”}]0xb02366ed0b7ad3844561d7b26608d755fe06bb50941c655dc2f2c7ab654aec1a
0x00000000000001ad428e4906ae43d8f9852d0dd60x0000000000000000000000000000000000000000false[{“token”:“0xa0219742881ca333657fd1873e25f5cc15edbeab”,“amount”:“1”,“itemType”:2,“identifier”:“1625”}]400xbf7aebb891cc7890c7efc44bac60ea7547cfad10290931490x78fba7ca5f6ef73cf174f29aeeff7c3326e5255ff3a2b0aee09e0455a42b49a20xd6180be39ee2e388744c07178d56bb6aed4e71e52023-04-22T21:46:48.000Z[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“21866250000000000”,“itemType”:0,“recipient”:“0xbf7aebb891cc7890c7efc44bac60ea7547cfad10”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“624750000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“2499000000000000”,“itemType”:0,“recipient”:“0xbf7aebb891cc7890c7efc44bac60ea7547cfad10”,“identifier”:“0”}]0x274b2166030e690a858b30ab6ed4a268c45501eb12f52404506d66aa682d73ed
0x00000000000001ad428e4906ae43d8f9852d0dd60x0000000000000000000000000000000000000000false[{“token”:“0x7325e3564b89968d102b3261189ea44c0f5f1a8e”,“amount”:“1”,“itemType”:2,“identifier”:“14546”}]280x7e7e7383b0d84e6524a92882f743da12d38b17bf290613740xdbb393525427d74a5d47a3fae38369e1379d6763f75c00626ab2bfd253af9fe30xdc8915723bc7115f28f85e3777bbe7340b45215b2023-04-22T03:49:48.000Z[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“194250000000000000”,“itemType”:0,“recipient”:“0x7e7e7383b0d84e6524a92882f743da12d38b17bf”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“5550000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“22200000000000000”,“itemType”:0,“recipient”:“0x85748ed7d1ef99a08fa8651ca5f6e7f40f5b515c”,“identifier”:“0”}]0xac1a521f3b485888c0afafc4a7289042c71085b493ebb16079bb55487342c9b5
Query with partition filter
SELECT *
FROM `tt-contracts.seaport_v1_avalanche.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.
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”:“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”,“amount”:“2000000”,“itemType”:1,“identifier”:“0”}]50x797ec11c78151ca5f0ba72da2f1f4c1f4f621b6b411913440xbc6b9259909fc354a502797376feeb23630b1a65bc9fd37d35324a32e03527750x62bc71aa0df320914c632c7ee133522f3aa894c82024-02-03T09:34:21.000Z[{“token”:“0x2da215293f66319facdf8fe41d99524a406d4c8f”,“amount”:“1”,“itemType”:2,“recipient”:“0x797ec11c78151ca5f0ba72da2f1f4c1f4f621b6b”,“identifier”:“4062”}]0x430ed5953e5aba79a9a1862a8b0ea29a84c628a39abe57ece6305f3c5995aed7
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x000000e7ec00e7b300774b00001314b8610022b8false[{“token”:“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”,“amount”:“110000000000000000”,“itemType”:1,“identifier”:“0”}]10xfd36dafc4c69ef7b95489f560bdbb3336e3c3c09412125960xd2cdad66163984683567d83af8299457557c5f833f3fae9e89ebe7c3940cf67a0x1944b64f3d586857a0fa85e50c4e823a00ea301a2024-02-03T21:40:01.000Z[{“token”:“0x2da215293f66319facdf8fe41d99524a406d4c8f”,“amount”:“1”,“itemType”:2,“recipient”:“0xfd36dafc4c69ef7b95489f560bdbb3336e3c3c09”,“identifier”:“8686”},{“token”:“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”,“amount”:“2750000000000000”,“itemType”:1,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”}]0x3e4001e48f8e5732262d9c1dc9d51227f931c1bc58d9283fee28692fb4d9e80f
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x000000e7ec00e7b300774b00001314b8610022b8false[{“token”:“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”,“amount”:“150000000000000000”,“itemType”:1,“identifier”:“0”}]00xc0ebc847d547f6db0a914fc397a93a107332d77c412082620xbf0945221f3f71917829e38459711f4d27ccd1c31ac30b073fe2a485c798066b0x42378ae013e5da7b190c7a058000e2848168b5cf2024-02-03T19:11:28.000Z[{“token”:“0x993869979f9f3e8269790c478eb55f1a43827981”,“amount”:“1”,“itemType”:2,“recipient”:“0xc0ebc847d547f6db0a914fc397a93a107332d77c”,“identifier”:“32716”},{“token”:“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”,“amount”:“3750000000000000”,“itemType”:1,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”}]0x2185294379b818738324bd08b95eb375cf373cf63c9d319aa74f27e471b39712
Query with partition filter
SELECT *
FROM `tt-contracts.seaport_v1_avalanche.SeaportV5_OrderFulfilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100