PREVIEW / stock_5min / 2003-06-20
file: by_date/stock_5min/2003/2003-06-20.parquet size: 2.2 MB rows: 156,829 symbols: 1,586
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-20 08:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3461 | 0.3461 | 29680.0 |
| 2003-06-20 08:20:00 | AAPL | Stock | 0.3468 | 0.3468 | 0.3468 | 0.3468 | 22400.0 |
| 2003-06-20 08:45:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 6608.0 |
| 2003-06-20 09:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 28000.0 |
| 2003-06-20 09:05:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3471 | 0.3471 | 22400.0 |
| 2003-06-20 09:15:00 | AAPL | Stock | 0.3463 | 0.3463 | 0.3463 | 0.3463 | 5600.0 |
| 2003-06-20 09:20:00 | AAPL | Stock | 0.3463 | 0.3463 | 0.3438 | 0.3447 | 104272.0 |
| 2003-06-20 09:25:00 | AAPL | Stock | 0.3473 | 0.3488 | 0.3459 | 0.348 | 1655472.0 |
| 2003-06-20 09:30:00 | AAPL | Stock | 0.3455 | 0.3488 | 0.3441 | 0.3474 | 21210112.0 |
| 2003-06-20 09:35:00 | AAPL | Stock | 0.3471 | 0.3473 | 0.3439 | 0.3457 | 5003264.0 |
| 2003-06-20 09:40:00 | AAPL | Stock | 0.3457 | 0.3471 | 0.345 | 0.3454 | 8352400.0 |
| 2003-06-20 09:45:00 | AAPL | Stock | 0.3457 | 0.3479 | 0.3454 | 0.3472 | 4882192.0 |
| 2003-06-20 09:50:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3454 | 0.3461 | 3466400.0 |
| 2003-06-20 09:55:00 | AAPL | Stock | 0.3459 | 0.3464 | 0.3453 | 0.3461 | 3670128.0 |
| 2003-06-20 10:00:00 | AAPL | Stock | 0.3459 | 0.3473 | 0.3452 | 0.3471 | 4541432.0 |
| 2003-06-20 10:05:00 | AAPL | Stock | 0.3471 | 0.3477 | 0.3466 | 0.3471 | 4010216.0 |
| 2003-06-20 10:10:00 | AAPL | Stock | 0.3471 | 0.3496 | 0.3471 | 0.3491 | 6139448.0 |
| 2003-06-20 10:15:00 | AAPL | Stock | 0.3488 | 0.3489 | 0.3454 | 0.3455 | 6567288.0 |
| 2003-06-20 10:20:00 | AAPL | Stock | 0.3454 | 0.3477 | 0.3454 | 0.3461 | 6467552.0 |
| 2003-06-20 10:25:00 | AAPL | Stock | 0.3455 | 0.3457 | 0.3443 | 0.3446 | 4404848.0 |
| 2003-06-20 10:30:00 | AAPL | Stock | 0.3446 | 0.3459 | 0.3439 | 0.3455 | 2827944.0 |
| 2003-06-20 10:35:00 | AAPL | Stock | 0.3454 | 0.3455 | 0.3439 | 0.3439 | 2445016.0 |
| 2003-06-20 10:40:00 | AAPL | Stock | 0.3443 | 0.345 | 0.3441 | 0.345 | 2755200.0 |
| 2003-06-20 10:45:00 | AAPL | Stock | 0.3448 | 0.3454 | 0.3441 | 0.3448 | 2580312.0 |
| 2003-06-20 10:50:00 | AAPL | Stock | 0.3448 | 0.345 | 0.3439 | 0.3441 | 2187584.0 |
| 2003-06-20 10:55:00 | AAPL | Stock | 0.3443 | 0.3446 | 0.3438 | 0.3438 | 3659600.0 |
| 2003-06-20 11:00:00 | AAPL | Stock | 0.3438 | 0.3445 | 0.3436 | 0.3436 | 4634448.0 |
| 2003-06-20 11:05:00 | AAPL | Stock | 0.3438 | 0.3443 | 0.3436 | 0.3438 | 3711624.0 |
| 2003-06-20 11:10:00 | AAPL | Stock | 0.3438 | 0.3445 | 0.3436 | 0.3443 | 9079560.0 |
| 2003-06-20 11:15:00 | AAPL | Stock | 0.3443 | 0.3459 | 0.3441 | 0.3457 | 8417640.0 |
| 2003-06-20 11:20:00 | AAPL | Stock | 0.3457 | 0.3473 | 0.3455 | 0.3468 | 5868800.0 |
| 2003-06-20 11:25:00 | AAPL | Stock | 0.3466 | 0.3491 | 0.3466 | 0.3491 | 3732400.0 |
| 2003-06-20 11:30:00 | AAPL | Stock | 0.3491 | 0.3495 | 0.3468 | 0.347 | 11088448.0 |
| 2003-06-20 11:35:00 | AAPL | Stock | 0.3471 | 0.3475 | 0.3464 | 0.3471 | 2100000.0 |
| 2003-06-20 11:40:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.347 | 0.3473 | 1232280.0 |
| 2003-06-20 11:45:00 | AAPL | Stock | 0.3477 | 0.348 | 0.3466 | 0.3471 | 688800.0 |
| 2003-06-20 11:50:00 | AAPL | Stock | 0.3468 | 0.347 | 0.3457 | 0.3461 | 1928360.0 |
| 2003-06-20 11:55:00 | AAPL | Stock | 0.3461 | 0.3461 | 0.3457 | 0.3459 | 1178800.0 |
| 2003-06-20 12:00:00 | AAPL | Stock | 0.3461 | 0.3464 | 0.3459 | 0.3463 | 1130472.0 |
| 2003-06-20 12:05:00 | AAPL | Stock | 0.3461 | 0.3464 | 0.3461 | 0.3461 | 549976.0 |
| 2003-06-20 12:10:00 | AAPL | Stock | 0.3463 | 0.3464 | 0.3461 | 0.3463 | 711312.0 |
| 2003-06-20 12:15:00 | AAPL | Stock | 0.3461 | 0.3464 | 0.3461 | 0.3463 | 1574552.0 |
| 2003-06-20 12:20:00 | AAPL | Stock | 0.3463 | 0.3463 | 0.3458 | 0.3463 | 1320704.0 |
| 2003-06-20 12:25:00 | AAPL | Stock | 0.3463 | 0.3479 | 0.3463 | 0.3466 | 2181200.0 |
| 2003-06-20 12:30:00 | AAPL | Stock | 0.3464 | 0.3482 | 0.3464 | 0.348 | 1390760.0 |
| 2003-06-20 12:35:00 | AAPL | Stock | 0.348 | 0.348 | 0.3477 | 0.3477 | 1288000.0 |
| 2003-06-20 12:40:00 | AAPL | Stock | 0.3477 | 0.3482 | 0.3475 | 0.3477 | 4424000.0 |
| 2003-06-20 12:45:00 | AAPL | Stock | 0.3477 | 0.348 | 0.3475 | 0.3477 | 1612800.0 |
| 2003-06-20 12:50:00 | AAPL | Stock | 0.3475 | 0.3477 | 0.3475 | 0.3475 | 330400.0 |
| 2003-06-20 12:55:00 | AAPL | Stock | 0.3475 | 0.3477 | 0.3471 | 0.3471 | 1041600.0 |
> showing 50 of 156,829 rows — these rows as CSV