decentralgames_v1_polygon

Tables

ERC721CollectionV2_Issue_event

NFT minting events from Decentral Games ERC-721 collections on Polygon, tracking issued token IDs, item types, caller addresses, and beneficiary recipients. Used for analyzing NFT issuance patterns and distribution across different collection items.

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__beneficiary`	`STRING`	Address that received the newly minted NFT from this issuance event. Hex-encoded, 0x-prefixed 40-character Ethereum address on Polygon.
`in__tokenId`	`STRING`	Unique identifier for the NFT (Non-Fungible Token) within its contract. String-encoded integer value.
`in__itemId`	`STRING`	Template identifier for the type of NFT being issued in the collection. Numeric string that categorizes different item types within the Decentral Games ERC721 collection.
`in__issuedId`	`STRING`	Sequential identifier assigned to the newly minted NFT within the collection’s issuance system. Increments with each Issue event and serves as the collection-specific token counter distinct from the global tokenId.
`in__caller`	`STRING`	Address of the account that initiated the function call which emitted the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in__caller	in__tokenId	block_number	in__issuedId	block_timestamp	in__beneficiary	transaction_hash
0xb854bf4d15be8e1f9b38e8b6af7d3283b81edfd8	false	158	0x966dc1f18d8a870550b3addc52b5493f7df6ca44	6002	42148890	6002	2023-04-30T20:10:59.000Z	0x86cdd7265e3785793c5330702c2003d64b2ced67	0x94695a143170bcbbca03a895a11a07fe6706cfc1ff8779d9c7069c7953ca7e8c
0xb854bf4d15be8e1f9b38e8b6af7d3283b81edfd8	false	305	0xc9a67ed1472a76d064c826b54c144ca00dae4015	6003	42154449	6003	2023-04-30T23:32:00.000Z	0x6f0c3711e9e2dc33cd8f34e806a7805f1f1b9185	0x207ef86b944207ff06deb3a2dd87f16255c202a25a8ca446b804172d7aeb5009
0xb854bf4d15be8e1f9b38e8b6af7d3283b81edfd8	false	470	0xc9a67ed1472a76d064c826b54c144ca00dae4015	6001	42126400	6001	2023-04-30T06:32:51.000Z	0x7100ca50cc8f8f01cb43ee4e34ea15e7065fd537	0x0443bb6f3fb47f262012b84189e5acefe8bfe140500c49643d12f4f79c51fba5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.decentralgames_v1_polygon.ERC721CollectionV2_Issue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

IceCleaner_Purchased_event

In-game purchase events from Decentral Games IceCleaner contract on Polygon, tracking player spending of points to acquire NFT tokens. Used for analyzing virtual economy activity and player engagement within the Decentral Games ecosystem.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_playerAddress`	`STRING`	Polygon wallet address of the player who made the purchase in the Decentral Games IceCleaner contract. Hex-encoded, 0x-prefixed 40-character string representing the buyer’s account.
`in_pointsAmount`	`STRING`	Amount of points spent by the player to purchase the IceCleaner item in Decentral Games. Represented as a string-encoded integer, typically showing values around 105 points per transaction.

Sample Data

address	removed	log_index	in_tokenId	block_number	block_timestamp	in_pointsAmount	in_tokenAddress	in_playerAddress	transaction_hash
0x470517a0c1a9124188e87d359acebbefbe3ffd23	false	84	212	41761339	2023-04-20T21:27:13.000Z	105	0x40519b3aebc58a489d576962a02efca7497faf44	0x3d3f7bae7f52e490ea5b7e1597041fd2f8db7efe	0xe0da4cc9250f5a20d964aaa5c065ea4bc3d9d0f3b84aa09e70ce255b7d0fc2c1
0x470517a0c1a9124188e87d359acebbefbe3ffd23	false	259	212	41761365	2023-04-20T21:28:09.000Z	105	0x40519b3aebc58a489d576962a02efca7497faf44	0x3d3f7bae7f52e490ea5b7e1597041fd2f8db7efe	0xd80e6491ba6b959f3480a571ed4fdf4ba10b764cccf007f9a74a057108e51830
0x470517a0c1a9124188e87d359acebbefbe3ffd23	false	229	212	41761311	2023-04-20T21:26:13.000Z	105	0x40519b3aebc58a489d576962a02efca7497faf44	0x3d3f7bae7f52e490ea5b7e1597041fd2f8db7efe	0x2b4b45dca577e8a9dacb9cb4572362b5a15f9451bf12c2ca26fad55eabb2f02d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.decentralgames_v1_polygon.IceCleaner_Purchased_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

IceRegistrant_IceLevelTransfer_event

ICE token level transfer events from Decentral Games protocol on Polygon, tracking ownership changes of ICE NFT levels between accounts. Used to analyze player progression, level trading activity, and account interactions within the Decentral Games metaverse ecosystem.

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_oldOwner`	`STRING`	Address of the previous owner before 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.
`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.

Sample Data

address	removed	log_index	in_tokenId	in_newOwner	in_oldOwner	block_number	block_timestamp	in_tokenAddress	transaction_hash
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	111	2527495000045372480750032664408090375653482289613178670103463460878	0x46d5e2f151cd9c11bf32ca6b87ca1f65ed400fa4	0xf5fdaa91b9bcbbde2e3626e4c4c817b34bd796f9	39965624	2023-03-04T19:42:09.000Z	0xa67e3d65588c6760da6a4e7e6c2319dfb24c0ab0	0xb571a239483d6256334334d04caf4d87a7e2b10586916e05f5871ba284d00d4f
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	176	1579684375028357800468770415255056484783426431008236668814664663045	0x613e052555ac74ff6af0fc64e40e8035c1e9dcf8	0xeb03c497e7f692bf1a4f1e6a47c9eaed27aa4b7e	39935397	2023-03-04T00:17:43.000Z	0xa67e3d65588c6760da6a4e7e6c2319dfb24c0ab0	0x973f9423ae4e1fad5f57a2d98b1035f74e5fb24b4663b55bbe5716db3061554b
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	175	8	0x613e052555ac74ff6af0fc64e40e8035c1e9dcf8	0xeb03c497e7f692bf1a4f1e6a47c9eaed27aa4b7e	39935456	2023-03-04T00:19:49.000Z	0xa67e3d65588c6760da6a4e7e6c2319dfb24c0ab0	0x18e4e1632a498b35cd59128a07a72a4bb8aeff6d290dcdf07b0c00e498a9b8f8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.decentralgames_v1_polygon.IceRegistrant_IceLevelTransfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

IceRegistrant_InitialMinting_event

Initial NFT minting events from Decentral Games’ ICE token registrant contract on Polygon, tracking token IDs, owner addresses, and cumulative mint counts. Used for analyzing NFT distribution patterns and minting activity in the Decentral Games ecosystem.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_mintCount`	`STRING`	Number of tokens minted in the batch operation. Numeric string representation of the mint quantity.
`in_tokenOwner`	`STRING`	Polygon address of the wallet that received the initially minted token. Hex-encoded, 0x-prefixed 40-character string representing the NFT recipient.

Sample Data

address	removed	log_index	in_tokenId	block_number	in_mintCount	in_tokenOwner	block_timestamp	transaction_hash
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	344	26362	51924849	101448	0x05e5bb138250761974b5674c8125a11dba9fc8a5	2024-01-04T09:42:23.000Z	0xcbd907e2b822ee2cec6563d3a564c81fed86d4285cf80a459f695a55ec793c14
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	102	2522	51922741	101446	0x0969c7e120de4c5906ca84b69e4a8b8db0ccdf80	2024-01-04T08:23:12.000Z	0x4cdc7d8630eab17f0c3fe120e300f9071d6acbf233dd4dbfda70e4e7a1eface2
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	271	1053122916685571866979180276836704323188950954005491112543109778545	51929459	101466	0x0969c7e120de4c5906ca84b69e4a8b8db0ccdf80	2024-01-04T12:38:41.000Z	0x6bb9648b94665cd5272749acb680110b62b1d1a84e09443530ae2e4301376c0e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.decentralgames_v1_polygon.IceRegistrant_InitialMinting_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

IceRegistrant_UpgradeItem_event

Item upgrade events from Decentral Games’ ICE (Poker) gaming protocol on Polygon. Records when players enhance NFT wearables and game items with owner addresses, item identifiers, and sequential request tracking for analyzing in-game progression mechanics.

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_itemId`	`STRING`	Identifier of the specific item type being upgraded in the Decentral Games Ice Registrant system. Numeric string values ranging from 0 to 20 indicate different upgrade item categories.
`in_issuedId`	`STRING`	Unique identifier assigned to this specific upgrade item issuance within the Decentral Games ICE system. Incrementally assigned numeric value that tracks individual item instances as they are upgraded.
`in_tokenOwner`	`STRING`	Polygon address of the wallet that owns the token being upgraded in this Decentral Games ICE event. Value is null when the owner address is not applicable to the upgrade transaction.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_requestIndex`	`STRING`	Sequential identifier for the upgrade request within the Decentral Games ICE system. Incrementing numeric value used to track individual item upgrade operations in chronological order.

Sample Data

address	removed	in_itemId	log_index	in_tokenId	in_issuedId	block_number	in_tokenOwner	block_timestamp	in_requestIndex	in_tokenAddress	transaction_hash
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	10	43	1053122916685571866979180276836704323188950954005491112543109775441	81	29580293	0x45338bf3dcf0c55a3a6b1404b78e39cbe1f5105b	2022-06-15T02:07:04.000Z	21766	0x09eeac7dff0dc304e25cbb7bdbfae798488fc34f	0xd2ddd290d8eb2a3493040b6872041a4211c62ce3fb8b5f7e0d42a4a44d5b20f7
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	1	214	105312291668557186697918027683670432318895095400549111254310977708	172	29582830	0x683448da31066365f2b9ea8b8acba4245ca6bcd1	2022-06-15T03:44:58.000Z	21773	0x09eeac7dff0dc304e25cbb7bdbfae798488fc34f	0x6a2eaa531504fd28b58ed0e0c8201578908ff0426e345ac5d97aa53d5e1aa86d
0xc9a67ed1472a76d064c826b54c144ca00dae4015	false	11	93	1158435208354129053677098304520374755507846049406040223797420753068	172	29580359	0x45338bf3dcf0c55a3a6b1404b78e39cbe1f5105b	2022-06-15T02:09:20.000Z	21767	0x09eeac7dff0dc304e25cbb7bdbfae798488fc34f	0x518f4e889d8ce295850cfd10cb1c25fdde024ee98babe8791dff981b5d4db1d0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.decentralgames_v1_polygon.IceRegistrant_UpgradeItem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ERC721CollectionV2_Issue_event

IceCleaner_Purchased_event

IceRegistrant_IceLevelTransfer_event

IceRegistrant_InitialMinting_event

IceRegistrant_UpgradeItem_event

​Tables

​ERC721CollectionV2_Issue_event

​IceCleaner_Purchased_event

​IceRegistrant_IceLevelTransfer_event

​IceRegistrant_InitialMinting_event

​IceRegistrant_UpgradeItem_event

Tables

ERC721CollectionV2_Issue_event

IceCleaner_Purchased_event

IceRegistrant_IceLevelTransfer_event

IceRegistrant_InitialMinting_event

IceRegistrant_UpgradeItem_event