PREVIEW / stock_1min / 2013-03-07
file: by_date/stock_1min/2013/2013-03-07.parquet size: 13.2 MB rows: 975,193 symbols: 2,828
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-03-07 05:57:00 | AAPL | Stock | 15.165 | 15.165 | 15.1643 | 15.1643 | 11676.0 |
| 2013-03-07 07:03:00 | AAPL | Stock | 15.1786 | 15.1786 | 15.1786 | 15.1786 | 2800.0 |
| 2013-03-07 07:10:00 | AAPL | Stock | 15.1857 | 15.1893 | 15.1857 | 15.1893 | 14000.0 |
| 2013-03-07 07:11:00 | AAPL | Stock | 15.1786 | 15.1786 | 15.1786 | 15.1786 | 2800.0 |
| 2013-03-07 07:14:00 | AAPL | Stock | 15.1839 | 15.1839 | 15.1607 | 15.1607 | 15400.0 |
| 2013-03-07 07:16:00 | AAPL | Stock | 15.1607 | 15.1607 | 15.1607 | 15.1607 | 11452.0 |
| 2013-03-07 07:17:00 | AAPL | Stock | 15.1564 | 15.1564 | 15.1564 | 15.1564 | 5600.0 |
| 2013-03-07 07:20:00 | AAPL | Stock | 15.1664 | 15.1664 | 15.1554 | 15.1554 | 16800.0 |
| 2013-03-07 07:23:00 | AAPL | Stock | 15.1525 | 15.1525 | 15.1325 | 15.1325 | 14000.0 |
| 2013-03-07 07:24:00 | AAPL | Stock | 15.1382 | 15.1429 | 15.1375 | 15.1429 | 20720.0 |
| 2013-03-07 07:25:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2013-03-07 07:26:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 14000.0 |
| 2013-03-07 07:32:00 | AAPL | Stock | 15.1525 | 15.1525 | 15.1525 | 15.1525 | 13076.0 |
| 2013-03-07 07:33:00 | AAPL | Stock | 15.1571 | 15.1571 | 15.1571 | 15.1571 | 5600.0 |
| 2013-03-07 07:37:00 | AAPL | Stock | 15.1661 | 15.1661 | 15.1571 | 15.1571 | 20244.0 |
| 2013-03-07 07:38:00 | AAPL | Stock | 15.1607 | 15.1611 | 15.1607 | 15.1607 | 8876.0 |
| 2013-03-07 07:39:00 | AAPL | Stock | 15.15 | 15.15 | 15.1429 | 15.1429 | 18648.0 |
| 2013-03-07 07:44:00 | AAPL | Stock | 15.1607 | 15.1611 | 15.1607 | 15.1607 | 14000.0 |
| 2013-03-07 07:48:00 | AAPL | Stock | 15.1571 | 15.1571 | 15.1571 | 15.1571 | 5600.0 |
| 2013-03-07 07:55:00 | AAPL | Stock | 15.1554 | 15.1554 | 15.1429 | 15.1518 | 33600.0 |
| 2013-03-07 07:56:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1429 | 15.1429 | 26264.0 |
| 2013-03-07 07:57:00 | AAPL | Stock | 15.1429 | 15.1446 | 15.1429 | 15.1429 | 16800.0 |
| 2013-03-07 08:00:00 | AAPL | Stock | 15.1607 | 15.2143 | 15.1429 | 15.145 | 203840.0 |
| 2013-03-07 08:01:00 | AAPL | Stock | 15.1518 | 15.1786 | 15.1429 | 15.1625 | 95200.0 |
| 2013-03-07 08:02:00 | AAPL | Stock | 15.1575 | 15.1575 | 15.1564 | 15.1564 | 5600.0 |
| 2013-03-07 08:03:00 | AAPL | Stock | 15.1607 | 15.1643 | 15.16 | 15.1639 | 30800.0 |
| 2013-03-07 08:04:00 | AAPL | Stock | 15.1632 | 15.1668 | 15.1632 | 15.1668 | 15008.0 |
| 2013-03-07 08:05:00 | AAPL | Stock | 15.1679 | 15.1714 | 15.1679 | 15.1714 | 13412.0 |
| 2013-03-07 08:06:00 | AAPL | Stock | 15.1611 | 15.1611 | 15.1611 | 15.1611 | 2800.0 |
| 2013-03-07 08:07:00 | AAPL | Stock | 15.1607 | 15.1607 | 15.1607 | 15.1607 | 3360.0 |
| 2013-03-07 08:08:00 | AAPL | Stock | 15.1614 | 15.1614 | 15.1518 | 15.1518 | 35280.0 |
| 2013-03-07 08:11:00 | AAPL | Stock | 15.1536 | 15.1643 | 15.1536 | 15.1568 | 25200.0 |
| 2013-03-07 08:13:00 | AAPL | Stock | 15.1589 | 15.1661 | 15.1561 | 15.1561 | 25060.0 |
| 2013-03-07 08:15:00 | AAPL | Stock | 15.1568 | 15.1568 | 15.1568 | 15.1568 | 10640.0 |
| 2013-03-07 08:16:00 | AAPL | Stock | 15.1607 | 15.1607 | 15.1521 | 15.1568 | 14000.0 |
| 2013-03-07 08:17:00 | AAPL | Stock | 15.1568 | 15.1625 | 15.1568 | 15.1625 | 14000.0 |
| 2013-03-07 08:19:00 | AAPL | Stock | 15.1643 | 15.1643 | 15.1643 | 15.1643 | 8260.0 |
| 2013-03-07 08:20:00 | AAPL | Stock | 15.1643 | 15.1643 | 15.1607 | 15.1607 | 12880.0 |
| 2013-03-07 08:21:00 | AAPL | Stock | 15.1575 | 15.1618 | 15.1568 | 15.1618 | 16800.0 |
| 2013-03-07 08:23:00 | AAPL | Stock | 15.1611 | 15.1611 | 15.1611 | 15.1611 | 2800.0 |
| 2013-03-07 08:24:00 | AAPL | Stock | 15.1679 | 15.1693 | 15.1661 | 15.1661 | 13664.0 |
| 2013-03-07 08:25:00 | AAPL | Stock | 15.1661 | 15.1714 | 15.1661 | 15.1714 | 33600.0 |
| 2013-03-07 08:26:00 | AAPL | Stock | 15.1746 | 15.1786 | 15.1746 | 15.1786 | 28000.0 |
| 2013-03-07 08:27:00 | AAPL | Stock | 15.1811 | 15.1811 | 15.1746 | 15.1789 | 12908.0 |
| 2013-03-07 08:28:00 | AAPL | Stock | 15.1918 | 15.1918 | 15.1857 | 15.1857 | 8400.0 |
| 2013-03-07 08:29:00 | AAPL | Stock | 15.1925 | 15.1925 | 15.1821 | 15.1821 | 16800.0 |
| 2013-03-07 08:30:00 | AAPL | Stock | 15.1839 | 15.1839 | 15.1714 | 15.1714 | 22400.0 |
| 2013-03-07 08:31:00 | AAPL | Stock | 15.1779 | 15.1779 | 15.1779 | 15.1779 | 4732.0 |
| 2013-03-07 08:32:00 | AAPL | Stock | 15.1779 | 15.1782 | 15.1779 | 15.1782 | 7532.0 |
| 2013-03-07 08:33:00 | AAPL | Stock | 15.1732 | 15.1754 | 15.1661 | 15.1743 | 45080.0 |
> showing 50 of 975,193 rows — these rows as CSV