PREVIEW / stock_1hour / 2000-10-27
file: by_date/stock_1hour/2000/2000-10-27.parquet size: 303 KB rows: 15,487 symbols: 1,231
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-10-27 08:00:00 | AAPL | Stock | 0.3348 | 0.3382 | 0.3315 | 0.3371 | 448000.0 |
| 2000-10-27 09:00:00 | AAPL | Stock | 0.3393 | 0.3426 | 0.3326 | 0.3326 | 115012800.0 |
| 2000-10-27 10:00:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3225 | 0.3237 | 107116800.0 |
| 2000-10-27 11:00:00 | AAPL | Stock | 0.3248 | 0.3304 | 0.3214 | 0.3281 | 110023200.0 |
| 2000-10-27 12:00:00 | AAPL | Stock | 0.3281 | 0.3304 | 0.3203 | 0.3203 | 86167200.0 |
| 2000-10-27 13:00:00 | AAPL | Stock | 0.3203 | 0.3259 | 0.3203 | 0.3225 | 70168000.0 |
| 2000-10-27 14:00:00 | AAPL | Stock | 0.3237 | 0.3248 | 0.3192 | 0.3225 | 69473600.0 |
| 2000-10-27 15:00:00 | AAPL | Stock | 0.3214 | 0.3326 | 0.3214 | 0.3315 | 122416000.0 |
| 2000-10-27 16:00:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3259 | 0.3304 | 28285600.0 |
| 2000-10-27 17:00:00 | AAPL | Stock | 0.3292 | 0.3326 | 0.3281 | 0.3326 | 358400.0 |
| 2000-10-27 18:00:00 | AAPL | Stock | 0.3304 | 0.332 | 0.3304 | 0.3304 | 61600.0 |
| 2000-10-27 08:00:00 | MSFT | Stock | 32.625 | 32.9688 | 31.9375 | 32.125 | 164800.0 |
| 2000-10-27 09:00:00 | MSFT | Stock | 32.125 | 33.0312 | 32.0625 | 32.8125 | 12200200.0 |
| 2000-10-27 10:00:00 | MSFT | Stock | 32.8125 | 33.3125 | 32.8125 | 33.0938 | 19050800.0 |
| 2000-10-27 11:00:00 | MSFT | Stock | 33.1094 | 34.0312 | 32.875 | 34.0 | 20195800.0 |
| 2000-10-27 12:00:00 | MSFT | Stock | 34.0 | 34.0625 | 33.5625 | 33.8125 | 13301200.0 |
| 2000-10-27 13:00:00 | MSFT | Stock | 33.8125 | 34.3125 | 33.75 | 34.25 | 9110800.0 |
| 2000-10-27 14:00:00 | MSFT | Stock | 34.25 | 34.5938 | 34.0938 | 34.2188 | 16531600.0 |
| 2000-10-27 15:00:00 | MSFT | Stock | 34.2188 | 34.25 | 33.6875 | 33.8438 | 18659000.0 |
| 2000-10-27 16:00:00 | MSFT | Stock | 33.875 | 34.0156 | 33.625 | 33.8125 | 7059600.0 |
| 2000-10-27 17:00:00 | MSFT | Stock | 33.8125 | 33.875 | 33.6562 | 33.6562 | 13600.0 |
| 2000-10-27 18:00:00 | MSFT | Stock | 33.75 | 33.8438 | 33.75 | 33.8438 | 600.0 |
| 2000-10-27 09:00:00 | NVDA | Stock | 0.262 | 0.2678 | 0.2542 | 0.2617 | 19056000.0 |
| 2000-10-27 10:00:00 | NVDA | Stock | 0.2625 | 0.2664 | 0.2563 | 0.2589 | 17712000.0 |
| 2000-10-27 11:00:00 | NVDA | Stock | 0.2591 | 0.2641 | 0.2573 | 0.2609 | 27840000.0 |
| 2000-10-27 12:00:00 | NVDA | Stock | 0.2602 | 0.2604 | 0.2542 | 0.2552 | 27360000.0 |
| 2000-10-27 13:00:00 | NVDA | Stock | 0.2547 | 0.2599 | 0.2542 | 0.2583 | 24672000.0 |
| 2000-10-27 14:00:00 | NVDA | Stock | 0.2573 | 0.2583 | 0.2503 | 0.2529 | 25800000.0 |
| 2000-10-27 15:00:00 | NVDA | Stock | 0.2526 | 0.2583 | 0.2458 | 0.2552 | 46680000.0 |
| 2000-10-27 16:00:00 | NVDA | Stock | 0.2542 | 0.2565 | 0.2542 | 0.2552 | 6624000.0 |
| 2000-10-27 08:00:00 | AMZN | Stock | 1.8125 | 1.825 | 1.6875 | 1.7156 | 2344000.0 |
| 2000-10-27 09:00:00 | AMZN | Stock | 1.7219 | 1.875 | 1.65 | 1.8266 | 63548000.0 |
| 2000-10-27 10:00:00 | AMZN | Stock | 1.8297 | 1.8375 | 1.7625 | 1.7688 | 38930000.0 |
| 2000-10-27 11:00:00 | AMZN | Stock | 1.7656 | 1.8375 | 1.7406 | 1.8062 | 37414000.0 |
| 2000-10-27 12:00:00 | AMZN | Stock | 1.8062 | 1.8156 | 1.7812 | 1.8062 | 14384000.0 |
| 2000-10-27 13:00:00 | AMZN | Stock | 1.8094 | 1.8219 | 1.7781 | 1.8125 | 15096000.0 |
| 2000-10-27 14:00:00 | AMZN | Stock | 1.8156 | 1.8156 | 1.7875 | 1.7875 | 14346000.0 |
| 2000-10-27 15:00:00 | AMZN | Stock | 1.7875 | 1.8 | 1.7469 | 1.7812 | 36240000.0 |
| 2000-10-27 16:00:00 | AMZN | Stock | 1.7828 | 1.8 | 1.7625 | 1.7812 | 3190000.0 |
| 2000-10-27 17:00:00 | AMZN | Stock | 1.7656 | 1.7656 | 1.7625 | 1.7656 | 14000.0 |
| 2000-10-27 18:00:00 | AMZN | Stock | 1.775 | 1.775 | 1.775 | 1.775 | 10000.0 |
| 2000-10-27 09:00:00 | CL | Stock | 27.745 | 27.745 | 27.6 | 27.605 | 492400.0 |
| 2000-10-27 10:00:00 | CL | Stock | 27.6 | 28.25 | 27.575 | 28.005 | 622600.0 |
| 2000-10-27 11:00:00 | CL | Stock | 28.02 | 28.275 | 28.005 | 28.275 | 586600.0 |
| 2000-10-27 12:00:00 | CL | Stock | 28.275 | 28.45 | 28.255 | 28.395 | 329200.0 |
| 2000-10-27 13:00:00 | CL | Stock | 28.39 | 28.4 | 28.175 | 28.195 | 305200.0 |
| 2000-10-27 14:00:00 | CL | Stock | 28.19 | 28.325 | 28.125 | 28.3 | 346800.0 |
| 2000-10-27 15:00:00 | CL | Stock | 28.305 | 28.81 | 28.305 | 28.81 | 1086800.0 |
| 2000-10-27 16:00:00 | CL | Stock | 28.81 | 28.81 | 28.2 | 28.81 | 599400.0 |
| 2000-10-27 17:00:00 | CL | Stock | 28.81 | 28.81 | 28.81 | 28.81 | 19000.0 |
> showing 50 of 15,487 rows — these rows as CSV