Raw
Tokens
Table Columns
Unique Key:
| Column Name | Data Type | Description |
|---|---|---|
| token_id | VARCHAR | Unique identifier for the token |
| name | VARCHAR | Name of the token |
| symbol | VARCHAR | Symbol/ticker of the token |
| type | VARCHAR | Type of token (FUNGIBLE_COMMON, NON_FUNGIBLE_UNIQUE) |
| memo | VARCHAR | Memo attached to the token |
| expiry_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the token expires |
| auto_renew_period | BIGINT | Auto-renewal period in seconds |
| auto_renew_account | VARCHAR | Account ID for auto-renewal |
| freeze_default | BOOLEAN | Whether new accounts are frozen by default |
| pause_status | VARCHAR | Current pause status of the token |
| treasury_account_id | VARCHAR | Account ID of the token treasury |
| deleted | BOOLEAN | Whether the token has been deleted |
| created_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the token was created |
| modified_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the token was last modified |
| total_supply | VARCHAR | Total supply of the token |
| initial_supply | VARCHAR | Initial supply when the token was created |
| max_supply | VARCHAR | Maximum supply of the token (0 for unlimited) |
| supply_type | VARCHAR | Type of supply (FINITE, INFINITE) |
| decimals | BIGINT | Number of decimal places for the token |
| metadata | VARCHAR | Metadata associated with the token |
| custom_fees | VARIANT | Custom fee schedule for the token |
| admin_key | VARIANT | Admin key for the token |
| kyc_key | VARIANT | KYC key for the token |
| freeze_key | VARIANT | Freeze key for the token |
| wipe_key | VARIANT | Wipe key for the token |
| supply_key | VARIANT | Supply key for the token |
| fee_schedule_key | VARIANT | Fee schedule key for the token |
| pause_key | VARIANT | Pause key for the token |
| metadata_key | VARIANT | Metadata key for the token |
| expiry_timestamp_raw | DECIMAL(29,9) | Raw expiry timestamp as decimal |
| created_timestamp_raw | DECIMAL(29,9) | Raw created timestamp as decimal |
| modified_timestamp_raw | DECIMAL(29,9) | Raw modified timestamp as decimal |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |