> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# rarible_v1_polygon
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| gas | value | status | gas\_used | in\_direct | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 297354 | 0 | 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 | 0 | 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 | 0 | 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| gas | value | status | gas\_used | in\_direct | signature | to\_address | block\_number | from\_address | trace\_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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | in\_sigR | in\_sigS | in\_sigV | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | in\_userAddress | block\_timestamp | transaction\_hash | in\_functionSignature |
| ------ | ----- | ------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | -------- | --------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 272416 | 0 | true | 0x9f0411ecce9c9fa7bc1af90d81f3dce8ba6c87c1cf24b9cd47d0c535b8bc8bc3 | 0x5b4bd936db8e4e5cb1b2e558645a0f27498dba9cf130dbcb4d23e9a718d39a62 | 27 | 258482 | 0x | 0x0c53c51c | 0x12b3897a36fdb436dde2788c06eff0ffd997066e | 32612354 | 0x2d7813a2e158b1615599e98ece851b29ad30d9db | | 0x797bb4e297dd737c4fe9065b95cfb769b98f4f02 | 2022-09-02T21:25:42.000Z | 0x6a8ad9c7718829b508542e9e9e365a3c1eed5beb51595765b19c4703ea4c525d | 0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c000000000000000000000000044f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba0000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002008a598533fb30dcfafca41c5f628a0c4654024b1a7502460daa774c863289bdc60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000006973bb64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000400000000000000000000000002230e0c09289009478dd0b6e03d55f53fd3ba1ba44f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000068ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000424ace4669579986d200ebeb3c75924282324a42000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000415e7c18bcf7abffbbe9f506980eb30cb7212fa50c7a3ec141bb94f8a18314de59536c192c4b3cf928c4680e65819b7e150917e79b5e29ce78a65d7ad4ac7fcab11b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000797bb4e297dd737c4fe9065b95cfb769b98f4f02000000000000000000000000000000000000000000000000000000000000012000000000000000000000000044f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba00000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000058ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000005973bb64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000400000000000000000000000002230e0c09289009478dd0b6e03d55f53fd3ba1ba44f39daa6ceb49e5ef66f6b1cdf44bd88f0124ba00000000000000000000000200000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461 |
| 269168 | 0 | true | 0x5504d4906162f4c1968cd97327e366f269f9faa9e2c6b0c75365c576732fe0e3 | 0x2d681c914a89b3c015e85338793a8eaaa22b88bfff8a9e44a2072398354de634 | 27 | 255284 | 0x | 0x0c53c51c | 0x12b3897a36fdb436dde2788c06eff0ffd997066e | 32597482 | 0x860ea4f47bf3917549cf558b0173ee0898480afe | | 0xe7f36cbbe217edc72a827c6e52ebc651dbc7d8c8 | 2022-09-02T12:38:41.000Z | 0xa5c489f5d5e2293f1c4754138380bb6176ee2e210021bdec0508696690ed235b | 0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c0000000000000000000000000a339e00f18d677cc5b149224582e9ff7f2e058f00000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e0b315acc5f33449053a7a51a68fdaa175663b931596400001e951ab781d7c29780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000a8ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000a973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a2d9ded6115b7b7208459450d676f0127418ae7a48e2c8bbbe8a61d2fdd9af6d1ad1d480cfe5abad0000000000000000000000420000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000424ace4669579986d200ebeb3c75924282324a4200000000000000000000000000000000000000000000000000000000000000640000000000000000000000000000000000000000000000000000000000000041fabe2e5100297a310f98934829158980a9232f6ccb7a99099a2e516b29be4cd27491fe698346871b9685e5668fd5404d897e19d4fa77d72bd653b42145411b101c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000e7f36cbbe217edc72a827c6e52ebc651dbc7d8c80000000000000000000000000000000000000000000000000000000000000120000000000000000000000000a339e00f18d677cc5b149224582e9ff7f2e058f0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a2d9ded6115b7b7208459450d676f0127418ae7a48e2c8bbbe8a61d2fdd9af6d1ad1d480cfe5abad000000000000000000000042000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000018ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461 |
| 307063 | 0 | true | 0x691566ac18cb2f53a69bd04df7b86ba7c7dac44d598e0a6be401fccfb44512c5 | 0x1bbe5ea7275071bf312551b89b204135d45046bbb3d5ae6af5573e2afc52fd2e | 27 | 292587 | 0x | 0x0c53c51c | 0x12b3897a36fdb436dde2788c06eff0ffd997066e | 32595664 | 0x3587474523c5c8a352c558a2bb52732e1f851d5b | | 0xa7a62f32613686bd2f634498e46879fbeb3f7f0c | 2022-09-02T11:36:11.000Z | 0x78a48729b1a42dbc37346d690bd75be7fa1bc4d02297c0b02a765adbc6db0fbc | 0xe99a3f800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000046000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000008c00000000000000000000000003c5593af538b2278ebdcee385fdc5db94473daf00000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e04aed66014d68f1e178c26efeed70bd9714abe97b869193abe9cd9a5118a275c70000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000186a08ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000186a0973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000c218504fccd2a16c0f68dab9fd163fbe39678090c3ce6692bd4f0892e524b410fb9480dde0efa6ef0000000000000000000000950000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000424ace4669579986d200ebeb3c75924282324a42000000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000416ba8c7789d1c7023044a5d48809874d79ec4494b1de061a41636fe0c0bf27d786613e0ea77d1c20d1b78b87fa4aee2256fba091f0f14e83355312a825d529bf81c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000a7a62f32613686bd2f634498e46879fbeb3f7f0c00000000000000000000000000000000000000000000000000000000000001200000000000000000000000003c5593af538b2278ebdcee385fdc5db94473daf0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000023d235ef0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001973bb6400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000c218504fccd2a16c0f68dab9fd163fbe39678090c3ce6692bd4f0892e524b410fb9480dde0efa6ef000000000000000000000095000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000018ae85d8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000200000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec0000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000109616c6c64617461 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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, value STRING>, taker STRING, takeAsset STRUCT, 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, value STRING>, taker STRING, takeAsset STRUCT, 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. |
| gas | value | 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 | 0 | 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 | 0 | 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 | 0 | 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | in\_token | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ----- | ----- | ------ | --------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 41460 | 0 | true | 18140 | 0xa264c4f62937719b865e80fc76a6d6b86a880e35 | 0xfc73be00 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 32411234 | 0x8a1aa457b06ca13945ef5e7a39285efe5b38d3e8 | | 2022-08-28T11:22:15.000Z | 0x2331974603ada308975d1f2a3148056142d44a04192259b396bbd8834095ce66 |
| 20912 | 0 | true | 20738 | 0xa93dd827649712594421fca090bdda0fde7525d0 | 0xfc73be00 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 52590997 | 0x72e5de45588aa6597826c23eeff329778e35723b | | 2024-01-21T18:12:03.000Z | 0x02b26fe789625258fb76094328a3fc71fd250e5e4a2f0757655a5aa89a927ca4 |
| 41203 | 0 | true | 17972 | 0x9f096fa5ffe4247390740a4e89707dcc11c4cf1b | 0xfc73be00 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 47582483 | 0xdf3a37791a6d59e42dbcc6f53ab576493d031ac7 | | 2023-09-15T19:03:58.000Z | 0xecba65a3d9e5c02e3d39f6da536a66dc2063a06f4bc14a2594d367412f4aa9df |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | in\_token | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | in\_royaltiesType | transaction\_hash |
| -------- | ----- | ------ | --------- | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 28478416 | 0 | false | 17976 | | 0x36eff6c2 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 30776056 | 0x2fbcf8d541e4ad70989cb618908fabe5fd6656f8 | | 2022-07-16T05:11:52.000Z | | 0x2ce6c1d528021c9ce6f32ad295845709c9bc8756ef9da997a6e3b38aab8c005c |
| 28478428 | 0 | false | 17976 | | 0x36eff6c2 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 30776164 | 0x2fbcf8d541e4ad70989cb618908fabe5fd6656f8 | | 2022-07-16T05:17:44.000Z | | 0x856fed6e40d0d1ed0ac5efd2af027b38494120c807f0b60dbabeed1d4e6500a3 |
| 28478416 | 0 | false | 17976 | | 0x36eff6c2 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 30844287 | 0x2fbcf8d541e4ad70989cb618908fabe5fd6656f8 | | 2022-07-18T02:13:56.000Z | | 0x41822566830ffd1847586d5db1ef8545271f9b7ffb29c4e916831d6b54b39581 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | in\_token | out\_value | signature | in\_tokenId | to\_address | out\_account | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ------------------------------------------ | ---------- | ---------- | ----------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 100952 | 0 | true | 11338 | 0xe05b172278722b7009faf690508ae437e8ba2de2 | | 0x9ca7dc7a | 33742 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | | 54051072 | 0x12b3897a36fdb436dde2788c06eff0ffd997066e | 0,2 | 2024-02-28T08:16:37.000Z | 0x6734a6de10a2409779a7a29c411035dc0839f824b5f0c94146fc8a4c79c3a1da |
| 85740 | 0 | true | 11338 | 0xff0271135213197f76fd512621d0c98c25b8d69f | | 0x9ca7dc7a | 801 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | | 54038002 | 0x12b3897a36fdb436dde2788c06eff0ffd997066e | 0,1 | 2024-02-28T00:01:29.000Z | 0xe77d0468ea5156a950d667d9a4bb50bf6203dceb1b95a6b9021c245da0493a45 |
| 67769 | 0 | true | 11338 | 0x0ad52bfd0ddd09f581f0f790fe4f7369e9097712 | | 0x9ca7dc7a | 1144 | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | | 54051187 | 0x12b3897a36fdb436dde2788c06eff0ffd997066e | 0,1 | 2024-02-28T08:20:41.000Z | 0x9866b6a5161500a8fe8e543d57e9d809ccc0535f6cc28be2860113ba68af7b39 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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>` | 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%). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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>` | 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%). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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>` | 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%). |
| gas | value | status | gas\_used | in\_token | signature | to\_address | block\_number | from\_address | in\_royalties | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | --------------------------------------------------------------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 143971 | 0 | true | 141679 | 0x6de88a6cd1a865da2e97f225ec12d89b1527e440 | 0xacf14efb | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 64950315 | 0xa6c1673a727255e53a511e0be9ce51ddd56301d9 | \[\{"value":"1000","account":"0xa6c1673a727255e53a511e0be9ce51ddd56301d9"}] | | 2024-12-01T10:46:14.000Z | 0xdd13e745d56ca76466f35a9638e3e927b050fc469f5440578d008da0ef579e82 |
| 143959 | 0 | true | 141667 | 0xfa595d1bd8534f44a3cc5a412991a72841c33812 | 0xacf14efb | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 64948995 | 0xaef3bf86481d002d8e5b5bde5ee59e2966f61d18 | \[\{"value":"1000","account":"0xaef3bf86481d002d8e5b5bde5ee59e2966f61d18"}] | | 2024-12-01T09:58:58.000Z | 0x60dd7c7f55f73c94e2e83e21a42b9f332cdecb74ab70d594f8f33650172713f6 |
| 136375 | 0 | true | 134143 | 0x6be7edb641efd8c0110c107f563f3bad20e57c95 | 0xacf14efb | 0xf2514f32ae798ca29641f6e2313bacb1650cc76f | 71032924 | 0x87c329bffe5e5cdca30339fd50c68b46be222798 | \[\{"value":"1000","account":"0x87c329bffe5e5cdca30339fd50c68b46be222798"}] | | 2025-05-02T20:09:01.000Z | 0x47b9c17fd69125430ceab091bf91dd02019405690da2fed9f6db31ada9a0a966 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.rarible_v1_polygon.RoyaltiesRegistry_setRoyaltiesByToken_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***