crosschain.core Table: fact_hourly_prices Type: View
What
A dimension table holding provider specific asset metadataColumns
| Column Name | Data Type | Description |
|---|---|---|
| PROVIDER | TEXT | provider of the data |
| ID | TEXT | unique identifier representing the asset |
| RECORDED_HOUR | TIMESTAMP_NTZ | opening hour of price data |
| OPEN | FLOAT | open price of asset for hour |
| HIGH | FLOAT | high price of asset for hour |
| LOW | FLOAT | low price of asset for hour |
| CLOSE | FLOAT | close price of asset for hour |