PREVIEW / stock_1min / 2011-09-19
file: by_date/stock_1min/2011/2011-09-19.parquet size: 13.0 MB rows: 984,032 symbols: 2,833
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-09-19 04:00:00 | AAPL | Stock | 14.1786 | 14.1786 | 14.1786 | 14.1786 | 5600.0 |
| 2011-09-19 04:03:00 | AAPL | Stock | 14.1254 | 14.1254 | 14.1254 | 14.1254 | 2800.0 |
| 2011-09-19 04:14:00 | AAPL | Stock | 14.1454 | 14.1454 | 14.145 | 14.145 | 5600.0 |
| 2011-09-19 04:15:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 2800.0 |
| 2011-09-19 04:21:00 | AAPL | Stock | 14.1493 | 14.1493 | 14.1421 | 14.1421 | 5600.0 |
| 2011-09-19 04:25:00 | AAPL | Stock | 14.1432 | 14.1432 | 14.1432 | 14.1432 | 2800.0 |
| 2011-09-19 04:28:00 | AAPL | Stock | 14.1418 | 14.1418 | 14.1418 | 14.1418 | 2800.0 |
| 2011-09-19 04:29:00 | AAPL | Stock | 14.1414 | 14.1414 | 14.1414 | 14.1414 | 2800.0 |
| 2011-09-19 04:37:00 | AAPL | Stock | 14.1593 | 14.1596 | 14.1593 | 14.1596 | 5600.0 |
| 2011-09-19 04:38:00 | AAPL | Stock | 14.1489 | 14.1489 | 14.1393 | 14.1393 | 19600.0 |
| 2011-09-19 04:39:00 | AAPL | Stock | 14.1393 | 14.1393 | 14.1339 | 14.1339 | 8400.0 |
| 2011-09-19 04:58:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 2800.0 |
| 2011-09-19 05:05:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 5600.0 |
| 2011-09-19 05:08:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 5040.0 |
| 2011-09-19 05:10:00 | AAPL | Stock | 14.1214 | 14.1218 | 14.1214 | 14.1218 | 8400.0 |
| 2011-09-19 05:14:00 | AAPL | Stock | 14.1111 | 14.1125 | 14.1111 | 14.1125 | 33600.0 |
| 2011-09-19 05:17:00 | AAPL | Stock | 14.1204 | 14.1204 | 14.1204 | 14.1204 | 2800.0 |
| 2011-09-19 05:19:00 | AAPL | Stock | 14.1264 | 14.1264 | 14.1264 | 14.1264 | 2800.0 |
| 2011-09-19 05:20:00 | AAPL | Stock | 14.1554 | 14.1554 | 14.1554 | 14.1554 | 2800.0 |
| 2011-09-19 05:28:00 | AAPL | Stock | 14.1229 | 14.1229 | 14.1229 | 14.1229 | 2800.0 |
| 2011-09-19 06:02:00 | AAPL | Stock | 14.1289 | 14.1289 | 14.1289 | 14.1289 | 2800.0 |
| 2011-09-19 06:07:00 | AAPL | Stock | 14.1311 | 14.1314 | 14.1286 | 14.1314 | 11060.0 |
| 2011-09-19 06:08:00 | AAPL | Stock | 14.1321 | 14.1321 | 14.1321 | 14.1321 | 2800.0 |
| 2011-09-19 06:14:00 | AAPL | Stock | 14.1418 | 14.1418 | 14.1418 | 14.1418 | 2800.0 |
| 2011-09-19 06:21:00 | AAPL | Stock | 14.1464 | 14.1464 | 14.1429 | 14.1429 | 16800.0 |
| 2011-09-19 06:41:00 | AAPL | Stock | 14.1404 | 14.1454 | 14.1404 | 14.1454 | 5600.0 |
| 2011-09-19 06:42:00 | AAPL | Stock | 14.1446 | 14.1461 | 14.1439 | 14.1446 | 11200.0 |
| 2011-09-19 06:43:00 | AAPL | Stock | 14.1446 | 14.1446 | 14.1432 | 14.1432 | 5600.0 |
| 2011-09-19 06:44:00 | AAPL | Stock | 14.1443 | 14.1443 | 14.1443 | 14.1443 | 2800.0 |
| 2011-09-19 06:45:00 | AAPL | Stock | 14.1471 | 14.1471 | 14.1471 | 14.1471 | 2800.0 |
| 2011-09-19 06:48:00 | AAPL | Stock | 14.15 | 14.15 | 14.15 | 14.15 | 65800.0 |
| 2011-09-19 06:50:00 | AAPL | Stock | 14.1514 | 14.1514 | 14.1514 | 14.1514 | 2800.0 |
| 2011-09-19 06:55:00 | AAPL | Stock | 14.15 | 14.15 | 14.15 | 14.15 | 2800.0 |
| 2011-09-19 06:56:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1411 | 14.1411 | 8400.0 |
| 2011-09-19 06:58:00 | AAPL | Stock | 14.1411 | 14.1411 | 14.1411 | 14.1411 | 2800.0 |
| 2011-09-19 07:00:00 | AAPL | Stock | 14.1454 | 14.1454 | 14.1454 | 14.1454 | 2800.0 |
| 2011-09-19 07:01:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1411 | 14.1429 | 16492.0 |
| 2011-09-19 07:02:00 | AAPL | Stock | 14.1446 | 14.1518 | 14.1446 | 14.1514 | 28000.0 |
| 2011-09-19 07:03:00 | AAPL | Stock | 14.1468 | 14.1607 | 14.1468 | 14.1607 | 16800.0 |
| 2011-09-19 07:05:00 | AAPL | Stock | 14.1575 | 14.1575 | 14.1575 | 14.1575 | 2800.0 |
| 2011-09-19 07:06:00 | AAPL | Stock | 14.1593 | 14.16 | 14.1593 | 14.16 | 6440.0 |
| 2011-09-19 07:07:00 | AAPL | Stock | 14.1754 | 14.1796 | 14.1754 | 14.1796 | 50400.0 |
| 2011-09-19 07:10:00 | AAPL | Stock | 14.18 | 14.1857 | 14.18 | 14.1857 | 5600.0 |
| 2011-09-19 07:11:00 | AAPL | Stock | 14.1857 | 14.1857 | 14.1857 | 14.1857 | 2800.0 |
| 2011-09-19 07:12:00 | AAPL | Stock | 14.1843 | 14.1904 | 14.1836 | 14.1904 | 19600.0 |
| 2011-09-19 07:13:00 | AAPL | Stock | 14.2029 | 14.2029 | 14.2 | 14.2014 | 17360.0 |
| 2011-09-19 07:15:00 | AAPL | Stock | 14.195 | 14.1957 | 14.1786 | 14.1786 | 81816.0 |
| 2011-09-19 07:16:00 | AAPL | Stock | 14.1961 | 14.1964 | 14.1961 | 14.1964 | 14000.0 |
| 2011-09-19 07:17:00 | AAPL | Stock | 14.1811 | 14.1846 | 14.1807 | 14.1807 | 19908.0 |
| 2011-09-19 07:18:00 | AAPL | Stock | 14.1804 | 14.1804 | 14.1804 | 14.1804 | 2800.0 |
> showing 50 of 984,032 rows — these rows as CSV