Skip to main content

​
Tables

​
Market_TokenIsPurchased_event

NFT purchase events from Unique Network marketplace contract, tracking token sales with buyer/seller substrate and Ethereum addresses, sale prices in various currencies (collection IDs 3776-3777), and transaction amounts. Used for analyzing NFT trading activity and marketplace volume on Unique Network.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedSTRINGBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_versionSTRINGVersion identifier for the contract or event schema. String or integer value indicating the initialization or state version.
in_item_idSTRINGMarketplace listing identifier for the purchased item. References a unique item listing within the Market contract, used to track individual sale offers.
in_item_collectionIdSTRINGCollection identifier of the NFT being purchased in this marketplace transaction. Numeric string representing the Unique Network collection ID containing the traded token.
in_item_tokenIdSTRINGToken identifier (ID) of the NFT that was purchased within its collection. String-encoded numeric value unique to each NFT in the collection specified by in_item_collectionId.
in_item_amountSTRINGQuantity of items involved in this token purchase transaction. Typically 0 based on sample data, with the actual count appearing in in_salesAmount instead.
in_item_priceSTRINGPurchase price of the token in the smallest unit of the specified currency (e.g., wei for native tokens). Values range from small amounts like 10000000000 to larger sums like 1200000000000000000000.
in_item_currencySTRINGCurrency identifier for the payment token used in this purchase. Typically ‘0’ for native chain tokens or a collection ID for other token standards.
in_item_seller_ethSTRINGEthereum address of the seller in this marketplace token purchase event. This field typically contains the zero address when the seller uses a Substrate-native address instead.
in_item_seller_subSTRINGSubstrate-format address of the NFT seller represented as a 256-bit integer. Used on Unique Network when the seller address is not an Ethereum-compatible address (in_item_seller_eth is null).
in_salesAmountSTRINGTotal number of items sold in this marketplace transaction. Always 1 in the samples, representing single-token purchases on Unique Network’s marketplace contract.
in_buyer_ethSTRINGEthereum address of the token buyer on Unique Network, represented as a hex-encoded, 0x-prefixed 40-character string. May be zero address when buyer is identified via Substrate address format instead.
in_buyer_subSTRINGSubstrate-format buyer address on Unique Network, represented as a large integer identifier. Typically non-zero when the buyer uses a native Substrate account rather than an EVM address.
in_royaltiesSTRINGArray of royalty recipients and their corresponding basis point values. Each struct contains an account address (hex-encoded, 0x-prefixed, 42-character string) and a value (numeric string representing basis points, where 500 = 5%).
addressremovedlog_indexin_item_idin_versionblock_numberin_buyer_ethin_buyer_subin_royaltiesin_item_pricein_item_amountin_salesAmountblock_timestampin_item_tokenIdin_item_currencytransaction_hashin_item_seller_ethin_item_seller_subin_item_collectionId
0x7cccb70061c2725b9a64b13c95f78500d2b3b382false71671096740790x0000000000000000000000000000000000000000111401637116739510678877020749864733709215241230583814420385782705832648104205300000000000000000000012025-10-10T20:59:18.000Z105300xc438411785c545d1adf4378e1468bb4c166626bd7442cc24e20fd8c79d47dec40x00000000000000000000000000000000000000001116785300413030287800836377756152903924871050977947586004690567357923862072713776
0x7cccb70061c2725b9a64b13c95f78500d2b3b382false71623096714230x00000000000000000000000000000000000000001114016371167395106788770207498647337092152412305838144203857827058326481042051000000000000000000000012025-10-10T16:29:54.000Z193200x407390060a1e2bafe160bd5939321a2f54f097c27e87b53941fa5bff9b42a3060x000000000000000000000000000000000000000036543088876990824030318441402311683422013411531599071649492692232667198001583776
0x7cccb70061c2725b9a64b13c95f78500d2b3b382false101537096701010x000000000000000000000000000000000000000011140163711673951067887702074986473370921524123058381442038578270583264810420510000000000012025-10-10T14:15:42.000Z11404370x1496abd101743f2f7f2cc0eefff48103f91db385dcfedc698210120af8d3903f0x0000000000000000000000000000000000000000626153796958955821613216074546384519497496638103269864133748942474765760802293776
Query with partition filter
SELECT *
FROM `tt-contracts.uniquenetwork_v1_uniquenetwork.Market_TokenIsPurchased_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100