PREVIEW / stock_1hour / 2001-10-29
file: by_date/stock_1hour/2001/2001-10-29.parquet size: 360 KB rows: 17,551 symbols: 1,355
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-10-29 08:00:00 | AAPL | Stock | 0.3332 | 0.3334 | 0.3332 | 0.3334 | 128800.0 |
| 2001-10-29 09:00:00 | AAPL | Stock | 0.3329 | 0.3334 | 0.3241 | 0.3282 | 26684000.0 |
| 2001-10-29 10:00:00 | AAPL | Stock | 0.3282 | 0.33 | 0.3229 | 0.3298 | 29344000.0 |
| 2001-10-29 11:00:00 | AAPL | Stock | 0.33 | 0.33 | 0.3254 | 0.3266 | 17836000.0 |
| 2001-10-29 12:00:00 | AAPL | Stock | 0.3263 | 0.3275 | 0.3229 | 0.3243 | 20949600.0 |
| 2001-10-29 13:00:00 | AAPL | Stock | 0.3243 | 0.3264 | 0.3223 | 0.3239 | 15125600.0 |
| 2001-10-29 14:00:00 | AAPL | Stock | 0.3245 | 0.325 | 0.32 | 0.3232 | 22377600.0 |
| 2001-10-29 15:00:00 | AAPL | Stock | 0.3227 | 0.3232 | 0.3134 | 0.3146 | 80925600.0 |
| 2001-10-29 16:00:00 | AAPL | Stock | 0.3148 | 0.3229 | 0.3132 | 0.3148 | 19510400.0 |
| 2001-10-29 17:00:00 | AAPL | Stock | 0.3148 | 0.3148 | 0.3148 | 0.3148 | 1226400.0 |
| 2001-10-29 08:00:00 | MSFT | Stock | 31.001 | 31.1 | 30.975 | 31.1 | 56600.0 |
| 2001-10-29 09:00:00 | MSFT | Stock | 31.15 | 31.2 | 30.6505 | 30.735 | 7291000.0 |
| 2001-10-29 10:00:00 | MSFT | Stock | 30.725 | 30.775 | 30.43 | 30.6605 | 9093000.0 |
| 2001-10-29 11:00:00 | MSFT | Stock | 30.655 | 30.665 | 30.345 | 30.46 | 4889000.0 |
| 2001-10-29 12:00:00 | MSFT | Stock | 30.46 | 30.56 | 30.365 | 30.435 | 4020000.0 |
| 2001-10-29 13:00:00 | MSFT | Stock | 30.435 | 30.475 | 30.125 | 30.14 | 5666400.0 |
| 2001-10-29 14:00:00 | MSFT | Stock | 30.14 | 30.2 | 30.025 | 30.145 | 7358400.0 |
| 2001-10-29 15:00:00 | MSFT | Stock | 30.145 | 30.1465 | 29.77 | 29.82 | 13538200.0 |
| 2001-10-29 16:00:00 | MSFT | Stock | 29.82 | 30.1102 | 29.69 | 29.82 | 1726600.0 |
| 2001-10-29 17:00:00 | MSFT | Stock | 29.755 | 30.7 | 29.4 | 29.4 | 226800.0 |
| 2001-10-29 18:00:00 | MSFT | Stock | 29.425 | 29.425 | 29.38 | 29.39 | 8000.0 |
| 2001-10-29 08:00:00 | NVDA | Stock | 0.3812 | 0.3833 | 0.3792 | 0.3829 | 288000.0 |
| 2001-10-29 09:00:00 | NVDA | Stock | 0.3833 | 0.3896 | 0.3708 | 0.3754 | 207768000.0 |
| 2001-10-29 10:00:00 | NVDA | Stock | 0.3754 | 0.3779 | 0.3693 | 0.3772 | 231360000.0 |
| 2001-10-29 11:00:00 | NVDA | Stock | 0.3772 | 0.3777 | 0.3637 | 0.3651 | 114900000.0 |
| 2001-10-29 12:00:00 | NVDA | Stock | 0.3653 | 0.3687 | 0.3621 | 0.3652 | 80916000.0 |
| 2001-10-29 13:00:00 | NVDA | Stock | 0.3654 | 0.3671 | 0.3592 | 0.3612 | 78744000.0 |
| 2001-10-29 14:00:00 | NVDA | Stock | 0.3612 | 0.3634 | 0.3562 | 0.3615 | 83772000.0 |
| 2001-10-29 15:00:00 | NVDA | Stock | 0.3627 | 0.3632 | 0.3502 | 0.3507 | 171588000.0 |
| 2001-10-29 16:00:00 | NVDA | Stock | 0.3506 | 0.3648 | 0.3487 | 0.35 | 20424000.0 |
| 2001-10-29 17:00:00 | NVDA | Stock | 0.35 | 0.3506 | 0.3478 | 0.3478 | 1284000.0 |
| 2001-10-29 18:00:00 | NVDA | Stock | 0.3478 | 0.3478 | 0.3462 | 0.3462 | 312000.0 |
| 2001-10-29 08:00:00 | AMZN | Stock | 0.3805 | 0.385 | 0.375 | 0.379 | 448000.0 |
| 2001-10-29 09:00:00 | AMZN | Stock | 0.3795 | 0.3825 | 0.368 | 0.379 | 19548000.0 |
| 2001-10-29 10:00:00 | AMZN | Stock | 0.379 | 0.383 | 0.374 | 0.381 | 13782000.0 |
| 2001-10-29 11:00:00 | AMZN | Stock | 0.3805 | 0.3825 | 0.375 | 0.377 | 6504000.0 |
| 2001-10-29 12:00:00 | AMZN | Stock | 0.377 | 0.3775 | 0.3725 | 0.375 | 6898000.0 |
| 2001-10-29 13:00:00 | AMZN | Stock | 0.375 | 0.376 | 0.37 | 0.37 | 9142000.0 |
| 2001-10-29 14:00:00 | AMZN | Stock | 0.3705 | 0.373 | 0.354 | 0.362 | 23442000.0 |
| 2001-10-29 15:00:00 | AMZN | Stock | 0.362 | 0.365 | 0.352 | 0.3535 | 19588000.0 |
| 2001-10-29 16:00:00 | AMZN | Stock | 0.3525 | 0.3595 | 0.351 | 0.3525 | 2154000.0 |
| 2001-10-29 17:00:00 | AMZN | Stock | 0.3515 | 0.3525 | 0.35 | 0.351 | 390000.0 |
| 2001-10-29 18:00:00 | AMZN | Stock | 0.3505 | 0.3515 | 0.35 | 0.35 | 124000.0 |
| 2001-10-29 09:00:00 | CL | Stock | 29.2 | 29.205 | 29.03 | 29.15 | 144600.0 |
| 2001-10-29 10:00:00 | CL | Stock | 29.15 | 29.22 | 29.0 | 29.21 | 342200.0 |
| 2001-10-29 11:00:00 | CL | Stock | 29.2 | 29.22 | 29.025 | 29.025 | 183400.0 |
| 2001-10-29 12:00:00 | CL | Stock | 29.03 | 29.05 | 28.485 | 28.485 | 839600.0 |
| 2001-10-29 13:00:00 | CL | Stock | 28.5 | 28.61 | 28.445 | 28.495 | 564200.0 |
| 2001-10-29 14:00:00 | CL | Stock | 28.49 | 28.9 | 28.475 | 28.9 | 839400.0 |
| 2001-10-29 15:00:00 | CL | Stock | 28.9 | 28.945 | 28.775 | 28.82 | 1082600.0 |
> showing 50 of 17,551 rows — these rows as CSV