PREVIEW / stock_1min / 2008-06-13
file: by_date/stock_1min/2008/2008-06-13.parquet size: 11.9 MB rows: 956,563 symbols: 2,715
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-13 06:23:00 | AAPL | Stock | 6.1221 | 6.1221 | 6.1221 | 6.1221 | 2800.0 |
| 2008-06-13 06:28:00 | AAPL | Stock | 6.1314 | 6.1314 | 6.1314 | 6.1314 | 5600.0 |
| 2008-06-13 06:29:00 | AAPL | Stock | 6.1332 | 6.1332 | 6.1332 | 6.1332 | 5600.0 |
| 2008-06-13 06:37:00 | AAPL | Stock | 6.1332 | 6.1375 | 6.1246 | 6.1375 | 25200.0 |
| 2008-06-13 06:41:00 | AAPL | Stock | 6.1368 | 6.1368 | 6.1368 | 6.1368 | 2800.0 |
| 2008-06-13 06:44:00 | AAPL | Stock | 6.1329 | 6.1329 | 6.1329 | 6.1329 | 2800.0 |
| 2008-06-13 06:58:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 2800.0 |
| 2008-06-13 07:00:00 | AAPL | Stock | 6.1596 | 6.1604 | 6.1596 | 6.1604 | 51520.0 |
| 2008-06-13 07:01:00 | AAPL | Stock | 6.1596 | 6.1596 | 6.1596 | 6.1596 | 18732.0 |
| 2008-06-13 07:10:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 27160.0 |
| 2008-06-13 07:21:00 | AAPL | Stock | 6.1396 | 6.1396 | 6.1393 | 6.1393 | 9660.0 |
| 2008-06-13 07:33:00 | AAPL | Stock | 6.1396 | 6.14 | 6.1396 | 6.14 | 11200.0 |
| 2008-06-13 07:38:00 | AAPL | Stock | 6.1396 | 6.1396 | 6.1396 | 6.1396 | 2800.0 |
| 2008-06-13 07:39:00 | AAPL | Stock | 6.1393 | 6.1393 | 6.1393 | 6.1393 | 17500.0 |
| 2008-06-13 07:47:00 | AAPL | Stock | 6.1396 | 6.1396 | 6.1396 | 6.1396 | 2800.0 |
| 2008-06-13 07:52:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1411 | 6.1411 | 19600.0 |
| 2008-06-13 07:54:00 | AAPL | Stock | 6.1464 | 6.1464 | 6.1464 | 6.1464 | 16800.0 |
| 2008-06-13 07:55:00 | AAPL | Stock | 6.1475 | 6.1475 | 6.1475 | 6.1475 | 11200.0 |
| 2008-06-13 07:56:00 | AAPL | Stock | 6.1429 | 6.1461 | 6.1429 | 6.1461 | 11200.0 |
| 2008-06-13 07:57:00 | AAPL | Stock | 6.1464 | 6.1464 | 6.1464 | 6.1464 | 14000.0 |
| 2008-06-13 08:00:00 | AAPL | Stock | 6.1543 | 6.1543 | 6.1396 | 6.1396 | 132440.0 |
| 2008-06-13 08:01:00 | AAPL | Stock | 6.1393 | 6.14 | 6.1375 | 6.1375 | 66780.0 |
| 2008-06-13 08:02:00 | AAPL | Stock | 6.1375 | 6.1407 | 6.1343 | 6.1343 | 14000.0 |
| 2008-06-13 08:03:00 | AAPL | Stock | 6.1336 | 6.1336 | 6.125 | 6.1271 | 118356.0 |
| 2008-06-13 08:04:00 | AAPL | Stock | 6.1271 | 6.1307 | 6.1271 | 6.1286 | 43624.0 |
| 2008-06-13 08:05:00 | AAPL | Stock | 6.1296 | 6.1304 | 6.1286 | 6.1286 | 114800.0 |
| 2008-06-13 08:06:00 | AAPL | Stock | 6.1286 | 6.1339 | 6.1286 | 6.1289 | 199668.0 |
| 2008-06-13 08:07:00 | AAPL | Stock | 6.1282 | 6.1318 | 6.1254 | 6.1318 | 50400.0 |
| 2008-06-13 08:08:00 | AAPL | Stock | 6.1293 | 6.1307 | 6.1254 | 6.1261 | 91840.0 |
| 2008-06-13 08:09:00 | AAPL | Stock | 6.1257 | 6.1257 | 6.1146 | 6.1146 | 97720.0 |
| 2008-06-13 08:10:00 | AAPL | Stock | 6.1143 | 6.1207 | 6.1071 | 6.1207 | 75740.0 |
| 2008-06-13 08:11:00 | AAPL | Stock | 6.1179 | 6.1214 | 6.1164 | 6.1214 | 81340.0 |
| 2008-06-13 08:12:00 | AAPL | Stock | 6.1232 | 6.1321 | 6.1232 | 6.1304 | 37240.0 |
| 2008-06-13 08:13:00 | AAPL | Stock | 6.1268 | 6.1282 | 6.1254 | 6.1254 | 33040.0 |
| 2008-06-13 08:14:00 | AAPL | Stock | 6.125 | 6.125 | 6.1236 | 6.1236 | 40600.0 |
| 2008-06-13 08:16:00 | AAPL | Stock | 6.1268 | 6.1318 | 6.1243 | 6.1261 | 183008.0 |
| 2008-06-13 08:17:00 | AAPL | Stock | 6.13 | 6.1304 | 6.125 | 6.125 | 59444.0 |
| 2008-06-13 08:18:00 | AAPL | Stock | 6.1286 | 6.1311 | 6.1071 | 6.1296 | 84560.0 |
| 2008-06-13 08:19:00 | AAPL | Stock | 6.1264 | 6.1264 | 6.1232 | 6.1236 | 27160.0 |
| 2008-06-13 08:20:00 | AAPL | Stock | 6.1261 | 6.1286 | 6.1232 | 6.1286 | 29820.0 |
| 2008-06-13 08:21:00 | AAPL | Stock | 6.1279 | 6.1321 | 6.1279 | 6.1321 | 36232.0 |
| 2008-06-13 08:22:00 | AAPL | Stock | 6.1321 | 6.1407 | 6.1321 | 6.135 | 99372.0 |
| 2008-06-13 08:23:00 | AAPL | Stock | 6.1368 | 6.1393 | 6.1368 | 6.1375 | 33600.0 |
| 2008-06-13 08:24:00 | AAPL | Stock | 6.1393 | 6.1393 | 6.1357 | 6.1357 | 14000.0 |
| 2008-06-13 08:25:00 | AAPL | Stock | 6.1357 | 6.1371 | 6.1357 | 6.1371 | 5600.0 |
| 2008-06-13 08:26:00 | AAPL | Stock | 6.1357 | 6.1379 | 6.1357 | 6.1375 | 31444.0 |
| 2008-06-13 08:27:00 | AAPL | Stock | 6.14 | 6.14 | 6.1271 | 6.1271 | 29092.0 |
| 2008-06-13 08:28:00 | AAPL | Stock | 6.1321 | 6.1321 | 6.1321 | 6.1321 | 2800.0 |
| 2008-06-13 08:29:00 | AAPL | Stock | 6.1318 | 6.1339 | 6.1318 | 6.1339 | 7000.0 |
| 2008-06-13 08:30:00 | AAPL | Stock | 6.1339 | 6.14 | 6.1154 | 6.1193 | 478268.0 |
> showing 50 of 956,563 rows — these rows as CSV