PREVIEW / stock_1min / 2013-07-11
file: by_date/stock_1min/2013/2013-07-11.parquet size: 13.7 MB rows: 1,010,320 symbols: 2,837
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-07-11 04:09:00 | AAPL | Stock | 15.1596 | 15.1596 | 15.1596 | 15.1596 | 11200.0 |
| 2013-07-11 04:19:00 | AAPL | Stock | 15.1586 | 15.1586 | 15.1586 | 15.1586 | 5600.0 |
| 2013-07-11 04:25:00 | AAPL | Stock | 15.1604 | 15.1604 | 15.1604 | 15.1604 | 3500.0 |
| 2013-07-11 04:39:00 | AAPL | Stock | 15.1521 | 15.1521 | 15.1521 | 15.1521 | 2800.0 |
| 2013-07-11 04:45:00 | AAPL | Stock | 15.1521 | 15.1521 | 15.1518 | 15.1518 | 21112.0 |
| 2013-07-11 04:52:00 | AAPL | Stock | 15.1479 | 15.1479 | 15.1479 | 15.1479 | 2800.0 |
| 2013-07-11 05:03:00 | AAPL | Stock | 15.1479 | 15.1479 | 15.1479 | 15.1479 | 2800.0 |
| 2013-07-11 05:06:00 | AAPL | Stock | 15.1479 | 15.1479 | 15.1479 | 15.1479 | 2800.0 |
| 2013-07-11 05:12:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5600.0 |
| 2013-07-11 05:19:00 | AAPL | Stock | 15.1375 | 15.1375 | 15.1375 | 15.1375 | 2800.0 |
| 2013-07-11 05:29:00 | AAPL | Stock | 15.1293 | 15.1293 | 15.1293 | 15.1293 | 7000.0 |
| 2013-07-11 06:19:00 | AAPL | Stock | 15.1286 | 15.1286 | 15.1286 | 15.1286 | 2800.0 |
| 2013-07-11 06:29:00 | AAPL | Stock | 15.1296 | 15.1296 | 15.1296 | 15.1296 | 2800.0 |
| 2013-07-11 07:00:00 | AAPL | Stock | 15.1286 | 15.1286 | 15.1286 | 15.1286 | 2800.0 |
| 2013-07-11 07:03:00 | AAPL | Stock | 15.1311 | 15.1311 | 15.1311 | 15.1311 | 5600.0 |
| 2013-07-11 07:04:00 | AAPL | Stock | 15.1336 | 15.1357 | 15.1336 | 15.1357 | 20916.0 |
| 2013-07-11 07:05:00 | AAPL | Stock | 15.1354 | 15.1429 | 15.1354 | 15.1425 | 35672.0 |
| 2013-07-11 07:06:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2013-07-11 07:09:00 | AAPL | Stock | 15.1414 | 15.1425 | 15.1414 | 15.1425 | 23800.0 |
| 2013-07-11 07:11:00 | AAPL | Stock | 15.1357 | 15.1357 | 15.1268 | 15.1268 | 6328.0 |
| 2013-07-11 07:15:00 | AAPL | Stock | 15.1129 | 15.1129 | 15.1107 | 15.1107 | 5600.0 |
| 2013-07-11 07:16:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 2800.0 |
| 2013-07-11 07:21:00 | AAPL | Stock | 15.115 | 15.115 | 15.115 | 15.115 | 2800.0 |
| 2013-07-11 07:26:00 | AAPL | Stock | 15.13 | 15.13 | 15.13 | 15.13 | 2800.0 |
| 2013-07-11 07:29:00 | AAPL | Stock | 15.1171 | 15.1179 | 15.1171 | 15.1179 | 11060.0 |
| 2013-07-11 07:30:00 | AAPL | Stock | 15.1146 | 15.1146 | 15.1146 | 15.1146 | 2800.0 |
| 2013-07-11 07:40:00 | AAPL | Stock | 15.1168 | 15.1182 | 15.1071 | 15.1071 | 50400.0 |
| 2013-07-11 07:41:00 | AAPL | Stock | 15.1071 | 15.1093 | 15.09 | 15.09 | 54600.0 |
| 2013-07-11 07:42:00 | AAPL | Stock | 15.0879 | 15.1021 | 15.0857 | 15.1021 | 22400.0 |
| 2013-07-11 07:43:00 | AAPL | Stock | 15.1 | 15.1 | 15.1 | 15.1 | 2800.0 |
| 2013-07-11 07:44:00 | AAPL | Stock | 15.1021 | 15.1071 | 15.1021 | 15.1071 | 62216.0 |
| 2013-07-11 07:48:00 | AAPL | Stock | 15.1104 | 15.13 | 15.1104 | 15.13 | 5600.0 |
| 2013-07-11 07:49:00 | AAPL | Stock | 15.1243 | 15.1243 | 15.1214 | 15.1214 | 5600.0 |
| 2013-07-11 07:51:00 | AAPL | Stock | 15.1164 | 15.1164 | 15.1143 | 15.1143 | 14000.0 |
| 2013-07-11 07:53:00 | AAPL | Stock | 15.1204 | 15.1211 | 15.1204 | 15.1211 | 5600.0 |
| 2013-07-11 07:54:00 | AAPL | Stock | 15.1089 | 15.1089 | 15.1075 | 15.1075 | 12796.0 |
| 2013-07-11 08:00:00 | AAPL | Stock | 15.1071 | 15.1429 | 15.1071 | 15.1071 | 145348.0 |
| 2013-07-11 08:01:00 | AAPL | Stock | 15.1154 | 15.1296 | 15.1154 | 15.1296 | 53620.0 |
| 2013-07-11 08:02:00 | AAPL | Stock | 15.1282 | 15.1296 | 15.12 | 15.1218 | 30800.0 |
| 2013-07-11 08:03:00 | AAPL | Stock | 15.1232 | 15.1257 | 15.1232 | 15.1254 | 22400.0 |
| 2013-07-11 08:04:00 | AAPL | Stock | 15.1257 | 15.1421 | 15.1257 | 15.1421 | 60200.0 |
| 2013-07-11 08:05:00 | AAPL | Stock | 15.1386 | 15.1386 | 15.13 | 15.1368 | 36400.0 |
| 2013-07-11 08:06:00 | AAPL | Stock | 15.13 | 15.13 | 15.125 | 15.125 | 44380.0 |
| 2013-07-11 08:07:00 | AAPL | Stock | 15.1354 | 15.1354 | 15.1346 | 15.1346 | 16380.0 |
| 2013-07-11 08:08:00 | AAPL | Stock | 15.1339 | 15.1357 | 15.1125 | 15.1125 | 89376.0 |
| 2013-07-11 08:09:00 | AAPL | Stock | 15.1146 | 15.1146 | 15.1143 | 15.1143 | 5600.0 |
| 2013-07-11 08:11:00 | AAPL | Stock | 15.1246 | 15.1246 | 15.1246 | 15.1246 | 2800.0 |
| 2013-07-11 08:12:00 | AAPL | Stock | 15.1232 | 15.1289 | 15.1232 | 15.1289 | 47152.0 |
| 2013-07-11 08:13:00 | AAPL | Stock | 15.1321 | 15.1339 | 15.125 | 15.125 | 42000.0 |
| 2013-07-11 08:14:00 | AAPL | Stock | 15.1336 | 15.1357 | 15.1336 | 15.1339 | 101500.0 |
> showing 50 of 1,010,320 rows — these rows as CSV