PREVIEW / stock_1min / 2008-09-02
file: by_date/stock_1min/2008/2008-09-02.parquet size: 12.5 MB rows: 1,003,933 symbols: 2,700
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-09-02 04:25:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 11228.0 |
| 2008-09-02 04:30:00 | AAPL | Stock | 6.1507 | 6.1507 | 6.1507 | 6.1507 | 8400.0 |
| 2008-09-02 04:32:00 | AAPL | Stock | 6.1536 | 6.1536 | 6.1536 | 6.1536 | 5320.0 |
| 2008-09-02 07:01:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 2800.0 |
| 2008-09-02 07:05:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 5600.0 |
| 2008-09-02 07:11:00 | AAPL | Stock | 6.1407 | 6.1407 | 6.1407 | 6.1407 | 5880.0 |
| 2008-09-02 07:12:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1411 | 6.1411 | 8400.0 |
| 2008-09-02 07:13:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1411 | 6.1411 | 28000.0 |
| 2008-09-02 07:19:00 | AAPL | Stock | 6.1407 | 6.1425 | 6.1407 | 6.1425 | 13720.0 |
| 2008-09-02 07:20:00 | AAPL | Stock | 6.1425 | 6.1425 | 6.1425 | 6.1425 | 7000.0 |
| 2008-09-02 07:22:00 | AAPL | Stock | 6.1425 | 6.1429 | 6.1425 | 6.1429 | 27524.0 |
| 2008-09-02 07:29:00 | AAPL | Stock | 6.1443 | 6.1443 | 6.1357 | 6.1357 | 23660.0 |
| 2008-09-02 07:30:00 | AAPL | Stock | 6.1532 | 6.1536 | 6.1532 | 6.1536 | 28000.0 |
| 2008-09-02 07:31:00 | AAPL | Stock | 6.1532 | 6.1536 | 6.1532 | 6.1536 | 42000.0 |
| 2008-09-02 07:32:00 | AAPL | Stock | 6.1532 | 6.1532 | 6.1532 | 6.1532 | 28000.0 |
| 2008-09-02 07:37:00 | AAPL | Stock | 6.1379 | 6.1379 | 6.1357 | 6.1361 | 154000.0 |
| 2008-09-02 07:38:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 14000.0 |
| 2008-09-02 07:40:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 56000.0 |
| 2008-09-02 07:41:00 | AAPL | Stock | 6.1339 | 6.1343 | 6.1336 | 6.1336 | 167720.0 |
| 2008-09-02 07:42:00 | AAPL | Stock | 6.15 | 6.15 | 6.15 | 6.15 | 16800.0 |
| 2008-09-02 07:43:00 | AAPL | Stock | 6.1482 | 6.1482 | 6.1339 | 6.1429 | 123200.0 |
| 2008-09-02 07:44:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 2800.0 |
| 2008-09-02 07:52:00 | AAPL | Stock | 6.1286 | 6.1304 | 6.1286 | 6.1304 | 14000.0 |
| 2008-09-02 07:54:00 | AAPL | Stock | 6.1418 | 6.1418 | 6.1418 | 6.1418 | 22400.0 |
| 2008-09-02 07:56:00 | AAPL | Stock | 6.1425 | 6.1425 | 6.1425 | 6.1425 | 14000.0 |
| 2008-09-02 07:57:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 30800.0 |
| 2008-09-02 07:58:00 | AAPL | Stock | 6.1286 | 6.1289 | 6.125 | 6.1254 | 30800.0 |
| 2008-09-02 07:59:00 | AAPL | Stock | 6.13 | 6.1321 | 6.13 | 6.1321 | 59640.0 |
| 2008-09-02 08:00:00 | AAPL | Stock | 6.13 | 6.1375 | 6.1204 | 6.1364 | 174384.0 |
| 2008-09-02 08:01:00 | AAPL | Stock | 6.1368 | 6.1368 | 6.1321 | 6.1368 | 110600.0 |
| 2008-09-02 08:02:00 | AAPL | Stock | 6.1368 | 6.1368 | 6.1304 | 6.1304 | 107940.0 |
| 2008-09-02 08:03:00 | AAPL | Stock | 6.1304 | 6.1321 | 6.1286 | 6.1321 | 35924.0 |
| 2008-09-02 08:04:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1332 | 6.1332 | 26600.0 |
| 2008-09-02 08:05:00 | AAPL | Stock | 6.1332 | 6.1386 | 6.1325 | 6.1386 | 79772.0 |
| 2008-09-02 08:06:00 | AAPL | Stock | 6.1379 | 6.1411 | 6.1379 | 6.1411 | 54292.0 |
| 2008-09-02 08:07:00 | AAPL | Stock | 6.1411 | 6.1429 | 6.1411 | 6.1429 | 107996.0 |
| 2008-09-02 08:08:00 | AAPL | Stock | 6.1464 | 6.1464 | 6.1411 | 6.1411 | 322000.0 |
| 2008-09-02 08:09:00 | AAPL | Stock | 6.1457 | 6.1536 | 6.1414 | 6.1496 | 225120.0 |
| 2008-09-02 08:10:00 | AAPL | Stock | 6.1496 | 6.1529 | 6.1496 | 6.1529 | 135940.0 |
| 2008-09-02 08:11:00 | AAPL | Stock | 6.1529 | 6.1536 | 6.1496 | 6.1536 | 46116.0 |
| 2008-09-02 08:12:00 | AAPL | Stock | 6.15 | 6.1504 | 6.1443 | 6.1443 | 173600.0 |
| 2008-09-02 08:13:00 | AAPL | Stock | 6.1496 | 6.15 | 6.1496 | 6.15 | 34720.0 |
| 2008-09-02 08:14:00 | AAPL | Stock | 6.15 | 6.15 | 6.15 | 6.15 | 8400.0 |
| 2008-09-02 08:15:00 | AAPL | Stock | 6.1496 | 6.1496 | 6.1468 | 6.1468 | 30800.0 |
| 2008-09-02 08:16:00 | AAPL | Stock | 6.1468 | 6.1468 | 6.1429 | 6.1429 | 165200.0 |
| 2008-09-02 08:17:00 | AAPL | Stock | 6.145 | 6.1475 | 6.1418 | 6.1429 | 153440.0 |
| 2008-09-02 08:18:00 | AAPL | Stock | 6.1429 | 6.1464 | 6.1429 | 6.1429 | 59360.0 |
| 2008-09-02 08:19:00 | AAPL | Stock | 6.1446 | 6.1511 | 6.1446 | 6.1482 | 154560.0 |
| 2008-09-02 08:20:00 | AAPL | Stock | 6.1482 | 6.1482 | 6.1479 | 6.1482 | 33600.0 |
| 2008-09-02 08:21:00 | AAPL | Stock | 6.1482 | 6.15 | 6.1468 | 6.1468 | 155400.0 |
> showing 50 of 1,003,933 rows — these rows as CSV