PREVIEW / stock_1min / 2006-07-21
file: by_date/stock_1min/2006/2006-07-21.parquet size: 8.4 MB rows: 691,340 symbols: 1,881
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-21 04:06:00 | AAPL | Stock | 2.1679 | 2.1679 | 2.1679 | 2.1679 | 29400.0 |
| 2006-07-21 04:10:00 | AAPL | Stock | 2.1643 | 2.1643 | 2.1643 | 2.1643 | 11200.0 |
| 2006-07-21 04:11:00 | AAPL | Stock | 2.1643 | 2.1643 | 2.1643 | 2.1643 | 28000.0 |
| 2006-07-21 04:26:00 | AAPL | Stock | 2.1625 | 2.1625 | 2.1625 | 2.1625 | 8400.0 |
| 2006-07-21 04:45:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 36400.0 |
| 2006-07-21 04:56:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 28000.0 |
| 2006-07-21 07:30:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 19376.0 |
| 2006-07-21 07:43:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.1536 | 2.1536 | 28000.0 |
| 2006-07-21 07:47:00 | AAPL | Stock | 2.1518 | 2.1518 | 2.1518 | 2.1518 | 19600.0 |
| 2006-07-21 07:48:00 | AAPL | Stock | 2.1504 | 2.1504 | 2.1504 | 2.1504 | 3388.0 |
| 2006-07-21 07:50:00 | AAPL | Stock | 2.1504 | 2.1504 | 2.1429 | 2.1429 | 33012.0 |
| 2006-07-21 08:00:00 | AAPL | Stock | 2.1536 | 2.1564 | 2.1429 | 2.1446 | 130200.0 |
| 2006-07-21 08:01:00 | AAPL | Stock | 2.1439 | 2.1536 | 2.1439 | 2.15 | 351372.0 |
| 2006-07-21 08:02:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 28000.0 |
| 2006-07-21 08:03:00 | AAPL | Stock | 2.1436 | 2.1482 | 2.1429 | 2.1429 | 195440.0 |
| 2006-07-21 08:04:00 | AAPL | Stock | 2.1432 | 2.1436 | 2.1429 | 2.1432 | 622020.0 |
| 2006-07-21 08:05:00 | AAPL | Stock | 2.1432 | 2.1432 | 2.1407 | 2.1407 | 98000.0 |
| 2006-07-21 08:06:00 | AAPL | Stock | 2.1411 | 2.1411 | 2.1382 | 2.1386 | 156548.0 |
| 2006-07-21 08:07:00 | AAPL | Stock | 2.1393 | 2.1411 | 2.1375 | 2.1407 | 107828.0 |
| 2006-07-21 08:08:00 | AAPL | Stock | 2.1396 | 2.1411 | 2.1396 | 2.1411 | 26516.0 |
| 2006-07-21 08:09:00 | AAPL | Stock | 2.1411 | 2.1411 | 2.1393 | 2.1393 | 33600.0 |
| 2006-07-21 08:10:00 | AAPL | Stock | 2.1411 | 2.1429 | 2.1393 | 2.1411 | 193396.0 |
| 2006-07-21 08:12:00 | AAPL | Stock | 2.1421 | 2.1421 | 2.1411 | 2.1411 | 13300.0 |
| 2006-07-21 08:13:00 | AAPL | Stock | 2.1393 | 2.1396 | 2.1375 | 2.1393 | 110600.0 |
| 2006-07-21 08:14:00 | AAPL | Stock | 2.1371 | 2.1371 | 2.1318 | 2.1318 | 228200.0 |
| 2006-07-21 08:15:00 | AAPL | Stock | 2.1289 | 2.1289 | 2.1286 | 2.1286 | 61600.0 |
| 2006-07-21 08:16:00 | AAPL | Stock | 2.1293 | 2.1321 | 2.1286 | 2.1318 | 103320.0 |
| 2006-07-21 08:17:00 | AAPL | Stock | 2.1318 | 2.1318 | 2.1293 | 2.1293 | 135240.0 |
| 2006-07-21 08:18:00 | AAPL | Stock | 2.1296 | 2.1296 | 2.1257 | 2.1268 | 134680.0 |
| 2006-07-21 08:19:00 | AAPL | Stock | 2.1268 | 2.1286 | 2.1268 | 2.1286 | 128100.0 |
| 2006-07-21 08:20:00 | AAPL | Stock | 2.1271 | 2.1286 | 2.1268 | 2.1268 | 112840.0 |
| 2006-07-21 08:21:00 | AAPL | Stock | 2.1268 | 2.1314 | 2.1268 | 2.1314 | 76440.0 |
| 2006-07-21 08:22:00 | AAPL | Stock | 2.1321 | 2.1343 | 2.1321 | 2.1325 | 114800.0 |
| 2006-07-21 08:23:00 | AAPL | Stock | 2.1343 | 2.1343 | 2.1339 | 2.1339 | 53200.0 |
| 2006-07-21 08:24:00 | AAPL | Stock | 2.1329 | 2.1343 | 2.1321 | 2.1329 | 36400.0 |
| 2006-07-21 08:25:00 | AAPL | Stock | 2.1339 | 2.1343 | 2.1339 | 2.1343 | 5600.0 |
| 2006-07-21 08:26:00 | AAPL | Stock | 2.1339 | 2.1343 | 2.1339 | 2.1343 | 5600.0 |
| 2006-07-21 08:27:00 | AAPL | Stock | 2.135 | 2.135 | 2.1339 | 2.1339 | 39760.0 |
| 2006-07-21 08:28:00 | AAPL | Stock | 2.1329 | 2.1329 | 2.1329 | 2.1329 | 11200.0 |
| 2006-07-21 08:29:00 | AAPL | Stock | 2.1329 | 2.1329 | 2.1321 | 2.1321 | 14000.0 |
| 2006-07-21 08:30:00 | AAPL | Stock | 2.1321 | 2.1329 | 2.1321 | 2.1329 | 8400.0 |
| 2006-07-21 08:31:00 | AAPL | Stock | 2.1354 | 2.1354 | 2.1354 | 2.1354 | 11200.0 |
| 2006-07-21 08:32:00 | AAPL | Stock | 2.135 | 2.1357 | 2.135 | 2.1357 | 33600.0 |
| 2006-07-21 08:33:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 15400.0 |
| 2006-07-21 08:34:00 | AAPL | Stock | 2.1321 | 2.135 | 2.1321 | 2.135 | 56000.0 |
| 2006-07-21 08:35:00 | AAPL | Stock | 2.1332 | 2.1332 | 2.1321 | 2.1321 | 16800.0 |
| 2006-07-21 08:36:00 | AAPL | Stock | 2.1346 | 2.1346 | 2.1321 | 2.1346 | 70000.0 |
| 2006-07-21 08:37:00 | AAPL | Stock | 2.1343 | 2.1343 | 2.1343 | 2.1343 | 21392.0 |
| 2006-07-21 08:38:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 48384.0 |
| 2006-07-21 08:39:00 | AAPL | Stock | 2.1357 | 2.1361 | 2.1339 | 2.1339 | 106400.0 |
> showing 50 of 691,340 rows — these rows as CSV