layer3_v1_zksyncera

Tables

Cube_CubeClaim_event

Layer3 Cube NFT claim events emitted when users mint quest completion tokens. Records claimer address, quest identifier, token identifier, issue number, optional wallet provider and embed origin metadata.

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_questId`	`STRING`	Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_claimer`	`STRING`	Address of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_issueNumber`	`STRING`	Sequential identifier for the NFT claim within its quest. Numeric string representation of the claim sequence number.
`in_walletProvider`	`STRING`	Name of the wallet application or browser extension used to initiate the claim transaction.
`in_embedOrigin`	`STRING`	URL of the website or application where the Layer3 quest claim was embedded or initiated.

Sample Data

address	removed	log_index	in_claimer	in_questId	in_tokenId	block_number	in_issueNumber	block_timestamp	transaction_hash
0xf77bd7c05598e094bc06e34bb81c07bd3b091db1	false	3	0xc7d285fb503b4392baf63a91253252a8d6bf3a94	73864929910910341822644595367334206379	2263688	41814407	7550	2024-08-16T07:55:09.000Z	0x7b3bc3fd7099aec01e7fa0804223a4291251fc847fc65f6c12ff719aec8b9c26
0xf77bd7c05598e094bc06e34bb81c07bd3b091db1	false	3	0xd6e8141df974aad3e6533c71444877e2580483e2	73864929910910341822644595367334206379	2263790	41816765	7629	2024-08-16T08:36:00.000Z	0x364eee75a6cf8a500a20f26a120410ed289d3fac2e96cd73eacb08cb29d6b72e
0xf77bd7c05598e094bc06e34bb81c07bd3b091db1	false	3	0x2a1e510db1deb8a3bcb1b58e1b582519153e5aaf	73864929910910341822644595367334206379	2264179	41827309	7889	2024-08-16T11:41:13.000Z	0xc1f530ab25ca9f1a8747862448f677ef778c13770150a5828040f3c05a48e2de

Example Query

Query with partition filter

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

Cube_TokenReward_event

Token reward distribution events from Layer3 Cube system containing reward amount, token details (address, type, and token ID), cube token identifier, and chain identifier. Used for tracking cross-chain reward allocations and token disbursements.

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_cubeTokenId`	`STRING`	Unique identifier for a Cube token in the Layer3 platform. Numeric string representation of the Cube NFT’s token ID.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_tokenType`	`INT64`	Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens.

Sample Data

address	removed	in_amount	log_index	in_chainId	block_number	in_cubeTokenId	block_timestamp	in_tokenAddress	transaction_hash
0xf77bd7c05598e094bc06e34bb81c07bd3b091db1	false	12500000000000000000	24	324	34869951	1400532	2024-05-25T08:06:54.000Z	0xa995ad25ce5eb76972ab356168f5e1d9257e4d05	0xcb2f7101b3d01454991b6b411f6f0fd27310579b12ff8751b23006e5251325f6
0xf77bd7c05598e094bc06e34bb81c07bd3b091db1	false	12500000000000000000	83	324	34873147	1401258	2024-05-25T09:02:43.000Z	0xa995ad25ce5eb76972ab356168f5e1d9257e4d05	0xee3fd46d1145dc897866e75f6d5925d908c0f9e637fa75a71b4b42608af638f8
0xf77bd7c05598e094bc06e34bb81c07bd3b091db1	false	12500000000000000000	31	324	34912085	1407278	2024-05-25T20:13:04.000Z	0xa995ad25ce5eb76972ab356168f5e1d9257e4d05	0x61e8d850c240399a2c680f4dcfd7d1a024fa64aa18ca712e265ec18613f7b3d4

Example Query

Query with partition filter

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

Escrow_EscrowERC20Transfer_event

ERC-20 token escrow transfer events emitted when tokens are released from an escrow contract to a recipient. Contains token address, transfer amount, recipient address, and optional rake (fee) details with payout address for platform revenue tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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_to`	`STRING`	Destination address receiving tokens or assets in the operation. 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_rake`	`STRING`	Fee amount deducted from the transfer. Numeric string representation in smallest token denomination.
`in_rakePayoutAddress`	`STRING`	Address designated to receive the rake fee from the escrow transfer. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Escrow_EscrowNativeTransfer_event

Native token transfer events from escrow contracts containing recipient address, transfer amount, rake fee, and rake payout address. Used for tracking escrowed native asset movements and associated fee distributions across Layer3 platform deployments.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. 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_rake`	`STRING`	Fee amount deducted from the transfer. Numeric string representation in smallest token denomination.
`in_rakePayoutAddress`	`STRING`	Address designated to receive the rake fee from the escrow transfer. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Escrow_TokenPayout_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_tokenType`	`INT64`	Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens.
`in_questId`	`STRING`	Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Factory_EscrowRegistered_event

Event log capturing escrow contract registrations in the Layer3 quest platform. Links quest identifiers to their deployed escrow contract addresses and registering parties for reward distribution tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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_registror`	`STRING`	Contract address that registered the escrow for the quest. Hex-encoded, 0x-prefixed, 42-character string.
`in_escrowAddress`	`STRING`	Contract address of the escrow associated with the quest registration. Hex-encoded, 0x-prefixed, 42-character string.
`in_questId`	`STRING`	Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.

Sample Data

address	removed	log_index	in_questId	block_number	in_registror	block_timestamp	in_escrowAddress	transaction_hash
0xc3e7df62b4d6c1dc3330a3382eaf5a64f45959fb	false	18	212981349668212110430712858913617115597	31896143	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-04-19T13:28:55.000Z	0x44bd083582218cb8019b06a4b8b12f2a589de0e3	0x875b4129fef75746c659fc1cc8a2cc35055ce9c603f690fbf00d121d29174d0d
0xc3e7df62b4d6c1dc3330a3382eaf5a64f45959fb	false	4	214245608344017283220061796302096080587	52974702	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2025-01-05T21:26:51.000Z	0x8bd97af30aea0677b138e179b840ccebccaa88e3	0xad20c79554d963db82d6ed4231495d47872698beec94cf0d61562a880abf2825
0xc3e7df62b4d6c1dc3330a3382eaf5a64f45959fb	false	46	27700113922334506041974287622477583490	32213043	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-04-23T09:35:35.000Z	0x20f7b1d4696fb25e638f93911de58b5e39f9d9b3	0x72111b2b282174a0cd3cbab139b8a96826caae2aa8be4643ebb7c42a44eaabe9

Example Query

Query with partition filter

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

Pool_TokenPayout_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_tokenType`	`INT64`	Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens.
`in_questId`	`STRING`	Unique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Cube_CubeClaim_event

Cube_TokenReward_event

Escrow_EscrowERC20Transfer_event

Escrow_EscrowNativeTransfer_event

Escrow_TokenPayout_event

Factory_EscrowRegistered_event

Pool_TokenPayout_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Cube_CubeClaim_event

​Cube_TokenReward_event

​Escrow_EscrowERC20Transfer_event

​Escrow_EscrowNativeTransfer_event

​Escrow_TokenPayout_event

​Factory_EscrowRegistered_event

​Pool_TokenPayout_event

Tables

Cube_CubeClaim_event

Cube_TokenReward_event

Escrow_EscrowERC20Transfer_event

Escrow_EscrowNativeTransfer_event

Escrow_TokenPayout_event

Factory_EscrowRegistered_event

Pool_TokenPayout_event