PREVIEW / stock_5min / 2013-12-03
file: by_date/stock_5min/2013/2013-12-03.parquet size: 5.4 MB rows: 360,296 symbols: 3,544
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-03 04:00:00 | AAPL | Stock | 19.8211 | 20.0036 | 19.8211 | 19.9025 | 44352.0 |
| 2013-12-03 04:05:00 | AAPL | Stock | 19.9479 | 19.9489 | 19.9432 | 19.9432 | 14000.0 |
| 2013-12-03 04:10:00 | AAPL | Stock | 19.9382 | 19.9382 | 19.9382 | 19.9382 | 5600.0 |
| 2013-12-03 04:20:00 | AAPL | Stock | 19.9407 | 19.9407 | 19.9407 | 19.9407 | 2800.0 |
| 2013-12-03 04:30:00 | AAPL | Stock | 19.9621 | 19.9696 | 19.9286 | 19.9643 | 30660.0 |
| 2013-12-03 04:35:00 | AAPL | Stock | 19.9357 | 19.9357 | 19.9357 | 19.9357 | 2800.0 |
| 2013-12-03 04:40:00 | AAPL | Stock | 19.9646 | 19.9686 | 19.9646 | 19.9686 | 12600.0 |
| 2013-12-03 04:55:00 | AAPL | Stock | 19.9332 | 19.9332 | 19.9332 | 19.9332 | 2800.0 |
| 2013-12-03 05:00:00 | AAPL | Stock | 19.9375 | 19.9375 | 19.8489 | 19.8646 | 23800.0 |
| 2013-12-03 05:05:00 | AAPL | Stock | 19.8907 | 19.8907 | 19.8907 | 19.8907 | 2800.0 |
| 2013-12-03 05:15:00 | AAPL | Stock | 19.9021 | 19.9021 | 19.9021 | 19.9021 | 2800.0 |
| 2013-12-03 05:20:00 | AAPL | Stock | 19.9079 | 19.9093 | 19.9079 | 19.9093 | 7000.0 |
| 2013-12-03 05:25:00 | AAPL | Stock | 19.9082 | 19.9186 | 19.9082 | 19.9125 | 34048.0 |
| 2013-12-03 05:30:00 | AAPL | Stock | 19.9075 | 19.9075 | 19.9075 | 19.9075 | 8400.0 |
| 2013-12-03 05:35:00 | AAPL | Stock | 19.9129 | 19.9129 | 19.9036 | 19.9036 | 7280.0 |
| 2013-12-03 05:40:00 | AAPL | Stock | 19.9129 | 19.9129 | 19.8714 | 19.8714 | 117124.0 |
| 2013-12-03 05:45:00 | AAPL | Stock | 19.8811 | 19.8829 | 19.8707 | 19.8764 | 36148.0 |
| 2013-12-03 05:50:00 | AAPL | Stock | 19.8725 | 19.88 | 19.8725 | 19.88 | 5600.0 |
| 2013-12-03 05:55:00 | AAPL | Stock | 19.8829 | 19.8929 | 19.8829 | 19.8929 | 33600.0 |
| 2013-12-03 06:00:00 | AAPL | Stock | 19.9107 | 19.9193 | 19.9107 | 19.9193 | 16800.0 |
| 2013-12-03 06:05:00 | AAPL | Stock | 19.9218 | 19.9254 | 19.9211 | 19.925 | 25200.0 |
| 2013-12-03 06:10:00 | AAPL | Stock | 19.925 | 19.925 | 19.925 | 19.925 | 2800.0 |
| 2013-12-03 06:15:00 | AAPL | Stock | 19.9232 | 19.9232 | 19.9232 | 19.9232 | 2800.0 |
| 2013-12-03 06:20:00 | AAPL | Stock | 19.9136 | 19.9139 | 19.9136 | 19.9139 | 10080.0 |
| 2013-12-03 06:25:00 | AAPL | Stock | 19.9139 | 19.925 | 19.9139 | 19.925 | 17920.0 |
| 2013-12-03 06:30:00 | AAPL | Stock | 19.9196 | 19.9196 | 19.9196 | 19.9196 | 4340.0 |
| 2013-12-03 06:35:00 | AAPL | Stock | 19.8761 | 19.8857 | 19.8761 | 19.8857 | 16800.0 |
| 2013-12-03 06:40:00 | AAPL | Stock | 19.8857 | 19.9071 | 19.8857 | 19.9071 | 64036.0 |
| 2013-12-03 06:45:00 | AAPL | Stock | 19.9071 | 19.9286 | 19.9071 | 19.9286 | 77896.0 |
| 2013-12-03 06:50:00 | AAPL | Stock | 19.9111 | 19.9111 | 19.9111 | 19.9111 | 7000.0 |
| 2013-12-03 06:55:00 | AAPL | Stock | 19.9111 | 19.925 | 19.9107 | 19.925 | 14000.0 |
| 2013-12-03 07:00:00 | AAPL | Stock | 19.9129 | 19.9246 | 19.875 | 19.875 | 350700.0 |
| 2013-12-03 07:05:00 | AAPL | Stock | 19.8854 | 19.8854 | 19.8532 | 19.8532 | 113092.0 |
| 2013-12-03 07:10:00 | AAPL | Stock | 19.8571 | 19.8754 | 19.8571 | 19.8679 | 96572.0 |
| 2013-12-03 07:15:00 | AAPL | Stock | 19.8743 | 19.8754 | 19.8571 | 19.8571 | 25536.0 |
| 2013-12-03 07:20:00 | AAPL | Stock | 19.8571 | 19.875 | 19.8571 | 19.875 | 86380.0 |
| 2013-12-03 07:25:00 | AAPL | Stock | 19.875 | 19.8807 | 19.8743 | 19.8743 | 16800.0 |
| 2013-12-03 07:30:00 | AAPL | Stock | 19.8743 | 19.8804 | 19.8714 | 19.8732 | 152376.0 |
| 2013-12-03 07:35:00 | AAPL | Stock | 19.8775 | 19.8982 | 19.8775 | 19.8929 | 146552.0 |
| 2013-12-03 07:40:00 | AAPL | Stock | 19.8982 | 19.9143 | 19.8964 | 19.9132 | 273056.0 |
| 2013-12-03 07:45:00 | AAPL | Stock | 19.9075 | 19.9143 | 19.875 | 19.8893 | 290836.0 |
| 2013-12-03 07:50:00 | AAPL | Stock | 19.8893 | 19.8914 | 19.8761 | 19.8896 | 35728.0 |
| 2013-12-03 07:55:00 | AAPL | Stock | 19.8889 | 19.8929 | 19.8889 | 19.8929 | 24108.0 |
| 2013-12-03 08:00:00 | AAPL | Stock | 19.8918 | 19.925 | 19.6964 | 19.85 | 875700.0 |
| 2013-12-03 08:05:00 | AAPL | Stock | 19.8571 | 19.8657 | 19.84 | 19.8464 | 233100.0 |
| 2013-12-03 08:10:00 | AAPL | Stock | 19.8514 | 19.8514 | 19.8411 | 19.8507 | 141120.0 |
| 2013-12-03 08:15:00 | AAPL | Stock | 19.8443 | 19.8864 | 19.8411 | 19.86 | 314888.0 |
| 2013-12-03 08:20:00 | AAPL | Stock | 19.8571 | 19.8764 | 19.8571 | 19.87 | 191856.0 |
| 2013-12-03 08:25:00 | AAPL | Stock | 19.8743 | 19.9014 | 19.8714 | 19.8964 | 495544.0 |
| 2013-12-03 08:30:00 | AAPL | Stock | 19.8943 | 19.9014 | 19.8575 | 19.8661 | 377748.0 |
> showing 50 of 360,296 rows — these rows as CSV