PREVIEW / stock_5min / 2001-08-13
file: by_date/stock_5min/2001/2001-08-13.parquet size: 1.4 MB rows: 102,536 symbols: 1,324
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-13 08:05:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3411 | 0.3411 | 56000.0 |
| 2001-08-13 08:35:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3411 | 0.3411 | 56000.0 |
| 2001-08-13 09:25:00 | AAPL | Stock | 0.3404 | 0.3409 | 0.34 | 0.3405 | 100800.0 |
| 2001-08-13 09:30:00 | AAPL | Stock | 0.3411 | 0.3443 | 0.3409 | 0.3438 | 3987200.0 |
| 2001-08-13 09:35:00 | AAPL | Stock | 0.3438 | 0.3452 | 0.3425 | 0.3429 | 2783200.0 |
| 2001-08-13 09:40:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3416 | 0.3427 | 1758400.0 |
| 2001-08-13 09:45:00 | AAPL | Stock | 0.3427 | 0.3429 | 0.3416 | 0.3423 | 1579200.0 |
| 2001-08-13 09:50:00 | AAPL | Stock | 0.3429 | 0.3436 | 0.342 | 0.3429 | 761600.0 |
| 2001-08-13 09:55:00 | AAPL | Stock | 0.3429 | 0.3436 | 0.3421 | 0.343 | 924000.0 |
| 2001-08-13 10:00:00 | AAPL | Stock | 0.3434 | 0.3441 | 0.343 | 0.3439 | 1450400.0 |
| 2001-08-13 10:05:00 | AAPL | Stock | 0.3441 | 0.3446 | 0.3427 | 0.3443 | 1624000.0 |
| 2001-08-13 10:10:00 | AAPL | Stock | 0.3445 | 0.3445 | 0.3425 | 0.3443 | 2072000.0 |
| 2001-08-13 10:15:00 | AAPL | Stock | 0.3445 | 0.345 | 0.3434 | 0.3436 | 3925600.0 |
| 2001-08-13 10:20:00 | AAPL | Stock | 0.3438 | 0.3439 | 0.3429 | 0.3432 | 1876000.0 |
| 2001-08-13 10:25:00 | AAPL | Stock | 0.3434 | 0.3436 | 0.342 | 0.3427 | 2917600.0 |
| 2001-08-13 10:30:00 | AAPL | Stock | 0.3427 | 0.3429 | 0.3404 | 0.3409 | 2721600.0 |
| 2001-08-13 10:35:00 | AAPL | Stock | 0.3407 | 0.3409 | 0.3388 | 0.3402 | 2251200.0 |
| 2001-08-13 10:40:00 | AAPL | Stock | 0.3402 | 0.3405 | 0.335 | 0.3355 | 4519200.0 |
| 2001-08-13 10:45:00 | AAPL | Stock | 0.3355 | 0.3384 | 0.335 | 0.3366 | 3869600.0 |
| 2001-08-13 10:50:00 | AAPL | Stock | 0.337 | 0.338 | 0.3366 | 0.3379 | 2184000.0 |
| 2001-08-13 10:55:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3371 | 0.3375 | 2105600.0 |
| 2001-08-13 11:00:00 | AAPL | Stock | 0.3379 | 0.3402 | 0.3375 | 0.3389 | 2212000.0 |
| 2001-08-13 11:05:00 | AAPL | Stock | 0.3388 | 0.3402 | 0.338 | 0.3395 | 1377600.0 |
| 2001-08-13 11:10:00 | AAPL | Stock | 0.3395 | 0.34 | 0.3393 | 0.3393 | 1321600.0 |
| 2001-08-13 11:15:00 | AAPL | Stock | 0.3398 | 0.3405 | 0.3389 | 0.3391 | 621600.0 |
| 2001-08-13 11:20:00 | AAPL | Stock | 0.3389 | 0.3391 | 0.3373 | 0.3384 | 1288000.0 |
| 2001-08-13 11:25:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.338 | 0.3384 | 414400.0 |
| 2001-08-13 11:30:00 | AAPL | Stock | 0.3384 | 0.3393 | 0.3384 | 0.3386 | 907200.0 |
| 2001-08-13 11:35:00 | AAPL | Stock | 0.3386 | 0.3389 | 0.3375 | 0.3389 | 1344000.0 |
| 2001-08-13 11:40:00 | AAPL | Stock | 0.3388 | 0.3398 | 0.3388 | 0.3396 | 1304800.0 |
| 2001-08-13 11:45:00 | AAPL | Stock | 0.3398 | 0.3398 | 0.3379 | 0.3382 | 1131200.0 |
| 2001-08-13 11:50:00 | AAPL | Stock | 0.3384 | 0.3391 | 0.338 | 0.338 | 212800.0 |
| 2001-08-13 11:55:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.338 | 0.3382 | 593600.0 |
| 2001-08-13 12:00:00 | AAPL | Stock | 0.3388 | 0.3388 | 0.3379 | 0.3384 | 414400.0 |
| 2001-08-13 12:05:00 | AAPL | Stock | 0.3382 | 0.3384 | 0.3377 | 0.3379 | 980000.0 |
| 2001-08-13 12:10:00 | AAPL | Stock | 0.3379 | 0.3393 | 0.3379 | 0.3393 | 453600.0 |
| 2001-08-13 12:15:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3384 | 0.3391 | 425600.0 |
| 2001-08-13 12:20:00 | AAPL | Stock | 0.3389 | 0.3393 | 0.3384 | 0.3384 | 207200.0 |
| 2001-08-13 12:25:00 | AAPL | Stock | 0.3389 | 0.3396 | 0.3388 | 0.3395 | 168000.0 |
| 2001-08-13 12:30:00 | AAPL | Stock | 0.3389 | 0.3393 | 0.3384 | 0.3393 | 313600.0 |
| 2001-08-13 12:35:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.338 | 0.3391 | 341600.0 |
| 2001-08-13 12:40:00 | AAPL | Stock | 0.3391 | 0.3396 | 0.3386 | 0.3388 | 1075200.0 |
| 2001-08-13 12:45:00 | AAPL | Stock | 0.3386 | 0.3389 | 0.3384 | 0.3388 | 229600.0 |
| 2001-08-13 12:50:00 | AAPL | Stock | 0.3388 | 0.3388 | 0.338 | 0.3382 | 1198400.0 |
| 2001-08-13 12:55:00 | AAPL | Stock | 0.3382 | 0.3382 | 0.3375 | 0.3377 | 1579200.0 |
| 2001-08-13 13:00:00 | AAPL | Stock | 0.3379 | 0.338 | 0.3375 | 0.3379 | 1988000.0 |
| 2001-08-13 13:05:00 | AAPL | Stock | 0.338 | 0.338 | 0.3371 | 0.3379 | 1836800.0 |
| 2001-08-13 13:10:00 | AAPL | Stock | 0.3377 | 0.3382 | 0.3375 | 0.3377 | 1696800.0 |
| 2001-08-13 13:15:00 | AAPL | Stock | 0.3377 | 0.3384 | 0.3375 | 0.3377 | 1125600.0 |
| 2001-08-13 13:20:00 | AAPL | Stock | 0.3377 | 0.3384 | 0.3375 | 0.338 | 1142400.0 |
> showing 50 of 102,536 rows — these rows as CSV