PREVIEW / stock_5min / 2001-01-22
file: by_date/stock_5min/2001/2001-01-22.parquet size: 1.3 MB rows: 97,556 symbols: 1,264
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-01-22 08:00:00 | AAPL | Stock | 0.3304 | 0.3449 | 0.3304 | 0.3348 | 431200.0 |
| 2001-01-22 08:05:00 | AAPL | Stock | 0.3371 | 0.3371 | 0.3304 | 0.3304 | 151200.0 |
| 2001-01-22 08:10:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.3304 | 0.3304 | 168000.0 |
| 2001-01-22 08:15:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.3281 | 0.3304 | 263200.0 |
| 2001-01-22 08:20:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3326 | 0.3326 | 16800.0 |
| 2001-01-22 08:25:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.327 | 0.3304 | 16800.0 |
| 2001-01-22 08:30:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3348 | 0.3348 | 50400.0 |
| 2001-01-22 08:40:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3348 | 0.3348 | 16800.0 |
| 2001-01-22 08:45:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3348 | 0.3348 | 5600.0 |
| 2001-01-22 08:50:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3326 | 0.3326 | 78400.0 |
| 2001-01-22 08:55:00 | AAPL | Stock | 0.3309 | 0.3326 | 0.3304 | 0.3326 | 16800.0 |
| 2001-01-22 09:00:00 | AAPL | Stock | 0.3337 | 0.3337 | 0.3337 | 0.3337 | 33600.0 |
| 2001-01-22 09:05:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3348 | 0.3348 | 28000.0 |
| 2001-01-22 09:10:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3348 | 0.3348 | 5600.0 |
| 2001-01-22 09:15:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3348 | 0.3382 | 1450400.0 |
| 2001-01-22 09:20:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3371 | 0.3371 | 1108800.0 |
| 2001-01-22 09:25:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3359 | 0.3415 | 1624000.0 |
| 2001-01-22 09:30:00 | AAPL | Stock | 0.3404 | 0.3504 | 0.3393 | 0.3415 | 20316800.0 |
| 2001-01-22 09:35:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3393 | 0.3393 | 10561600.0 |
| 2001-01-22 09:40:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3304 | 0.3326 | 14610400.0 |
| 2001-01-22 09:45:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3292 | 0.3326 | 16122400.0 |
| 2001-01-22 09:50:00 | AAPL | Stock | 0.3326 | 0.3359 | 0.3304 | 0.3359 | 19829600.0 |
| 2001-01-22 09:55:00 | AAPL | Stock | 0.3359 | 0.3426 | 0.3348 | 0.3415 | 11771200.0 |
| 2001-01-22 10:00:00 | AAPL | Stock | 0.3415 | 0.3482 | 0.3404 | 0.3471 | 13109600.0 |
| 2001-01-22 10:05:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3393 | 0.3404 | 21929600.0 |
| 2001-01-22 10:10:00 | AAPL | Stock | 0.3404 | 0.3426 | 0.3393 | 0.3415 | 9307200.0 |
| 2001-01-22 10:15:00 | AAPL | Stock | 0.3404 | 0.3426 | 0.3404 | 0.3415 | 5051200.0 |
| 2001-01-22 10:20:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3393 | 0.3393 | 2156000.0 |
| 2001-01-22 10:25:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3382 | 0.3382 | 9620800.0 |
| 2001-01-22 10:30:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3359 | 0.3371 | 16710400.0 |
| 2001-01-22 10:35:00 | AAPL | Stock | 0.3382 | 0.3404 | 0.3371 | 0.3393 | 3203200.0 |
| 2001-01-22 10:40:00 | AAPL | Stock | 0.3393 | 0.3415 | 0.3382 | 0.3415 | 3276000.0 |
| 2001-01-22 10:45:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3393 | 0.3393 | 4480000.0 |
| 2001-01-22 10:50:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3382 | 0.3382 | 4351200.0 |
| 2001-01-22 10:55:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3382 | 0.3393 | 8338400.0 |
| 2001-01-22 11:00:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3382 | 0.3393 | 4765600.0 |
| 2001-01-22 11:05:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3371 | 0.3371 | 3096800.0 |
| 2001-01-22 11:10:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3371 | 0.3393 | 5320000.0 |
| 2001-01-22 11:15:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3371 | 0.3382 | 1187200.0 |
| 2001-01-22 11:20:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3371 | 0.3371 | 7347200.0 |
| 2001-01-22 11:25:00 | AAPL | Stock | 0.3382 | 0.3387 | 0.3359 | 0.3371 | 4379200.0 |
| 2001-01-22 11:30:00 | AAPL | Stock | 0.3371 | 0.3382 | 0.3371 | 0.3382 | 6512800.0 |
| 2001-01-22 11:35:00 | AAPL | Stock | 0.3382 | 0.3382 | 0.3371 | 0.3382 | 3147200.0 |
| 2001-01-22 11:40:00 | AAPL | Stock | 0.3382 | 0.3382 | 0.3371 | 0.3371 | 1388800.0 |
| 2001-01-22 11:45:00 | AAPL | Stock | 0.3376 | 0.3382 | 0.3359 | 0.3371 | 4183200.0 |
| 2001-01-22 11:50:00 | AAPL | Stock | 0.3382 | 0.3382 | 0.3359 | 0.3359 | 1848000.0 |
| 2001-01-22 11:55:00 | AAPL | Stock | 0.3359 | 0.3382 | 0.3359 | 0.3371 | 1265600.0 |
| 2001-01-22 12:00:00 | AAPL | Stock | 0.3371 | 0.3371 | 0.3359 | 0.3371 | 4597600.0 |
| 2001-01-22 12:05:00 | AAPL | Stock | 0.3371 | 0.3382 | 0.3359 | 0.3371 | 3556000.0 |
| 2001-01-22 12:10:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3359 | 0.3371 | 9184000.0 |
> showing 50 of 97,556 rows — these rows as CSV