Table Details
| Property | Value |
|---|---|
| Table Name | stellar.prices.hourly_beta |
| Table Status | Production-Ready |
| Unique Key | address, timestamp |
| Clustering Key(s) | timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| timestamp | TIMESTAMP_NTZ(9) | Hour bucket (UTC) this price applies to. |
| chain | VARCHAR(16777216) | Blockchain slug for this row (stellar). |
| address | VARCHAR(16777216) | Token or asset identifier this price applies to. |
| symbol | VARCHAR(16777216) | Ticker symbol of the token. |
| price | VARCHAR(16777216) | USD price per unit of the token. |
| decimals | NUMBER(38,0) | Number of decimal places for this token. |
| id | VARCHAR(16777216) | Unique identifier for this price row. |
| source | VARCHAR(16777216) | Origin data source that produced this price. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |