PREVIEW / stock_5min / 2003-08-19
file: by_date/stock_5min/2003/2003-08-19.parquet size: 2.2 MB rows: 155,207 symbols: 1,610
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-08-19 08:45:00 | AAPL | Stock | 0.3636 | 0.3636 | 0.3636 | 0.3636 | 28000.0 |
| 2003-08-19 09:20:00 | AAPL | Stock | 0.3638 | 0.3638 | 0.3638 | 0.3638 | 28000.0 |
| 2003-08-19 09:25:00 | AAPL | Stock | 0.3639 | 0.3639 | 0.3636 | 0.3636 | 67200.0 |
| 2003-08-19 09:30:00 | AAPL | Stock | 0.3638 | 0.3639 | 0.363 | 0.3636 | 3052000.0 |
| 2003-08-19 09:35:00 | AAPL | Stock | 0.3632 | 0.3634 | 0.3571 | 0.3605 | 4926264.0 |
| 2003-08-19 09:40:00 | AAPL | Stock | 0.3607 | 0.3634 | 0.3602 | 0.3607 | 3472000.0 |
| 2003-08-19 09:45:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.36 | 0.3607 | 3561600.0 |
| 2003-08-19 09:50:00 | AAPL | Stock | 0.3611 | 0.3636 | 0.3607 | 0.3636 | 4960872.0 |
| 2003-08-19 09:55:00 | AAPL | Stock | 0.3638 | 0.3652 | 0.3607 | 0.3607 | 8067864.0 |
| 2003-08-19 10:00:00 | AAPL | Stock | 0.3613 | 0.3618 | 0.3607 | 0.3607 | 1727936.0 |
| 2003-08-19 10:05:00 | AAPL | Stock | 0.3609 | 0.3613 | 0.3595 | 0.36 | 2640512.0 |
| 2003-08-19 10:10:00 | AAPL | Stock | 0.36 | 0.3602 | 0.3593 | 0.3598 | 1886640.0 |
| 2003-08-19 10:15:00 | AAPL | Stock | 0.3596 | 0.3602 | 0.3593 | 0.36 | 3121384.0 |
| 2003-08-19 10:20:00 | AAPL | Stock | 0.36 | 0.3611 | 0.36 | 0.3607 | 1339184.0 |
| 2003-08-19 10:25:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3602 | 0.3602 | 1915200.0 |
| 2003-08-19 10:30:00 | AAPL | Stock | 0.3602 | 0.3609 | 0.3602 | 0.3609 | 1646400.0 |
| 2003-08-19 10:35:00 | AAPL | Stock | 0.3607 | 0.3625 | 0.3605 | 0.3623 | 2587312.0 |
| 2003-08-19 10:40:00 | AAPL | Stock | 0.3623 | 0.3627 | 0.3616 | 0.3616 | 392336.0 |
| 2003-08-19 10:45:00 | AAPL | Stock | 0.3616 | 0.3621 | 0.3609 | 0.3616 | 929600.0 |
| 2003-08-19 10:50:00 | AAPL | Stock | 0.3616 | 0.362 | 0.3611 | 0.3613 | 2740864.0 |
| 2003-08-19 10:55:00 | AAPL | Stock | 0.3613 | 0.3621 | 0.3611 | 0.362 | 763168.0 |
| 2003-08-19 11:00:00 | AAPL | Stock | 0.362 | 0.3621 | 0.3609 | 0.3614 | 1179584.0 |
| 2003-08-19 11:05:00 | AAPL | Stock | 0.3616 | 0.3621 | 0.3611 | 0.3611 | 1247736.0 |
| 2003-08-19 11:10:00 | AAPL | Stock | 0.3607 | 0.3611 | 0.3607 | 0.3611 | 439600.0 |
| 2003-08-19 11:15:00 | AAPL | Stock | 0.3609 | 0.3613 | 0.3607 | 0.3613 | 608608.0 |
| 2003-08-19 11:20:00 | AAPL | Stock | 0.3613 | 0.3613 | 0.3607 | 0.3609 | 405552.0 |
| 2003-08-19 11:25:00 | AAPL | Stock | 0.3609 | 0.3613 | 0.3607 | 0.3611 | 164640.0 |
| 2003-08-19 11:30:00 | AAPL | Stock | 0.3613 | 0.3616 | 0.3609 | 0.3614 | 552160.0 |
| 2003-08-19 11:35:00 | AAPL | Stock | 0.3614 | 0.3616 | 0.3598 | 0.3605 | 1153096.0 |
| 2003-08-19 11:40:00 | AAPL | Stock | 0.3605 | 0.3614 | 0.3605 | 0.3614 | 601440.0 |
| 2003-08-19 11:45:00 | AAPL | Stock | 0.3614 | 0.3616 | 0.3613 | 0.3616 | 543200.0 |
| 2003-08-19 11:50:00 | AAPL | Stock | 0.3616 | 0.362 | 0.3614 | 0.3618 | 560000.0 |
| 2003-08-19 11:55:00 | AAPL | Stock | 0.3618 | 0.3618 | 0.3616 | 0.3616 | 326928.0 |
| 2003-08-19 12:00:00 | AAPL | Stock | 0.3616 | 0.3621 | 0.3616 | 0.3621 | 565600.0 |
| 2003-08-19 12:05:00 | AAPL | Stock | 0.3621 | 0.3623 | 0.3619 | 0.3621 | 1316000.0 |
| 2003-08-19 12:10:00 | AAPL | Stock | 0.3623 | 0.3632 | 0.3623 | 0.363 | 2208472.0 |
| 2003-08-19 12:15:00 | AAPL | Stock | 0.363 | 0.3634 | 0.3629 | 0.3632 | 1565200.0 |
| 2003-08-19 12:20:00 | AAPL | Stock | 0.3632 | 0.3634 | 0.3627 | 0.3627 | 1019592.0 |
| 2003-08-19 12:25:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3618 | 0.3623 | 1193248.0 |
| 2003-08-19 12:30:00 | AAPL | Stock | 0.3623 | 0.3627 | 0.3621 | 0.3627 | 1293152.0 |
| 2003-08-19 12:35:00 | AAPL | Stock | 0.3627 | 0.3634 | 0.3627 | 0.3634 | 1224608.0 |
| 2003-08-19 12:40:00 | AAPL | Stock | 0.3632 | 0.3634 | 0.3618 | 0.362 | 1024800.0 |
| 2003-08-19 12:45:00 | AAPL | Stock | 0.362 | 0.3621 | 0.3614 | 0.362 | 848792.0 |
| 2003-08-19 12:50:00 | AAPL | Stock | 0.3618 | 0.3623 | 0.3616 | 0.362 | 1271200.0 |
| 2003-08-19 12:55:00 | AAPL | Stock | 0.3618 | 0.3629 | 0.3616 | 0.3627 | 1068088.0 |
| 2003-08-19 13:00:00 | AAPL | Stock | 0.3623 | 0.3625 | 0.362 | 0.362 | 509600.0 |
| 2003-08-19 13:05:00 | AAPL | Stock | 0.362 | 0.3621 | 0.3618 | 0.362 | 487200.0 |
| 2003-08-19 13:10:00 | AAPL | Stock | 0.362 | 0.362 | 0.3618 | 0.3618 | 117600.0 |
| 2003-08-19 13:15:00 | AAPL | Stock | 0.362 | 0.3625 | 0.3614 | 0.3614 | 1030064.0 |
| 2003-08-19 13:20:00 | AAPL | Stock | 0.3614 | 0.3616 | 0.3614 | 0.3614 | 192528.0 |
> showing 50 of 155,207 rows — these rows as CSV