PREVIEW / stock_5min / 2012-12-13
file: by_date/stock_5min/2012/2012-12-13.parquet size: 4.8 MB rows: 318,417 symbols: 3,507
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-12-13 04:20:00 | AAPL | Stock | 19.2682 | 19.2682 | 19.2682 | 19.2682 | 2800.0 |
| 2012-12-13 04:25:00 | AAPL | Stock | 19.2739 | 19.2739 | 19.2739 | 19.2739 | 2800.0 |
| 2012-12-13 04:40:00 | AAPL | Stock | 19.2346 | 19.2346 | 19.2346 | 19.2346 | 2800.0 |
| 2012-12-13 05:15:00 | AAPL | Stock | 19.2146 | 19.2146 | 19.2146 | 19.2146 | 2800.0 |
| 2012-12-13 05:25:00 | AAPL | Stock | 19.1993 | 19.1993 | 19.1993 | 19.1993 | 2800.0 |
| 2012-12-13 05:40:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 8400.0 |
| 2012-12-13 05:45:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 32760.0 |
| 2012-12-13 05:50:00 | AAPL | Stock | 19.1954 | 19.1964 | 19.1929 | 19.1964 | 8400.0 |
| 2012-12-13 06:00:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 2800.0 |
| 2012-12-13 06:05:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1786 | 19.1786 | 9520.0 |
| 2012-12-13 06:20:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 14000.0 |
| 2012-12-13 06:25:00 | AAPL | Stock | 19.1821 | 19.1821 | 19.1821 | 19.1821 | 26320.0 |
| 2012-12-13 06:35:00 | AAPL | Stock | 19.1607 | 19.1607 | 19.1607 | 19.1607 | 2800.0 |
| 2012-12-13 06:40:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1429 | 19.1429 | 35532.0 |
| 2012-12-13 06:50:00 | AAPL | Stock | 19.1571 | 19.1607 | 19.1571 | 19.1607 | 5600.0 |
| 2012-12-13 06:55:00 | AAPL | Stock | 19.1596 | 19.1607 | 19.1596 | 19.1607 | 9520.0 |
| 2012-12-13 07:00:00 | AAPL | Stock | 19.1464 | 19.1607 | 19.1464 | 19.1607 | 8400.0 |
| 2012-12-13 07:05:00 | AAPL | Stock | 19.1686 | 19.1789 | 19.16 | 19.1786 | 128828.0 |
| 2012-12-13 07:10:00 | AAPL | Stock | 19.1821 | 19.1821 | 19.1796 | 19.1796 | 26600.0 |
| 2012-12-13 07:15:00 | AAPL | Stock | 19.1796 | 19.2036 | 19.1796 | 19.2004 | 15400.0 |
| 2012-12-13 07:20:00 | AAPL | Stock | 19.2118 | 19.2143 | 19.1843 | 19.1961 | 39424.0 |
| 2012-12-13 07:25:00 | AAPL | Stock | 19.1932 | 19.21 | 19.1932 | 19.21 | 8400.0 |
| 2012-12-13 07:35:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 2800.0 |
| 2012-12-13 07:40:00 | AAPL | Stock | 19.2025 | 19.2057 | 19.1796 | 19.1796 | 78932.0 |
| 2012-12-13 07:45:00 | AAPL | Stock | 19.1839 | 19.1982 | 19.1618 | 19.1618 | 77000.0 |
| 2012-12-13 07:50:00 | AAPL | Stock | 19.1607 | 19.175 | 19.1607 | 19.175 | 28000.0 |
| 2012-12-13 07:55:00 | AAPL | Stock | 19.1771 | 19.1786 | 19.15 | 19.1586 | 46200.0 |
| 2012-12-13 08:00:00 | AAPL | Stock | 19.1614 | 19.2143 | 19.1304 | 19.1611 | 357868.0 |
| 2012-12-13 08:05:00 | AAPL | Stock | 19.1489 | 19.1743 | 19.1489 | 19.1539 | 288820.0 |
| 2012-12-13 08:10:00 | AAPL | Stock | 19.1604 | 19.1707 | 19.1571 | 19.1646 | 98168.0 |
| 2012-12-13 08:15:00 | AAPL | Stock | 19.1696 | 19.1711 | 19.1429 | 19.1429 | 135072.0 |
| 2012-12-13 08:20:00 | AAPL | Stock | 19.1371 | 19.1464 | 19.1371 | 19.1429 | 72352.0 |
| 2012-12-13 08:25:00 | AAPL | Stock | 19.1379 | 19.1379 | 19.0357 | 19.0893 | 1192632.0 |
| 2012-12-13 08:30:00 | AAPL | Stock | 19.0929 | 19.1243 | 19.0286 | 19.0286 | 2312996.0 |
| 2012-12-13 08:35:00 | AAPL | Stock | 19.0286 | 19.0357 | 19.0071 | 19.0132 | 1541624.0 |
| 2012-12-13 08:40:00 | AAPL | Stock | 19.0132 | 19.0357 | 18.9643 | 18.9821 | 1411312.0 |
| 2012-12-13 08:45:00 | AAPL | Stock | 18.9821 | 18.9911 | 18.905 | 18.9286 | 1923684.0 |
| 2012-12-13 08:50:00 | AAPL | Stock | 18.9286 | 18.9582 | 18.8857 | 18.9107 | 1208872.0 |
| 2012-12-13 08:55:00 | AAPL | Stock | 18.9107 | 18.9396 | 18.89 | 18.9193 | 790664.0 |
| 2012-12-13 09:00:00 | AAPL | Stock | 18.9282 | 18.9946 | 18.9282 | 18.9714 | 599032.0 |
| 2012-12-13 09:05:00 | AAPL | Stock | 18.9661 | 18.9918 | 18.9643 | 18.9686 | 537264.0 |
| 2012-12-13 09:10:00 | AAPL | Stock | 18.9679 | 18.9771 | 18.9132 | 18.93 | 811412.0 |
| 2012-12-13 09:15:00 | AAPL | Stock | 18.9286 | 18.9518 | 18.9286 | 18.9464 | 724388.0 |
| 2012-12-13 09:20:00 | AAPL | Stock | 18.9464 | 18.9643 | 18.9357 | 18.9625 | 952308.0 |
| 2012-12-13 09:25:00 | AAPL | Stock | 18.9632 | 18.9829 | 18.9579 | 18.9661 | 495068.0 |
| 2012-12-13 09:30:00 | AAPL | Stock | 18.9682 | 19.1189 | 18.9161 | 19.1154 | 30333856.0 |
| 2012-12-13 09:35:00 | AAPL | Stock | 19.1164 | 19.1357 | 19.0068 | 19.0357 | 16944060.0 |
| 2012-12-13 09:40:00 | AAPL | Stock | 19.0332 | 19.0357 | 18.9036 | 18.9536 | 21371448.0 |
| 2012-12-13 09:45:00 | AAPL | Stock | 18.9618 | 19.0179 | 18.9393 | 18.968 | 13512856.0 |
| 2012-12-13 09:50:00 | AAPL | Stock | 18.9704 | 19.0264 | 18.9521 | 18.9589 | 11141340.0 |
> showing 50 of 318,417 rows — these rows as CSV