Table Description
Contains metadata for native assets on the Cardano blockchain. Each row represents a unique asset identified by its policy ID and token name, and includes off-chain metadata such as display name, ticker, decimals, URL, categories, and latest price information.Column Descriptions
| Column | Description | Type |
|---|---|---|
| policy_id | The hash of the minting policy script governing this asset. | varchar |
| token_name | The on-chain token name (hex-encoded). | varchar |
| name | The human-readable display name of the asset. | varchar |
| url | The URL associated with the asset (e.g., project website). | varchar |
| ticker | The ticker symbol of the asset (e.g., SUNDAE, DJED). | varchar |
| decimals | The number of decimal places used to display the asset’s quantity. | bigint |
| created_at | The timestamp when the asset was first minted. | timestamp |
| categories | An array of categories the asset belongs to (e.g., DeFi, NFT). | array(varchar) |
| price | The latest known price of the asset in USD. | double |
| fetched_at | The timestamp when the metadata was last fetched from external sources. | timestamp |
| _updated_at | The time when this record was last updated. | timestamp |
| _ingested_at | The time when this record was ingested into Dune. | timestamp |