> ## 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" />