PREVIEW / stock_1hour / 2001-11-12
file: by_date/stock_1hour/2001/2001-11-12.parquet size: 366 KB rows: 17,365 symbols: 1,338
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-12 08:00:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3384 | 0.3384 | 28000.0 |
| 2001-11-12 09:00:00 | AAPL | Stock | 0.3332 | 0.3334 | 0.3207 | 0.3266 | 48378400.0 |
| 2001-11-12 10:00:00 | AAPL | Stock | 0.3266 | 0.333 | 0.3245 | 0.3316 | 32804800.0 |
| 2001-11-12 11:00:00 | AAPL | Stock | 0.3313 | 0.3327 | 0.325 | 0.3321 | 25149600.0 |
| 2001-11-12 12:00:00 | AAPL | Stock | 0.3321 | 0.3389 | 0.3313 | 0.3372 | 22848000.0 |
| 2001-11-12 13:00:00 | AAPL | Stock | 0.3373 | 0.3423 | 0.3355 | 0.3373 | 31494400.0 |
| 2001-11-12 14:00:00 | AAPL | Stock | 0.3375 | 0.338 | 0.3329 | 0.3366 | 8691200.0 |
| 2001-11-12 15:00:00 | AAPL | Stock | 0.3366 | 0.3373 | 0.3304 | 0.3345 | 26258400.0 |
| 2001-11-12 16:00:00 | AAPL | Stock | 0.3346 | 0.3361 | 0.3313 | 0.3348 | 4552800.0 |
| 2001-11-12 17:00:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3348 | 0.3348 | 44800.0 |
| 2001-11-12 08:00:00 | MSFT | Stock | 32.55 | 32.65 | 32.55 | 32.65 | 34400.0 |
| 2001-11-12 09:00:00 | MSFT | Stock | 32.65 | 32.65 | 31.825 | 32.3 | 10559400.0 |
| 2001-11-12 10:00:00 | MSFT | Stock | 32.3 | 32.58 | 32.14 | 32.575 | 10909200.0 |
| 2001-11-12 11:00:00 | MSFT | Stock | 32.555 | 32.575 | 32.255 | 32.4295 | 5722600.0 |
| 2001-11-12 12:00:00 | MSFT | Stock | 32.425 | 32.96 | 32.425 | 32.7895 | 6320800.0 |
| 2001-11-12 13:00:00 | MSFT | Stock | 32.79 | 33.025 | 32.775 | 32.9695 | 6285000.0 |
| 2001-11-12 14:00:00 | MSFT | Stock | 32.968 | 33.12 | 32.78 | 33.045 | 6137600.0 |
| 2001-11-12 15:00:00 | MSFT | Stock | 33.0455 | 33.22 | 32.845 | 32.89 | 9028800.0 |
| 2001-11-12 16:00:00 | MSFT | Stock | 32.89 | 33.05 | 32.5912 | 32.95 | 1556400.0 |
| 2001-11-12 17:00:00 | MSFT | Stock | 32.592 | 32.935 | 32.592 | 32.935 | 51600.0 |
| 2001-11-12 18:00:00 | MSFT | Stock | 32.935 | 32.935 | 32.925 | 32.925 | 2200.0 |
| 2001-11-12 08:00:00 | NVDA | Stock | 0.4375 | 0.4446 | 0.4262 | 0.4446 | 2208000.0 |
| 2001-11-12 09:00:00 | NVDA | Stock | 0.4425 | 0.4437 | 0.4282 | 0.4429 | 233544000.0 |
| 2001-11-12 10:00:00 | NVDA | Stock | 0.4432 | 0.4539 | 0.4417 | 0.4517 | 300336000.0 |
| 2001-11-12 11:00:00 | NVDA | Stock | 0.4522 | 0.4522 | 0.447 | 0.4507 | 92388000.0 |
| 2001-11-12 12:00:00 | NVDA | Stock | 0.4503 | 0.4612 | 0.45 | 0.4582 | 177048000.0 |
| 2001-11-12 13:00:00 | NVDA | Stock | 0.4582 | 0.4666 | 0.4577 | 0.4622 | 176304000.0 |
| 2001-11-12 14:00:00 | NVDA | Stock | 0.4622 | 0.4625 | 0.4557 | 0.4593 | 158904000.0 |
| 2001-11-12 15:00:00 | NVDA | Stock | 0.4593 | 0.4605 | 0.4529 | 0.4548 | 251700000.0 |
| 2001-11-12 16:00:00 | NVDA | Stock | 0.4552 | 0.4586 | 0.4542 | 0.455 | 20448000.0 |
| 2001-11-12 17:00:00 | NVDA | Stock | 0.4552 | 0.4552 | 0.4552 | 0.4552 | 120000.0 |
| 2001-11-12 18:00:00 | NVDA | Stock | 0.456 | 0.4562 | 0.456 | 0.4562 | 72000.0 |
| 2001-11-12 08:00:00 | AMZN | Stock | 0.3575 | 0.3575 | 0.3575 | 0.3575 | 64000.0 |
| 2001-11-12 09:00:00 | AMZN | Stock | 0.36 | 0.36 | 0.34 | 0.352 | 18442000.0 |
| 2001-11-12 10:00:00 | AMZN | Stock | 0.352 | 0.3608 | 0.35 | 0.3575 | 11672000.0 |
| 2001-11-12 11:00:00 | AMZN | Stock | 0.357 | 0.3575 | 0.352 | 0.354 | 5578000.0 |
| 2001-11-12 12:00:00 | AMZN | Stock | 0.355 | 0.3595 | 0.354 | 0.359 | 5462000.0 |
| 2001-11-12 13:00:00 | AMZN | Stock | 0.3585 | 0.362 | 0.3575 | 0.359 | 6280000.0 |
| 2001-11-12 14:00:00 | AMZN | Stock | 0.3595 | 0.36 | 0.353 | 0.353 | 4350000.0 |
| 2001-11-12 15:00:00 | AMZN | Stock | 0.3535 | 0.355 | 0.35 | 0.3525 | 16876000.0 |
| 2001-11-12 16:00:00 | AMZN | Stock | 0.352 | 0.355 | 0.35 | 0.355 | 3038000.0 |
| 2001-11-12 17:00:00 | AMZN | Stock | 0.3525 | 0.356 | 0.3525 | 0.3535 | 80000.0 |
| 2001-11-12 18:00:00 | AMZN | Stock | 0.355 | 0.3555 | 0.355 | 0.3555 | 26000.0 |
| 2001-11-12 09:00:00 | CL | Stock | 28.7 | 28.7 | 28.275 | 28.325 | 426200.0 |
| 2001-11-12 10:00:00 | CL | Stock | 28.325 | 28.55 | 28.31 | 28.32 | 604200.0 |
| 2001-11-12 11:00:00 | CL | Stock | 28.32 | 28.33 | 28.235 | 28.275 | 201800.0 |
| 2001-11-12 12:00:00 | CL | Stock | 28.275 | 28.325 | 28.205 | 28.23 | 278600.0 |
| 2001-11-12 13:00:00 | CL | Stock | 28.235 | 28.3 | 28.125 | 28.195 | 533800.0 |
| 2001-11-12 14:00:00 | CL | Stock | 28.195 | 28.295 | 28.19 | 28.295 | 382000.0 |
| 2001-11-12 15:00:00 | CL | Stock | 28.295 | 28.525 | 28.28 | 28.42 | 657400.0 |
> showing 50 of 17,365 rows — these rows as CSV