> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Unshielded UTXOs

> Midnight unshielded UTXO data

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

# Table Description

This table tracks unshielded (public) UTXOs on Midnight, including create/spend transactions, owner, token type, and value.

## Column Descriptions

| Column Name | Data Type | Description |
| - | - | - |
| **id** | bigint | Internal UTXO identifier. |
| **creating\_transaction\_id** | bigint | Transaction that created the UTXO. |
| **spending\_transaction\_id** | bigint | Transaction that spent the UTXO (null if unspent). |
| **owner** | varchar | Owner address of the UTXO. |
| **token\_type** | varchar | Token type held by the UTXO. |
| **value** | decimal(38,0) | Token amount held by the UTXO. |
| **intent\_hash** | varchar | Intent hash associated with the output. |
| **output\_index** | bigint | Output index within the creating transaction. |
| **ctime** | bigint | Creation time of the UTXO (network time representation). |
| **initial\_nonce** | varchar | Initial nonce for the UTXO. |
| **registered\_for\_dust\_generation** | boolean | Whether the UTXO is registered for DUST generation. |
| **\_updated\_at** | timestamp | Timestamp when this record was last updated. |
| **\_ingested\_at** | timestamp | Timestamp when this record was ingested into Dune. |

## Table Sample

<TableSample tableSchema="midnight" tableName="unshielded_utxos" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.