PREVIEW / stock_1min / 2011-08-02
file: by_date/stock_1min/2011/2011-08-02.parquet size: 14.0 MB rows: 1,034,468 symbols: 2,843
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-02 04:14:00 | AAPL | Stock | 14.1343 | 14.1343 | 14.1343 | 14.1343 | 2800.0 |
| 2011-08-02 04:32:00 | AAPL | Stock | 14.1471 | 14.1471 | 14.1471 | 14.1471 | 8400.0 |
| 2011-08-02 04:42:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 2800.0 |
| 2011-08-02 05:22:00 | AAPL | Stock | 14.1343 | 14.1343 | 14.1343 | 14.1343 | 2800.0 |
| 2011-08-02 05:23:00 | AAPL | Stock | 14.1343 | 14.1343 | 14.1343 | 14.1343 | 2800.0 |
| 2011-08-02 05:28:00 | AAPL | Stock | 14.1279 | 14.1279 | 14.1279 | 14.1279 | 2800.0 |
| 2011-08-02 05:34:00 | AAPL | Stock | 14.1946 | 14.1946 | 14.1946 | 14.1946 | 2800.0 |
| 2011-08-02 05:45:00 | AAPL | Stock | 14.1961 | 14.1961 | 14.1961 | 14.1961 | 2800.0 |
| 2011-08-02 05:48:00 | AAPL | Stock | 14.1279 | 14.1279 | 14.1279 | 14.1279 | 2800.0 |
| 2011-08-02 05:49:00 | AAPL | Stock | 14.1279 | 14.1279 | 14.1279 | 14.1279 | 11200.0 |
| 2011-08-02 05:57:00 | AAPL | Stock | 14.1279 | 14.1279 | 14.1279 | 14.1279 | 2800.0 |
| 2011-08-02 06:02:00 | AAPL | Stock | 14.1286 | 14.1286 | 14.1286 | 14.1286 | 5600.0 |
| 2011-08-02 06:05:00 | AAPL | Stock | 14.1357 | 14.1357 | 14.1357 | 14.1357 | 2800.0 |
| 2011-08-02 06:13:00 | AAPL | Stock | 14.1461 | 14.1461 | 14.1461 | 14.1461 | 2800.0 |
| 2011-08-02 06:14:00 | AAPL | Stock | 14.1464 | 14.1464 | 14.1464 | 14.1464 | 11200.0 |
| 2011-08-02 06:19:00 | AAPL | Stock | 14.1464 | 14.1482 | 14.1464 | 14.1482 | 5600.0 |
| 2011-08-02 06:50:00 | AAPL | Stock | 14.1482 | 14.1482 | 14.1325 | 14.1325 | 16800.0 |
| 2011-08-02 06:57:00 | AAPL | Stock | 14.1425 | 14.1425 | 14.1425 | 14.1425 | 3920.0 |
| 2011-08-02 07:01:00 | AAPL | Stock | 14.1529 | 14.1529 | 14.1529 | 14.1529 | 5600.0 |
| 2011-08-02 07:03:00 | AAPL | Stock | 14.1639 | 14.1639 | 14.1639 | 14.1639 | 5600.0 |
| 2011-08-02 07:04:00 | AAPL | Stock | 14.1696 | 14.1696 | 14.1696 | 14.1696 | 2800.0 |
| 2011-08-02 07:05:00 | AAPL | Stock | 14.1661 | 14.1907 | 14.1661 | 14.1907 | 16800.0 |
| 2011-08-02 07:06:00 | AAPL | Stock | 14.1668 | 14.1668 | 14.1607 | 14.1607 | 22400.0 |
| 2011-08-02 07:07:00 | AAPL | Stock | 14.1432 | 14.1489 | 14.1429 | 14.1429 | 42700.0 |
| 2011-08-02 07:08:00 | AAPL | Stock | 14.1604 | 14.1604 | 14.1604 | 14.1604 | 5600.0 |
| 2011-08-02 07:14:00 | AAPL | Stock | 14.1471 | 14.1471 | 14.1471 | 14.1471 | 5600.0 |
| 2011-08-02 07:16:00 | AAPL | Stock | 14.1661 | 14.1696 | 14.1661 | 14.1696 | 8400.0 |
| 2011-08-02 07:17:00 | AAPL | Stock | 14.1675 | 14.1675 | 14.1675 | 14.1675 | 2800.0 |
| 2011-08-02 07:22:00 | AAPL | Stock | 14.1664 | 14.1679 | 14.1646 | 14.1664 | 57848.0 |
| 2011-08-02 07:23:00 | AAPL | Stock | 14.1664 | 14.1704 | 14.1664 | 14.1675 | 22400.0 |
| 2011-08-02 07:24:00 | AAPL | Stock | 14.1675 | 14.1704 | 14.1518 | 14.1704 | 131152.0 |
| 2011-08-02 07:25:00 | AAPL | Stock | 14.1504 | 14.1504 | 14.1357 | 14.1425 | 84112.0 |
| 2011-08-02 07:27:00 | AAPL | Stock | 14.1386 | 14.1386 | 14.1386 | 14.1386 | 5600.0 |
| 2011-08-02 07:28:00 | AAPL | Stock | 14.1393 | 14.1429 | 14.1393 | 14.1429 | 9800.0 |
| 2011-08-02 07:33:00 | AAPL | Stock | 14.1411 | 14.1432 | 14.1411 | 14.1429 | 14000.0 |
| 2011-08-02 07:34:00 | AAPL | Stock | 14.1361 | 14.1418 | 14.1357 | 14.1418 | 25200.0 |
| 2011-08-02 07:36:00 | AAPL | Stock | 14.1325 | 14.1325 | 14.1232 | 14.1232 | 56000.0 |
| 2011-08-02 07:38:00 | AAPL | Stock | 14.125 | 14.125 | 14.1214 | 14.125 | 30800.0 |
| 2011-08-02 07:39:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 5600.0 |
| 2011-08-02 07:40:00 | AAPL | Stock | 14.1311 | 14.1325 | 14.1311 | 14.1325 | 26040.0 |
| 2011-08-02 07:41:00 | AAPL | Stock | 14.1386 | 14.1386 | 14.1386 | 14.1386 | 5600.0 |
| 2011-08-02 07:42:00 | AAPL | Stock | 14.1411 | 14.1411 | 14.1411 | 14.1411 | 2800.0 |
| 2011-08-02 07:43:00 | AAPL | Stock | 14.1404 | 14.1411 | 14.1404 | 14.1411 | 5600.0 |
| 2011-08-02 07:45:00 | AAPL | Stock | 14.1375 | 14.1386 | 14.1375 | 14.1375 | 14000.0 |
| 2011-08-02 07:51:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1414 | 14.1414 | 5600.0 |
| 2011-08-02 07:55:00 | AAPL | Stock | 14.1554 | 14.1554 | 14.1554 | 14.1554 | 2800.0 |
| 2011-08-02 07:56:00 | AAPL | Stock | 14.1554 | 14.1554 | 14.1554 | 14.1554 | 5600.0 |
| 2011-08-02 08:00:00 | AAPL | Stock | 14.1518 | 14.1643 | 14.1518 | 14.1561 | 98896.0 |
| 2011-08-02 08:01:00 | AAPL | Stock | 14.1561 | 14.1564 | 14.1482 | 14.1482 | 43008.0 |
| 2011-08-02 08:02:00 | AAPL | Stock | 14.15 | 14.15 | 14.1443 | 14.1454 | 50960.0 |
> showing 50 of 1,034,468 rows — these rows as CSV