PREVIEW / stock_1min / 2011-05-16
file: by_date/stock_1min/2011/2011-05-16.parquet size: 13.4 MB rows: 1,004,148 symbols: 2,890
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-05-16 05:45:00 | AAPL | Stock | 12.1082 | 12.1082 | 12.1082 | 12.1082 | 2800.0 |
| 2011-05-16 06:08:00 | AAPL | Stock | 12.085 | 12.085 | 12.0829 | 12.0829 | 5600.0 |
| 2011-05-16 06:09:00 | AAPL | Stock | 12.0829 | 12.0829 | 12.08 | 12.0807 | 8400.0 |
| 2011-05-16 07:02:00 | AAPL | Stock | 12.0929 | 12.0929 | 12.0857 | 12.0857 | 8120.0 |
| 2011-05-16 07:03:00 | AAPL | Stock | 12.0875 | 12.0875 | 12.0875 | 12.0875 | 2800.0 |
| 2011-05-16 07:04:00 | AAPL | Stock | 12.0929 | 12.0929 | 12.0929 | 12.0929 | 2800.0 |
| 2011-05-16 07:07:00 | AAPL | Stock | 12.0982 | 12.0982 | 12.0982 | 12.0982 | 16800.0 |
| 2011-05-16 07:08:00 | AAPL | Stock | 12.1071 | 12.1243 | 12.0982 | 12.1229 | 22400.0 |
| 2011-05-16 07:11:00 | AAPL | Stock | 12.1161 | 12.1161 | 12.1161 | 12.1161 | 2800.0 |
| 2011-05-16 07:14:00 | AAPL | Stock | 12.1207 | 12.1207 | 12.1207 | 12.1207 | 25200.0 |
| 2011-05-16 07:15:00 | AAPL | Stock | 12.1179 | 12.1179 | 12.1179 | 12.1179 | 2800.0 |
| 2011-05-16 07:19:00 | AAPL | Stock | 12.1125 | 12.1125 | 12.1125 | 12.1125 | 2800.0 |
| 2011-05-16 07:20:00 | AAPL | Stock | 12.1107 | 12.1107 | 12.1082 | 12.1082 | 7000.0 |
| 2011-05-16 07:22:00 | AAPL | Stock | 12.1082 | 12.1082 | 12.1071 | 12.1071 | 21000.0 |
| 2011-05-16 07:24:00 | AAPL | Stock | 12.1161 | 12.1211 | 12.1161 | 12.1179 | 25200.0 |
| 2011-05-16 07:25:00 | AAPL | Stock | 12.125 | 12.125 | 12.125 | 12.125 | 5600.0 |
| 2011-05-16 07:26:00 | AAPL | Stock | 12.125 | 12.1279 | 12.125 | 12.1279 | 22400.0 |
| 2011-05-16 07:27:00 | AAPL | Stock | 12.1307 | 12.1307 | 12.1307 | 12.1307 | 5600.0 |
| 2011-05-16 07:28:00 | AAPL | Stock | 12.1254 | 12.1254 | 12.125 | 12.125 | 8400.0 |
| 2011-05-16 07:31:00 | AAPL | Stock | 12.1164 | 12.1164 | 12.1154 | 12.1154 | 11200.0 |
| 2011-05-16 07:32:00 | AAPL | Stock | 12.11 | 12.11 | 12.1075 | 12.1075 | 11200.0 |
| 2011-05-16 07:35:00 | AAPL | Stock | 12.1246 | 12.1246 | 12.1246 | 12.1246 | 2800.0 |
| 2011-05-16 07:36:00 | AAPL | Stock | 12.1254 | 12.1254 | 12.1254 | 12.1254 | 19600.0 |
| 2011-05-16 07:38:00 | AAPL | Stock | 12.125 | 12.125 | 12.125 | 12.125 | 13272.0 |
| 2011-05-16 07:39:00 | AAPL | Stock | 12.1268 | 12.1268 | 12.1268 | 12.1268 | 5600.0 |
| 2011-05-16 07:43:00 | AAPL | Stock | 12.1271 | 12.1271 | 12.1271 | 12.1271 | 2800.0 |
| 2011-05-16 07:48:00 | AAPL | Stock | 12.1286 | 12.1343 | 12.125 | 12.125 | 25200.0 |
| 2011-05-16 07:49:00 | AAPL | Stock | 12.1282 | 12.1286 | 12.1279 | 12.1286 | 11200.0 |
| 2011-05-16 07:52:00 | AAPL | Stock | 12.1218 | 12.1218 | 12.1214 | 12.1214 | 5600.0 |
| 2011-05-16 07:53:00 | AAPL | Stock | 12.1111 | 12.1111 | 12.1111 | 12.1111 | 2800.0 |
| 2011-05-16 07:55:00 | AAPL | Stock | 12.1221 | 12.1221 | 12.1221 | 12.1221 | 2800.0 |
| 2011-05-16 07:56:00 | AAPL | Stock | 12.1286 | 12.1304 | 12.1286 | 12.1286 | 67144.0 |
| 2011-05-16 07:59:00 | AAPL | Stock | 12.1214 | 12.1214 | 12.1214 | 12.1214 | 2800.0 |
| 2011-05-16 08:00:00 | AAPL | Stock | 12.125 | 12.1429 | 12.1125 | 12.1296 | 111860.0 |
| 2011-05-16 08:02:00 | AAPL | Stock | 12.1275 | 12.1282 | 12.125 | 12.1268 | 46256.0 |
| 2011-05-16 08:03:00 | AAPL | Stock | 12.1368 | 12.1368 | 12.1364 | 12.1364 | 8400.0 |
| 2011-05-16 08:04:00 | AAPL | Stock | 12.1361 | 12.1361 | 12.1296 | 12.1357 | 11200.0 |
| 2011-05-16 08:05:00 | AAPL | Stock | 12.125 | 12.125 | 12.125 | 12.125 | 2800.0 |
| 2011-05-16 08:06:00 | AAPL | Stock | 12.125 | 12.1254 | 12.125 | 12.1254 | 62944.0 |
| 2011-05-16 08:07:00 | AAPL | Stock | 12.1254 | 12.1254 | 12.125 | 12.125 | 12600.0 |
| 2011-05-16 08:09:00 | AAPL | Stock | 12.1179 | 12.1179 | 12.1179 | 12.1179 | 2800.0 |
| 2011-05-16 08:10:00 | AAPL | Stock | 12.1318 | 12.1318 | 12.1318 | 12.1318 | 2800.0 |
| 2011-05-16 08:11:00 | AAPL | Stock | 12.1257 | 12.1318 | 12.1214 | 12.1318 | 113960.0 |
| 2011-05-16 08:12:00 | AAPL | Stock | 12.1279 | 12.1318 | 12.1254 | 12.1318 | 36820.0 |
| 2011-05-16 08:14:00 | AAPL | Stock | 12.1357 | 12.1429 | 12.1357 | 12.1429 | 51800.0 |
| 2011-05-16 08:15:00 | AAPL | Stock | 12.1429 | 12.1471 | 12.1429 | 12.1471 | 30800.0 |
| 2011-05-16 08:16:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 8400.0 |
| 2011-05-16 08:17:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 10444.0 |
| 2011-05-16 08:18:00 | AAPL | Stock | 12.1479 | 12.1479 | 12.1479 | 12.1479 | 11256.0 |
| 2011-05-16 08:19:00 | AAPL | Stock | 12.1486 | 12.15 | 12.1486 | 12.15 | 20664.0 |
> showing 50 of 1,004,148 rows — these rows as CSV