PREVIEW / stock_1min / 2013-05-06
file: by_date/stock_1min/2013/2013-05-06.parquet size: 13.0 MB rows: 958,437 symbols: 2,817
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-05-06 04:10:00 | AAPL | Stock | 16.1071 | 16.1071 | 16.1071 | 16.1071 | 2800.0 |
| 2013-05-06 04:23:00 | AAPL | Stock | 16.1261 | 16.1261 | 16.125 | 16.125 | 5600.0 |
| 2013-05-06 04:34:00 | AAPL | Stock | 16.1289 | 16.1289 | 16.1289 | 16.1289 | 2800.0 |
| 2013-05-06 04:35:00 | AAPL | Stock | 16.1386 | 16.1386 | 16.1229 | 16.1229 | 5600.0 |
| 2013-05-06 04:37:00 | AAPL | Stock | 16.1225 | 16.1225 | 16.1225 | 16.1225 | 2800.0 |
| 2013-05-06 04:52:00 | AAPL | Stock | 16.1354 | 16.1354 | 16.1354 | 16.1354 | 2800.0 |
| 2013-05-06 05:14:00 | AAPL | Stock | 16.1375 | 16.1375 | 16.1375 | 16.1375 | 2800.0 |
| 2013-05-06 05:55:00 | AAPL | Stock | 16.105 | 16.105 | 16.105 | 16.105 | 2800.0 |
| 2013-05-06 06:17:00 | AAPL | Stock | 16.1071 | 16.1161 | 16.1071 | 16.1161 | 16800.0 |
| 2013-05-06 06:18:00 | AAPL | Stock | 16.1161 | 16.1161 | 16.1161 | 16.1161 | 5264.0 |
| 2013-05-06 07:04:00 | AAPL | Stock | 16.1143 | 16.1143 | 16.1143 | 16.1143 | 2800.0 |
| 2013-05-06 07:06:00 | AAPL | Stock | 16.1161 | 16.1161 | 16.1161 | 16.1161 | 5600.0 |
| 2013-05-06 07:10:00 | AAPL | Stock | 16.1289 | 16.1289 | 16.1232 | 16.125 | 25200.0 |
| 2013-05-06 07:11:00 | AAPL | Stock | 16.125 | 16.1429 | 16.125 | 16.1429 | 14000.0 |
| 2013-05-06 07:12:00 | AAPL | Stock | 16.145 | 16.1646 | 16.145 | 16.1607 | 11956.0 |
| 2013-05-06 07:13:00 | AAPL | Stock | 16.1607 | 16.1607 | 16.1607 | 16.1607 | 2800.0 |
| 2013-05-06 07:15:00 | AAPL | Stock | 16.1525 | 16.1525 | 16.1471 | 16.1471 | 11200.0 |
| 2013-05-06 07:16:00 | AAPL | Stock | 16.1582 | 16.1607 | 16.1536 | 16.1536 | 44240.0 |
| 2013-05-06 07:17:00 | AAPL | Stock | 16.1543 | 16.1543 | 16.1479 | 16.1479 | 12656.0 |
| 2013-05-06 07:18:00 | AAPL | Stock | 16.1571 | 16.1571 | 16.1354 | 16.1354 | 8400.0 |
| 2013-05-06 07:21:00 | AAPL | Stock | 16.1343 | 16.1343 | 16.1318 | 16.1318 | 7000.0 |
| 2013-05-06 07:27:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1418 | 16.1421 | 11200.0 |
| 2013-05-06 07:28:00 | AAPL | Stock | 16.1446 | 16.1446 | 16.1446 | 16.1446 | 5600.0 |
| 2013-05-06 07:29:00 | AAPL | Stock | 16.15 | 16.1554 | 16.15 | 16.1518 | 21700.0 |
| 2013-05-06 07:30:00 | AAPL | Stock | 16.1518 | 16.1536 | 16.1518 | 16.1536 | 8400.0 |
| 2013-05-06 07:33:00 | AAPL | Stock | 16.1429 | 16.1446 | 16.1429 | 16.1429 | 14000.0 |
| 2013-05-06 07:35:00 | AAPL | Stock | 16.1396 | 16.1518 | 16.1357 | 16.1357 | 81200.0 |
| 2013-05-06 07:36:00 | AAPL | Stock | 16.1486 | 16.1536 | 16.1411 | 16.1482 | 25480.0 |
| 2013-05-06 07:37:00 | AAPL | Stock | 16.1536 | 16.1536 | 16.1536 | 16.1536 | 2800.0 |
| 2013-05-06 07:38:00 | AAPL | Stock | 16.1536 | 16.1536 | 16.1536 | 16.1536 | 2800.0 |
| 2013-05-06 07:39:00 | AAPL | Stock | 16.1471 | 16.1471 | 16.1464 | 16.1464 | 5600.0 |
| 2013-05-06 07:41:00 | AAPL | Stock | 16.1482 | 16.1482 | 16.1471 | 16.1475 | 16800.0 |
| 2013-05-06 07:42:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 2800.0 |
| 2013-05-06 07:44:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1418 | 16.1429 | 31220.0 |
| 2013-05-06 07:45:00 | AAPL | Stock | 16.1432 | 16.1432 | 16.1432 | 16.1432 | 5600.0 |
| 2013-05-06 07:46:00 | AAPL | Stock | 16.1454 | 16.1454 | 16.1429 | 16.1429 | 47600.0 |
| 2013-05-06 07:47:00 | AAPL | Stock | 16.1518 | 16.1518 | 16.1518 | 16.1518 | 2800.0 |
| 2013-05-06 07:49:00 | AAPL | Stock | 16.1457 | 16.1457 | 16.1457 | 16.1457 | 2800.0 |
| 2013-05-06 07:50:00 | AAPL | Stock | 16.1518 | 16.1539 | 16.1454 | 16.1539 | 14560.0 |
| 2013-05-06 07:51:00 | AAPL | Stock | 16.1554 | 16.1571 | 16.1554 | 16.1571 | 11200.0 |
| 2013-05-06 07:52:00 | AAPL | Stock | 16.1696 | 16.1696 | 16.1696 | 16.1696 | 5600.0 |
| 2013-05-06 07:53:00 | AAPL | Stock | 16.1696 | 16.1696 | 16.1607 | 16.1607 | 22400.0 |
| 2013-05-06 07:55:00 | AAPL | Stock | 16.1746 | 16.1746 | 16.1746 | 16.1746 | 2800.0 |
| 2013-05-06 07:56:00 | AAPL | Stock | 16.1768 | 16.1843 | 16.1768 | 16.1843 | 23800.0 |
| 2013-05-06 07:57:00 | AAPL | Stock | 16.1904 | 16.1968 | 16.1904 | 16.1968 | 44772.0 |
| 2013-05-06 07:58:00 | AAPL | Stock | 16.1982 | 16.21 | 16.1982 | 16.1982 | 11200.0 |
| 2013-05-06 07:59:00 | AAPL | Stock | 16.2025 | 16.2036 | 16.1946 | 16.1964 | 53732.0 |
| 2013-05-06 08:00:00 | AAPL | Stock | 16.1914 | 16.1968 | 16.1246 | 16.1836 | 131712.0 |
| 2013-05-06 08:01:00 | AAPL | Stock | 16.1893 | 16.2061 | 16.1893 | 16.2061 | 68432.0 |
| 2013-05-06 08:02:00 | AAPL | Stock | 16.205 | 16.2279 | 16.2036 | 16.2243 | 134344.0 |
> showing 50 of 958,437 rows — these rows as CSV