PREVIEW / stock_1min / 2012-08-28
file: by_date/stock_1min/2012/2012-08-28.parquet size: 11.8 MB rows: 877,772 symbols: 2,777
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-28 04:00:00 | AAPL | Stock | 24.1429 | 24.2143 | 24.1429 | 24.2143 | 37240.0 |
| 2012-08-28 04:02:00 | AAPL | Stock | 24.2139 | 24.2139 | 24.2139 | 24.2139 | 3360.0 |
| 2012-08-28 04:18:00 | AAPL | Stock | 24.1879 | 24.1879 | 24.1879 | 24.1879 | 2800.0 |
| 2012-08-28 04:20:00 | AAPL | Stock | 24.1786 | 24.1786 | 24.1786 | 24.1786 | 2800.0 |
| 2012-08-28 04:31:00 | AAPL | Stock | 24.2132 | 24.2143 | 24.2132 | 24.2143 | 25760.0 |
| 2012-08-28 04:32:00 | AAPL | Stock | 24.2143 | 24.2143 | 24.2143 | 24.2143 | 15540.0 |
| 2012-08-28 04:33:00 | AAPL | Stock | 24.2143 | 24.2143 | 24.2143 | 24.2143 | 11200.0 |
| 2012-08-28 04:47:00 | AAPL | Stock | 24.2343 | 24.2343 | 24.2343 | 24.2343 | 2800.0 |
| 2012-08-28 05:23:00 | AAPL | Stock | 24.2325 | 24.2325 | 24.2325 | 24.2325 | 2800.0 |
| 2012-08-28 05:34:00 | AAPL | Stock | 24.2321 | 24.2321 | 24.2321 | 24.2321 | 11200.0 |
| 2012-08-28 05:57:00 | AAPL | Stock | 24.2411 | 24.2411 | 24.2411 | 24.2411 | 6720.0 |
| 2012-08-28 06:01:00 | AAPL | Stock | 24.2218 | 24.2218 | 24.2214 | 24.2214 | 8400.0 |
| 2012-08-28 06:05:00 | AAPL | Stock | 24.225 | 24.225 | 24.225 | 24.225 | 2800.0 |
| 2012-08-28 06:09:00 | AAPL | Stock | 24.225 | 24.225 | 24.225 | 24.225 | 2800.0 |
| 2012-08-28 06:27:00 | AAPL | Stock | 24.2143 | 24.2143 | 24.2143 | 24.2143 | 2800.0 |
| 2012-08-28 06:44:00 | AAPL | Stock | 24.2036 | 24.2036 | 24.2036 | 24.2036 | 7280.0 |
| 2012-08-28 07:01:00 | AAPL | Stock | 24.1843 | 24.1964 | 24.1839 | 24.1964 | 8400.0 |
| 2012-08-28 07:02:00 | AAPL | Stock | 24.1875 | 24.1875 | 24.1875 | 24.1875 | 8260.0 |
| 2012-08-28 07:03:00 | AAPL | Stock | 24.1786 | 24.1786 | 24.1786 | 24.1786 | 8260.0 |
| 2012-08-28 07:05:00 | AAPL | Stock | 24.1679 | 24.1679 | 24.1607 | 24.1607 | 14000.0 |
| 2012-08-28 07:07:00 | AAPL | Stock | 24.1607 | 24.1607 | 24.15 | 24.15 | 16800.0 |
| 2012-08-28 07:08:00 | AAPL | Stock | 24.15 | 24.15 | 24.1446 | 24.1446 | 5600.0 |
| 2012-08-28 07:09:00 | AAPL | Stock | 24.1439 | 24.1439 | 24.1439 | 24.1439 | 2800.0 |
| 2012-08-28 07:10:00 | AAPL | Stock | 24.1482 | 24.1482 | 24.1482 | 24.1482 | 20104.0 |
| 2012-08-28 07:12:00 | AAPL | Stock | 24.1446 | 24.1536 | 24.1446 | 24.1536 | 5600.0 |
| 2012-08-28 07:16:00 | AAPL | Stock | 24.1525 | 24.1525 | 24.1525 | 24.1525 | 8400.0 |
| 2012-08-28 07:17:00 | AAPL | Stock | 24.1607 | 24.1607 | 24.1607 | 24.1607 | 4200.0 |
| 2012-08-28 07:19:00 | AAPL | Stock | 24.1639 | 24.1704 | 24.1546 | 24.1546 | 25200.0 |
| 2012-08-28 07:24:00 | AAPL | Stock | 24.1643 | 24.1643 | 24.1571 | 24.1571 | 8820.0 |
| 2012-08-28 07:27:00 | AAPL | Stock | 24.1589 | 24.1589 | 24.1571 | 24.1571 | 5600.0 |
| 2012-08-28 07:28:00 | AAPL | Stock | 24.1704 | 24.1725 | 24.1704 | 24.1725 | 19600.0 |
| 2012-08-28 07:29:00 | AAPL | Stock | 24.1739 | 24.1739 | 24.1739 | 24.1739 | 8400.0 |
| 2012-08-28 07:33:00 | AAPL | Stock | 24.1696 | 24.1696 | 24.1661 | 24.1661 | 16800.0 |
| 2012-08-28 07:37:00 | AAPL | Stock | 24.1571 | 24.1571 | 24.1571 | 24.1571 | 2800.0 |
| 2012-08-28 07:40:00 | AAPL | Stock | 24.1643 | 24.1643 | 24.1643 | 24.1643 | 8400.0 |
| 2012-08-28 07:41:00 | AAPL | Stock | 24.1496 | 24.1496 | 24.1496 | 24.1496 | 2800.0 |
| 2012-08-28 07:42:00 | AAPL | Stock | 24.15 | 24.15 | 24.15 | 24.15 | 8400.0 |
| 2012-08-28 07:45:00 | AAPL | Stock | 24.1464 | 24.1464 | 24.145 | 24.1454 | 8400.0 |
| 2012-08-28 07:47:00 | AAPL | Stock | 24.1443 | 24.1443 | 24.1286 | 24.1286 | 36400.0 |
| 2012-08-28 07:49:00 | AAPL | Stock | 24.1404 | 24.1404 | 24.1404 | 24.1404 | 14000.0 |
| 2012-08-28 07:51:00 | AAPL | Stock | 24.14 | 24.14 | 24.14 | 24.14 | 2800.0 |
| 2012-08-28 07:54:00 | AAPL | Stock | 24.1296 | 24.1296 | 24.1296 | 24.1296 | 2800.0 |
| 2012-08-28 07:55:00 | AAPL | Stock | 24.14 | 24.15 | 24.1389 | 24.1429 | 75908.0 |
| 2012-08-28 07:56:00 | AAPL | Stock | 24.1532 | 24.1564 | 24.1532 | 24.1564 | 5600.0 |
| 2012-08-28 07:57:00 | AAPL | Stock | 24.1429 | 24.1429 | 24.1429 | 24.1429 | 12880.0 |
| 2012-08-28 08:00:00 | AAPL | Stock | 24.1568 | 24.1575 | 24.1332 | 24.1332 | 123368.0 |
| 2012-08-28 08:01:00 | AAPL | Stock | 24.1375 | 24.1375 | 24.125 | 24.1318 | 62776.0 |
| 2012-08-28 08:02:00 | AAPL | Stock | 24.1354 | 24.1429 | 24.1279 | 24.1321 | 107632.0 |
| 2012-08-28 08:03:00 | AAPL | Stock | 24.2 | 24.2 | 24.1321 | 24.1354 | 174552.0 |
| 2012-08-28 08:04:00 | AAPL | Stock | 24.1418 | 24.1418 | 24.1357 | 24.1357 | 10360.0 |
> showing 50 of 877,772 rows — these rows as CSV