PREVIEW / stock_1hour / 2000-11-21
file: by_date/stock_1hour/2000/2000-11-21.parquet size: 306 KB rows: 15,909 symbols: 1,249
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-11-21 08:00:00 | AAPL | Stock | 0.3348 | 0.3661 | 0.3348 | 0.3393 | 767200.0 |
| 2000-11-21 09:00:00 | AAPL | Stock | 0.3393 | 0.3482 | 0.3371 | 0.3382 | 57153600.0 |
| 2000-11-21 10:00:00 | AAPL | Stock | 0.3382 | 0.3482 | 0.3348 | 0.346 | 69781600.0 |
| 2000-11-21 11:00:00 | AAPL | Stock | 0.346 | 0.346 | 0.3404 | 0.3415 | 27283200.0 |
| 2000-11-21 12:00:00 | AAPL | Stock | 0.3415 | 0.3438 | 0.3393 | 0.3393 | 22080800.0 |
| 2000-11-21 13:00:00 | AAPL | Stock | 0.3393 | 0.3421 | 0.3371 | 0.3415 | 41064800.0 |
| 2000-11-21 14:00:00 | AAPL | Stock | 0.3415 | 0.3449 | 0.3393 | 0.3415 | 32491200.0 |
| 2000-11-21 15:00:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3348 | 0.3359 | 30055200.0 |
| 2000-11-21 16:00:00 | AAPL | Stock | 0.3348 | 0.3438 | 0.3337 | 0.3359 | 3382400.0 |
| 2000-11-21 17:00:00 | AAPL | Stock | 0.3359 | 0.3359 | 0.3348 | 0.3359 | 660800.0 |
| 2000-11-21 08:00:00 | MSFT | Stock | 33.5781 | 34.0625 | 33.5781 | 33.6875 | 50200.0 |
| 2000-11-21 09:00:00 | MSFT | Stock | 33.6875 | 34.1562 | 33.5625 | 34.125 | 7889400.0 |
| 2000-11-21 10:00:00 | MSFT | Stock | 34.125 | 34.5625 | 33.9062 | 34.4844 | 13538000.0 |
| 2000-11-21 11:00:00 | MSFT | Stock | 34.5 | 34.5 | 34.125 | 34.25 | 4711000.0 |
| 2000-11-21 12:00:00 | MSFT | Stock | 34.25 | 34.625 | 34.1875 | 34.4688 | 3334600.0 |
| 2000-11-21 13:00:00 | MSFT | Stock | 34.5 | 34.5 | 34.1562 | 34.2188 | 4429600.0 |
| 2000-11-21 14:00:00 | MSFT | Stock | 34.2188 | 34.3438 | 34.125 | 34.25 | 8746800.0 |
| 2000-11-21 15:00:00 | MSFT | Stock | 34.25 | 34.25 | 33.6875 | 33.8438 | 8152200.0 |
| 2000-11-21 16:00:00 | MSFT | Stock | 33.875 | 34.2812 | 33.7812 | 33.875 | 1319200.0 |
| 2000-11-21 17:00:00 | MSFT | Stock | 33.875 | 33.9062 | 33.7812 | 33.7812 | 61800.0 |
| 2000-11-21 18:00:00 | MSFT | Stock | 33.875 | 33.875 | 33.7812 | 33.7812 | 398400.0 |
| 2000-11-21 08:00:00 | NVDA | Stock | 0.2526 | 0.2646 | 0.25 | 0.25 | 576000.0 |
| 2000-11-21 09:00:00 | NVDA | Stock | 0.2523 | 0.2563 | 0.2292 | 0.2323 | 70896000.0 |
| 2000-11-21 10:00:00 | NVDA | Stock | 0.232 | 0.2474 | 0.2266 | 0.2375 | 67536000.0 |
| 2000-11-21 11:00:00 | NVDA | Stock | 0.2375 | 0.2427 | 0.2331 | 0.2375 | 42120000.0 |
| 2000-11-21 12:00:00 | NVDA | Stock | 0.2378 | 0.2438 | 0.2359 | 0.2422 | 71712000.0 |
| 2000-11-21 13:00:00 | NVDA | Stock | 0.2427 | 0.244 | 0.2385 | 0.2427 | 18960000.0 |
| 2000-11-21 14:00:00 | NVDA | Stock | 0.2422 | 0.2435 | 0.2385 | 0.2406 | 27192000.0 |
| 2000-11-21 15:00:00 | NVDA | Stock | 0.2409 | 0.2417 | 0.2354 | 0.2391 | 51936000.0 |
| 2000-11-21 16:00:00 | NVDA | Stock | 0.2391 | 0.2391 | 0.2389 | 0.2391 | 4704000.0 |
| 2000-11-21 08:00:00 | AMZN | Stock | 1.2906 | 1.325 | 1.2906 | 1.3125 | 156000.0 |
| 2000-11-21 09:00:00 | AMZN | Stock | 1.3141 | 1.3438 | 1.2688 | 1.2875 | 12754000.0 |
| 2000-11-21 10:00:00 | AMZN | Stock | 1.2875 | 1.325 | 1.2062 | 1.2812 | 25988000.0 |
| 2000-11-21 11:00:00 | AMZN | Stock | 1.2812 | 1.2844 | 1.25 | 1.2734 | 12192000.0 |
| 2000-11-21 12:00:00 | AMZN | Stock | 1.2719 | 1.2812 | 1.2438 | 1.2594 | 6564000.0 |
| 2000-11-21 13:00:00 | AMZN | Stock | 1.2594 | 1.2625 | 1.2219 | 1.2406 | 11030000.0 |
| 2000-11-21 14:00:00 | AMZN | Stock | 1.2438 | 1.2531 | 1.2 | 1.2031 | 15662000.0 |
| 2000-11-21 15:00:00 | AMZN | Stock | 1.2031 | 1.2438 | 1.1813 | 1.2125 | 25710000.0 |
| 2000-11-21 16:00:00 | AMZN | Stock | 1.2125 | 1.2812 | 1.1906 | 1.2125 | 4162000.0 |
| 2000-11-21 17:00:00 | AMZN | Stock | 1.2125 | 1.2125 | 1.2125 | 1.2125 | 132000.0 |
| 2000-11-21 18:00:00 | AMZN | Stock | 1.2125 | 1.2484 | 1.2062 | 1.2062 | 44000.0 |
| 2000-11-21 09:00:00 | CL | Stock | 29.9 | 29.975 | 29.75 | 29.75 | 203000.0 |
| 2000-11-21 10:00:00 | CL | Stock | 29.75 | 29.755 | 29.375 | 29.675 | 412200.0 |
| 2000-11-21 11:00:00 | CL | Stock | 29.675 | 29.72 | 29.6 | 29.625 | 142800.0 |
| 2000-11-21 12:00:00 | CL | Stock | 29.625 | 29.675 | 29.505 | 29.62 | 230400.0 |
| 2000-11-21 13:00:00 | CL | Stock | 29.575 | 29.735 | 29.505 | 29.72 | 359600.0 |
| 2000-11-21 14:00:00 | CL | Stock | 29.735 | 29.74 | 29.63 | 29.71 | 200400.0 |
| 2000-11-21 15:00:00 | CL | Stock | 29.71 | 29.82 | 29.675 | 29.775 | 428400.0 |
| 2000-11-21 16:00:00 | CL | Stock | 29.78 | 29.78 | 29.635 | 29.7 | 449000.0 |
| 2000-11-21 17:00:00 | CL | Stock | 29.7 | 29.7 | 29.7 | 29.7 | 10000.0 |
> showing 50 of 15,909 rows — these rows as CSV