PREVIEW / stock_5min / 2013-09-10
file: by_date/stock_5min/2013/2013-09-10.parquet size: 5.3 MB rows: 350,638 symbols: 3,533
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-09-10 04:00:00 | AAPL | Stock | 18.0714 | 18.1786 | 18.0714 | 18.1786 | 25200.0 |
| 2013-09-10 04:05:00 | AAPL | Stock | 18.1857 | 18.1857 | 18.1857 | 18.1857 | 5600.0 |
| 2013-09-10 04:10:00 | AAPL | Stock | 18.1786 | 18.1786 | 18.1786 | 18.1786 | 13496.0 |
| 2013-09-10 04:20:00 | AAPL | Stock | 18.1786 | 18.1786 | 18.1786 | 18.1786 | 2800.0 |
| 2013-09-10 04:30:00 | AAPL | Stock | 18.1875 | 18.1886 | 18.1875 | 18.1886 | 5600.0 |
| 2013-09-10 04:45:00 | AAPL | Stock | 18.1886 | 18.1929 | 18.1886 | 18.1929 | 64400.0 |
| 2013-09-10 04:50:00 | AAPL | Stock | 18.1786 | 18.1929 | 18.1714 | 18.1929 | 32368.0 |
| 2013-09-10 05:05:00 | AAPL | Stock | 18.1714 | 18.1714 | 18.1607 | 18.1607 | 117600.0 |
| 2013-09-10 05:10:00 | AAPL | Stock | 18.1607 | 18.1607 | 18.1429 | 18.1429 | 22400.0 |
| 2013-09-10 05:20:00 | AAPL | Stock | 18.1518 | 18.1518 | 18.1518 | 18.1518 | 3220.0 |
| 2013-09-10 05:30:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 8400.0 |
| 2013-09-10 05:35:00 | AAPL | Stock | 18.1557 | 18.1557 | 18.1557 | 18.1557 | 2800.0 |
| 2013-09-10 05:40:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 8400.0 |
| 2013-09-10 05:50:00 | AAPL | Stock | 18.145 | 18.145 | 18.1429 | 18.1429 | 11200.0 |
| 2013-09-10 05:55:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1304 | 18.1304 | 16800.0 |
| 2013-09-10 06:00:00 | AAPL | Stock | 18.1368 | 18.1368 | 18.1368 | 18.1368 | 7840.0 |
| 2013-09-10 06:05:00 | AAPL | Stock | 18.1368 | 18.145 | 18.1368 | 18.145 | 30632.0 |
| 2013-09-10 06:10:00 | AAPL | Stock | 18.1557 | 18.1607 | 18.1557 | 18.1607 | 36400.0 |
| 2013-09-10 06:30:00 | AAPL | Stock | 18.1607 | 18.1696 | 18.1607 | 18.1607 | 16800.0 |
| 2013-09-10 06:35:00 | AAPL | Stock | 18.1607 | 18.1607 | 18.1607 | 18.1607 | 19404.0 |
| 2013-09-10 06:45:00 | AAPL | Stock | 18.1732 | 18.1732 | 18.1732 | 18.1732 | 2800.0 |
| 2013-09-10 06:50:00 | AAPL | Stock | 18.1607 | 18.1614 | 18.16 | 18.16 | 52892.0 |
| 2013-09-10 06:55:00 | AAPL | Stock | 18.1607 | 18.1607 | 18.1607 | 18.1607 | 2800.0 |
| 2013-09-10 07:00:00 | AAPL | Stock | 18.1468 | 18.1518 | 18.1436 | 18.1446 | 67760.0 |
| 2013-09-10 07:05:00 | AAPL | Stock | 18.1439 | 18.1479 | 18.125 | 18.1479 | 144172.0 |
| 2013-09-10 07:10:00 | AAPL | Stock | 18.1521 | 18.1661 | 18.1436 | 18.1661 | 43876.0 |
| 2013-09-10 07:15:00 | AAPL | Stock | 18.1661 | 18.1743 | 18.1536 | 18.1607 | 69888.0 |
| 2013-09-10 07:20:00 | AAPL | Stock | 18.1643 | 18.1643 | 18.1518 | 18.1536 | 73920.0 |
| 2013-09-10 07:25:00 | AAPL | Stock | 18.1636 | 18.1636 | 18.1589 | 18.1589 | 30716.0 |
| 2013-09-10 07:30:00 | AAPL | Stock | 18.1536 | 18.1625 | 18.145 | 18.145 | 21000.0 |
| 2013-09-10 07:35:00 | AAPL | Stock | 18.1543 | 18.1643 | 18.1536 | 18.1604 | 147056.0 |
| 2013-09-10 07:40:00 | AAPL | Stock | 18.1607 | 18.1696 | 18.1607 | 18.1696 | 78540.0 |
| 2013-09-10 07:45:00 | AAPL | Stock | 18.1711 | 18.175 | 18.1661 | 18.1732 | 180460.0 |
| 2013-09-10 07:50:00 | AAPL | Stock | 18.1732 | 18.1757 | 18.1696 | 18.1696 | 132412.0 |
| 2013-09-10 07:55:00 | AAPL | Stock | 18.1757 | 18.1929 | 18.1714 | 18.1804 | 283304.0 |
| 2013-09-10 08:00:00 | AAPL | Stock | 18.1804 | 18.1943 | 18.125 | 18.1857 | 834232.0 |
| 2013-09-10 08:05:00 | AAPL | Stock | 18.1829 | 18.1839 | 18.145 | 18.145 | 512708.0 |
| 2013-09-10 08:10:00 | AAPL | Stock | 18.1568 | 18.1571 | 18.1496 | 18.1571 | 120120.0 |
| 2013-09-10 08:15:00 | AAPL | Stock | 18.1571 | 18.1629 | 18.1511 | 18.1529 | 231084.0 |
| 2013-09-10 08:20:00 | AAPL | Stock | 18.1529 | 18.1664 | 18.1529 | 18.16 | 353752.0 |
| 2013-09-10 08:25:00 | AAPL | Stock | 18.1604 | 18.1636 | 18.1571 | 18.1571 | 301924.0 |
| 2013-09-10 08:30:00 | AAPL | Stock | 18.1589 | 18.16 | 18.1536 | 18.1571 | 189756.0 |
| 2013-09-10 08:35:00 | AAPL | Stock | 18.1604 | 18.1604 | 18.1532 | 18.1554 | 67200.0 |
| 2013-09-10 08:40:00 | AAPL | Stock | 18.1564 | 18.1564 | 18.1321 | 18.1343 | 343196.0 |
| 2013-09-10 08:45:00 | AAPL | Stock | 18.1346 | 18.1404 | 18.0932 | 18.1064 | 591584.0 |
| 2013-09-10 08:50:00 | AAPL | Stock | 18.1064 | 18.125 | 18.1004 | 18.1214 | 296268.0 |
| 2013-09-10 08:55:00 | AAPL | Stock | 18.1268 | 18.1371 | 18.1179 | 18.1214 | 267176.0 |
| 2013-09-10 09:00:00 | AAPL | Stock | 18.13 | 18.13 | 18.1132 | 18.1179 | 225344.0 |
| 2013-09-10 09:05:00 | AAPL | Stock | 18.1129 | 18.1214 | 18.1125 | 18.1214 | 181384.0 |
| 2013-09-10 09:10:00 | AAPL | Stock | 18.1214 | 18.1246 | 18.1114 | 18.1114 | 82600.0 |
> showing 50 of 350,638 rows — these rows as CSV