rarible_v1_zksyncera

Tables

ExchangeMeta_Cancel_event

Order cancellation events from Rarible NFT (non-fungible token) marketplace on zkSync Era. Records cancelled listings and offers with order hash identifiers for tracking marketplace activity and user behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_hash`	`STRING`	Hash identifier of the canceled order on the Rarible marketplace. Always non-null, hex-encoded 0x-prefixed 64-character string uniquely identifying the order being canceled.

Sample Data

address	in_hash	removed	log_index	block_number	block_timestamp	transaction_hash
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	0x93f71a08ea920ea3d0eac5319d5d2da459a83d03612db6bb2c97f7b0fd987387	false	100	22053079	2023-12-21T12:01:28.000Z	0x3cf30305ebc66b69415396cbcee01135184dca369c24e14b79752d64cc103d31
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	0xc15cb2460474842891745512446fedba34eaab30a71be3beeed2c0c6cb392e76	false	97	21989463	2023-12-20T17:44:16.000Z	0xddc787c5e9c01205fcd7a2c389d635433db3f89ef773efb3a424bd5c7dd30719
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	0xc15cb2460474842891745512446fedba34eaab30a71be3beeed2c0c6cb392e76	false	72	21988572	2023-12-20T17:29:04.000Z	0xe1866ad66446e1516a07bac4608fe88608d05d425afccc8787854511e3898b86

Example Query

Query with partition filter

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

ExchangeMeta_directPurchase_function

Direct purchase transactions from Rarible’s NFT marketplace on zkSync Era. Contains buy and sell order details including NFT identifiers, payment amounts, maker addresses, and cryptographic signatures for tracking marketplace activity and order execution.

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_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	trace_address	block_timestamp	transaction_hash
681156	967500000000000	true	426537	{“nftData”:“0x000000000000000000000000f501f9df64e433d54d6eb33513244aeb5288ffe81dbcaa002e5cc9d6da3d8728142448117910bc95000000000000000000000005”,“buyOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1719792728”,“nftAssetClass”:“0x973bb640”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“sellOrderSalt”:“104432165615398669513913894967129370850452747826619919550142244312100364771290”,“sellOrderMaker”:“0x1dbcaa002e5cc9d6da3d8728142448117910bc95”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“15000”,“sellOrderSignature”:“0xbfcd71e79f2ab3301fbd1df45bab73a578266f595b96326c9a0daf2fcef98e9c3d36980091effd1c2d3007d5769ee03c93e34b0a1f860a3d61906d45e4a21eca1c”,“buyOrderPaymentAmount”:“900000000000000”,“sellOrderPaymentAmount”:“13500000000000000000”}	0x0d5f7d35	0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	24656545	0x0bcbfcf3fdba607091c6c27ad69b197fe2d15992	0,18,0,1	2024-01-22T03:33:53.000Z	0x753d373ed71b0c568ccf97886a99ef67e63ed75a999a0d8ce4ac01335613806f
2609145	1437275000000000	true	835536	{“nftData”:“0x000000000000000000000000d02cb44adf7acf92eef81067ac276b453011ef407ac98895d094126796fcbc6ef7820810bd00278f000000000000000000000002”,“buyOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1705681975”,“nftAssetClass”:“0x73ad2146”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“sellOrderSalt”:“50565005940820608184066911216955554554642123264190457504854719467202872601350”,“sellOrderMaker”:“0x7ac98895d094126796fcbc6ef7820810bd00278f”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“1”,“sellOrderSignature”:“0x890998a298beb75fbd513a8a93c6af4860a104982baa854f6affd91646d7c03668d8c6e6855a37dd5bd6aed564a5bb799d4dda44b4d7447ea1f9c96a1c9be81e1c”,“buyOrderPaymentAmount”:“1337000000000000”,“sellOrderPaymentAmount”:“1337000000000000”}	0x0d5f7d35	0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	21988401	0x28e7e9c1e83fd22b7ee6e9d15fc0cfd96168b1b1	0,17,0,1	2023-12-20T17:26:12.000Z	0x3c37ef9b5e6e2c9f077c39bb24cb8c32acf2a572d6e2e0d082561139b46e2ef5
517986	182750000000000	true	312663	{“nftData”:“0x000000000000000000000000f501f9df64e433d54d6eb33513244aeb5288ffe801a0f471541c31e394ec5150371294dca3bd71d7000000000000000000000001”,“buyOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“paymentToken”:“0x0000000000000000000000000000000000000000”,“sellOrderEnd”:“1708839360”,“nftAssetClass”:“0x973bb640”,“sellOrderData”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000f22f838aaca272afb0f268e4f4e655fac3a35ec00000000000000000000000000000000000000000000000000000000000002ee”,“sellOrderSalt”:“55196506379763129297431056046875328266240224747921203904639076826413560943132”,“sellOrderMaker”:“0x01a0f471541c31e394ec5150371294dca3bd71d7”,“sellOrderStart”:“0”,“buyOrderNftAmount”:“1”,“sellOrderDataType”:“0x23d235ef”,“sellOrderNftAmount”:“170000”,“sellOrderSignature”:“0x9bbb4b0a2a64d296d744c9e5d27280217bc03726b842aef5a8cf074d6ad8710f42d9404b0d171351b36513fde63b7de35217108e9d3c9385be8ef9cbc32c097b1b”,“buyOrderPaymentAmount”:“170000000000000”,“sellOrderPaymentAmount”:“28900000000000000000”}	0x0d5f7d35	0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	25182796	0xb0530a6347c1e5807f5c5a6a8a33044dbea93470	0,18,0,1	2024-01-28T12:40:07.000Z	0x4f9380d676631ce29ae514dd0edb8fa345db71c4e61bf4fb56f00ebf22a4777d

Example Query

Query with partition filter

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

ExchangeMeta_Match_event

Order matching events from Rarible NFT marketplace on zkSync Era, recording matched buy and sell orders with fill amounts. Tracks trade execution between makers and takers for analyzing marketplace liquidity and 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.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_leftHash`	`STRING`	Unique identifier hash for the left-side order in a Rarible exchange match on zkSync Era. Each hash represents a distinct order being matched, with fill amounts tracked in corresponding newLeftFill values.
`in_rightHash`	`STRING`	Hash identifier of the right (maker or taker) order being matched in this Rarible exchange transaction. Hex-encoded, 0x-prefixed 64-character string representing the keccak256 hash of the order parameters.
`in_newLeftFill`	`STRING`	Updated fill amount for the left-side order after matching, represented in wei (smallest denomination). This tracks how much of the maker order has been filled following the trade execution.
`in_newRightFill`	`STRING`	Updated fill amount for the right-side order after the match is executed, typically representing the quantity of tokens or NFTs (often 1 for NFTs) received by the right-side order participant.

Sample Data

address	removed	log_index	in_leftHash	block_number	in_rightHash	in_newLeftFill	block_timestamp	in_newRightFill	transaction_hash
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	false	2	0xdd18e4e6344ad8b229c4aa6574256791abd46526f0bdf00c6567844a593e1c9f	23555014	0xf464669d87d0616c6d6121a1048d5b052a4fd495b1a27c30a4b3aaf6bbc6f9f1	2000000000000000	2024-01-08T19:17:32.000Z	1	0xa64f76d17956379599558128a907ab8af988968dfd35f683651eb911be41c64c
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	false	28	0xdfcd3a468df4798cb40f7b3429b0801a286573f703432a3d39bf7f5149155651	23555087	0xc9492f53204e343ee2c2f52691fbbf2f047701c3201b2105be0ca1429417fbc9	2000000000000000	2024-01-08T19:18:45.000Z	1	0xa6c66f2af37ce20ed23e49dfd0c788091edeaf8a1e74878afe19c8589b36a7a8
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	false	65	0x227fd51e5f0d0ba2dbc9a9e33fc1298e9860717eac1e766018199d7023cbdfa8	23555156	0x78c60220e7222a15d73033522c7fbd5c53f1226138afa1f9d33a29b701e11cd8	2000000000000000	2024-01-08T19:19:56.000Z	1	0x2e500d0c83c3c161a81f68986466e15ccc377c25629ab23567c766a3675e2525

Example Query

Query with partition filter

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

ExchangeMeta_MatcherChange_event

Configuration changes for authorized matchers on Rarible V1 NFT marketplace deployed on zkSync Era. Tracks additions and removals of matcher addresses that can execute trades for specific asset types, useful for analyzing marketplace operator permissions and protocol governance.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_assetType`	`STRING`	Asset type identifier for the Rarible exchange protocol. 10-character hex string including 0x prefix.
`in_matcher`	`STRING`	Address of the matcher account authorized for this asset type in the Rarible exchange contract. Hex-encoded, 0x-prefixed 40-character string representing the zkSync Era address.

Sample Data

address	removed	log_index	in_matcher	block_number	in_assetType	block_timestamp	transaction_hash
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	false	25	0x1d83b947ec9556c937744f42616146fc214e5ba1	21464070	0xf63c2825	2023-12-14T10:42:34.000Z	0xff0de2953c8b58d943ee412f1fb2931a8417fa098bafc78fd3162a575a949d3e

Example Query

Query with partition filter

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

ExchangeMeta_OwnershipTransferred_event

Ownership transfer events from the Rarible v1 NFT marketplace ExchangeMeta contract on zkSync Era, tracking administrative control changes from previous to new owner addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	false	2	0x256effcea2ab308d31e318728d2615545171d85b	21463944	2023-12-14T10:40:22.000Z	0x0000000000000000000000000000000000000000	0x792a872bbf2fe485cbdf7ca82aedb548904ec5cb45cec70fdd9cb7ac0042309f

Example Query

Query with partition filter

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

ExchangeMeta_ProxyChange_event

Proxy configuration change events from Rarible NFT marketplace exchange contract on zkSync Era, tracking updates to asset type handler addresses. Used for monitoring marketplace infrastructure changes and understanding which proxy contracts handle different asset standards.

Columns

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

Sample Data

address	removed	in_proxy	log_index	block_number	in_assetType	block_timestamp	transaction_hash
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	false	0x463651f1620e411426e7eb70c3d2029106f2b6e0	94	21464038	0xd8f960c1	2023-12-14T10:41:59.000Z	0xb4f4d3d456f4e64568f9798ccca69e710fdd077843698a30d8f69243db966667
0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	false	0x99e3d07c2fa7d9566baa34e84b9dd5b8fb98961a	7	21464049	0x1cdfaa40	2023-12-14T10:42:10.000Z	0x08770869fb61680b8f9160c0e2ee0084b9246126078c2c1b764ad9d33ba21366

Example Query

Query with partition filter

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

ExchangeMeta_setTransferProxy_function

Transfer proxy configuration events from Rarible’s NFT marketplace exchange contract on zkSync Era. Records administrative calls that register proxy contracts authorized to transfer specific asset types (ERC-721, ERC-1155, ERC-20) during trades.

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_assetType`	`STRING`	Asset type identifier for the Rarible exchange protocol. 10-character hex string including 0x prefix.
`in_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	value	status	gas_used	in_proxy	signature	to_address	block_number	from_address	in_assetType	trace_address	block_timestamp	transaction_hash
377937	0	true	105096	0x99e3d07c2fa7d9566baa34e84b9dd5b8fb98961a	0x30c642f1	0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	21464049	0x256effcea2ab308d31e318728d2615545171d85b	0x1cdfaa40	0,18,0	2023-12-14T10:42:10.000Z	0x08770869fb61680b8f9160c0e2ee0084b9246126078c2c1b764ad9d33ba21366
361557	0	true	105096	0x463651f1620e411426e7eb70c3d2029106f2b6e0	0x30c642f1	0x5e0bbed68e1b47c94a396226d8ac10dde242e77c	21464038	0x256effcea2ab308d31e318728d2615545171d85b	0xd8f960c1	0,18,0	2023-12-14T10:41:59.000Z	0xb4f4d3d456f4e64568f9798ccca69e710fdd077843698a30d8f69243db966667

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ExchangeMeta_Cancel_event

ExchangeMeta_directPurchase_function

ExchangeMeta_Match_event

ExchangeMeta_MatcherChange_event

ExchangeMeta_OwnershipTransferred_event

ExchangeMeta_ProxyChange_event

ExchangeMeta_setTransferProxy_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​ExchangeMeta_Cancel_event

​ExchangeMeta_directPurchase_function

​ExchangeMeta_Match_event

​ExchangeMeta_MatcherChange_event

​ExchangeMeta_OwnershipTransferred_event

​ExchangeMeta_ProxyChange_event

​ExchangeMeta_setTransferProxy_function

Tables

ExchangeMeta_Cancel_event

ExchangeMeta_directPurchase_function

ExchangeMeta_Match_event

ExchangeMeta_MatcherChange_event

ExchangeMeta_OwnershipTransferred_event

ExchangeMeta_ProxyChange_event

ExchangeMeta_setTransferProxy_function