PREVIEW / stock_1min / 2014-04-22
file: by_date/stock_1min/2014/2014-04-22.parquet size: 14.3 MB rows: 1,045,359 symbols: 2,894
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-22 04:46:00 | AAPL | Stock | 18.9589 | 18.9589 | 18.9589 | 18.9589 | 2800.0 |
| 2014-04-22 04:52:00 | AAPL | Stock | 18.9589 | 18.9589 | 18.9589 | 18.9589 | 2800.0 |
| 2014-04-22 05:28:00 | AAPL | Stock | 18.9036 | 18.9036 | 18.9036 | 18.9036 | 2800.0 |
| 2014-04-22 05:36:00 | AAPL | Stock | 18.9143 | 18.9179 | 18.9143 | 18.9179 | 34384.0 |
| 2014-04-22 06:01:00 | AAPL | Stock | 18.92 | 18.92 | 18.92 | 18.92 | 2800.0 |
| 2014-04-22 06:08:00 | AAPL | Stock | 18.9529 | 18.9529 | 18.9529 | 18.9529 | 2940.0 |
| 2014-04-22 06:36:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2014-04-22 07:15:00 | AAPL | Stock | 18.9293 | 18.9293 | 18.9293 | 18.9293 | 2800.0 |
| 2014-04-22 07:18:00 | AAPL | Stock | 18.9304 | 18.9304 | 18.9275 | 18.9275 | 13440.0 |
| 2014-04-22 07:20:00 | AAPL | Stock | 18.9268 | 18.9286 | 18.9268 | 18.9286 | 5600.0 |
| 2014-04-22 07:22:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.9321 | 18.9321 | 10416.0 |
| 2014-04-22 07:29:00 | AAPL | Stock | 18.93 | 18.93 | 18.9286 | 18.9286 | 11200.0 |
| 2014-04-22 07:31:00 | AAPL | Stock | 18.915 | 18.915 | 18.915 | 18.915 | 9520.0 |
| 2014-04-22 07:32:00 | AAPL | Stock | 18.9189 | 18.9189 | 18.9107 | 18.9107 | 29540.0 |
| 2014-04-22 07:42:00 | AAPL | Stock | 18.9179 | 18.9196 | 18.9179 | 18.9196 | 56000.0 |
| 2014-04-22 07:45:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2014-04-22 07:54:00 | AAPL | Stock | 18.9154 | 18.9154 | 18.9068 | 18.9089 | 39200.0 |
| 2014-04-22 07:55:00 | AAPL | Stock | 18.8996 | 18.8996 | 18.895 | 18.895 | 27300.0 |
| 2014-04-22 07:56:00 | AAPL | Stock | 18.895 | 18.895 | 18.8804 | 18.8804 | 51800.0 |
| 2014-04-22 07:57:00 | AAPL | Stock | 18.875 | 18.8814 | 18.8661 | 18.8675 | 44072.0 |
| 2014-04-22 07:58:00 | AAPL | Stock | 18.8925 | 18.8929 | 18.8707 | 18.8707 | 11200.0 |
| 2014-04-22 08:00:00 | AAPL | Stock | 18.8796 | 18.9464 | 18.8786 | 18.8839 | 89880.0 |
| 2014-04-22 08:01:00 | AAPL | Stock | 18.8979 | 18.9 | 18.8939 | 18.8939 | 22400.0 |
| 2014-04-22 08:04:00 | AAPL | Stock | 18.8954 | 18.8954 | 18.8954 | 18.8954 | 2800.0 |
| 2014-04-22 08:05:00 | AAPL | Stock | 18.8964 | 18.8964 | 18.8964 | 18.8964 | 11788.0 |
| 2014-04-22 08:08:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 14000.0 |
| 2014-04-22 08:10:00 | AAPL | Stock | 18.8896 | 18.8896 | 18.8896 | 18.8896 | 2800.0 |
| 2014-04-22 08:12:00 | AAPL | Stock | 18.8921 | 18.8929 | 18.8921 | 18.8929 | 12880.0 |
| 2014-04-22 08:14:00 | AAPL | Stock | 18.89 | 18.89 | 18.8871 | 18.8871 | 47600.0 |
| 2014-04-22 08:15:00 | AAPL | Stock | 18.8846 | 18.8893 | 18.8821 | 18.8893 | 35000.0 |
| 2014-04-22 08:17:00 | AAPL | Stock | 18.8893 | 18.8893 | 18.8893 | 18.8893 | 5600.0 |
| 2014-04-22 08:18:00 | AAPL | Stock | 18.8886 | 18.8886 | 18.8886 | 18.8886 | 5600.0 |
| 2014-04-22 08:19:00 | AAPL | Stock | 18.8921 | 18.8929 | 18.8921 | 18.8929 | 56000.0 |
| 2014-04-22 08:20:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8857 | 18.8857 | 52640.0 |
| 2014-04-22 08:21:00 | AAPL | Stock | 18.8864 | 18.8996 | 18.8857 | 18.8996 | 88760.0 |
| 2014-04-22 08:24:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 4200.0 |
| 2014-04-22 08:25:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 9800.0 |
| 2014-04-22 08:27:00 | AAPL | Stock | 18.8893 | 18.9 | 18.8893 | 18.8993 | 29764.0 |
| 2014-04-22 08:30:00 | AAPL | Stock | 18.9032 | 18.9036 | 18.9032 | 18.9036 | 14420.0 |
| 2014-04-22 08:31:00 | AAPL | Stock | 18.9061 | 18.9061 | 18.9061 | 18.9061 | 2800.0 |
| 2014-04-22 08:34:00 | AAPL | Stock | 18.9068 | 18.9068 | 18.9068 | 18.9068 | 5600.0 |
| 2014-04-22 08:36:00 | AAPL | Stock | 18.9018 | 18.9068 | 18.9018 | 18.9018 | 19600.0 |
| 2014-04-22 08:37:00 | AAPL | Stock | 18.9068 | 18.9068 | 18.9018 | 18.9018 | 25200.0 |
| 2014-04-22 08:40:00 | AAPL | Stock | 18.9054 | 18.9054 | 18.9054 | 18.9054 | 28924.0 |
| 2014-04-22 08:41:00 | AAPL | Stock | 18.905 | 18.905 | 18.905 | 18.905 | 5600.0 |
| 2014-04-22 08:42:00 | AAPL | Stock | 18.9068 | 18.9168 | 18.9068 | 18.9168 | 114296.0 |
| 2014-04-22 08:43:00 | AAPL | Stock | 18.9132 | 18.9214 | 18.9132 | 18.9179 | 57232.0 |
| 2014-04-22 08:44:00 | AAPL | Stock | 18.9164 | 18.9311 | 18.9164 | 18.9311 | 143752.0 |
| 2014-04-22 08:45:00 | AAPL | Stock | 18.9311 | 18.9382 | 18.9286 | 18.9286 | 78400.0 |
| 2014-04-22 08:47:00 | AAPL | Stock | 18.9368 | 18.9368 | 18.9368 | 18.9368 | 5600.0 |
> showing 50 of 1,045,359 rows — these rows as CSV