layer3_v1_polygon

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	421	0x5e95bdf823b6106316aa817fe54979c2d760f310	121250738841773363112517419778590968719	119622	54778190	13644	2024-03-17T20:36:35.000Z	0x5f1ef4cc46e1a4195fac01e30ae6b806369d07e4af3fbe0890a03cc472bfc1cc
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	302	0x38684229f6e57fe593e1899c099f49b41696fa58	154634951572282381658295613488067349716	118631	54762516	15935	2024-03-17T10:21:05.000Z	0x32595c3bc2c3e9ce89f9096af32c2305b2ebf6319e2dcb2535e93802c7ac2de5
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	343	0x31bbc2d5eb67ba9b94a7f0ea2c462dd6efb98dd6	20520265923319323843168814237427686899	119073	54768860	15015	2024-03-17T14:27:50.000Z	0xa6ff52e7559410e70fe793650d594d694c35544cebb75ff20a0835ca805246ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_polygon.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	24040000000000000000	360	137	56249339	3	417900	2024-04-25T20:17:57.000Z	0x0000000000000000000000000000000000000000	0x0455869c119c8224ed837c3d9615e2978ca87823a78b10c255508f813f770dc2
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	24040000000000000000	387	137	56253281	3	420020	2024-04-25T22:48:49.000Z	0x0000000000000000000000000000000000000000	0xe243f1e70bba901506c318820881d7a9d335e0ead488ba33e2aa0f5df152e7dd
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	24040000000000000000	384	137	56239631	3	411623	2024-04-25T14:11:16.000Z	0x0000000000000000000000000000000000000000	0xa84d96c2c6a4575c97cc8006eba28af4a3a8db418266ba01d33a21b7baf9186f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_polygon.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
0x29a3c67f2a4a50250342d23748beed0c19349605	0xa9c84f9fb489f11c8ef3717a0d2b736d998aa3e1	false	0xbbba073c31bf03b8acf7c28ef0738decf3695683	3000000000000000000	141	59720551	2024-07-23T18:19:47.000Z	0x88889036e287f61b00ec346d869b0fbbda2705a6564c25e1031ff3945d3c240e	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0x59c530055daaf3bc8216570897d0957481319ae4	0x90c21bf91c3e0cdea47d520796df8011834f4ed8	false	0xbbba073c31bf03b8acf7c28ef0738decf3695683	10000000000000000000	245	66887349	2025-01-19T11:34:57.000Z	0x043eae5f6a4fd9ec4ac93146f56ef930bbf12e939a8f6828839791c8bb03a7fa	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0x33e921d9ee1821e174a4f9d786dc067fee0b6275	0x878dcb165c11351a25c02287a4f9d7a3d8d9e41a	false	0x3d2bd0e15829aa5c362a4144fdf4a1112fa29b5c	100000000000000000000	2184	68772367	2025-03-07T21:51:29.000Z	0x57896c3dcb530d54b861e3254f8acb233494932ca12ec5c10c9b5b8cf37b137a	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d

Example Query

Query with partition filter

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

in_to	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_rakePayoutAddress
0x1930b7f236d94e872a0b9ded104ba092d85a3856	0xb4d9034a7313ea87697dbcc3fb0b49a625770156	false	24040000000000000000	269	55921048	2024-04-17T08:11:39.000Z	0x6ef343d6e2a9d56132cca42d49b459fe16d668d17f8dd27a71ea2ef63b53ac8c	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0xe37af946bd4ef7de4024a8cc3f765f4501c3f51e	0xb4d9034a7313ea87697dbcc3fb0b49a625770156	false	24040000000000000000	237	55920836	2024-04-17T08:03:15.000Z	0x4a55658c6d16faaf9fb83af7e6bebc9aceaf36df4e8b2e4cc713acdebb1d4a1f	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d
0x7ea74516e7d801cd5267e2b6b4f456b5bb75b267	0xc4f49502383858485611aa6126f4de0a22c95e3d	false	3750000000000000000	502	55944561	2024-04-17T22:44:23.000Z	0x6c55d0e592a519fd0a5b3bf8cd56e25abf16a33cf2da1cd28b735b295724b7dc	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_polygon.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_polygon.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	3652	136881024680508679757053686042129176055	57868684	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-06-07T09:25:59.000Z	0xc4f61443b975399748b85c087f1f096ca47553fc	0xf952438b74843cde91b04e6534a0dc6646a99b4b1182d17075f86293af752794
0x5e2b297016d41055876ff1078100c548adc3a498	false	232	185644678695309659346058904048927455363	57884455	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-06-07T19:05:34.000Z	0x48615f13b88de243f3f6c39a0b4dbe07158b0407	0xa6a6c35fcab8b584a2ea709ca4e72d3750418fa3e1e126831daa8d2ca07f3927
0x5e2b297016d41055876ff1078100c548adc3a498	false	370	252422070427012014174693217765328975837	57789370	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-06-05T08:10:24.000Z	0xea84e6aac8371966ddb026a44cc857d0d2a77f0d	0x9a0b2773311011a20eda00d7018dbcfe88514cadc8a048e40e983455a35bcfae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_polygon.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_polygon.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