PREVIEW / stock_5min / 2011-09-06
file: by_date/stock_5min/2011/2011-09-06.parquet size: 4.9 MB rows: 338,663 symbols: 3,505
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-06 04:00:00 | AAPL | Stock | 13.2143 | 13.2811 | 13.165 | 13.2586 | 53060.0 |
| 2011-09-06 04:05:00 | AAPL | Stock | 13.2811 | 13.3025 | 13.2811 | 13.2857 | 42000.0 |
| 2011-09-06 04:10:00 | AAPL | Stock | 13.2857 | 13.2971 | 13.2857 | 13.2857 | 75600.0 |
| 2011-09-06 04:20:00 | AAPL | Stock | 13.2243 | 13.2457 | 13.2243 | 13.2457 | 11200.0 |
| 2011-09-06 04:25:00 | AAPL | Stock | 13.2357 | 13.2357 | 13.2357 | 13.2357 | 5600.0 |
| 2011-09-06 04:30:00 | AAPL | Stock | 13.2296 | 13.2296 | 13.2296 | 13.2296 | 2800.0 |
| 2011-09-06 05:00:00 | AAPL | Stock | 13.24 | 13.24 | 13.24 | 13.24 | 2800.0 |
| 2011-09-06 05:05:00 | AAPL | Stock | 13.2171 | 13.2171 | 13.2171 | 13.2171 | 5600.0 |
| 2011-09-06 05:10:00 | AAPL | Stock | 13.2379 | 13.2514 | 13.2379 | 13.2514 | 5600.0 |
| 2011-09-06 05:35:00 | AAPL | Stock | 13.2346 | 13.2346 | 13.2339 | 13.2339 | 5600.0 |
| 2011-09-06 05:55:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 8400.0 |
| 2011-09-06 06:00:00 | AAPL | Stock | 13.2661 | 13.2661 | 13.2661 | 13.2661 | 2800.0 |
| 2011-09-06 06:50:00 | AAPL | Stock | 13.2686 | 13.2696 | 13.2679 | 13.2679 | 8400.0 |
| 2011-09-06 06:55:00 | AAPL | Stock | 13.2554 | 13.2554 | 13.2554 | 13.2554 | 2940.0 |
| 2011-09-06 07:00:00 | AAPL | Stock | 13.2636 | 13.2636 | 13.245 | 13.2589 | 30380.0 |
| 2011-09-06 07:05:00 | AAPL | Stock | 13.2589 | 13.2589 | 13.2464 | 13.2464 | 28000.0 |
| 2011-09-06 07:10:00 | AAPL | Stock | 13.2464 | 13.2464 | 13.1786 | 13.1832 | 82600.0 |
| 2011-09-06 07:15:00 | AAPL | Stock | 13.1982 | 13.2 | 13.1843 | 13.1964 | 78960.0 |
| 2011-09-06 07:20:00 | AAPL | Stock | 13.2032 | 13.2032 | 13.1911 | 13.1911 | 40964.0 |
| 2011-09-06 07:25:00 | AAPL | Stock | 13.1804 | 13.1804 | 13.165 | 13.1696 | 36400.0 |
| 2011-09-06 07:30:00 | AAPL | Stock | 13.1746 | 13.1789 | 13.1607 | 13.1607 | 137564.0 |
| 2011-09-06 07:35:00 | AAPL | Stock | 13.1732 | 13.1732 | 13.1714 | 13.1732 | 11200.0 |
| 2011-09-06 07:40:00 | AAPL | Stock | 13.1611 | 13.1611 | 13.1607 | 13.1607 | 8400.0 |
| 2011-09-06 07:45:00 | AAPL | Stock | 13.17 | 13.1739 | 13.17 | 13.1739 | 14000.0 |
| 2011-09-06 07:50:00 | AAPL | Stock | 13.1746 | 13.175 | 13.1739 | 13.1739 | 42000.0 |
| 2011-09-06 07:55:00 | AAPL | Stock | 13.165 | 13.1689 | 13.1532 | 13.1689 | 57204.0 |
| 2011-09-06 08:00:00 | AAPL | Stock | 13.1561 | 13.1764 | 13.125 | 13.1632 | 480004.0 |
| 2011-09-06 08:05:00 | AAPL | Stock | 13.1607 | 13.1679 | 13.1543 | 13.1607 | 229012.0 |
| 2011-09-06 08:10:00 | AAPL | Stock | 13.1639 | 13.1639 | 13.1257 | 13.1257 | 194852.0 |
| 2011-09-06 08:15:00 | AAPL | Stock | 13.1254 | 13.1314 | 13.1071 | 13.1143 | 337680.0 |
| 2011-09-06 08:20:00 | AAPL | Stock | 13.1221 | 13.1429 | 13.1111 | 13.1279 | 292852.0 |
| 2011-09-06 08:25:00 | AAPL | Stock | 13.125 | 13.1371 | 13.1107 | 13.1218 | 145880.0 |
| 2011-09-06 08:30:00 | AAPL | Stock | 13.1268 | 13.1357 | 13.1207 | 13.1357 | 314384.0 |
| 2011-09-06 08:35:00 | AAPL | Stock | 13.1254 | 13.1339 | 13.1107 | 13.1232 | 118860.0 |
| 2011-09-06 08:40:00 | AAPL | Stock | 13.1311 | 13.1339 | 13.095 | 13.095 | 121884.0 |
| 2011-09-06 08:45:00 | AAPL | Stock | 13.0971 | 13.1232 | 13.0921 | 13.1125 | 413364.0 |
| 2011-09-06 08:50:00 | AAPL | Stock | 13.1154 | 13.1318 | 13.1079 | 13.1318 | 204400.0 |
| 2011-09-06 08:55:00 | AAPL | Stock | 13.1261 | 13.1339 | 13.1146 | 13.1218 | 255780.0 |
| 2011-09-06 09:00:00 | AAPL | Stock | 13.1211 | 13.1504 | 13.1211 | 13.1461 | 172872.0 |
| 2011-09-06 09:05:00 | AAPL | Stock | 13.1496 | 13.1536 | 13.1439 | 13.1518 | 221200.0 |
| 2011-09-06 09:10:00 | AAPL | Stock | 13.1518 | 13.1561 | 13.1454 | 13.1454 | 358008.0 |
| 2011-09-06 09:15:00 | AAPL | Stock | 13.1489 | 13.1546 | 13.1193 | 13.1243 | 307132.0 |
| 2011-09-06 09:20:00 | AAPL | Stock | 13.1221 | 13.1232 | 13.1039 | 13.1196 | 495012.0 |
| 2011-09-06 09:25:00 | AAPL | Stock | 13.1111 | 13.1343 | 13.1096 | 13.11 | 657636.0 |
| 2011-09-06 09:30:00 | AAPL | Stock | 13.11 | 13.2229 | 13.0886 | 13.1918 | 16971556.0 |
| 2011-09-06 09:35:00 | AAPL | Stock | 13.1939 | 13.2314 | 13.1675 | 13.2164 | 10538864.0 |
| 2011-09-06 09:40:00 | AAPL | Stock | 13.2132 | 13.2357 | 13.2039 | 13.2289 | 9662492.0 |
| 2011-09-06 09:45:00 | AAPL | Stock | 13.2318 | 13.2411 | 13.1839 | 13.1846 | 9014292.0 |
| 2011-09-06 09:50:00 | AAPL | Stock | 13.1843 | 13.2382 | 13.1786 | 13.215 | 8486576.0 |
| 2011-09-06 09:55:00 | AAPL | Stock | 13.2155 | 13.2229 | 13.1814 | 13.2004 | 7467068.0 |
> showing 50 of 338,663 rows — these rows as CSV