PREVIEW / stock_5min / 2010-10-26
file: by_date/stock_5min/2010/2010-10-26.parquet size: 4.7 MB rows: 324,537 symbols: 3,478
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-10-26 04:25:00 | AAPL | Stock | 10.9829 | 10.9829 | 10.9829 | 10.9829 | 2800.0 |
| 2010-10-26 04:30:00 | AAPL | Stock | 10.9786 | 10.9786 | 10.9786 | 10.9786 | 2800.0 |
| 2010-10-26 04:35:00 | AAPL | Stock | 10.9782 | 10.9782 | 10.9782 | 10.9782 | 2800.0 |
| 2010-10-26 05:10:00 | AAPL | Stock | 10.9586 | 10.9586 | 10.9586 | 10.9586 | 2800.0 |
| 2010-10-26 05:20:00 | AAPL | Stock | 10.9596 | 10.9596 | 10.9596 | 10.9596 | 2800.0 |
| 2010-10-26 05:25:00 | AAPL | Stock | 10.9704 | 10.9704 | 10.9704 | 10.9704 | 2800.0 |
| 2010-10-26 06:05:00 | AAPL | Stock | 10.9821 | 10.9821 | 10.9821 | 10.9821 | 2800.0 |
| 2010-10-26 06:15:00 | AAPL | Stock | 10.9714 | 10.9714 | 10.9714 | 10.9714 | 8400.0 |
| 2010-10-26 06:30:00 | AAPL | Stock | 10.9714 | 10.9714 | 10.9714 | 10.9714 | 2800.0 |
| 2010-10-26 06:35:00 | AAPL | Stock | 10.9714 | 10.9714 | 10.9714 | 10.9714 | 2800.0 |
| 2010-10-26 06:55:00 | AAPL | Stock | 10.9729 | 10.9729 | 10.9729 | 10.9729 | 2800.0 |
| 2010-10-26 07:05:00 | AAPL | Stock | 10.9736 | 10.9736 | 10.9736 | 10.9736 | 2800.0 |
| 2010-10-26 07:10:00 | AAPL | Stock | 10.9821 | 10.985 | 10.9821 | 10.9825 | 10220.0 |
| 2010-10-26 07:15:00 | AAPL | Stock | 10.985 | 10.9911 | 10.985 | 10.9911 | 8400.0 |
| 2010-10-26 07:20:00 | AAPL | Stock | 10.9839 | 10.9918 | 10.9839 | 10.9839 | 60620.0 |
| 2010-10-26 07:25:00 | AAPL | Stock | 10.9893 | 10.9911 | 10.9839 | 10.9911 | 11200.0 |
| 2010-10-26 07:30:00 | AAPL | Stock | 10.9893 | 10.9893 | 10.9875 | 10.9875 | 5600.0 |
| 2010-10-26 07:35:00 | AAPL | Stock | 10.9893 | 10.9964 | 10.9893 | 10.9964 | 11200.0 |
| 2010-10-26 07:40:00 | AAPL | Stock | 10.9946 | 11.0 | 10.9832 | 10.9914 | 39340.0 |
| 2010-10-26 07:45:00 | AAPL | Stock | 10.9914 | 10.9914 | 10.9729 | 10.9729 | 78260.0 |
| 2010-10-26 08:00:00 | AAPL | Stock | 10.9821 | 10.9957 | 10.9746 | 10.9786 | 224224.0 |
| 2010-10-26 08:05:00 | AAPL | Stock | 10.9779 | 10.9836 | 10.9771 | 10.9821 | 42000.0 |
| 2010-10-26 08:10:00 | AAPL | Stock | 10.9832 | 10.995 | 10.9832 | 10.9846 | 244776.0 |
| 2010-10-26 08:15:00 | AAPL | Stock | 10.9871 | 10.9871 | 10.9746 | 10.9746 | 128968.0 |
| 2010-10-26 08:20:00 | AAPL | Stock | 10.9732 | 10.98 | 10.9668 | 10.9668 | 87864.0 |
| 2010-10-26 08:25:00 | AAPL | Stock | 10.9714 | 10.9779 | 10.9611 | 10.9739 | 283360.0 |
| 2010-10-26 08:30:00 | AAPL | Stock | 10.9757 | 10.9804 | 10.9746 | 10.9804 | 70840.0 |
| 2010-10-26 08:35:00 | AAPL | Stock | 10.9811 | 10.9821 | 10.9768 | 10.9786 | 43120.0 |
| 2010-10-26 08:40:00 | AAPL | Stock | 10.9789 | 10.9832 | 10.9732 | 10.9768 | 141820.0 |
| 2010-10-26 08:45:00 | AAPL | Stock | 10.9746 | 10.975 | 10.9732 | 10.975 | 25200.0 |
| 2010-10-26 08:50:00 | AAPL | Stock | 10.9743 | 10.9789 | 10.9732 | 10.9789 | 33600.0 |
| 2010-10-26 08:55:00 | AAPL | Stock | 10.9779 | 10.9825 | 10.9743 | 10.9764 | 112000.0 |
| 2010-10-26 09:00:00 | AAPL | Stock | 10.9764 | 10.9786 | 10.9536 | 10.9536 | 931336.0 |
| 2010-10-26 09:05:00 | AAPL | Stock | 10.9536 | 10.9643 | 10.945 | 10.9618 | 345352.0 |
| 2010-10-26 09:10:00 | AAPL | Stock | 10.9596 | 10.9704 | 10.9596 | 10.9643 | 316680.0 |
| 2010-10-26 09:15:00 | AAPL | Stock | 10.9643 | 10.9764 | 10.9611 | 10.9643 | 156800.0 |
| 2010-10-26 09:20:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9593 | 10.9607 | 104104.0 |
| 2010-10-26 09:25:00 | AAPL | Stock | 10.9607 | 10.9639 | 10.9596 | 10.9639 | 86800.0 |
| 2010-10-26 09:30:00 | AAPL | Stock | 10.9639 | 10.9714 | 10.9375 | 10.9611 | 19768392.0 |
| 2010-10-26 09:35:00 | AAPL | Stock | 10.9629 | 10.9679 | 10.9468 | 10.9567 | 11351284.0 |
| 2010-10-26 09:40:00 | AAPL | Stock | 10.9556 | 10.9589 | 10.9161 | 10.9243 | 18897816.0 |
| 2010-10-26 09:45:00 | AAPL | Stock | 10.9236 | 10.9493 | 10.9179 | 10.9457 | 10875984.0 |
| 2010-10-26 09:50:00 | AAPL | Stock | 10.9457 | 10.9521 | 10.9243 | 10.9379 | 9347772.0 |
| 2010-10-26 09:55:00 | AAPL | Stock | 10.9379 | 10.9532 | 10.9379 | 10.9432 | 4247236.0 |
| 2010-10-26 10:00:00 | AAPL | Stock | 10.9411 | 11.0018 | 10.9411 | 10.9796 | 16486848.0 |
| 2010-10-26 10:05:00 | AAPL | Stock | 10.9786 | 11.0121 | 10.9786 | 11.0107 | 11886448.0 |
| 2010-10-26 10:10:00 | AAPL | Stock | 11.0118 | 11.0121 | 10.9868 | 10.9868 | 6211632.0 |
| 2010-10-26 10:15:00 | AAPL | Stock | 10.9876 | 11.0071 | 10.9864 | 11.0004 | 6947948.0 |
| 2010-10-26 10:20:00 | AAPL | Stock | 11.0007 | 11.025 | 10.9975 | 11.025 | 8797348.0 |
| 2010-10-26 10:25:00 | AAPL | Stock | 11.025 | 11.0425 | 11.0093 | 11.0206 | 8319416.0 |
> showing 50 of 324,537 rows — these rows as CSV