PREVIEW / stock_5min / 2001-11-16
file: by_date/stock_5min/2001/2001-11-16.parquet size: 1.6 MB rows: 109,897 symbols: 1,360
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-16 08:30:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3527 | 0.3527 | 5600.0 |
| 2001-11-16 08:35:00 | AAPL | Stock | 0.3477 | 0.3536 | 0.3464 | 0.3477 | 33600.0 |
| 2001-11-16 08:40:00 | AAPL | Stock | 0.3477 | 0.3477 | 0.3477 | 0.3477 | 50400.0 |
| 2001-11-16 08:45:00 | AAPL | Stock | 0.3477 | 0.3477 | 0.3429 | 0.3438 | 268800.0 |
| 2001-11-16 08:50:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3429 | 0.3438 | 89600.0 |
| 2001-11-16 08:55:00 | AAPL | Stock | 0.3441 | 0.3441 | 0.3441 | 0.3441 | 28000.0 |
| 2001-11-16 09:05:00 | AAPL | Stock | 0.3404 | 0.3436 | 0.3404 | 0.3436 | 11200.0 |
| 2001-11-16 09:10:00 | AAPL | Stock | 0.3436 | 0.3436 | 0.3436 | 0.3436 | 16800.0 |
| 2001-11-16 09:15:00 | AAPL | Stock | 0.3434 | 0.3436 | 0.3434 | 0.3436 | 16800.0 |
| 2001-11-16 09:20:00 | AAPL | Stock | 0.3443 | 0.3446 | 0.3443 | 0.3446 | 459200.0 |
| 2001-11-16 09:25:00 | AAPL | Stock | 0.3457 | 0.3457 | 0.3439 | 0.3439 | 1825600.0 |
| 2001-11-16 09:30:00 | AAPL | Stock | 0.3443 | 0.3445 | 0.342 | 0.343 | 6798400.0 |
| 2001-11-16 09:35:00 | AAPL | Stock | 0.3434 | 0.3434 | 0.3402 | 0.3404 | 3158400.0 |
| 2001-11-16 09:40:00 | AAPL | Stock | 0.3404 | 0.3413 | 0.3388 | 0.3411 | 9088800.0 |
| 2001-11-16 09:45:00 | AAPL | Stock | 0.3411 | 0.3436 | 0.3393 | 0.3398 | 14134400.0 |
| 2001-11-16 09:50:00 | AAPL | Stock | 0.3398 | 0.3414 | 0.3375 | 0.3379 | 7576800.0 |
| 2001-11-16 09:55:00 | AAPL | Stock | 0.3379 | 0.34 | 0.3366 | 0.3366 | 9844800.0 |
| 2001-11-16 10:00:00 | AAPL | Stock | 0.3366 | 0.338 | 0.3366 | 0.3371 | 8103200.0 |
| 2001-11-16 10:05:00 | AAPL | Stock | 0.3372 | 0.3414 | 0.3372 | 0.3413 | 6384000.0 |
| 2001-11-16 10:10:00 | AAPL | Stock | 0.3395 | 0.3418 | 0.3391 | 0.3395 | 5152000.0 |
| 2001-11-16 10:15:00 | AAPL | Stock | 0.3395 | 0.3409 | 0.3388 | 0.3409 | 1114400.0 |
| 2001-11-16 10:20:00 | AAPL | Stock | 0.3409 | 0.3416 | 0.3377 | 0.3377 | 1786400.0 |
| 2001-11-16 10:25:00 | AAPL | Stock | 0.3375 | 0.3384 | 0.337 | 0.3384 | 1797600.0 |
| 2001-11-16 10:30:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3369 | 0.3371 | 1657600.0 |
| 2001-11-16 10:35:00 | AAPL | Stock | 0.3372 | 0.3377 | 0.337 | 0.3377 | 1092000.0 |
| 2001-11-16 10:40:00 | AAPL | Stock | 0.3377 | 0.3382 | 0.3375 | 0.338 | 996800.0 |
| 2001-11-16 10:45:00 | AAPL | Stock | 0.3379 | 0.3384 | 0.3373 | 0.3373 | 1181600.0 |
| 2001-11-16 10:50:00 | AAPL | Stock | 0.3377 | 0.3382 | 0.337 | 0.3375 | 2245600.0 |
| 2001-11-16 10:55:00 | AAPL | Stock | 0.3375 | 0.338 | 0.337 | 0.3379 | 1226400.0 |
| 2001-11-16 11:00:00 | AAPL | Stock | 0.3378 | 0.338 | 0.3371 | 0.338 | 1769600.0 |
| 2001-11-16 11:05:00 | AAPL | Stock | 0.338 | 0.3381 | 0.337 | 0.3379 | 1803200.0 |
| 2001-11-16 11:10:00 | AAPL | Stock | 0.3379 | 0.3384 | 0.3377 | 0.3384 | 1836800.0 |
| 2001-11-16 11:15:00 | AAPL | Stock | 0.3386 | 0.3398 | 0.338 | 0.338 | 3880800.0 |
| 2001-11-16 11:20:00 | AAPL | Stock | 0.3384 | 0.3398 | 0.3384 | 0.3396 | 1148000.0 |
| 2001-11-16 11:25:00 | AAPL | Stock | 0.3393 | 0.3411 | 0.3393 | 0.3409 | 2172800.0 |
| 2001-11-16 11:30:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3384 | 0.3384 | 4020800.0 |
| 2001-11-16 11:35:00 | AAPL | Stock | 0.3386 | 0.3391 | 0.3371 | 0.3382 | 2055200.0 |
| 2001-11-16 11:40:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3379 | 0.3379 | 588000.0 |
| 2001-11-16 11:45:00 | AAPL | Stock | 0.3379 | 0.3384 | 0.3377 | 0.3384 | 1036000.0 |
| 2001-11-16 11:50:00 | AAPL | Stock | 0.3384 | 0.3388 | 0.338 | 0.3388 | 912800.0 |
| 2001-11-16 11:55:00 | AAPL | Stock | 0.3388 | 0.3388 | 0.338 | 0.3382 | 1041600.0 |
| 2001-11-16 12:00:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3375 | 0.3375 | 1108800.0 |
| 2001-11-16 12:05:00 | AAPL | Stock | 0.338 | 0.3384 | 0.337 | 0.3377 | 2732800.0 |
| 2001-11-16 12:10:00 | AAPL | Stock | 0.3377 | 0.338 | 0.337 | 0.3373 | 1640800.0 |
| 2001-11-16 12:15:00 | AAPL | Stock | 0.337 | 0.3373 | 0.3366 | 0.3366 | 2083200.0 |
| 2001-11-16 12:20:00 | AAPL | Stock | 0.3368 | 0.337 | 0.3361 | 0.3361 | 1495200.0 |
| 2001-11-16 12:25:00 | AAPL | Stock | 0.3361 | 0.3368 | 0.3355 | 0.3366 | 1870400.0 |
| 2001-11-16 12:30:00 | AAPL | Stock | 0.3366 | 0.337 | 0.3359 | 0.3366 | 1243200.0 |
| 2001-11-16 12:35:00 | AAPL | Stock | 0.3364 | 0.3375 | 0.3364 | 0.3368 | 1349600.0 |
| 2001-11-16 12:40:00 | AAPL | Stock | 0.3373 | 0.3373 | 0.3364 | 0.3371 | 935200.0 |
> showing 50 of 109,897 rows — these rows as CSV