PREVIEW / stock_5min / 2003-08-04
file: by_date/stock_5min/2003/2003-08-04.parquet size: 2.1 MB rows: 152,563 symbols: 1,599
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-04 09:25:00 | AAPL | Stock | 0.368 | 0.3686 | 0.368 | 0.368 | 156800.0 |
| 2003-08-04 09:30:00 | AAPL | Stock | 0.3677 | 0.3705 | 0.3675 | 0.3702 | 2698920.0 |
| 2003-08-04 09:35:00 | AAPL | Stock | 0.37 | 0.3716 | 0.3679 | 0.3679 | 1612576.0 |
| 2003-08-04 09:40:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.3664 | 0.3671 | 1596000.0 |
| 2003-08-04 09:45:00 | AAPL | Stock | 0.367 | 0.3675 | 0.3663 | 0.3664 | 1667120.0 |
| 2003-08-04 09:50:00 | AAPL | Stock | 0.3663 | 0.3666 | 0.3642 | 0.3648 | 4196360.0 |
| 2003-08-04 09:55:00 | AAPL | Stock | 0.3648 | 0.3661 | 0.3648 | 0.3657 | 683200.0 |
| 2003-08-04 10:00:00 | AAPL | Stock | 0.3657 | 0.367 | 0.3645 | 0.367 | 4675888.0 |
| 2003-08-04 10:05:00 | AAPL | Stock | 0.3668 | 0.3691 | 0.3668 | 0.3682 | 1864800.0 |
| 2003-08-04 10:10:00 | AAPL | Stock | 0.3682 | 0.3682 | 0.367 | 0.3671 | 791840.0 |
| 2003-08-04 10:15:00 | AAPL | Stock | 0.3673 | 0.3673 | 0.3657 | 0.3659 | 4609864.0 |
| 2003-08-04 10:20:00 | AAPL | Stock | 0.3657 | 0.3657 | 0.3646 | 0.3646 | 2162440.0 |
| 2003-08-04 10:25:00 | AAPL | Stock | 0.3648 | 0.3648 | 0.3643 | 0.3643 | 1237600.0 |
| 2003-08-04 10:30:00 | AAPL | Stock | 0.3645 | 0.3645 | 0.3625 | 0.3627 | 4505424.0 |
| 2003-08-04 10:35:00 | AAPL | Stock | 0.3625 | 0.3632 | 0.3621 | 0.363 | 2416624.0 |
| 2003-08-04 10:40:00 | AAPL | Stock | 0.3632 | 0.3634 | 0.3627 | 0.3632 | 2704800.0 |
| 2003-08-04 10:45:00 | AAPL | Stock | 0.3632 | 0.3638 | 0.363 | 0.3638 | 2699200.0 |
| 2003-08-04 10:50:00 | AAPL | Stock | 0.3636 | 0.3639 | 0.363 | 0.3636 | 1237600.0 |
| 2003-08-04 10:55:00 | AAPL | Stock | 0.3638 | 0.3646 | 0.3634 | 0.3641 | 935424.0 |
| 2003-08-04 11:00:00 | AAPL | Stock | 0.3641 | 0.3641 | 0.3634 | 0.3639 | 593600.0 |
| 2003-08-04 11:05:00 | AAPL | Stock | 0.3639 | 0.3643 | 0.3639 | 0.3641 | 817600.0 |
| 2003-08-04 11:10:00 | AAPL | Stock | 0.3641 | 0.3648 | 0.3639 | 0.3646 | 1178016.0 |
| 2003-08-04 11:15:00 | AAPL | Stock | 0.3648 | 0.3675 | 0.3645 | 0.3669 | 5226144.0 |
| 2003-08-04 11:20:00 | AAPL | Stock | 0.3668 | 0.367 | 0.3646 | 0.3663 | 1786400.0 |
| 2003-08-04 11:25:00 | AAPL | Stock | 0.3663 | 0.3671 | 0.3661 | 0.367 | 5258400.0 |
| 2003-08-04 11:30:00 | AAPL | Stock | 0.3673 | 0.3677 | 0.3668 | 0.3668 | 2020928.0 |
| 2003-08-04 11:35:00 | AAPL | Stock | 0.367 | 0.367 | 0.3657 | 0.3657 | 1008224.0 |
| 2003-08-04 11:40:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.365 | 0.3655 | 1030568.0 |
| 2003-08-04 11:45:00 | AAPL | Stock | 0.3654 | 0.3655 | 0.365 | 0.3652 | 895776.0 |
| 2003-08-04 11:50:00 | AAPL | Stock | 0.3652 | 0.3657 | 0.3648 | 0.3657 | 1416800.0 |
| 2003-08-04 11:55:00 | AAPL | Stock | 0.3657 | 0.3661 | 0.3654 | 0.3657 | 1159200.0 |
| 2003-08-04 12:00:00 | AAPL | Stock | 0.3657 | 0.3659 | 0.3654 | 0.3655 | 536536.0 |
| 2003-08-04 12:05:00 | AAPL | Stock | 0.3654 | 0.3655 | 0.3652 | 0.3655 | 1321376.0 |
| 2003-08-04 12:10:00 | AAPL | Stock | 0.3657 | 0.3664 | 0.3657 | 0.3663 | 1506288.0 |
| 2003-08-04 12:15:00 | AAPL | Stock | 0.3664 | 0.3677 | 0.3659 | 0.3677 | 3567200.0 |
| 2003-08-04 12:20:00 | AAPL | Stock | 0.3677 | 0.3679 | 0.3663 | 0.3673 | 3711008.0 |
| 2003-08-04 12:25:00 | AAPL | Stock | 0.367 | 0.368 | 0.367 | 0.3679 | 3757600.0 |
| 2003-08-04 12:30:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.3663 | 0.3663 | 823200.0 |
| 2003-08-04 12:35:00 | AAPL | Stock | 0.3664 | 0.3668 | 0.3661 | 0.3661 | 520800.0 |
| 2003-08-04 12:40:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3659 | 0.3661 | 466200.0 |
| 2003-08-04 12:45:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3654 | 0.3654 | 291200.0 |
| 2003-08-04 12:50:00 | AAPL | Stock | 0.3654 | 0.3661 | 0.3652 | 0.3661 | 1248800.0 |
| 2003-08-04 12:55:00 | AAPL | Stock | 0.3659 | 0.3668 | 0.3654 | 0.3659 | 1540000.0 |
| 2003-08-04 13:00:00 | AAPL | Stock | 0.3661 | 0.3673 | 0.3657 | 0.3673 | 1719200.0 |
| 2003-08-04 13:05:00 | AAPL | Stock | 0.3675 | 0.3679 | 0.367 | 0.3677 | 744800.0 |
| 2003-08-04 13:10:00 | AAPL | Stock | 0.3679 | 0.3682 | 0.3677 | 0.3679 | 1450400.0 |
| 2003-08-04 13:15:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.367 | 0.3673 | 520800.0 |
| 2003-08-04 13:20:00 | AAPL | Stock | 0.3673 | 0.3693 | 0.3671 | 0.3693 | 2912392.0 |
| 2003-08-04 13:25:00 | AAPL | Stock | 0.3695 | 0.3696 | 0.3688 | 0.3689 | 1327984.0 |
| 2003-08-04 13:30:00 | AAPL | Stock | 0.3688 | 0.3691 | 0.3686 | 0.3686 | 2341024.0 |
> showing 50 of 152,563 rows — these rows as CSV