PREVIEW / stock_1min / 2011-10-17
file: by_date/stock_1min/2011/2011-10-17.parquet size: 12.7 MB rows: 960,014 symbols: 2,814
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-10-17 04:15:00 | AAPL | Stock | 15.17 | 15.17 | 15.17 | 15.17 | 2800.0 |
| 2011-10-17 04:22:00 | AAPL | Stock | 15.17 | 15.17 | 15.17 | 15.17 | 2800.0 |
| 2011-10-17 04:23:00 | AAPL | Stock | 15.17 | 15.17 | 15.17 | 15.17 | 2800.0 |
| 2011-10-17 04:57:00 | AAPL | Stock | 15.2057 | 15.2068 | 15.2057 | 15.2068 | 11900.0 |
| 2011-10-17 04:58:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 8400.0 |
| 2011-10-17 05:01:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 2800.0 |
| 2011-10-17 05:06:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 15120.0 |
| 2011-10-17 05:07:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 2800.0 |
| 2011-10-17 05:10:00 | AAPL | Stock | 15.2236 | 15.2236 | 15.2232 | 15.2232 | 5600.0 |
| 2011-10-17 05:16:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 12600.0 |
| 2011-10-17 05:18:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 2800.0 |
| 2011-10-17 05:35:00 | AAPL | Stock | 15.1536 | 15.1536 | 15.1536 | 15.1536 | 5040.0 |
| 2011-10-17 05:40:00 | AAPL | Stock | 15.1786 | 15.1786 | 15.1786 | 15.1786 | 2800.0 |
| 2011-10-17 05:48:00 | AAPL | Stock | 15.1464 | 15.1464 | 15.1429 | 15.1429 | 25200.0 |
| 2011-10-17 05:52:00 | AAPL | Stock | 15.1304 | 15.1304 | 15.1304 | 15.1304 | 22400.0 |
| 2011-10-17 05:54:00 | AAPL | Stock | 15.1786 | 15.1786 | 15.1786 | 15.1786 | 24500.0 |
| 2011-10-17 05:56:00 | AAPL | Stock | 15.1786 | 15.1786 | 15.1786 | 15.1786 | 6580.0 |
| 2011-10-17 06:09:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 14000.0 |
| 2011-10-17 06:10:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 8400.0 |
| 2011-10-17 06:17:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5600.0 |
| 2011-10-17 06:19:00 | AAPL | Stock | 15.16 | 15.1607 | 15.1439 | 15.1439 | 36400.0 |
| 2011-10-17 06:29:00 | AAPL | Stock | 15.1607 | 15.1607 | 15.1607 | 15.1607 | 2800.0 |
| 2011-10-17 06:32:00 | AAPL | Stock | 15.1457 | 15.1457 | 15.1457 | 15.1457 | 2800.0 |
| 2011-10-17 06:35:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2011-10-17 06:36:00 | AAPL | Stock | 15.1268 | 15.1268 | 15.1268 | 15.1268 | 16800.0 |
| 2011-10-17 06:37:00 | AAPL | Stock | 15.1268 | 15.1268 | 15.1268 | 15.1268 | 5600.0 |
| 2011-10-17 06:39:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 2800.0 |
| 2011-10-17 06:42:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 8400.0 |
| 2011-10-17 06:45:00 | AAPL | Stock | 15.11 | 15.11 | 15.1093 | 15.1093 | 8400.0 |
| 2011-10-17 06:46:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 8400.0 |
| 2011-10-17 06:47:00 | AAPL | Stock | 15.0896 | 15.0896 | 15.0896 | 15.0896 | 2800.0 |
| 2011-10-17 06:50:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 2800.0 |
| 2011-10-17 06:51:00 | AAPL | Stock | 15.1229 | 15.125 | 15.1229 | 15.125 | 14000.0 |
| 2011-10-17 06:53:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 17108.0 |
| 2011-10-17 06:57:00 | AAPL | Stock | 15.0921 | 15.0921 | 15.0893 | 15.0921 | 22400.0 |
| 2011-10-17 07:00:00 | AAPL | Stock | 15.1061 | 15.1093 | 15.1061 | 15.1093 | 11200.0 |
| 2011-10-17 07:01:00 | AAPL | Stock | 15.1071 | 15.125 | 15.1071 | 15.125 | 38360.0 |
| 2011-10-17 07:02:00 | AAPL | Stock | 15.125 | 15.1379 | 15.125 | 15.1357 | 58044.0 |
| 2011-10-17 07:03:00 | AAPL | Stock | 15.1357 | 15.1429 | 15.1321 | 15.1339 | 52668.0 |
| 2011-10-17 07:04:00 | AAPL | Stock | 15.1332 | 15.1429 | 15.1332 | 15.1429 | 17080.0 |
| 2011-10-17 07:05:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1339 | 15.1339 | 125328.0 |
| 2011-10-17 07:07:00 | AAPL | Stock | 15.125 | 15.125 | 15.1161 | 15.1161 | 30996.0 |
| 2011-10-17 07:09:00 | AAPL | Stock | 15.1161 | 15.1168 | 15.1161 | 15.1168 | 14924.0 |
| 2011-10-17 07:11:00 | AAPL | Stock | 15.1154 | 15.1154 | 15.1154 | 15.1154 | 2800.0 |
| 2011-10-17 07:12:00 | AAPL | Stock | 15.1243 | 15.1243 | 15.1243 | 15.1243 | 2800.0 |
| 2011-10-17 07:13:00 | AAPL | Stock | 15.125 | 15.125 | 15.1243 | 15.1243 | 41160.0 |
| 2011-10-17 07:14:00 | AAPL | Stock | 15.1271 | 15.1271 | 15.1271 | 15.1271 | 11200.0 |
| 2011-10-17 07:15:00 | AAPL | Stock | 15.1339 | 15.1339 | 15.12 | 15.1211 | 46760.0 |
| 2011-10-17 07:16:00 | AAPL | Stock | 15.1211 | 15.1211 | 15.1161 | 15.1161 | 16520.0 |
| 2011-10-17 07:18:00 | AAPL | Stock | 15.1125 | 15.1125 | 15.1071 | 15.1071 | 50232.0 |
> showing 50 of 960,014 rows — these rows as CSV