PREVIEW / stock_5min / 2013-03-07
file: by_date/stock_5min/2013/2013-03-07.parquet size: 5.0 MB rows: 332,679 symbols: 3,494
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-03-07 05:55:00 | AAPL | Stock | 15.165 | 15.165 | 15.1643 | 15.1643 | 11676.0 |
| 2013-03-07 07:00:00 | AAPL | Stock | 15.1786 | 15.1786 | 15.1786 | 15.1786 | 2800.0 |
| 2013-03-07 07:10:00 | AAPL | Stock | 15.1857 | 15.1893 | 15.1607 | 15.1607 | 32200.0 |
| 2013-03-07 07:15:00 | AAPL | Stock | 15.1607 | 15.1607 | 15.1564 | 15.1564 | 17052.0 |
| 2013-03-07 07:20:00 | AAPL | Stock | 15.1664 | 15.1664 | 15.1325 | 15.1429 | 51520.0 |
| 2013-03-07 07:25:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 16800.0 |
| 2013-03-07 07:30:00 | AAPL | Stock | 15.1525 | 15.1571 | 15.1525 | 15.1571 | 18676.0 |
| 2013-03-07 07:35:00 | AAPL | Stock | 15.1661 | 15.1661 | 15.1429 | 15.1429 | 47768.0 |
| 2013-03-07 07:40:00 | AAPL | Stock | 15.1607 | 15.1611 | 15.1607 | 15.1607 | 14000.0 |
| 2013-03-07 07:45:00 | AAPL | Stock | 15.1571 | 15.1571 | 15.1571 | 15.1571 | 5600.0 |
| 2013-03-07 07:55:00 | AAPL | Stock | 15.1554 | 15.1554 | 15.1429 | 15.1429 | 76664.0 |
| 2013-03-07 08:00:00 | AAPL | Stock | 15.1607 | 15.2143 | 15.1429 | 15.1668 | 350448.0 |
| 2013-03-07 08:05:00 | AAPL | Stock | 15.1679 | 15.1714 | 15.1518 | 15.1518 | 54852.0 |
| 2013-03-07 08:10:00 | AAPL | Stock | 15.1536 | 15.1661 | 15.1536 | 15.1561 | 50260.0 |
| 2013-03-07 08:15:00 | AAPL | Stock | 15.1568 | 15.1643 | 15.1521 | 15.1643 | 46900.0 |
| 2013-03-07 08:20:00 | AAPL | Stock | 15.1643 | 15.1693 | 15.1568 | 15.1661 | 46144.0 |
| 2013-03-07 08:25:00 | AAPL | Stock | 15.1661 | 15.1925 | 15.1661 | 15.1821 | 99708.0 |
| 2013-03-07 08:30:00 | AAPL | Stock | 15.1839 | 15.1839 | 15.1607 | 15.1611 | 128128.0 |
| 2013-03-07 08:35:00 | AAPL | Stock | 15.1611 | 15.1693 | 15.1611 | 15.1693 | 32536.0 |
| 2013-03-07 08:40:00 | AAPL | Stock | 15.1661 | 15.2054 | 15.1607 | 15.205 | 242564.0 |
| 2013-03-07 08:45:00 | AAPL | Stock | 15.205 | 15.2154 | 15.1857 | 15.1857 | 177240.0 |
| 2013-03-07 08:50:00 | AAPL | Stock | 15.1893 | 15.2011 | 15.1786 | 15.1857 | 128380.0 |
| 2013-03-07 08:55:00 | AAPL | Stock | 15.1843 | 15.2193 | 15.1843 | 15.2143 | 158788.0 |
| 2013-03-07 09:00:00 | AAPL | Stock | 15.2143 | 15.23 | 15.2143 | 15.23 | 103880.0 |
| 2013-03-07 09:05:00 | AAPL | Stock | 15.2161 | 15.2179 | 15.1889 | 15.1889 | 127204.0 |
| 2013-03-07 09:10:00 | AAPL | Stock | 15.1943 | 15.1957 | 15.1786 | 15.1957 | 120064.0 |
| 2013-03-07 09:15:00 | AAPL | Stock | 15.1943 | 15.1946 | 15.1829 | 15.1829 | 27720.0 |
| 2013-03-07 09:20:00 | AAPL | Stock | 15.1896 | 15.1896 | 15.1696 | 15.1786 | 148848.0 |
| 2013-03-07 09:25:00 | AAPL | Stock | 15.1786 | 15.1871 | 15.1536 | 15.1589 | 494620.0 |
| 2013-03-07 09:30:00 | AAPL | Stock | 15.16 | 15.175 | 15.0993 | 15.1264 | 19313644.0 |
| 2013-03-07 09:35:00 | AAPL | Stock | 15.1232 | 15.1264 | 15.0957 | 15.1082 | 10628464.0 |
| 2013-03-07 09:40:00 | AAPL | Stock | 15.1103 | 15.12 | 15.0804 | 15.1036 | 9434712.0 |
| 2013-03-07 09:45:00 | AAPL | Stock | 15.1018 | 15.1243 | 15.0668 | 15.0786 | 7415296.0 |
| 2013-03-07 09:50:00 | AAPL | Stock | 15.0794 | 15.0868 | 15.0464 | 15.0714 | 8126972.0 |
| 2013-03-07 09:55:00 | AAPL | Stock | 15.0704 | 15.1082 | 15.0614 | 15.0782 | 5839876.0 |
| 2013-03-07 10:00:00 | AAPL | Stock | 15.0807 | 15.0857 | 15.0418 | 15.0518 | 8422064.0 |
| 2013-03-07 10:05:00 | AAPL | Stock | 15.0536 | 15.0654 | 15.0379 | 15.0607 | 6909196.0 |
| 2013-03-07 10:10:00 | AAPL | Stock | 15.0606 | 15.1004 | 15.0536 | 15.0829 | 7117768.0 |
| 2013-03-07 10:15:00 | AAPL | Stock | 15.0854 | 15.0989 | 15.0714 | 15.0807 | 4910724.0 |
| 2013-03-07 10:20:00 | AAPL | Stock | 15.0821 | 15.0857 | 15.0532 | 15.0814 | 4495792.0 |
| 2013-03-07 10:25:00 | AAPL | Stock | 15.0814 | 15.0893 | 15.0654 | 15.0854 | 3736012.0 |
| 2013-03-07 10:30:00 | AAPL | Stock | 15.0804 | 15.1121 | 15.0779 | 15.1036 | 5752348.0 |
| 2013-03-07 10:35:00 | AAPL | Stock | 15.1035 | 15.1035 | 15.0775 | 15.0821 | 4436096.0 |
| 2013-03-07 10:40:00 | AAPL | Stock | 15.0821 | 15.1146 | 15.0821 | 15.1107 | 4818632.0 |
| 2013-03-07 10:45:00 | AAPL | Stock | 15.1139 | 15.1482 | 15.1075 | 15.1429 | 10618160.0 |
| 2013-03-07 10:50:00 | AAPL | Stock | 15.142 | 15.1682 | 15.1282 | 15.13 | 8654828.0 |
| 2013-03-07 10:55:00 | AAPL | Stock | 15.1286 | 15.1429 | 15.1143 | 15.1362 | 4500468.0 |
| 2013-03-07 11:00:00 | AAPL | Stock | 15.1372 | 15.1939 | 15.1332 | 15.1718 | 10611776.0 |
| 2013-03-07 11:05:00 | AAPL | Stock | 15.1711 | 15.2404 | 15.1696 | 15.2206 | 12901812.0 |
| 2013-03-07 11:10:00 | AAPL | Stock | 15.2189 | 15.2286 | 15.2021 | 15.2021 | 6064212.0 |
> showing 50 of 332,679 rows — these rows as CSV