rarible_v1_polygon

Tables

ERC721RaribleFactory_Create721RaribleProxy_event

ERC-721 (non-fungible token) collection deployment events from Rarible’s factory contract on Polygon, recording each new NFT collection proxy address created. Useful for tracking Rarible marketplace collection launches and creator activity over time.

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_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_proxy	log_index	block_number	block_timestamp	transaction_hash
0x16911a36a56f828f17632cd4915614dd5c7a45e0	false	0x2a890a07f9805f1338f4c6aede84ec45b77fa335	502	26192789	2022-03-21T15:30:57.000Z	0x5c9ce8df607f2d5eae7a45a45e6ea8f4e64cac9c9852a6caf31c75ca24efec50
0x16911a36a56f828f17632cd4915614dd5c7a45e0	false	0x845b43e1be6ee8c87206594ebbb067cdaee96030	283	39838043	2023-03-01T10:05:09.000Z	0x34987b01d9d45a0670ea13697f35dde133ca368f5f33b680550e2175b5ba6983
0x16911a36a56f828f17632cd4915614dd5c7a45e0	false	0xdecf90c505b1bd72abc21a953f458367eff2fef5	308	31155896	2022-07-26T11:22:54.000Z	0x6934a29b79c15d7c69747c64c0a0dce7f544412cbca39cee1140762b05c21b99

Example Query

Query with partition filter

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

ERC721RaribleFactory_Create721RaribleUserProxy_event

NFT collection deployment events from Rarible’s ERC-721 factory contract on Polygon, capturing proxy contract addresses created for new collections. Used to track collection launches and identify newly deployed Rarible-based NFT contracts.

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_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_proxy	log_index	block_number	block_timestamp	transaction_hash
0x16911a36a56f828f17632cd4915614dd5c7a45e0	false	0x12a46a2ae1c9302c3fc5e771cf36dc7fc47e0665	182	31414907	2022-08-02T01:23:08.000Z	0x4a6e544c01ea4d4a03674f39158d5e649a0ef49dcc68a015fa6a4111972049f5
0x16911a36a56f828f17632cd4915614dd5c7a45e0	false	0x036de7989b006f161be6d4bfdbf7e9d24ff93234	211	31441156	2022-08-02T17:34:08.000Z	0x40ba4a749462994c0c79f863993ef66c7c6b2de685498e0e452a576ee7d4dd4b
0x16911a36a56f828f17632cd4915614dd5c7a45e0	false	0xddb292f3a8e1ae0259dc348c29d1aac0ba6a322c	287	31441268	2022-08-02T17:37:56.000Z	0xe8873537163f39523a108e68f175e383b475ce65ac0b253ebe6dd79ba40c85c0

Example Query

Query with partition filter

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

ExchangeMeta_Cancel_event

Order cancellation events from Rarible NFT marketplace v1 protocol on Polygon. Tracks cancelled listing and bid orders with unique order hashes for monitoring marketplace liquidity and user behavior.

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_hash`	`STRING`	Hash identifier of the cancelled order or listing on the Rarible NFT marketplace. This value is unique per cancellation event and references the specific order being invalidated.

Sample Data

address	in_hash	removed	log_index	block_number	block_timestamp	transaction_hash
0x12b3897a36fdb436dde2788c06eff0ffd997066e	0xa51250d43654476687c9cde79cce9a65582500fd47149c45ff66581bcae8550d	false	128	46191884	2023-08-11T22:06:36.000Z	0x5f217e267b9b41d46a2fe2035a919d746cf59f327a21100a41ee31424c32a440
0x12b3897a36fdb436dde2788c06eff0ffd997066e	0xb1151854700afdadd24dcd327306e20911db2a3c59f33e7f7f0fbc1b94cc8c5d	false	697	46191537	2023-08-11T21:53:20.000Z	0xb0292c0092bb3a985348eb39fec18307dda7aad697a8aeb98ff4460c7b415353
0x12b3897a36fdb436dde2788c06eff0ffd997066e	0x383ec564f39db2534f4f0bf921164fd9b48719bb3f9980b4191d9ef160689408	false	203	46191739	2023-08-11T22:00:56.000Z	0x641b4add02959cd4742275b7c1df4cf90d38400f31a7960e8e71a7472175a80c

Example Query

Query with partition filter

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

ExchangeMeta_directAcceptBid_function

Direct bid acceptance transactions on Rarible v1 NFT marketplace on Polygon, capturing seller executions of off-chain bids with token addresses, payment amounts, and cryptographic signatures for analyzing marketplace trade flows.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_direct`	`STRUCT<bidMaker STRING, bidNftAmount STRING, nftAssetClass STRING, nftData STRING, bidPaymentAmount STRING, paymentToken STRING, bidSalt STRING, bidStart STRING, bidEnd STRING, bidDataType STRING, bidData STRING, bidSignature STRING, sellOrderPaymentAmount STRING, sellOrderNftAmount STRING, sellOrderData STRING>`	Structured data containing order parameters for direct NFT marketplace transactions. Fields include maker address, NFT and payment amounts, asset class identifiers, token addresses, cryptographic salts, timestamps, data types, encoded order data, and cryptographic signatures for transaction verification.

Sample Data

gas	status	gas_used	in_direct	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
297354	true	285814	{“bidEnd”:“1715133454”,“bidData”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“bidSalt”:“54278091338523698497232802716436875244645081073570236729908372092422136363467”,“nftData”:“0x000000000000000000000000d8e5c8d506e51fe5e5b353a04717c7643adfb31f00000000000000000000000000000000000000000000000000000000000004bf”,“bidMaker”:“0x217510bc96069eafaebc6d297bc5087b546a9c3f”,“bidStart”:“0”,“bidDataType”:“0x23d235ef”,“bidNftAmount”:“1”,“bidSignature”:“0xfa06e71f9060cd63d46046f6394b5ab840d47b34af3466e615e870fba9451e423d28baf6ac6edfb035c7a10af1d64fb6cd8591e555f1ae0eed89a8fa81f50cd51b”,“paymentToken”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“nftAssetClass”:“0x73ad2146”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000001f4”,“bidPaymentAmount”:“40000000000000000”,“sellOrderNftAmount”:“1”,“sellOrderPaymentAmount”:“40000000000000000”}	0x67d49a3b	0x12b3897a36fdb436dde2788c06eff0ffd997066e	56445563	0xf24e4d48cfeb2f84fc7bb388c3de266d6144338f	2024-05-01T04:31:26.000Z	0xcc8a50c9aa96ce44c18216929fa17ab54fa92faaf58e8594f52db348e1054ca7
227655	true	223731	{“bidEnd”:“1694542113”,“bidData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000008f907ad7ceb9c87b643445470226ea75d317865e00000000000000000000000000000000000000000000000000000000000001f40000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000000”,“bidSalt”:“28171717215654973071537660073542476621200257750178560016137923561810774337857”,“nftData”:“0x000000000000000000000000e2ea7827dc3437ec244861b3e5074d60ff27c60d000000000000000000000000000000000000000000000000000000000000002c”,“bidMaker”:“0x7c3afb806baf17bb99585cf74a96a3634b3d7e5c”,“bidStart”:“0”,“bidDataType”:“0x23d235ef”,“bidNftAmount”:“1”,“bidSignature”:“0xf49060e4168766aa5e27290057e7b42fce097ad6ecba8a73c5dc6d0785d397260de83421dddb6845aca38cfb6a900c80b2d51854c7c596530d718c39f0edbf1f1b”,“paymentToken”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“nftAssetClass”:“0x73ad2146”,“sellOrderData”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“bidPaymentAmount”:“3000000000000000”,“sellOrderNftAmount”:“1”,“sellOrderPaymentAmount”:“3000000000000000”}	0x67d49a3b	0x12b3897a36fdb436dde2788c06eff0ffd997066e	47228444	0x8f907ad7ceb9c87b643445470226ea75d317865e	2023-09-06T20:55:21.000Z	0x7d45898e798656239b8a2059f76283ef4a6528999cc83e52fb5a4a142ec5e1fd
249455	true	244332	{“bidEnd”:“1719370888”,“bidData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“bidSalt”:“6500958923130316715588661883915763413929557096007056044714188081306854565224”,“nftData”:“0x0000000000000000000000002d29cd55f129fcfd290b240f51d4930a74096c5b0000000000000000000000000000000000000000000000000000000000000000”,“bidMaker”:“0x122fa37c32cbec73dfbe883b63fcfb81bd8b7c3b”,“bidStart”:“0”,“bidDataType”:“0x23d235ef”,“bidNftAmount”:“1”,“bidSignature”:“0xdb6ddafae6dbe73f531a0355b304fa08ef7179a857c399861e321fd93a8ef2537c786fb400ea2f3d55ce5ceb2294b743b81e3d6f13056a43e59e1d65e9460cd01c”,“paymentToken”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“nftAssetClass”:“0x973bb640”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“bidPaymentAmount”:“10000000000000000000”,“sellOrderNftAmount”:“1”,“sellOrderPaymentAmount”:“10000000000000000000”}	0x67d49a3b	0x12b3897a36fdb436dde2788c06eff0ffd997066e	58454677	0x46d2ff84d12b1ead04d38deaf9ce9d0c6ea8f6f1	2024-06-22T03:45:16.000Z	0x393c921ce9ceed621b62333664ac251c7482c23c17b1f8acf932b2e1779f99a3

Example Query

Query with partition filter

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

ExchangeMeta_directPurchase_function

Direct purchase executions on Rarible V1 marketplace on Polygon, containing NFT buy and sell order matching with payment amounts, order signatures, and ERC-721/ERC-1155 (0x73ad2146 asset class) token transfer details.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_direct`	`STRUCT<sellOrderMaker STRING, sellOrderNftAmount STRING, nftAssetClass STRING, nftData STRING, sellOrderPaymentAmount STRING, paymentToken STRING, sellOrderSalt STRING, sellOrderStart STRING, sellOrderEnd STRING, sellOrderDataType STRING, sellOrderData STRING, sellOrderSignature STRING, buyOrderPaymentAmount STRING, buyOrderNftAmount STRING, buyOrderData STRING>`	Structured data containing order parameters for direct NFT marketplace transactions. Fields include maker address, NFT and payment amounts, asset class identifiers, token addresses, cryptographic salts, timestamps, data types, encoded order data, and cryptographic signatures for transaction verification.

Sample Data

gas	value	status	gas_used	in_direct	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
338143	28300000000000000000	true	215562	{“nftData”:“0x000000000000000000000000179f99618419c4103813dcd09e76e2e7588705fd00000000000000000000000000000000000000000000000000000000000003bc”,“buyOrderData”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1704728350”,“nftAssetClass”:“0x73ad2146”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000096”,“sellOrderSalt”:“17294496482284848864900132264881648189452178988960553507498411933478497042792”,“sellOrderMaker”:“0x0531210d165aa7241b0d6b71f502b035879e2746”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“1”,“sellOrderSignature”:“0x4c3cb5bcf0428e9d9b526f98d653845ebc124bd4ac59d7c669b352bbed7cce616f2cf2573952fccc3485ec747639d112240ed2d7aab8ec54a0b1c76983551c901b”,“buyOrderPaymentAmount”:“28300000000000000000”,“sellOrderPaymentAmount”:“28300000000000000000”}	0x0d5f7d35	0x12b3897a36fdb436dde2788c06eff0ffd997066e	48646368	0xada5b350f7e41051a20646f49eedce665b125c26	2023-10-12T22:57:55.000Z	0xfb30eaa0c050fafc6d9824e98f956bbce78e1b535a147b48ef9e17a571bec2fb
243658	28680000000000000000	true	232679	{“nftData”:“0x000000000000000000000000179f99618419c4103813dcd09e76e2e7588705fd0000000000000000000000000000000000000000000000000000000000000728”,“buyOrderData”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1704453787”,“nftAssetClass”:“0x73ad2146”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000096”,“sellOrderSalt”:“21861028934221142068687582096991307428194382726600832584038080945996609263474”,“sellOrderMaker”:“0x310bacbf3616e0e34370289aacb42440f7ee7401”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“1”,“sellOrderSignature”:“0xb9c1b58bfbbd10515304a39617da70b86f4bc0b7aa64cc1e95198953e1a9ff3579b8011183fb815f11c75dc2e5f59a7b49fbed44fc4c8316f055416eedb27ad31c”,“buyOrderPaymentAmount”:“28680000000000000000”,“sellOrderPaymentAmount”:“28680000000000000000”}	0x0d5f7d35	0x12b3897a36fdb436dde2788c06eff0ffd997066e	48613602	0x480af3b9994989b70bc9282d734c8194ca55e1d3	2023-10-12T02:54:41.000Z	0x2b35f7b2a0566d2440b4220d830acad72d0a7c461b97a67d2bbb24cf3199842b
281836	45000000000000000000	true	220400	{“nftData”:“0x0000000000000000000000001e602f4fe638500b4b181adfb4a0ec886afa32bd00000000000000000000000000000000000000000000000000000000000001e2”,“buyOrderData”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1703927155”,“nftAssetClass”:“0x73ad2146”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000096”,“sellOrderSalt”:“59783167183531238264614389066508163310429888892981805863483097564074255064418”,“sellOrderMaker”:“0xdd2a75bd3428e58d058ef412c484ef2f0161b333”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“1”,“sellOrderSignature”:“0x72ae100504088907e8d4680a3c6906a907d4b3f38e44a1273f9edbfe78e04fd4721fce9cdca3fc5792784a2ec53c509cc0da15c5015689180c1b5492144350081c”,“buyOrderPaymentAmount”:“45000000000000000000”,“sellOrderPaymentAmount”:“45000000000000000000”}	0x0d5f7d35	0x12b3897a36fdb436dde2788c06eff0ffd997066e	48622284	0xc4b4a7a153ab665b3b2ba5bd5a4c6c34b71e5ee6	2023-10-12T08:23:39.000Z	0xefdf520d79029dc2d3b65939a56f51cde056222b0c7ecad67abd6e553b9954cd

Example Query

Query with partition filter

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

ExchangeMeta_executeMetaTransaction_function

Meta-transaction executions on Rarible NFT marketplace V1 (Polygon), enabling gasless transactions where relayers submit signed user operations. Contains signature components (sigR, sigS, sigV) and encoded function data for analyzing delegated transaction patterns.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_userAddress`	`STRING`	Address of the user executing the meta-transaction, distinct from the relayer submitting it on-chain. This is the signer whose signature components (in_sigR, in_sigS, in_sigV) authorize the transaction execution.
`in_functionSignature`	`STRING`	Encoded function call data representing the meta-transaction to be executed on behalf of the user address. Contains the actual exchange operation parameters (order details, amounts, addresses) that will be executed after signature verification.
`in_sigR`	`STRING`	R component of the ECDSA signature verifying the meta-transaction authorization from the user address. 32-byte hex-encoded value with 0x prefix, part of the signature triplet (v, r, s) used for cryptographic validation.
`in_sigS`	`STRING`	S component of the ECDSA signature used to verify the meta-transaction on behalf of the user. Hex-encoded 32-byte value starting with 0x, part of the standard Ethereum signature triplet (v, r, s).
`in_sigV`	`INT64`	Recovery ID parameter from the ECDSA signature used to verify the meta-transaction. Integer value typically 27 or 28, used alongside sigR and sigS to recover the signer’s address.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	in_sigR	in_sigS	in_sigV	gas_used	out_anon0	signature	to_address	block_number	from_address	in_userAddress	block_timestamp	transaction_hash	in_functionSignature
272416	true	0x9f0411ecce9c9fa7bc1af90d81f3dce8ba6c87c1cf24b9cd47d0c535b8bc8bc3	0x5b4bd936db8e4e5cb1b2e558645a0f27498dba9cf130dbcb4d23e9a718d39a62	27	258482	0x	0x0c53c51c	0x12b3897a36fdb436dde2788c06eff0ffd997066e	32612354	0x2d7813a2e158b1615599e98ece851b29ad30d9db	0x797bb4e297dd737c4fe9065b95cfb769b98f4f02	2022-09-02T21:25:42.000Z	0x6a8ad9c7718829b508542e9e9e365a3c1eed5beb51595765b19c4703ea4c525d	0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c000000000000000000000000044f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002008a598533fb30dcfafca41c5f628a0c4654024b1a7502460daa774c863289bdc60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000006973bb64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000400000000000000000000000002230e0c09289009478dd0b6e03d55f53fd3ba1ba44f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000068ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000424ace4669579986d200ebeb3c75924282324a42000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000415e7c18bcf7abffbbe9f506980eb30cb7212fa50c7a3ec141bb94f8a18314de59536c192c4b3cf928c4680e65819b7e150917e79b5e29ce78a65d7ad4ac7fcab11b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000797bb4e297dd737c4fe9065b95cfb769b98f4f02000000000000000000000000000000000000000000000000000000000000012000000000000000000000000044f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba00000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000058ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000005973bb64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000400000000000000000000000002230e0c09289009478dd0b6e03d55f53fd3ba1ba44f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba00000000000000000000000200000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461
269168	true	0x5504d4906162f4c1968cd97327e366f269f9faa9e2c6b0c75365c576732fe0e3	0x2d681c914a89b3c015e85338793a8eaaa22b88bfff8a9e44a2072398354de634	27	255284	0x	0x0c53c51c	0x12b3897a36fdb436dde2788c06eff0ffd997066e	32597482	0x860ea4f47bf3917549cf558b0173ee0898480afe	0xe7f36cbbe217edc72a827c6e52ebc651dbc7d8c8	2022-09-02T12:38:41.000Z	0xa5c489f5d5e2293f1c4754138380bb6176ee2e210021bdec0508696690ed235b	0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c0000000000000000000000000a339e00f18d677cc5b149224582e9ff7f2e058f00000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e0b315acc5f33449053a7a51a68fdaa175663b931596400001e951ab781d7c29780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000a8ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000a973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a2d9ded6115b7b7208459450d676f0127418ae7a48e2c8bbbe8a61d2fdd9af6d1ad1d480cfe5abad0000000000000000000000420000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000424ace4669579986d200ebeb3c75924282324a4200000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000041fabe2e5100297a310f98934829158980a9232f6ccb7a99099a2e516b29be4cd27491fe698346871b9685e5668fd5404d897e19d4fa77d72bd653b42145411b101c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000e7f36cbbe217edc72a827c6e52ebc651dbc7d8c80000000000000000000000000000000000000000000000000000000000000120000000000000000000000000a339e00f18d677cc5b149224582e9ff7f2e058f0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a2d9ded6115b7b7208459450d676f0127418ae7a48e2c8bbbe8a61d2fdd9af6d1ad1d480cfe5abad000000000000000000000042000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000018ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461
307063	true	0x691566ac18cb2f53a69bd04df7b86ba7c7dac44d598e0a6be401fccfb44512c5	0x1bbe5ea7275071bf312551b89b204135d45046bbb3d5ae6af5573e2afc52fd2e	27	292587	0x	0x0c53c51c	0x12b3897a36fdb436dde2788c06eff0ffd997066e	32595664	0x3587474523c5c8a352c558a2bb52732e1f851d5b	0xa7a62f32613686bd2f634498e46879fbeb3f7f0c	2022-09-02T11:36:11.000Z	0x78a48729b1a42dbc37346d690bd75be7fa1bc4d02297c0b02a765adbc6db0fbc	0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c00000000000000000000000003c5593af538b2278ebdcee385fdc5db94473daf00000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e04aed66014d68f1e178c26efeed70bd9714abe97b869193abe9cd9a5118a275c70000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000186a08ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000186a0973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000c218504fccd2a16c0f68dab9fd163fbe39678090c3ce6692bd4f0892e524b410fb9480dde0efa6ef0000000000000000000000950000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000424ace4669579986d200ebeb3c75924282324a42000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000416ba8c7789d1c7023044a5d48809874d79ec4494b1de061a41636fe0c0bf27d786613e0ea77d1c20d1b78b87fa4aee2256fba091f0f14e83355312a825d529bf81c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000a7a62f32613686bd2f634498e46879fbeb3f7f0c00000000000000000000000000000000000000000000000000000000000001200000000000000000000000003c5593af538b2278ebdcee385fdc5db94473daf0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000c218504fccd2a16c0f68dab9fd163fbe39678090c3ce6692bd4f0892e524b410fb9480dde0efa6ef000000000000000000000095000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000018ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461

Example Query

Query with partition filter

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

ExchangeMeta_Match_event

Order matching events from Rarible’s v1 NFT marketplace on Polygon, recording left and right order hashes with their fill amounts when trades execute. Used for tracking marketplace settlement activity and partial order fulfillment patterns.

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_leftHash`	`STRING`	Unique identifier hash for the left-side order in a Rarible exchange match on Polygon. Hex-encoded, 0x-prefixed 64-character string that references the maker order being filled.
`in_rightHash`	`STRING`	Hash identifier of the right-side (taker) order in the Rarible exchange match event. Hex-encoded, 0x-prefixed 64-character keccak256 hash uniquely identifying the order being matched against.
`in_newLeftFill`	`STRING`	Filled quantity for the left-side order after this match execution on Rarible’s exchange contract. Values represent token amounts in smallest unit (wei for ERC-20, or single NFT for ERC-721).
`in_newRightFill`	`STRING`	Updated fill amount for the right-side order after the match is executed on Rarible’s exchange contract. Represents the cumulative quantity filled in the order’s base units (often wei for native tokens or smallest denomination for ERC-20).

Sample Data

address	removed	log_index	in_leftHash	block_number	in_rightHash	in_newLeftFill	block_timestamp	in_newRightFill	transaction_hash
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	1001	0x1520ee9b8d0497d03aefa2cb4cf4990d492257e015d3b3135a1709710f0d8bbc	73342328	0x350c4695483bace87fc632a06efa2e0581ecbe8be39affff6fedb7f2ff44ebba	1	2025-06-28T22:46:23.000Z	100000	0xe8fbd428e86a82e9c2e0a7eedf615a98606ee62f3b44509286cfb18f30078608
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	317	0x5ef9a5461714e5271c1f15e3a703e05c7e04f7380295bf1cfe267cb0f26f9e11	73342676	0xf07976ee57437df9da2a713bd690a09345e2522551057077fa6ddcc238921274	1	2025-06-28T22:58:43.000Z	100000	0xd11986c43bbd359ebbdb1986f89eefe5ba3cf7edf44700efbc8d702a91b252c0
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	20	0x6225007769d98a579289530f0c4bbac036bd8c0532455c8a356b68c6e86a7353	73330276	0xff98d2524f913d6390b7886a8ab5b60ab6bfbfd9589f742c2277146f7e33736a	1000000000000000000	2025-06-28T15:39:14.000Z	1	0x2a57bb9a8d0c8096b7262f67b2ce9fc863285867cb990035a6695a3b0dd1e4c2

Example Query

Query with partition filter

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

ExchangeMeta_MatcherChange_event

Matcher authorization events from Rarible NFT marketplace on Polygon, tracking when addresses are granted or revoked permission to match orders for specific asset types. Used for analyzing marketplace operator changes and order matching infrastructure.

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_assetType`	`STRING`	Asset type identifier for the Rarible exchange protocol. 10-character hex string including 0x prefix.
`in_matcher`	`STRING`	Address of the matcher contract authorized to facilitate trades for the specified asset type on Rarible. Hex-encoded, 0x-prefixed 40-character string representing the contract responsible for order matching.

Sample Data

address	removed	log_index	in_matcher	block_number	in_assetType	block_timestamp	transaction_hash
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	45	0xaaa348b4b087475c320a24719748a2e6be1c2cc8	25193940	0xf63c2825	2022-02-21T13:07:52.000Z	0x57d2fa40b2f9b44428d515259d04c41247bf520e244fec205a63d22c55428e43

Example Query

Query with partition filter

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

ExchangeMeta_matchOrders_function

Matched order execution records from Rarible’s NFT marketplace protocol on Polygon. Contains left and right order details with maker/taker addresses, asset types, signatures, and fill amounts for analyzing NFT trading activity and price discovery.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_orderLeft`	`STRUCT<maker STRING, makeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, taker STRING, takeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, salt STRING, start STRING,` end `STRING, dataType STRING, data STRING>`	Order details from the selling side of the trade, including maker address, asset types, quantities, and cryptographic signatures. Contains nested fields defining what asset is being sold (makeAsset) and what is requested in exchange (takeAsset).
`in_signatureLeft`	`STRING`	Cryptographic signature from the maker of the left-side order, hex-encoded. May be empty (0x) when order is already on-chain or does not require signature verification.
`in_orderRight`	`STRUCT<maker STRING, makeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, taker STRING, takeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, salt STRING, start STRING,` end `STRING, dataType STRING, data STRING>`	Left-side order details in a Rarible NFT exchange match, containing maker/taker addresses, asset types, quantities, and cryptographic signatures. Structured record with nested fields for the order being matched against `in_orderLeft`.
`in_signatureRight`	`STRING`	Cryptographic signature from the right-side order maker authorizing the trade. May be empty (0x) when the maker is also the transaction sender and authorization is implicit.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_orderLeft	in_orderRight	trace_address	block_timestamp	in_signatureLeft	transaction_hash	in_signatureRight
313962	true	205671	0xe99a3f80	0x12b3897a36fdb436dde2788c06eff0ffd997066e	37697397	0x544299fe0c7bb3b8c80535f224011f8c06406cdb	{“end”:“0”,“data”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“salt”:“23375205609634225238415199688892763940500709474949544723136053284821754926298”,“maker”:“0x9244ac5b4ff5ed244e23b15dc7a9db77cacbb395”,“start”:“0”,“taker”:“0x0000000000000000000000000000000000000000”,“dataType”:“0x23d235ef”,“makeAsset”:{“value”:“200000000000000”,“assetType”:{“data”:“0x0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619”,“assetClass”:“0x8ae85d84”}},“takeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000509d5acc1c08fcdbc3bad469e2cc011de6d0117a544299fe0c7bb3b8c80535f224011f8c06406cdb000000000000000000000008”,“assetClass”:“0x73ad2146”}}}	{“end”:“0”,“data”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“salt”:“0”,“maker”:“0x544299fe0c7bb3b8c80535f224011f8c06406cdb”,“start”:“0”,“taker”:“0x9244ac5b4ff5ed244e23b15dc7a9db77cacbb395”,“dataType”:“0x23d235ef”,“makeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000509d5acc1c08fcdbc3bad469e2cc011de6d0117a544299fe0c7bb3b8c80535f224011f8c06406cdb000000000000000000000008”,“assetClass”:“0x73ad2146”}},“takeAsset”:{“value”:“200000000000000”,“assetType”:{“data”:“0x0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619”,“assetClass”:“0x8ae85d84”}}}		2023-01-05T09:48:59.000Z	0x47cb4d5d338f6655d65b7654448fc6c415530bbc2c4e43a0b973d35ecedf29592f74400d71d00867317934488dc9435fa39ce35ac4408c8f0b20dce0ccdd78181c	0x8c2b7e2363eaf311f1b2412baa8cca99c0560463b597848728d242f97ad349e0	0x
190906	true	157929	0xe99a3f80	0x12b3897a36fdb436dde2788c06eff0ffd997066e	37691761	0x12b3897a36fdb436dde2788c06eff0ffd997066e	{“end”:“0”,“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064”,“salt”:“41331888608525088382884865771408309681997912343388138915487648602938077414900”,“maker”:“0x3c5593af538b2278ebdcee385fdc5db94473daf0”,“start”:“0”,“taker”:“0x0000000000000000000000000000000000000000”,“dataType”:“0x23d235ef”,“makeAsset”:{“value”:“10000”,“assetType”:{“data”:“0x0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619”,“assetClass”:“0x8ae85d84”}},“takeAsset”:{“value”:“100”,“assetType”:{“data”:“0x0000000000000000000000002953399124f0cbb46d2cbacd8a89cf059997496324b90eaf3d45928f7483f61c4242ef99be5ed44d0000000000000200000186a0”,“assetClass”:“0x973bb640”}}}	{“end”:“0”,“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064”,“salt”:“0”,“maker”:“0x2814045419933db0eafad825fd52bfd57593f861”,“start”:“0”,“taker”:“0x3c5593af538b2278ebdcee385fdc5db94473daf0”,“dataType”:“0x23d235ef”,“makeAsset”:{“value”:“1”,“assetType”:{“data”:“0x0000000000000000000000002953399124f0cbb46d2cbacd8a89cf059997496324b90eaf3d45928f7483f61c4242ef99be5ed44d0000000000000200000186a0”,“assetClass”:“0x973bb640”}},“takeAsset”:{“value”:“100”,“assetType”:{“data”:“0x0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619”,“assetClass”:“0x8ae85d84”}}}	0,1	2023-01-05T06:24:33.000Z	0x8c2ed4abbf00cef46d9a7e9ea35bb134669fa33b893cc95af118936f9b8d8dff14530f23fc3886a43f2c90a5d8b42abe12e669a5df34f6f00595134f324faf981c	0xa5721753bbe9f5f663f10252d514dcb26b082ed15415da82e0cc72d6b9f2b17f	0x
190906	true	157929	0xe99a3f80	0x12b3897a36fdb436dde2788c06eff0ffd997066e	37691723	0x12b3897a36fdb436dde2788c06eff0ffd997066e	{“end”:“0”,“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064”,“salt”:“41331888608525088382884865771408309681997912343388138915487648602938077414900”,“maker”:“0x3c5593af538b2278ebdcee385fdc5db94473daf0”,“start”:“0”,“taker”:“0x0000000000000000000000000000000000000000”,“dataType”:“0x23d235ef”,“makeAsset”:{“value”:“10000”,“assetType”:{“data”:“0x0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619”,“assetClass”:“0x8ae85d84”}},“takeAsset”:{“value”:“100”,“assetType”:{“data”:“0x0000000000000000000000002953399124f0cbb46d2cbacd8a89cf059997496324b90eaf3d45928f7483f61c4242ef99be5ed44d0000000000000200000186a0”,“assetClass”:“0x973bb640”}}}	{“end”:“0”,“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064”,“salt”:“0”,“maker”:“0x2814045419933db0eafad825fd52bfd57593f861”,“start”:“0”,“taker”:“0x3c5593af538b2278ebdcee385fdc5db94473daf0”,“dataType”:“0x23d235ef”,“makeAsset”:{“value”:“1”,“assetType”:{“data”:“0x0000000000000000000000002953399124f0cbb46d2cbacd8a89cf059997496324b90eaf3d45928f7483f61c4242ef99be5ed44d0000000000000200000186a0”,“assetClass”:“0x973bb640”}},“takeAsset”:{“value”:“100”,“assetType”:{“data”:“0x0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619”,“assetClass”:“0x8ae85d84”}}}	0,1	2023-01-05T06:23:17.000Z	0x8c2ed4abbf00cef46d9a7e9ea35bb134669fa33b893cc95af118936f9b8d8dff14530f23fc3886a43f2c90a5d8b42abe12e669a5df34f6f00595134f324faf981c	0xe9029312b5a55a68fe2cb5ccee3b2797d6ae618bd077613e98269006a2ec5953	0x

Example Query

Query with partition filter

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

ExchangeMeta_MetaTransactionExecuted_event

Meta-transaction execution events from Rarible NFT marketplace on Polygon, capturing gasless transactions where relayers submit signed operations on behalf of users. Records include user and relayer addresses with function signatures for analyzing marketplace activity patterns and relayer behavior.

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_userAddress`	`STRING`	Address of the user on whose behalf the meta-transaction was executed on the Rarible exchange contract. This is the actual account initiating the action, while the relayer submits the transaction on-chain.
`in_relayerAddress`	`STRING`	Address of the relayer that submitted the meta-transaction on behalf of the user. Always present as a hex-encoded, 0x-prefixed Polygon address in this Rarible exchange event.
`in_functionSignature`	`STRING`	Encoded function call data and parameters for the meta-transaction being executed by the relayer on behalf of the user. Hex-encoded string starting with 0x containing the function selector and ABI-encoded arguments.

Sample Data

address	removed	log_index	block_number	in_userAddress	block_timestamp	transaction_hash	in_relayerAddress	in_functionSignature
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	190	35107719	0x02df085bf71475e4a59e85b4a76e1a8b51de58ec	2022-11-02T11:59:43.000Z	0xba0c9eb287f2145e58c97d4f00623721571680d314a2519dfe1c07dae36b2b0f	0xb5e8094db2d7b859834ab1cf14c8721053fca1fd	0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c0000000000000000000000000fd13a78d98c6dc839e0c4805318ee1b7035bc3cb0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e04fa04d544c0fd88bbec0602208e4abf1e3eb568db8d8267f4a41fd23cc0821cd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000002540a58b08ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000005f5dd0c973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a2d9ded6115b7b7208459450d676f0127418ae7a5d3193bf0009b1c0c1dc04b63a7c3ed8a212285700000000000000000000000800000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000041e68ae9d3f5981418103674f890cbb46e7aa59394b63e0e6a7691b477e3a2ba9527233bbfa7bf75c34902e1bb4c0ce6f98d6f4d979943b992ec7658016d59268c1b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000002df085bf71475e4a59e85b4a76e1a8b51de58ec0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000fd13a78d98c6dc839e0c4805318ee1b7035bc3cb000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a2d9ded6115b7b7208459450d676f0127418ae7a5d3193bf0009b1c0c1dc04b63a7c3ed8a2122857000000000000000000000008000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000648ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	141	35105528	0x03f230e5b68883768198d5bcdbf555f8bb9d792f	2022-11-02T10:44:16.000Z	0x5d72d54b73151a9290cfa356b4298635db0bc8726788078adec8efddb3b0df8e	0xcca820619e667c8c168434a886587e7b195c6457	0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c0000000000000000000000000f7165248e5f0562c27f8fefa55288c640d4c953a0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e0651bd0c99da09d58570d1f30ad31daa446bfa4c7f1605d6c3e2c026f749c83860000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000009184e72a0008ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000173ad2146000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004000000000000000000000000071cf7ce522494e4fdd47ab2e5c0b338b2ab75cb103f230e5b68883768198d5bcdbf555f8bb9d792f00000000000000000000000e00000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000041c32f3bb9b2378b829484dbfbc3f6c007060b96315f66b9968937f817a9407ded3e142dd5f73fc8431a9a31a439de3ea429b3e7c152872b7c530b3fde4889f2401c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000003f230e5b68883768198d5bcdbf555f8bb9d792f0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000f7165248e5f0562c27f8fefa55288c640d4c953a000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000173ad2146000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004000000000000000000000000071cf7ce522494e4fdd47ab2e5c0b338b2ab75cb103f230e5b68883768198d5bcdbf555f8bb9d792f00000000000000000000000e0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000009184e72a0008ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	100	35105614	0x03f230e5b68883768198d5bcdbf555f8bb9d792f	2022-11-02T10:47:19.000Z	0xe12c6a97e7a0cd64888b9dce1cee91f9e65b330d13aebc19be9720aac6fa2de9	0x1bf258774820faddd340491f5719d61b92cd2107	0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c0000000000000000000000000f7165248e5f0562c27f8fefa55288c640d4c953a0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e0a48f23fe765b0b06698925b49108bc2a74ba5327fa30e596b4811d9675d2c8b60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000246139ca80008ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000004973bb64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000400000000000000000000000002953399124f0cbb46d2cbacd8a89cf0599974963b7cca536949526db2cbe7c263f09cfe60dfdad9a0000000000003c00000186a000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000004174dd371b6ba76a7837739c33ad0a36de45d712d95ac785cf285914cb7ffd512d213b57458a0aed64640ac9184ff36f17c867df2404be8df4286afae766433a001b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000003f230e5b68883768198d5bcdbf555f8bb9d792f0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000f7165248e5f0562c27f8fefa55288c640d4c953a000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001973bb64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000400000000000000000000000002953399124f0cbb46d2cbacd8a89cf0599974963b7cca536949526db2cbe7c263f09cfe60dfdad9a0000000000003c00000186a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000009184e72a0008ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461

Example Query

Query with partition filter

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

ExchangeMeta_OwnershipTransferred_event

Ownership transfer events from Rarible’s ExchangeMeta contract on Polygon, tracking when contract administration changes hands from previous to new owner addresses. Used for monitoring contract governance transitions and administrative control history.

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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0x12b3897a36fdb436dde2788c06eff0ffd997066e	false	102	0x20b9049c69dea7e5d46de82ce0b33a9d5a8a0893	25193887	2022-02-21T13:06:02.000Z	0x0000000000000000000000000000000000000000	0x5e6c5ddcf0f524075cf5d661598b7b55d41c5d79b35770f2ef540e9e7c67cf4a

Example Query

Query with partition filter

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

ExchangeMeta_setAssetMatcher_function

Contract function calls for configuring asset type matchers in the Rarible NFT exchange protocol on Polygon. Used to track administrative changes to supported asset types and their corresponding matcher contract addresses.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_assetType`	`STRING`	Asset type identifier for the Rarible exchange protocol. 10-character hex string including 0x prefix.
`in_matcher`	`STRING`	Contract address of the asset matcher being registered for the specified asset type. This matcher contract implements the logic to verify asset compatibility in Rarible exchange orders.

Sample Data

gas	value	status	gas_used	signature	in_matcher	to_address	block_number	from_address	in_assetType	trace_address	block_timestamp	transaction_hash
5978392	0	true	33791	0xb39deb46	0xaaa348b4b087475c320a24719748a2e6be1c2cc8	0x12b3897a36fdb436dde2788c06eff0ffd997066e	25193940	0x20b9049c69dea7e5d46de82ce0b33a9d5a8a0893	0xf63c2825		2022-02-21T13:07:52.000Z	0x57d2fa40b2f9b44428d515259d04c41247bf520e244fec205a63d22c55428e43

Example Query

Query with partition filter

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

RoyaltiesRegistry_clearRoyaltiesType_function

Royalty registry function calls that clear or remove royalty type configurations for NFT collections on Rarible’s Polygon marketplace. Tracks administrative actions removing royalty settings from specific token contracts.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	in_token	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
41460	true	18140	0xa264c4f62937719b865e80fc76a6d6b86a880e35	0xfc73be00	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	32411234	0x8a1aa457b06ca13945ef5e7a39285efe5b38d3e8	2022-08-28T11:22:15.000Z	0x2331974603ada308975d1f2a3148056142d44a04192259b396bbd8834095ce66
20912	true	20738	0xa93dd827649712594421fca090bdda0fde7525d0	0xfc73be00	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	52590997	0x72e5de45588aa6597826c23eeff329778e35723b	2024-01-21T18:12:03.000Z	0x02b26fe789625258fb76094328a3fc71fd250e5e4a2f0757655a5aa89a927ca4
41203	true	17972	0x9f096fa5ffe4247390740a4e89707dcc11c4cf1b	0xfc73be00	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	47582483	0xdf3a37791a6d59e42dbcc6f53ab576493d031ac7	2023-09-15T19:03:58.000Z	0xecba65a3d9e5c02e3d39f6da536a66dc2063a06f4bc14a2594d367412f4aa9df

Example Query

Query with partition filter

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

RoyaltiesRegistry_forceSetRoyaltiesType_function

Administrative function calls to Rarible’s RoyaltiesRegistry contract on Polygon for forcibly setting NFT royalty types. Used to track protocol governance actions and royalty configuration changes across NFT collections.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_royaltiesType`	`STRING`	Input parameter specifying the royalty type identifier to be forcibly set for a token contract in the Rarible registry. Null values in samples suggest failed transactions where the parameter was not successfully decoded.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
28478416	false	17976	0x36eff6c2	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	30776056	0x2fbcf8d541e4ad70989cb618908fabe5fd6656f8	2022-07-16T05:11:52.000Z	0x2ce6c1d528021c9ce6f32ad295845709c9bc8756ef9da997a6e3b38aab8c005c
28478428	false	17976	0x36eff6c2	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	30776164	0x2fbcf8d541e4ad70989cb618908fabe5fd6656f8	2022-07-16T05:17:44.000Z	0x856fed6e40d0d1ed0ac5efd2af027b38494120c807f0b60dbabeed1d4e6500a3
28478416	false	17976	0x36eff6c2	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	30844287	0x2fbcf8d541e4ad70989cb618908fabe5fd6656f8	2022-07-18T02:13:56.000Z	0x41822566830ffd1847586d5db1ef8545271f9b7ffb29c4e916831d6b54b39581

Example Query

Query with partition filter

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

RoyaltiesRegistry_getRoyalties_function

Royalty lookup function calls from Rarible’s RoyaltiesRegistry contract on Polygon, querying royalty configurations for specific NFT (Non-Fungible Token) contracts and token IDs. Used for analyzing royalty settings and marketplace integration patterns across Rarible-traded collections.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`out_account`	`STRING`	Recipient account address that receives royalty payments for the queried NFT token. Null when no royalty configuration exists for the token.
`out_value`	`STRING`	Royalty percentage value returned by the registry for the specified NFT token. Null when no royalty configuration exists for the queried token.

Sample Data

gas	status	gas_used	in_token	signature	in_tokenId	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
100952	true	11338	0xe05b172278722b7009faf690508ae437e8ba2de2	0x9ca7dc7a	33742	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	54051072	0x12b3897a36fdb436dde2788c06eff0ffd997066e	0,2	2024-02-28T08:16:37.000Z	0x6734a6de10a2409779a7a29c411035dc0839f824b5f0c94146fc8a4c79c3a1da
85740	true	11338	0xff0271135213197f76fd512621d0c98c25b8d69f	0x9ca7dc7a	801	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	54038002	0x12b3897a36fdb436dde2788c06eff0ffd997066e	0,1	2024-02-28T00:01:29.000Z	0xe77d0468ea5156a950d667d9a4bb50bf6203dceb1b95a6b9021c245da0493a45
67769	true	11338	0x0ad52bfd0ddd09f581f0f790fe4f7369e9097712	0x9ca7dc7a	1144	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	54051187	0x12b3897a36fdb436dde2788c06eff0ffd997066e	0,1	2024-02-28T08:20:41.000Z	0x9866b6a5161500a8fe8e543d57e9d809ccc0535f6cc28be2860113ba68af7b39

Example Query

Query with partition filter

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

RoyaltiesRegistry_OwnershipTransferred_event

Ownership transfer events from Rarible’s royalty registry contract on Polygon, tracking changes in contract control from previous to new owner addresses. Used for monitoring protocol governance transitions and administrative changes to the NFT royalty management system.

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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0xf2514f32ae798ca29641f6e2313bacb1650cc76f	false	132	0x20b9049c69dea7e5d46de82ce0b33a9d5a8a0893	22593136	2021-12-16T13:28:05.000Z	0x0000000000000000000000000000000000000000	0x0d2db4efc0975908e9a1b8e23eaf0b464a2e4be8ce92f03a6d6097435c3ba679

Example Query

Query with partition filter

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

RoyaltiesRegistry_RoyaltiesSetForContract_event

Royalty configuration events from Rarible’s RoyaltiesRegistry contract on Polygon, recording when creators set royalty percentages (in basis points) and recipient accounts for NFT collections. Used for tracking creator earnings settings and analyzing marketplace royalty enforcement across different token contracts.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_royalties`	`ARRAY<STRUCT<account STRING, value STRING>>`	Array of royalty recipients and their corresponding basis point values. Each struct contains an account address (hex-encoded, 0x-prefixed, 42-character string) and a value (numeric string representing basis points, where 500 = 5%).

Sample Data

address	removed	in_token	log_index	block_number	in_royalties	block_timestamp	transaction_hash
0xf2514f32ae798ca29641f6e2313bacb1650cc76f	false	0x61e04ecf84589fb6c78c40b4cc7e901ca6409478	449	70870585	[{“value”:“500”,“account”:“0x06d2d90afd5de4dfdeb6b08f2a08ab1eac28c255”}]	2025-04-28T20:01:18.000Z	0x873ee566116d277bbf9d48f659911cf5fb9f62b3ef4890ad98512d5721c8808d
0xf2514f32ae798ca29641f6e2313bacb1650cc76f	false	0x52b3700f9c6f09206f25a3354f0bba3c0967b675	366	70872792	[{“value”:“500”,“account”:“0x2b6924185e83837fe95bd759efe9fd21ce5e35a1”}]	2025-04-28T21:19:28.000Z	0x5e941a8f053c9c4af0ae7746466befc80e84547ce40ec1d0ced25899b4cdeae3
0xf2514f32ae798ca29641f6e2313bacb1650cc76f	false	0x06d5c72aa9e54eda6245bcae85bb64fd17343095	339	50458296	[{“value”:“1000”,“account”:“0x1fe5cf4fe24819ca0869c75fead76804c6f1db28”}]	2023-11-27T16:18:17.000Z	0xa6218fe6fd1baaf5af4ee75321fcd08cbd774daf166a9f210bd7d8a511c966d5

Example Query

Query with partition filter

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

RoyaltiesRegistry_RoyaltiesSetForToken_event

No description available.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_royalties`	`ARRAY<STRUCT<account STRING, value STRING>>`	Array of royalty recipients and their corresponding basis point values. Each struct contains an account address (hex-encoded, 0x-prefixed, 42-character string) and a value (numeric string representing basis points, where 500 = 5%).

Sample Data

No sample data available.

Example Query

Query with partition filter

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

RoyaltiesRegistry_setRoyaltiesByToken_function

Function calls to set royalty configurations for NFT token contracts on Rarible’s Polygon marketplace. Records royalty percentage (basis points) and beneficiary addresses for each token collection, supporting secondary sale creator compensation tracking.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_royalties`	`ARRAY<STRUCT<account STRING, value STRING>>`	Array of royalty recipients and their corresponding basis point values. Each struct contains an account address (hex-encoded, 0x-prefixed, 42-character string) and a value (numeric string representing basis points, where 500 = 5%).

Sample Data

gas	status	gas_used	in_token	signature	to_address	block_number	from_address	in_royalties	block_timestamp	transaction_hash
143971	true	141679	0x6de88a6cd1a865da2e97f225ec12d89b1527e440	0xacf14efb	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	64950315	0xa6c1673a727255e53a511e0be9ce51ddd56301d9	[{“value”:“1000”,“account”:“0xa6c1673a727255e53a511e0be9ce51ddd56301d9”}]	2024-12-01T10:46:14.000Z	0xdd13e745d56ca76466f35a9638e3e927b050fc469f5440578d008da0ef579e82
143959	true	141667	0xfa595d1bd8534f44a3cc5a412991a72841c33812	0xacf14efb	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	64948995	0xaef3bf86481d002d8e5b5bde5ee59e2966f61d18	[{“value”:“1000”,“account”:“0xaef3bf86481d002d8e5b5bde5ee59e2966f61d18”}]	2024-12-01T09:58:58.000Z	0x60dd7c7f55f73c94e2e83e21a42b9f332cdecb74ab70d594f8f33650172713f6
136375	true	134143	0x6be7edb641efd8c0110c107f563f3bad20e57c95	0xacf14efb	0xf2514f32ae798ca29641f6e2313bacb1650cc76f	71032924	0x87c329bffe5e5cdca30339fd50c68b46be222798	[{“value”:“1000”,“account”:“0x87c329bffe5e5cdca30339fd50c68b46be222798”}]	2025-05-02T20:09:01.000Z	0x47b9c17fd69125430ceab091bf91dd02019405690da2fed9f6db31ada9a0a966

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ERC721RaribleFactory_Create721RaribleProxy_event

ERC721RaribleFactory_Create721RaribleUserProxy_event

ExchangeMeta_Cancel_event

ExchangeMeta_directAcceptBid_function

ExchangeMeta_directPurchase_function

ExchangeMeta_executeMetaTransaction_function

ExchangeMeta_Match_event

ExchangeMeta_MatcherChange_event

ExchangeMeta_matchOrders_function

ExchangeMeta_MetaTransactionExecuted_event

ExchangeMeta_OwnershipTransferred_event

ExchangeMeta_setAssetMatcher_function

RoyaltiesRegistry_clearRoyaltiesType_function

RoyaltiesRegistry_forceSetRoyaltiesType_function

RoyaltiesRegistry_getRoyalties_function

RoyaltiesRegistry_OwnershipTransferred_event

RoyaltiesRegistry_RoyaltiesSetForContract_event

RoyaltiesRegistry_RoyaltiesSetForToken_event

RoyaltiesRegistry_setRoyaltiesByToken_function

​Tables

​ERC721RaribleFactory_Create721RaribleProxy_event

​ERC721RaribleFactory_Create721RaribleUserProxy_event

​ExchangeMeta_Cancel_event

​ExchangeMeta_directAcceptBid_function

​ExchangeMeta_directPurchase_function

​ExchangeMeta_executeMetaTransaction_function

​ExchangeMeta_Match_event

​ExchangeMeta_MatcherChange_event

​ExchangeMeta_matchOrders_function

​ExchangeMeta_MetaTransactionExecuted_event

​ExchangeMeta_OwnershipTransferred_event

​ExchangeMeta_setAssetMatcher_function

​RoyaltiesRegistry_clearRoyaltiesType_function

​RoyaltiesRegistry_forceSetRoyaltiesType_function

​RoyaltiesRegistry_getRoyalties_function

​RoyaltiesRegistry_OwnershipTransferred_event

​RoyaltiesRegistry_RoyaltiesSetForContract_event

​RoyaltiesRegistry_RoyaltiesSetForToken_event

​RoyaltiesRegistry_setRoyaltiesByToken_function

Tables

ERC721RaribleFactory_Create721RaribleProxy_event

ERC721RaribleFactory_Create721RaribleUserProxy_event

ExchangeMeta_Cancel_event

ExchangeMeta_directAcceptBid_function

ExchangeMeta_directPurchase_function

ExchangeMeta_executeMetaTransaction_function

ExchangeMeta_Match_event

ExchangeMeta_MatcherChange_event

ExchangeMeta_matchOrders_function

ExchangeMeta_MetaTransactionExecuted_event

ExchangeMeta_OwnershipTransferred_event

ExchangeMeta_setAssetMatcher_function

RoyaltiesRegistry_clearRoyaltiesType_function

RoyaltiesRegistry_forceSetRoyaltiesType_function

RoyaltiesRegistry_getRoyalties_function

RoyaltiesRegistry_OwnershipTransferred_event

RoyaltiesRegistry_RoyaltiesSetForContract_event

RoyaltiesRegistry_RoyaltiesSetForToken_event

RoyaltiesRegistry_setRoyaltiesByToken_function