rarible_v2_ethereum

Tables

ERC1155Sale_Buy_event

ERC-1155 (multi-token standard) purchase events from Rarible V2 marketplace on Ethereum, capturing buyer, seller, token ID, quantity, and payment token details for each NFT sale. Used for analyzing trading volume, price discovery, and marketplace activity across fungible and non-fungible tokens.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_buyer	in_owner	in_price	in_token	in_value	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x93f2a75d771628856f37f256da95e99ea28aafbe	false	0x1e7a0caf55ca0c650823cef5def9205055f20b04	0x7f59ae2adc2ce3e3c1a9c09680307fd5d785370a	10000000000000	0xd07dc4262bcdbf85190c01c996b4c06a461d2430	500	167	271	11085023	2020-10-19T07:13:58.000Z	0xd6cd49bc7b72d7abc51cff97b39e4b35bb9bf79fc9167961cc48bf159fc21204
0x93f2a75d771628856f37f256da95e99ea28aafbe	false	0x2f261a227480b7d1802433d05a92a27bab645032	0x8615593f2b34626e69f476ac418596ae08178f5e	10000000000000	0xd07dc4262bcdbf85190c01c996b4c06a461d2430	47	19	34248	11083178	2020-10-19T00:33:01.000Z	0x5c49fccca2bf9bc076c0f8d493d0521b681229894ab9a2f50a100eb6b979d99d
0x93f2a75d771628856f37f256da95e99ea28aafbe	false	0x9ef8c5ae4a320ef0984695af9a85d07f5be13792	0x2646de5603ec6b257f73d7857659261ff05bca2d	10000000000000	0xd07dc4262bcdbf85190c01c996b4c06a461d2430	1	191	44683	11083440	2020-10-19T01:34:40.000Z	0x67797f11d18ac88b82a1817e8c0d13b8555262558805a4fe98098d9ed66f65a5

Example Query

Query with partition filter

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

ERC1155Sale_buy_function

ERC-1155 (multi-token standard) purchase transactions on Rarible v2 marketplace on Ethereum, capturing buyer, seller, token ID, quantity, and price details with cryptographic signatures. Used for analyzing NFT sales activity, pricing trends, and marketplace volume for semi-fungible and fungible tokens.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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`	`INT64`	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.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_selling`	`STRING`	Quantity of ERC1155 tokens being sold by the owner in this transaction. Represented as a string-encoded integer, typically ranging from 1 to double-digit amounts based on the listing.
`in_buying`	`STRING`	Quantity of tokens being purchased by the buyer in this ERC-1155 sale transaction. String-encoded integer that is typically 1 for single NFT purchases but can be higher for fungible or semi-fungible tokens.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_sellerFee`	`STRING`	Seller fee amount for the ERC1155 sale transaction, denominated in wei. Typically zero based on sample data, but represents any percentage-based fee charged to the seller.
`in_signature`	`STRUCT<v INT64, r STRING, s STRING>`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.

Sample Data

gas	value	status	gas_used	in_owner	in_price	in_token	in_buying	signature	in_selling	in_tokenId	to_address	block_number	from_address	in_sellerFee	in_signature	block_timestamp	transaction_hash
266413	100000000000000000	false	121838					0xfd453a85			0x93f2a75d771628856f37f256da95e99ea28aafbe	10817940	0x7dfb612c4227a7f252e1631340416fab0f9081a4			2020-09-08T01:10:38.000Z	0x34a47eb88bef695a79031f668f67cef9f9b5cd5c5acbb4f76af32c5e4535f1f0
279491	425000000000000000	true	239083	0x5d18dffde59e681b76a9a712e14b328b4e8cf513	425000000000000000	0x5bbef39747422e21991f5c8dc7e8b0c938c9970a	1	0xfd453a85	1	1	0x93f2a75d771628856f37f256da95e99ea28aafbe	10821103	0x08dcc98f508127bf33c2a19ff59c0833594979e1	0	{“r”:“0x6d0d78ce7b92252e924d055096b28103cbb89a660feed1788192b47807a73144”,“s”:“0x405b61443d43fff60b8fe8a474955d5ea482467a764a4633ef5d18069e9b9798”,“v”:27}	2020-09-08T12:53:01.000Z	0x5251df8b46f6b76afbd57abde63bcd87f93b7dee60c15520ac5a3539e0caf118
249489	15800000000000000	true	226809	0xdbb5dc30131af014c81a849490917ed91adc43b1	7900000000000000	0x4d36e460f9fd391f115676d997e5187edcc8404f	2	0xfd453a85	10	10	0x93f2a75d771628856f37f256da95e99ea28aafbe	10818585	0xa2b3b5c4ab5f3d3afdd2f73352a852a6e8c4df65	0	{“r”:“0x9d809ff150c4c3c43000f50a44b9aeb848867b774c902b1f5c500ef1ac318f02”,“s”:“0x3734eaf246857fed98379c95e6d08aa61cf89975149e24d6a17ff789737930fa”,“v”:28}	2020-09-08T03:36:57.000Z	0xfbb02653f4fb642ce22230e65cc9f2f7a7375754226d100e35bd5773de04dca5

Example Query

Query with partition filter

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

ERC721Sale_Buy_event

ERC-721 (non-fungible token) purchase events from Rarible v2 marketplace on Ethereum, capturing buyer, seller, NFT contract addresses, token IDs, and sale prices. Used for analyzing NFT trading activity, price discovery, and marketplace volume on Rarible’s platform.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.

Sample Data

address	removed	in_buyer	in_nonce	in_price	in_token	in_seller	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x131aebbfe55bca0c9eaad4ea24d386c5c082dd58	false	0xa0ab186f4815f1fd190ae7a9f0702d5b6ec15966	1	400000000000000000	0x2de0050a91944a2d9db040aea23250ef9b55cd72	0x234bab2648ca50fe14b8495bf77a923585105b57	226	1	11193987	2020-11-05T00:32:41.000Z	0x76ad3a747adf4ee5b183104d3037017ad6336a4d4e70be2d446d78fbf6861750
0x131aebbfe55bca0c9eaad4ea24d386c5c082dd58	false	0x294f14e931455026896f2890a9c908801073e801	1	100000000000000000	0x4ff37da4042e81bd9ec2c0a0db48bf8976e10d23	0xa0ab186f4815f1fd190ae7a9f0702d5b6ec15966	238	4	11195558	2020-11-05T06:26:15.000Z	0xb04be66f0657a8911f67e93c673514d651c36778cf80d02a4e41fcafdfaffc5f
0x131aebbfe55bca0c9eaad4ea24d386c5c082dd58	false	0x8087682879a674775889ba3becd54e0951645dd3	1	150000000000000000	0x98fb982050b0177ce1a062f1c7bdebf068482697	0x234bab2648ca50fe14b8495bf77a923585105b57	319	4	11200051	2020-11-05T22:52:57.000Z	0x5d86a5f2561ae00119f5655d7620e0a8ec904a1c2966e7ed17f4f360b6d2f75b

Example Query

Query with partition filter

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

ERC721Sale_buy_function

ERC721 NFT purchase transactions on Rarible V2 marketplace for Ethereum, decoded from buy function calls including price, token ID, seller fee, and cryptographic signature data. Used for analyzing NFT sales activity, marketplace fees, and transaction success rates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	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.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_sellerFee`	`STRING`	Seller fee amount specified in the buy order for the ERC721 token purchase on Rarible v2. String-encoded wei value, typically ‘0’ or null for failed transactions.
`in_signature`	`STRUCT<v INT64, r STRING, s STRING>`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
329454	102500000000000000	false	125735	0xa4ddbaa6	0x131aebbfe55bca0c9eaad4ea24d386c5c082dd58	10969245	0x2fe50c88f228dacfc24100de0c5167aa7a539dc6	2020-10-01T09:02:47.000Z	0x1050a99a75376315bde75c7bc3f704bb32b6fa6f3bfa2f37f054bd3b3e067f34
306369	5125000000000000	false	124079	0xa4ddbaa6	0x131aebbfe55bca0c9eaad4ea24d386c5c082dd58	10969876	0xb440d55d052e42e69784b5a6ba250dd15b6afacb	2020-10-01T11:22:44.000Z	0xc5c47462201d12e158b5e10e8d7fe1a21db775e189efd0f316b0ad32ceceab1e
337938	51250000000000000	false	124907	0xa4ddbaa6	0x131aebbfe55bca0c9eaad4ea24d386c5c082dd58	10969757	0x6d03524dabfeee640f0e2011ea79285d1b3db200	2020-10-01T10:56:48.000Z	0xd16e56a2e87b5cac3396eadfa0e00cd63e9f04306dc9bf3fff152d394cde9ade

Example Query

Query with partition filter

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

ERC721Sale_setBuyerFee_function

Function call records for setting buyer fees on Rarible v2 ERC-721 sales contract on Ethereum. Used to track fee parameter changes and governance actions by contract administrators.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	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__buyerFee`	`STRING`	Fee amount charged to the buyer in basis points (1/100th of a percent), where 250 represents a 2.5% fee. This parameter is being set via the setBuyerFee function call on the Rarible ERC721Sale contract.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__buyerFee	trace_address	block_timestamp	transaction_hash
128796	0	true	21361	0xfa7da19d	0x131aebbfe55bca0c9eaad4ea24d386c5c082dd58	10911353	0x3482549fca7511267c9ef7089507c0f16ea1dcc1	250		2020-09-22T08:47:35.000Z	0xa35ac26a1011bd12d58aa2250710157a86bb67093338466849cde07209af482f

Example Query

Query with partition filter

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

ExchangeV2_directAcceptBid_function

Seller-accepted bid transactions from Rarible V2 NFT marketplace on Ethereum. Contains bid parameters, NFT identifiers, payment amounts in WETH, and execution status for analyzing direct bid acceptance patterns and NFT sale prices.

Columns

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

Sample Data

gas	status	gas_used	in_direct	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
284100	true	248371	{“bidEnd”:“1683398169”,“bidData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“bidSalt”:“29191825930194344785699772032996023023731031151073433152503608997156205982132”,“nftData”:“0x0000000000000000000000004513d68783c56d0e53b63d41dbfab94ce736a0520000000000000000000000000000000000000000000000000000000000000001”,“bidMaker”:“0xdc1c5a3d2173d6bcc0d6a62b7e94c00f88ddbae8”,“bidStart”:“0”,“bidDataType”:“0x23d235ef”,“bidNftAmount”:“2”,“bidSignature”:“0xe4f17e8817bf3aea8b617c4055a7238cbccab4df1996974b63e645974346a7585004ab4ba493542a25c10fa99d858649b56c839cc19dc02fa77ecbd672ca1b221c”,“paymentToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“nftAssetClass”:“0x973bb640”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“bidPaymentAmount”:“300000000000000”,“sellOrderNftAmount”:“1”,“sellOrderPaymentAmount”:“150000000000000”}	0x67d49a3b	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	16604071	0xb18e076d774be7f2ba806d76549d6e0d71daa2ff	2023-02-11T07:37:11.000Z	0x7415bb5128cdb34851e8ab205e1fc8ae709bc5066a9e9c848cb26219b60ff670
313547	true	263913	{“bidEnd”:“0”,“bidData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“bidSalt”:“101781230827730555776363927216164841104728707770237385007523715132768797967607”,“nftData”:“0x000000000000000000000000e03e4721c75188de6dd9ccf4fc0eb7c81399e305000000000000000000000000000000000000000000000000000000000000274b”,“bidMaker”:“0xd4cf19f76addb489d079d0f60f41d6e91e7c79e1”,“bidStart”:“0”,“bidDataType”:“0x23d235ef”,“bidNftAmount”:“1”,“bidSignature”:“0xbd533ad902f74411b350da1fe74f746136bf76cf82c8806f2980f6d4127196d940cf42efd2ed389b7a0c4b72084ba10035ff55eb6e88feea0ee0d95f5cf932ce1b”,“paymentToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“nftAssetClass”:“0x73ad2146”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“bidPaymentAmount”:“2888000000000000000”,“sellOrderNftAmount”:“1”,“sellOrderPaymentAmount”:“2888000000000000000”}	0x67d49a3b	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	17219462	0x4da48ac48b782a7c01e70065e4a51faf2c3f7b09	2023-05-09T00:54:35.000Z	0x843b281515cd9d6f8ffa1b935879d17e42b588faae5118759680b09fa1c8c17f
263113	true	247102	{“bidEnd”:“1709404717”,“bidData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“bidSalt”:“49679660861974371255145856258160208043708537630588759289626248486629157364043”,“nftData”:“0x0000000000000000000000000bde4ba965f8f21c6b359c0e0488deb0e921ada200000000000000000000000000000000000000000000000000000000000001cd”,“bidMaker”:“0x881c6c3e31c9920ca41e9feaf7e78e7f89f02c6b”,“bidStart”:“0”,“bidDataType”:“0x23d235ef”,“bidNftAmount”:“1”,“bidSignature”:“0x50a99bb096ccc0948839fd0ed01fb739a311d4590c69a96c98b797d20cf857b536b502b6b4e3e11c995db8a975333df4c75ecbab8e0cf15caaedfcc665ca9cb41b”,“paymentToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“nftAssetClass”:“0x973bb640”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“bidPaymentAmount”:“1000000000000000000”,“sellOrderNftAmount”:“1”,“sellOrderPaymentAmount”:“1000000000000000000”}	0x67d49a3b	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	19301421	0xd7895cb8390bc719d903515b801e67d0a4ae2171	2024-02-25T01:48:47.000Z	0x5250d7d551a9c576b4975627a078b79330913e83e6f81b5760cd7316a6bb02ce

Example Query

Query with partition filter

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

ExchangeV2_directPurchase_function

Direct purchase transaction records from Rarible’s ExchangeV2 contract on Ethereum, capturing buy-side NFT acquisitions with maker/taker addresses, payment amounts in ETH, and complete order metadata including signatures and asset class identifiers.

Columns

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

Sample Data

gas	value	status	gas_used	in_direct	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
462197	10100000000000000	true	402740	{“nftData”:“0x000000000000000000000000c9154424b823b10579895ccbe442d41b9abd96ed0000000000000000000000000000000000000000000000000000000000000040df15d086eb2154617c3cab9026ba1fdb3ce1e3b70000000000000000000000a700000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000000412f697066732f6261666b72656967776c62763766626b33686f766676726533693475366179616e75366175683362727a74617078366877637774366d6b65796179000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000df15d086eb2154617c3cab9026ba1fdb3ce1e3b700000000000000000000000000000000000000000000000000000000000027100000000000000000000000000000000000000000000000000000000000000001000000000000000000000000df15d086eb2154617c3cab9026ba1fdb3ce1e3b700000000000000000000000000000000000000000000000000000000000003e8000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000041e6c99fa164a8d5aac56b49e8b5d881b959ca40f86fb32c3192016f6b13085c105fa7aa19cc1c14ccd49bd67ab2938ad5752e28687b50d4a730095c88322154cb1b00000000000000000000000000000000000000000000000000000000000000”,“buyOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1685728626”,“nftAssetClass”:“0xd8f960c1”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“sellOrderSalt”:“70663541468718064948656561758210244392863488147071736463478637195904328021497”,“sellOrderMaker”:“0xdf15d086eb2154617c3cab9026ba1fdb3ce1e3b7”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“1”,“sellOrderSignature”:“0x31a63bbd1764a71ffec3280c6b00254e2d892aabf42f525cb84867ecc5c8268040328952e06a0cf755de55795cb67d7ffd1eccf070378c066520d68e6e35577d1c”,“buyOrderPaymentAmount”:“10000000000000000”,“sellOrderPaymentAmount”:“10000000000000000”}	0x0d5f7d35	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	16774993	0x214f84f54d5b5b926cf54b15dc04bb74c721be77	2023-03-07T07:38:47.000Z	0xdefe0991b9dcd739c8a00d46a8e23cc8d75c8e5a14d73fb2eab5a67f0b1a9a2b
482169	10100000000000000	true	419785	{“nftData”:“0x000000000000000000000000c9154424b823b10579895ccbe442d41b9abd96ed0000000000000000000000000000000000000000000000000000000000000040a23b0dfbcdd17825c04b6b2ae4abe80afed3044c00000000000000000000000300000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000000412f697066732f6261666b726569687966747936687477737a6b646678796e766a77696774646165736663737571767573366d613771726b6c676271797936776334000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000a23b0dfbcdd17825c04b6b2ae4abe80afed3044c00000000000000000000000000000000000000000000000000000000000027100000000000000000000000000000000000000000000000000000000000000001000000000000000000000000a23b0dfbcdd17825c04b6b2ae4abe80afed3044c000000000000000000000000000000000000000000000000000000000000138800000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004116140d834de8da9bfaa206280f588f3410f81a7a9d5be97b6cea5b2b08893d025f7c7943d25b995f2bac8dac068e56c59ee223093cbf3bd39286d5a373e984c41b00000000000000000000000000000000000000000000000000000000000000”,“buyOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“0”,“nftAssetClass”:“0xd8f960c1”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“sellOrderSalt”:“41669209711371856497163731054876415686342140327766520439776486881615521798241”,“sellOrderMaker”:“0xa23b0dfbcdd17825c04b6b2ae4abe80afed3044c”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“1”,“sellOrderSignature”:“0xbbd377ce7aab90d3706de2b2f64c8d8876934eb2253bbf3aa77ea02dc2cf2ff855f98fecf1cbb03193de961bc3ab5417b96fa4ec278babe9298388e816da19cd1c”,“buyOrderPaymentAmount”:“10000000000000000”,“sellOrderPaymentAmount”:“10000000000000000”}	0x0d5f7d35	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	16774174	0x2a565b45544df4864375be4b4008e5f8b6699bdf	2023-03-07T04:52:59.000Z	0xba88d803e0fad74c5c45215d5fa170ae03bfc37db62e7414f87f231f865b1bce
236144	101000000000000000	true	206382	{“nftData”:“0x000000000000000000000000e7afb4189603a901b74f8085f775931a60996166000000000000000000000000000000000000000000000000000000000000279e”,“buyOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1682347601”,“nftAssetClass”:“0x973bb640”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a0000000000000000000000000000000000000000000000000000000000000064”,“sellOrderSalt”:“91214971463500068758590600412253904443497403197841846572818679790990917031051”,“sellOrderMaker”:“0x15044bfec82b86dd58b39d2bd2012a1a464cd3cc”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“1”,“sellOrderSignature”:“0xdf576cf18531b5cc904dc5e54a8597ba601b7b73a3be9d2b77c61216236e81cd251e16664e2cf2d0354c87a48623d2a443c64973752d678f22397c8a6b4493a81b”,“buyOrderPaymentAmount”:“100000000000000000”,“sellOrderPaymentAmount”:“100000000000000000”}	0x0d5f7d35	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	16772964	0x818d56cae5042aa60437741966dd0e6fd997a4d7	2023-03-07T00:48:11.000Z	0x61fee56b5ccc27fdab3373958eb7a2b0c21b6084b7dc334342865709fb9d411f

Example Query

Query with partition filter

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

ExchangeV2_matchOrders_function

Trade execution records from Rarible’s ExchangeV2 contract on Ethereum, capturing matched orders between makers and takers with asset details, pricing, and cryptographic signatures. Contains both successful and failed NFT-for-ETH and NFT-for-ERC20 token swaps for analyzing marketplace trading activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_orderLeft`	`STRUCT<maker STRING, makeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, taker STRING, takeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, salt STRING, start STRING,` end `STRING, dataType STRING, data STRING>`	Order parameters submitted by the maker (left side) of the trade, including asset details, quantities, validity period, and maker/taker addresses. Null when transaction fails or is malformed.
`in_signatureLeft`	`STRING`	Cryptographic signature from the maker of the left order, validating their intent to execute the trade. Hex-encoded signature string, typically 132 characters (0x-prefixed), or 0x for unsigned orders filled by trusted addresses.
`in_orderRight`	`STRUCT<maker STRING, makeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, taker STRING, takeAsset STRUCT<assetType STRUCT<assetClass STRING, data STRING>, value STRING>, salt STRING, start STRING,` end `STRING, dataType STRING, data STRING>`	Structured order parameters for the taker (buyer) side of the Rarible V2 trade, including asset details, maker/taker addresses, and validity period. Null for failed transactions where order matching did not occur.
`in_signatureRight`	`STRING`	Cryptographic signature from the right-side order maker authorizing the trade execution. Empty (0x) when the right order is created on-chain during the transaction itself.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in_orderLeft	in_orderRight	block_timestamp	in_signatureLeft	transaction_hash	in_signatureRight
332114	327000000000000000	true	260537	0xe99a3f80	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	23010831	0xa6335939199c170d87c790b57e7c18aff6a7ce5e	{“end”:“1755971700”,“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a00000000000000000000000000000000000000000000000000000000000000e1”,“salt”:“40276506222773172050297638186863311246512691496686154897733188409894032135377”,“maker”:“0x0e7b3c814b3434e687a8c29bd0a09713f1879349”,“start”:“0”,“taker”:“0x0000000000000000000000000000000000000000”,“dataType”:“0x4ade54ca”,“makeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000e785e82358879f061bc3dcac6f0444462d4b533000000000000000000000000000000000000000000000000000000000000023e1”,“assetClass”:“0x73ad2146”}},“takeAsset”:{“value”:“327000000000000000”,“assetType”:{“data”:“0x”,“assetClass”:“0xaaaebeba”}}}	{“end”:“1755971700”,“data”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“salt”:“0”,“maker”:“0xa6335939199c170d87c790b57e7c18aff6a7ce5e”,“start”:“0”,“taker”:“0x0e7b3c814b3434e687a8c29bd0a09713f1879349”,“dataType”:“0x23d235ef”,“makeAsset”:{“value”:“327000000000000000”,“assetType”:{“data”:“0x”,“assetClass”:“0xaaaebeba”}},“takeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000e785e82358879f061bc3dcac6f0444462d4b533000000000000000000000000000000000000000000000000000000000000023e1”,“assetClass”:“0x73ad2146”}}}	2025-07-27T13:38:47.000Z	0x4170106ab1b41c6216394dc91bdb4dbc7e283a9c82bb9105d90a3fb6668e15c31e46abb0fc34d1b6bf34c21682e0b29820f483902e4cf30ae3392360940c61941b	0xcf42e0666b2d28b5db0ff446b4be79b611e790cd0db88445629f24290f1e5c40	0x
390616	1075000000000	true	244443	0xe99a3f80	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	23009637	0xea9e22bcc7b5bf9ddb8be295a815f923e04dc552	{“end”:“0”,“data”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a00000000000000000000000000000000000000000000000000000000000000fa”,“salt”:“35109911030589390370192494398829050998996131272655198166978955520832158674731”,“maker”:“0x15a4086ec9992b6645dad12208b1be994fabdd5d”,“start”:“0”,“taker”:“0x0000000000000000000000000000000000000000”,“dataType”:“0x4c234266”,“makeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000aa86c991f431a0cff8aba553b19268debb9b48a40000000000000000000000000000000000000000000000000000000000000a38”,“assetClass”:“0x73ad2146”}},“takeAsset”:{“value”:“1000000000000”,“assetType”:{“data”:“0x”,“assetClass”:“0xaaaebeba”}}}	{“end”:“0”,“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a00000000000000000000000000000000000000000000000000000000000002d5”,“salt”:“0”,“maker”:“0xea9e22bcc7b5bf9ddb8be295a815f923e04dc552”,“start”:“0”,“taker”:“0x15a4086ec9992b6645dad12208b1be994fabdd5d”,“dataType”:“0x4ade54ca”,“makeAsset”:{“value”:“1000000000000”,“assetType”:{“data”:“0x”,“assetClass”:“0xaaaebeba”}},“takeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000aa86c991f431a0cff8aba553b19268debb9b48a40000000000000000000000000000000000000000000000000000000000000a38”,“assetClass”:“0x73ad2146”}}}	2025-07-27T09:39:23.000Z	0x8f2bb2e969cadc43fd3c013640ea574473b9c863c0008610703d3441b52601a93b92e00c4d605f6b5ff5a5e3a989a8b1c6c08c6953751532dee55cf3480dce491c	0x148ad6d2657100c7e0e4e4000acd4933b130cacf72dd6924df68b046be6455d9	0x
394884	1075000000000	true	247243	0xe99a3f80	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	23009593	0xd656a78445decfe95e7e97da6a7b60d6c92935df	{“end”:“0”,“data”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a00000000000000000000000000000000000000000000000000000000000000fa”,“salt”:“102879354610540860590638757020853695500772978667275879099665816052328001496845”,“maker”:“0x15a4086ec9992b6645dad12208b1be994fabdd5d”,“start”:“0”,“taker”:“0x0000000000000000000000000000000000000000”,“dataType”:“0x4c234266”,“makeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000aa86c991f431a0cff8aba553b19268debb9b48a40000000000000000000000000000000000000000000000000000000000000a3c”,“assetClass”:“0x73ad2146”}},“takeAsset”:{“value”:“1000000000000”,“assetType”:{“data”:“0x”,“assetClass”:“0xaaaebeba”}}}	{“end”:“0”,“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001cf0df2a5a20cd61d68d4489eebbf85b8d39e18a00000000000000000000000000000000000000000000000000000000000002d5”,“salt”:“0”,“maker”:“0xd656a78445decfe95e7e97da6a7b60d6c92935df”,“start”:“0”,“taker”:“0x15a4086ec9992b6645dad12208b1be994fabdd5d”,“dataType”:“0x4ade54ca”,“makeAsset”:{“value”:“1000000000000”,“assetType”:{“data”:“0x”,“assetClass”:“0xaaaebeba”}},“takeAsset”:{“value”:“1”,“assetType”:{“data”:“0x000000000000000000000000aa86c991f431a0cff8aba553b19268debb9b48a40000000000000000000000000000000000000000000000000000000000000a3c”,“assetClass”:“0x73ad2146”}}}	2025-07-27T09:30:35.000Z	0xc7490764d9e7933ddcb8f5193075af179082f1a7118946d4da5e39326f7610a65a7d5db13fcee259e13fc464fa9710f582c2500ca96f29e76c776c017ca414ac1c	0x9a7dd6762af56585ab153db4c9a7735c7ec2bc6b01d94b749f21614b8e8bcfef	0x

Example Query

Query with partition filter

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

ExchangeV2_setRoyaltiesRegistry_function

Administrative function calls for updating Rarible’s royalty registry contract address on Ethereum. Used to track governance changes to the marketplace’s royalty payment infrastructure.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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`	`INT64`	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_newRoyaltiesRegistry`	`STRING`	Contract address of the new royalties registry being set in the Rarible V2 exchange. Hex-encoded, 0x-prefixed 40-character Ethereum address that will handle royalty distribution for NFT trades.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in_newRoyaltiesRegistry
178568	0	true	14990	0x3be89922	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	12662509	0x3482549fca7511267c9ef7089507c0f16ea1dcc1		2021-06-19T03:49:06.000Z	0x3aa0c019d28c88c20f81afea69dd3f536ef5480890f73f8f6d0a4dad58d53032	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd

Example Query

Query with partition filter

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

RariMineV3_claim_function

RARI token claim transactions from Rarible’s RariMine V3 mining contract on Ethereum. Contains signature-verified claims with recipient addresses and token amounts for tracking reward distributions and user participation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	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__balance`	`STRUCT<recipient STRING, value STRING>`	Token amount represented in smallest denomination. String-encoded integer value without decimal places.
`in_v`	`INT64`	ECDSA signature component v used for cryptographic verification of signed messages or permits. Integer value representing the recovery identifier, typically 27 or 28.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_s`	`STRING`	ECDSA signature component s used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.

Sample Data

gas	in_r	in_s	in_v	status	gas_used	signature	to_address	in__balance	block_number	from_address	block_timestamp	transaction_hash
901297	0x810d5154b4a98c76c83d1bd7d480f5d2ae680ad09dfea4b89c2307ed6dc6810a	0x153c0730fd474be4d82303e4090bf1dbe83a3a1db6ebccce591e414ec3f85f38	27	true	824797	0x0ecf28e9	0xc633f65a1bebd433df12d9f3ac7acf31b26ca1e6	39795032717651455115	20379944	0xb0a5f7a472ced766bb6249b8f1b4d45ece161d5d	2024-07-25T00:21:11.000Z	0x8d0d1d256d938580dc13b235abb73c638c803488feaa2c0c90a752d5a62ce890
901297	0x59f7c1438f71de88c5c88b85781247330465ee75e59c7d35cf4086d7748fb351	0x1ec3d32ebec8fb165370d25eacfcbc16a580c2df7c9d63f1f9992fbebf802d91	27	true	824797	0x0ecf28e9	0xc633f65a1bebd433df12d9f3ac7acf31b26ca1e6	118629385706012532909	20379928	0x862efb9333f39476425cfd39b9a6179ee21ad242	2024-07-25T00:17:59.000Z	0xd5dc67222b95858c5c64984da07a6a9d1cc887397e5489a87ba11481136c64ee
762428	0x5243cca4bf78ae71ef77da420da13d40b91242aa0516f64a3b710385059a0857	0x3b514895befde6bfe25d1b30088387cc8fb060f39b6f6c0b30f555d91b75e4ae	28	true	693315	0x0ecf28e9	0xc633f65a1bebd433df12d9f3ac7acf31b26ca1e6	1128437947652338766959	15977637	0xd543a0be0684f0556786586b83f4c9fd16a4dc35	2022-11-15T19:52:35.000Z	0x392a0592657189bb1fd5908097e6872ef63e658caa84fcc3be9728298cd027ef

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ERC1155Sale_Buy_event

ERC1155Sale_buy_function

ERC721Sale_Buy_event

ERC721Sale_buy_function

ERC721Sale_setBuyerFee_function

ExchangeV2_directAcceptBid_function

ExchangeV2_directPurchase_function

ExchangeV2_matchOrders_function

ExchangeV2_setRoyaltiesRegistry_function

RariMineV3_claim_function

​Tables

​ERC1155Sale_Buy_event

​ERC1155Sale_buy_function

​ERC721Sale_Buy_event

​ERC721Sale_buy_function

​ERC721Sale_setBuyerFee_function

​ExchangeV2_directAcceptBid_function

​ExchangeV2_directPurchase_function

​ExchangeV2_matchOrders_function

​ExchangeV2_setRoyaltiesRegistry_function

​RariMineV3_claim_function

Tables

ERC1155Sale_Buy_event

ERC1155Sale_buy_function

ERC721Sale_Buy_event

ERC721Sale_buy_function

ERC721Sale_setBuyerFee_function

ExchangeV2_directAcceptBid_function

ExchangeV2_directPurchase_function

ExchangeV2_matchOrders_function

ExchangeV2_setRoyaltiesRegistry_function

RariMineV3_claim_function