Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_questIdSTRINGUnique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_claimerSTRINGAddress of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_isNativeBOOLIndicates whether the claimed token is native to the platform or chain versus a wrapped or third-party asset. Always true in sample data, suggesting most claims involve native Layer3 tokens.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_issueNumberSTRINGSequential identifier for the NFT claim within its quest. Numeric string representation of the claim sequence number.
in_walletProviderSTRINGName of the wallet application or browser extension used to initiate the claim transaction.
in_embedOriginSTRINGURL of the website or application where the Layer3 quest claim was embedded or initiated.
addressremovedin_pricelog_indexin_claimerin_questIdin_tokenIdin_isNativeblock_numberin_embedOriginin_issueNumberblock_timestamptransaction_hashin_walletProvider
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false030xca4f09d258d84b6f6aeb3bb35d2a397007839e78292105874657351937997747607667451228466517635true3530134555232025-05-14T05:55:03.000Z0x3d772131cef0a5b77dc2a4abc0af071bbbfc76ec49f6fd19617a3dc1bba8578d
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false030xe7fd8cc646a3f8a20b89113e569f1893b641bb4b230910755411699932914572880232932445762517650true3530511571432025-05-14T06:57:53.000Z0xe90507f10cf5dd48152e8d7a37a9ccc5390229b7268657f0848600980822a202
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false54854875940212573680x50d087c856930ccbb778afc475ac99d57083387e230910755411699932914572880232932445762517614true3528566271172025-05-14T01:33:40.000Z0x1d04f85d527e0c8d8b2749dc78398e12e4b2eafeff22757a559c6524c426ac6d
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v2_celo.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_cubeTokenIdSTRINGUnique identifier for a Cube token in the Layer3 platform. Numeric string representation of the Cube NFT’s token ID.
in_tokenAddressSTRINGToken contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_chainIdSTRINGBlockchain 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_tokenTypeINT64Token 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_rewardRecipientAddressSTRING-
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v2_celo.Cube_TokenReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100