PREVIEW / stock_5min / 2014-04-30
file: by_date/stock_5min/2014/2014-04-30.parquet size: 5.5 MB rows: 365,216 symbols: 3,555
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-04-30 04:35:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2014-04-30 04:40:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 2800.0 |
| 2014-04-30 05:30:00 | AAPL | Stock | 21.0857 | 21.0857 | 21.0857 | 21.0857 | 12880.0 |
| 2014-04-30 05:45:00 | AAPL | Stock | 21.0829 | 21.0829 | 21.0829 | 21.0829 | 14000.0 |
| 2014-04-30 05:50:00 | AAPL | Stock | 21.0721 | 21.0721 | 21.0721 | 21.0721 | 2800.0 |
| 2014-04-30 06:00:00 | AAPL | Stock | 21.0736 | 21.0736 | 21.0736 | 21.0736 | 2800.0 |
| 2014-04-30 06:15:00 | AAPL | Stock | 21.1036 | 21.1071 | 21.1036 | 21.1071 | 31668.0 |
| 2014-04-30 06:40:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 3220.0 |
| 2014-04-30 06:45:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 11004.0 |
| 2014-04-30 06:50:00 | AAPL | Stock | 21.1286 | 21.1286 | 21.1286 | 21.1286 | 2800.0 |
| 2014-04-30 07:00:00 | AAPL | Stock | 21.1246 | 21.1282 | 21.1186 | 21.125 | 64316.0 |
| 2014-04-30 07:05:00 | AAPL | Stock | 21.115 | 21.115 | 21.115 | 21.115 | 3920.0 |
| 2014-04-30 07:15:00 | AAPL | Stock | 21.1071 | 21.1089 | 21.0946 | 21.1089 | 55412.0 |
| 2014-04-30 07:20:00 | AAPL | Stock | 21.1236 | 21.1339 | 21.1218 | 21.1218 | 39200.0 |
| 2014-04-30 07:30:00 | AAPL | Stock | 21.1425 | 21.1536 | 21.1425 | 21.1461 | 57596.0 |
| 2014-04-30 07:35:00 | AAPL | Stock | 21.1464 | 21.2143 | 21.1432 | 21.2143 | 274344.0 |
| 2014-04-30 07:40:00 | AAPL | Stock | 21.2093 | 21.2093 | 21.1821 | 21.1964 | 100072.0 |
| 2014-04-30 07:45:00 | AAPL | Stock | 21.1921 | 21.1964 | 21.1921 | 21.1964 | 44240.0 |
| 2014-04-30 07:50:00 | AAPL | Stock | 21.1964 | 21.1968 | 21.1954 | 21.1954 | 109228.0 |
| 2014-04-30 07:55:00 | AAPL | Stock | 21.1961 | 21.2343 | 21.1961 | 21.2282 | 191072.0 |
| 2014-04-30 08:00:00 | AAPL | Stock | 21.2146 | 21.2146 | 21.1593 | 21.1607 | 298256.0 |
| 2014-04-30 08:05:00 | AAPL | Stock | 21.1621 | 21.1786 | 21.1621 | 21.1764 | 65800.0 |
| 2014-04-30 08:10:00 | AAPL | Stock | 21.1786 | 21.2143 | 21.1696 | 21.2143 | 214480.0 |
| 2014-04-30 08:15:00 | AAPL | Stock | 21.2143 | 21.2321 | 21.2089 | 21.2314 | 278488.0 |
| 2014-04-30 08:20:00 | AAPL | Stock | 21.2314 | 21.2568 | 21.2268 | 21.2471 | 215572.0 |
| 2014-04-30 08:25:00 | AAPL | Stock | 21.25 | 21.25 | 21.2321 | 21.2321 | 105952.0 |
| 2014-04-30 08:30:00 | AAPL | Stock | 21.22 | 21.2279 | 21.2 | 21.2171 | 129388.0 |
| 2014-04-30 08:35:00 | AAPL | Stock | 21.225 | 21.2286 | 21.2014 | 21.2157 | 232456.0 |
| 2014-04-30 08:40:00 | AAPL | Stock | 21.2118 | 21.2279 | 21.2118 | 21.2268 | 79100.0 |
| 2014-04-30 08:45:00 | AAPL | Stock | 21.2214 | 21.2243 | 21.1914 | 21.1954 | 139804.0 |
| 2014-04-30 08:50:00 | AAPL | Stock | 21.2125 | 21.2129 | 21.2068 | 21.2068 | 11200.0 |
| 2014-04-30 08:55:00 | AAPL | Stock | 21.2036 | 21.2036 | 21.1939 | 21.1939 | 11200.0 |
| 2014-04-30 09:00:00 | AAPL | Stock | 21.1964 | 21.2018 | 21.1929 | 21.1996 | 50512.0 |
| 2014-04-30 09:05:00 | AAPL | Stock | 21.1936 | 21.1964 | 21.1786 | 21.1807 | 205968.0 |
| 2014-04-30 09:10:00 | AAPL | Stock | 21.1789 | 21.1957 | 21.1707 | 21.1857 | 126812.0 |
| 2014-04-30 09:15:00 | AAPL | Stock | 21.18 | 21.185 | 21.1714 | 21.1714 | 95200.0 |
| 2014-04-30 09:20:00 | AAPL | Stock | 21.1714 | 21.1718 | 21.1696 | 21.1696 | 69048.0 |
| 2014-04-30 09:25:00 | AAPL | Stock | 21.1743 | 21.1825 | 21.1464 | 21.1675 | 335608.0 |
| 2014-04-30 09:30:00 | AAPL | Stock | 21.1657 | 21.2446 | 21.1443 | 21.2371 | 11611712.0 |
| 2014-04-30 09:35:00 | AAPL | Stock | 21.2357 | 21.25 | 21.125 | 21.1371 | 8380176.0 |
| 2014-04-30 09:40:00 | AAPL | Stock | 21.1332 | 21.1936 | 21.1161 | 21.177 | 5895428.0 |
| 2014-04-30 09:45:00 | AAPL | Stock | 21.1746 | 21.205 | 21.1521 | 21.1554 | 4018000.0 |
| 2014-04-30 09:50:00 | AAPL | Stock | 21.1579 | 21.1886 | 21.1189 | 21.1461 | 4098696.0 |
| 2014-04-30 09:55:00 | AAPL | Stock | 21.1477 | 21.175 | 21.1318 | 21.1629 | 2612232.0 |
| 2014-04-30 10:00:00 | AAPL | Stock | 21.1643 | 21.1757 | 21.1436 | 21.1707 | 2165408.0 |
| 2014-04-30 10:05:00 | AAPL | Stock | 21.1725 | 21.21 | 21.1607 | 21.1982 | 3729824.0 |
| 2014-04-30 10:10:00 | AAPL | Stock | 21.1986 | 21.2357 | 21.1982 | 21.2307 | 4547788.0 |
| 2014-04-30 10:15:00 | AAPL | Stock | 21.2307 | 21.2839 | 21.2279 | 21.2614 | 8032640.0 |
| 2014-04-30 10:20:00 | AAPL | Stock | 21.2575 | 21.2696 | 21.24 | 21.2589 | 2750132.0 |
| 2014-04-30 10:25:00 | AAPL | Stock | 21.2575 | 21.2682 | 21.2346 | 21.2625 | 3018232.0 |
> showing 50 of 365,216 rows — these rows as CSV