PREVIEW / stock_1hour / 2001-03-16
file: by_date/stock_1hour/2001/2001-03-16.parquet size: 351 KB rows: 16,365 symbols: 1,276
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-16 08:00:00 | AAPL | Stock | 0.3527 | 0.3571 | 0.3504 | 0.3571 | 644000.0 |
| 2001-03-16 09:00:00 | AAPL | Stock | 0.3493 | 0.356 | 0.3371 | 0.346 | 74407200.0 |
| 2001-03-16 10:00:00 | AAPL | Stock | 0.346 | 0.3504 | 0.3415 | 0.3426 | 43400000.0 |
| 2001-03-16 11:00:00 | AAPL | Stock | 0.3426 | 0.3605 | 0.3415 | 0.3583 | 56974400.0 |
| 2001-03-16 12:00:00 | AAPL | Stock | 0.3583 | 0.3627 | 0.356 | 0.3583 | 35828800.0 |
| 2001-03-16 13:00:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3504 | 0.3571 | 23548000.0 |
| 2001-03-16 14:00:00 | AAPL | Stock | 0.356 | 0.3605 | 0.3516 | 0.3527 | 31516800.0 |
| 2001-03-16 15:00:00 | AAPL | Stock | 0.3527 | 0.3583 | 0.3493 | 0.3493 | 65184000.0 |
| 2001-03-16 16:00:00 | AAPL | Stock | 0.3493 | 0.3538 | 0.3482 | 0.3504 | 81452000.0 |
| 2001-03-16 17:00:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3499 | 0.3499 | 3740800.0 |
| 2001-03-16 08:00:00 | MSFT | Stock | 26.875 | 27.25 | 26.75 | 27.125 | 512400.0 |
| 2001-03-16 09:00:00 | MSFT | Stock | 27.1875 | 27.1875 | 26.0625 | 26.9062 | 24456600.0 |
| 2001-03-16 10:00:00 | MSFT | Stock | 26.9062 | 27.2188 | 26.7812 | 26.9688 | 13195400.0 |
| 2001-03-16 11:00:00 | MSFT | Stock | 26.9688 | 27.4062 | 26.9375 | 27.375 | 12041400.0 |
| 2001-03-16 12:00:00 | MSFT | Stock | 27.3438 | 27.5625 | 27.2812 | 27.3438 | 8457600.0 |
| 2001-03-16 13:00:00 | MSFT | Stock | 27.3125 | 27.4375 | 26.9375 | 27.25 | 7436200.0 |
| 2001-03-16 14:00:00 | MSFT | Stock | 27.3125 | 27.4062 | 26.875 | 26.875 | 5711000.0 |
| 2001-03-16 15:00:00 | MSFT | Stock | 26.9062 | 27.375 | 26.875 | 27.25 | 12276000.0 |
| 2001-03-16 16:00:00 | MSFT | Stock | 27.25 | 27.4688 | 26.5 | 27.2812 | 6278000.0 |
| 2001-03-16 17:00:00 | MSFT | Stock | 27.2812 | 27.375 | 27.2188 | 27.2812 | 390400.0 |
| 2001-03-16 18:00:00 | MSFT | Stock | 27.2812 | 27.3438 | 27.2812 | 27.3125 | 5000.0 |
| 2001-03-16 08:00:00 | NVDA | Stock | 0.2496 | 0.2542 | 0.2479 | 0.2495 | 8664000.0 |
| 2001-03-16 09:00:00 | NVDA | Stock | 0.2484 | 0.2542 | 0.2448 | 0.2497 | 202680000.0 |
| 2001-03-16 10:00:00 | NVDA | Stock | 0.2497 | 0.2552 | 0.2383 | 0.2417 | 258840000.0 |
| 2001-03-16 11:00:00 | NVDA | Stock | 0.2411 | 0.2497 | 0.2411 | 0.2477 | 213816000.0 |
| 2001-03-16 12:00:00 | NVDA | Stock | 0.2474 | 0.251 | 0.2461 | 0.2469 | 95976000.0 |
| 2001-03-16 13:00:00 | NVDA | Stock | 0.2466 | 0.249 | 0.2453 | 0.2487 | 51168000.0 |
| 2001-03-16 14:00:00 | NVDA | Stock | 0.2487 | 0.25 | 0.2466 | 0.2474 | 125904000.0 |
| 2001-03-16 15:00:00 | NVDA | Stock | 0.2474 | 0.2518 | 0.2461 | 0.2484 | 161328000.0 |
| 2001-03-16 16:00:00 | NVDA | Stock | 0.2483 | 0.2526 | 0.2477 | 0.2505 | 39576000.0 |
| 2001-03-16 17:00:00 | NVDA | Stock | 0.2483 | 0.2505 | 0.2483 | 0.2505 | 2208000.0 |
| 2001-03-16 18:00:00 | NVDA | Stock | 0.2518 | 0.2518 | 0.2492 | 0.2492 | 72000.0 |
| 2001-03-16 08:00:00 | AMZN | Stock | 0.5438 | 0.5438 | 0.5406 | 0.5438 | 58000.0 |
| 2001-03-16 09:00:00 | AMZN | Stock | 0.5438 | 0.5469 | 0.5125 | 0.5219 | 15624000.0 |
| 2001-03-16 10:00:00 | AMZN | Stock | 0.5219 | 0.5281 | 0.5156 | 0.5219 | 24184000.0 |
| 2001-03-16 11:00:00 | AMZN | Stock | 0.525 | 0.5375 | 0.5188 | 0.5344 | 13430000.0 |
| 2001-03-16 12:00:00 | AMZN | Stock | 0.5328 | 0.5344 | 0.525 | 0.5312 | 6976000.0 |
| 2001-03-16 13:00:00 | AMZN | Stock | 0.5312 | 0.5531 | 0.5281 | 0.5438 | 13420000.0 |
| 2001-03-16 14:00:00 | AMZN | Stock | 0.5438 | 0.55 | 0.5375 | 0.5406 | 24124000.0 |
| 2001-03-16 15:00:00 | AMZN | Stock | 0.5406 | 0.5531 | 0.5406 | 0.55 | 20316000.0 |
| 2001-03-16 16:00:00 | AMZN | Stock | 0.55 | 0.575 | 0.5469 | 0.5516 | 5038000.0 |
| 2001-03-16 17:00:00 | AMZN | Stock | 0.5484 | 0.5531 | 0.5484 | 0.55 | 100000.0 |
| 2001-03-16 09:00:00 | CL | Stock | 26.75 | 27.235 | 26.75 | 26.825 | 1857400.0 |
| 2001-03-16 10:00:00 | CL | Stock | 26.84 | 27.1 | 26.825 | 27.075 | 484200.0 |
| 2001-03-16 11:00:00 | CL | Stock | 27.025 | 27.5 | 27.025 | 27.475 | 371000.0 |
| 2001-03-16 12:00:00 | CL | Stock | 27.465 | 27.625 | 27.375 | 27.43 | 353200.0 |
| 2001-03-16 13:00:00 | CL | Stock | 27.46 | 27.55 | 27.415 | 27.525 | 190000.0 |
| 2001-03-16 14:00:00 | CL | Stock | 27.53 | 27.55 | 27.15 | 27.275 | 347000.0 |
| 2001-03-16 15:00:00 | CL | Stock | 27.275 | 27.35 | 27.09 | 27.095 | 731000.0 |
| 2001-03-16 16:00:00 | CL | Stock | 27.15 | 27.15 | 26.75 | 26.75 | 434600.0 |
> showing 50 of 16,365 rows — these rows as CSV