PREVIEW / stock_5min / 2007-07-31
file: by_date/stock_5min/2007/2007-07-31.parquet size: 4.3 MB rows: 307,328 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-31 09:30:00 | AAPL | Stock | 5.1061 | 5.1129 | 5.0893 | 5.1004 | 33544476.0 |
| 2007-07-31 09:35:00 | AAPL | Stock | 5.0984 | 5.1243 | 5.0984 | 5.1114 | 22660176.0 |
| 2007-07-31 09:40:00 | AAPL | Stock | 5.1111 | 5.1129 | 5.0714 | 5.08 | 29861748.0 |
| 2007-07-31 09:45:00 | AAPL | Stock | 5.08 | 5.0911 | 5.0732 | 5.0807 | 16728320.0 |
| 2007-07-31 09:50:00 | AAPL | Stock | 5.0807 | 5.0921 | 5.0775 | 5.0896 | 18097996.0 |
| 2007-07-31 09:55:00 | AAPL | Stock | 5.09 | 5.1054 | 5.0849 | 5.1011 | 18902940.0 |
| 2007-07-31 10:00:00 | AAPL | Stock | 5.1011 | 5.1179 | 5.0982 | 5.0989 | 19580652.0 |
| 2007-07-31 10:05:00 | AAPL | Stock | 5.0993 | 5.1036 | 5.0861 | 5.0943 | 13548360.0 |
| 2007-07-31 10:10:00 | AAPL | Stock | 5.0921 | 5.0969 | 5.0714 | 5.075 | 20774852.0 |
| 2007-07-31 10:15:00 | AAPL | Stock | 5.0744 | 5.08 | 5.0589 | 5.0607 | 32557364.0 |
| 2007-07-31 10:20:00 | AAPL | Stock | 5.0604 | 5.0604 | 4.9911 | 5.0025 | 56612388.0 |
| 2007-07-31 10:25:00 | AAPL | Stock | 5.0032 | 5.0182 | 4.9789 | 4.9879 | 47648944.0 |
| 2007-07-31 10:30:00 | AAPL | Stock | 4.9879 | 5.0 | 4.9204 | 4.9504 | 74073188.0 |
| 2007-07-31 10:35:00 | AAPL | Stock | 4.9493 | 5.0929 | 4.8946 | 4.9214 | 66755976.0 |
| 2007-07-31 10:40:00 | AAPL | Stock | 4.9211 | 4.9379 | 4.8836 | 4.8857 | 49408856.0 |
| 2007-07-31 10:45:00 | AAPL | Stock | 4.8857 | 4.9075 | 4.8625 | 4.8879 | 48938148.0 |
| 2007-07-31 10:50:00 | AAPL | Stock | 4.89 | 4.8929 | 4.8489 | 4.8793 | 51966936.0 |
| 2007-07-31 10:55:00 | AAPL | Stock | 4.8779 | 4.9264 | 4.8768 | 4.9111 | 47734400.0 |
| 2007-07-31 11:00:00 | AAPL | Stock | 4.9132 | 4.9357 | 4.9011 | 4.9254 | 28180320.0 |
| 2007-07-31 11:05:00 | AAPL | Stock | 4.925 | 4.9286 | 4.9043 | 4.9275 | 20080312.0 |
| 2007-07-31 11:10:00 | AAPL | Stock | 4.9275 | 4.9454 | 4.9161 | 4.9164 | 28733404.0 |
| 2007-07-31 11:15:00 | AAPL | Stock | 4.9164 | 4.9186 | 4.9043 | 4.9089 | 15084020.0 |
| 2007-07-31 11:20:00 | AAPL | Stock | 4.9079 | 4.9089 | 4.8696 | 4.8746 | 28389900.0 |
| 2007-07-31 11:25:00 | AAPL | Stock | 4.875 | 4.8929 | 4.8632 | 4.8882 | 19166420.0 |
| 2007-07-31 11:30:00 | AAPL | Stock | 4.8879 | 4.9014 | 4.8839 | 4.8918 | 16261140.0 |
| 2007-07-31 11:35:00 | AAPL | Stock | 4.8925 | 4.9032 | 4.8821 | 4.8889 | 12206908.0 |
| 2007-07-31 11:40:00 | AAPL | Stock | 4.8888 | 4.8982 | 4.8804 | 4.8925 | 10516380.0 |
| 2007-07-31 11:45:00 | AAPL | Stock | 4.8925 | 4.9089 | 4.8882 | 4.9061 | 10520692.0 |
| 2007-07-31 11:50:00 | AAPL | Stock | 4.9064 | 4.9121 | 4.9 | 4.9071 | 8604876.0 |
| 2007-07-31 11:55:00 | AAPL | Stock | 4.9075 | 4.9143 | 4.9018 | 4.9054 | 7947716.0 |
| 2007-07-31 12:00:00 | AAPL | Stock | 4.9043 | 4.9044 | 4.8779 | 4.8786 | 12795860.0 |
| 2007-07-31 12:05:00 | AAPL | Stock | 4.8786 | 4.8839 | 4.8661 | 4.8829 | 22056608.0 |
| 2007-07-31 12:10:00 | AAPL | Stock | 4.8832 | 4.8832 | 4.8721 | 4.8761 | 14499016.0 |
| 2007-07-31 12:15:00 | AAPL | Stock | 4.8757 | 4.8925 | 4.8657 | 4.8879 | 17693592.0 |
| 2007-07-31 12:20:00 | AAPL | Stock | 4.8875 | 4.9071 | 4.885 | 4.9061 | 19492564.0 |
| 2007-07-31 12:25:00 | AAPL | Stock | 4.9068 | 4.9214 | 4.8982 | 4.9029 | 20018684.0 |
| 2007-07-31 12:30:00 | AAPL | Stock | 4.9029 | 4.91 | 4.8821 | 4.8875 | 12950980.0 |
| 2007-07-31 12:35:00 | AAPL | Stock | 4.8875 | 4.8986 | 4.8864 | 4.8882 | 8247512.0 |
| 2007-07-31 12:40:00 | AAPL | Stock | 4.8892 | 4.8996 | 4.8875 | 4.8957 | 6562948.0 |
| 2007-07-31 12:45:00 | AAPL | Stock | 4.8961 | 4.9 | 4.8911 | 4.9 | 7831796.0 |
| 2007-07-31 12:50:00 | AAPL | Stock | 4.9 | 4.9014 | 4.8861 | 4.8911 | 7326704.0 |
| 2007-07-31 12:55:00 | AAPL | Stock | 4.8911 | 4.8943 | 4.8768 | 4.8932 | 8586200.0 |
| 2007-07-31 13:00:00 | AAPL | Stock | 4.8936 | 4.9071 | 4.8918 | 4.9057 | 8627444.0 |
| 2007-07-31 13:05:00 | AAPL | Stock | 4.9064 | 4.9093 | 4.8854 | 4.8959 | 8808492.0 |
| 2007-07-31 13:10:00 | AAPL | Stock | 4.895 | 4.9143 | 4.8929 | 4.9057 | 8708280.0 |
| 2007-07-31 13:15:00 | AAPL | Stock | 4.9061 | 4.915 | 4.8982 | 4.9032 | 7839300.0 |
| 2007-07-31 13:20:00 | AAPL | Stock | 4.9036 | 4.9107 | 4.8993 | 4.8996 | 6625500.0 |
| 2007-07-31 13:25:00 | AAPL | Stock | 4.8996 | 4.9018 | 4.8893 | 4.8904 | 9558472.0 |
| 2007-07-31 13:30:00 | AAPL | Stock | 4.8904 | 4.8979 | 4.8843 | 4.8918 | 7677852.0 |
| 2007-07-31 13:35:00 | AAPL | Stock | 4.8918 | 4.895 | 4.8846 | 4.8886 | 7220444.0 |
> showing 50 of 307,328 rows — these rows as CSV