layer3_v1_optimism

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	in_walletProvider
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	256	0xa2b6de094dfa2c76af937c423516141a8f8082db	36792512294987176463765543311239681721	4177837	128895369	25371	2024-12-05T09:05:15.000Z	0x3a4828495c6f6e2bad31212d16b1677d9f9bc9f720cc553ce586a307a479565d
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	256	0xf72e10ba10c78b845e63328f83ae3623bb525618	180401183682168332044487389210809239263	4199872	128917033	3093	2024-12-05T21:07:23.000Z	0xeaf9dd7ac7565ae2fcba5d40f7409870afe875f33c933ebdd3b7e5066cf10bf1	Rabby Wallet
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	256	0x8cda53f8bde8d225ecc4400704c168538c27e2f2	180401183682168332044487389210809239263	4198595	128915549	2825	2024-12-05T20:17:55.000Z	0x7339fc26fd8495a488724ede0cef4dfc3749b6b0876410c88692f02a43a1e10a	MetaMask

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_optimism.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	157000000000000000	6	10	121804164	1102265	2024-06-24T05:31:45.000Z	0x4200000000000000000000000000000000000042	0x5f98630be7a4242fe0983069d77f3f5be7fe58f6672b57a3c3a2702d856e7184
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	157000000000000000	6	10	121800149	1101611	2024-06-24T03:17:55.000Z	0x4200000000000000000000000000000000000042	0xd3f07b1a92ed3895a664441d291f66897a26365b1d28dc4d7de1caa276a8e91d
0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7	false	157000000000000000	6	10	121802206	1101886	2024-06-24T04:26:29.000Z	0x4200000000000000000000000000000000000042	0x62f3c5bc995f97f90c5b0867229ac8d32f1314366678cb284e4ac35555bf12e4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_optimism.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
0x60bee18b17fa940f80d2bfdb02ad90f95be1dbe3	0x145113b03dea2e55bcca38a844f2126de21ea6e2	false	0x4200000000000000000000000000000000000042	150000000000000000	32	129824126	2024-12-26T21:03:49.000Z	0x7fd32eb1b29ea742ddc25ea9717e3bea53e5944d8b4af8b3dbedce290a10084b	0x88b3c2d4690390d6fe63fcec984497a3785c6240
0x844402085d052061fac0ee77cf640feb043af4a6	0x1f723f067b0598ddc65ccf2407ed8162460b9e89	false	0x4200000000000000000000000000000000000042	150000000000000000	7	129803190	2024-12-26T09:25:57.000Z	0x040111b2089ca09d671ebe33bfe3f4ea21c028c3827f4e90da85e2bae3a4a5ee	0x88b3c2d4690390d6fe63fcec984497a3785c6240
0x424a5d72b31912e88d1352cd5020763aa92acd31	0x1f723f067b0598ddc65ccf2407ed8162460b9e89	false	0x4200000000000000000000000000000000000042	150000000000000000	9	129793941	2024-12-26T04:17:39.000Z	0x4101e420ff481b9abe30b26737e81c64d83eababeb57e553a466cbb1ccf3ea56	0x88b3c2d4690390d6fe63fcec984497a3785c6240

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_optimism.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
0xdc5db412a626aa3f27b541eed3ad0c71f5f14f77	0x6d507cd9dfe6def70449611e891eccbe17924fdf	false	510000000000000	3	136819389	2025-06-06T19:19:15.000Z	0x727a2f3446c305d0c26afe2526a94f54273a40f0d9598b916e2341e37aae5ae2	0x88b3c2d4690390d6fe63fcec984497a3785c6240
0x676c4f2c77f2ed2cf046f92747af654a1b40aabe	0x6d507cd9dfe6def70449611e891eccbe17924fdf	false	510000000000000	3	136820369	2025-06-06T19:51:55.000Z	0xa7996b8271241adb383cce4b600332713259296f63c5ef4e43f9cf1a3a696ac4	0x88b3c2d4690390d6fe63fcec984497a3785c6240
0x6bb275953d6297261386a8eac44db37e8f278ebf	0x6d507cd9dfe6def70449611e891eccbe17924fdf	false	510000000000000	3	136823427	2025-06-06T21:33:51.000Z	0x9a177e0611796311df12a0999fcdd0024d3bb1d7e347a915a12e14208f5c900a	0x88b3c2d4690390d6fe63fcec984497a3785c6240

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layer3_v1_optimism.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_optimism.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	2	307208752321677135906328287637076536930	118225723	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-04-02T09:30:23.000Z	0x35008f5dc9253140fe5d9e1b2defba7d319e664c	0x83fc36ee70853ecc6df1ffadf669ccd432ea25c4997825ab2bd73611f0d6100d
0x5e2b297016d41055876ff1078100c548adc3a498	false	1	123623148282711728687603095803558117300	118225554	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-04-02T09:24:45.000Z	0x15465a694c4a76a6506c64f6fd76619f13d72ec3	0x66cfac12fcce92285406d44321ed3059d049f64ee4b88e7337ce2db0a1800e61
0x5e2b297016d41055876ff1078100c548adc3a498	false	1	140148127463073916207720657585263128148	118225882	0x1796a56b5446a4d7d32914aa645ba1d3730ae81d	2024-04-02T09:35:41.000Z	0x459fbdc8b4eda47691aabedda980bdf79e7e592a	0xe2cabda8383faaa589150e327b7b6cb817f6f87f9ae221dbe74e145f7706c4dc

Example Query

Query with partition filter

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