PREVIEW / stock_5min / 2009-12-17
file: by_date/stock_5min/2009/2009-12-17.parquet size: 4.6 MB rows: 317,528 symbols: 3,427
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-17 04:15:00 | AAPL | Stock | 6.9589 | 6.9589 | 6.9589 | 6.9589 | 2800.0 |
| 2009-12-17 04:45:00 | AAPL | Stock | 6.9318 | 6.9318 | 6.9304 | 6.9304 | 8400.0 |
| 2009-12-17 07:00:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9214 | 6.9214 | 19600.0 |
| 2009-12-17 07:20:00 | AAPL | Stock | 6.9386 | 6.9386 | 6.9386 | 6.9386 | 2800.0 |
| 2009-12-17 07:45:00 | AAPL | Stock | 6.9311 | 6.9311 | 6.9282 | 6.9282 | 47600.0 |
| 2009-12-17 07:50:00 | AAPL | Stock | 6.9196 | 6.9196 | 6.9196 | 6.9196 | 2800.0 |
| 2009-12-17 08:00:00 | AAPL | Stock | 6.9393 | 6.9429 | 6.9179 | 6.925 | 109368.0 |
| 2009-12-17 08:05:00 | AAPL | Stock | 6.9211 | 6.925 | 6.9179 | 6.9196 | 72100.0 |
| 2009-12-17 08:10:00 | AAPL | Stock | 6.9179 | 6.9196 | 6.9107 | 6.9107 | 148988.0 |
| 2009-12-17 08:15:00 | AAPL | Stock | 6.9075 | 6.9196 | 6.9075 | 6.9196 | 177268.0 |
| 2009-12-17 08:20:00 | AAPL | Stock | 6.9196 | 6.9196 | 6.9129 | 6.9129 | 44380.0 |
| 2009-12-17 08:25:00 | AAPL | Stock | 6.9179 | 6.9286 | 6.9179 | 6.9286 | 161588.0 |
| 2009-12-17 08:30:00 | AAPL | Stock | 6.9236 | 6.9284 | 6.9182 | 6.92 | 54180.0 |
| 2009-12-17 08:35:00 | AAPL | Stock | 6.92 | 6.92 | 6.9071 | 6.9107 | 214480.0 |
| 2009-12-17 08:40:00 | AAPL | Stock | 6.9107 | 6.9143 | 6.9082 | 6.9143 | 15232.0 |
| 2009-12-17 08:45:00 | AAPL | Stock | 6.9129 | 6.9196 | 6.9125 | 6.9125 | 44800.0 |
| 2009-12-17 08:50:00 | AAPL | Stock | 6.9125 | 6.9196 | 6.9125 | 6.9196 | 109200.0 |
| 2009-12-17 08:55:00 | AAPL | Stock | 6.9268 | 6.9275 | 6.9196 | 6.9268 | 53200.0 |
| 2009-12-17 09:00:00 | AAPL | Stock | 6.9214 | 6.9239 | 6.9214 | 6.9214 | 36904.0 |
| 2009-12-17 09:05:00 | AAPL | Stock | 6.9221 | 6.9239 | 6.9218 | 6.9218 | 16800.0 |
| 2009-12-17 09:10:00 | AAPL | Stock | 6.9218 | 6.9236 | 6.9214 | 6.9236 | 8400.0 |
| 2009-12-17 09:15:00 | AAPL | Stock | 6.9236 | 6.9286 | 6.9236 | 6.9286 | 53200.0 |
| 2009-12-17 09:20:00 | AAPL | Stock | 6.9282 | 6.9282 | 6.9282 | 6.9282 | 2800.0 |
| 2009-12-17 09:25:00 | AAPL | Stock | 6.9282 | 6.9411 | 6.9279 | 6.9411 | 238700.0 |
| 2009-12-17 09:30:00 | AAPL | Stock | 6.9329 | 6.965 | 6.9132 | 6.9264 | 10801980.0 |
| 2009-12-17 09:35:00 | AAPL | Stock | 6.9262 | 6.9464 | 6.925 | 6.9418 | 8469132.0 |
| 2009-12-17 09:40:00 | AAPL | Stock | 6.9411 | 6.9437 | 6.925 | 6.9321 | 6196652.0 |
| 2009-12-17 09:45:00 | AAPL | Stock | 6.9321 | 6.9321 | 6.9146 | 6.9196 | 5874344.0 |
| 2009-12-17 09:50:00 | AAPL | Stock | 6.9207 | 6.9254 | 6.9136 | 6.9175 | 5959268.0 |
| 2009-12-17 09:55:00 | AAPL | Stock | 6.9179 | 6.9193 | 6.8879 | 6.8918 | 12396440.0 |
| 2009-12-17 10:00:00 | AAPL | Stock | 6.8907 | 6.9071 | 6.8739 | 6.8793 | 16667560.0 |
| 2009-12-17 10:05:00 | AAPL | Stock | 6.8796 | 6.8883 | 6.8636 | 6.885 | 8210048.0 |
| 2009-12-17 10:10:00 | AAPL | Stock | 6.8861 | 6.895 | 6.8789 | 6.8814 | 7768264.0 |
| 2009-12-17 10:15:00 | AAPL | Stock | 6.8825 | 6.8857 | 6.8643 | 6.8811 | 31985660.0 |
| 2009-12-17 10:20:00 | AAPL | Stock | 6.8807 | 6.8846 | 6.8661 | 6.8661 | 8268904.0 |
| 2009-12-17 10:25:00 | AAPL | Stock | 6.8661 | 6.8857 | 6.8629 | 6.8832 | 7130228.0 |
| 2009-12-17 10:30:00 | AAPL | Stock | 6.8829 | 6.8871 | 6.8711 | 6.8749 | 4308024.0 |
| 2009-12-17 10:35:00 | AAPL | Stock | 6.8743 | 6.8743 | 6.8536 | 6.8625 | 10794112.0 |
| 2009-12-17 10:40:00 | AAPL | Stock | 6.8624 | 6.8668 | 6.8575 | 6.8642 | 4765460.0 |
| 2009-12-17 10:45:00 | AAPL | Stock | 6.8636 | 6.8754 | 6.8586 | 6.8736 | 4873820.0 |
| 2009-12-17 10:50:00 | AAPL | Stock | 6.8736 | 6.8836 | 6.8696 | 6.8829 | 4708620.0 |
| 2009-12-17 10:55:00 | AAPL | Stock | 6.8829 | 6.8982 | 6.8807 | 6.8932 | 7386232.0 |
| 2009-12-17 11:00:00 | AAPL | Stock | 6.8936 | 6.9059 | 6.8933 | 6.8968 | 5930596.0 |
| 2009-12-17 11:05:00 | AAPL | Stock | 6.8966 | 6.9086 | 6.895 | 6.8982 | 4765992.0 |
| 2009-12-17 11:10:00 | AAPL | Stock | 6.8982 | 6.9018 | 6.8932 | 6.8968 | 3185308.0 |
| 2009-12-17 11:15:00 | AAPL | Stock | 6.8968 | 6.9096 | 6.8968 | 6.9057 | 5111400.0 |
| 2009-12-17 11:20:00 | AAPL | Stock | 6.9057 | 6.9136 | 6.9029 | 6.9129 | 2775836.0 |
| 2009-12-17 11:25:00 | AAPL | Stock | 6.9125 | 6.9164 | 6.9004 | 6.9054 | 5917632.0 |
| 2009-12-17 11:30:00 | AAPL | Stock | 6.9046 | 6.9054 | 6.895 | 6.9032 | 3033660.0 |
| 2009-12-17 11:35:00 | AAPL | Stock | 6.9026 | 6.9029 | 6.8932 | 6.8979 | 1981560.0 |
> showing 50 of 317,528 rows — these rows as CSV