PREVIEW / stock_1hour / 2000-02-18
file: by_date/stock_1hour/2000/2000-02-18.parquet size: 278 KB rows: 14,539 symbols: 1,142
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2000-02-18 09:00:00 | AAPL | Stock | 1.0234 | 1.0234 | 1.0128 | 1.0162 | 27496000.0 |
| 2000-02-18 10:00:00 | AAPL | Stock | 1.0173 | 1.0218 | 1.0112 | 1.0206 | 36366400.0 |
| 2000-02-18 11:00:00 | AAPL | Stock | 1.0206 | 1.0279 | 1.0145 | 1.0251 | 17416000.0 |
| 2000-02-18 12:00:00 | AAPL | Stock | 1.0268 | 1.0301 | 1.0167 | 1.0179 | 19297600.0 |
| 2000-02-18 13:00:00 | AAPL | Stock | 1.0212 | 1.0212 | 1.0089 | 1.0106 | 16128000.0 |
| 2000-02-18 14:00:00 | AAPL | Stock | 1.0106 | 1.0131 | 0.9967 | 1.0045 | 30956800.0 |
| 2000-02-18 15:00:00 | AAPL | Stock | 1.0039 | 1.0045 | 0.99 | 0.9939 | 47297600.0 |
| 2000-02-18 16:00:00 | AAPL | Stock | 0.9939 | 0.9939 | 0.9911 | 0.9933 | 1019200.0 |
| 2000-02-18 09:00:00 | MSFT | Stock | 50.0 | 50.0 | 49.3438 | 49.625 | 8395800.0 |
| 2000-02-18 10:00:00 | MSFT | Stock | 49.6875 | 49.875 | 49.2812 | 49.75 | 6710200.0 |
| 2000-02-18 11:00:00 | MSFT | Stock | 49.75 | 50.0312 | 49.4375 | 49.6562 | 6433800.0 |
| 2000-02-18 12:00:00 | MSFT | Stock | 49.6562 | 49.6875 | 49.0 | 49.1875 | 9167400.0 |
| 2000-02-18 13:00:00 | MSFT | Stock | 49.2188 | 49.2188 | 48.3125 | 48.6562 | 8307800.0 |
| 2000-02-18 14:00:00 | MSFT | Stock | 48.6562 | 48.9688 | 47.75 | 48.0 | 10191200.0 |
| 2000-02-18 15:00:00 | MSFT | Stock | 48.0 | 48.0 | 47.4375 | 47.5156 | 17473600.0 |
| 2000-02-18 16:00:00 | MSFT | Stock | 47.5156 | 47.7812 | 47.5 | 47.6875 | 472400.0 |
| 2000-02-18 09:00:00 | NVDA | Stock | 0.124 | 0.1251 | 0.123 | 0.125 | 89904000.0 |
| 2000-02-18 10:00:00 | NVDA | Stock | 0.125 | 0.1273 | 0.125 | 0.1271 | 231696000.0 |
| 2000-02-18 11:00:00 | NVDA | Stock | 0.1271 | 0.1286 | 0.1266 | 0.1279 | 168768000.0 |
| 2000-02-18 12:00:00 | NVDA | Stock | 0.1279 | 0.1289 | 0.1279 | 0.1284 | 99648000.0 |
| 2000-02-18 13:00:00 | NVDA | Stock | 0.1288 | 0.129 | 0.128 | 0.1286 | 33264000.0 |
| 2000-02-18 14:00:00 | NVDA | Stock | 0.1285 | 0.1327 | 0.1279 | 0.1322 | 122448000.0 |
| 2000-02-18 15:00:00 | NVDA | Stock | 0.1323 | 0.1422 | 0.1312 | 0.1383 | 163440000.0 |
| 2000-02-18 16:00:00 | NVDA | Stock | 0.1383 | 0.1404 | 0.1383 | 0.1404 | 3024000.0 |
| 2000-02-18 09:00:00 | AMZN | Stock | 3.4219 | 3.45 | 3.3625 | 3.375 | 12342000.0 |
| 2000-02-18 10:00:00 | AMZN | Stock | 3.3688 | 3.3938 | 3.3 | 3.3406 | 26794000.0 |
| 2000-02-18 11:00:00 | AMZN | Stock | 3.3312 | 3.35 | 3.2562 | 3.2656 | 25444000.0 |
| 2000-02-18 12:00:00 | AMZN | Stock | 3.2656 | 3.2812 | 3.225 | 3.2312 | 29552000.0 |
| 2000-02-18 13:00:00 | AMZN | Stock | 3.2312 | 3.275 | 3.1938 | 3.2688 | 19664000.0 |
| 2000-02-18 14:00:00 | AMZN | Stock | 3.2688 | 3.275 | 3.1938 | 3.2281 | 19010000.0 |
| 2000-02-18 15:00:00 | AMZN | Stock | 3.2344 | 3.2625 | 3.2 | 3.2406 | 29238000.0 |
| 2000-02-18 16:00:00 | AMZN | Stock | 3.2375 | 3.25 | 3.2375 | 3.25 | 624000.0 |
| 2000-02-18 09:00:00 | CL | Stock | 26.25 | 26.375 | 26.0625 | 26.2188 | 1056200.0 |
| 2000-02-18 10:00:00 | CL | Stock | 26.25 | 26.7188 | 26.2188 | 26.7188 | 827000.0 |
| 2000-02-18 11:00:00 | CL | Stock | 26.7188 | 27.4375 | 26.625 | 27.0 | 575400.0 |
| 2000-02-18 12:00:00 | CL | Stock | 27.0938 | 27.125 | 26.8125 | 27.0 | 308400.0 |
| 2000-02-18 13:00:00 | CL | Stock | 27.0312 | 27.0312 | 26.625 | 26.75 | 280000.0 |
| 2000-02-18 14:00:00 | CL | Stock | 26.7812 | 26.8438 | 26.0 | 26.2188 | 565200.0 |
| 2000-02-18 15:00:00 | CL | Stock | 26.25 | 26.7188 | 26.1875 | 26.5938 | 399200.0 |
| 2000-02-18 16:00:00 | CL | Stock | 26.5938 | 26.5938 | 26.5312 | 26.5312 | 142400.0 |
> showing 40 of 14,539 rows — these rows as CSV