PREVIEW / stock_1hour / 2001-08-29
file: by_date/stock_1hour/2001/2001-08-29.parquet size: 359 KB rows: 16,858 symbols: 1,325
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-08-29 08:00:00 | AAPL | Stock | 0.3296 | 0.3304 | 0.3257 | 0.3304 | 207200.0 |
| 2001-08-29 09:00:00 | AAPL | Stock | 0.3304 | 0.3363 | 0.3288 | 0.3318 | 17500000.0 |
| 2001-08-29 10:00:00 | AAPL | Stock | 0.3318 | 0.3318 | 0.3239 | 0.3284 | 25972800.0 |
| 2001-08-29 11:00:00 | AAPL | Stock | 0.3275 | 0.3316 | 0.327 | 0.3279 | 12392800.0 |
| 2001-08-29 12:00:00 | AAPL | Stock | 0.3275 | 0.3295 | 0.3263 | 0.3266 | 14957600.0 |
| 2001-08-29 13:00:00 | AAPL | Stock | 0.3266 | 0.3277 | 0.3236 | 0.3245 | 33101600.0 |
| 2001-08-29 14:00:00 | AAPL | Stock | 0.3245 | 0.325 | 0.3223 | 0.3225 | 45847200.0 |
| 2001-08-29 15:00:00 | AAPL | Stock | 0.3229 | 0.3238 | 0.3184 | 0.3184 | 51441600.0 |
| 2001-08-29 16:00:00 | AAPL | Stock | 0.3186 | 0.3239 | 0.3182 | 0.3184 | 10880800.0 |
| 2001-08-29 17:00:00 | AAPL | Stock | 0.3184 | 0.3188 | 0.3184 | 0.3188 | 414400.0 |
| 2001-08-29 18:00:00 | AAPL | Stock | 0.3188 | 0.3188 | 0.3188 | 0.3188 | 5600.0 |
| 2001-08-29 08:00:00 | MSFT | Stock | 30.37 | 30.66 | 30.25 | 30.55 | 70000.0 |
| 2001-08-29 09:00:00 | MSFT | Stock | 30.51 | 30.65 | 30.275 | 30.36 | 5928800.0 |
| 2001-08-29 10:00:00 | MSFT | Stock | 30.365 | 30.365 | 29.77 | 30.02 | 10720200.0 |
| 2001-08-29 11:00:00 | MSFT | Stock | 30.02 | 30.15 | 29.9 | 29.97 | 4165400.0 |
| 2001-08-29 12:00:00 | MSFT | Stock | 29.9745 | 30.1495 | 29.97 | 30.085 | 3650600.0 |
| 2001-08-29 13:00:00 | MSFT | Stock | 30.095 | 30.375 | 29.9505 | 30.15 | 4529200.0 |
| 2001-08-29 14:00:00 | MSFT | Stock | 30.15 | 30.355 | 30.035 | 30.095 | 5017000.0 |
| 2001-08-29 15:00:00 | MSFT | Stock | 30.08 | 30.3955 | 30.05 | 30.125 | 6194000.0 |
| 2001-08-29 16:00:00 | MSFT | Stock | 30.125 | 30.275 | 30.055 | 30.105 | 3322000.0 |
| 2001-08-29 17:00:00 | MSFT | Stock | 30.105 | 30.125 | 30.0 | 30.0 | 61600.0 |
| 2001-08-29 18:00:00 | MSFT | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 800.0 |
| 2001-08-29 08:00:00 | NVDA | Stock | 0.3604 | 0.3683 | 0.3542 | 0.3643 | 5472000.0 |
| 2001-08-29 09:00:00 | NVDA | Stock | 0.3646 | 0.3661 | 0.3563 | 0.3585 | 187176000.0 |
| 2001-08-29 10:00:00 | NVDA | Stock | 0.3583 | 0.3584 | 0.3531 | 0.3571 | 264384000.0 |
| 2001-08-29 11:00:00 | NVDA | Stock | 0.3567 | 0.3583 | 0.3548 | 0.3552 | 142848000.0 |
| 2001-08-29 12:00:00 | NVDA | Stock | 0.3552 | 0.3563 | 0.354 | 0.3552 | 91824000.0 |
| 2001-08-29 13:00:00 | NVDA | Stock | 0.3554 | 0.3573 | 0.3545 | 0.3571 | 130344000.0 |
| 2001-08-29 14:00:00 | NVDA | Stock | 0.3569 | 0.3577 | 0.3531 | 0.3542 | 177264000.0 |
| 2001-08-29 15:00:00 | NVDA | Stock | 0.3542 | 0.3544 | 0.3481 | 0.351 | 298608000.0 |
| 2001-08-29 16:00:00 | NVDA | Stock | 0.3512 | 0.355 | 0.3458 | 0.3458 | 21000000.0 |
| 2001-08-29 17:00:00 | NVDA | Stock | 0.3458 | 0.3516 | 0.3418 | 0.3458 | 4968000.0 |
| 2001-08-29 18:00:00 | NVDA | Stock | 0.3458 | 0.3458 | 0.3446 | 0.3446 | 264000.0 |
| 2001-08-29 08:00:00 | AMZN | Stock | 0.4975 | 0.5035 | 0.485 | 0.503 | 330000.0 |
| 2001-08-29 09:00:00 | AMZN | Stock | 0.5025 | 0.505 | 0.483 | 0.489 | 6770000.0 |
| 2001-08-29 10:00:00 | AMZN | Stock | 0.4895 | 0.49 | 0.474 | 0.477 | 13924000.0 |
| 2001-08-29 11:00:00 | AMZN | Stock | 0.4765 | 0.477 | 0.4705 | 0.471 | 5244000.0 |
| 2001-08-29 12:00:00 | AMZN | Stock | 0.471 | 0.477 | 0.47 | 0.473 | 5048000.0 |
| 2001-08-29 13:00:00 | AMZN | Stock | 0.4725 | 0.475 | 0.4655 | 0.4655 | 9082000.0 |
| 2001-08-29 14:00:00 | AMZN | Stock | 0.4655 | 0.468 | 0.4515 | 0.453 | 11272000.0 |
| 2001-08-29 15:00:00 | AMZN | Stock | 0.4525 | 0.47 | 0.4505 | 0.46 | 18624000.0 |
| 2001-08-29 16:00:00 | AMZN | Stock | 0.46 | 0.465 | 0.4585 | 0.4595 | 1006000.0 |
| 2001-08-29 17:00:00 | AMZN | Stock | 0.4595 | 0.4625 | 0.4595 | 0.4595 | 206000.0 |
| 2001-08-29 18:00:00 | AMZN | Stock | 0.46 | 0.46 | 0.46 | 0.46 | 12000.0 |
| 2001-08-29 09:00:00 | CL | Stock | 27.48 | 27.48 | 27.265 | 27.34 | 161000.0 |
| 2001-08-29 10:00:00 | CL | Stock | 27.315 | 27.34 | 27.15 | 27.245 | 263600.0 |
| 2001-08-29 11:00:00 | CL | Stock | 27.25 | 27.3 | 27.2 | 27.24 | 82600.0 |
| 2001-08-29 12:00:00 | CL | Stock | 27.245 | 27.365 | 27.225 | 27.325 | 236600.0 |
| 2001-08-29 13:00:00 | CL | Stock | 27.325 | 27.425 | 27.25 | 27.3 | 269200.0 |
| 2001-08-29 14:00:00 | CL | Stock | 27.305 | 27.335 | 27.22 | 27.275 | 182400.0 |
> showing 50 of 16,858 rows — these rows as CSV