PREVIEW / stock_5min / 2014-06-06
file: by_date/stock_5min/2014/2014-06-06.parquet size: 5.3 MB rows: 358,452 symbols: 3,540
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-06-06 04:00:00 | AAPL | Stock | 23.1714 | 23.1911 | 23.1714 | 23.1757 | 11200.0 |
| 2014-06-06 04:10:00 | AAPL | Stock | 23.1629 | 23.1629 | 23.1629 | 23.1629 | 3920.0 |
| 2014-06-06 04:15:00 | AAPL | Stock | 23.1643 | 23.1714 | 23.1643 | 23.1714 | 8400.0 |
| 2014-06-06 04:30:00 | AAPL | Stock | 23.1539 | 23.1786 | 23.1539 | 23.1761 | 22400.0 |
| 2014-06-06 04:35:00 | AAPL | Stock | 23.1768 | 23.1768 | 23.1579 | 23.1579 | 7840.0 |
| 2014-06-06 04:45:00 | AAPL | Stock | 23.1786 | 23.1786 | 23.1786 | 23.1786 | 5040.0 |
| 2014-06-06 04:50:00 | AAPL | Stock | 23.1775 | 23.1793 | 23.1775 | 23.1793 | 5600.0 |
| 2014-06-06 04:55:00 | AAPL | Stock | 23.1786 | 23.1786 | 23.1786 | 23.1786 | 2800.0 |
| 2014-06-06 05:00:00 | AAPL | Stock | 23.1746 | 23.1746 | 23.1643 | 23.1643 | 8400.0 |
| 2014-06-06 05:10:00 | AAPL | Stock | 23.1786 | 23.1786 | 23.1786 | 23.1786 | 8400.0 |
| 2014-06-06 05:25:00 | AAPL | Stock | 23.1786 | 23.1786 | 23.1786 | 23.1786 | 2800.0 |
| 2014-06-06 05:50:00 | AAPL | Stock | 23.1786 | 23.1786 | 23.1786 | 23.1786 | 2800.0 |
| 2014-06-06 06:00:00 | AAPL | Stock | 23.1896 | 23.1896 | 23.1721 | 23.1721 | 14588.0 |
| 2014-06-06 06:10:00 | AAPL | Stock | 23.1821 | 23.1821 | 23.1821 | 23.1821 | 2800.0 |
| 2014-06-06 06:15:00 | AAPL | Stock | 23.1893 | 23.1964 | 23.1893 | 23.1964 | 5600.0 |
| 2014-06-06 06:30:00 | AAPL | Stock | 23.185 | 23.185 | 23.1814 | 23.1814 | 8400.0 |
| 2014-06-06 06:35:00 | AAPL | Stock | 23.1807 | 23.1807 | 23.1807 | 23.1807 | 2800.0 |
| 2014-06-06 06:40:00 | AAPL | Stock | 23.1804 | 23.1804 | 23.1804 | 23.1804 | 16800.0 |
| 2014-06-06 06:45:00 | AAPL | Stock | 23.1768 | 23.1768 | 23.1714 | 23.1714 | 9800.0 |
| 2014-06-06 07:00:00 | AAPL | Stock | 23.1779 | 23.1779 | 23.1696 | 23.1696 | 16800.0 |
| 2014-06-06 07:05:00 | AAPL | Stock | 23.165 | 23.165 | 23.1461 | 23.1461 | 50400.0 |
| 2014-06-06 07:10:00 | AAPL | Stock | 23.1429 | 23.1561 | 23.1371 | 23.1371 | 71344.0 |
| 2014-06-06 07:15:00 | AAPL | Stock | 23.1429 | 23.1429 | 23.1429 | 23.1429 | 2912.0 |
| 2014-06-06 07:20:00 | AAPL | Stock | 23.1429 | 23.1518 | 23.1429 | 23.15 | 97860.0 |
| 2014-06-06 07:25:00 | AAPL | Stock | 23.1443 | 23.1443 | 23.1425 | 23.1429 | 20720.0 |
| 2014-06-06 07:30:00 | AAPL | Stock | 23.1429 | 23.1607 | 23.1429 | 23.1518 | 41748.0 |
| 2014-06-06 07:35:00 | AAPL | Stock | 23.1464 | 23.1464 | 23.1429 | 23.1429 | 13720.0 |
| 2014-06-06 07:40:00 | AAPL | Stock | 23.1507 | 23.1507 | 23.1429 | 23.1464 | 107800.0 |
| 2014-06-06 07:45:00 | AAPL | Stock | 23.1521 | 23.1643 | 23.1518 | 23.1518 | 77588.0 |
| 2014-06-06 07:50:00 | AAPL | Stock | 23.1507 | 23.1507 | 23.15 | 23.15 | 5600.0 |
| 2014-06-06 07:55:00 | AAPL | Stock | 23.1586 | 23.1611 | 23.1575 | 23.1611 | 30800.0 |
| 2014-06-06 08:00:00 | AAPL | Stock | 23.1554 | 23.1696 | 23.1371 | 23.1475 | 167944.0 |
| 2014-06-06 08:05:00 | AAPL | Stock | 23.1439 | 23.1464 | 23.1361 | 23.1361 | 41972.0 |
| 2014-06-06 08:10:00 | AAPL | Stock | 23.1321 | 23.1361 | 23.1239 | 23.1336 | 98224.0 |
| 2014-06-06 08:15:00 | AAPL | Stock | 23.1336 | 23.1339 | 23.125 | 23.125 | 95704.0 |
| 2014-06-06 08:20:00 | AAPL | Stock | 23.1254 | 23.1254 | 23.1125 | 23.1161 | 178976.0 |
| 2014-06-06 08:25:00 | AAPL | Stock | 23.1168 | 23.1196 | 23.1089 | 23.1125 | 146552.0 |
| 2014-06-06 08:30:00 | AAPL | Stock | 23.1232 | 23.1732 | 23.1218 | 23.1686 | 568344.0 |
| 2014-06-06 08:35:00 | AAPL | Stock | 23.1679 | 23.1679 | 23.1536 | 23.1536 | 123900.0 |
| 2014-06-06 08:40:00 | AAPL | Stock | 23.1589 | 23.1589 | 23.1536 | 23.1589 | 26516.0 |
| 2014-06-06 08:45:00 | AAPL | Stock | 23.1589 | 23.1589 | 23.1582 | 23.1586 | 8400.0 |
| 2014-06-06 08:50:00 | AAPL | Stock | 23.1607 | 23.17 | 23.1607 | 23.1636 | 95564.0 |
| 2014-06-06 08:55:00 | AAPL | Stock | 23.1664 | 23.1743 | 23.1625 | 23.1707 | 165172.0 |
| 2014-06-06 09:00:00 | AAPL | Stock | 23.1711 | 23.1786 | 23.17 | 23.1786 | 112000.0 |
| 2014-06-06 09:05:00 | AAPL | Stock | 23.1786 | 23.1804 | 23.1718 | 23.1786 | 200648.0 |
| 2014-06-06 09:10:00 | AAPL | Stock | 23.1775 | 23.1782 | 23.1771 | 23.1775 | 14000.0 |
| 2014-06-06 09:15:00 | AAPL | Stock | 23.1761 | 23.1786 | 23.1732 | 23.175 | 47684.0 |
| 2014-06-06 09:20:00 | AAPL | Stock | 23.175 | 23.1964 | 23.175 | 23.1957 | 318724.0 |
| 2014-06-06 09:25:00 | AAPL | Stock | 23.1932 | 23.2257 | 23.1911 | 23.2218 | 830928.0 |
| 2014-06-06 09:30:00 | AAPL | Stock | 23.2129 | 23.2318 | 23.1197 | 23.1347 | 19686240.0 |
> showing 50 of 358,452 rows — these rows as CSV