PREVIEW / stock_5min / 2013-06-04
file: by_date/stock_5min/2013/2013-06-04.parquet size: 5.2 MB rows: 347,361 symbols: 3,502
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-06-04 04:00:00 | AAPL | Stock | 16.1229 | 16.1229 | 16.1229 | 16.1229 | 11200.0 |
| 2013-06-04 04:10:00 | AAPL | Stock | 16.1268 | 16.1268 | 16.125 | 16.125 | 7000.0 |
| 2013-06-04 04:15:00 | AAPL | Stock | 16.125 | 16.125 | 16.125 | 16.125 | 2800.0 |
| 2013-06-04 06:50:00 | AAPL | Stock | 16.1071 | 16.1071 | 16.1071 | 16.1071 | 2800.0 |
| 2013-06-04 06:55:00 | AAPL | Stock | 16.0982 | 16.1004 | 16.0982 | 16.1004 | 5600.0 |
| 2013-06-04 07:00:00 | AAPL | Stock | 16.1079 | 16.1079 | 16.1071 | 16.1071 | 8400.0 |
| 2013-06-04 07:05:00 | AAPL | Stock | 16.1125 | 16.125 | 16.1125 | 16.125 | 16800.0 |
| 2013-06-04 07:10:00 | AAPL | Stock | 16.125 | 16.1429 | 16.125 | 16.1304 | 58800.0 |
| 2013-06-04 07:15:00 | AAPL | Stock | 16.1436 | 16.1529 | 16.1339 | 16.1429 | 49000.0 |
| 2013-06-04 07:20:00 | AAPL | Stock | 16.1518 | 16.1714 | 16.1518 | 16.1607 | 173348.0 |
| 2013-06-04 07:25:00 | AAPL | Stock | 16.1721 | 16.1907 | 16.1696 | 16.1764 | 59640.0 |
| 2013-06-04 07:30:00 | AAPL | Stock | 16.1632 | 16.1904 | 16.1607 | 16.1904 | 217700.0 |
| 2013-06-04 07:35:00 | AAPL | Stock | 16.1818 | 16.1918 | 16.1721 | 16.1721 | 41720.0 |
| 2013-06-04 07:40:00 | AAPL | Stock | 16.1704 | 16.1704 | 16.1696 | 16.1696 | 19600.0 |
| 2013-06-04 07:45:00 | AAPL | Stock | 16.1782 | 16.1782 | 16.1782 | 16.1782 | 8400.0 |
| 2013-06-04 07:50:00 | AAPL | Stock | 16.1661 | 16.1661 | 16.1604 | 16.1604 | 14000.0 |
| 2013-06-04 07:55:00 | AAPL | Stock | 16.1693 | 16.1786 | 16.1639 | 16.1786 | 47600.0 |
| 2013-06-04 08:00:00 | AAPL | Stock | 16.175 | 16.1929 | 16.0714 | 16.1893 | 475944.0 |
| 2013-06-04 08:05:00 | AAPL | Stock | 16.1804 | 16.2139 | 16.1789 | 16.2139 | 309456.0 |
| 2013-06-04 08:10:00 | AAPL | Stock | 16.2082 | 16.2089 | 16.1939 | 16.1964 | 175840.0 |
| 2013-06-04 08:15:00 | AAPL | Stock | 16.2029 | 16.2032 | 16.1911 | 16.1911 | 78400.0 |
| 2013-06-04 08:20:00 | AAPL | Stock | 16.1964 | 16.2082 | 16.1964 | 16.1968 | 79296.0 |
| 2013-06-04 08:25:00 | AAPL | Stock | 16.1968 | 16.225 | 16.1968 | 16.2175 | 382480.0 |
| 2013-06-04 08:30:00 | AAPL | Stock | 16.2214 | 16.2214 | 16.1971 | 16.2114 | 207116.0 |
| 2013-06-04 08:35:00 | AAPL | Stock | 16.21 | 16.2214 | 16.2075 | 16.2136 | 179032.0 |
| 2013-06-04 08:40:00 | AAPL | Stock | 16.2071 | 16.2121 | 16.1964 | 16.1964 | 77840.0 |
| 2013-06-04 08:45:00 | AAPL | Stock | 16.1968 | 16.2004 | 16.1929 | 16.1961 | 49784.0 |
| 2013-06-04 08:50:00 | AAPL | Stock | 16.2 | 16.2 | 16.1879 | 16.1879 | 154252.0 |
| 2013-06-04 08:55:00 | AAPL | Stock | 16.1868 | 16.1893 | 16.1821 | 16.1879 | 103432.0 |
| 2013-06-04 09:00:00 | AAPL | Stock | 16.1936 | 16.1939 | 16.1804 | 16.1804 | 98000.0 |
| 2013-06-04 09:05:00 | AAPL | Stock | 16.1864 | 16.1879 | 16.1786 | 16.1786 | 225204.0 |
| 2013-06-04 09:10:00 | AAPL | Stock | 16.1825 | 16.1857 | 16.1821 | 16.1836 | 55972.0 |
| 2013-06-04 09:15:00 | AAPL | Stock | 16.1829 | 16.1871 | 16.1821 | 16.1829 | 60760.0 |
| 2013-06-04 09:20:00 | AAPL | Stock | 16.1821 | 16.2021 | 16.1821 | 16.1875 | 322980.0 |
| 2013-06-04 09:25:00 | AAPL | Stock | 16.1946 | 16.1996 | 16.1821 | 16.1857 | 189588.0 |
| 2013-06-04 09:30:00 | AAPL | Stock | 16.1907 | 16.2224 | 16.1475 | 16.1818 | 13408864.0 |
| 2013-06-04 09:35:00 | AAPL | Stock | 16.1841 | 16.1904 | 16.1429 | 16.15 | 8423772.0 |
| 2013-06-04 09:40:00 | AAPL | Stock | 16.1493 | 16.1646 | 16.1004 | 16.1225 | 7835716.0 |
| 2013-06-04 09:45:00 | AAPL | Stock | 16.1225 | 16.155 | 16.1011 | 16.1479 | 5855304.0 |
| 2013-06-04 09:50:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.0989 | 16.1336 | 4389448.0 |
| 2013-06-04 09:55:00 | AAPL | Stock | 16.1354 | 16.1818 | 16.1304 | 16.1721 | 6111896.0 |
| 2013-06-04 10:00:00 | AAPL | Stock | 16.175 | 16.1842 | 16.1482 | 16.1607 | 3160108.0 |
| 2013-06-04 10:05:00 | AAPL | Stock | 16.1607 | 16.1753 | 16.1386 | 16.157 | 3564176.0 |
| 2013-06-04 10:10:00 | AAPL | Stock | 16.155 | 16.1654 | 16.1386 | 16.145 | 3323432.0 |
| 2013-06-04 10:15:00 | AAPL | Stock | 16.1475 | 16.1643 | 16.1318 | 16.1582 | 3246908.0 |
| 2013-06-04 10:20:00 | AAPL | Stock | 16.1575 | 16.1964 | 16.1389 | 16.1957 | 5052152.0 |
| 2013-06-04 10:25:00 | AAPL | Stock | 16.1932 | 16.2118 | 16.175 | 16.205 | 4809196.0 |
| 2013-06-04 10:30:00 | AAPL | Stock | 16.2025 | 16.2296 | 16.1971 | 16.225 | 7700280.0 |
| 2013-06-04 10:35:00 | AAPL | Stock | 16.2251 | 16.2279 | 16.2011 | 16.2061 | 4905208.0 |
| 2013-06-04 10:40:00 | AAPL | Stock | 16.205 | 16.2254 | 16.2 | 16.2046 | 2407468.0 |
> showing 50 of 347,361 rows — these rows as CSV