PREVIEW / stock_5min / 2011-08-02
file: by_date/stock_5min/2011/2011-08-02.parquet size: 5.0 MB rows: 334,798 symbols: 3,517
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:10:00 | AAPL | Stock | 14.1343 | 14.1343 | 14.1343 | 14.1343 | 2800.0 |
| 2011-08-02 04:30:00 | AAPL | Stock | 14.1471 | 14.1471 | 14.1471 | 14.1471 | 8400.0 |
| 2011-08-02 04:40:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 2800.0 |
| 2011-08-02 05:20:00 | AAPL | Stock | 14.1343 | 14.1343 | 14.1343 | 14.1343 | 5600.0 |
| 2011-08-02 05:25:00 | AAPL | Stock | 14.1279 | 14.1279 | 14.1279 | 14.1279 | 2800.0 |
| 2011-08-02 05:30: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.1279 | 14.1279 | 16800.0 |
| 2011-08-02 05:55:00 | AAPL | Stock | 14.1279 | 14.1279 | 14.1279 | 14.1279 | 2800.0 |
| 2011-08-02 06:00: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:10:00 | AAPL | Stock | 14.1461 | 14.1464 | 14.1461 | 14.1464 | 14000.0 |
| 2011-08-02 06:15: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:55:00 | AAPL | Stock | 14.1425 | 14.1425 | 14.1425 | 14.1425 | 3920.0 |
| 2011-08-02 07:00:00 | AAPL | Stock | 14.1529 | 14.1696 | 14.1529 | 14.1696 | 14000.0 |
| 2011-08-02 07:05:00 | AAPL | Stock | 14.1661 | 14.1907 | 14.1429 | 14.1604 | 87500.0 |
| 2011-08-02 07:10:00 | AAPL | Stock | 14.1471 | 14.1471 | 14.1471 | 14.1471 | 5600.0 |
| 2011-08-02 07:15:00 | AAPL | Stock | 14.1661 | 14.1696 | 14.1661 | 14.1675 | 11200.0 |
| 2011-08-02 07:20:00 | AAPL | Stock | 14.1664 | 14.1704 | 14.1518 | 14.1704 | 211400.0 |
| 2011-08-02 07:25:00 | AAPL | Stock | 14.1504 | 14.1504 | 14.1357 | 14.1429 | 99512.0 |
| 2011-08-02 07:30:00 | AAPL | Stock | 14.1411 | 14.1432 | 14.1357 | 14.1418 | 39200.0 |
| 2011-08-02 07:35:00 | AAPL | Stock | 14.1325 | 14.1325 | 14.1214 | 14.125 | 92400.0 |
| 2011-08-02 07:40:00 | AAPL | Stock | 14.1311 | 14.1411 | 14.1311 | 14.1411 | 40040.0 |
| 2011-08-02 07:45:00 | AAPL | Stock | 14.1375 | 14.1386 | 14.1375 | 14.1375 | 14000.0 |
| 2011-08-02 07:50: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 | 8400.0 |
| 2011-08-02 08:00:00 | AAPL | Stock | 14.1518 | 14.1643 | 14.1432 | 14.1439 | 243964.0 |
| 2011-08-02 08:05:00 | AAPL | Stock | 14.1436 | 14.1482 | 14.1361 | 14.1414 | 477204.0 |
| 2011-08-02 08:10:00 | AAPL | Stock | 14.1461 | 14.1461 | 14.1375 | 14.1375 | 88172.0 |
| 2011-08-02 08:15:00 | AAPL | Stock | 14.1375 | 14.1389 | 14.1329 | 14.1329 | 403004.0 |
| 2011-08-02 08:20:00 | AAPL | Stock | 14.1296 | 14.1386 | 14.1071 | 14.1071 | 372176.0 |
| 2011-08-02 08:25:00 | AAPL | Stock | 14.1075 | 14.1189 | 14.1071 | 14.11 | 216524.0 |
| 2011-08-02 08:30:00 | AAPL | Stock | 14.1071 | 14.1207 | 14.0893 | 14.12 | 612192.0 |
| 2011-08-02 08:35:00 | AAPL | Stock | 14.1182 | 14.13 | 14.0968 | 14.1168 | 157472.0 |
| 2011-08-02 08:40:00 | AAPL | Stock | 14.1161 | 14.1429 | 14.1111 | 14.1429 | 198380.0 |
| 2011-08-02 08:45:00 | AAPL | Stock | 14.1457 | 14.1464 | 14.1336 | 14.1336 | 233380.0 |
| 2011-08-02 08:50:00 | AAPL | Stock | 14.1311 | 14.1379 | 14.1286 | 14.1339 | 117740.0 |
| 2011-08-02 08:55:00 | AAPL | Stock | 14.1361 | 14.1643 | 14.1361 | 14.1593 | 350784.0 |
| 2011-08-02 09:00:00 | AAPL | Stock | 14.1568 | 14.1589 | 14.1464 | 14.1536 | 182588.0 |
| 2011-08-02 09:05:00 | AAPL | Stock | 14.1568 | 14.1575 | 14.1468 | 14.1468 | 56000.0 |
| 2011-08-02 09:10:00 | AAPL | Stock | 14.1482 | 14.1596 | 14.1464 | 14.1539 | 239008.0 |
| 2011-08-02 09:15:00 | AAPL | Stock | 14.1539 | 14.1768 | 14.1529 | 14.1743 | 291928.0 |
| 2011-08-02 09:20:00 | AAPL | Stock | 14.1714 | 14.1743 | 14.1589 | 14.1696 | 549780.0 |
| 2011-08-02 09:25:00 | AAPL | Stock | 14.1661 | 14.1996 | 14.1621 | 14.1964 | 621936.0 |
| 2011-08-02 09:30:00 | AAPL | Stock | 14.2011 | 14.2107 | 14.1314 | 14.1549 | 19358696.0 |
| 2011-08-02 09:35:00 | AAPL | Stock | 14.155 | 14.1961 | 14.1379 | 14.1961 | 16953132.0 |
| 2011-08-02 09:40:00 | AAPL | Stock | 14.1945 | 14.2 | 14.1393 | 14.1636 | 12065424.0 |
| 2011-08-02 09:45:00 | AAPL | Stock | 14.1632 | 14.1786 | 14.1393 | 14.1482 | 11468044.0 |
| 2011-08-02 09:50:00 | AAPL | Stock | 14.1482 | 14.1496 | 14.1136 | 14.1221 | 12269096.0 |
| 2011-08-02 09:55:00 | AAPL | Stock | 14.1219 | 14.1568 | 14.1168 | 14.15 | 9948232.0 |
> showing 50 of 334,798 rows — these rows as CSV