external.avalanche Table: fact_utxos Type: View
What
Avalanche UTXOs. Please visit https://discord.gg/avax for any questions.Columns
| Column Name | Data Type | Description |
|---|---|---|
| UTXO_ID | TEXT | Unique identifier for the UTXO |
| TRANSACTION_HASH | TEXT | Transaction hash associated with the UTXO |
| BLOCK_INDEX | NUMBER | Index of the block where the UTXO was created |
| OUTPUT_INDEX | NUMBER | Ordering of the UTXOs within a transaction |
| TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the UTXO was created |
| TX_TYPE | TEXT | Type of transaction that generated the UTXO |
| OUTPUT_TYPE | TEXT | OUTPUT_TYPE column |
| ADDRESS | TEXT | Blockchain address associated with the UTXO |
| CONSUMING_TRANSACTION_HASH | TEXT | Transaction hash that consumed the UTXO |
| ASSET_ID | TEXT | Asset identifier associated with the UTXO |
| LOCKTIME | NUMBER | LOCKTIME column |
| THRESHOLD | NUMBER | THRESHOLD column |
| PUBLIC_KEY | TEXT | PUBLIC_KEY column |
| SIGNATURE | TEXT | SIGNATURE column |
| AMOUNT | NUMBER | Amount of the asset stored in the UTXO |
| GROUP_ID | NUMBER | GROUP_ID column |
| PAYLOAD | TEXT | Additional payload data associated with the UTXO |
| FX_ID | TEXT | FX_ID column |
| CREATED_ON | TEXT | Blockchain ID on which the UTXO was created |
| CONSUMED_ON | TEXT | Blockchain ID on which the UTXO was consumed |
| PLATFORM_LOCKTIME | TIMESTAMP_NTZ | PLATFORM_LOCKTIME column |
| STAKED | BOOLEAN | STAKED column |
| STAKEABLE_LOCKTIME | TIMESTAMP_NTZ | STAKEABLE_LOCKTIME column |
| REWARD | BOOLEAN | Indicates if the UTXO was part of a staking reward |
| LAST_UPDATED | TIMESTAMP_NTZ | LAST_UPDATED column |
| LOAD_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when data was loaded into Snowflake |
| CONSUMING_TRANSACTION_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the UTXO was consumed |
| STAKING_START_TIME | TIMESTAMP_NTZ | Start time for staking period |
| STAKING_END_TIME | TIMESTAMP_NTZ | End time for staking period |
| NODE_ID | TEXT | Validator node ID associated with staking UTXOs |
| REWARD_ADDRESSES | VARIANT | List of addresses receiving staking rewards |
| CONSUMING_BLOCK_HEIGHT | NUMBER | Block height at which the UTXO was consumed |