PREVIEW / stock_5min / 2014-05-13
file: by_date/stock_5min/2014/2014-05-13.parquet size: 5.3 MB rows: 355,811 symbols: 3,551
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-05-13 04:40:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1804 | 21.1804 | 2800.0 |
| 2014-05-13 04:45:00 | AAPL | Stock | 21.1725 | 21.1725 | 21.1725 | 21.1725 | 2800.0 |
| 2014-05-13 04:50:00 | AAPL | Stock | 21.1836 | 21.1836 | 21.1836 | 21.1836 | 2800.0 |
| 2014-05-13 05:10:00 | AAPL | Stock | 21.1511 | 21.1511 | 21.1511 | 21.1511 | 9520.0 |
| 2014-05-13 05:35:00 | AAPL | Stock | 21.1929 | 21.1929 | 21.1929 | 21.1929 | 2800.0 |
| 2014-05-13 06:10:00 | AAPL | Stock | 21.1536 | 21.1536 | 21.1536 | 21.1536 | 8400.0 |
| 2014-05-13 06:20:00 | AAPL | Stock | 21.1464 | 21.1464 | 21.1464 | 21.1464 | 2800.0 |
| 2014-05-13 07:00:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 11760.0 |
| 2014-05-13 07:05:00 | AAPL | Stock | 21.1711 | 21.1711 | 21.1711 | 21.1711 | 11172.0 |
| 2014-05-13 07:25:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 2800.0 |
| 2014-05-13 07:30:00 | AAPL | Stock | 21.1857 | 21.1857 | 21.1818 | 21.1839 | 8400.0 |
| 2014-05-13 07:35:00 | AAPL | Stock | 21.1868 | 21.1868 | 21.1846 | 21.1846 | 16800.0 |
| 2014-05-13 07:40:00 | AAPL | Stock | 21.1868 | 21.1868 | 21.1786 | 21.185 | 20020.0 |
| 2014-05-13 07:45:00 | AAPL | Stock | 21.1786 | 21.1793 | 21.1679 | 21.1679 | 81172.0 |
| 2014-05-13 08:00:00 | AAPL | Stock | 21.1807 | 21.185 | 21.1582 | 21.1582 | 61180.0 |
| 2014-05-13 08:05:00 | AAPL | Stock | 21.1482 | 21.1586 | 21.1482 | 21.1564 | 11200.0 |
| 2014-05-13 08:10:00 | AAPL | Stock | 21.1564 | 21.1607 | 21.1518 | 21.1518 | 22400.0 |
| 2014-05-13 08:15:00 | AAPL | Stock | 21.15 | 21.15 | 21.1411 | 21.1425 | 82936.0 |
| 2014-05-13 08:20:00 | AAPL | Stock | 21.1411 | 21.1425 | 21.1229 | 21.1236 | 67200.0 |
| 2014-05-13 08:25:00 | AAPL | Stock | 21.1275 | 21.1296 | 21.1179 | 21.1296 | 67060.0 |
| 2014-05-13 08:30:00 | AAPL | Stock | 21.13 | 21.13 | 21.1071 | 21.125 | 128408.0 |
| 2014-05-13 08:35:00 | AAPL | Stock | 21.1236 | 21.1304 | 21.1196 | 21.1304 | 84000.0 |
| 2014-05-13 08:40:00 | AAPL | Stock | 21.1254 | 21.1271 | 21.1246 | 21.1271 | 30800.0 |
| 2014-05-13 08:45:00 | AAPL | Stock | 21.1286 | 21.1314 | 21.125 | 21.1314 | 29288.0 |
| 2014-05-13 08:50:00 | AAPL | Stock | 21.1264 | 21.1375 | 21.1264 | 21.1375 | 30800.0 |
| 2014-05-13 08:55:00 | AAPL | Stock | 21.1332 | 21.1332 | 21.1332 | 21.1332 | 2800.0 |
| 2014-05-13 09:00:00 | AAPL | Stock | 21.1425 | 21.1425 | 21.1421 | 21.1421 | 8400.0 |
| 2014-05-13 09:05:00 | AAPL | Stock | 21.1421 | 21.1432 | 21.1421 | 21.1432 | 30436.0 |
| 2014-05-13 09:10:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1396 | 21.1404 | 58800.0 |
| 2014-05-13 09:20:00 | AAPL | Stock | 21.1393 | 21.1421 | 21.1393 | 21.1421 | 14000.0 |
| 2014-05-13 09:25:00 | AAPL | Stock | 21.1421 | 21.1536 | 21.1346 | 21.1411 | 114744.0 |
| 2014-05-13 09:30:00 | AAPL | Stock | 21.1429 | 21.1689 | 21.1182 | 21.1277 | 6148912.0 |
| 2014-05-13 09:35:00 | AAPL | Stock | 21.1375 | 21.16 | 21.0964 | 21.1568 | 4172224.0 |
| 2014-05-13 09:40:00 | AAPL | Stock | 21.1564 | 21.1785 | 21.1339 | 21.17 | 3552472.0 |
| 2014-05-13 09:45:00 | AAPL | Stock | 21.1711 | 21.1875 | 21.1607 | 21.1707 | 3714760.0 |
| 2014-05-13 09:50:00 | AAPL | Stock | 21.1711 | 21.1732 | 21.1061 | 21.1187 | 3569664.0 |
| 2014-05-13 09:55:00 | AAPL | Stock | 21.1157 | 21.1261 | 21.1 | 21.1196 | 2926532.0 |
| 2014-05-13 10:00:00 | AAPL | Stock | 21.1211 | 21.1582 | 21.1079 | 21.1571 | 2079280.0 |
| 2014-05-13 10:05:00 | AAPL | Stock | 21.1571 | 21.1761 | 21.1435 | 21.1761 | 1921304.0 |
| 2014-05-13 10:10:00 | AAPL | Stock | 21.1764 | 21.1946 | 21.1582 | 21.1879 | 3266060.0 |
| 2014-05-13 10:15:00 | AAPL | Stock | 21.1907 | 21.2054 | 21.1718 | 21.1775 | 2885428.0 |
| 2014-05-13 10:20:00 | AAPL | Stock | 21.1811 | 21.1989 | 21.1518 | 21.1539 | 1888992.0 |
| 2014-05-13 10:25:00 | AAPL | Stock | 21.1546 | 21.1757 | 21.1525 | 21.1525 | 1113644.0 |
| 2014-05-13 10:30:00 | AAPL | Stock | 21.1518 | 21.1639 | 21.1293 | 21.1346 | 2008636.0 |
| 2014-05-13 10:35:00 | AAPL | Stock | 21.1379 | 21.1757 | 21.1379 | 21.1679 | 1578528.0 |
| 2014-05-13 10:40:00 | AAPL | Stock | 21.1696 | 21.1929 | 21.1646 | 21.1806 | 1373372.0 |
| 2014-05-13 10:45:00 | AAPL | Stock | 21.1716 | 21.1786 | 21.1629 | 21.1782 | 731416.0 |
| 2014-05-13 10:50:00 | AAPL | Stock | 21.1786 | 21.1836 | 21.1711 | 21.1821 | 861196.0 |
| 2014-05-13 10:55:00 | AAPL | Stock | 21.1832 | 21.1943 | 21.1529 | 21.1675 | 1540308.0 |
| 2014-05-13 11:00:00 | AAPL | Stock | 21.1679 | 21.1875 | 21.1614 | 21.1675 | 1210328.0 |
> showing 50 of 355,811 rows — these rows as CSV