PREVIEW / stock_5min / 2011-05-17
file: by_date/stock_5min/2011/2011-05-17.parquet size: 5.0 MB rows: 341,228 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-17 04:40:00 | AAPL | Stock | 11.9243 | 11.9243 | 11.9243 | 11.9243 | 2800.0 |
| 2011-05-17 05:50:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 11816.0 |
| 2011-05-17 05:55:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 14000.0 |
| 2011-05-17 06:00:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-05-17 06:45:00 | AAPL | Stock | 11.95 | 11.95 | 11.95 | 11.95 | 14000.0 |
| 2011-05-17 06:50:00 | AAPL | Stock | 11.9518 | 11.9518 | 11.9464 | 11.95 | 22400.0 |
| 2011-05-17 06:55:00 | AAPL | Stock | 11.95 | 11.95 | 11.9464 | 11.9464 | 66584.0 |
| 2011-05-17 07:00:00 | AAPL | Stock | 11.9396 | 11.9582 | 11.9393 | 11.95 | 82516.0 |
| 2011-05-17 07:05:00 | AAPL | Stock | 11.9493 | 11.95 | 11.9493 | 11.95 | 8400.0 |
| 2011-05-17 07:10:00 | AAPL | Stock | 11.9393 | 11.9393 | 11.9214 | 11.9214 | 9800.0 |
| 2011-05-17 07:15:00 | AAPL | Stock | 11.9425 | 11.9589 | 11.9346 | 11.9589 | 150920.0 |
| 2011-05-17 07:25:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 17780.0 |
| 2011-05-17 07:30:00 | AAPL | Stock | 11.9286 | 11.9411 | 11.9286 | 11.9411 | 50400.0 |
| 2011-05-17 07:40:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9236 | 11.9236 | 12460.0 |
| 2011-05-17 07:45:00 | AAPL | Stock | 11.9218 | 11.9304 | 11.9214 | 11.925 | 25480.0 |
| 2011-05-17 07:50:00 | AAPL | Stock | 11.9168 | 11.9254 | 11.9107 | 11.9143 | 33488.0 |
| 2011-05-17 07:55:00 | AAPL | Stock | 11.9207 | 11.9207 | 11.9089 | 11.9107 | 22400.0 |
| 2011-05-17 08:00:00 | AAPL | Stock | 11.9196 | 11.9196 | 11.9107 | 11.9193 | 70952.0 |
| 2011-05-17 08:05:00 | AAPL | Stock | 11.9157 | 11.9157 | 11.9043 | 11.9136 | 70560.0 |
| 2011-05-17 08:10:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.8807 | 11.8821 | 224084.0 |
| 2011-05-17 08:15:00 | AAPL | Stock | 11.8846 | 11.8846 | 11.8789 | 11.8804 | 131460.0 |
| 2011-05-17 08:20:00 | AAPL | Stock | 11.8804 | 11.8839 | 11.8625 | 11.875 | 231224.0 |
| 2011-05-17 08:25:00 | AAPL | Stock | 11.8814 | 11.8814 | 11.8439 | 11.8657 | 731584.0 |
| 2011-05-17 08:30:00 | AAPL | Stock | 11.8575 | 11.8675 | 11.8479 | 11.8514 | 251636.0 |
| 2011-05-17 08:35:00 | AAPL | Stock | 11.8504 | 11.8621 | 11.8504 | 11.8621 | 349468.0 |
| 2011-05-17 08:40:00 | AAPL | Stock | 11.8625 | 11.8679 | 11.8571 | 11.8671 | 156744.0 |
| 2011-05-17 08:45:00 | AAPL | Stock | 11.8654 | 11.8693 | 11.8571 | 11.8643 | 194180.0 |
| 2011-05-17 08:50:00 | AAPL | Stock | 11.8643 | 11.8643 | 11.8464 | 11.8589 | 182616.0 |
| 2011-05-17 08:55:00 | AAPL | Stock | 11.8593 | 11.8832 | 11.8593 | 11.8679 | 112560.0 |
| 2011-05-17 09:00:00 | AAPL | Stock | 11.8696 | 11.8893 | 11.8679 | 11.8864 | 159600.0 |
| 2011-05-17 09:05:00 | AAPL | Stock | 11.8814 | 11.8893 | 11.8779 | 11.8829 | 172928.0 |
| 2011-05-17 09:10:00 | AAPL | Stock | 11.885 | 11.8961 | 11.8839 | 11.8839 | 200592.0 |
| 2011-05-17 09:15:00 | AAPL | Stock | 11.8839 | 11.8964 | 11.8786 | 11.8882 | 595644.0 |
| 2011-05-17 09:20:00 | AAPL | Stock | 11.8882 | 11.8907 | 11.875 | 11.875 | 129640.0 |
| 2011-05-17 09:25:00 | AAPL | Stock | 11.8871 | 11.8889 | 11.8511 | 11.8571 | 801976.0 |
| 2011-05-17 09:30:00 | AAPL | Stock | 11.8571 | 11.9018 | 11.8271 | 11.8854 | 16457140.0 |
| 2011-05-17 09:35:00 | AAPL | Stock | 11.8764 | 11.8836 | 11.8118 | 11.8536 | 11723460.0 |
| 2011-05-17 09:40:00 | AAPL | Stock | 11.8518 | 11.8764 | 11.8282 | 11.8543 | 10671444.0 |
| 2011-05-17 09:45:00 | AAPL | Stock | 11.8539 | 11.8768 | 11.8464 | 11.8586 | 7270340.0 |
| 2011-05-17 09:50:00 | AAPL | Stock | 11.8589 | 11.8607 | 11.8364 | 11.8521 | 7556612.0 |
| 2011-05-17 09:55:00 | AAPL | Stock | 11.8518 | 11.8764 | 11.8493 | 11.8524 | 8973468.0 |
| 2011-05-17 10:00:00 | AAPL | Stock | 11.8521 | 11.8575 | 11.8214 | 11.825 | 7329420.0 |
| 2011-05-17 10:05:00 | AAPL | Stock | 11.8246 | 11.8396 | 11.8207 | 11.825 | 6080592.0 |
| 2011-05-17 10:10:00 | AAPL | Stock | 11.8221 | 11.8586 | 11.8179 | 11.8548 | 7637896.0 |
| 2011-05-17 10:15:00 | AAPL | Stock | 11.8549 | 11.8893 | 11.8549 | 11.885 | 9653364.0 |
| 2011-05-17 10:20:00 | AAPL | Stock | 11.885 | 11.93 | 11.8818 | 11.9277 | 12915504.0 |
| 2011-05-17 10:25:00 | AAPL | Stock | 11.9293 | 11.9554 | 11.9229 | 11.9544 | 12784828.0 |
| 2011-05-17 10:30:00 | AAPL | Stock | 11.9546 | 11.9565 | 11.9296 | 11.9318 | 8313676.0 |
| 2011-05-17 10:35:00 | AAPL | Stock | 11.9318 | 11.9411 | 11.9182 | 11.9279 | 5994800.0 |
| 2011-05-17 10:40:00 | AAPL | Stock | 11.9262 | 11.9314 | 11.9196 | 11.9271 | 3731672.0 |
> showing 50 of 341,228 rows — these rows as CSV