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
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
Sample Data
| address | removed | log_index | in_claimer | in_questId | in_tokenId | block_number | in_embedOrigin | in_issueNumber | block_timestamp | transaction_hash | in_walletProvider |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7 | false | 1 | 0x05049f7a24f281e3c22ab2f68dcdc2790f13535e | 322609610471523283792872975877435803332 | 1280869 | 212305299 | 40438 | 2024-05-17T21:05:53.000Z | 0x359985d92991b34e849c4aed2ac805d16162c5e0e9a540c298175960646cb8d7 | ||
| 0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7 | false | 1 | 0x0bc5765389fd703f7d7ef01f20596e544c7f4f68 | 322609610471523283792872975877435803332 | 1280335 | 212289774 | 40212 | 2024-05-17T19:59:58.000Z | 0xd83af151b437bc222d8447b9d1e679c2740f5d08d100dcbdaae96b32df820b25 | ||
| 0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7 | false | 1 | 0xe583dd0feb415a6684df955c3a6cca6fd58e8c27 | 322609610471523283792872975877435803332 | 1280516 | 212294572 | 40288 | 2024-05-17T20:20:14.000Z | 0xf10fb03266451155887f45e13ce403a456868c08bba511d60430cf1510985619 |
Example Query
Example Query
Query with partition filter
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
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
Sample Data
| address | removed | in_amount | log_index | in_chainId | in_tokenId | block_number | in_tokenType | in_cubeTokenId | block_timestamp | in_tokenAddress | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7 | false | 350000 | 3 | 42161 | 0 | 186922786 | 0 | 26107 | 2024-03-04T06:33:59.000Z | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 0x862511a70674794f594a43baadc61667b02053a65cad7be756455c0e6c799dc8 |
| 0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7 | false | 350000 | 3 | 42161 | 0 | 186992186 | 0 | 26394 | 2024-03-04T11:31:57.000Z | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 0x88c50e4f0d4274b64d6e7b7aa5765809778e0aa796e9da2b326f8f407e54bf27 |
| 0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7 | false | 350000 | 3 | 42161 | 0 | 186976736 | 0 | 26338 | 2024-03-04T10:25:15.000Z | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 0x93c890fc1539cfce948570c0d8e386070cf3825c1efe96c8e705c9673400a67c |
Example Query
Example Query
Query with partition filter
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
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
Sample Data
| in_to | address | in_rake | removed | in_token | in_amount | log_index | block_number | block_timestamp | transaction_hash | in_rakePayoutAddress |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x91c39732b09c836978caa74863de23f853e12440 | 0x1a899be2a7b69e47860eeeabaa6d06ebd9e82b00 | 0 | false | 0x354a6da3fcde098f8389cad84b0182725c6c91de | 31200000000000000 | 9 | 276843217 | 2024-11-21T16:31:34.000Z | 0x810e1d91a0ab21d3ae15735fc9e240bb1cdf3f252dcf1d2c49dd8c78239a7518 | 0x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1 |
| 0xdc02781bd75fa9102e00440a7e6176985430074d | 0x1a899be2a7b69e47860eeeabaa6d06ebd9e82b00 | 0 | false | 0x354a6da3fcde098f8389cad84b0182725c6c91de | 31200000000000000 | 10 | 276863550 | 2024-11-21T17:56:39.000Z | 0x5b940cd757e19e4bfdec7fe5fc025a88332a8c9dfb9795408efbcce97b7fad42 | 0x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1 |
| 0xfbbcbb87f982ce7c3b46959ec5aaf2b3d892cd0d | 0x1a899be2a7b69e47860eeeabaa6d06ebd9e82b00 | 0 | false | 0x354a6da3fcde098f8389cad84b0182725c6c91de | 31200000000000000 | 174 | 276763453 | 2024-11-21T10:57:18.000Z | 0x2aa5a4427cf2a4f51fe3477f97fd7b32940103c0e1a09c2592615e2d5c7e5272 | 0x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1 |
Example Query
Example Query
Query with partition filter
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
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
Sample Data
| in_to | address | in_rake | removed | in_amount | log_index | block_number | block_timestamp | transaction_hash | in_rakePayoutAddress |
|---|---|---|---|---|---|---|---|---|---|
| 0x7cfe310b31c71c45a8141326cb73f7e248a42bd1 | 0x23e1c72d455243c108aa810ee03bad442f25fc0b | 0 | false | 10000000000000 | 3 | 194720236 | 2024-03-27T10:37:31.000Z | 0xc8159958655d7b8f665222d5dd5e7cb5b5cfbb047b874b5082839d10df22b557 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d |
| 0xa60cd6fb8e3f96fa3a5b296a62024ebaeba588c1 | 0x23e1c72d455243c108aa810ee03bad442f25fc0b | 0 | false | 10000000000000 | 3 | 194735799 | 2024-03-27T11:42:25.000Z | 0xcf09db7ba617252c5b956d06b7ada220fe44d733e97bdebbbb335ef45c4bd7d1 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d |
| 0x7084b2a1637f5a0535dbb9e272e8b7c02a69e308 | 0xe1e23406751be4fb099eb893b802039109ee1f81 | 0 | false | 1450000000000000000 | 0 | 334118721 | 2025-05-07T07:34:14.000Z | 0xd9bf7eefeccad3d9c334d4333eb5676f4ecaeec9743dc0a74d761ba2c213cd83 | 0x39e310f6b6b3eb13ba436cf75bf9ed7056ec9bb1 |
Example Query
Example Query
Query with partition filter
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.Columns
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_previousOwner | STRING | Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. |
in_newOwner | STRING | Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | removed | log_index | in_newOwner | block_number | block_timestamp | in_previousOwner | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x8213e34e5427b23c3db5ef9f72b352997b35fd55 | false | 31 | 0xeda4b295c53412c3c78b8cbc64685bb92b2347e9 | 221486619 | 2024-06-13T17:03:51.000Z | 0x0000000000000000000000000000000000000000 | 0xf8cf89241ca7a1b65e37fb5dd80eb1ce0b02670927199050ab753d6bbc82b0ac |
Example Query
Example Query
Query with partition filter
Escrow_TokenPayout_event
No description available.Columns
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
Sample Data
No sample data available.
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
Sample Data
| address | removed | in_token | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x8213e34e5427b23c3db5ef9f72b352997b35fd55 | false | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 11 | 221487366 | 2024-06-13T17:06:56.000Z | 0xb596dee192c49503611f84918b4b9b68fc86e757d2a1f6cabc98bc2edad76de5 |
| 0x8213e34e5427b23c3db5ef9f72b352997b35fd55 | false | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 76 | 221487262 | 2024-06-13T17:06:30.000Z | 0xe26c69f3af150e97570caad39a1e73c69b8f885ef144e4f1fe44bc24bc8266ce |
| 0x8213e34e5427b23c3db5ef9f72b352997b35fd55 | false | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 1 | 221487441 | 2024-06-13T17:07:15.000Z | 0x5f5d8639eb82e2b863aa0257f068d1d8b2ca6724c5d5bfad50bd5c7857b5a7ef |
Example Query
Example Query
Query with partition filter
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
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
Sample Data
| address | removed | log_index | in_questId | block_number | in_registror | block_timestamp | in_escrowAddress | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x5e2b297016d41055876ff1078100c548adc3a498 | false | 12 | 17131643359184528086159192808435761136 | 228343629 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d | 2024-07-03T13:41:53.000Z | 0x3e5129b8818999f5b9704ee0b1574282d0013b6c | 0xb7484c8222fc1cb9b37915b973424f6de2a0368dc9f6f07bb3904b4c22a9f8f8 |
| 0x5e2b297016d41055876ff1078100c548adc3a498 | false | 6 | 236884246845649892705196028950183388161 | 228352505 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d | 2024-07-03T14:19:08.000Z | 0xc3dac81a86651ecc6eac25c3d47f820bb39014e0 | 0x5f32e18bb1a81f714fede319bf8146179e88a6653c0a231b4da7b1d0eebb2eef |
| 0x5e2b297016d41055876ff1078100c548adc3a498 | false | 9 | 256773471738149825537430003212708847846 | 256525653 | 0x1796a56b5446a4d7d32914aa645ba1d3730ae81d | 2024-09-23T13:12:25.000Z | 0x818e78463043b0ec220ac6f956d4809c3027ee59 | 0xafdc724fdee5851ba19454597dcff560ee39a647c44a935f09fe8e9fa19cc49b |
Example Query
Example Query
Query with partition filter
Pool_TokenPayout_event
No description available.Columns
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
Sample Data
No sample data available.
Example Query
Example Query
Query with partition filter