PREVIEW / stock_5min / 2007-07-25
file: by_date/stock_5min/2007/2007-07-25.parquet size: 4.3 MB rows: 306,316 symbols: 3,090
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-25 09:30:00 | AAPL | Stock | 4.9054 | 4.9084 | 4.8679 | 4.8907 | 38915912.0 |
| 2007-07-25 09:35:00 | AAPL | Stock | 4.8907 | 4.8929 | 4.8593 | 4.8711 | 28864836.0 |
| 2007-07-25 09:40:00 | AAPL | Stock | 4.8707 | 4.8729 | 4.8254 | 4.8357 | 31335332.0 |
| 2007-07-25 09:45:00 | AAPL | Stock | 4.8354 | 4.8929 | 4.8214 | 4.8929 | 39290160.0 |
| 2007-07-25 09:50:00 | AAPL | Stock | 4.8929 | 4.905 | 4.8786 | 4.8861 | 30403716.0 |
| 2007-07-25 09:55:00 | AAPL | Stock | 4.8868 | 4.8871 | 4.8661 | 4.8746 | 16892232.0 |
| 2007-07-25 10:00:00 | AAPL | Stock | 4.8746 | 4.8889 | 4.8686 | 4.8707 | 19543552.0 |
| 2007-07-25 10:05:00 | AAPL | Stock | 4.8707 | 4.8914 | 4.8621 | 4.8796 | 20560792.0 |
| 2007-07-25 10:10:00 | AAPL | Stock | 4.8793 | 4.8821 | 4.87 | 4.8729 | 11580016.0 |
| 2007-07-25 10:15:00 | AAPL | Stock | 4.8724 | 4.9182 | 4.8718 | 4.9161 | 29765568.0 |
| 2007-07-25 10:20:00 | AAPL | Stock | 4.9161 | 4.9196 | 4.8821 | 4.8857 | 19441912.0 |
| 2007-07-25 10:25:00 | AAPL | Stock | 4.8857 | 4.8982 | 4.8818 | 4.8929 | 13606264.0 |
| 2007-07-25 10:30:00 | AAPL | Stock | 4.8923 | 4.8982 | 4.875 | 4.8804 | 15543360.0 |
| 2007-07-25 10:35:00 | AAPL | Stock | 4.8804 | 4.8936 | 4.8664 | 4.8775 | 14094892.0 |
| 2007-07-25 10:40:00 | AAPL | Stock | 4.8775 | 4.8886 | 4.8661 | 4.8661 | 10670352.0 |
| 2007-07-25 10:45:00 | AAPL | Stock | 4.8661 | 4.8768 | 4.8571 | 4.8625 | 17895892.0 |
| 2007-07-25 10:50:00 | AAPL | Stock | 4.8625 | 4.875 | 4.8596 | 4.8725 | 9251984.0 |
| 2007-07-25 10:55:00 | AAPL | Stock | 4.8729 | 4.8904 | 4.8664 | 4.8746 | 14466004.0 |
| 2007-07-25 11:00:00 | AAPL | Stock | 4.8736 | 4.8779 | 4.8686 | 4.8775 | 10645628.0 |
| 2007-07-25 11:05:00 | AAPL | Stock | 4.8779 | 4.8836 | 4.8607 | 4.8639 | 11504136.0 |
| 2007-07-25 11:10:00 | AAPL | Stock | 4.8639 | 4.88 | 4.8611 | 4.8718 | 8783264.0 |
| 2007-07-25 11:15:00 | AAPL | Stock | 4.8718 | 4.8718 | 4.86 | 4.8621 | 9570876.0 |
| 2007-07-25 11:20:00 | AAPL | Stock | 4.8621 | 4.875 | 4.8621 | 4.8693 | 10993136.0 |
| 2007-07-25 11:25:00 | AAPL | Stock | 4.8696 | 4.8743 | 4.8657 | 4.8721 | 8018696.0 |
| 2007-07-25 11:30:00 | AAPL | Stock | 4.8721 | 4.8807 | 4.8679 | 4.8704 | 11228448.0 |
| 2007-07-25 11:35:00 | AAPL | Stock | 4.8704 | 4.8764 | 4.8643 | 4.8746 | 12145896.0 |
| 2007-07-25 11:40:00 | AAPL | Stock | 4.8746 | 4.8804 | 4.8693 | 4.8779 | 8062852.0 |
| 2007-07-25 11:45:00 | AAPL | Stock | 4.8771 | 4.8786 | 4.8643 | 4.8654 | 9178288.0 |
| 2007-07-25 11:50:00 | AAPL | Stock | 4.8657 | 4.8775 | 4.8643 | 4.8739 | 7622692.0 |
| 2007-07-25 11:55:00 | AAPL | Stock | 4.8739 | 4.8775 | 4.8696 | 4.8725 | 4719400.0 |
| 2007-07-25 12:00:00 | AAPL | Stock | 4.8725 | 4.8804 | 4.8725 | 4.8743 | 4470508.0 |
| 2007-07-25 12:05:00 | AAPL | Stock | 4.8746 | 4.8811 | 4.8714 | 4.8811 | 6207824.0 |
| 2007-07-25 12:10:00 | AAPL | Stock | 4.8814 | 4.9018 | 4.88 | 4.89 | 13538924.0 |
| 2007-07-25 12:15:00 | AAPL | Stock | 4.8909 | 4.9068 | 4.8793 | 4.9068 | 8783432.0 |
| 2007-07-25 12:20:00 | AAPL | Stock | 4.9061 | 4.9107 | 4.8971 | 4.9014 | 10073084.0 |
| 2007-07-25 12:25:00 | AAPL | Stock | 4.9011 | 4.9171 | 4.875 | 4.9132 | 10325196.0 |
| 2007-07-25 12:30:00 | AAPL | Stock | 4.9129 | 4.925 | 4.89 | 4.9089 | 16957584.0 |
| 2007-07-25 12:35:00 | AAPL | Stock | 4.9086 | 4.9157 | 4.9068 | 4.9129 | 6003032.0 |
| 2007-07-25 12:40:00 | AAPL | Stock | 4.9129 | 4.9179 | 4.9071 | 4.9075 | 5935076.0 |
| 2007-07-25 12:45:00 | AAPL | Stock | 4.9075 | 4.9118 | 4.9 | 4.9043 | 6444256.0 |
| 2007-07-25 12:50:00 | AAPL | Stock | 4.9046 | 4.9061 | 4.8925 | 4.9011 | 10716748.0 |
| 2007-07-25 12:55:00 | AAPL | Stock | 4.9011 | 4.9089 | 4.8986 | 4.9021 | 5346012.0 |
| 2007-07-25 13:00:00 | AAPL | Stock | 4.9021 | 4.9082 | 4.8968 | 4.9032 | 5285364.0 |
| 2007-07-25 13:05:00 | AAPL | Stock | 4.9039 | 4.9043 | 4.8882 | 4.8886 | 6497596.0 |
| 2007-07-25 13:10:00 | AAPL | Stock | 4.8886 | 4.8911 | 4.8675 | 4.8804 | 14528612.0 |
| 2007-07-25 13:15:00 | AAPL | Stock | 4.88 | 4.8834 | 4.8714 | 4.8768 | 6975640.0 |
| 2007-07-25 13:20:00 | AAPL | Stock | 4.8768 | 4.8846 | 4.8768 | 4.8789 | 6860000.0 |
| 2007-07-25 13:25:00 | AAPL | Stock | 4.8793 | 4.8911 | 4.8789 | 4.8829 | 7270200.0 |
| 2007-07-25 13:30:00 | AAPL | Stock | 4.8821 | 4.8821 | 4.8714 | 4.8743 | 8172612.0 |
| 2007-07-25 13:35:00 | AAPL | Stock | 4.8746 | 4.8893 | 4.8729 | 4.8773 | 8323756.0 |
> showing 50 of 306,316 rows — these rows as CSV