PREVIEW / stock_1hour / 2001-11-26
file: by_date/stock_1hour/2001/2001-11-26.parquet size: 383 KB rows: 18,442 symbols: 1,365
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-11-26 08:00:00 | AAPL | Stock | 0.3563 | 0.3572 | 0.3563 | 0.3571 | 168000.0 |
| 2001-11-26 09:00:00 | AAPL | Stock | 0.3561 | 0.367 | 0.355 | 0.3663 | 56425600.0 |
| 2001-11-26 10:00:00 | AAPL | Stock | 0.3661 | 0.3711 | 0.3645 | 0.3679 | 80875200.0 |
| 2001-11-26 11:00:00 | AAPL | Stock | 0.3679 | 0.3741 | 0.3677 | 0.3727 | 51156000.0 |
| 2001-11-26 12:00:00 | AAPL | Stock | 0.3727 | 0.3729 | 0.3693 | 0.3718 | 14974400.0 |
| 2001-11-26 13:00:00 | AAPL | Stock | 0.3718 | 0.3761 | 0.3713 | 0.375 | 36120000.0 |
| 2001-11-26 14:00:00 | AAPL | Stock | 0.375 | 0.3848 | 0.3746 | 0.3832 | 73007200.0 |
| 2001-11-26 15:00:00 | AAPL | Stock | 0.3834 | 0.3846 | 0.3777 | 0.3816 | 94354400.0 |
| 2001-11-26 16:00:00 | AAPL | Stock | 0.3816 | 0.3857 | 0.3763 | 0.3857 | 49011200.0 |
| 2001-11-26 17:00:00 | AAPL | Stock | 0.3816 | 0.3816 | 0.3798 | 0.3807 | 28000.0 |
| 2001-11-26 08:00:00 | MSFT | Stock | 32.49 | 32.49 | 32.31 | 32.4 | 66800.0 |
| 2001-11-26 09:00:00 | MSFT | Stock | 32.4 | 32.675 | 32.22 | 32.6 | 7172200.0 |
| 2001-11-26 10:00:00 | MSFT | Stock | 32.605 | 32.855 | 32.47 | 32.6 | 8051200.0 |
| 2001-11-26 11:00:00 | MSFT | Stock | 32.595 | 32.63 | 32.25 | 32.375 | 5028400.0 |
| 2001-11-26 12:00:00 | MSFT | Stock | 32.385 | 32.43 | 32.2 | 32.395 | 3374200.0 |
| 2001-11-26 13:00:00 | MSFT | Stock | 32.395 | 32.4745 | 32.31 | 32.435 | 3206400.0 |
| 2001-11-26 14:00:00 | MSFT | Stock | 32.43 | 32.615 | 32.369 | 32.595 | 4983000.0 |
| 2001-11-26 15:00:00 | MSFT | Stock | 32.585 | 32.71 | 32.455 | 32.56 | 6690200.0 |
| 2001-11-26 16:00:00 | MSFT | Stock | 32.5355 | 32.695 | 32.36 | 32.45 | 2385200.0 |
| 2001-11-26 17:00:00 | MSFT | Stock | 32.45 | 32.57 | 32.45 | 32.48 | 25400.0 |
| 2001-11-26 18:00:00 | MSFT | Stock | 32.45 | 32.475 | 32.45 | 32.475 | 3200.0 |
| 2001-11-26 08:00:00 | NVDA | Stock | 0.4183 | 0.4229 | 0.4183 | 0.4208 | 168000.0 |
| 2001-11-26 09:00:00 | NVDA | Stock | 0.4208 | 0.4375 | 0.4183 | 0.4374 | 205800000.0 |
| 2001-11-26 10:00:00 | NVDA | Stock | 0.4369 | 0.4415 | 0.4337 | 0.4362 | 243204000.0 |
| 2001-11-26 11:00:00 | NVDA | Stock | 0.4358 | 0.4379 | 0.4319 | 0.4352 | 127860000.0 |
| 2001-11-26 12:00:00 | NVDA | Stock | 0.4349 | 0.4383 | 0.4337 | 0.4371 | 74268000.0 |
| 2001-11-26 13:00:00 | NVDA | Stock | 0.437 | 0.4392 | 0.436 | 0.4386 | 102108000.0 |
| 2001-11-26 14:00:00 | NVDA | Stock | 0.4386 | 0.446 | 0.4355 | 0.445 | 187836000.0 |
| 2001-11-26 15:00:00 | NVDA | Stock | 0.4449 | 0.4466 | 0.4405 | 0.446 | 197760000.0 |
| 2001-11-26 16:00:00 | NVDA | Stock | 0.4456 | 0.4489 | 0.438 | 0.4467 | 25944000.0 |
| 2001-11-26 17:00:00 | NVDA | Stock | 0.4467 | 0.4468 | 0.446 | 0.4468 | 756000.0 |
| 2001-11-26 18:00:00 | NVDA | Stock | 0.4469 | 0.4469 | 0.4469 | 0.4469 | 12000.0 |
| 2001-11-26 08:00:00 | AMZN | Stock | 0.461 | 0.485 | 0.45 | 0.48 | 3974000.0 |
| 2001-11-26 09:00:00 | AMZN | Stock | 0.48 | 0.537 | 0.461 | 0.535 | 159562000.0 |
| 2001-11-26 10:00:00 | AMZN | Stock | 0.535 | 0.536 | 0.52 | 0.5245 | 134974000.0 |
| 2001-11-26 11:00:00 | AMZN | Stock | 0.523 | 0.5265 | 0.5075 | 0.525 | 90930000.0 |
| 2001-11-26 12:00:00 | AMZN | Stock | 0.525 | 0.5345 | 0.5156 | 0.5315 | 58628000.0 |
| 2001-11-26 13:00:00 | AMZN | Stock | 0.532 | 0.5455 | 0.5255 | 0.5435 | 71498000.0 |
| 2001-11-26 14:00:00 | AMZN | Stock | 0.543 | 0.5555 | 0.5365 | 0.5535 | 101792000.0 |
| 2001-11-26 15:00:00 | AMZN | Stock | 0.5535 | 0.611 | 0.55 | 0.61 | 285428000.0 |
| 2001-11-26 16:00:00 | AMZN | Stock | 0.6105 | 0.613 | 0.4905 | 0.61 | 49862000.0 |
| 2001-11-26 17:00:00 | AMZN | Stock | 0.6105 | 0.6325 | 0.5658 | 0.631 | 7442000.0 |
| 2001-11-26 18:00:00 | AMZN | Stock | 0.632 | 0.64 | 0.63 | 0.6325 | 3038000.0 |
| 2001-11-26 09:00:00 | CL | Stock | 29.225 | 29.325 | 29.1 | 29.275 | 240200.0 |
| 2001-11-26 10:00:00 | CL | Stock | 29.285 | 29.5 | 29.28 | 29.41 | 507000.0 |
| 2001-11-26 11:00:00 | CL | Stock | 29.41 | 29.45 | 29.275 | 29.275 | 344600.0 |
| 2001-11-26 12:00:00 | CL | Stock | 29.3 | 29.475 | 29.3 | 29.475 | 234400.0 |
| 2001-11-26 13:00:00 | CL | Stock | 29.47 | 29.47 | 29.275 | 29.335 | 153000.0 |
| 2001-11-26 14:00:00 | CL | Stock | 29.33 | 29.525 | 29.33 | 29.525 | 260000.0 |
| 2001-11-26 15:00:00 | CL | Stock | 29.525 | 29.53 | 29.425 | 29.425 | 475200.0 |
> showing 50 of 18,442 rows — these rows as CSV