layer3_v1_base

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	in_walletProvider
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	256	0xc51798c0ddef98a97720475a10b1e27892207cb0	1466120808989061590940564159460171069	4136152	14897001	21358	2024-05-24T20:42:29.000Z	0xc87b7233aba40dca3567485534599aaf181652fcc8783358f9264b5e283cdce0	MetaMask
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	259	0x49cec7ee8eae35e9c39a4b3fe5b84f2c1240bc40	1466120808989061590940564159460171069	4103996	14860003	21317	2024-05-24T00:09:13.000Z	0xd668f8ded9a101c64bdc7bb23e9e947958cc217d3a665fc936cc8bd554bf49c2	MetaMask
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	259	0xcc039022a50fbc67cffe3ef7daffb213ce5bd8bb	1466120808989061590940564159460171069	4137484	14898938	21362	2024-05-24T21:47:03.000Z	0x8001e6effcda68e0c0a5e870f5b2be78424f5a47fe8dae5d061d24370b040b51	Injected

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_base.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
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	2000000	3	8453	11300835	421152	2024-03-02T14:50:17.000Z	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x38f216edc5ace5c0ba61fd44ca88f3c3d2d0d317bdba14f8fc350dcfd9480d16
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	2000000	3	8453	11283919	416773	2024-03-02T05:26:25.000Z	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0xe3a6a4f336648d064dfe019241a2740454cbb85886da1aaf9871a4addd8b947c
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	2000000	4	8453	11300191	420978	2024-03-02T14:28:49.000Z	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x492066570b8cad5fc43a233a44ff3a3820608818832c11076a8150cacd9e3a2a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_base.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

in_to	address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_rakePayoutAddress
0x42a0ce8930fe39cb15c3dcd217d0f8c4073bdd16	0xec4bf2f268af7edae893a8d623973e928f31fb76	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2440000	14	14744500	2024-05-21T07:59:07.000Z	0x525454da8b6e323c951f0b9bfdd461505c8d7036e2be61ea8ea538dd0b7ce94a	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0xab6fcaa46f137e8a6de9d16cb27a9d988becc443	0xec4bf2f268af7edae893a8d623973e928f31fb76	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2440000	159	14769586	2024-05-21T21:55:19.000Z	0x954535fc0143a270feb5b8290b96069236fe77a01de482e387faf25d3c91e1fa	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0xa03931b426bf36c38f19f7111894612cd6bdf295	0xec4bf2f268af7edae893a8d623973e928f31fb76	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2440000	205	14768603	2024-05-21T21:22:33.000Z	0x4f7f2fb82e87c6fdd3c77a4c80d7d5a01760b028d4bc7c93b4e95cc9fcc31707	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_base.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

in_to	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_rakePayoutAddress
0xa853940a3ab810d422568ee5adb37c9a15eed3e0	0x9eb48f9d8d8d7adb36019b7f21d2ef197091c003	false	660450000000000	146	21054093	2024-10-14T09:18:53.000Z	0x2ad8eaa34f5943644b77d99d751d14a57bccaf742d29e8c4ed73787987dd02e3	0xd254beb8e42bf90adea93072fbf2ae63fd22a428
0xeedb07ae31191e8e803685887bf653754f2f6f52	0x9eb48f9d8d8d7adb36019b7f21d2ef197091c003	false	660450000000000	218	21050979	2024-10-14T07:35:05.000Z	0x2f1ae8a70ba0fcec6be9f72e19c5a60d6df3b96a866aea34395ad3cf224a4860	0xd254beb8e42bf90adea93072fbf2ae63fd22a428
0x51811fbf055a7e4fef7d4747d7f136b1eea02651	0xc6b07d8d848dba154c365983db2f692193255c27	false	85000000000000	259	18758791	2024-08-22T06:08:49.000Z	0x55b95dfed6afe6ab6b03a3cc889ebc314c49d29e9191ac84bd2fcb6f48b758b4	0xd254beb8e42bf90adea93072fbf2ae63fd22a428

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_base.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_base.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
0x5e2b297016d41055876ff1078100c548adc3a498	false	4	109226852422539367470492301063966731039	16040098	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-06-20T07:45:43.000Z	0x5c5a2eb0557b957a511a91cda4cf085b91ad4e87	0x04a57a47cb2f8984ac579a5b5d47a2adff7eb68fdbc5458c358f0cf348265388
0x5e2b297016d41055876ff1078100c548adc3a498	false	1	254721598650970539940665154573250004804	19326332	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-09-04T09:26:51.000Z	0x081fe01778654b330b0118303a7f6e84c0c22fd0	0x8b4776555d5c20d2121313d2e59b6d79632eee3e620e2044eeba8d2ace8f59df
0x5e2b297016d41055876ff1078100c548adc3a498	false	1	70048590488032944276770781181943380965	19336482	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-09-04T15:05:11.000Z	0x68c4fecd8f26b55deebe3f532d1aaa0e6348af6e	0xe7f172da29055e33095f14ec03e0e852d8f0ce85db7055cbe9de8068c041ea6f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_base.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_base.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