PREVIEW / stock_1min / 2014-01-13
file: by_date/stock_1min/2014/2014-01-13.parquet size: 15.6 MB rows: 1,097,619 symbols: 2,863
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-01-13 04:12:00 | AAPL | Stock | 19.0339 | 19.0357 | 19.0339 | 19.0357 | 10836.0 |
| 2014-01-13 04:13:00 | AAPL | Stock | 19.0339 | 19.0339 | 19.03 | 19.0321 | 11760.0 |
| 2014-01-13 04:50:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 2800.0 |
| 2014-01-13 05:33:00 | AAPL | Stock | 19.0732 | 19.0732 | 19.0711 | 19.0732 | 12600.0 |
| 2014-01-13 05:53:00 | AAPL | Stock | 19.0693 | 19.0693 | 19.0693 | 19.0693 | 5600.0 |
| 2014-01-13 06:11:00 | AAPL | Stock | 19.0829 | 19.0829 | 19.0829 | 19.0829 | 2800.0 |
| 2014-01-13 06:27:00 | AAPL | Stock | 19.0789 | 19.0789 | 19.0789 | 19.0789 | 8400.0 |
| 2014-01-13 06:47:00 | AAPL | Stock | 19.0818 | 19.0818 | 19.0818 | 19.0818 | 14000.0 |
| 2014-01-13 06:58:00 | AAPL | Stock | 19.0818 | 19.0818 | 19.0814 | 19.0814 | 13160.0 |
| 2014-01-13 07:00:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.0843 | 19.0843 | 24444.0 |
| 2014-01-13 07:02:00 | AAPL | Stock | 19.0821 | 19.0821 | 19.0821 | 19.0821 | 26012.0 |
| 2014-01-13 07:04:00 | AAPL | Stock | 19.0864 | 19.0893 | 19.0864 | 19.0893 | 15260.0 |
| 2014-01-13 07:05:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0893 | 19.0893 | 19740.0 |
| 2014-01-13 07:06:00 | AAPL | Stock | 19.0946 | 19.0946 | 19.0946 | 19.0946 | 7196.0 |
| 2014-01-13 07:07:00 | AAPL | Stock | 19.1071 | 19.1196 | 19.1071 | 19.1196 | 8400.0 |
| 2014-01-13 07:09:00 | AAPL | Stock | 19.1571 | 19.1571 | 19.125 | 19.125 | 18844.0 |
| 2014-01-13 07:12:00 | AAPL | Stock | 19.1271 | 19.1271 | 19.1271 | 19.1271 | 8400.0 |
| 2014-01-13 07:13:00 | AAPL | Stock | 19.1271 | 19.1368 | 19.1225 | 19.1368 | 19600.0 |
| 2014-01-13 07:14:00 | AAPL | Stock | 19.1421 | 19.1429 | 19.1389 | 19.1389 | 15260.0 |
| 2014-01-13 07:15:00 | AAPL | Stock | 19.1307 | 19.1307 | 19.125 | 19.125 | 8400.0 |
| 2014-01-13 07:16:00 | AAPL | Stock | 19.1075 | 19.1075 | 19.1071 | 19.1075 | 11060.0 |
| 2014-01-13 07:17:00 | AAPL | Stock | 19.1211 | 19.1225 | 19.1204 | 19.1225 | 20440.0 |
| 2014-01-13 07:23:00 | AAPL | Stock | 19.1321 | 19.1375 | 19.1321 | 19.1375 | 16800.0 |
| 2014-01-13 07:25:00 | AAPL | Stock | 19.1418 | 19.1418 | 19.1418 | 19.1418 | 2800.0 |
| 2014-01-13 07:26:00 | AAPL | Stock | 19.1418 | 19.1571 | 19.1418 | 19.1571 | 16800.0 |
| 2014-01-13 07:27:00 | AAPL | Stock | 19.1571 | 19.1571 | 19.1571 | 19.1571 | 14000.0 |
| 2014-01-13 07:28:00 | AAPL | Stock | 19.1571 | 19.1571 | 19.1521 | 19.1521 | 8400.0 |
| 2014-01-13 07:30:00 | AAPL | Stock | 19.1432 | 19.1432 | 19.1432 | 19.1432 | 2800.0 |
| 2014-01-13 07:31:00 | AAPL | Stock | 19.1375 | 19.1514 | 19.125 | 19.125 | 16604.0 |
| 2014-01-13 07:41:00 | AAPL | Stock | 19.1132 | 19.1132 | 19.1132 | 19.1132 | 2800.0 |
| 2014-01-13 07:43:00 | AAPL | Stock | 19.1132 | 19.1132 | 19.1132 | 19.1132 | 2828.0 |
| 2014-01-13 07:44:00 | AAPL | Stock | 19.1164 | 19.1164 | 19.1164 | 19.1164 | 2800.0 |
| 2014-01-13 07:48:00 | AAPL | Stock | 19.125 | 19.125 | 19.125 | 19.125 | 12460.0 |
| 2014-01-13 07:50:00 | AAPL | Stock | 19.1271 | 19.1443 | 19.125 | 19.1443 | 46060.0 |
| 2014-01-13 07:53:00 | AAPL | Stock | 19.1454 | 19.1454 | 19.1454 | 19.1454 | 2800.0 |
| 2014-01-13 07:54:00 | AAPL | Stock | 19.1493 | 19.1554 | 19.1493 | 19.1554 | 10500.0 |
| 2014-01-13 07:55:00 | AAPL | Stock | 19.1539 | 19.1539 | 19.1518 | 19.1518 | 22400.0 |
| 2014-01-13 07:56:00 | AAPL | Stock | 19.1454 | 19.1454 | 19.1429 | 19.1429 | 63168.0 |
| 2014-01-13 08:00:00 | AAPL | Stock | 19.1286 | 19.1554 | 19.0821 | 19.1268 | 228088.0 |
| 2014-01-13 08:01:00 | AAPL | Stock | 19.1268 | 19.1268 | 19.125 | 19.125 | 38332.0 |
| 2014-01-13 08:03:00 | AAPL | Stock | 19.1196 | 19.1286 | 19.1164 | 19.1286 | 50120.0 |
| 2014-01-13 08:04:00 | AAPL | Stock | 19.1268 | 19.1296 | 19.1264 | 19.1264 | 33880.0 |
| 2014-01-13 08:05:00 | AAPL | Stock | 19.1186 | 19.13 | 19.1186 | 19.1232 | 20216.0 |
| 2014-01-13 08:06:00 | AAPL | Stock | 19.1186 | 19.1286 | 19.1179 | 19.1179 | 46172.0 |
| 2014-01-13 08:07:00 | AAPL | Stock | 19.1111 | 19.1161 | 19.0993 | 19.1071 | 117068.0 |
| 2014-01-13 08:08:00 | AAPL | Stock | 19.1089 | 19.1089 | 19.1071 | 19.1071 | 47600.0 |
| 2014-01-13 08:09:00 | AAPL | Stock | 19.0993 | 19.0993 | 19.095 | 19.095 | 19600.0 |
| 2014-01-13 08:10:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0693 | 19.0693 | 186340.0 |
| 2014-01-13 08:11:00 | AAPL | Stock | 19.0693 | 19.0693 | 19.0539 | 19.0686 | 36596.0 |
| 2014-01-13 08:12:00 | AAPL | Stock | 19.0625 | 19.0625 | 19.0625 | 19.0625 | 2800.0 |
> showing 50 of 1,097,619 rows — these rows as CSV