Table Details
| Property | Value |
|---|---|
| Table Name | ton.prices.hourly |
| Table Status | Production-Ready |
| Unique Key | timestamp, uf_address |
| Clustering Key(s) | timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. |
| utime | TIMESTAMP_NTZ(9) | Unix timestamp of the transfer. |
| uf_address | VARCHAR(16777216) | User-friendly TON address representation with workchain prefix (e.g., EQA…) as opposed to the raw hex or base64 format. |
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| price | FLOAT | Price per unit of the asset at the time of this event, in USD or in the quote token’s units depending on context. |
| _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. |