PREVIEW / stock_5min / 2005-10-31
file: by_date/stock_5min/2005/2005-10-31.parquet size: 2.9 MB rows: 209,037 symbols: 2,116
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-31 07:55:00 | AAPL | Stock | 1.9571 | 1.9571 | 1.9571 | 1.9571 | 2800.0 |
| 2005-10-31 08:00:00 | AAPL | Stock | 1.9518 | 1.9643 | 1.9518 | 1.9643 | 220416.0 |
| 2005-10-31 08:05:00 | AAPL | Stock | 1.9679 | 1.9707 | 1.9643 | 1.9643 | 301224.0 |
| 2005-10-31 08:10:00 | AAPL | Stock | 1.9643 | 1.9661 | 1.9607 | 1.9643 | 61600.0 |
| 2005-10-31 08:15:00 | AAPL | Stock | 1.9607 | 1.9639 | 1.9607 | 1.9614 | 8400.0 |
| 2005-10-31 08:20:00 | AAPL | Stock | 1.9636 | 1.9675 | 1.9636 | 1.9657 | 271320.0 |
| 2005-10-31 08:25:00 | AAPL | Stock | 1.9664 | 1.9664 | 1.9661 | 1.9661 | 22400.0 |
| 2005-10-31 08:30:00 | AAPL | Stock | 1.9661 | 1.9714 | 1.9657 | 1.97 | 292432.0 |
| 2005-10-31 08:35:00 | AAPL | Stock | 1.9689 | 1.97 | 1.9664 | 1.97 | 81900.0 |
| 2005-10-31 08:40:00 | AAPL | Stock | 1.9696 | 1.9707 | 1.9686 | 1.9704 | 67928.0 |
| 2005-10-31 08:45:00 | AAPL | Stock | 1.9704 | 1.9743 | 1.9704 | 1.9721 | 228928.0 |
| 2005-10-31 08:50:00 | AAPL | Stock | 1.9729 | 1.9768 | 1.9729 | 1.975 | 734160.0 |
| 2005-10-31 08:55:00 | AAPL | Stock | 1.9768 | 1.9796 | 1.975 | 1.9786 | 1083376.0 |
| 2005-10-31 09:00:00 | AAPL | Stock | 1.9786 | 1.9814 | 1.9786 | 1.9804 | 571984.0 |
| 2005-10-31 09:05:00 | AAPL | Stock | 1.9786 | 1.9818 | 1.9786 | 1.9814 | 410844.0 |
| 2005-10-31 09:10:00 | AAPL | Stock | 1.9789 | 1.9814 | 1.9786 | 1.9796 | 185360.0 |
| 2005-10-31 09:15:00 | AAPL | Stock | 1.9796 | 1.9839 | 1.975 | 1.975 | 838180.0 |
| 2005-10-31 09:20:00 | AAPL | Stock | 1.975 | 1.9786 | 1.975 | 1.9768 | 353948.0 |
| 2005-10-31 09:25:00 | AAPL | Stock | 1.9732 | 1.9793 | 1.9689 | 1.9732 | 1216236.0 |
| 2005-10-31 09:30:00 | AAPL | Stock | 1.9714 | 1.9764 | 1.9554 | 1.9607 | 24627624.0 |
| 2005-10-31 09:35:00 | AAPL | Stock | 1.9607 | 1.9732 | 1.9607 | 1.9704 | 18098052.0 |
| 2005-10-31 09:40:00 | AAPL | Stock | 1.9711 | 1.9818 | 1.9693 | 1.9707 | 16447984.0 |
| 2005-10-31 09:45:00 | AAPL | Stock | 1.9707 | 1.98 | 1.9704 | 1.9782 | 11983356.0 |
| 2005-10-31 09:50:00 | AAPL | Stock | 1.9779 | 1.98 | 1.9739 | 1.9757 | 9896040.0 |
| 2005-10-31 09:55:00 | AAPL | Stock | 1.9754 | 1.9764 | 1.9682 | 1.975 | 11922876.0 |
| 2005-10-31 10:00:00 | AAPL | Stock | 1.975 | 1.9854 | 1.9736 | 1.9796 | 14218820.0 |
| 2005-10-31 10:05:00 | AAPL | Stock | 1.9796 | 1.9854 | 1.9761 | 1.9764 | 11363576.0 |
| 2005-10-31 10:10:00 | AAPL | Stock | 1.9768 | 1.9814 | 1.9732 | 1.9732 | 6633256.0 |
| 2005-10-31 10:15:00 | AAPL | Stock | 1.9732 | 1.9825 | 1.9718 | 1.9746 | 10345300.0 |
| 2005-10-31 10:20:00 | AAPL | Stock | 1.9745 | 1.9964 | 1.9743 | 1.9932 | 17630844.0 |
| 2005-10-31 10:25:00 | AAPL | Stock | 1.9932 | 2.0079 | 1.9893 | 2.0004 | 23626036.0 |
| 2005-10-31 10:30:00 | AAPL | Stock | 2.0004 | 2.0046 | 1.9929 | 2.0014 | 17110940.0 |
| 2005-10-31 10:35:00 | AAPL | Stock | 2.0011 | 2.0039 | 1.9982 | 1.9989 | 6814668.0 |
| 2005-10-31 10:40:00 | AAPL | Stock | 1.9989 | 2.0089 | 1.9989 | 2.0079 | 13476596.0 |
| 2005-10-31 10:45:00 | AAPL | Stock | 2.0079 | 2.0082 | 2.0039 | 2.0054 | 9895452.0 |
| 2005-10-31 10:50:00 | AAPL | Stock | 2.0054 | 2.0125 | 2.0039 | 2.0089 | 12186020.0 |
| 2005-10-31 10:55:00 | AAPL | Stock | 2.0086 | 2.0107 | 2.0039 | 2.0039 | 8091132.0 |
| 2005-10-31 11:00:00 | AAPL | Stock | 2.0043 | 2.0043 | 1.9979 | 2.0032 | 7303576.0 |
| 2005-10-31 11:05:00 | AAPL | Stock | 2.0031 | 2.0079 | 2.0018 | 2.005 | 5943840.0 |
| 2005-10-31 11:10:00 | AAPL | Stock | 2.0046 | 2.0089 | 2.0043 | 2.0089 | 4360356.0 |
| 2005-10-31 11:15:00 | AAPL | Stock | 2.0086 | 2.0136 | 2.0075 | 2.0104 | 7814716.0 |
| 2005-10-31 11:20:00 | AAPL | Stock | 2.01 | 2.0161 | 2.0079 | 2.0143 | 8330504.0 |
| 2005-10-31 11:25:00 | AAPL | Stock | 2.0143 | 2.0161 | 2.0125 | 2.0146 | 7230076.0 |
| 2005-10-31 11:30:00 | AAPL | Stock | 2.0143 | 2.0171 | 1.9899 | 2.0161 | 5962656.0 |
| 2005-10-31 11:35:00 | AAPL | Stock | 2.0161 | 2.0232 | 2.0154 | 2.0218 | 12069344.0 |
| 2005-10-31 11:40:00 | AAPL | Stock | 2.0214 | 2.0289 | 2.0214 | 2.0271 | 12888960.0 |
| 2005-10-31 11:45:00 | AAPL | Stock | 2.0268 | 2.03 | 2.0239 | 2.0289 | 9514316.0 |
| 2005-10-31 11:50:00 | AAPL | Stock | 2.0293 | 2.0332 | 2.025 | 2.0257 | 14609280.0 |
| 2005-10-31 11:55:00 | AAPL | Stock | 2.0257 | 2.0339 | 2.025 | 2.0286 | 8022028.0 |
| 2005-10-31 12:00:00 | AAPL | Stock | 2.0289 | 2.0329 | 2.025 | 2.0321 | 9908808.0 |
> showing 50 of 209,037 rows — these rows as CSV