PREVIEW / stock_5min / 2014-05-02
file: by_date/stock_5min/2014/2014-05-02.parquet size: 5.3 MB rows: 354,434 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 |
|---|---|---|---|---|---|---|---|
| 2014-05-02 04:00:00 | AAPL | Stock | 21.1429 | 21.1429 | 21.1429 | 21.1429 | 5600.0 |
| 2014-05-02 06:15:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 2800.0 |
| 2014-05-02 06:55:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 2800.0 |
| 2014-05-02 07:00:00 | AAPL | Stock | 21.1768 | 21.1768 | 21.1714 | 21.1714 | 27468.0 |
| 2014-05-02 07:05:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 2800.0 |
| 2014-05-02 07:10:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 9212.0 |
| 2014-05-02 07:15:00 | AAPL | Stock | 21.1643 | 21.1643 | 21.1643 | 21.1643 | 12040.0 |
| 2014-05-02 07:25:00 | AAPL | Stock | 21.1643 | 21.1643 | 21.1643 | 21.1643 | 2800.0 |
| 2014-05-02 07:30:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 18200.0 |
| 2014-05-02 07:35:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 2800.0 |
| 2014-05-02 07:40:00 | AAPL | Stock | 21.1693 | 21.1693 | 21.1693 | 21.1693 | 2800.0 |
| 2014-05-02 07:50:00 | AAPL | Stock | 21.1686 | 21.1696 | 21.1686 | 21.1696 | 18200.0 |
| 2014-05-02 08:00:00 | AAPL | Stock | 21.1611 | 21.1696 | 21.1429 | 21.1607 | 86128.0 |
| 2014-05-02 08:05:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1475 | 21.1557 | 57736.0 |
| 2014-05-02 08:10:00 | AAPL | Stock | 21.1582 | 21.1604 | 21.1564 | 21.1564 | 15736.0 |
| 2014-05-02 08:15:00 | AAPL | Stock | 21.1593 | 21.1604 | 21.1593 | 21.1604 | 5600.0 |
| 2014-05-02 08:25:00 | AAPL | Stock | 21.16 | 21.1743 | 21.1514 | 21.1611 | 34440.0 |
| 2014-05-02 08:30:00 | AAPL | Stock | 21.1604 | 21.2107 | 21.1604 | 21.19 | 173236.0 |
| 2014-05-02 08:35:00 | AAPL | Stock | 21.1789 | 21.1789 | 21.1607 | 21.1693 | 120512.0 |
| 2014-05-02 08:40:00 | AAPL | Stock | 21.1693 | 21.1696 | 21.165 | 21.1696 | 19516.0 |
| 2014-05-02 08:45:00 | AAPL | Stock | 21.1829 | 21.1857 | 21.1829 | 21.1857 | 19432.0 |
| 2014-05-02 08:50:00 | AAPL | Stock | 21.1893 | 21.1925 | 21.1821 | 21.1925 | 14140.0 |
| 2014-05-02 08:55:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1639 | 21.1639 | 102508.0 |
| 2014-05-02 09:00:00 | AAPL | Stock | 21.1646 | 21.1714 | 21.1511 | 21.1546 | 156324.0 |
| 2014-05-02 09:05:00 | AAPL | Stock | 21.1546 | 21.1679 | 21.1546 | 21.1679 | 57904.0 |
| 2014-05-02 09:10:00 | AAPL | Stock | 21.1679 | 21.1761 | 21.1679 | 21.1761 | 30800.0 |
| 2014-05-02 09:15:00 | AAPL | Stock | 21.1696 | 21.175 | 21.1654 | 21.1654 | 42000.0 |
| 2014-05-02 09:20:00 | AAPL | Stock | 21.1754 | 21.1761 | 21.1704 | 21.1761 | 20216.0 |
| 2014-05-02 09:25:00 | AAPL | Stock | 21.1657 | 21.1786 | 21.1561 | 21.1654 | 192444.0 |
| 2014-05-02 09:30:00 | AAPL | Stock | 21.155 | 21.175 | 21.0911 | 21.1121 | 9338756.0 |
| 2014-05-02 09:35:00 | AAPL | Stock | 21.1125 | 21.2014 | 21.1054 | 21.2 | 4897060.0 |
| 2014-05-02 09:40:00 | AAPL | Stock | 21.2 | 21.2214 | 21.1607 | 21.1632 | 5737480.0 |
| 2014-05-02 09:45:00 | AAPL | Stock | 21.1636 | 21.185 | 21.1296 | 21.1416 | 3703196.0 |
| 2014-05-02 09:50:00 | AAPL | Stock | 21.14 | 21.155 | 21.0918 | 21.125 | 4307688.0 |
| 2014-05-02 09:55:00 | AAPL | Stock | 21.1236 | 21.1705 | 21.1086 | 21.1529 | 3564176.0 |
| 2014-05-02 10:00:00 | AAPL | Stock | 21.1489 | 21.1825 | 21.1161 | 21.1761 | 3299548.0 |
| 2014-05-02 10:05:00 | AAPL | Stock | 21.1746 | 21.1964 | 21.1533 | 21.1828 | 2184616.0 |
| 2014-05-02 10:10:00 | AAPL | Stock | 21.185 | 21.1961 | 21.1607 | 21.1843 | 2171484.0 |
| 2014-05-02 10:15:00 | AAPL | Stock | 21.1868 | 21.1921 | 21.1768 | 21.1832 | 1773380.0 |
| 2014-05-02 10:20:00 | AAPL | Stock | 21.1839 | 21.1857 | 21.1693 | 21.1814 | 1821092.0 |
| 2014-05-02 10:25:00 | AAPL | Stock | 21.1786 | 21.1946 | 21.1518 | 21.1586 | 1879780.0 |
| 2014-05-02 10:30:00 | AAPL | Stock | 21.1536 | 21.1657 | 21.1389 | 21.1657 | 1501864.0 |
| 2014-05-02 10:35:00 | AAPL | Stock | 21.1661 | 21.1707 | 21.1514 | 21.1582 | 1139292.0 |
| 2014-05-02 10:40:00 | AAPL | Stock | 21.1579 | 21.1664 | 21.1071 | 21.1246 | 3285912.0 |
| 2014-05-02 10:45:00 | AAPL | Stock | 21.1211 | 21.1275 | 21.0625 | 21.0739 | 4328884.0 |
| 2014-05-02 10:50:00 | AAPL | Stock | 21.0646 | 21.1057 | 21.0611 | 21.0936 | 3397828.0 |
| 2014-05-02 10:55:00 | AAPL | Stock | 21.0921 | 21.1339 | 21.0871 | 21.1164 | 2442692.0 |
| 2014-05-02 11:00:00 | AAPL | Stock | 21.115 | 21.1464 | 21.1114 | 21.1368 | 1798832.0 |
| 2014-05-02 11:05:00 | AAPL | Stock | 21.1368 | 21.1393 | 21.1164 | 21.1179 | 948388.0 |
| 2014-05-02 11:10:00 | AAPL | Stock | 21.12 | 21.1286 | 21.1029 | 21.112 | 1080100.0 |
> showing 50 of 354,434 rows — these rows as CSV