PREVIEW / stock_5min / 2011-10-14
file: by_date/stock_5min/2011/2011-10-14.parquet size: 4.6 MB rows: 313,768 symbols: 3,504
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-10-14 04:05:00 | AAPL | Stock | 14.7268 | 14.7268 | 14.7268 | 14.7268 | 5600.0 |
| 2011-10-14 04:10:00 | AAPL | Stock | 14.7232 | 14.7232 | 14.7232 | 14.7232 | 2800.0 |
| 2011-10-14 04:15:00 | AAPL | Stock | 14.7193 | 14.7193 | 14.7193 | 14.7193 | 5600.0 |
| 2011-10-14 04:20:00 | AAPL | Stock | 14.75 | 14.75 | 14.75 | 14.75 | 8400.0 |
| 2011-10-14 04:25:00 | AAPL | Stock | 14.7307 | 14.7307 | 14.7307 | 14.7307 | 2800.0 |
| 2011-10-14 04:40:00 | AAPL | Stock | 14.7518 | 14.7518 | 14.75 | 14.75 | 14000.0 |
| 2011-10-14 04:50:00 | AAPL | Stock | 14.7643 | 14.7714 | 14.7643 | 14.7714 | 14560.0 |
| 2011-10-14 04:55:00 | AAPL | Stock | 14.7714 | 14.7714 | 14.7679 | 14.7679 | 14000.0 |
| 2011-10-14 05:05:00 | AAPL | Stock | 14.7786 | 14.7786 | 14.7786 | 14.7786 | 2800.0 |
| 2011-10-14 05:20:00 | AAPL | Stock | 14.7736 | 14.7736 | 14.7736 | 14.7736 | 2800.0 |
| 2011-10-14 05:25:00 | AAPL | Stock | 14.7736 | 14.7786 | 14.7736 | 14.7786 | 19572.0 |
| 2011-10-14 05:30:00 | AAPL | Stock | 14.7843 | 14.7843 | 14.7843 | 14.7843 | 2800.0 |
| 2011-10-14 05:50:00 | AAPL | Stock | 14.8196 | 14.8214 | 14.8196 | 14.8214 | 8400.0 |
| 2011-10-14 06:20:00 | AAPL | Stock | 14.8307 | 14.8307 | 14.8307 | 14.8307 | 2800.0 |
| 2011-10-14 06:30:00 | AAPL | Stock | 14.8379 | 14.8379 | 14.8379 | 14.8379 | 2800.0 |
| 2011-10-14 06:35:00 | AAPL | Stock | 14.8536 | 14.8536 | 14.8536 | 14.8536 | 2800.0 |
| 2011-10-14 06:40:00 | AAPL | Stock | 14.8664 | 14.8664 | 14.8664 | 14.8664 | 2800.0 |
| 2011-10-14 06:45:00 | AAPL | Stock | 14.8482 | 14.8482 | 14.8446 | 14.8446 | 7560.0 |
| 2011-10-14 06:50:00 | AAPL | Stock | 14.8689 | 14.8689 | 14.8689 | 14.8689 | 2800.0 |
| 2011-10-14 07:00:00 | AAPL | Stock | 14.8893 | 14.9554 | 14.8893 | 14.9107 | 167916.0 |
| 2011-10-14 07:05:00 | AAPL | Stock | 14.8932 | 14.9275 | 14.8929 | 14.8929 | 152292.0 |
| 2011-10-14 07:10:00 | AAPL | Stock | 14.8775 | 14.9011 | 14.8775 | 14.8929 | 66864.0 |
| 2011-10-14 07:15:00 | AAPL | Stock | 14.8929 | 14.9 | 14.8571 | 14.8786 | 128800.0 |
| 2011-10-14 07:20:00 | AAPL | Stock | 14.8804 | 14.8804 | 14.8482 | 14.8482 | 76860.0 |
| 2011-10-14 07:25:00 | AAPL | Stock | 14.8571 | 14.8707 | 14.8557 | 14.8707 | 16548.0 |
| 2011-10-14 07:30:00 | AAPL | Stock | 14.8714 | 14.8743 | 14.8657 | 14.8657 | 64400.0 |
| 2011-10-14 07:35:00 | AAPL | Stock | 14.8668 | 14.8729 | 14.8446 | 14.8536 | 82152.0 |
| 2011-10-14 07:40:00 | AAPL | Stock | 14.8446 | 14.8571 | 14.8357 | 14.8496 | 181944.0 |
| 2011-10-14 07:45:00 | AAPL | Stock | 14.8464 | 14.8607 | 14.8464 | 14.8489 | 305312.0 |
| 2011-10-14 07:50:00 | AAPL | Stock | 14.85 | 14.85 | 14.8232 | 14.8293 | 103936.0 |
| 2011-10-14 07:55:00 | AAPL | Stock | 14.8293 | 14.8514 | 14.8 | 14.8514 | 266812.0 |
| 2011-10-14 08:00:00 | AAPL | Stock | 14.8518 | 14.8875 | 14.8214 | 14.8846 | 1160516.0 |
| 2011-10-14 08:05:00 | AAPL | Stock | 14.8843 | 14.9286 | 14.8843 | 14.9029 | 1535296.0 |
| 2011-10-14 08:10:00 | AAPL | Stock | 14.9086 | 14.9286 | 14.8939 | 14.9107 | 443268.0 |
| 2011-10-14 08:15:00 | AAPL | Stock | 14.9071 | 14.9071 | 14.8954 | 14.9018 | 268548.0 |
| 2011-10-14 08:20:00 | AAPL | Stock | 14.9 | 14.9075 | 14.8807 | 14.8929 | 431004.0 |
| 2011-10-14 08:25:00 | AAPL | Stock | 14.8936 | 14.9021 | 14.8925 | 14.8929 | 254856.0 |
| 2011-10-14 08:30:00 | AAPL | Stock | 14.8929 | 14.9107 | 14.8786 | 14.8879 | 680344.0 |
| 2011-10-14 08:35:00 | AAPL | Stock | 14.8879 | 14.9157 | 14.8861 | 14.9143 | 626444.0 |
| 2011-10-14 08:40:00 | AAPL | Stock | 14.9139 | 14.9171 | 14.9007 | 14.9046 | 447356.0 |
| 2011-10-14 08:45:00 | AAPL | Stock | 14.9071 | 14.9071 | 14.8886 | 14.8975 | 489860.0 |
| 2011-10-14 08:50:00 | AAPL | Stock | 14.8982 | 14.9286 | 14.8979 | 14.925 | 721364.0 |
| 2011-10-14 08:55:00 | AAPL | Stock | 14.9243 | 14.9464 | 14.9243 | 14.9286 | 1098916.0 |
| 2011-10-14 09:00:00 | AAPL | Stock | 14.9279 | 14.9339 | 14.9232 | 14.9304 | 336028.0 |
| 2011-10-14 09:05:00 | AAPL | Stock | 14.9304 | 14.9361 | 14.9282 | 14.9286 | 722008.0 |
| 2011-10-14 09:10:00 | AAPL | Stock | 14.9286 | 14.9311 | 14.9204 | 14.9204 | 384776.0 |
| 2011-10-14 09:15:00 | AAPL | Stock | 14.9204 | 14.9354 | 14.9143 | 14.9254 | 576100.0 |
| 2011-10-14 09:20:00 | AAPL | Stock | 14.9286 | 14.9321 | 14.9107 | 14.9207 | 326760.0 |
| 2011-10-14 09:25:00 | AAPL | Stock | 14.9207 | 14.9207 | 14.8775 | 14.89 | 869120.0 |
| 2011-10-14 09:30:00 | AAPL | Stock | 14.8868 | 14.9593 | 14.8629 | 14.9568 | 33976348.0 |
> showing 50 of 313,768 rows — these rows as CSV