PREVIEW / stock_1min / 2013-11-27
file: by_date/stock_1min/2013/2013-11-27.parquet size: 13.5 MB rows: 997,842 symbols: 2,872
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-11-27 05:10:00 | AAPL | Stock | 19.0971 | 19.0971 | 19.0971 | 19.0971 | 2800.0 |
| 2013-11-27 06:01:00 | AAPL | Stock | 19.0996 | 19.0996 | 19.0936 | 19.0936 | 5600.0 |
| 2013-11-27 06:11:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 28000.0 |
| 2013-11-27 06:13:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2013-11-27 06:31:00 | AAPL | Stock | 19.1068 | 19.1071 | 19.1068 | 19.1071 | 27860.0 |
| 2013-11-27 06:32:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 10500.0 |
| 2013-11-27 06:37:00 | AAPL | Stock | 19.1225 | 19.1229 | 19.1225 | 19.1229 | 28000.0 |
| 2013-11-27 06:41:00 | AAPL | Stock | 19.1214 | 19.1214 | 19.1214 | 19.1214 | 2800.0 |
| 2013-11-27 06:46:00 | AAPL | Stock | 19.1214 | 19.1225 | 19.1214 | 19.1225 | 6272.0 |
| 2013-11-27 06:47:00 | AAPL | Stock | 19.1214 | 19.1239 | 19.1214 | 19.1239 | 9520.0 |
| 2013-11-27 06:50:00 | AAPL | Stock | 19.1239 | 19.1239 | 19.1239 | 19.1239 | 2800.0 |
| 2013-11-27 06:55:00 | AAPL | Stock | 19.1093 | 19.1093 | 19.1071 | 19.1071 | 29204.0 |
| 2013-11-27 06:57:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2013-11-27 06:58:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 2800.0 |
| 2013-11-27 07:00:00 | AAPL | Stock | 19.1157 | 19.1157 | 19.1071 | 19.1071 | 22092.0 |
| 2013-11-27 07:01:00 | AAPL | Stock | 19.1075 | 19.1075 | 19.1071 | 19.1071 | 14000.0 |
| 2013-11-27 07:02:00 | AAPL | Stock | 19.115 | 19.1157 | 19.115 | 19.1157 | 16800.0 |
| 2013-11-27 07:03:00 | AAPL | Stock | 19.1214 | 19.1229 | 19.1214 | 19.1229 | 8540.0 |
| 2013-11-27 07:04:00 | AAPL | Stock | 19.1214 | 19.1243 | 19.1214 | 19.1243 | 29512.0 |
| 2013-11-27 07:06:00 | AAPL | Stock | 19.1114 | 19.1118 | 19.1114 | 19.1118 | 7700.0 |
| 2013-11-27 07:08:00 | AAPL | Stock | 19.1111 | 19.1111 | 19.1107 | 19.1107 | 5600.0 |
| 2013-11-27 07:10:00 | AAPL | Stock | 19.1075 | 19.1075 | 19.1071 | 19.1071 | 16240.0 |
| 2013-11-27 07:11:00 | AAPL | Stock | 19.1161 | 19.1161 | 19.1075 | 19.1075 | 9800.0 |
| 2013-11-27 07:12:00 | AAPL | Stock | 19.1161 | 19.1161 | 19.1161 | 19.1161 | 2800.0 |
| 2013-11-27 07:15:00 | AAPL | Stock | 19.1164 | 19.1164 | 19.1164 | 19.1164 | 11200.0 |
| 2013-11-27 07:17:00 | AAPL | Stock | 19.1164 | 19.125 | 19.1164 | 19.125 | 30800.0 |
| 2013-11-27 07:19:00 | AAPL | Stock | 19.125 | 19.13 | 19.125 | 19.1293 | 90412.0 |
| 2013-11-27 07:21:00 | AAPL | Stock | 19.1311 | 19.1357 | 19.1311 | 19.1357 | 15120.0 |
| 2013-11-27 07:22:00 | AAPL | Stock | 19.1379 | 19.15 | 19.1379 | 19.15 | 44520.0 |
| 2013-11-27 07:23:00 | AAPL | Stock | 19.1532 | 19.1546 | 19.1529 | 19.1539 | 37100.0 |
| 2013-11-27 07:24:00 | AAPL | Stock | 19.1518 | 19.1518 | 19.1518 | 19.1518 | 8400.0 |
| 2013-11-27 07:25:00 | AAPL | Stock | 19.1586 | 19.1639 | 19.1429 | 19.1429 | 69720.0 |
| 2013-11-27 07:26:00 | AAPL | Stock | 19.1464 | 19.1464 | 19.1429 | 19.1429 | 19880.0 |
| 2013-11-27 07:27:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1429 | 19.1429 | 2800.0 |
| 2013-11-27 07:29:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1429 | 19.1429 | 18900.0 |
| 2013-11-27 07:30:00 | AAPL | Stock | 19.1518 | 19.1564 | 19.1468 | 19.1557 | 37856.0 |
| 2013-11-27 07:32:00 | AAPL | Stock | 19.1554 | 19.1564 | 19.1468 | 19.1468 | 12180.0 |
| 2013-11-27 07:33:00 | AAPL | Stock | 19.1464 | 19.1464 | 19.1464 | 19.1464 | 8400.0 |
| 2013-11-27 07:39:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1429 | 19.1429 | 2800.0 |
| 2013-11-27 07:40:00 | AAPL | Stock | 19.1429 | 19.1464 | 19.1429 | 19.1429 | 42700.0 |
| 2013-11-27 07:41:00 | AAPL | Stock | 19.1504 | 19.1511 | 19.1504 | 19.1511 | 5600.0 |
| 2013-11-27 07:42:00 | AAPL | Stock | 19.1518 | 19.1518 | 19.1514 | 19.1514 | 8400.0 |
| 2013-11-27 07:43:00 | AAPL | Stock | 19.1518 | 19.155 | 19.1518 | 19.155 | 19600.0 |
| 2013-11-27 07:44:00 | AAPL | Stock | 19.155 | 19.1643 | 19.155 | 19.1643 | 72800.0 |
| 2013-11-27 07:45:00 | AAPL | Stock | 19.1664 | 19.1786 | 19.1664 | 19.1786 | 145600.0 |
| 2013-11-27 07:46:00 | AAPL | Stock | 19.1786 | 19.1789 | 19.1779 | 19.1789 | 35336.0 |
| 2013-11-27 07:47:00 | AAPL | Stock | 19.1782 | 19.1786 | 19.1696 | 19.1714 | 50400.0 |
| 2013-11-27 07:48:00 | AAPL | Stock | 19.1732 | 19.1786 | 19.1696 | 19.1786 | 72716.0 |
| 2013-11-27 07:49:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1743 | 19.1743 | 20664.0 |
| 2013-11-27 07:50:00 | AAPL | Stock | 19.1714 | 19.1714 | 19.1661 | 19.1661 | 81060.0 |
> showing 50 of 997,842 rows — these rows as CSV