PREVIEW / stock_1min / 2013-12-10
file: by_date/stock_1min/2013/2013-12-10.parquet size: 14.3 MB rows: 1,049,273 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 |
|---|---|---|---|---|---|---|---|
| 2013-12-10 04:00:00 | AAPL | Stock | 20.2721 | 20.2721 | 20.2721 | 20.2721 | 2800.0 |
| 2013-12-10 05:52:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 2800.0 |
| 2013-12-10 06:08:00 | AAPL | Stock | 20.2589 | 20.2589 | 20.2589 | 20.2589 | 2800.0 |
| 2013-12-10 06:15:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 21000.0 |
| 2013-12-10 06:31:00 | AAPL | Stock | 20.2489 | 20.2489 | 20.2489 | 20.2489 | 5572.0 |
| 2013-12-10 06:51:00 | AAPL | Stock | 20.2429 | 20.2429 | 20.2429 | 20.2429 | 8680.0 |
| 2013-12-10 06:55:00 | AAPL | Stock | 20.2357 | 20.2357 | 20.2296 | 20.2296 | 16800.0 |
| 2013-12-10 06:56:00 | AAPL | Stock | 20.2357 | 20.2357 | 20.2357 | 20.2357 | 8400.0 |
| 2013-12-10 06:57:00 | AAPL | Stock | 20.2264 | 20.2264 | 20.2264 | 20.2264 | 11200.0 |
| 2013-12-10 07:09:00 | AAPL | Stock | 20.2396 | 20.2396 | 20.2393 | 20.2393 | 16800.0 |
| 2013-12-10 07:10:00 | AAPL | Stock | 20.2329 | 20.2329 | 20.2329 | 20.2329 | 2800.0 |
| 2013-12-10 07:12:00 | AAPL | Stock | 20.2236 | 20.2236 | 20.2236 | 20.2236 | 5600.0 |
| 2013-12-10 07:15:00 | AAPL | Stock | 20.2232 | 20.2232 | 20.2218 | 20.2218 | 12600.0 |
| 2013-12-10 07:16:00 | AAPL | Stock | 20.22 | 20.2279 | 20.215 | 20.215 | 19600.0 |
| 2013-12-10 07:24:00 | AAPL | Stock | 20.2071 | 20.2071 | 20.2071 | 20.2071 | 11200.0 |
| 2013-12-10 07:25:00 | AAPL | Stock | 20.2107 | 20.2107 | 20.2107 | 20.2107 | 2800.0 |
| 2013-12-10 07:26:00 | AAPL | Stock | 20.2071 | 20.2071 | 20.2018 | 20.2018 | 5600.0 |
| 2013-12-10 07:27:00 | AAPL | Stock | 20.2007 | 20.2007 | 20.2007 | 20.2007 | 2800.0 |
| 2013-12-10 07:31:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1786 | 20.1786 | 28728.0 |
| 2013-12-10 07:32:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1696 | 20.1696 | 18172.0 |
| 2013-12-10 07:33:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 9632.0 |
| 2013-12-10 07:49:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1893 | 20.1893 | 2800.0 |
| 2013-12-10 07:52:00 | AAPL | Stock | 20.1857 | 20.1904 | 20.1857 | 20.1904 | 5600.0 |
| 2013-12-10 07:54:00 | AAPL | Stock | 20.1964 | 20.1964 | 20.1964 | 20.1964 | 11200.0 |
| 2013-12-10 07:55:00 | AAPL | Stock | 20.19 | 20.19 | 20.1896 | 20.1896 | 8400.0 |
| 2013-12-10 07:56:00 | AAPL | Stock | 20.1875 | 20.1875 | 20.1786 | 20.1786 | 16800.0 |
| 2013-12-10 07:57:00 | AAPL | Stock | 20.1911 | 20.2029 | 20.1911 | 20.2014 | 28000.0 |
| 2013-12-10 07:58:00 | AAPL | Stock | 20.1946 | 20.1946 | 20.1893 | 20.1911 | 56000.0 |
| 2013-12-10 07:59:00 | AAPL | Stock | 20.1921 | 20.1929 | 20.1836 | 20.1836 | 14000.0 |
| 2013-12-10 08:00:00 | AAPL | Stock | 20.1929 | 20.2329 | 20.1786 | 20.1879 | 84112.0 |
| 2013-12-10 08:01:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1875 | 20.1893 | 16240.0 |
| 2013-12-10 08:02:00 | AAPL | Stock | 20.1836 | 20.1868 | 20.1786 | 20.1789 | 63560.0 |
| 2013-12-10 08:03:00 | AAPL | Stock | 20.1857 | 20.1857 | 20.1786 | 20.1821 | 78736.0 |
| 2013-12-10 08:04:00 | AAPL | Stock | 20.1821 | 20.2296 | 20.1771 | 20.2296 | 142800.0 |
| 2013-12-10 08:05:00 | AAPL | Stock | 20.1775 | 20.1775 | 20.1496 | 20.1504 | 145740.0 |
| 2013-12-10 08:06:00 | AAPL | Stock | 20.1464 | 20.1464 | 20.1429 | 20.1429 | 40880.0 |
| 2013-12-10 08:07:00 | AAPL | Stock | 20.1571 | 20.1571 | 20.145 | 20.145 | 8400.0 |
| 2013-12-10 08:08:00 | AAPL | Stock | 20.1486 | 20.15 | 20.1429 | 20.1464 | 64400.0 |
| 2013-12-10 08:09:00 | AAPL | Stock | 20.1536 | 20.1536 | 20.1518 | 20.1518 | 8400.0 |
| 2013-12-10 08:10:00 | AAPL | Stock | 20.1468 | 20.1468 | 20.145 | 20.145 | 12628.0 |
| 2013-12-10 08:11:00 | AAPL | Stock | 20.1518 | 20.1518 | 20.1482 | 20.1518 | 11256.0 |
| 2013-12-10 08:12:00 | AAPL | Stock | 20.1518 | 20.1536 | 20.1518 | 20.1536 | 14028.0 |
| 2013-12-10 08:15:00 | AAPL | Stock | 20.1589 | 20.1589 | 20.1429 | 20.1429 | 88200.0 |
| 2013-12-10 08:16:00 | AAPL | Stock | 20.1454 | 20.1454 | 20.1454 | 20.1454 | 14000.0 |
| 2013-12-10 08:17:00 | AAPL | Stock | 20.1482 | 20.1486 | 20.1429 | 20.1454 | 36400.0 |
| 2013-12-10 08:18:00 | AAPL | Stock | 20.1443 | 20.1454 | 20.1404 | 20.1407 | 60900.0 |
| 2013-12-10 08:19:00 | AAPL | Stock | 20.1343 | 20.1407 | 20.1343 | 20.1375 | 8680.0 |
| 2013-12-10 08:20:00 | AAPL | Stock | 20.1407 | 20.1411 | 20.1321 | 20.1354 | 33600.0 |
| 2013-12-10 08:21:00 | AAPL | Stock | 20.1271 | 20.1271 | 20.1271 | 20.1271 | 5600.0 |
| 2013-12-10 08:22:00 | AAPL | Stock | 20.1386 | 20.1393 | 20.1268 | 20.1304 | 55160.0 |
> showing 50 of 1,049,273 rows — these rows as CSV