PREVIEW / stock_5min / 2005-10-17
file: by_date/stock_5min/2005/2005-10-17.parquet size: 2.8 MB rows: 204,244 symbols: 2,095
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-17 08:00:00 | AAPL | Stock | 1.9214 | 1.9214 | 1.9154 | 1.9179 | 434280.0 |
| 2005-10-17 08:05:00 | AAPL | Stock | 1.9157 | 1.9161 | 1.9071 | 1.9111 | 160748.0 |
| 2005-10-17 08:10:00 | AAPL | Stock | 1.9143 | 1.9143 | 1.9114 | 1.9114 | 72940.0 |
| 2005-10-17 08:15:00 | AAPL | Stock | 1.9114 | 1.9136 | 1.9089 | 1.9089 | 245140.0 |
| 2005-10-17 08:20:00 | AAPL | Stock | 1.9089 | 1.9143 | 1.9089 | 1.9143 | 127148.0 |
| 2005-10-17 08:25:00 | AAPL | Stock | 1.9107 | 1.9125 | 1.9107 | 1.9107 | 61600.0 |
| 2005-10-17 08:30:00 | AAPL | Stock | 1.9089 | 1.9089 | 1.9082 | 1.9089 | 70000.0 |
| 2005-10-17 08:35:00 | AAPL | Stock | 1.9082 | 1.9107 | 1.9079 | 1.9107 | 112000.0 |
| 2005-10-17 08:40:00 | AAPL | Stock | 1.9096 | 1.91 | 1.9079 | 1.9096 | 90720.0 |
| 2005-10-17 08:45:00 | AAPL | Stock | 1.9107 | 1.9161 | 1.9107 | 1.915 | 148400.0 |
| 2005-10-17 08:50:00 | AAPL | Stock | 1.915 | 1.9275 | 1.915 | 1.9196 | 1286656.0 |
| 2005-10-17 08:55:00 | AAPL | Stock | 1.9214 | 1.9214 | 1.9179 | 1.9179 | 95200.0 |
| 2005-10-17 09:00:00 | AAPL | Stock | 1.9186 | 1.9196 | 1.9182 | 1.9182 | 62888.0 |
| 2005-10-17 09:05:00 | AAPL | Stock | 1.9179 | 1.9261 | 1.9175 | 1.925 | 591584.0 |
| 2005-10-17 09:10:00 | AAPL | Stock | 1.925 | 1.9275 | 1.9225 | 1.925 | 470820.0 |
| 2005-10-17 09:15:00 | AAPL | Stock | 1.9232 | 1.9275 | 1.9232 | 1.925 | 235032.0 |
| 2005-10-17 09:20:00 | AAPL | Stock | 1.925 | 1.925 | 1.9232 | 1.9232 | 246400.0 |
| 2005-10-17 09:25:00 | AAPL | Stock | 1.9239 | 1.9293 | 1.9221 | 1.9293 | 1730204.0 |
| 2005-10-17 09:30:00 | AAPL | Stock | 1.9279 | 1.9286 | 1.9161 | 1.9193 | 20999944.0 |
| 2005-10-17 09:35:00 | AAPL | Stock | 1.9193 | 1.9318 | 1.9182 | 1.9275 | 20395648.0 |
| 2005-10-17 09:40:00 | AAPL | Stock | 1.9275 | 1.9275 | 1.915 | 1.9221 | 20878480.0 |
| 2005-10-17 09:45:00 | AAPL | Stock | 1.9221 | 1.9229 | 1.915 | 1.9186 | 14300048.0 |
| 2005-10-17 09:50:00 | AAPL | Stock | 1.9186 | 1.9275 | 1.9175 | 1.9211 | 13984992.0 |
| 2005-10-17 09:55:00 | AAPL | Stock | 1.9218 | 1.9239 | 1.9196 | 1.9214 | 6042932.0 |
| 2005-10-17 10:00:00 | AAPL | Stock | 1.9214 | 1.9236 | 1.9179 | 1.9225 | 9770012.0 |
| 2005-10-17 10:05:00 | AAPL | Stock | 1.9221 | 1.9368 | 1.92 | 1.9314 | 23531340.0 |
| 2005-10-17 10:10:00 | AAPL | Stock | 1.9314 | 1.9321 | 1.9193 | 1.9221 | 13049904.0 |
| 2005-10-17 10:15:00 | AAPL | Stock | 1.9218 | 1.9232 | 1.91 | 1.9107 | 14213668.0 |
| 2005-10-17 10:20:00 | AAPL | Stock | 1.9104 | 1.9157 | 1.9071 | 1.9136 | 15367800.0 |
| 2005-10-17 10:25:00 | AAPL | Stock | 1.9136 | 1.9164 | 1.9118 | 1.9154 | 7219828.0 |
| 2005-10-17 10:30:00 | AAPL | Stock | 1.915 | 1.9182 | 1.9139 | 1.9143 | 8076264.0 |
| 2005-10-17 10:35:00 | AAPL | Stock | 1.9146 | 1.9193 | 1.9111 | 1.9175 | 10944696.0 |
| 2005-10-17 10:40:00 | AAPL | Stock | 1.9175 | 1.9221 | 1.9164 | 1.9211 | 10723020.0 |
| 2005-10-17 10:45:00 | AAPL | Stock | 1.9207 | 1.9207 | 1.9175 | 1.9175 | 5574156.0 |
| 2005-10-17 10:50:00 | AAPL | Stock | 1.9175 | 1.9179 | 1.9121 | 1.9136 | 7753648.0 |
| 2005-10-17 10:55:00 | AAPL | Stock | 1.9143 | 1.9143 | 1.9121 | 1.9143 | 7099680.0 |
| 2005-10-17 11:00:00 | AAPL | Stock | 1.9139 | 1.9157 | 1.9118 | 1.9147 | 7511252.0 |
| 2005-10-17 11:05:00 | AAPL | Stock | 1.915 | 1.9171 | 1.9143 | 1.9163 | 3920588.0 |
| 2005-10-17 11:10:00 | AAPL | Stock | 1.9164 | 1.9182 | 1.9111 | 1.9111 | 5895848.0 |
| 2005-10-17 11:15:00 | AAPL | Stock | 1.9111 | 1.9161 | 1.9111 | 1.9146 | 5279876.0 |
| 2005-10-17 11:20:00 | AAPL | Stock | 1.9146 | 1.9146 | 1.9111 | 1.9121 | 3931956.0 |
| 2005-10-17 11:25:00 | AAPL | Stock | 1.9121 | 1.9136 | 1.9111 | 1.9129 | 1977416.0 |
| 2005-10-17 11:30:00 | AAPL | Stock | 1.9129 | 1.9136 | 1.9086 | 1.9129 | 5341896.0 |
| 2005-10-17 11:35:00 | AAPL | Stock | 1.9125 | 1.9125 | 1.9057 | 1.9068 | 7482020.0 |
| 2005-10-17 11:40:00 | AAPL | Stock | 1.9068 | 1.9086 | 1.9054 | 1.9071 | 6042204.0 |
| 2005-10-17 11:45:00 | AAPL | Stock | 1.9071 | 1.9075 | 1.9007 | 1.9021 | 11203696.0 |
| 2005-10-17 11:50:00 | AAPL | Stock | 1.9025 | 1.9071 | 1.9018 | 1.9036 | 6687688.0 |
| 2005-10-17 11:55:00 | AAPL | Stock | 1.9036 | 1.9039 | 1.8971 | 1.8982 | 11605244.0 |
| 2005-10-17 12:00:00 | AAPL | Stock | 1.8982 | 1.9018 | 1.8979 | 1.9014 | 7313516.0 |
| 2005-10-17 12:05:00 | AAPL | Stock | 1.9014 | 1.9032 | 1.9 | 1.9014 | 5489904.0 |
> showing 50 of 204,244 rows — these rows as CSV