PREVIEW / stock_1min / 2011-10-24
file: by_date/stock_1min/2011/2011-10-24.parquet size: 13.3 MB rows: 990,908 symbols: 2,838
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-24 04:27:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 2800.0 |
| 2011-10-24 04:29:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 2800.0 |
| 2011-10-24 04:43:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 2800.0 |
| 2011-10-24 04:48:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 2800.0 |
| 2011-10-24 04:51:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 2800.0 |
| 2011-10-24 04:52:00 | AAPL | Stock | 14.1061 | 14.1061 | 14.1061 | 14.1061 | 14000.0 |
| 2011-10-24 05:04:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-10-24 05:05:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-10-24 05:25:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-10-24 05:54:00 | AAPL | Stock | 14.0964 | 14.0964 | 14.0964 | 14.0964 | 5600.0 |
| 2011-10-24 06:08:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 3920.0 |
| 2011-10-24 06:18:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 10920.0 |
| 2011-10-24 06:20:00 | AAPL | Stock | 14.1036 | 14.1036 | 14.1036 | 14.1036 | 2800.0 |
| 2011-10-24 06:48:00 | AAPL | Stock | 14.1036 | 14.1036 | 14.1036 | 14.1036 | 2800.0 |
| 2011-10-24 06:57:00 | AAPL | Stock | 14.1 | 14.1 | 14.1 | 14.1 | 14000.0 |
| 2011-10-24 06:59:00 | AAPL | Stock | 14.1164 | 14.1164 | 14.1164 | 14.1164 | 5600.0 |
| 2011-10-24 07:02:00 | AAPL | Stock | 14.1064 | 14.1064 | 14.1064 | 14.1064 | 2800.0 |
| 2011-10-24 07:13:00 | AAPL | Stock | 14.1064 | 14.1064 | 14.1064 | 14.1064 | 8120.0 |
| 2011-10-24 07:26:00 | AAPL | Stock | 14.1021 | 14.1021 | 14.1021 | 14.1021 | 27076.0 |
| 2011-10-24 07:27:00 | AAPL | Stock | 14.1068 | 14.1071 | 14.1068 | 14.1071 | 30800.0 |
| 2011-10-24 07:28:00 | AAPL | Stock | 14.1021 | 14.1021 | 14.1021 | 14.1021 | 2800.0 |
| 2011-10-24 07:29:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1021 | 14.1021 | 11200.0 |
| 2011-10-24 07:30:00 | AAPL | Stock | 14.0964 | 14.0964 | 14.0964 | 14.0964 | 17640.0 |
| 2011-10-24 07:31:00 | AAPL | Stock | 14.0964 | 14.0964 | 14.0964 | 14.0964 | 3892.0 |
| 2011-10-24 07:32:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 5600.0 |
| 2011-10-24 07:33:00 | AAPL | Stock | 14.0964 | 14.0964 | 14.0964 | 14.0964 | 2800.0 |
| 2011-10-24 07:36:00 | AAPL | Stock | 14.0929 | 14.0929 | 14.0904 | 14.0904 | 5600.0 |
| 2011-10-24 07:41:00 | AAPL | Stock | 14.0943 | 14.0943 | 14.0943 | 14.0943 | 5600.0 |
| 2011-10-24 07:45:00 | AAPL | Stock | 14.0946 | 14.0946 | 14.0946 | 14.0946 | 2800.0 |
| 2011-10-24 07:46:00 | AAPL | Stock | 14.09 | 14.1071 | 14.09 | 14.1071 | 56840.0 |
| 2011-10-24 07:47:00 | AAPL | Stock | 14.1071 | 14.1139 | 14.1071 | 14.1139 | 14000.0 |
| 2011-10-24 07:48:00 | AAPL | Stock | 14.1143 | 14.1204 | 14.1143 | 14.1146 | 44800.0 |
| 2011-10-24 07:49:00 | AAPL | Stock | 14.1129 | 14.1129 | 14.1075 | 14.1075 | 16800.0 |
| 2011-10-24 07:50:00 | AAPL | Stock | 14.1154 | 14.1154 | 14.1154 | 14.1154 | 2800.0 |
| 2011-10-24 07:53:00 | AAPL | Stock | 14.1107 | 14.1107 | 14.1107 | 14.1107 | 11200.0 |
| 2011-10-24 07:55:00 | AAPL | Stock | 14.1182 | 14.1214 | 14.1182 | 14.1214 | 14000.0 |
| 2011-10-24 07:57:00 | AAPL | Stock | 14.1089 | 14.1089 | 14.1071 | 14.1071 | 35308.0 |
| 2011-10-24 07:58:00 | AAPL | Stock | 14.1071 | 14.1214 | 14.1071 | 14.1214 | 28700.0 |
| 2011-10-24 08:00:00 | AAPL | Stock | 14.1179 | 14.1189 | 14.1025 | 14.1093 | 87724.0 |
| 2011-10-24 08:01:00 | AAPL | Stock | 14.1186 | 14.1214 | 14.1186 | 14.1214 | 8400.0 |
| 2011-10-24 08:02:00 | AAPL | Stock | 14.1214 | 14.1257 | 14.1214 | 14.125 | 50260.0 |
| 2011-10-24 08:03:00 | AAPL | Stock | 14.125 | 14.1339 | 14.125 | 14.125 | 43960.0 |
| 2011-10-24 08:04:00 | AAPL | Stock | 14.1286 | 14.1321 | 14.1275 | 14.1321 | 11200.0 |
| 2011-10-24 08:05:00 | AAPL | Stock | 14.1286 | 14.1339 | 14.1286 | 14.1339 | 16632.0 |
| 2011-10-24 08:06:00 | AAPL | Stock | 14.1339 | 14.1475 | 14.1339 | 14.1439 | 124936.0 |
| 2011-10-24 08:07:00 | AAPL | Stock | 14.1393 | 14.15 | 14.1339 | 14.1339 | 56196.0 |
| 2011-10-24 08:08:00 | AAPL | Stock | 14.1386 | 14.1389 | 14.1357 | 14.1357 | 40880.0 |
| 2011-10-24 08:09:00 | AAPL | Stock | 14.1339 | 14.1339 | 14.1339 | 14.1339 | 2800.0 |
| 2011-10-24 08:10:00 | AAPL | Stock | 14.125 | 14.1293 | 14.125 | 14.1293 | 24836.0 |
| 2011-10-24 08:11:00 | AAPL | Stock | 14.1293 | 14.1336 | 14.1232 | 14.1336 | 16184.0 |
> showing 50 of 990,908 rows — these rows as CSV