PREVIEW / stock_1min / 2014-05-14
file: by_date/stock_1min/2014/2014-05-14.parquet size: 14.3 MB rows: 1,064,232 symbols: 2,869
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-05-14 05:05:00 | AAPL | Stock | 21.1579 | 21.1582 | 21.1579 | 21.1582 | 14000.0 |
| 2014-05-14 05:18:00 | AAPL | Stock | 21.1446 | 21.1446 | 21.1446 | 21.1446 | 2800.0 |
| 2014-05-14 05:38:00 | AAPL | Stock | 21.1289 | 21.1289 | 21.1289 | 21.1289 | 5600.0 |
| 2014-05-14 05:46:00 | AAPL | Stock | 21.1257 | 21.1257 | 21.1257 | 21.1257 | 2800.0 |
| 2014-05-14 06:38:00 | AAPL | Stock | 21.1321 | 21.1321 | 21.1321 | 21.1321 | 2800.0 |
| 2014-05-14 06:52:00 | AAPL | Stock | 21.1339 | 21.1339 | 21.1339 | 21.1339 | 2800.0 |
| 2014-05-14 06:56:00 | AAPL | Stock | 21.1479 | 21.1479 | 21.1479 | 21.1479 | 14000.0 |
| 2014-05-14 07:16:00 | AAPL | Stock | 21.1425 | 21.1425 | 21.1425 | 21.1425 | 2800.0 |
| 2014-05-14 07:23:00 | AAPL | Stock | 21.1425 | 21.1425 | 21.1425 | 21.1425 | 2800.0 |
| 2014-05-14 07:29:00 | AAPL | Stock | 21.1418 | 21.1425 | 21.1418 | 21.1425 | 5600.0 |
| 2014-05-14 07:33:00 | AAPL | Stock | 21.135 | 21.135 | 21.1321 | 21.1321 | 11200.0 |
| 2014-05-14 07:43:00 | AAPL | Stock | 21.1375 | 21.1375 | 21.1375 | 21.1375 | 2800.0 |
| 2014-05-14 07:56:00 | AAPL | Stock | 21.1532 | 21.1532 | 21.1532 | 21.1532 | 2800.0 |
| 2014-05-14 08:00:00 | AAPL | Stock | 21.1439 | 21.15 | 21.1418 | 21.1429 | 28364.0 |
| 2014-05-14 08:07:00 | AAPL | Stock | 21.1411 | 21.1411 | 21.1411 | 21.1411 | 2800.0 |
| 2014-05-14 08:08:00 | AAPL | Stock | 21.1411 | 21.1429 | 21.1411 | 21.1429 | 6384.0 |
| 2014-05-14 08:11:00 | AAPL | Stock | 21.1357 | 21.1357 | 21.1357 | 21.1357 | 5600.0 |
| 2014-05-14 08:15:00 | AAPL | Stock | 21.1393 | 21.1393 | 21.135 | 21.1361 | 21112.0 |
| 2014-05-14 08:17:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1429 | 21.1429 | 2800.0 |
| 2014-05-14 08:21:00 | AAPL | Stock | 21.1511 | 21.1582 | 21.1504 | 21.1582 | 31780.0 |
| 2014-05-14 08:22:00 | AAPL | Stock | 21.165 | 21.1664 | 21.1507 | 21.1507 | 47432.0 |
| 2014-05-14 08:23:00 | AAPL | Stock | 21.1639 | 21.1639 | 21.1639 | 21.1639 | 2800.0 |
| 2014-05-14 08:24:00 | AAPL | Stock | 21.1586 | 21.1586 | 21.1586 | 21.1586 | 4620.0 |
| 2014-05-14 08:25:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1586 | 21.1586 | 18004.0 |
| 2014-05-14 08:28:00 | AAPL | Stock | 21.1529 | 21.1529 | 21.1507 | 21.1507 | 36512.0 |
| 2014-05-14 08:31:00 | AAPL | Stock | 21.1586 | 21.1586 | 21.1586 | 21.1586 | 2800.0 |
| 2014-05-14 08:33:00 | AAPL | Stock | 21.1529 | 21.1532 | 21.1529 | 21.1532 | 5600.0 |
| 2014-05-14 08:37:00 | AAPL | Stock | 21.155 | 21.155 | 21.155 | 21.155 | 2800.0 |
| 2014-05-14 08:45:00 | AAPL | Stock | 21.16 | 21.1604 | 21.16 | 21.1604 | 27888.0 |
| 2014-05-14 08:46:00 | AAPL | Stock | 21.1496 | 21.1496 | 21.1486 | 21.1486 | 8400.0 |
| 2014-05-14 08:51:00 | AAPL | Stock | 21.1571 | 21.1571 | 21.1571 | 21.1571 | 5600.0 |
| 2014-05-14 08:53:00 | AAPL | Stock | 21.1536 | 21.1536 | 21.1536 | 21.1536 | 2800.0 |
| 2014-05-14 08:56:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.16 | 21.1604 | 16800.0 |
| 2014-05-14 08:57:00 | AAPL | Stock | 21.1579 | 21.1579 | 21.1579 | 21.1579 | 3640.0 |
| 2014-05-14 08:59:00 | AAPL | Stock | 21.1571 | 21.1571 | 21.1571 | 21.1571 | 5600.0 |
| 2014-05-14 09:05:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1489 | 21.1489 | 7560.0 |
| 2014-05-14 09:06:00 | AAPL | Stock | 21.1493 | 21.1493 | 21.1489 | 21.1489 | 5600.0 |
| 2014-05-14 09:08:00 | AAPL | Stock | 21.1482 | 21.1521 | 21.1482 | 21.1521 | 8400.0 |
| 2014-05-14 09:09:00 | AAPL | Stock | 21.1536 | 21.1596 | 21.1536 | 21.1596 | 5880.0 |
| 2014-05-14 09:11:00 | AAPL | Stock | 21.1571 | 21.1643 | 21.1571 | 21.1643 | 8400.0 |
| 2014-05-14 09:23:00 | AAPL | Stock | 21.1632 | 21.1632 | 21.1625 | 21.1625 | 5600.0 |
| 2014-05-14 09:24:00 | AAPL | Stock | 21.1625 | 21.1625 | 21.1625 | 21.1625 | 2800.0 |
| 2014-05-14 09:25:00 | AAPL | Stock | 21.1571 | 21.1571 | 21.1536 | 21.1536 | 21980.0 |
| 2014-05-14 09:29:00 | AAPL | Stock | 21.1543 | 21.1621 | 21.1536 | 21.1621 | 16800.0 |
| 2014-05-14 09:30:00 | AAPL | Stock | 21.1571 | 21.1868 | 21.1496 | 21.1868 | 1832236.0 |
| 2014-05-14 09:31:00 | AAPL | Stock | 21.1868 | 21.195 | 21.1757 | 21.1836 | 707364.0 |
| 2014-05-14 09:32:00 | AAPL | Stock | 21.1832 | 21.1907 | 21.17 | 21.1907 | 511364.0 |
| 2014-05-14 09:33:00 | AAPL | Stock | 21.1818 | 21.2339 | 21.1818 | 21.2044 | 1379392.0 |
| 2014-05-14 09:34:00 | AAPL | Stock | 21.2021 | 21.2232 | 21.1896 | 21.1896 | 1070748.0 |
| 2014-05-14 09:35:00 | AAPL | Stock | 21.1936 | 21.2071 | 21.1864 | 21.2071 | 509096.0 |
> showing 50 of 1,064,232 rows — these rows as CSV