layer3_v1_avalanche

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	2	0xa5ab2ffed2a1de60d9b99f0a9e8e6da79b3067d2	227332360129333175987393772305080992785	36529	47709123	36530	2024-07-08T13:15:14.000Z	0xeb88d113f6c5b62a1b470e945b4e57046a9d300862d1a72fde6631d48bf8d147
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	1	0x0c85c95aa4fe870e03ca335bae0c0468ba68b721	227332360129333175987393772305080992785	36538	47711624	36539	2024-07-08T14:39:26.000Z	0xb57d10f4e0f4b75f29419de0f8d834e9110de390559033682f2d354229fa96c9	Zerion
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	2	0xf5d25cbe35e4261664ae91ba777ffba006cccd53	227332360129333175987393772305080992785	36563	47721067	36564	2024-07-08T20:00:21.000Z	0x816851b2275e01da6d47c66d554c1d649f9f41df433031e5d134e4be9f719f8b	Zerion

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_avalanche.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_tokenType	in_cubeTokenId	block_timestamp	in_tokenAddress	transaction_hash
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	5000000000000000	2	43114	57646936	3	51173	2025-02-21T10:05:22.000Z	0x0000000000000000000000000000000000000000	0xb776573e94a363f7d9d94902b5dd23e818c5e40a1b1a01806edcbeb5f2958527
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	9600000000000000	2	43114	57663665	3	52174	2025-02-21T17:19:48.000Z	0x0000000000000000000000000000000000000000	0x1ba0bd11c2dddd6c0c120df520b5bb700188dd17c12a9de27e6f394244186c8a
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	3000000000000000	2	43114	57652564	3	51735	2025-02-21T12:50:29.000Z	0x0000000000000000000000000000000000000000	0xad900a981dc383bc5a6044133c836b289cd292b1435b4d29703ecd62a26087ed

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_avalanche.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
0x8c932e9b832c484870ab582da58ac055b41caf58	0x22ef1901b9a34c09c52cbcbe5ea39ce5dd27d03e	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	250000	4	65934814	2025-07-23T09:28:13.000Z	0xb49645aa6c164bd4d4578990145eff578e413ce120b38aa3e52e59a4efacb46e	0x8495f22aa4c93e50f46250e25bb257d5d25ae984
0x9d7db6b8980356e0906b1ea1478b8d8d5a1c1a66	0x662acf01f1a665f3de1ee9c9d27e031f27992bfa	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	200000	5	65946266	2025-07-23T14:43:00.000Z	0xdaf0b91eed5a6c2a38aaea733a2aaefe309fef4b1bef7f7270610b2872b63dde	0x8495f22aa4c93e50f46250e25bb257d5d25ae984
0x12924049e2d21664e35387c69429c98e9891a820	0x662acf01f1a665f3de1ee9c9d27e031f27992bfa	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	200000	5	65964543	2025-07-23T22:48:12.000Z	0x628981cc0891e59e7ad70954aaa3ce4c16dd78fabade4b216fa8e1fc5b80590b	0x8495f22aa4c93e50f46250e25bb257d5d25ae984

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_avalanche.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_avalanche.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_avalanche.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	14	209639220389195938994008816705818599940	65898456	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2025-07-22T16:25:28.000Z	0x662acf01f1a665f3de1ee9c9d27e031f27992bfa	0xa91534c50b24813906246ce1a20e47c0ef2477afe1342cb8cc24eab59c5969c1
0x5e2b297016d41055876ff1078100c548adc3a498	false	10	14234101506439081528578336465719719556	65934712	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2025-07-23T09:25:38.000Z	0x22ef1901b9a34c09c52cbcbe5ea39ce5dd27d03e	0xc86d59f9c88bc0967fe0e5f1255854c525c0f4c65b39a5c0dd3289659a6e009d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_avalanche.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_avalanche.Pool_TokenPayout_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

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

Tables

Cube_CubeClaim_event

Cube_TokenReward_event

Escrow_EscrowERC20Transfer_event

Escrow_EscrowNativeTransfer_event

Escrow_TokenPayout_event

Factory_EscrowRegistered_event

Pool_TokenPayout_event