rarible_v1_ethereum

Tables

ERC1155Sale_Buy_event

ERC-1155 (multi-token standard) purchase events from Rarible’s v1 marketplace on Ethereum, capturing buyer and seller addresses, token contract, token ID, quantity, and price in wei. Used for tracking NFT and fungible token sales on the Rarible 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_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
0x8c530a698b6e83d562db09079bc458d4dad4e6c5	false	0xbf5c6d85510e491cd45d1264fffec0c2c4282564	0x2791de4ee53da7b499cf276d003637f0c3cf8a3e	25000000000000000	0xad3018b6c203174f9a84373fcf862300147ba5f6	15	52	1	10157001	2020-05-28T22:45:13.000Z	0x6f481f594df2696006979f5ba99bed13a74142b461dfe24c6729f5ace4c683c1
0x8c530a698b6e83d562db09079bc458d4dad4e6c5	false	0x885fcf666c73717895828a5f5c64a18bf81cc4d2	0x7535da202d79ca57299918c60c218f9b779aa14c	32100000000000000	0x9498e391ca49722988fc4da4d0d8c9c987ce8961	1	103	4	10156278	2020-05-28T20:07:36.000Z	0x9827a5423c21adfaba40956b809c97dc2cf4e511281d99e2f2e0581dc79a0486
0x8c530a698b6e83d562db09079bc458d4dad4e6c5	false	0x5a483c063b6b2b4f0baafbfe799a3504dd477dae	0x7535da202d79ca57299918c60c218f9b779aa14c	32100000000000000	0x9498e391ca49722988fc4da4d0d8c9c987ce8961	1	95	4	10156261	2020-05-28T20:04:25.000Z	0xa7cb8ed45fb541c5a6591a8e40a166fd4ec80e1704db2d959b2a81588e9bd391

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.rarible_v1_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 executed through Rarible’s v1 marketplace buy function on Ethereum. Contains signature-verified purchase details including token IDs, quantities bought and sold, and seller addresses for analyzing NFT 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`	`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_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 ERC-1155 tokens being sold by the owner in this buy transaction. Numeric string value typically ranging from 1 to 25 in sample data.
`in_buying`	`STRING`	Quantity of tokens being purchased in this ERC-1155 buy transaction. Typically set to 1 for single-edition NFT sales, as seen in sample transactions.
`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	value	status	gas_used	in_owner	in_token	in_buying	signature	in_selling	in_tokenId	to_address	block_number	from_address	block_timestamp	transaction_hash
200710	0x1c85af4dacaf0c586b60dc8fe66ce243129316339c6e71d916af6aa1ee88da0b	0x677acd0606f97db3c3f5e07dac50b9da1969590a4c6f4cad099684164c092a9e	28	10000000000000000	true	180338	0x44e9d011df8741be2493e99297e9ad67bb1aa85b	0x60d92741bf44a4a7c240bbad29e328ff74232268	1	0x16df6f92	5	5	0x8c530a698b6e83d562db09079bc458d4dad4e6c5	10254276	0x02404a0eee532466174096d57f5d3739dbd6439a	2020-06-13T01:05:14.000Z	0x636c0608f3189274c2edcb02e52e75515d206a9a26291e9f6f62a55b1cdce215
186031	0x951b3c1b6abd3fe15eb5cd46cf7d9f4068668a44eee0827307c2598fb40f532f	0x1f53b1dd467f4365d47dd3400e02ca849a9d1b7ae01c36175b55a306cbed64ab	28	10000000000000000	true	166994	0x44e9d011df8741be2493e99297e9ad67bb1aa85b	0xd07dc4262bcdbf85190c01c996b4c06a461d2430	1	0x16df6f92	7	212	0x8c530a698b6e83d562db09079bc458d4dad4e6c5	10254683	0x49e5c693dc0cc586b6e29e2404b17dc0565ac12b	2020-06-13T02:33:40.000Z	0x9244bd817ca17e8a0307c80f8ba566d887f59c823a1a273db31d0857b23b248d
202531	0x951b3c1b6abd3fe15eb5cd46cf7d9f4068668a44eee0827307c2598fb40f532f	0x1f53b1dd467f4365d47dd3400e02ca849a9d1b7ae01c36175b55a306cbed64ab	28	10000000000000000	true	181994	0x44e9d011df8741be2493e99297e9ad67bb1aa85b	0xd07dc4262bcdbf85190c01c996b4c06a461d2430	1	0x16df6f92	7	212	0x8c530a698b6e83d562db09079bc458d4dad4e6c5	10254659	0xa13e1b3e5959378df847fce2161cee55df64cc1f	2020-06-13T02:29:13.000Z	0x91d1f366f14e9c5f8c22498b77e854f1d29e819951d82dca05491ed9a9a54af9

Example Query

Query with partition filter

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

ERC721Sale_Buy_event

NFT (ERC-721) purchase events from Rarible V1 marketplace on Ethereum, capturing buyer, seller, token contract, token ID, and sale price. Used for analyzing secondary market trading volume, price discovery, and marketplace activity patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xa5af48b105ddf2fa73cbaac61d420ea31b3c2a07	false	0x8087682879a674775889ba3becd54e0951645dd3	1	150000000000000000	0x6e5322ee2ae9ac0f90e979b8aced243a2ea8722d	0x96d80fdec427117b5bed01bd24fb3c960487e872	184	5	10771386	2020-08-31T22:06:09.000Z	0x627e66aab5e28f9a2f4f00ffc53fc9133fd5cfdd1f8f3e4e529df64889df2af2
0xa5af48b105ddf2fa73cbaac61d420ea31b3c2a07	false	0x349dda24ef1a4228d7d328ebaddd8d39eab9ded8	1	1000000000000000000	0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85	0xa16ce88f9f702d390244ce016f9416b23c9c3027	272	111980825324423721154318462032513773334546192423318884375839792072342958411770	10766192	2020-08-31T03:14:46.000Z	0xb524b7f3b670861c8c7f4c733fb61ce48e61eb6a0bbaf959cc32b92841df86d7
0xa5af48b105ddf2fa73cbaac61d420ea31b3c2a07	false	0x349dda24ef1a4228d7d328ebaddd8d39eab9ded8	1	1500000000000000000	0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85	0xa16ce88f9f702d390244ce016f9416b23c9c3027	189	4178884961700107536676833937510049707028031097043456315333790467805145325427	10766188	2020-08-31T03:14:01.000Z	0x444ae7635d77439e52d89b2838c284bef5a48710dd099fc546688a7765c26d14

Example Query

Query with partition filter

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

ERC721Sale_buy_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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`	-
`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

No sample data available.

Example Query

Query with partition filter

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

ExchangeV1_Buy_event

NFT purchase events from Rarible’s V1 exchange contract on Ethereum, capturing buyer/seller addresses, token contracts, token IDs, and payment amounts in wei for secondary market transactions.

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_sellToken`	`STRING`	Contract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellTokenId`	`STRING`	Token ID of the NFT being sold in this Rarible V1 exchange transaction. Numeric identifier for the specific token within the collection specified by in_sellToken.
`in_sellValue`	`STRING`	Quantity or amount of the token being sold in the trade. Denominated in the smallest unit (wei for ETH, base units for ERC-20/721), typically ‘1’ for NFT sales.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyToken`	`STRING`	Contract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyTokenId`	`STRING`	Token ID of the asset being purchased by the buyer in the trade. For ERC-721 or ERC-1155 NFTs this is the specific token ID, while for fungible tokens (ERC-20) this is typically ‘0’.
`in_buyValue`	`STRING`	Payment amount in wei offered by the buyer for the NFT purchase. Typically 0 for free mints or contains wei-denominated values for paid transactions.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_salt`	`STRING`	Cryptographic salt value used for deterministic address generation in contract deployment. 66-character hex string including 0x prefix.

Sample Data

address	in_salt	removed	in_buyer	in_owner	in_amount	log_index	in_buyToken	in_buyValue	block_number	in_sellToken	in_sellValue	in_sellTokenId	block_timestamp	transaction_hash
0xcd4ec7b66fbc029c116ba9ffb3e59351c20b5b06	21046531482527411392479556161956721600049047336372198871362857060949022290066	false	0xb9d5c0e084661813d1e2e6ce9c2df2ffe4b4e092	0xe18118e32bf6879cdacddeb737629c98dba72f7e	1	243	0x0000000000000000000000000000000000000000	0	12246611	0x60f80121c31a0d46b5279700f9df786054aa5ee5	1	270000	2021-04-15T19:30:39.000Z	0x68c2fdc8ced071e5e861b2f70760ef7d48318f12502a7d4129036b835d85f8cf
0xcd4ec7b66fbc029c116ba9ffb3e59351c20b5b06	88245721306524848582769409396750471414006192699178762209256006179611531943261	false	0x1edb613d82a6f2558460d58c8992ac42f71434d8	0xaddaf99990b665d8553f08653966fa8995cc1209	1	304	0x0000000000000000000000000000000000000000	100000000000000	12242581	0x60f80121c31a0d46b5279700f9df786054aa5ee5	1	34172	2021-04-15T04:43:23.000Z	0xc422310436be0681e405da75d43eb45e283ecea5deb388a605ad06c0b7b35b37
0xcd4ec7b66fbc029c116ba9ffb3e59351c20b5b06	40319358654748434009144424772549785249585103011586719301768396306862510645756	false	0x6440350e4adb24c82874e6a34505425f8b66db80	0xa90f75194a3e86a899ff64d57102fec949523e59	1	116	0x0000000000000000000000000000000000000000	850000000000000	12242239	0xd07dc4262bcdbf85190c01c996b4c06a461d2430	1	107160	2021-04-15T03:29:00.000Z	0x6981c8fa0dfcaa435c67adb975e548ff565610cb9d4b519ebb146d37c1669f39

Example Query

Query with partition filter

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

ExchangeV1_exchange_function

NFT purchase transactions from Rarible V1 exchange contract on Ethereum. Contains order details, buyer/seller addresses, token transfers, signatures, and fee data 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_order`	`STRUCT<key STRUCT<owner STRING, salt STRING, sellAsset STRUCT<token STRING, tokenId STRING, assetType INT64>, buyAsset STRUCT<token STRING, tokenId STRING, assetType INT64>>, selling STRING, buying STRING, sellerFee STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_sig`	`STRUCT<v INT64, r STRING, s STRING>`	ECDSA signature authorizing the transaction or order. Structure containing v (recovery identifier), r (first 32 bytes of signature), and s (second 32 bytes of signature) components.
`in_buyerFee`	`STRING`	Buyer fee amount denominated in basis points (250 = 2.5%). Typically set to 250 across successful transactions in this dataset.
`in_buyerFeeSig`	`STRUCT<v INT64, r STRING, s STRING>`	Cryptographic signature (v, r, s components) authorizing the buyer’s fee payment for the exchange transaction. Null when transactions fail or when buyer fee signatures are not required.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	value	in_sig	status	gas_used	in_buyer	in_order	in_amount	signature	to_address	in_buyerFee	block_number	from_address	in_buyerFeeSig	block_timestamp	transaction_hash
334262	0		false	129486				0x9cec6392	0xcd4ec7b66fbc029c116ba9ffb3e59351c20b5b06		11684161	0x48f3451456c77935e2b2f7c1947e84d6acc14b2d		2021-01-19T06:39:45.000Z	0x69b2333da35f4dc9f555c80d8703aa4989268fe148885a352d858c6fb8309fdd
265665	41000000000000000		false	129150				0x9cec6392	0xcd4ec7b66fbc029c116ba9ffb3e59351c20b5b06		11687592	0xa3f1f13928516252eb800c4ae43a118c379c5e31		2021-01-19T19:14:45.000Z	0x535ea1a4df1e901cd6b967f2e990a3bbf41e79e5d7c8247e486785f76b2eaa76
401307	0	{“r”:“0x0de2f0a39d02ef4112b97c29141e36f421d32e9313346ccc4f6979ac0be4edcd”,“s”:“0x0e53deecea4202224f04b3c1673eedade4234ed238974d80b14a0cce760692da”,“v”:28}	true	352198	0x0000000000000000000000000000000000000000	{“key”:{“salt”:“53991772698251461497376882753477326114711981629275124113685018248371477237127”,“owner”:“0xc619ed6ec6cda75fa470947c1e8377f40044f9a8”,“buyAsset”:{“token”:“0x60f80121c31a0d46b5279700f9df786054aa5ee5”,“tokenId”:“99637”,“assetType”:3},“sellAsset”:{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“tokenId”:“0”,“assetType”:1}},“buying”:“1”,“selling”:“90000000000000000”,“sellerFee”:“250”}	90000000000000000	0x9cec6392	0xcd4ec7b66fbc029c116ba9ffb3e59351c20b5b06	250	11688624	0x602669a0ad80d60e4f48c5f3d40cbb80511c2c35	{“r”:“0xb459dfd8094d21a660eee34c5cfa8f83412cd8aef325e430e78374f9d620d28b”,“s”:“0x6db79f8f0b181a143aa087dca542d4fa7adb8a7e3cbe978fbab9a80b7910fc9c”,“v”:28}	2021-01-19T23:00:48.000Z	0x4c6be484258de44193227f9408b89dfee938c81e17a86825bc06b788d6e58aec

Example Query

Query with partition filter

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

ExchangeV12_exchange_function

Order execution events from Rarible’s ExchangeV12 contract on Ethereum. Contains matched buy/sell orders with asset details, prices, fees, and cryptographic signatures for analyzing NFT 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_order`	`STRUCT<key STRUCT<owner STRING, salt STRING, sellAsset STRUCT<token STRING, tokenId STRING, assetType INT64>, buyAsset STRUCT<token STRING, tokenId STRING, assetType INT64>>, selling STRING, buying STRING, sellerFee STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_sig`	`STRUCT<v INT64, r STRING, s STRING>`	ECDSA signature authorizing the transaction or order. Structure containing v (recovery identifier), r (first 32 bytes of signature), and s (second 32 bytes of signature) components.
`in_buyerFee`	`STRING`	Fee amount paid by the buyer on this exchange transaction, denominated in the smallest unit of the payment token. Typically zero in these sample transactions, indicating no additional buyer fee beyond the transaction value.
`in_buyerFeeSig`	`STRUCT<v INT64, r STRING, s STRING>`	Cryptographic signature (v, r, s) authorizing the buyer’s fee structure for the exchange transaction. Contains ECDSA signature components used to verify the buyer agreed to the specified fee terms.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	value	in_sig	status	gas_used	in_buyer	in_order	in_amount	signature	to_address	block_number	from_address	in_buyerFeeSig	block_timestamp	transaction_hash
288732	240000000000000000	{“r”:“0x9f215fcc34b541153f85050ed7ecd5daec401493761d0d2728ad93ab12119def”,“s”:“0x47b44e92ceeb302c3591a743c4eb4d04b88104f6c9600d220a3822fe13794289”,“v”:28}	true	274983	0x0000000000000000000000000000000000000000	{“key”:{“salt”:“5915435121904810134803668865222226050620419351468914934599720756378076459976”,“owner”:“0xd4cf19f76addb489d079d0f60f41d6e91e7c79e1”,“buyAsset”:{“token”:“0x0000000000000000000000000000000000000000”,“tokenId”:“0”,“assetType”:0},“sellAsset”:{“token”:“0x34037a293ffb6e29057ea7f36a453a39dccd130a”,“tokenId”:“8”,“assetType”:2}},“buying”:“240000000000000000”,“selling”:“1”,“sellerFee”:“250”}	1	0x9cec6392	0x09eab21c40743b2364b94345419138ef80f39e30	14188805	0x4959ad9145030d5a2f3cce66ca4da8b3d35dbe1d	{“r”:“0x9d3431cad0bc95e1e65fac06c3897ddb811b7ed9dd832b1bbbaa24b07a1cb1be”,“s”:“0x23b94f669de5e4e68a299394a5241997e862c6ffd49d18d117e6c92fcc42b57b”,“v”:27}	2022-02-12T03:24:12.000Z	0xa397a51317b8369ab1876b772d62f5d0e1df1983f7326a8ab5f18f61d5d2a0f1
288707	50000000000000000	{“r”:“0xbb4e75c1ea005631a8128c9c57753e5fe6a3df6621276dfb81271a2dc8b9eb19”,“s”:“0x7084192987562f12cb7175ab39bef7a2d12712ac226e1181e3e1a98fa36cae4f”,“v”:28}	true	270159	0x0000000000000000000000000000000000000000	{“key”:{“salt”:“3171446497220830084787012283433107096239362411875655716098341086491688328223”,“owner”:“0x2a254c18f8e1794b05bea298ae27126df160b9e0”,“buyAsset”:{“token”:“0x0000000000000000000000000000000000000000”,“tokenId”:“0”,“assetType”:0},“sellAsset”:{“token”:“0x416676c3c0be210b9b041f1906617ad5c57ab8db”,“tokenId”:“11”,“assetType”:2}},“buying”:“50000000000000000”,“selling”:“1”,“sellerFee”:“250”}	1	0x9cec6392	0x09eab21c40743b2364b94345419138ef80f39e30	14191962	0x8da471bcd4d3ada08e6572b63cb05752dc1d2e70	{“r”:“0xafb1f2cbcea2e6461a99669565a2b71f93a3e288f268bf872552050c78ba5dbd”,“s”:“0x1a5656fe0f58abd2fd0893a5301471e2a503e6196da30bf0a2188f20ff691552”,“v”:28}	2022-02-12T15:03:59.000Z	0xc575c897d9a7e6593653d022427077d10012d294677f90a0af00cbafc11af20a
288757	100000000000000000	{“r”:“0x79fa16a2c3ff8f8062db1fce6bd53bcb35ba744ae91e98801266838f9785a1db”,“s”:“0x425a881a17cd37c2470d777a95dfdde0a802f3fa4574abf91f3b2c305a78f3c2”,“v”:28}	true	270207	0x0000000000000000000000000000000000000000	{“key”:{“salt”:“38610893003991426617325771119918877590949576388455941186428662005422972063094”,“owner”:“0x36ed2d75a82e180e0871456b15c239b73b4ee9f4”,“buyAsset”:{“token”:“0x0000000000000000000000000000000000000000”,“tokenId”:“0”,“assetType”:0},“sellAsset”:{“token”:“0xd07dc4262bcdbf85190c01c996b4c06a461d2430”,“tokenId”:“586352”,“assetType”:2}},“buying”:“100000000000000000”,“selling”:“1”,“sellerFee”:“250”}	1	0x9cec6392	0x09eab21c40743b2364b94345419138ef80f39e30	14194417	0xd1978e0339cae8074a99038827bb8d8e83411f47	{“r”:“0xa9e53e01c34c4c43e8c99016e6ab68259b5121fb6a192b2218d9fafe7baa9576”,“s”:“0x2e823c18522a44d15ba29f2856acd9262032d45d81557e91e7167c8f844250fe”,“v”:28}	2022-02-12T23:59:57.000Z	0x231a2a9931a6e677c270271cb35ad83cff061133ff1112693d666b31ab6f0cd4

Example Query

Query with partition filter

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

RariMineV2_Claim_event

RARI token claim events from Rarible’s liquidity mining program (RariMine V2) on Ethereum. Records user reward claims with wallet addresses and token amounts (in wei) for tracking mining incentive distributions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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_owner	in_value	log_index	block_number	block_timestamp	transaction_hash
0x3b5d2b254224954547a33cbf753bcaa5eb4b27bd	false	0x5e049c452dca0f1991c3b8c6eb38a5ac472eeaa3	10614271899430184600	300	12264651	2021-04-18T14:38:13.000Z	0xeaedf8242e9679fc42b775c673e111bdfae73c4be96e2c7c85a2521b97f0cd68
0x3b5d2b254224954547a33cbf753bcaa5eb4b27bd	false	0x3add9ad2e60993590cb28ce8fc6526aecfc477ab	311273187674611530000	60	12264460	2021-04-18T13:58:11.000Z	0x155b0e61eed7cfe628cf94e243f236db7e8d2710a0245bb6482e2c43982f4680
0x3b5d2b254224954547a33cbf753bcaa5eb4b27bd	false	0x025883a8bd530185a30178262fceb0d49fc73a15	11383215227165510000	329	12264009	2021-04-18T12:12:28.000Z	0x63d32ddb78a92b89be19c7308f6668be6de38db321981643877f8576c16f401b

Example Query

Query with partition filter

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

RoyaltyRegistry_getRoyalties_function

Function call records querying royalty information from Rarible’s RoyaltyRegistry contract on Ethereum. Returns royalty recipient addresses and basis points (out_value in hundredths of a percent) for specific NFT token contracts and token IDs.

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.
`out_account`	`STRING`	Wallet address that receives royalty payments for the specified NFT. Null when no royalty configuration exists for the token.
`out_value`	`STRING`	Royalty basis points value returned by the registry for this token, typically expressed as a percentage multiplied by 100 (e.g., 500 = 5%). Null when no royalty is configured for the queried token.

Sample Data

gas	status	gas_used	in_token	out_value	signature	in_tokenId	to_address	out_account	block_number	from_address	trace_address	block_timestamp	transaction_hash
111301	true	11338	0x495f947276749ce646f68ac8c248420045cb7b5e		0x9ca7dc7a	75733154005079120383632397234206525845042763156816277186221271618082758983681	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd		16727286	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	0,1	2023-02-28T14:35:23.000Z	0x33c23698fb8f756ab1c36627fe4db08898286af25bc9a301669e563a7f5f18e4
128693	true	11338	0x7037843d739d846cdce3a6839a80f7d70b60b99a		0x9ca7dc7a	367	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd		16728276	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	0,1	2023-02-28T17:55:35.000Z	0x883962a4bbc89bc56a526b3fe7f209fea1b790f381624aee1e684b081fb79a84
141121	true	27198	0xb66a603f4cfe17e3d27b87a8bfcad319856518b8	1000	0x9ca7dc7a	76710954621293814021517577192663515291415149369826023063624470505901638287365	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	0xa998dc971066afa8777d040f1ecf25c636e4e993	16726433	0x9757f2d2b135150bbeb65308d4a91804107cd8d6	0,1	2023-02-28T11:42:59.000Z	0xed1288c03a4386e32235a9bd80ac66aec7af76ed8780879ce072a4c8793e837d

Example Query

Query with partition filter

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

RoyaltyRegistry_OwnershipTransferred_event

Ownership transfer events from the Rarible v1 Royalty Registry contract on Ethereum, tracking changes in contract administrative control. Records previous and new owner addresses for analyzing protocol governance transitions and contract custody history.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	43	0x20b9049c69dea7e5d46de82ce0b33a9d5a8a0893	14936622	2022-06-10T04:59:17.000Z	0x3482549fca7511267c9ef7089507c0f16ea1dcc1	0x2c309885b9446977ec3c2e030c4cc0e8668209e4a9dccb46837bbfa2b4e87be0
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	188	0x3482549fca7511267c9ef7089507c0f16ea1dcc1	12662496	2021-06-19T03:46:34.000Z	0x0000000000000000000000000000000000000000	0x213517a4e902c10f4bacd04b7bcb68eac590d30f8bbed50f37aac8f664de8774
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	111	0x256effcea2ab308d31e318728d2615545171d85b	19020562	2024-01-16T16:11:23.000Z	0x20b9049c69dea7e5d46de82ce0b33a9d5a8a0893	0x3d821da54c07cc027f3b6bd711256f28fe1b146937b1e86d1407341c737a5b27

Example Query

Query with partition filter

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

RoyaltyRegistry_RoyaltiesSetForContract_event

Royalty configuration events from Rarible’s RoyaltyRegistry contract on Ethereum, capturing when royalty recipients and basis points (e.g., 500 = 5%, 1000 = 10%) are set for NFT collections. Used for tracking creator royalty settings across Rarible marketplace integrations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_royalties`	`ARRAY<STRUCT<account STRING, value STRING>>`	Array of royalty recipients and their corresponding basis point values. Each struct contains an account address (hex-encoded, 0x-prefixed, 42-character string) and a value (numeric string representing basis points, where 500 = 5%).

Sample Data

address	removed	in_token	log_index	block_number	in_royalties	block_timestamp	transaction_hash
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	0x851d37439e95f9aa56349e0dd9867b17c7913eb5	108	15246446	[{“value”:“500”,“account”:“0x5d6cb52bb22b515b58f4785d31ebb327f0a5a99a”}]	2022-07-30T22:21:25.000Z	0x2ceac22e497ecf3283cdc49e9afcf22b935dae777282a678c95f47aeee9d078c
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	0xfa577bd8084746899cd60b19b7c15047c95d818a	409	15241259	[{“value”:“500”,“account”:“0x17ef96045d1d08c3d9f9e40b50d3f6962f63e9b4”}]	2022-07-30T02:51:05.000Z	0x9c0cc8222c28d1d32bc6c8f3a1774242c5c7d00589df57306f7a0673f1e50628
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	0xb2481691b251bcddd5201ad03684c2487b0f03f7	305	15244448	[{“value”:“500”,“account”:“0xb30077c4bdb0e23001c4b9297e231201bada49e4”}]	2022-07-30T14:56:13.000Z	0x1875179b16ef24c2582535b7303c66f00b210370f3e8d8678ed6877469f973fe

Example Query

Query with partition filter

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

RoyaltyRegistry_RoyaltiesSetForToken_event

Royalty configuration events from Rarible’s RoyaltyRegistry contract on Ethereum, capturing when royalty payments are set or updated for specific NFT (Non-Fungible Token) tokens. Records include token contract addresses, token IDs, and recipient account details with royalty basis points (e.g., 2000 = 20%).

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_royalties`	`ARRAY<STRUCT<account STRING, value STRING>>`	Array of royalty recipients and their corresponding basis point values. Each struct contains an account address (hex-encoded, 0x-prefixed, 42-character string) and a value (numeric string representing basis points, where 500 = 5%).

Sample Data

address	removed	in_token	log_index	in_tokenId	block_number	in_royalties	block_timestamp	transaction_hash
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	0x1906fd9c4ac440561f7197da0a4bd2e88df5fa70	113	13567	13441354	[]	2021-10-18T10:43:12.000Z	0xf3fceef1b166ff889917575d7c8244d971cf1424b60763c5b2ce074973c9d6d0
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	0x2597e7ede4cc1e38d50eec42a8a7896b67f7c1c6	544	22	13443167	[{“value”:“2000”,“account”:“0xabc0e3faee254dc26c44724e40be2208f2aa8c20”}]	2021-10-18T17:33:59.000Z	0x58b47dac549a8067b3506c67611e8b832fa3987e7adf2aa333086a440cccdf40
0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	false	0x2597e7ede4cc1e38d50eec42a8a7896b67f7c1c6	76	20	13439264	[{“value”:“2000”,“account”:“0xabc0e3faee254dc26c44724e40be2208f2aa8c20”}]	2021-10-18T02:50:40.000Z	0xaacc95481e0a8e0138e20fa078915e21ad68b2d7e253e7c67a003bab807bc074

Example Query

Query with partition filter

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

RoyaltyRegistry_setProviderByToken_function

Function calls to Rarible’s RoyaltyRegistry contract on Ethereum that assign royalty provider addresses to specific NFT token contracts. Used for tracking royalty configuration changes and analyzing which contracts use custom versus default royalty implementations.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	in_token	signature	to_address	in_provider	block_number	from_address	trace_address	block_timestamp	transaction_hash
78212	true	32314	0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270	0xd836f013	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	0xeeacb62bd98c7a8982213ff40001d9cc6f46b1d1	13169942	0x3482549fca7511267c9ef7089507c0f16ea1dcc1		2021-09-06T04:00:38.000Z	0x727376c49b683c69741b8e1a5c7997c6952e7703959a1c6b906df2b0b0f42050
78212	true	32314	0x059edd72cd353df5106d2b9cc5ab83a52287ac3a	0xd836f013	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	0xeeacb62bd98c7a8982213ff40001d9cc6f46b1d1	13169941	0x3482549fca7511267c9ef7089507c0f16ea1dcc1		2021-09-06T04:00:06.000Z	0x8333d6db5c7ef093aaa2ce11ad28cca62134f88008abd74359ddba81eddbf6a8
185411	true	34500	0xa8a2199faeed5ba2b095bea00f247cba10491b5f	0xd836f013	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	0xa8a2199faeed5ba2b095bea00f247cba10491b5f	14316440	0xa8a2199faeed5ba2b095bea00f247cba10491b5f	1,1,1,0,1,1,1,2	2022-03-03T21:26:50.000Z	0x071e4ced30ace5bc405194dcdd52d668a6c64c963b59609c4dd45cb6d4340e04

Example Query

Query with partition filter

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

RoyaltyRegistry_setRoyaltiesByToken_function

Function calls to set royalty configurations for NFT collections on Rarible’s Ethereum RoyaltyRegistry contract, specifying recipient addresses and basis point percentages (e.g., 500 = 5%) per token contract.

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

Sample Data

gas	status	gas_used	in_token	signature	to_address	block_number	from_address	in_royalties	block_timestamp	transaction_hash
133086	true	131507	0xbbf77093aef4273fea61f8bf54d6dedeecfef2d5	0xacf14efb	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	23246951	0x73395dd2954333fe546414679b931fb08c84ae81	[{“value”:“500”,“account”:“0x0fa26f8f0ade715a708aad527384dd3f5d95fa86”}]	2025-08-29T13:02:23.000Z	0x9e86bbd08a61af5d0b7bb8e57303d17dec2e0e9372148049059d4144d22eec5c
64115	true	55213	0xbcbcc7cbf50344ed4445512b30897d6bad76f166	0xacf14efb	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	15258711	0x5e1d54ecebffcf57867db510e7fc55a610f952af	[{“value”:“750”,“account”:“0x7e58b9f29dff41b61f46dc187c42cf060f33e890”}]	2022-08-01T20:03:53.000Z	0x482c3ef8a03d953389ee1f697b36750938dfce5a38398b091a3cdb400308a024
66527	true	57587	0x0fd1006fc15b1128514cfc9f25b16b6c9ee4fc80	0xacf14efb	0xea90cfad1b8e030b8fd3e63d22074e0aeb8e0dcd	15256506	0xe38fc29c65f4fba223e03ebbc7562f59c7bc0825	[{“value”:“750”,“account”:“0xc01b5df75d0567c96666a3939ef2c5472b2d8256”}]	2022-08-01T11:55:28.000Z	0xf8318975067c065ab121b17b1efe6abf9161b1ba7edaa70344c9562cb594d0c8

Example Query

Query with partition filter

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

TokenSale_Buy_event

NFT purchase events from Rarible v1 marketplace on Ethereum. Records buyer, seller, token ID, and price in wei for each completed sale transaction.

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
0xf2ee97405593bc7b6275682b0331169a48fedec7	false	0xaca056daaa8241843a2d90057272024e9583de93	1	1000000000000000	0x40f14fadea10daab99214368dcde893300ecdbce	0x2c3ef1f3df0bf1409af53f8fc0bafdfe60318e01	96	2978	9774661	2020-03-30T18:32:30.000Z	0x64f9461ecc213fbac1084890836e8e4c9a76088495a8664fa533908cde4bfeb9
0xf2ee97405593bc7b6275682b0331169a48fedec7	false	0xbc2c67a59ec004d7127a63f0f99275e31b4883cf	1	1000000000000000	0x40f14fadea10daab99214368dcde893300ecdbce	0x2c3ef1f3df0bf1409af53f8fc0bafdfe60318e01	75	2727	9774690	2020-03-30T18:38:40.000Z	0xa4e2f65d554751145b1b7ef51194b6ce87cb99263db2ee21f85f6ee3adb513a0
0xf2ee97405593bc7b6275682b0331169a48fedec7	false	0x474543b99438a978b39d39d8983723eb5ff9196b	1	1000000000000000	0x40f14fadea10daab99214368dcde893300ecdbce	0x2c3ef1f3df0bf1409af53f8fc0bafdfe60318e01	104	4148	9774656	2020-03-30T18:32:02.000Z	0x62450138ccd14a65234ebfe14393a000f917c14e58f611c9a5e6b784b71d1832

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ERC1155Sale_Buy_event

ERC1155Sale_buy_function

ERC721Sale_Buy_event

ERC721Sale_buy_function

ExchangeV1_Buy_event

ExchangeV1_exchange_function

ExchangeV12_exchange_function

RariMineV2_Claim_event

RoyaltyRegistry_getRoyalties_function

RoyaltyRegistry_OwnershipTransferred_event

RoyaltyRegistry_RoyaltiesSetForContract_event

RoyaltyRegistry_RoyaltiesSetForToken_event

RoyaltyRegistry_setProviderByToken_function

RoyaltyRegistry_setRoyaltiesByToken_function

TokenSale_Buy_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ERC1155Sale_Buy_event

​ERC1155Sale_buy_function

​ERC721Sale_Buy_event

​ERC721Sale_buy_function

​ExchangeV1_Buy_event

​ExchangeV1_exchange_function

​ExchangeV12_exchange_function

​RariMineV2_Claim_event

​RoyaltyRegistry_getRoyalties_function

​RoyaltyRegistry_OwnershipTransferred_event

​RoyaltyRegistry_RoyaltiesSetForContract_event

​RoyaltyRegistry_RoyaltiesSetForToken_event

​RoyaltyRegistry_setProviderByToken_function

​RoyaltyRegistry_setRoyaltiesByToken_function

​TokenSale_Buy_event

Tables

ERC1155Sale_Buy_event

ERC1155Sale_buy_function

ERC721Sale_Buy_event

ERC721Sale_buy_function

ExchangeV1_Buy_event

ExchangeV1_exchange_function

ExchangeV12_exchange_function

RariMineV2_Claim_event

RoyaltyRegistry_getRoyalties_function

RoyaltyRegistry_OwnershipTransferred_event

RoyaltyRegistry_RoyaltiesSetForContract_event

RoyaltyRegistry_RoyaltiesSetForToken_event

RoyaltyRegistry_setProviderByToken_function

RoyaltyRegistry_setRoyaltiesByToken_function

TokenSale_Buy_event