PREVIEW / stock_5min / 2004-11-03
file: by_date/stock_5min/2004/2004-11-03.parquet size: 2.6 MB rows: 186,729 symbols: 1,860
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-03 08:00:00 | AAPL | Stock | 0.9645 | 0.9821 | 0.9645 | 0.9802 | 162400.0 |
| 2004-11-03 08:05:00 | AAPL | Stock | 0.9804 | 0.9804 | 0.9793 | 0.9793 | 291200.0 |
| 2004-11-03 08:10:00 | AAPL | Stock | 0.9779 | 0.9779 | 0.975 | 0.975 | 184800.0 |
| 2004-11-03 08:15:00 | AAPL | Stock | 0.975 | 0.975 | 0.9741 | 0.9741 | 131600.0 |
| 2004-11-03 08:20:00 | AAPL | Stock | 0.9741 | 0.975 | 0.9741 | 0.9741 | 117600.0 |
| 2004-11-03 08:25:00 | AAPL | Stock | 0.9743 | 0.975 | 0.9732 | 0.9732 | 182560.0 |
| 2004-11-03 08:30:00 | AAPL | Stock | 0.975 | 0.975 | 0.9732 | 0.9732 | 242200.0 |
| 2004-11-03 08:35:00 | AAPL | Stock | 0.9714 | 0.9723 | 0.9714 | 0.9723 | 78400.0 |
| 2004-11-03 08:40:00 | AAPL | Stock | 0.975 | 0.975 | 0.9696 | 0.9702 | 919240.0 |
| 2004-11-03 08:45:00 | AAPL | Stock | 0.9696 | 0.9734 | 0.9696 | 0.9734 | 22400.0 |
| 2004-11-03 08:50:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9714 | 0.9723 | 565600.0 |
| 2004-11-03 08:55:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 56000.0 |
| 2004-11-03 09:00:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.973 | 0.9732 | 72800.0 |
| 2004-11-03 09:05:00 | AAPL | Stock | 0.973 | 0.9732 | 0.973 | 0.9732 | 221200.0 |
| 2004-11-03 09:10:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9711 | 0.9711 | 194600.0 |
| 2004-11-03 09:15:00 | AAPL | Stock | 0.9729 | 0.9729 | 0.9718 | 0.9725 | 105000.0 |
| 2004-11-03 09:20:00 | AAPL | Stock | 0.972 | 0.972 | 0.9707 | 0.9714 | 442400.0 |
| 2004-11-03 09:25:00 | AAPL | Stock | 0.9711 | 0.9718 | 0.9561 | 0.9718 | 3474968.0 |
| 2004-11-03 09:30:00 | AAPL | Stock | 0.9721 | 0.9777 | 0.9695 | 0.973 | 44087792.0 |
| 2004-11-03 09:35:00 | AAPL | Stock | 0.9732 | 0.9768 | 0.9723 | 0.9752 | 12064808.0 |
| 2004-11-03 09:40:00 | AAPL | Stock | 0.975 | 0.978 | 0.9746 | 0.9771 | 17844344.0 |
| 2004-11-03 09:45:00 | AAPL | Stock | 0.977 | 0.977 | 0.9705 | 0.9716 | 29192520.0 |
| 2004-11-03 09:50:00 | AAPL | Stock | 0.9721 | 0.9734 | 0.9709 | 0.9727 | 12562536.0 |
| 2004-11-03 09:55:00 | AAPL | Stock | 0.9727 | 0.9732 | 0.9714 | 0.9723 | 14784336.0 |
| 2004-11-03 10:00:00 | AAPL | Stock | 0.9729 | 0.9745 | 0.9721 | 0.9723 | 13060320.0 |
| 2004-11-03 10:05:00 | AAPL | Stock | 0.9725 | 0.9755 | 0.972 | 0.9743 | 21576128.0 |
| 2004-11-03 10:10:00 | AAPL | Stock | 0.9748 | 0.9757 | 0.9657 | 0.9684 | 23134496.0 |
| 2004-11-03 10:15:00 | AAPL | Stock | 0.9688 | 0.9704 | 0.9661 | 0.9663 | 11381272.0 |
| 2004-11-03 10:20:00 | AAPL | Stock | 0.9663 | 0.9684 | 0.9641 | 0.9668 | 15525832.0 |
| 2004-11-03 10:25:00 | AAPL | Stock | 0.9666 | 0.9739 | 0.9661 | 0.9739 | 11244352.0 |
| 2004-11-03 10:30:00 | AAPL | Stock | 0.9741 | 0.9775 | 0.9727 | 0.9768 | 18782792.0 |
| 2004-11-03 10:35:00 | AAPL | Stock | 0.9768 | 0.98 | 0.9739 | 0.9789 | 14658392.0 |
| 2004-11-03 10:40:00 | AAPL | Stock | 0.9789 | 0.9811 | 0.9768 | 0.9786 | 15173872.0 |
| 2004-11-03 10:45:00 | AAPL | Stock | 0.9786 | 0.9795 | 0.9729 | 0.9734 | 13199088.0 |
| 2004-11-03 10:50:00 | AAPL | Stock | 0.9739 | 0.9755 | 0.9732 | 0.9736 | 5577824.0 |
| 2004-11-03 10:55:00 | AAPL | Stock | 0.9738 | 0.9763 | 0.9732 | 0.9736 | 3954944.0 |
| 2004-11-03 11:00:00 | AAPL | Stock | 0.9736 | 0.9745 | 0.97 | 0.9716 | 12263832.0 |
| 2004-11-03 11:05:00 | AAPL | Stock | 0.9718 | 0.9771 | 0.9714 | 0.9748 | 10693200.0 |
| 2004-11-03 11:10:00 | AAPL | Stock | 0.9747 | 0.9752 | 0.9729 | 0.975 | 6401584.0 |
| 2004-11-03 11:15:00 | AAPL | Stock | 0.975 | 0.9761 | 0.9734 | 0.9757 | 4189304.0 |
| 2004-11-03 11:20:00 | AAPL | Stock | 0.9757 | 0.9793 | 0.9754 | 0.9782 | 7122864.0 |
| 2004-11-03 11:25:00 | AAPL | Stock | 0.9784 | 0.9843 | 0.9782 | 0.9832 | 30367512.0 |
| 2004-11-03 11:30:00 | AAPL | Stock | 0.9836 | 0.9875 | 0.9823 | 0.9875 | 23419984.0 |
| 2004-11-03 11:35:00 | AAPL | Stock | 0.9873 | 0.9889 | 0.9859 | 0.9861 | 15830360.0 |
| 2004-11-03 11:40:00 | AAPL | Stock | 0.9863 | 0.9884 | 0.9855 | 0.9857 | 10662400.0 |
| 2004-11-03 11:45:00 | AAPL | Stock | 0.9857 | 0.9863 | 0.9839 | 0.9855 | 12979120.0 |
| 2004-11-03 11:50:00 | AAPL | Stock | 0.9854 | 0.9863 | 0.9843 | 0.9859 | 10658536.0 |
| 2004-11-03 11:55:00 | AAPL | Stock | 0.9859 | 0.9861 | 0.982 | 0.9821 | 18398688.0 |
| 2004-11-03 12:00:00 | AAPL | Stock | 0.9821 | 0.9848 | 0.982 | 0.9848 | 11487672.0 |
| 2004-11-03 12:05:00 | AAPL | Stock | 0.9848 | 0.9857 | 0.982 | 0.9848 | 13280680.0 |
> showing 50 of 186,729 rows — these rows as CSV