PREVIEW / stock_5min / 2007-08-30
file: by_date/stock_5min/2007/2007-08-30.parquet size: 3.9 MB rows: 289,851 symbols: 3,089
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-08-30 09:30:00 | AAPL | Stock | 4.7357 | 4.75 | 4.725 | 4.7486 | 30265844.0 |
| 2007-08-30 09:35:00 | AAPL | Stock | 4.7493 | 4.7832 | 4.7443 | 4.7757 | 28176960.0 |
| 2007-08-30 09:40:00 | AAPL | Stock | 4.7757 | 4.8054 | 4.7682 | 4.795 | 34496588.0 |
| 2007-08-30 09:45:00 | AAPL | Stock | 4.7954 | 4.8543 | 4.7886 | 4.8389 | 50746864.0 |
| 2007-08-30 09:50:00 | AAPL | Stock | 4.8414 | 4.8825 | 4.8411 | 4.8646 | 46599140.0 |
| 2007-08-30 09:55:00 | AAPL | Stock | 4.8646 | 4.8982 | 4.8639 | 4.8871 | 42748132.0 |
| 2007-08-30 10:00:00 | AAPL | Stock | 4.8857 | 4.8904 | 4.8571 | 4.8732 | 37148188.0 |
| 2007-08-30 10:05:00 | AAPL | Stock | 4.8739 | 4.9129 | 4.8682 | 4.9064 | 45731952.0 |
| 2007-08-30 10:10:00 | AAPL | Stock | 4.9064 | 4.9104 | 4.8811 | 4.8936 | 27598900.0 |
| 2007-08-30 10:15:00 | AAPL | Stock | 4.8936 | 4.9157 | 4.8846 | 4.9143 | 23983680.0 |
| 2007-08-30 10:20:00 | AAPL | Stock | 4.9143 | 4.9286 | 4.9075 | 4.9164 | 30865996.0 |
| 2007-08-30 10:25:00 | AAPL | Stock | 4.9164 | 4.9318 | 4.9079 | 4.9104 | 24218712.0 |
| 2007-08-30 10:30:00 | AAPL | Stock | 4.91 | 4.9268 | 4.9093 | 4.9168 | 19358836.0 |
| 2007-08-30 10:35:00 | AAPL | Stock | 4.9164 | 4.9218 | 4.8964 | 4.8993 | 20856836.0 |
| 2007-08-30 10:40:00 | AAPL | Stock | 4.9 | 4.9054 | 4.8939 | 4.9054 | 16050636.0 |
| 2007-08-30 10:45:00 | AAPL | Stock | 4.9054 | 4.9075 | 4.8893 | 4.9029 | 15297464.0 |
| 2007-08-30 10:50:00 | AAPL | Stock | 4.9025 | 4.9179 | 4.8996 | 4.9107 | 16928296.0 |
| 2007-08-30 10:55:00 | AAPL | Stock | 4.9111 | 4.9318 | 4.9039 | 4.9218 | 28244356.0 |
| 2007-08-30 11:00:00 | AAPL | Stock | 4.9218 | 4.9375 | 4.9204 | 4.9225 | 26596584.0 |
| 2007-08-30 11:05:00 | AAPL | Stock | 4.9221 | 4.9246 | 4.9132 | 4.9161 | 11818128.0 |
| 2007-08-30 11:10:00 | AAPL | Stock | 4.9164 | 4.9321 | 4.9154 | 4.9239 | 17488940.0 |
| 2007-08-30 11:15:00 | AAPL | Stock | 4.9236 | 4.9311 | 4.9214 | 4.9271 | 11496800.0 |
| 2007-08-30 11:20:00 | AAPL | Stock | 4.9275 | 4.9339 | 4.9196 | 4.9232 | 14136780.0 |
| 2007-08-30 11:25:00 | AAPL | Stock | 4.9225 | 4.9232 | 4.9143 | 4.9179 | 10787392.0 |
| 2007-08-30 11:30:00 | AAPL | Stock | 4.9193 | 4.9219 | 4.9125 | 4.9186 | 7218316.0 |
| 2007-08-30 11:35:00 | AAPL | Stock | 4.9186 | 4.9279 | 4.9132 | 4.9243 | 8691592.0 |
| 2007-08-30 11:40:00 | AAPL | Stock | 4.9246 | 4.925 | 4.9173 | 4.9196 | 7594356.0 |
| 2007-08-30 11:45:00 | AAPL | Stock | 4.92 | 4.9207 | 4.9114 | 4.9175 | 7937020.0 |
| 2007-08-30 11:50:00 | AAPL | Stock | 4.9173 | 4.9196 | 4.9071 | 4.9108 | 9552872.0 |
| 2007-08-30 11:55:00 | AAPL | Stock | 4.9111 | 4.9125 | 4.8986 | 4.9004 | 12211360.0 |
| 2007-08-30 12:00:00 | AAPL | Stock | 4.8999 | 4.9025 | 4.8757 | 4.8771 | 20992888.0 |
| 2007-08-30 12:05:00 | AAPL | Stock | 4.8768 | 4.8871 | 4.8696 | 4.8811 | 18090828.0 |
| 2007-08-30 12:10:00 | AAPL | Stock | 4.8814 | 4.8857 | 4.8768 | 4.8843 | 9742684.0 |
| 2007-08-30 12:15:00 | AAPL | Stock | 4.8839 | 4.89 | 4.8732 | 4.8736 | 11069772.0 |
| 2007-08-30 12:20:00 | AAPL | Stock | 4.8736 | 4.8836 | 4.8596 | 4.8757 | 19061196.0 |
| 2007-08-30 12:25:00 | AAPL | Stock | 4.8754 | 4.9 | 4.8732 | 4.8975 | 15240428.0 |
| 2007-08-30 12:30:00 | AAPL | Stock | 4.8968 | 4.9064 | 4.8907 | 4.9011 | 11408488.0 |
| 2007-08-30 12:35:00 | AAPL | Stock | 4.9011 | 4.9107 | 4.8982 | 4.9068 | 10978520.0 |
| 2007-08-30 12:40:00 | AAPL | Stock | 4.9064 | 4.9107 | 4.9004 | 4.9107 | 9045932.0 |
| 2007-08-30 12:45:00 | AAPL | Stock | 4.91 | 4.9125 | 4.8989 | 4.9028 | 7678356.0 |
| 2007-08-30 12:50:00 | AAPL | Stock | 4.9029 | 4.9057 | 4.8964 | 4.9036 | 5109552.0 |
| 2007-08-30 12:55:00 | AAPL | Stock | 4.9036 | 4.9161 | 4.9036 | 4.9075 | 10226104.0 |
| 2007-08-30 13:00:00 | AAPL | Stock | 4.9071 | 4.9121 | 4.9011 | 4.9082 | 7493920.0 |
| 2007-08-30 13:05:00 | AAPL | Stock | 4.9075 | 4.9146 | 4.9071 | 4.9093 | 4490360.0 |
| 2007-08-30 13:10:00 | AAPL | Stock | 4.9096 | 4.9107 | 4.9036 | 4.9054 | 3568068.0 |
| 2007-08-30 13:15:00 | AAPL | Stock | 4.9054 | 4.9057 | 4.895 | 4.8975 | 6528956.0 |
| 2007-08-30 13:20:00 | AAPL | Stock | 4.8975 | 4.9011 | 4.8955 | 4.8982 | 3497480.0 |
| 2007-08-30 13:25:00 | AAPL | Stock | 4.8982 | 4.8986 | 4.8804 | 4.8868 | 13900208.0 |
| 2007-08-30 13:30:00 | AAPL | Stock | 4.8868 | 4.8886 | 4.8732 | 4.8793 | 9555112.0 |
| 2007-08-30 13:35:00 | AAPL | Stock | 4.8793 | 4.8993 | 4.8793 | 4.8979 | 8153040.0 |
> showing 50 of 289,851 rows — these rows as CSV