PREVIEW / stock_5min / 2004-11-10
file: by_date/stock_5min/2004/2004-11-10.parquet size: 2.5 MB rows: 186,073 symbols: 1,877
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-10 08:55:00 | AAPL | Stock | 0.9643 | 0.9643 | 0.9625 | 0.9625 | 44800.0 |
| 2004-11-10 09:00:00 | AAPL | Stock | 0.963 | 0.963 | 0.963 | 0.963 | 61824.0 |
| 2004-11-10 09:25:00 | AAPL | Stock | 0.9639 | 0.9643 | 0.9625 | 0.9643 | 307664.0 |
| 2004-11-10 09:30:00 | AAPL | Stock | 0.9634 | 0.9677 | 0.963 | 0.9648 | 7913696.0 |
| 2004-11-10 09:35:00 | AAPL | Stock | 0.9648 | 0.9664 | 0.963 | 0.9661 | 12445608.0 |
| 2004-11-10 09:40:00 | AAPL | Stock | 0.9659 | 0.9723 | 0.9655 | 0.9693 | 15105440.0 |
| 2004-11-10 09:45:00 | AAPL | Stock | 0.9698 | 0.9721 | 0.9686 | 0.9713 | 8997856.0 |
| 2004-11-10 09:50:00 | AAPL | Stock | 0.9713 | 0.9723 | 0.9689 | 0.9696 | 5378520.0 |
| 2004-11-10 09:55:00 | AAPL | Stock | 0.9696 | 0.9696 | 0.9677 | 0.9682 | 3943800.0 |
| 2004-11-10 10:00:00 | AAPL | Stock | 0.9686 | 0.9688 | 0.9661 | 0.9677 | 5736864.0 |
| 2004-11-10 10:05:00 | AAPL | Stock | 0.9671 | 0.9688 | 0.9666 | 0.9686 | 8252104.0 |
| 2004-11-10 10:10:00 | AAPL | Stock | 0.968 | 0.9688 | 0.9671 | 0.9688 | 5225976.0 |
| 2004-11-10 10:15:00 | AAPL | Stock | 0.9686 | 0.972 | 0.9682 | 0.9714 | 6025432.0 |
| 2004-11-10 10:20:00 | AAPL | Stock | 0.9714 | 0.9789 | 0.9714 | 0.9755 | 17374336.0 |
| 2004-11-10 10:25:00 | AAPL | Stock | 0.9759 | 0.9805 | 0.9759 | 0.9777 | 15730848.0 |
| 2004-11-10 10:30:00 | AAPL | Stock | 0.9777 | 0.9777 | 0.9736 | 0.9759 | 13779080.0 |
| 2004-11-10 10:35:00 | AAPL | Stock | 0.9761 | 0.9773 | 0.9723 | 0.9761 | 8985424.0 |
| 2004-11-10 10:40:00 | AAPL | Stock | 0.9766 | 0.9775 | 0.9759 | 0.9775 | 4173736.0 |
| 2004-11-10 10:45:00 | AAPL | Stock | 0.9775 | 0.9796 | 0.9773 | 0.9793 | 6244560.0 |
| 2004-11-10 10:50:00 | AAPL | Stock | 0.9793 | 0.9802 | 0.9771 | 0.9779 | 3954104.0 |
| 2004-11-10 10:55:00 | AAPL | Stock | 0.9777 | 0.9786 | 0.9768 | 0.978 | 2662184.0 |
| 2004-11-10 11:00:00 | AAPL | Stock | 0.9784 | 0.9784 | 0.977 | 0.9771 | 1826216.0 |
| 2004-11-10 11:05:00 | AAPL | Stock | 0.9771 | 0.9775 | 0.975 | 0.975 | 5190472.0 |
| 2004-11-10 11:10:00 | AAPL | Stock | 0.975 | 0.9768 | 0.9714 | 0.9723 | 7273224.0 |
| 2004-11-10 11:15:00 | AAPL | Stock | 0.9725 | 0.9746 | 0.9723 | 0.973 | 3767680.0 |
| 2004-11-10 11:20:00 | AAPL | Stock | 0.9732 | 0.9739 | 0.9723 | 0.9723 | 2332400.0 |
| 2004-11-10 11:25:00 | AAPL | Stock | 0.9718 | 0.9732 | 0.9705 | 0.9728 | 3478664.0 |
| 2004-11-10 11:30:00 | AAPL | Stock | 0.9728 | 0.9746 | 0.972 | 0.9739 | 2698080.0 |
| 2004-11-10 11:35:00 | AAPL | Stock | 0.9739 | 0.9746 | 0.9723 | 0.9736 | 2013032.0 |
| 2004-11-10 11:40:00 | AAPL | Stock | 0.9738 | 0.975 | 0.9734 | 0.9743 | 1590512.0 |
| 2004-11-10 11:45:00 | AAPL | Stock | 0.9741 | 0.9777 | 0.9741 | 0.9768 | 5169920.0 |
| 2004-11-10 11:50:00 | AAPL | Stock | 0.9769 | 0.9777 | 0.9759 | 0.9761 | 2438744.0 |
| 2004-11-10 11:55:00 | AAPL | Stock | 0.9761 | 0.9777 | 0.9761 | 0.977 | 1966496.0 |
| 2004-11-10 12:00:00 | AAPL | Stock | 0.9768 | 0.9777 | 0.975 | 0.9761 | 3404632.0 |
| 2004-11-10 12:05:00 | AAPL | Stock | 0.9755 | 0.9768 | 0.9752 | 0.9761 | 1817928.0 |
| 2004-11-10 12:10:00 | AAPL | Stock | 0.9761 | 0.9761 | 0.9748 | 0.9752 | 893872.0 |
| 2004-11-10 12:15:00 | AAPL | Stock | 0.9752 | 0.9752 | 0.9732 | 0.9734 | 1946504.0 |
| 2004-11-10 12:20:00 | AAPL | Stock | 0.9732 | 0.9759 | 0.9732 | 0.9759 | 4805192.0 |
| 2004-11-10 12:25:00 | AAPL | Stock | 0.9759 | 0.9771 | 0.9759 | 0.977 | 1115632.0 |
| 2004-11-10 12:30:00 | AAPL | Stock | 0.977 | 0.9777 | 0.9768 | 0.9777 | 2558360.0 |
| 2004-11-10 12:35:00 | AAPL | Stock | 0.9777 | 0.9786 | 0.9775 | 0.978 | 4033064.0 |
| 2004-11-10 12:40:00 | AAPL | Stock | 0.9779 | 0.978 | 0.977 | 0.9774 | 2103640.0 |
| 2004-11-10 12:45:00 | AAPL | Stock | 0.9773 | 0.9782 | 0.9773 | 0.9782 | 810208.0 |
| 2004-11-10 12:50:00 | AAPL | Stock | 0.9782 | 0.9795 | 0.9782 | 0.9788 | 2518880.0 |
| 2004-11-10 12:55:00 | AAPL | Stock | 0.9788 | 0.9788 | 0.9779 | 0.9784 | 1129296.0 |
| 2004-11-10 13:00:00 | AAPL | Stock | 0.9784 | 0.9784 | 0.9773 | 0.9775 | 1244208.0 |
| 2004-11-10 13:05:00 | AAPL | Stock | 0.9775 | 0.9775 | 0.9746 | 0.9759 | 3181976.0 |
| 2004-11-10 13:10:00 | AAPL | Stock | 0.9763 | 0.9763 | 0.9739 | 0.9761 | 4371248.0 |
| 2004-11-10 13:15:00 | AAPL | Stock | 0.9761 | 0.9763 | 0.9739 | 0.9754 | 3219888.0 |
| 2004-11-10 13:20:00 | AAPL | Stock | 0.9755 | 0.9763 | 0.975 | 0.9763 | 1979040.0 |
> showing 50 of 186,073 rows — these rows as CSV