PREVIEW / stock_1hour / 2001-11-08
file: by_date/stock_1hour/2001/2001-11-08.parquet size: 378 KB rows: 18,086 symbols: 1,361
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-08 08:00:00 | AAPL | Stock | 0.3497 | 0.3536 | 0.3497 | 0.3527 | 509600.0 |
| 2001-11-08 09:00:00 | AAPL | Stock | 0.3518 | 0.3518 | 0.3455 | 0.348 | 28268800.0 |
| 2001-11-08 10:00:00 | AAPL | Stock | 0.3482 | 0.3536 | 0.3464 | 0.3536 | 49868000.0 |
| 2001-11-08 11:00:00 | AAPL | Stock | 0.3532 | 0.3553 | 0.3468 | 0.3491 | 24326400.0 |
| 2001-11-08 12:00:00 | AAPL | Stock | 0.3491 | 0.3502 | 0.3461 | 0.348 | 31595200.0 |
| 2001-11-08 13:00:00 | AAPL | Stock | 0.3479 | 0.3488 | 0.3414 | 0.3423 | 39547200.0 |
| 2001-11-08 14:00:00 | AAPL | Stock | 0.3428 | 0.3438 | 0.335 | 0.3354 | 72996000.0 |
| 2001-11-08 15:00:00 | AAPL | Stock | 0.335 | 0.3393 | 0.3316 | 0.3339 | 79923200.0 |
| 2001-11-08 16:00:00 | AAPL | Stock | 0.3341 | 0.3359 | 0.333 | 0.3359 | 10320800.0 |
| 2001-11-08 17:00:00 | AAPL | Stock | 0.3341 | 0.3341 | 0.3341 | 0.3341 | 716800.0 |
| 2001-11-08 18:00:00 | AAPL | Stock | 0.3352 | 0.3352 | 0.3352 | 0.3352 | 56000.0 |
| 2001-11-08 08:00:00 | MSFT | Stock | 32.345 | 32.445 | 32.181 | 32.33 | 121400.0 |
| 2001-11-08 09:00:00 | MSFT | Stock | 32.33 | 32.5135 | 32.1 | 32.415 | 9228200.0 |
| 2001-11-08 10:00:00 | MSFT | Stock | 32.3825 | 32.98 | 32.32 | 32.97 | 14093000.0 |
| 2001-11-08 11:00:00 | MSFT | Stock | 32.965 | 33.0 | 32.69 | 32.92 | 9921200.0 |
| 2001-11-08 12:00:00 | MSFT | Stock | 32.9151 | 32.985 | 32.73 | 32.9 | 5926200.0 |
| 2001-11-08 13:00:00 | MSFT | Stock | 32.9 | 33.03 | 32.735 | 32.815 | 6663200.0 |
| 2001-11-08 14:00:00 | MSFT | Stock | 32.825 | 32.875 | 32.395 | 32.4 | 8883200.0 |
| 2001-11-08 15:00:00 | MSFT | Stock | 32.4 | 32.45 | 31.83 | 32.205 | 14443800.0 |
| 2001-11-08 16:00:00 | MSFT | Stock | 32.2 | 32.5918 | 32.0394 | 32.24 | 2866200.0 |
| 2001-11-08 17:00:00 | MSFT | Stock | 32.21 | 32.5706 | 32.17 | 32.215 | 172000.0 |
| 2001-11-08 18:00:00 | MSFT | Stock | 32.225 | 32.275 | 32.225 | 32.225 | 12000.0 |
| 2001-11-08 08:00:00 | NVDA | Stock | 0.4312 | 0.4312 | 0.4237 | 0.4292 | 2220000.0 |
| 2001-11-08 09:00:00 | NVDA | Stock | 0.4302 | 0.4328 | 0.4242 | 0.4291 | 170772000.0 |
| 2001-11-08 10:00:00 | NVDA | Stock | 0.4295 | 0.4308 | 0.423 | 0.4284 | 140988000.0 |
| 2001-11-08 11:00:00 | NVDA | Stock | 0.4287 | 0.4296 | 0.4109 | 0.4171 | 333612000.0 |
| 2001-11-08 12:00:00 | NVDA | Stock | 0.4168 | 0.4186 | 0.4121 | 0.4167 | 209820000.0 |
| 2001-11-08 13:00:00 | NVDA | Stock | 0.4173 | 0.4195 | 0.4133 | 0.4146 | 110820000.0 |
| 2001-11-08 14:00:00 | NVDA | Stock | 0.4146 | 0.4177 | 0.4092 | 0.4144 | 223548000.0 |
| 2001-11-08 15:00:00 | NVDA | Stock | 0.4144 | 0.4167 | 0.4021 | 0.4145 | 444396000.0 |
| 2001-11-08 16:00:00 | NVDA | Stock | 0.4146 | 0.4362 | 0.4085 | 0.4357 | 175080000.0 |
| 2001-11-08 17:00:00 | NVDA | Stock | 0.4355 | 0.4446 | 0.4146 | 0.4387 | 57276000.0 |
| 2001-11-08 18:00:00 | NVDA | Stock | 0.4387 | 0.4407 | 0.4375 | 0.4379 | 3348000.0 |
| 2001-11-08 08:00:00 | AMZN | Stock | 0.3718 | 0.386 | 0.3718 | 0.386 | 804000.0 |
| 2001-11-08 09:00:00 | AMZN | Stock | 0.386 | 0.386 | 0.374 | 0.3765 | 26504000.0 |
| 2001-11-08 10:00:00 | AMZN | Stock | 0.3765 | 0.3775 | 0.372 | 0.375 | 35784000.0 |
| 2001-11-08 11:00:00 | AMZN | Stock | 0.375 | 0.3755 | 0.3665 | 0.367 | 22098000.0 |
| 2001-11-08 12:00:00 | AMZN | Stock | 0.367 | 0.368 | 0.3605 | 0.366 | 15046000.0 |
| 2001-11-08 13:00:00 | AMZN | Stock | 0.3655 | 0.3745 | 0.3655 | 0.3675 | 11954000.0 |
| 2001-11-08 14:00:00 | AMZN | Stock | 0.367 | 0.369 | 0.3535 | 0.3545 | 16362000.0 |
| 2001-11-08 15:00:00 | AMZN | Stock | 0.355 | 0.356 | 0.3375 | 0.3485 | 38630000.0 |
| 2001-11-08 16:00:00 | AMZN | Stock | 0.3485 | 0.3525 | 0.3465 | 0.3465 | 2836000.0 |
| 2001-11-08 17:00:00 | AMZN | Stock | 0.3485 | 0.3495 | 0.3485 | 0.3485 | 264000.0 |
| 2001-11-08 18:00:00 | AMZN | Stock | 0.35 | 0.35 | 0.35 | 0.35 | 70000.0 |
| 2001-11-08 09:00:00 | CL | Stock | 29.275 | 29.375 | 29.2 | 29.2 | 248400.0 |
| 2001-11-08 10:00:00 | CL | Stock | 29.195 | 29.25 | 29.08 | 29.235 | 461400.0 |
| 2001-11-08 11:00:00 | CL | Stock | 29.24 | 29.24 | 28.985 | 29.05 | 737200.0 |
| 2001-11-08 12:00:00 | CL | Stock | 29.05 | 29.055 | 28.845 | 28.895 | 382400.0 |
| 2001-11-08 13:00:00 | CL | Stock | 28.895 | 28.895 | 28.805 | 28.815 | 500400.0 |
| 2001-11-08 14:00:00 | CL | Stock | 28.8 | 28.955 | 28.725 | 28.835 | 372600.0 |
> showing 50 of 18,086 rows — these rows as CSV