PREVIEW / stock_1min / 2014-04-30
file: by_date/stock_1min/2014/2014-04-30.parquet size: 14.8 MB rows: 1,080,077 symbols: 2,883
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-04-30 04:39:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2014-04-30 04:43:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2014-04-30 05:32:00 | AAPL | Stock | 21.0857 | 21.0857 | 21.0857 | 21.0857 | 12880.0 |
| 2014-04-30 05:45:00 | AAPL | Stock | 21.0829 | 21.0829 | 21.0829 | 21.0829 | 14000.0 |
| 2014-04-30 05:53:00 | AAPL | Stock | 21.0721 | 21.0721 | 21.0721 | 21.0721 | 2800.0 |
| 2014-04-30 06:02:00 | AAPL | Stock | 21.0736 | 21.0736 | 21.0736 | 21.0736 | 2800.0 |
| 2014-04-30 06:18:00 | AAPL | Stock | 21.1036 | 21.1071 | 21.1036 | 21.1071 | 25760.0 |
| 2014-04-30 06:19:00 | AAPL | Stock | 21.1071 | 21.1071 | 21.1071 | 21.1071 | 5908.0 |
| 2014-04-30 06:40:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 3220.0 |
| 2014-04-30 06:48:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 8204.0 |
| 2014-04-30 06:49:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 2800.0 |
| 2014-04-30 06:51:00 | AAPL | Stock | 21.1286 | 21.1286 | 21.1286 | 21.1286 | 2800.0 |
| 2014-04-30 07:01:00 | AAPL | Stock | 21.1246 | 21.125 | 21.1246 | 21.125 | 21000.0 |
| 2014-04-30 07:02:00 | AAPL | Stock | 21.1282 | 21.1282 | 21.125 | 21.125 | 11200.0 |
| 2014-04-30 07:03:00 | AAPL | Stock | 21.125 | 21.125 | 21.1186 | 21.1186 | 24444.0 |
| 2014-04-30 07:04:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 7672.0 |
| 2014-04-30 07:09:00 | AAPL | Stock | 21.115 | 21.115 | 21.115 | 21.115 | 3920.0 |
| 2014-04-30 07:16:00 | AAPL | Stock | 21.1071 | 21.1071 | 21.1071 | 21.1071 | 19012.0 |
| 2014-04-30 07:17:00 | AAPL | Stock | 21.0946 | 21.0946 | 21.0946 | 21.0946 | 8400.0 |
| 2014-04-30 07:18:00 | AAPL | Stock | 21.1068 | 21.1089 | 21.1068 | 21.1089 | 28000.0 |
| 2014-04-30 07:23:00 | AAPL | Stock | 21.1236 | 21.1243 | 21.1236 | 21.1243 | 30800.0 |
| 2014-04-30 07:24:00 | AAPL | Stock | 21.1279 | 21.1339 | 21.1218 | 21.1218 | 8400.0 |
| 2014-04-30 07:30:00 | AAPL | Stock | 21.1425 | 21.1525 | 21.1425 | 21.1496 | 32760.0 |
| 2014-04-30 07:31:00 | AAPL | Stock | 21.1532 | 21.1536 | 21.1532 | 21.1536 | 22036.0 |
| 2014-04-30 07:34:00 | AAPL | Stock | 21.1461 | 21.1461 | 21.1461 | 21.1461 | 2800.0 |
| 2014-04-30 07:36:00 | AAPL | Stock | 21.1464 | 21.1571 | 21.1432 | 21.1571 | 82740.0 |
| 2014-04-30 07:37:00 | AAPL | Stock | 21.16 | 21.1786 | 21.16 | 21.1786 | 36400.0 |
| 2014-04-30 07:39:00 | AAPL | Stock | 21.2007 | 21.2143 | 21.1964 | 21.2143 | 155204.0 |
| 2014-04-30 07:40:00 | AAPL | Stock | 21.2093 | 21.2093 | 21.1982 | 21.1982 | 8400.0 |
| 2014-04-30 07:41:00 | AAPL | Stock | 21.1893 | 21.1893 | 21.1893 | 21.1893 | 13944.0 |
| 2014-04-30 07:42:00 | AAPL | Stock | 21.1893 | 21.1893 | 21.1821 | 21.1821 | 14056.0 |
| 2014-04-30 07:43:00 | AAPL | Stock | 21.1846 | 21.1964 | 21.1846 | 21.1964 | 63672.0 |
| 2014-04-30 07:49:00 | AAPL | Stock | 21.1921 | 21.1964 | 21.1921 | 21.1964 | 44240.0 |
| 2014-04-30 07:50:00 | AAPL | Stock | 21.1964 | 21.1968 | 21.1961 | 21.1968 | 106428.0 |
| 2014-04-30 07:53:00 | AAPL | Stock | 21.1954 | 21.1954 | 21.1954 | 21.1954 | 2800.0 |
| 2014-04-30 07:55:00 | AAPL | Stock | 21.1961 | 21.2086 | 21.1961 | 21.2086 | 39200.0 |
| 2014-04-30 07:56:00 | AAPL | Stock | 21.2054 | 21.2221 | 21.2054 | 21.2168 | 103656.0 |
| 2014-04-30 07:57:00 | AAPL | Stock | 21.2268 | 21.2343 | 21.2164 | 21.2164 | 25200.0 |
| 2014-04-30 07:59:00 | AAPL | Stock | 21.2164 | 21.2282 | 21.2143 | 21.2282 | 23016.0 |
| 2014-04-30 08:00:00 | AAPL | Stock | 21.2146 | 21.2146 | 21.1829 | 21.2054 | 97580.0 |
| 2014-04-30 08:01:00 | AAPL | Stock | 21.1861 | 21.1936 | 21.1825 | 21.1825 | 25676.0 |
| 2014-04-30 08:02:00 | AAPL | Stock | 21.1696 | 21.1782 | 21.1593 | 21.175 | 116200.0 |
| 2014-04-30 08:03:00 | AAPL | Stock | 21.1664 | 21.1764 | 21.16 | 21.165 | 53200.0 |
| 2014-04-30 08:04:00 | AAPL | Stock | 21.1604 | 21.1607 | 21.1604 | 21.1607 | 5600.0 |
| 2014-04-30 08:05:00 | AAPL | Stock | 21.1621 | 21.1621 | 21.1621 | 21.1621 | 5600.0 |
| 2014-04-30 08:07:00 | AAPL | Stock | 21.1743 | 21.1786 | 21.1743 | 21.1786 | 12600.0 |
| 2014-04-30 08:08:00 | AAPL | Stock | 21.1743 | 21.1771 | 21.1739 | 21.1764 | 47600.0 |
| 2014-04-30 08:10:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 28000.0 |
| 2014-04-30 08:11:00 | AAPL | Stock | 21.18 | 21.1807 | 21.1696 | 21.1807 | 62412.0 |
| 2014-04-30 08:12:00 | AAPL | Stock | 21.1782 | 21.1786 | 21.1782 | 21.1786 | 19600.0 |
> showing 50 of 1,080,077 rows — these rows as CSV