PREVIEW / stock_5min / 2003-07-14
file: by_date/stock_5min/2003/2003-07-14.parquet size: 2.2 MB rows: 156,147 symbols: 1,596
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-07-14 08:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3554 | 0.3566 | 39200.0 |
| 2003-07-14 08:25:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3589 | 0.3589 | 11200.0 |
| 2003-07-14 08:40:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3598 | 0.3598 | 121800.0 |
| 2003-07-14 08:45:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3595 | 0.3595 | 72800.0 |
| 2003-07-14 08:50:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3598 | 0.3598 | 16800.0 |
| 2003-07-14 09:05:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3607 | 0.3607 | 33600.0 |
| 2003-07-14 09:10:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3598 | 0.3607 | 67200.0 |
| 2003-07-14 09:15:00 | AAPL | Stock | 0.3607 | 0.3612 | 0.3607 | 0.3612 | 28000.0 |
| 2003-07-14 09:25:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3564 | 0.3566 | 1108800.0 |
| 2003-07-14 09:30:00 | AAPL | Stock | 0.3575 | 0.3582 | 0.3557 | 0.3571 | 7343784.0 |
| 2003-07-14 09:35:00 | AAPL | Stock | 0.3571 | 0.3586 | 0.3563 | 0.3563 | 3467968.0 |
| 2003-07-14 09:40:00 | AAPL | Stock | 0.3563 | 0.3579 | 0.3555 | 0.3564 | 5417832.0 |
| 2003-07-14 09:45:00 | AAPL | Stock | 0.3566 | 0.357 | 0.355 | 0.3557 | 2531984.0 |
| 2003-07-14 09:50:00 | AAPL | Stock | 0.3552 | 0.3571 | 0.3552 | 0.3568 | 1064000.0 |
| 2003-07-14 09:55:00 | AAPL | Stock | 0.3568 | 0.3595 | 0.3568 | 0.3595 | 1752632.0 |
| 2003-07-14 10:00:00 | AAPL | Stock | 0.3593 | 0.3607 | 0.3589 | 0.3604 | 2878288.0 |
| 2003-07-14 10:05:00 | AAPL | Stock | 0.3605 | 0.3618 | 0.3604 | 0.3611 | 2684696.0 |
| 2003-07-14 10:10:00 | AAPL | Stock | 0.3605 | 0.3607 | 0.3602 | 0.3604 | 4200000.0 |
| 2003-07-14 10:15:00 | AAPL | Stock | 0.3607 | 0.3625 | 0.3598 | 0.3625 | 5115824.0 |
| 2003-07-14 10:20:00 | AAPL | Stock | 0.3625 | 0.3636 | 0.362 | 0.3631 | 5250392.0 |
| 2003-07-14 10:25:00 | AAPL | Stock | 0.3632 | 0.3643 | 0.3632 | 0.3636 | 2520224.0 |
| 2003-07-14 10:30:00 | AAPL | Stock | 0.3636 | 0.3639 | 0.3627 | 0.3632 | 2589104.0 |
| 2003-07-14 10:35:00 | AAPL | Stock | 0.3632 | 0.3636 | 0.3615 | 0.3625 | 3696000.0 |
| 2003-07-14 10:40:00 | AAPL | Stock | 0.3623 | 0.3623 | 0.3596 | 0.3618 | 4224192.0 |
| 2003-07-14 10:45:00 | AAPL | Stock | 0.3618 | 0.3632 | 0.3618 | 0.363 | 1454712.0 |
| 2003-07-14 10:50:00 | AAPL | Stock | 0.363 | 0.3634 | 0.362 | 0.3627 | 1803032.0 |
| 2003-07-14 10:55:00 | AAPL | Stock | 0.3627 | 0.3634 | 0.3623 | 0.3627 | 3124800.0 |
| 2003-07-14 11:00:00 | AAPL | Stock | 0.3629 | 0.3634 | 0.3623 | 0.3625 | 1853936.0 |
| 2003-07-14 11:05:00 | AAPL | Stock | 0.3625 | 0.3633 | 0.3625 | 0.3625 | 836136.0 |
| 2003-07-14 11:10:00 | AAPL | Stock | 0.3627 | 0.3634 | 0.3625 | 0.3634 | 1481032.0 |
| 2003-07-14 11:15:00 | AAPL | Stock | 0.3632 | 0.3634 | 0.3621 | 0.3621 | 4653600.0 |
| 2003-07-14 11:20:00 | AAPL | Stock | 0.3623 | 0.363 | 0.362 | 0.363 | 7201600.0 |
| 2003-07-14 11:25:00 | AAPL | Stock | 0.363 | 0.3634 | 0.3625 | 0.3634 | 1472800.0 |
| 2003-07-14 11:30:00 | AAPL | Stock | 0.3634 | 0.3634 | 0.3625 | 0.3627 | 2046800.0 |
| 2003-07-14 11:35:00 | AAPL | Stock | 0.3629 | 0.3629 | 0.3621 | 0.3621 | 1052800.0 |
| 2003-07-14 11:40:00 | AAPL | Stock | 0.3621 | 0.3625 | 0.3616 | 0.3621 | 1344224.0 |
| 2003-07-14 11:45:00 | AAPL | Stock | 0.3623 | 0.3625 | 0.3616 | 0.3623 | 1864800.0 |
| 2003-07-14 11:50:00 | AAPL | Stock | 0.3623 | 0.3623 | 0.3618 | 0.3618 | 506464.0 |
| 2003-07-14 11:55:00 | AAPL | Stock | 0.3618 | 0.362 | 0.3616 | 0.3618 | 750400.0 |
| 2003-07-14 12:00:00 | AAPL | Stock | 0.362 | 0.362 | 0.3611 | 0.3613 | 1095416.0 |
| 2003-07-14 12:05:00 | AAPL | Stock | 0.3611 | 0.3611 | 0.36 | 0.3602 | 2004800.0 |
| 2003-07-14 12:10:00 | AAPL | Stock | 0.3602 | 0.3607 | 0.36 | 0.3607 | 1534288.0 |
| 2003-07-14 12:15:00 | AAPL | Stock | 0.3607 | 0.3609 | 0.3602 | 0.3606 | 3325000.0 |
| 2003-07-14 12:20:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3605 | 0.3607 | 969528.0 |
| 2003-07-14 12:25:00 | AAPL | Stock | 0.3607 | 0.3618 | 0.3607 | 0.3611 | 1565592.0 |
| 2003-07-14 12:30:00 | AAPL | Stock | 0.3613 | 0.3618 | 0.3611 | 0.3614 | 2072336.0 |
| 2003-07-14 12:35:00 | AAPL | Stock | 0.3607 | 0.3614 | 0.3607 | 0.3613 | 3119200.0 |
| 2003-07-14 12:40:00 | AAPL | Stock | 0.3614 | 0.3614 | 0.3605 | 0.3605 | 1824704.0 |
| 2003-07-14 12:45:00 | AAPL | Stock | 0.3604 | 0.3607 | 0.36 | 0.3605 | 1196440.0 |
| 2003-07-14 12:50:00 | AAPL | Stock | 0.3605 | 0.3614 | 0.3605 | 0.3614 | 1159200.0 |
> showing 50 of 156,147 rows — these rows as CSV