PREVIEW / stock_1min / 2014-02-12
file: by_date/stock_1min/2014/2014-02-12.parquet size: 14.6 MB rows: 1,064,895 symbols: 2,859
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-02-12 04:19:00 | AAPL | Stock | 19.1929 | 19.1929 | 19.1929 | 19.1929 | 5600.0 |
| 2014-02-12 05:02:00 | AAPL | Stock | 19.2107 | 19.2143 | 19.2107 | 19.2143 | 11200.0 |
| 2014-02-12 05:03:00 | AAPL | Stock | 19.2304 | 19.2304 | 19.2304 | 19.2304 | 25200.0 |
| 2014-02-12 05:06:00 | AAPL | Stock | 19.2271 | 19.2271 | 19.2271 | 19.2271 | 2800.0 |
| 2014-02-12 05:08:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1929 | 19.1929 | 13104.0 |
| 2014-02-12 05:09:00 | AAPL | Stock | 19.1929 | 19.1929 | 19.1896 | 19.1896 | 22400.0 |
| 2014-02-12 05:10:00 | AAPL | Stock | 19.2314 | 19.2314 | 19.2314 | 19.2314 | 8400.0 |
| 2014-02-12 05:23:00 | AAPL | Stock | 19.2304 | 19.2304 | 19.2304 | 19.2304 | 2800.0 |
| 2014-02-12 05:38:00 | AAPL | Stock | 19.2204 | 19.2204 | 19.2168 | 19.2168 | 5600.0 |
| 2014-02-12 05:42:00 | AAPL | Stock | 19.2057 | 19.2057 | 19.2057 | 19.2057 | 2800.0 |
| 2014-02-12 05:45:00 | AAPL | Stock | 19.2039 | 19.2039 | 19.2039 | 19.2039 | 2800.0 |
| 2014-02-12 05:56:00 | AAPL | Stock | 19.2057 | 19.2057 | 19.2057 | 19.2057 | 5600.0 |
| 2014-02-12 06:00:00 | AAPL | Stock | 19.2011 | 19.2011 | 19.2011 | 19.2011 | 5600.0 |
| 2014-02-12 06:24:00 | AAPL | Stock | 19.1811 | 19.1811 | 19.1768 | 19.1768 | 5600.0 |
| 2014-02-12 06:25:00 | AAPL | Stock | 19.1807 | 19.1811 | 19.1754 | 19.1754 | 11200.0 |
| 2014-02-12 06:54:00 | AAPL | Stock | 19.1754 | 19.1754 | 19.1754 | 19.1754 | 4200.0 |
| 2014-02-12 06:58:00 | AAPL | Stock | 19.1764 | 19.1764 | 19.1764 | 19.1764 | 4060.0 |
| 2014-02-12 07:04:00 | AAPL | Stock | 19.1393 | 19.1393 | 19.1393 | 19.1393 | 3220.0 |
| 2014-02-12 07:22:00 | AAPL | Stock | 19.1407 | 19.1407 | 19.1407 | 19.1407 | 2800.0 |
| 2014-02-12 07:23:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1429 | 19.1429 | 7000.0 |
| 2014-02-12 07:24:00 | AAPL | Stock | 19.1511 | 19.1511 | 19.1511 | 19.1511 | 2800.0 |
| 2014-02-12 07:34:00 | AAPL | Stock | 19.1679 | 19.1679 | 19.1679 | 19.1679 | 2800.0 |
| 2014-02-12 07:37:00 | AAPL | Stock | 19.1679 | 19.1679 | 19.1679 | 19.1679 | 2800.0 |
| 2014-02-12 07:40:00 | AAPL | Stock | 19.1679 | 19.1679 | 19.1679 | 19.1679 | 2800.0 |
| 2014-02-12 07:42:00 | AAPL | Stock | 19.1589 | 19.1589 | 19.1589 | 19.1589 | 2800.0 |
| 2014-02-12 07:47:00 | AAPL | Stock | 19.1518 | 19.1518 | 19.1518 | 19.1518 | 11200.0 |
| 2014-02-12 07:48:00 | AAPL | Stock | 19.1546 | 19.1546 | 19.1546 | 19.1546 | 2800.0 |
| 2014-02-12 07:50:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1607 | 19.1607 | 8400.0 |
| 2014-02-12 07:52:00 | AAPL | Stock | 19.1504 | 19.1529 | 19.1432 | 19.1529 | 17108.0 |
| 2014-02-12 07:54:00 | AAPL | Stock | 19.1486 | 19.1486 | 19.1471 | 19.1471 | 5600.0 |
| 2014-02-12 07:56:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1475 | 19.1479 | 14000.0 |
| 2014-02-12 07:57:00 | AAPL | Stock | 19.1432 | 19.1432 | 19.1429 | 19.1429 | 14000.0 |
| 2014-02-12 08:00:00 | AAPL | Stock | 19.1457 | 19.1914 | 19.1393 | 19.1464 | 103600.0 |
| 2014-02-12 08:01:00 | AAPL | Stock | 19.1464 | 19.1475 | 19.1429 | 19.1429 | 17024.0 |
| 2014-02-12 08:02:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1429 | 19.1429 | 5600.0 |
| 2014-02-12 08:03:00 | AAPL | Stock | 19.1429 | 19.1471 | 19.1429 | 19.1471 | 16604.0 |
| 2014-02-12 08:05:00 | AAPL | Stock | 19.1475 | 19.1475 | 19.1429 | 19.1443 | 8400.0 |
| 2014-02-12 08:06:00 | AAPL | Stock | 19.1454 | 19.1454 | 19.1454 | 19.1454 | 2800.0 |
| 2014-02-12 08:08:00 | AAPL | Stock | 19.1475 | 19.1475 | 19.1464 | 19.1464 | 19600.0 |
| 2014-02-12 08:09:00 | AAPL | Stock | 19.1464 | 19.1475 | 19.1454 | 19.1475 | 28000.0 |
| 2014-02-12 08:10:00 | AAPL | Stock | 19.1454 | 19.1611 | 19.1454 | 19.1611 | 16800.0 |
| 2014-02-12 08:12:00 | AAPL | Stock | 19.1536 | 19.1536 | 19.1536 | 19.1536 | 5040.0 |
| 2014-02-12 08:13:00 | AAPL | Stock | 19.1536 | 19.1536 | 19.1536 | 19.1536 | 2800.0 |
| 2014-02-12 08:18:00 | AAPL | Stock | 19.1571 | 19.1607 | 19.1571 | 19.1607 | 20720.0 |
| 2014-02-12 08:19:00 | AAPL | Stock | 19.1593 | 19.1593 | 19.1571 | 19.1571 | 14000.0 |
| 2014-02-12 08:21:00 | AAPL | Stock | 19.1625 | 19.1625 | 19.1586 | 19.1593 | 22820.0 |
| 2014-02-12 08:25:00 | AAPL | Stock | 19.1668 | 19.1668 | 19.1668 | 19.1668 | 2800.0 |
| 2014-02-12 08:26:00 | AAPL | Stock | 19.1664 | 19.1664 | 19.1664 | 19.1664 | 2800.0 |
| 2014-02-12 08:32:00 | AAPL | Stock | 19.1668 | 19.1671 | 19.1657 | 19.1671 | 8400.0 |
| 2014-02-12 08:33:00 | AAPL | Stock | 19.1664 | 19.1664 | 19.1646 | 19.1646 | 63868.0 |
> showing 50 of 1,064,895 rows — these rows as CSV