PREVIEW / stock_1hour / 2000-10-19
file: by_date/stock_1hour/2000/2000-10-19.parquet size: 306 KB rows: 15,718 symbols: 1,235
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-19 08:00:00 | AAPL | Stock | 0.3036 | 0.3348 | 0.2857 | 0.3315 | 26157600.0 |
| 2000-10-19 09:00:00 | AAPL | Stock | 0.3304 | 0.3438 | 0.3147 | 0.3281 | 288288000.0 |
| 2000-10-19 10:00:00 | AAPL | Stock | 0.3292 | 0.3538 | 0.3281 | 0.346 | 311074400.0 |
| 2000-10-19 11:00:00 | AAPL | Stock | 0.3449 | 0.3527 | 0.3438 | 0.3449 | 176820000.0 |
| 2000-10-19 12:00:00 | AAPL | Stock | 0.3449 | 0.3482 | 0.3371 | 0.3393 | 128665600.0 |
| 2000-10-19 13:00:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3304 | 0.3315 | 154716800.0 |
| 2000-10-19 14:00:00 | AAPL | Stock | 0.3315 | 0.3393 | 0.3292 | 0.3348 | 99400000.0 |
| 2000-10-19 15:00:00 | AAPL | Stock | 0.3348 | 0.3393 | 0.3315 | 0.3382 | 204142400.0 |
| 2000-10-19 16:00:00 | AAPL | Stock | 0.3382 | 0.3426 | 0.3092 | 0.3393 | 14672000.0 |
| 2000-10-19 17:00:00 | AAPL | Stock | 0.3415 | 0.3438 | 0.3393 | 0.3438 | 520800.0 |
| 2000-10-19 18:00:00 | AAPL | Stock | 0.3438 | 0.3527 | 0.3438 | 0.3482 | 1887200.0 |
| 2000-10-19 08:00:00 | MSFT | Stock | 28.0 | 28.75 | 28.0 | 28.5625 | 3897600.0 |
| 2000-10-19 09:00:00 | MSFT | Stock | 28.625 | 29.4688 | 26.0312 | 29.4375 | 48513600.0 |
| 2000-10-19 10:00:00 | MSFT | Stock | 29.4375 | 30.0312 | 29.375 | 29.875 | 42282000.0 |
| 2000-10-19 11:00:00 | MSFT | Stock | 29.875 | 30.6562 | 29.75 | 30.375 | 34420800.0 |
| 2000-10-19 12:00:00 | MSFT | Stock | 30.4062 | 30.625 | 30.25 | 30.375 | 22561200.0 |
| 2000-10-19 13:00:00 | MSFT | Stock | 30.375 | 30.375 | 29.9062 | 30.0 | 21451000.0 |
| 2000-10-19 14:00:00 | MSFT | Stock | 30.0312 | 30.9688 | 30.0 | 30.7969 | 26397800.0 |
| 2000-10-19 15:00:00 | MSFT | Stock | 30.8438 | 31.0938 | 30.625 | 30.875 | 30903000.0 |
| 2000-10-19 16:00:00 | MSFT | Stock | 30.9062 | 31.1875 | 30.0469 | 31.125 | 4959600.0 |
| 2000-10-19 17:00:00 | MSFT | Stock | 31.1406 | 31.1406 | 29.7188 | 31.0625 | 87600.0 |
| 2000-10-19 18:00:00 | MSFT | Stock | 31.0625 | 31.1562 | 31.0 | 31.125 | 33200.0 |
| 2000-10-19 09:00:00 | NVDA | Stock | 0.2531 | 0.2633 | 0.2531 | 0.2598 | 19848000.0 |
| 2000-10-19 10:00:00 | NVDA | Stock | 0.2598 | 0.2643 | 0.2536 | 0.2565 | 34632000.0 |
| 2000-10-19 11:00:00 | NVDA | Stock | 0.2565 | 0.2635 | 0.2542 | 0.2602 | 81696000.0 |
| 2000-10-19 12:00:00 | NVDA | Stock | 0.2599 | 0.2602 | 0.2573 | 0.2602 | 23664000.0 |
| 2000-10-19 13:00:00 | NVDA | Stock | 0.2583 | 0.2688 | 0.2583 | 0.2656 | 21600000.0 |
| 2000-10-19 14:00:00 | NVDA | Stock | 0.2656 | 0.2667 | 0.2628 | 0.2641 | 32400000.0 |
| 2000-10-19 15:00:00 | NVDA | Stock | 0.2664 | 0.2672 | 0.2602 | 0.2654 | 48384000.0 |
| 2000-10-19 16:00:00 | NVDA | Stock | 0.2654 | 0.2682 | 0.2632 | 0.2656 | 4608000.0 |
| 2000-10-19 17:00:00 | NVDA | Stock | 0.2681 | 0.2681 | 0.2654 | 0.2654 | 72000.0 |
| 2000-10-19 08:00:00 | AMZN | Stock | 1.35 | 1.375 | 1.2578 | 1.3688 | 1694000.0 |
| 2000-10-19 09:00:00 | AMZN | Stock | 1.35 | 1.3516 | 1.2781 | 1.2844 | 31334000.0 |
| 2000-10-19 10:00:00 | AMZN | Stock | 1.2812 | 1.3125 | 1.2094 | 1.2812 | 31398000.0 |
| 2000-10-19 11:00:00 | AMZN | Stock | 1.2781 | 1.3 | 1.2438 | 1.25 | 20654000.0 |
| 2000-10-19 12:00:00 | AMZN | Stock | 1.2531 | 1.3219 | 1.25 | 1.2938 | 15598000.0 |
| 2000-10-19 13:00:00 | AMZN | Stock | 1.2938 | 1.3438 | 1.2844 | 1.3 | 26694000.0 |
| 2000-10-19 14:00:00 | AMZN | Stock | 1.3 | 1.375 | 1.2844 | 1.3719 | 22728000.0 |
| 2000-10-19 15:00:00 | AMZN | Stock | 1.375 | 1.4062 | 1.3625 | 1.3812 | 43038000.0 |
| 2000-10-19 16:00:00 | AMZN | Stock | 1.3906 | 1.45 | 1.375 | 1.45 | 5218000.0 |
| 2000-10-19 17:00:00 | AMZN | Stock | 1.45 | 1.4813 | 1.4484 | 1.4531 | 576000.0 |
| 2000-10-19 18:00:00 | AMZN | Stock | 1.45 | 1.4625 | 1.4469 | 1.4469 | 42000.0 |
| 2000-10-19 09:00:00 | CL | Stock | 25.1 | 25.175 | 24.925 | 25.08 | 389800.0 |
| 2000-10-19 10:00:00 | CL | Stock | 25.05 | 25.055 | 24.7 | 24.71 | 1094400.0 |
| 2000-10-19 11:00:00 | CL | Stock | 24.705 | 25.2 | 24.69 | 25.185 | 657800.0 |
| 2000-10-19 12:00:00 | CL | Stock | 25.125 | 25.245 | 25.125 | 25.175 | 139600.0 |
| 2000-10-19 13:00:00 | CL | Stock | 25.2 | 25.45 | 25.175 | 25.45 | 281000.0 |
| 2000-10-19 14:00:00 | CL | Stock | 25.45 | 25.45 | 25.23 | 25.275 | 564200.0 |
| 2000-10-19 15:00:00 | CL | Stock | 25.275 | 25.325 | 25.125 | 25.14 | 977800.0 |
| 2000-10-19 16:00:00 | CL | Stock | 25.12 | 25.185 | 25.12 | 25.185 | 74600.0 |
> showing 50 of 15,718 rows — these rows as CSV