PREVIEW / stock_1min / 2006-07-20
file: by_date/stock_1min/2006/2006-07-20.parquet size: 8.4 MB rows: 681,731 symbols: 1,885
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-20 04:19:00 | AAPL | Stock | 2.1071 | 2.1071 | 2.1071 | 2.1071 | 14000.0 |
| 2006-07-20 04:58:00 | AAPL | Stock | 2.1214 | 2.1214 | 2.1214 | 2.1214 | 2800.0 |
| 2006-07-20 05:25:00 | AAPL | Stock | 2.1218 | 2.1218 | 2.1218 | 2.1218 | 2800.0 |
| 2006-07-20 05:27:00 | AAPL | Stock | 2.1218 | 2.1218 | 2.1218 | 2.1218 | 25200.0 |
| 2006-07-20 05:57:00 | AAPL | Stock | 2.1164 | 2.1164 | 2.1071 | 2.1071 | 70000.0 |
| 2006-07-20 05:58:00 | AAPL | Stock | 2.1164 | 2.1164 | 2.1125 | 2.1125 | 28000.0 |
| 2006-07-20 06:14:00 | AAPL | Stock | 2.125 | 2.125 | 2.125 | 2.125 | 16800.0 |
| 2006-07-20 06:23:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1232 | 2.1232 | 25228.0 |
| 2006-07-20 06:42:00 | AAPL | Stock | 2.1232 | 2.1246 | 2.1232 | 2.1246 | 11228.0 |
| 2006-07-20 06:43:00 | AAPL | Stock | 2.1229 | 2.1232 | 2.1229 | 2.1232 | 30744.0 |
| 2006-07-20 06:51:00 | AAPL | Stock | 2.1264 | 2.1264 | 2.1264 | 2.1264 | 2800.0 |
| 2006-07-20 07:00:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1232 | 2.1232 | 95200.0 |
| 2006-07-20 07:07:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1232 | 2.1232 | 2800.0 |
| 2006-07-20 07:08:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1232 | 2.1232 | 7280.0 |
| 2006-07-20 07:12:00 | AAPL | Stock | 2.1179 | 2.1179 | 2.1179 | 2.1179 | 5600.0 |
| 2006-07-20 07:13:00 | AAPL | Stock | 2.1179 | 2.1179 | 2.1179 | 2.1179 | 8400.0 |
| 2006-07-20 07:22:00 | AAPL | Stock | 2.1286 | 2.1286 | 2.125 | 2.125 | 58800.0 |
| 2006-07-20 07:23:00 | AAPL | Stock | 2.1286 | 2.1329 | 2.1286 | 2.1329 | 125860.0 |
| 2006-07-20 07:26:00 | AAPL | Stock | 2.1329 | 2.1329 | 2.1329 | 2.1329 | 14000.0 |
| 2006-07-20 07:27:00 | AAPL | Stock | 2.1346 | 2.135 | 2.1346 | 2.135 | 42168.0 |
| 2006-07-20 07:28:00 | AAPL | Stock | 2.135 | 2.1389 | 2.135 | 2.135 | 36400.0 |
| 2006-07-20 07:31:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1339 | 2.1339 | 50400.0 |
| 2006-07-20 07:32:00 | AAPL | Stock | 2.1339 | 2.1396 | 2.1339 | 2.1339 | 130900.0 |
| 2006-07-20 07:33:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1321 | 2.1339 | 42000.0 |
| 2006-07-20 07:34:00 | AAPL | Stock | 2.1304 | 2.1304 | 2.1304 | 2.1304 | 5600.0 |
| 2006-07-20 07:36:00 | AAPL | Stock | 2.1304 | 2.1304 | 2.1304 | 2.1304 | 39200.0 |
| 2006-07-20 07:37:00 | AAPL | Stock | 2.1304 | 2.1304 | 2.1304 | 2.1304 | 11200.0 |
| 2006-07-20 07:38:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1339 | 2.1339 | 16800.0 |
| 2006-07-20 07:39:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1321 | 2.1321 | 145040.0 |
| 2006-07-20 07:40:00 | AAPL | Stock | 2.1304 | 2.1304 | 2.1304 | 2.1304 | 64400.0 |
| 2006-07-20 07:42:00 | AAPL | Stock | 2.1304 | 2.1304 | 2.1304 | 2.1304 | 5600.0 |
| 2006-07-20 07:43:00 | AAPL | Stock | 2.1304 | 2.1304 | 2.1304 | 2.1304 | 22428.0 |
| 2006-07-20 07:44:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1339 | 2.1339 | 14000.0 |
| 2006-07-20 07:45:00 | AAPL | Stock | 2.1339 | 2.1389 | 2.1339 | 2.1389 | 82600.0 |
| 2006-07-20 07:46:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1339 | 2.1339 | 139440.0 |
| 2006-07-20 07:47:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1339 | 2.1339 | 112000.0 |
| 2006-07-20 07:48:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1339 | 2.1339 | 16800.0 |
| 2006-07-20 07:49:00 | AAPL | Stock | 2.1375 | 2.1375 | 2.1375 | 2.1375 | 28000.0 |
| 2006-07-20 07:50:00 | AAPL | Stock | 2.1375 | 2.1411 | 2.1375 | 2.1411 | 144340.0 |
| 2006-07-20 07:51:00 | AAPL | Stock | 2.1421 | 2.1482 | 2.1421 | 2.1429 | 196000.0 |
| 2006-07-20 07:52:00 | AAPL | Stock | 2.1421 | 2.1429 | 2.1421 | 2.1421 | 205324.0 |
| 2006-07-20 07:53:00 | AAPL | Stock | 2.1393 | 2.1393 | 2.1357 | 2.1357 | 245672.0 |
| 2006-07-20 07:54:00 | AAPL | Stock | 2.1393 | 2.1393 | 2.1357 | 2.1357 | 224000.0 |
| 2006-07-20 07:55:00 | AAPL | Stock | 2.1411 | 2.1411 | 2.1411 | 2.1411 | 25200.0 |
| 2006-07-20 07:56:00 | AAPL | Stock | 2.1429 | 2.1464 | 2.1429 | 2.1446 | 70000.0 |
| 2006-07-20 07:57:00 | AAPL | Stock | 2.1436 | 2.1436 | 2.1436 | 2.1436 | 8400.0 |
| 2006-07-20 07:58:00 | AAPL | Stock | 2.1439 | 2.1439 | 2.1429 | 2.1429 | 8400.0 |
| 2006-07-20 07:59:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1429 | 2.1439 | 29400.0 |
| 2006-07-20 08:00:00 | AAPL | Stock | 2.1436 | 2.1464 | 2.1275 | 2.1464 | 1631672.0 |
| 2006-07-20 08:01:00 | AAPL | Stock | 2.1429 | 2.1564 | 2.1393 | 2.1525 | 4004616.0 |
> showing 50 of 681,731 rows — these rows as CSV