PREVIEW / stock_1min / 2013-11-22
file: by_date/stock_1min/2013/2013-11-22.parquet size: 13.8 MB rows: 1,012,151 symbols: 2,893
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-11-22 04:11:00 | AAPL | Stock | 18.67 | 18.6786 | 18.6689 | 18.6689 | 11200.0 |
| 2013-11-22 04:45:00 | AAPL | Stock | 18.66 | 18.66 | 18.66 | 18.66 | 4200.0 |
| 2013-11-22 04:52:00 | AAPL | Stock | 18.6539 | 18.6539 | 18.6539 | 18.6539 | 2800.0 |
| 2013-11-22 05:15:00 | AAPL | Stock | 18.6479 | 18.6479 | 18.6479 | 18.6479 | 2800.0 |
| 2013-11-22 06:44:00 | AAPL | Stock | 18.6286 | 18.6286 | 18.6286 | 18.6286 | 2800.0 |
| 2013-11-22 07:00:00 | AAPL | Stock | 18.6207 | 18.6207 | 18.6207 | 18.6207 | 9996.0 |
| 2013-11-22 07:02:00 | AAPL | Stock | 18.6279 | 18.6279 | 18.6279 | 18.6279 | 2800.0 |
| 2013-11-22 07:04:00 | AAPL | Stock | 18.6146 | 18.6146 | 18.6143 | 18.6143 | 28000.0 |
| 2013-11-22 07:10:00 | AAPL | Stock | 18.6232 | 18.6232 | 18.6232 | 18.6232 | 2800.0 |
| 2013-11-22 07:26:00 | AAPL | Stock | 18.6275 | 18.6275 | 18.6275 | 18.6275 | 2800.0 |
| 2013-11-22 07:30:00 | AAPL | Stock | 18.6221 | 18.6221 | 18.6221 | 18.6221 | 2800.0 |
| 2013-11-22 07:32:00 | AAPL | Stock | 18.6279 | 18.6286 | 18.6279 | 18.6286 | 25200.0 |
| 2013-11-22 07:46:00 | AAPL | Stock | 18.6289 | 18.6289 | 18.6286 | 18.6286 | 5600.0 |
| 2013-11-22 07:47:00 | AAPL | Stock | 18.6286 | 18.6286 | 18.625 | 18.625 | 37800.0 |
| 2013-11-22 07:49:00 | AAPL | Stock | 18.6214 | 18.6214 | 18.6214 | 18.6214 | 2800.0 |
| 2013-11-22 08:00:00 | AAPL | Stock | 18.6214 | 18.6357 | 18.6114 | 18.6114 | 70560.0 |
| 2013-11-22 08:01:00 | AAPL | Stock | 18.62 | 18.62 | 18.62 | 18.62 | 2800.0 |
| 2013-11-22 08:02:00 | AAPL | Stock | 18.5993 | 18.6121 | 18.5993 | 18.6071 | 36540.0 |
| 2013-11-22 08:04:00 | AAPL | Stock | 18.5982 | 18.5982 | 18.5982 | 18.5982 | 5600.0 |
| 2013-11-22 08:05:00 | AAPL | Stock | 18.5939 | 18.5982 | 18.5929 | 18.5982 | 10836.0 |
| 2013-11-22 08:08:00 | AAPL | Stock | 18.6104 | 18.6104 | 18.6104 | 18.6104 | 5600.0 |
| 2013-11-22 08:09:00 | AAPL | Stock | 18.6104 | 18.6104 | 18.6104 | 18.6104 | 14000.0 |
| 2013-11-22 08:10:00 | AAPL | Stock | 18.6104 | 18.6104 | 18.6104 | 18.6104 | 4200.0 |
| 2013-11-22 08:11:00 | AAPL | Stock | 18.6104 | 18.6104 | 18.6071 | 18.6071 | 35000.0 |
| 2013-11-22 08:13:00 | AAPL | Stock | 18.6086 | 18.6104 | 18.6086 | 18.6104 | 19600.0 |
| 2013-11-22 08:14:00 | AAPL | Stock | 18.6104 | 18.6121 | 18.6086 | 18.6086 | 55972.0 |
| 2013-11-22 08:15:00 | AAPL | Stock | 18.6075 | 18.6075 | 18.6075 | 18.6075 | 5600.0 |
| 2013-11-22 08:18:00 | AAPL | Stock | 18.6068 | 18.6071 | 18.6068 | 18.6071 | 11200.0 |
| 2013-11-22 08:20:00 | AAPL | Stock | 18.6075 | 18.6075 | 18.6 | 18.6 | 29120.0 |
| 2013-11-22 08:21:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 2800.0 |
| 2013-11-22 08:22:00 | AAPL | Stock | 18.6068 | 18.6082 | 18.6068 | 18.6082 | 28000.0 |
| 2013-11-22 08:23:00 | AAPL | Stock | 18.6075 | 18.6075 | 18.5982 | 18.5982 | 41860.0 |
| 2013-11-22 08:24:00 | AAPL | Stock | 18.5954 | 18.5954 | 18.5946 | 18.5946 | 5600.0 |
| 2013-11-22 08:25:00 | AAPL | Stock | 18.5946 | 18.5957 | 18.5929 | 18.5957 | 33404.0 |
| 2013-11-22 08:26:00 | AAPL | Stock | 18.5946 | 18.5946 | 18.5946 | 18.5946 | 14000.0 |
| 2013-11-22 08:27:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6068 | 18.6068 | 9016.0 |
| 2013-11-22 08:29:00 | AAPL | Stock | 18.6043 | 18.6107 | 18.6043 | 18.6107 | 43400.0 |
| 2013-11-22 08:32:00 | AAPL | Stock | 18.6157 | 18.6161 | 18.6146 | 18.6161 | 14000.0 |
| 2013-11-22 08:33:00 | AAPL | Stock | 18.6154 | 18.6154 | 18.6154 | 18.6154 | 2800.0 |
| 2013-11-22 08:35:00 | AAPL | Stock | 18.6136 | 18.6143 | 18.6136 | 18.6143 | 5600.0 |
| 2013-11-22 08:36:00 | AAPL | Stock | 18.6143 | 18.6143 | 18.6143 | 18.6143 | 2800.0 |
| 2013-11-22 08:37:00 | AAPL | Stock | 18.6143 | 18.6143 | 18.6143 | 18.6143 | 7000.0 |
| 2013-11-22 08:38:00 | AAPL | Stock | 18.6093 | 18.6093 | 18.6071 | 18.6071 | 8400.0 |
| 2013-11-22 08:39:00 | AAPL | Stock | 18.6054 | 18.6054 | 18.6039 | 18.6039 | 11200.0 |
| 2013-11-22 08:40:00 | AAPL | Stock | 18.6125 | 18.6125 | 18.6125 | 18.6125 | 2800.0 |
| 2013-11-22 08:43:00 | AAPL | Stock | 18.6043 | 18.6068 | 18.6014 | 18.6018 | 42000.0 |
| 2013-11-22 08:44:00 | AAPL | Stock | 18.6 | 18.6107 | 18.6 | 18.6107 | 84000.0 |
| 2013-11-22 08:47:00 | AAPL | Stock | 18.6075 | 18.6161 | 18.6075 | 18.6161 | 39200.0 |
| 2013-11-22 08:49:00 | AAPL | Stock | 18.6146 | 18.6214 | 18.6146 | 18.6214 | 51660.0 |
| 2013-11-22 08:50:00 | AAPL | Stock | 18.6207 | 18.6207 | 18.6179 | 18.6179 | 11200.0 |
> showing 50 of 1,012,151 rows — these rows as CSV