PREVIEW / stock_1min / 2013-06-04
file: by_date/stock_1min/2013/2013-06-04.parquet size: 14.1 MB rows: 1,037,235 symbols: 2,838
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-06-04 04:00:00 | AAPL | Stock | 16.1229 | 16.1229 | 16.1229 | 16.1229 | 11200.0 |
| 2013-06-04 04:13:00 | AAPL | Stock | 16.1268 | 16.1268 | 16.1268 | 16.1268 | 4200.0 |
| 2013-06-04 04:14:00 | AAPL | Stock | 16.125 | 16.125 | 16.125 | 16.125 | 2800.0 |
| 2013-06-04 04:17:00 | AAPL | Stock | 16.125 | 16.125 | 16.125 | 16.125 | 2800.0 |
| 2013-06-04 06:52:00 | AAPL | Stock | 16.1071 | 16.1071 | 16.1071 | 16.1071 | 2800.0 |
| 2013-06-04 06:56:00 | AAPL | Stock | 16.0982 | 16.1004 | 16.0982 | 16.1004 | 5600.0 |
| 2013-06-04 07:03:00 | AAPL | Stock | 16.1079 | 16.1079 | 16.1071 | 16.1071 | 8400.0 |
| 2013-06-04 07:06:00 | AAPL | Stock | 16.1125 | 16.1125 | 16.1125 | 16.1125 | 5600.0 |
| 2013-06-04 07:08:00 | AAPL | Stock | 16.1161 | 16.1161 | 16.1161 | 16.1161 | 2800.0 |
| 2013-06-04 07:09:00 | AAPL | Stock | 16.1207 | 16.125 | 16.1207 | 16.125 | 8400.0 |
| 2013-06-04 07:10:00 | AAPL | Stock | 16.125 | 16.1429 | 16.125 | 16.1429 | 16800.0 |
| 2013-06-04 07:12:00 | AAPL | Stock | 16.1393 | 16.1396 | 16.1357 | 16.1396 | 19600.0 |
| 2013-06-04 07:13:00 | AAPL | Stock | 16.1396 | 16.1396 | 16.1304 | 16.1304 | 22400.0 |
| 2013-06-04 07:16:00 | AAPL | Stock | 16.1436 | 16.1529 | 16.1436 | 16.1529 | 14000.0 |
| 2013-06-04 07:17:00 | AAPL | Stock | 16.1529 | 16.1529 | 16.1429 | 16.1429 | 8400.0 |
| 2013-06-04 07:18:00 | AAPL | Stock | 16.1357 | 16.1439 | 16.1339 | 16.1429 | 16800.0 |
| 2013-06-04 07:19:00 | AAPL | Stock | 16.1436 | 16.1436 | 16.1429 | 16.1429 | 9800.0 |
| 2013-06-04 07:20:00 | AAPL | Stock | 16.1518 | 16.1529 | 16.1518 | 16.1529 | 14000.0 |
| 2013-06-04 07:21:00 | AAPL | Stock | 16.1529 | 16.1714 | 16.1529 | 16.1575 | 87780.0 |
| 2013-06-04 07:22:00 | AAPL | Stock | 16.1668 | 16.1668 | 16.1636 | 16.1636 | 8344.0 |
| 2013-06-04 07:23:00 | AAPL | Stock | 16.1639 | 16.1639 | 16.1611 | 16.1611 | 11144.0 |
| 2013-06-04 07:24:00 | AAPL | Stock | 16.1611 | 16.1696 | 16.1593 | 16.1607 | 52080.0 |
| 2013-06-04 07:25:00 | AAPL | Stock | 16.1721 | 16.1721 | 16.1696 | 16.1696 | 7280.0 |
| 2013-06-04 07:26:00 | AAPL | Stock | 16.1696 | 16.1786 | 16.1696 | 16.1786 | 8400.0 |
| 2013-06-04 07:27:00 | AAPL | Stock | 16.1875 | 16.1907 | 16.1771 | 16.1786 | 35560.0 |
| 2013-06-04 07:29:00 | AAPL | Stock | 16.1739 | 16.1764 | 16.1739 | 16.1764 | 8400.0 |
| 2013-06-04 07:30:00 | AAPL | Stock | 16.1632 | 16.1693 | 16.1607 | 16.1693 | 14000.0 |
| 2013-06-04 07:31:00 | AAPL | Stock | 16.1675 | 16.1893 | 16.1675 | 16.1839 | 75040.0 |
| 2013-06-04 07:32:00 | AAPL | Stock | 16.1875 | 16.1893 | 16.1682 | 16.1682 | 86800.0 |
| 2013-06-04 07:33:00 | AAPL | Stock | 16.1779 | 16.1875 | 16.1779 | 16.1875 | 39060.0 |
| 2013-06-04 07:34:00 | AAPL | Stock | 16.1904 | 16.1904 | 16.1904 | 16.1904 | 2800.0 |
| 2013-06-04 07:35:00 | AAPL | Stock | 16.1818 | 16.1918 | 16.1818 | 16.1918 | 6300.0 |
| 2013-06-04 07:36:00 | AAPL | Stock | 16.1864 | 16.1864 | 16.1864 | 16.1864 | 2800.0 |
| 2013-06-04 07:37:00 | AAPL | Stock | 16.1861 | 16.1864 | 16.1807 | 16.1864 | 21420.0 |
| 2013-06-04 07:38:00 | AAPL | Stock | 16.1864 | 16.1864 | 16.1864 | 16.1864 | 5600.0 |
| 2013-06-04 07:39:00 | AAPL | Stock | 16.1736 | 16.1736 | 16.1721 | 16.1721 | 5600.0 |
| 2013-06-04 07:40:00 | AAPL | Stock | 16.1704 | 16.1704 | 16.1696 | 16.1696 | 11200.0 |
| 2013-06-04 07:41:00 | AAPL | Stock | 16.1696 | 16.1696 | 16.1696 | 16.1696 | 5600.0 |
| 2013-06-04 07:42:00 | AAPL | Stock | 16.1696 | 16.1696 | 16.1696 | 16.1696 | 2800.0 |
| 2013-06-04 07:49:00 | AAPL | Stock | 16.1782 | 16.1782 | 16.1782 | 16.1782 | 8400.0 |
| 2013-06-04 07:52:00 | AAPL | Stock | 16.1661 | 16.1661 | 16.1604 | 16.1604 | 14000.0 |
| 2013-06-04 07:56:00 | AAPL | Stock | 16.1693 | 16.1696 | 16.1693 | 16.1696 | 11200.0 |
| 2013-06-04 07:58:00 | AAPL | Stock | 16.1639 | 16.1711 | 16.1639 | 16.1711 | 14000.0 |
| 2013-06-04 07:59:00 | AAPL | Stock | 16.1725 | 16.1786 | 16.1725 | 16.1786 | 22400.0 |
| 2013-06-04 08:00:00 | AAPL | Stock | 16.175 | 16.1929 | 16.1529 | 16.1807 | 86660.0 |
| 2013-06-04 08:01:00 | AAPL | Stock | 16.1786 | 16.1918 | 16.0714 | 16.1857 | 75768.0 |
| 2013-06-04 08:02:00 | AAPL | Stock | 16.1857 | 16.1857 | 16.1789 | 16.1789 | 33600.0 |
| 2013-06-04 08:03:00 | AAPL | Stock | 16.1839 | 16.1839 | 16.1786 | 16.1789 | 88844.0 |
| 2013-06-04 08:04:00 | AAPL | Stock | 16.1786 | 16.1893 | 16.1679 | 16.1893 | 191072.0 |
| 2013-06-04 08:05:00 | AAPL | Stock | 16.1804 | 16.2029 | 16.1789 | 16.1929 | 142520.0 |
> showing 50 of 1,037,235 rows — these rows as CSV