PREVIEW / stock_1hour / 2001-08-30
file: by_date/stock_1hour/2001/2001-08-30.parquet size: 363 KB rows: 17,069 symbols: 1,334
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-30 08:00:00 | AAPL | Stock | 0.3175 | 0.3188 | 0.3175 | 0.3175 | 901600.0 |
| 2001-08-30 09:00:00 | AAPL | Stock | 0.3175 | 0.3221 | 0.3143 | 0.3204 | 32065600.0 |
| 2001-08-30 10:00:00 | AAPL | Stock | 0.3204 | 0.3223 | 0.3164 | 0.3179 | 49744800.0 |
| 2001-08-30 11:00:00 | AAPL | Stock | 0.3184 | 0.3204 | 0.3086 | 0.3152 | 57988000.0 |
| 2001-08-30 12:00:00 | AAPL | Stock | 0.315 | 0.3205 | 0.3148 | 0.3173 | 28985600.0 |
| 2001-08-30 13:00:00 | AAPL | Stock | 0.3173 | 0.3198 | 0.3152 | 0.3157 | 33510400.0 |
| 2001-08-30 14:00:00 | AAPL | Stock | 0.3157 | 0.3211 | 0.3146 | 0.3211 | 30923200.0 |
| 2001-08-30 15:00:00 | AAPL | Stock | 0.3211 | 0.3246 | 0.3179 | 0.3184 | 60177600.0 |
| 2001-08-30 16:00:00 | AAPL | Stock | 0.3182 | 0.3195 | 0.3179 | 0.3184 | 24684800.0 |
| 2001-08-30 17:00:00 | AAPL | Stock | 0.3179 | 0.3179 | 0.3179 | 0.3179 | 33600.0 |
| 2001-08-30 18:00:00 | AAPL | Stock | 0.3171 | 0.3171 | 0.3171 | 0.3171 | 22400.0 |
| 2001-08-30 08:00:00 | MSFT | Stock | 29.9 | 30.115 | 29.3 | 29.37 | 249800.0 |
| 2001-08-30 09:00:00 | MSFT | Stock | 29.375 | 29.83 | 29.25 | 29.615 | 12332200.0 |
| 2001-08-30 10:00:00 | MSFT | Stock | 29.61 | 29.645 | 28.7 | 28.8 | 16872400.0 |
| 2001-08-30 11:00:00 | MSFT | Stock | 28.795 | 28.885 | 28.465 | 28.575 | 15706400.0 |
| 2001-08-30 12:00:00 | MSFT | Stock | 28.575 | 28.725 | 28.555 | 28.63 | 7404800.0 |
| 2001-08-30 13:00:00 | MSFT | Stock | 28.635 | 28.705 | 28.475 | 28.495 | 4508600.0 |
| 2001-08-30 14:00:00 | MSFT | Stock | 28.475 | 28.7 | 28.26 | 28.645 | 13785800.0 |
| 2001-08-30 15:00:00 | MSFT | Stock | 28.66 | 28.675 | 28.3995 | 28.46 | 16399400.0 |
| 2001-08-30 16:00:00 | MSFT | Stock | 28.455 | 28.886 | 28.42 | 28.47 | 1902600.0 |
| 2001-08-30 17:00:00 | MSFT | Stock | 28.465 | 28.465 | 28.415 | 28.465 | 13800.0 |
| 2001-08-30 18:00:00 | MSFT | Stock | 28.4852 | 28.575 | 28.415 | 28.415 | 51600.0 |
| 2001-08-30 08:00:00 | NVDA | Stock | 0.351 | 0.351 | 0.3442 | 0.3442 | 1080000.0 |
| 2001-08-30 09:00:00 | NVDA | Stock | 0.345 | 0.3469 | 0.3369 | 0.3453 | 231144000.0 |
| 2001-08-30 10:00:00 | NVDA | Stock | 0.3454 | 0.3462 | 0.3388 | 0.3404 | 232128000.0 |
| 2001-08-30 11:00:00 | NVDA | Stock | 0.3398 | 0.3445 | 0.3388 | 0.3438 | 200184000.0 |
| 2001-08-30 12:00:00 | NVDA | Stock | 0.3437 | 0.3472 | 0.3435 | 0.3458 | 133320000.0 |
| 2001-08-30 13:00:00 | NVDA | Stock | 0.3461 | 0.35 | 0.3453 | 0.3456 | 148392000.0 |
| 2001-08-30 14:00:00 | NVDA | Stock | 0.3455 | 0.3485 | 0.3439 | 0.348 | 159312000.0 |
| 2001-08-30 15:00:00 | NVDA | Stock | 0.348 | 0.3525 | 0.345 | 0.3501 | 229056000.0 |
| 2001-08-30 16:00:00 | NVDA | Stock | 0.35 | 0.3514 | 0.349 | 0.35 | 9480000.0 |
| 2001-08-30 17:00:00 | NVDA | Stock | 0.3496 | 0.3498 | 0.3477 | 0.3498 | 408000.0 |
| 2001-08-30 18:00:00 | NVDA | Stock | 0.3492 | 0.3492 | 0.3473 | 0.3473 | 408000.0 |
| 2001-08-30 08:00:00 | AMZN | Stock | 0.4595 | 0.4595 | 0.4595 | 0.4595 | 20000.0 |
| 2001-08-30 09:00:00 | AMZN | Stock | 0.459 | 0.4745 | 0.4375 | 0.4635 | 19422000.0 |
| 2001-08-30 10:00:00 | AMZN | Stock | 0.4635 | 0.466 | 0.4465 | 0.4465 | 6654000.0 |
| 2001-08-30 11:00:00 | AMZN | Stock | 0.4465 | 0.4525 | 0.436 | 0.4505 | 15558000.0 |
| 2001-08-30 12:00:00 | AMZN | Stock | 0.451 | 0.4515 | 0.4435 | 0.4445 | 7510000.0 |
| 2001-08-30 13:00:00 | AMZN | Stock | 0.445 | 0.4505 | 0.4345 | 0.4355 | 12264000.0 |
| 2001-08-30 14:00:00 | AMZN | Stock | 0.4355 | 0.437 | 0.4275 | 0.4355 | 15344000.0 |
| 2001-08-30 15:00:00 | AMZN | Stock | 0.435 | 0.445 | 0.43 | 0.4345 | 18566000.0 |
| 2001-08-30 16:00:00 | AMZN | Stock | 0.435 | 0.4415 | 0.4325 | 0.4345 | 4512000.0 |
| 2001-08-30 17:00:00 | AMZN | Stock | 0.4375 | 0.4555 | 0.4315 | 0.4555 | 72000.0 |
| 2001-08-30 18:00:00 | AMZN | Stock | 0.4405 | 0.4405 | 0.4345 | 0.4345 | 102000.0 |
| 2001-08-30 09:00:00 | CL | Stock | 27.275 | 27.45 | 27.22 | 27.4 | 245800.0 |
| 2001-08-30 10:00:00 | CL | Stock | 27.405 | 27.415 | 27.15 | 27.165 | 500400.0 |
| 2001-08-30 11:00:00 | CL | Stock | 27.16 | 27.265 | 27.01 | 27.265 | 319000.0 |
| 2001-08-30 12:00:00 | CL | Stock | 27.25 | 27.35 | 27.175 | 27.255 | 356200.0 |
| 2001-08-30 13:00:00 | CL | Stock | 27.255 | 27.275 | 27.165 | 27.18 | 119400.0 |
| 2001-08-30 14:00:00 | CL | Stock | 27.18 | 27.18 | 27.0 | 27.09 | 298600.0 |
> showing 50 of 17,069 rows — these rows as CSV