PREVIEW / stock_1min / 2009-03-02
file: by_date/stock_1min/2009/2009-03-02.parquet size: 13.3 MB rows: 1,022,230 symbols: 2,723
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-02 07:20:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.1214 | 3.1214 | 2800.0 |
| 2009-03-02 07:21:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.1214 | 3.1214 | 2800.0 |
| 2009-03-02 07:23:00 | AAPL | Stock | 3.1279 | 3.1279 | 3.1279 | 3.1279 | 28000.0 |
| 2009-03-02 07:25:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.1214 | 3.1214 | 5600.0 |
| 2009-03-02 07:48:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.1214 | 3.1214 | 8400.0 |
| 2009-03-02 07:53:00 | AAPL | Stock | 3.1314 | 3.1314 | 3.1314 | 3.1314 | 14000.0 |
| 2009-03-02 07:54:00 | AAPL | Stock | 3.1314 | 3.1314 | 3.1314 | 3.1314 | 4900.0 |
| 2009-03-02 08:00:00 | AAPL | Stock | 3.1314 | 3.1329 | 3.1311 | 3.1311 | 42700.0 |
| 2009-03-02 08:01:00 | AAPL | Stock | 3.1421 | 3.1421 | 3.1339 | 3.1339 | 8400.0 |
| 2009-03-02 08:02:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1339 | 3.1339 | 8400.0 |
| 2009-03-02 08:03:00 | AAPL | Stock | 3.1332 | 3.1332 | 3.1332 | 3.1332 | 6440.0 |
| 2009-03-02 08:04:00 | AAPL | Stock | 3.1343 | 3.1343 | 3.1339 | 3.1339 | 28000.0 |
| 2009-03-02 08:05:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1393 | 3.1393 | 15400.0 |
| 2009-03-02 08:09:00 | AAPL | Stock | 3.1386 | 3.1429 | 3.1386 | 3.1429 | 24640.0 |
| 2009-03-02 08:10:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 14560.0 |
| 2009-03-02 08:11:00 | AAPL | Stock | 3.1404 | 3.1404 | 3.1404 | 3.1404 | 13832.0 |
| 2009-03-02 08:12:00 | AAPL | Stock | 3.1404 | 3.1421 | 3.1404 | 3.1421 | 35280.0 |
| 2009-03-02 08:13:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 4200.0 |
| 2009-03-02 08:19:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1446 | 3.1446 | 2800.0 |
| 2009-03-02 08:20:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1446 | 3.1446 | 19600.0 |
| 2009-03-02 08:21:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1446 | 3.1446 | 9800.0 |
| 2009-03-02 08:23:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1414 | 3.1414 | 24360.0 |
| 2009-03-02 08:24:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1439 | 3.1439 | 23800.0 |
| 2009-03-02 08:25:00 | AAPL | Stock | 3.1443 | 3.1443 | 3.1429 | 3.1429 | 32144.0 |
| 2009-03-02 08:26:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1404 | 3.1404 | 47600.0 |
| 2009-03-02 08:27:00 | AAPL | Stock | 3.1393 | 3.1393 | 3.1393 | 3.1393 | 28000.0 |
| 2009-03-02 08:28:00 | AAPL | Stock | 3.1404 | 3.1411 | 3.1404 | 3.1411 | 7952.0 |
| 2009-03-02 08:30:00 | AAPL | Stock | 3.1407 | 3.1407 | 3.1346 | 3.1346 | 9800.0 |
| 2009-03-02 08:31:00 | AAPL | Stock | 3.135 | 3.1429 | 3.1343 | 3.1429 | 117908.0 |
| 2009-03-02 08:32:00 | AAPL | Stock | 3.14 | 3.14 | 3.14 | 3.14 | 2800.0 |
| 2009-03-02 08:33:00 | AAPL | Stock | 3.1418 | 3.1418 | 3.1418 | 3.1418 | 5600.0 |
| 2009-03-02 08:34:00 | AAPL | Stock | 3.1425 | 3.1429 | 3.1379 | 3.1418 | 46200.0 |
| 2009-03-02 08:35:00 | AAPL | Stock | 3.1418 | 3.1418 | 3.1379 | 3.1379 | 14000.0 |
| 2009-03-02 08:38:00 | AAPL | Stock | 3.1429 | 3.1439 | 3.1429 | 3.1439 | 35056.0 |
| 2009-03-02 08:39:00 | AAPL | Stock | 3.1454 | 3.1464 | 3.1454 | 3.1464 | 22400.0 |
| 2009-03-02 08:40:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1429 | 3.1429 | 32200.0 |
| 2009-03-02 08:43:00 | AAPL | Stock | 3.1439 | 3.1446 | 3.1439 | 3.1446 | 7000.0 |
| 2009-03-02 08:44:00 | AAPL | Stock | 3.1471 | 3.1475 | 3.1471 | 3.1475 | 22400.0 |
| 2009-03-02 08:45:00 | AAPL | Stock | 3.1429 | 3.1446 | 3.1429 | 3.1446 | 8400.0 |
| 2009-03-02 08:46:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 2800.0 |
| 2009-03-02 08:47:00 | AAPL | Stock | 3.1468 | 3.1468 | 3.1468 | 3.1468 | 2800.0 |
| 2009-03-02 08:48:00 | AAPL | Stock | 3.1436 | 3.1436 | 3.1432 | 3.1432 | 11200.0 |
| 2009-03-02 08:50:00 | AAPL | Stock | 3.1461 | 3.1471 | 3.1461 | 3.1471 | 8400.0 |
| 2009-03-02 08:52:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 5600.0 |
| 2009-03-02 08:55:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1475 | 3.1475 | 2800.0 |
| 2009-03-02 08:56:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1475 | 3.1475 | 16800.0 |
| 2009-03-02 08:57:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1482 | 3.1482 | 22400.0 |
| 2009-03-02 08:58:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1475 | 3.1475 | 3080.0 |
| 2009-03-02 08:59:00 | AAPL | Stock | 3.1475 | 3.1489 | 3.1475 | 3.1486 | 43400.0 |
| 2009-03-02 09:00:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1489 | 3.1489 | 28560.0 |
> showing 50 of 1,022,230 rows — these rows as CSV