PREVIEW / stock_5min / 2010-02-08
file: by_date/stock_5min/2010/2010-02-08.parquet size: 4.7 MB rows: 320,227 symbols: 3,408
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-08 05:45:00 | AAPL | Stock | 6.9789 | 6.9789 | 6.9789 | 6.9789 | 5040.0 |
| 2010-02-08 07:00:00 | AAPL | Stock | 6.9782 | 6.9782 | 6.9782 | 6.9782 | 2800.0 |
| 2010-02-08 07:10:00 | AAPL | Stock | 6.9743 | 6.9743 | 6.9743 | 6.9743 | 5600.0 |
| 2010-02-08 07:30:00 | AAPL | Stock | 6.955 | 6.955 | 6.955 | 6.955 | 5600.0 |
| 2010-02-08 07:35:00 | AAPL | Stock | 6.9507 | 6.9507 | 6.9504 | 6.9504 | 7840.0 |
| 2010-02-08 07:40:00 | AAPL | Stock | 6.9311 | 6.9311 | 6.9311 | 6.9311 | 2800.0 |
| 2010-02-08 07:50:00 | AAPL | Stock | 6.9571 | 6.9682 | 6.9571 | 6.9682 | 43176.0 |
| 2010-02-08 07:55:00 | AAPL | Stock | 6.9804 | 6.9882 | 6.975 | 6.9882 | 95200.0 |
| 2010-02-08 08:00:00 | AAPL | Stock | 6.9754 | 6.9993 | 6.9754 | 6.9929 | 245000.0 |
| 2010-02-08 08:05:00 | AAPL | Stock | 6.9864 | 6.9864 | 6.9682 | 6.9821 | 208012.0 |
| 2010-02-08 08:10:00 | AAPL | Stock | 6.9821 | 6.9839 | 6.9782 | 6.9821 | 86800.0 |
| 2010-02-08 08:15:00 | AAPL | Stock | 6.9843 | 6.9843 | 6.9761 | 6.9786 | 90720.0 |
| 2010-02-08 08:20:00 | AAPL | Stock | 6.9775 | 6.9814 | 6.9768 | 6.9768 | 20440.0 |
| 2010-02-08 08:25:00 | AAPL | Stock | 6.9768 | 6.9954 | 6.9686 | 6.9764 | 240660.0 |
| 2010-02-08 08:30:00 | AAPL | Stock | 6.975 | 6.975 | 6.9625 | 6.9643 | 180656.0 |
| 2010-02-08 08:35:00 | AAPL | Stock | 6.9643 | 6.9707 | 6.9575 | 6.9643 | 236320.0 |
| 2010-02-08 08:40:00 | AAPL | Stock | 6.9639 | 6.9643 | 6.9639 | 6.9643 | 25200.0 |
| 2010-02-08 08:45:00 | AAPL | Stock | 6.9679 | 6.9704 | 6.9679 | 6.9704 | 72800.0 |
| 2010-02-08 08:50:00 | AAPL | Stock | 6.9707 | 6.9707 | 6.9639 | 6.9693 | 138460.0 |
| 2010-02-08 08:55:00 | AAPL | Stock | 6.9661 | 6.9714 | 6.9661 | 6.9714 | 48020.0 |
| 2010-02-08 09:00:00 | AAPL | Stock | 6.9711 | 6.9714 | 6.9639 | 6.9643 | 165172.0 |
| 2010-02-08 09:05:00 | AAPL | Stock | 6.9643 | 6.9671 | 6.9629 | 6.9671 | 158732.0 |
| 2010-02-08 09:10:00 | AAPL | Stock | 6.9668 | 6.9679 | 6.9643 | 6.9679 | 38976.0 |
| 2010-02-08 09:15:00 | AAPL | Stock | 6.9689 | 6.9714 | 6.9646 | 6.9679 | 146720.0 |
| 2010-02-08 09:20:00 | AAPL | Stock | 6.9704 | 6.9707 | 6.9686 | 6.9686 | 28000.0 |
| 2010-02-08 09:25:00 | AAPL | Stock | 6.9686 | 6.9893 | 6.9639 | 6.9893 | 401800.0 |
| 2010-02-08 09:30:00 | AAPL | Stock | 6.9889 | 7.0214 | 6.9732 | 7.0054 | 16616572.0 |
| 2010-02-08 09:35:00 | AAPL | Stock | 7.005 | 7.0429 | 6.9814 | 7.035 | 17387104.0 |
| 2010-02-08 09:40:00 | AAPL | Stock | 7.0368 | 7.0368 | 7.0025 | 7.0175 | 15390816.0 |
| 2010-02-08 09:45:00 | AAPL | Stock | 7.0154 | 7.0211 | 6.9832 | 6.9964 | 14132608.0 |
| 2010-02-08 09:50:00 | AAPL | Stock | 6.9961 | 7.0196 | 6.9643 | 7.0195 | 14792652.0 |
| 2010-02-08 09:55:00 | AAPL | Stock | 7.0189 | 7.0234 | 7.0036 | 7.0111 | 8591688.0 |
| 2010-02-08 10:00:00 | AAPL | Stock | 7.0139 | 7.0268 | 7.0 | 7.0179 | 8764448.0 |
| 2010-02-08 10:05:00 | AAPL | Stock | 7.0186 | 7.0393 | 7.005 | 7.033 | 10348744.0 |
| 2010-02-08 10:10:00 | AAPL | Stock | 7.0308 | 7.0493 | 7.0307 | 7.0339 | 11081196.0 |
| 2010-02-08 10:15:00 | AAPL | Stock | 7.0346 | 7.0457 | 7.0211 | 7.0261 | 8440964.0 |
| 2010-02-08 10:20:00 | AAPL | Stock | 7.0271 | 7.0339 | 7.0039 | 7.0133 | 7818972.0 |
| 2010-02-08 10:25:00 | AAPL | Stock | 7.0136 | 7.0314 | 7.01 | 7.0218 | 6135780.0 |
| 2010-02-08 10:30:00 | AAPL | Stock | 7.0214 | 7.025 | 7.0075 | 7.0146 | 4225032.0 |
| 2010-02-08 10:35:00 | AAPL | Stock | 7.0143 | 7.0243 | 7.0039 | 7.0086 | 5445832.0 |
| 2010-02-08 10:40:00 | AAPL | Stock | 7.0077 | 7.0204 | 7.0054 | 7.0175 | 3677660.0 |
| 2010-02-08 10:45:00 | AAPL | Stock | 7.0175 | 7.0304 | 7.0107 | 7.0266 | 5791184.0 |
| 2010-02-08 10:50:00 | AAPL | Stock | 7.0268 | 7.0379 | 7.0221 | 7.0296 | 5563656.0 |
| 2010-02-08 10:55:00 | AAPL | Stock | 7.0304 | 7.0393 | 7.0286 | 7.0332 | 2958172.0 |
| 2010-02-08 11:00:00 | AAPL | Stock | 7.0325 | 7.0575 | 7.0325 | 7.0561 | 9432640.0 |
| 2010-02-08 11:05:00 | AAPL | Stock | 7.0561 | 7.0671 | 7.0482 | 7.065 | 6477968.0 |
| 2010-02-08 11:10:00 | AAPL | Stock | 7.0636 | 7.0668 | 7.0557 | 7.0571 | 5073712.0 |
| 2010-02-08 11:15:00 | AAPL | Stock | 7.0573 | 7.0607 | 7.0477 | 7.0518 | 5860372.0 |
| 2010-02-08 11:20:00 | AAPL | Stock | 7.0514 | 7.0629 | 7.0507 | 7.0575 | 4205040.0 |
| 2010-02-08 11:25:00 | AAPL | Stock | 7.0582 | 7.0591 | 7.0407 | 7.0407 | 3984260.0 |
> showing 50 of 320,227 rows — these rows as CSV