PREVIEW / stock_5min / 2013-12-27
file: by_date/stock_5min/2013/2013-12-27.parquet size: 5.2 MB rows: 350,559 symbols: 3,531
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-12-27 04:25:00 | AAPL | Stock | 20.1643 | 20.1643 | 20.1643 | 20.1643 | 2800.0 |
| 2013-12-27 04:40:00 | AAPL | Stock | 20.1571 | 20.1571 | 20.1571 | 20.1571 | 2800.0 |
| 2013-12-27 04:45:00 | AAPL | Stock | 20.1625 | 20.1625 | 20.1625 | 20.1625 | 2800.0 |
| 2013-12-27 04:55:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1571 | 20.1571 | 5600.0 |
| 2013-12-27 05:00:00 | AAPL | Stock | 20.15 | 20.15 | 20.1482 | 20.1482 | 5600.0 |
| 2013-12-27 05:05:00 | AAPL | Stock | 20.1471 | 20.1471 | 20.1471 | 20.1471 | 5600.0 |
| 2013-12-27 05:10:00 | AAPL | Stock | 20.1482 | 20.1482 | 20.1482 | 20.1482 | 2800.0 |
| 2013-12-27 05:25:00 | AAPL | Stock | 20.1446 | 20.1446 | 20.1321 | 20.1321 | 11200.0 |
| 2013-12-27 05:35:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 2800.0 |
| 2013-12-27 05:40:00 | AAPL | Stock | 20.1314 | 20.1314 | 20.1179 | 20.1179 | 8400.0 |
| 2013-12-27 06:00:00 | AAPL | Stock | 20.1279 | 20.1279 | 20.1279 | 20.1279 | 2800.0 |
| 2013-12-27 06:35:00 | AAPL | Stock | 20.1554 | 20.1571 | 20.1554 | 20.1554 | 15400.0 |
| 2013-12-27 06:40:00 | AAPL | Stock | 20.1536 | 20.1536 | 20.1536 | 20.1536 | 2800.0 |
| 2013-12-27 06:55:00 | AAPL | Stock | 20.1661 | 20.1661 | 20.1621 | 20.1621 | 5600.0 |
| 2013-12-27 07:15:00 | AAPL | Stock | 20.1786 | 20.1821 | 20.16 | 20.1821 | 37436.0 |
| 2013-12-27 07:20:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 5600.0 |
| 2013-12-27 07:25:00 | AAPL | Stock | 20.1789 | 20.1789 | 20.1775 | 20.1775 | 5600.0 |
| 2013-12-27 07:30:00 | AAPL | Stock | 20.1811 | 20.1925 | 20.1811 | 20.1925 | 8400.0 |
| 2013-12-27 07:35:00 | AAPL | Stock | 20.1864 | 20.1864 | 20.1864 | 20.1864 | 2800.0 |
| 2013-12-27 07:40:00 | AAPL | Stock | 20.1771 | 20.1782 | 20.1771 | 20.1782 | 5600.0 |
| 2013-12-27 07:45:00 | AAPL | Stock | 20.1875 | 20.1875 | 20.1875 | 20.1875 | 7280.0 |
| 2013-12-27 07:50:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1893 | 20.1893 | 19600.0 |
| 2013-12-27 07:55:00 | AAPL | Stock | 20.1961 | 20.1961 | 20.1821 | 20.1821 | 17500.0 |
| 2013-12-27 08:00:00 | AAPL | Stock | 20.14 | 20.2143 | 20.14 | 20.1964 | 115892.0 |
| 2013-12-27 08:05:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1696 | 20.1696 | 22120.0 |
| 2013-12-27 08:10:00 | AAPL | Stock | 20.1607 | 20.1768 | 20.1607 | 20.1732 | 87500.0 |
| 2013-12-27 08:15:00 | AAPL | Stock | 20.1518 | 20.1632 | 20.1518 | 20.1632 | 8400.0 |
| 2013-12-27 08:20:00 | AAPL | Stock | 20.1575 | 20.1696 | 20.1575 | 20.1696 | 64288.0 |
| 2013-12-27 08:25:00 | AAPL | Stock | 20.175 | 20.175 | 20.1607 | 20.1625 | 70000.0 |
| 2013-12-27 08:30:00 | AAPL | Stock | 20.1561 | 20.1561 | 20.1429 | 20.1443 | 52108.0 |
| 2013-12-27 08:35:00 | AAPL | Stock | 20.1535 | 20.1535 | 20.1411 | 20.1411 | 22400.0 |
| 2013-12-27 08:40:00 | AAPL | Stock | 20.1368 | 20.1375 | 20.1286 | 20.1332 | 45948.0 |
| 2013-12-27 08:45:00 | AAPL | Stock | 20.1429 | 20.1493 | 20.1411 | 20.1411 | 41776.0 |
| 2013-12-27 08:50:00 | AAPL | Stock | 20.1443 | 20.1443 | 20.1393 | 20.1393 | 15736.0 |
| 2013-12-27 08:55:00 | AAPL | Stock | 20.1429 | 20.1446 | 20.1404 | 20.1446 | 15400.0 |
| 2013-12-27 09:05:00 | AAPL | Stock | 20.1447 | 20.1671 | 20.1447 | 20.1671 | 104664.0 |
| 2013-12-27 09:10:00 | AAPL | Stock | 20.1579 | 20.1661 | 20.1579 | 20.1661 | 36400.0 |
| 2013-12-27 09:15:00 | AAPL | Stock | 20.15 | 20.1596 | 20.15 | 20.15 | 19068.0 |
| 2013-12-27 09:20:00 | AAPL | Stock | 20.1571 | 20.1571 | 20.1425 | 20.1429 | 62608.0 |
| 2013-12-27 09:25:00 | AAPL | Stock | 20.1436 | 20.1529 | 20.1289 | 20.1289 | 185808.0 |
| 2013-12-27 09:30:00 | AAPL | Stock | 20.1389 | 20.1575 | 20.0639 | 20.125 | 10395700.0 |
| 2013-12-27 09:35:00 | AAPL | Stock | 20.1216 | 20.1239 | 20.0893 | 20.1014 | 5492060.0 |
| 2013-12-27 09:40:00 | AAPL | Stock | 20.0986 | 20.1536 | 20.0961 | 20.1007 | 6171424.0 |
| 2013-12-27 09:45:00 | AAPL | Stock | 20.1014 | 20.1207 | 20.0643 | 20.0668 | 5286820.0 |
| 2013-12-27 09:50:00 | AAPL | Stock | 20.0655 | 20.0893 | 20.0646 | 20.0718 | 4389560.0 |
| 2013-12-27 09:55:00 | AAPL | Stock | 20.0729 | 20.0733 | 20.0375 | 20.0432 | 6191136.0 |
| 2013-12-27 10:00:00 | AAPL | Stock | 20.0389 | 20.0804 | 20.0375 | 20.0789 | 4242028.0 |
| 2013-12-27 10:05:00 | AAPL | Stock | 20.0798 | 20.1032 | 20.0736 | 20.0821 | 3704064.0 |
| 2013-12-27 10:10:00 | AAPL | Stock | 20.0782 | 20.0811 | 20.0493 | 20.0544 | 2863448.0 |
| 2013-12-27 10:15:00 | AAPL | Stock | 20.0585 | 20.0761 | 20.0475 | 20.0532 | 3569888.0 |
> showing 50 of 350,559 rows — these rows as CSV