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_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.
addressremovedlog_indexin_claimerin_questIdin_tokenIdblock_numberin_embedOriginin_issueNumberblock_timestamptransaction_hashin_walletProvider
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false10x05049f7a24f281e3c22ab2f68dcdc2790f13535e3226096104715232837928729758774358033321280869212305299404382024-05-17T21:05:53.000Z0x359985d92991b34e849c4aed2ac805d16162c5e0e9a540c298175960646cb8d7
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false10x0bc5765389fd703f7d7ef01f20596e544c7f4f683226096104715232837928729758774358033321280335212289774402122024-05-17T19:59:58.000Z0xd83af151b437bc222d8447b9d1e679c2740f5d08d100dcbdaae96b32df820b25
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false10xe583dd0feb415a6684df955c3a6cca6fd58e8c273226096104715232837928729758774358033321280516212294572402882024-05-17T20:20:14.000Z0xf10fb03266451155887f45e13ce403a456868c08bba511d60430cf1510985619
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.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.
addressremovedin_amountlog_indexin_chainIdin_tokenIdblock_numberin_tokenTypein_cubeTokenIdblock_timestampin_tokenAddresstransaction_hash
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false35000034216101869227860261072024-03-04T06:33:59.000Z0xaf88d065e77c8cc2239327c5edb3a432268e58310x862511a70674794f594a43baadc61667b02053a65cad7be756455c0e6c799dc8
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false35000034216101869921860263942024-03-04T11:31:57.000Z0xaf88d065e77c8cc2239327c5edb3a432268e58310x88c50e4f0d4274b64d6e7b7aa5765809778e0aa796e9da2b326f8f407e54bf27
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7false35000034216101869767360263382024-03-04T10:25:15.000Z0xaf88d065e77c8cc2239327c5edb3a432268e58310x93c890fc1539cfce948570c0d8e386070cf3825c1efe96c8e705c9673400a67c
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.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.
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_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_rakeSTRINGFee amount deducted from the transfer. Numeric string representation in smallest token denomination.
in_rakePayoutAddressSTRINGAddress designated to receive the rake fee from the escrow transfer. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressin_rakeremovedin_tokenin_amountlog_indexblock_numberblock_timestamptransaction_hashin_rakePayoutAddress
0x91c39732b09c836978caa74863de23f853e124400x1a899be2a7b69e47860eeeabaa6d06ebd9e82b000false0x354a6da3fcde098f8389cad84b0182725c6c91de3120000000000000092768432172024-11-21T16:31:34.000Z0x810e1d91a0ab21d3ae15735fc9e240bb1cdf3f252dcf1d2c49dd8c78239a75180x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1
0xdc02781bd75fa9102e00440a7e6176985430074d0x1a899be2a7b69e47860eeeabaa6d06ebd9e82b000false0x354a6da3fcde098f8389cad84b0182725c6c91de31200000000000000102768635502024-11-21T17:56:39.000Z0x5b940cd757e19e4bfdec7fe5fc025a88332a8c9dfb9795408efbcce97b7fad420x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1
0xfbbcbb87f982ce7c3b46959ec5aaf2b3d892cd0d0x1a899be2a7b69e47860eeeabaa6d06ebd9e82b000false0x354a6da3fcde098f8389cad84b0182725c6c91de312000000000000001742767634532024-11-21T10:57:18.000Z0x2aa5a4427cf2a4f51fe3477f97fd7b32940103c0e1a09c2592615e2d5c7e52720x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.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.
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_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_rakeSTRINGFee amount deducted from the transfer. Numeric string representation in smallest token denomination.
in_rakePayoutAddressSTRINGAddress designated to receive the rake fee from the escrow transfer. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressin_rakeremovedin_amountlog_indexblock_numberblock_timestamptransaction_hashin_rakePayoutAddress
0x7cfe310b31c71c45a8141326cb73f7e248a42bd10x23e1c72d455243c108aa810ee03bad442f25fc0b0false1000000000000031947202362024-03-27T10:37:31.000Z0xc8159958655d7b8f665222d5dd5e7cb5b5cfbb047b874b5082839d10df22b5570x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0xa60cd6fb8e3f96fa3a5b296a62024ebaeba588c10x23e1c72d455243c108aa810ee03bad442f25fc0b0false1000000000000031947357992024-03-27T11:42:25.000Z0xcf09db7ba617252c5b956d06b7ada220fe44d733e97bdebbbb335ef45c4bd7d10x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0x7084b2a1637f5a0535dbb9e272e8b7c02a69e3080xe1e23406751be4fb099eb893b802039109ee1f810false145000000000000000003341187212025-05-07T07:34:14.000Z0xd9bf7eefeccad3d9c334d4333eb5676f4ecaeec9743dc0a74d761ba2c213cd830x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.Escrow_EscrowNativeTransfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Escrow_OwnershipTransferred_event

Ownership transfer events from Layer3’s Escrow contract on Arbitrum, recording when contract control changes from one address to another. Used for tracking administrative changes and contract governance transitions.
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_previousOwnerSTRINGAddress of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
in_newOwnerSTRINGAddress of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexin_newOwnerblock_numberblock_timestampin_previousOwnertransaction_hash
0x8213e34e5427b23c3db5ef9f72b352997b35fd55false310xeda4b295c53412c3c78b8cbc64685bb92b2347e92214866192024-06-13T17:03:51.000Z0x00000000000000000000000000000000000000000xf8cf89241ca7a1b65e37fb5dd80eb1ce0b02670927199050ab753d6bbc82b0ac
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.Escrow_OwnershipTransferred_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Escrow_TokenPayout_event

No description available.
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_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenAddressSTRINGToken contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
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_questIdSTRINGUnique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.Escrow_TokenPayout_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Escrow_TokenWhitelisted_event

Token whitelist management events from Layer3’s escrow contract on Arbitrum, recording when tokens are added to or removed from the accepted payment list. Used for tracking which tokens the protocol supports for escrowed transactions.
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_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_tokenlog_indexblock_numberblock_timestamptransaction_hash
0x8213e34e5427b23c3db5ef9f72b352997b35fd55false0x912ce59144191c1204e64559fe8253a0e49e6548112214873662024-06-13T17:06:56.000Z0xb596dee192c49503611f84918b4b9b68fc86e757d2a1f6cabc98bc2edad76de5
0x8213e34e5427b23c3db5ef9f72b352997b35fd55false0x912ce59144191c1204e64559fe8253a0e49e6548762214872622024-06-13T17:06:30.000Z0xe26c69f3af150e97570caad39a1e73c69b8f885ef144e4f1fe44bc24bc8266ce
0x8213e34e5427b23c3db5ef9f72b352997b35fd55false0x912ce59144191c1204e64559fe8253a0e49e654812214874412024-06-13T17:07:15.000Z0x5f5d8639eb82e2b863aa0257f068d1d8b2ca6724c5d5bfad50bd5c7857b5a7ef
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.Escrow_TokenWhitelisted_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.
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_registrorSTRINGContract address that registered the escrow for the quest. Hex-encoded, 0x-prefixed, 42-character string.
in_escrowAddressSTRINGContract address of the escrow associated with the quest registration. Hex-encoded, 0x-prefixed, 42-character string.
in_questIdSTRINGUnique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.
addressremovedlog_indexin_questIdblock_numberin_registrorblock_timestampin_escrowAddresstransaction_hash
0x5e2b297016d41055876ff1078100c548adc3a498false12171316433591845280861591928084357611362283436290x1796a56b5446a4d7d32914aa645ba1d3730ae81d2024-07-03T13:41:53.000Z0x3e5129b8818999f5b9704ee0b1574282d0013b6c0xb7484c8222fc1cb9b37915b973424f6de2a0368dc9f6f07bb3904b4c22a9f8f8
0x5e2b297016d41055876ff1078100c548adc3a498false62368842468456498927051960289501833881612283525050x1796a56b5446a4d7d32914aa645ba1d3730ae81d2024-07-03T14:19:08.000Z0xc3dac81a86651ecc6eac25c3d47f820bb39014e00x5f32e18bb1a81f714fede319bf8146179e88a6653c0a231b4da7b1d0eebb2eef
0x5e2b297016d41055876ff1078100c548adc3a498false92567734717381498255374300032127088478462565256530x1796a56b5446a4d7d32914aa645ba1d3730ae81d2024-09-23T13:12:25.000Z0x818e78463043b0ec220ac6f956d4809c3027ee590xafdc724fdee5851ba19454597dcff560ee39a647c44a935f09fe8e9fa19cc49b
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.Factory_EscrowRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_TokenPayout_event

No description available.
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_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenAddressSTRINGToken contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
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_questIdSTRINGUnique identifier for a quest within the Layer3 platform. Numeric string representation of the quest’s ID.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.layer3_v1_arbitrum.Pool_TokenPayout_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100