layer3_v1_blast

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
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	15	0x0d7b8029c42b689bdb4eab54c1474107291cba6d	297144329310726437127924300932025762914	686580	6166871	17057	2024-07-16T15:25:57.000Z	0x089a326607fe5f6076707584f6945403f48b599a58bf11aa784f2cc92f476f6b
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	28	0x115c01908b23eea95b71f00371b096bb336d22b8	105795045920438793608381949445357332190	686011	6160950	22190	2024-07-16T12:08:35.000Z	0xbdbe0b40bac9a8eb7a83bf2b33295daec3fa1eed837de29a32817bf1a9e4b7ad
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	20	0x115c01908b23eea95b71f00371b096bb336d22b8	208469309330635037757585872995775340423	685932	6160559	15476	2024-07-16T11:55:33.000Z	0xd88c81191a0a9b7503023238380e2e4a197350ea45dc16d8a744595e5be660bd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_blast.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	1632765000000000000000	28	81457	10865328	767374	2024-11-02T09:41:11.000Z	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	0xdac5f26ac7199b10fea5a4b965a206d05ff67e860732cde0c54e714fd6151be8
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	1632765000000000000000	32	81457	10032824	764189	2024-10-14T03:11:03.000Z	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	0x14c9110a4a6d0e934195f844a750892c94c4b2ce255e649a23b2a6a5663975dc
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	1632765000000000000000	14	81457	10029894	764181	2024-10-14T01:33:23.000Z	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	0x6f72d7880c7b478780f2def24f41c5457a194c7abb8979e9f52eb80c976be06d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_blast.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
0xd31a84c20bc430ad75e6a1903e7ddbee52211072	0x6cf0c14e691f718cd1d5a0ce2185d5c4cdde75b0	false	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	1632765000000000000000	3	9963423	2024-10-12T12:37:41.000Z	0x1da2e91c9422e44341ac4dc1979d90516e9fb3639f4a814dedf13784a264f87a	0x8495f22aa4c93e50f46250e25bb257d5d25ae984
0x1495d3a454eb1301a0b4530176099456639ef110	0x6cf0c14e691f718cd1d5a0ce2185d5c4cdde75b0	false	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	1632765000000000000000	16	9967945	2024-10-12T15:08:25.000Z	0xa531e9a1547c067f5fcdcee1c7d3ff3b95d87de9465e59fda420d6f9a995320f	0x8495f22aa4c93e50f46250e25bb257d5d25ae984
0xea3e579da60cdb97f3870f862af5db982c0ea08c	0x6cf0c14e691f718cd1d5a0ce2185d5c4cdde75b0	false	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	1632765000000000000000	7	9949201	2024-10-12T04:43:37.000Z	0xcda272d2fb63a53b17b709c819fbf209583fe17f30ad5242f3e260acee5a08f4	0x8495f22aa4c93e50f46250e25bb257d5d25ae984

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_blast.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_blast.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_blast.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	1	194848284990963689944409816531810528627	9837961	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-10-09T14:55:37.000Z	0x6cf0c14e691f718cd1d5a0ce2185d5c4cdde75b0	0x2b8fb4338502c27c37734ac49541e26d6d6dd57c26fa59293e40f4bcca7a2622

Example Query

Query with partition filter

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