> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# uniquenetwork_v1_uniquenetwork
> Tables in tt-contracts.uniquenetwork_v1_uniquenetwork
## 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.
| 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` | `STRING` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_version` | `STRING` | Version identifier for the contract or event schema. String or integer value indicating the initialization or state version. |
| `in_item_id` | `STRING` | Marketplace listing identifier for the purchased item. References a unique item listing within the Market contract, used to track individual sale offers. |
| `in_item_collectionId` | `STRING` | Collection identifier of the NFT being purchased in this marketplace transaction. Numeric string representing the Unique Network collection ID containing the traded token. |
| `in_item_tokenId` | `STRING` | Token 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_amount` | `STRING` | Quantity 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_price` | `STRING` | Purchase 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_currency` | `STRING` | Currency 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_eth` | `STRING` | Ethereum 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_sub` | `STRING` | Substrate-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_salesAmount` | `STRING` | Total 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_eth` | `STRING` | Ethereum 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_sub` | `STRING` | Substrate-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_royalties` | `STRING` | Array 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%). |
| address | removed | log\_index | in\_item\_id | in\_version | block\_number | in\_buyer\_eth | in\_buyer\_sub | in\_royalties | in\_item\_price | in\_item\_amount | in\_salesAmount | block\_timestamp | in\_item\_tokenId | in\_item\_currency | transaction\_hash | in\_item\_seller\_eth | in\_item\_seller\_sub | in\_item\_collectionId |
| ------------------------------------------ | ------- | ---------- | ------------ | ----------- | ------------- | ------------------------------------------ | ------------------------------------------------------------------------------ | ------------- | ---------------------- | ---------------- | --------------- | ------------------------ | ----------------- | ------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------------------------------------------ | ---------------------- |
| 0x7cccb70061c2725b9a64b13c95f78500d2b3b382 | false | 7 | 1671 | 0 | 9674079 | 0x0000000000000000000000000000000000000000 | 111401637116739510678877020749864733709215241230583814420385782705832648104205 | | 300000000000000000000 | 0 | 1 | 2025-10-10T20:59:18.000Z | 1053 | 0 | 0xc438411785c545d1adf4378e1468bb4c166626bd7442cc24e20fd8c79d47dec4 | 0x0000000000000000000000000000000000000000 | 111678530041303028780083637775615290392487105097794758600469056735792386207271 | 3776 |
| 0x7cccb70061c2725b9a64b13c95f78500d2b3b382 | false | 7 | 1623 | 0 | 9671423 | 0x0000000000000000000000000000000000000000 | 111401637116739510678877020749864733709215241230583814420385782705832648104205 | | 1000000000000000000000 | 0 | 1 | 2025-10-10T16:29:54.000Z | 1932 | 0 | 0x407390060a1e2bafe160bd5939321a2f54f097c27e87b53941fa5bff9b42a306 | 0x0000000000000000000000000000000000000000 | 3654308887699082403031844140231168342201341153159907164949269223266719800158 | 3776 |
| 0x7cccb70061c2725b9a64b13c95f78500d2b3b382 | false | 10 | 1537 | 0 | 9670101 | 0x0000000000000000000000000000000000000000 | 111401637116739510678877020749864733709215241230583814420385782705832648104205 | | 10000000000 | 0 | 1 | 2025-10-10T14:15:42.000Z | 1140 | 437 | 0x1496abd101743f2f7f2cc0eefff48103f91db385dcfedc698210120af8d3903f | 0x0000000000000000000000000000000000000000 | 62615379695895582161321607454638451949749663810326986413374894247476576080229 | 3776 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.uniquenetwork_v1_uniquenetwork.Market_TokenIsPurchased_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***