PREVIEW / stock_1hour / 2001-11-16
file: by_date/stock_1hour/2001/2001-11-16.parquet size: 370 KB rows: 17,601 symbols: 1,360
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-16 08:00:00 | AAPL | Stock | 0.3527 | 0.3536 | 0.3429 | 0.3441 | 476000.0 |
| 2001-11-16 09:00:00 | AAPL | Stock | 0.3404 | 0.3457 | 0.3366 | 0.3366 | 52931200.0 |
| 2001-11-16 10:00:00 | AAPL | Stock | 0.3366 | 0.3418 | 0.3366 | 0.3379 | 32737600.0 |
| 2001-11-16 11:00:00 | AAPL | Stock | 0.3378 | 0.3411 | 0.337 | 0.3382 | 22265600.0 |
| 2001-11-16 12:00:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3348 | 0.3373 | 18172000.0 |
| 2001-11-16 13:00:00 | AAPL | Stock | 0.3371 | 0.3377 | 0.3318 | 0.3323 | 20003200.0 |
| 2001-11-16 14:00:00 | AAPL | Stock | 0.3329 | 0.3346 | 0.3286 | 0.3313 | 33247200.0 |
| 2001-11-16 15:00:00 | AAPL | Stock | 0.3316 | 0.3402 | 0.3304 | 0.3386 | 30514400.0 |
| 2001-11-16 16:00:00 | AAPL | Stock | 0.3386 | 0.3393 | 0.3334 | 0.337 | 6249600.0 |
| 2001-11-16 17:00:00 | AAPL | Stock | 0.3388 | 0.3388 | 0.3388 | 0.3388 | 78400.0 |
| 2001-11-16 08:00:00 | MSFT | Stock | 33.15 | 33.295 | 33.045 | 33.045 | 83800.0 |
| 2001-11-16 09:00:00 | MSFT | Stock | 33.05 | 33.3095 | 32.935 | 33.205 | 7682400.0 |
| 2001-11-16 10:00:00 | MSFT | Stock | 33.205 | 33.23 | 32.76 | 32.94 | 11880200.0 |
| 2001-11-16 11:00:00 | MSFT | Stock | 32.941 | 33.055 | 32.705 | 32.82 | 5491200.0 |
| 2001-11-16 12:00:00 | MSFT | Stock | 32.83 | 32.905 | 32.635 | 32.78 | 4310800.0 |
| 2001-11-16 13:00:00 | MSFT | Stock | 32.79 | 32.86 | 32.475 | 32.5305 | 6509000.0 |
| 2001-11-16 14:00:00 | MSFT | Stock | 32.54 | 32.645 | 32.48 | 32.586 | 5326600.0 |
| 2001-11-16 15:00:00 | MSFT | Stock | 32.59 | 32.985 | 32.55 | 32.875 | 12518400.0 |
| 2001-11-16 16:00:00 | MSFT | Stock | 32.875 | 33.18 | 32.6968 | 33.025 | 2850400.0 |
| 2001-11-16 17:00:00 | MSFT | Stock | 33.015 | 33.04 | 32.875 | 33.03 | 61200.0 |
| 2001-11-16 18:00:00 | MSFT | Stock | 33.03 | 33.03 | 33.0 | 33.0 | 1200.0 |
| 2001-11-16 08:00:00 | NVDA | Stock | 0.4426 | 0.4458 | 0.4426 | 0.4458 | 120000.0 |
| 2001-11-16 09:00:00 | NVDA | Stock | 0.4426 | 0.4429 | 0.4358 | 0.4405 | 84552000.0 |
| 2001-11-16 10:00:00 | NVDA | Stock | 0.4405 | 0.4463 | 0.4383 | 0.4418 | 115944000.0 |
| 2001-11-16 11:00:00 | NVDA | Stock | 0.4418 | 0.4446 | 0.4379 | 0.4395 | 64860000.0 |
| 2001-11-16 12:00:00 | NVDA | Stock | 0.4396 | 0.4402 | 0.4359 | 0.4389 | 39960000.0 |
| 2001-11-16 13:00:00 | NVDA | Stock | 0.4389 | 0.4394 | 0.4315 | 0.4334 | 59448000.0 |
| 2001-11-16 14:00:00 | NVDA | Stock | 0.4334 | 0.4358 | 0.4317 | 0.4357 | 34788000.0 |
| 2001-11-16 15:00:00 | NVDA | Stock | 0.4354 | 0.4417 | 0.4348 | 0.4375 | 82092000.0 |
| 2001-11-16 16:00:00 | NVDA | Stock | 0.4374 | 0.44 | 0.4367 | 0.439 | 8748000.0 |
| 2001-11-16 17:00:00 | NVDA | Stock | 0.439 | 0.439 | 0.4377 | 0.4377 | 24000.0 |
| 2001-11-16 18:00:00 | NVDA | Stock | 0.4377 | 0.4377 | 0.4375 | 0.4375 | 120000.0 |
| 2001-11-16 08:00:00 | AMZN | Stock | 0.455 | 0.463 | 0.455 | 0.4625 | 604000.0 |
| 2001-11-16 09:00:00 | AMZN | Stock | 0.4625 | 0.4635 | 0.4375 | 0.4435 | 35550000.0 |
| 2001-11-16 10:00:00 | AMZN | Stock | 0.4436 | 0.465 | 0.4425 | 0.4645 | 67212000.0 |
| 2001-11-16 11:00:00 | AMZN | Stock | 0.464 | 0.4675 | 0.457 | 0.461 | 44230000.0 |
| 2001-11-16 12:00:00 | AMZN | Stock | 0.4605 | 0.4605 | 0.4475 | 0.4525 | 27474000.0 |
| 2001-11-16 13:00:00 | AMZN | Stock | 0.4515 | 0.456 | 0.438 | 0.4385 | 28052000.0 |
| 2001-11-16 14:00:00 | AMZN | Stock | 0.4385 | 0.45 | 0.438 | 0.4485 | 13636000.0 |
| 2001-11-16 15:00:00 | AMZN | Stock | 0.4485 | 0.4555 | 0.446 | 0.448 | 28920000.0 |
| 2001-11-16 16:00:00 | AMZN | Stock | 0.4465 | 0.45 | 0.44 | 0.45 | 2406000.0 |
| 2001-11-16 17:00:00 | AMZN | Stock | 0.4475 | 0.4505 | 0.4475 | 0.45 | 196000.0 |
| 2001-11-16 18:00:00 | AMZN | Stock | 0.45 | 0.452 | 0.45 | 0.452 | 80000.0 |
| 2001-11-16 09:00:00 | CL | Stock | 29.075 | 29.175 | 29.0 | 29.075 | 405800.0 |
| 2001-11-16 10:00:00 | CL | Stock | 29.075 | 29.25 | 29.05 | 29.24 | 315400.0 |
| 2001-11-16 11:00:00 | CL | Stock | 29.225 | 29.31 | 29.2 | 29.305 | 223200.0 |
| 2001-11-16 12:00:00 | CL | Stock | 29.225 | 29.45 | 29.225 | 29.35 | 406400.0 |
| 2001-11-16 13:00:00 | CL | Stock | 29.345 | 29.345 | 29.225 | 29.23 | 329400.0 |
| 2001-11-16 14:00:00 | CL | Stock | 29.23 | 29.275 | 29.05 | 29.085 | 504400.0 |
| 2001-11-16 15:00:00 | CL | Stock | 29.085 | 29.335 | 29.085 | 29.245 | 407200.0 |
> showing 50 of 17,601 rows — these rows as CSV