PREVIEW / stock_1min / 2012-01-09
file: by_date/stock_1min/2012/2012-01-09.parquet size: 12.6 MB rows: 949,482 symbols: 2,865
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-09 04:03:00 | AAPL | Stock | 15.1254 | 15.1254 | 15.1254 | 15.1254 | 3360.0 |
| 2012-01-09 04:09:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2012-01-09 05:04:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 28000.0 |
| 2012-01-09 05:06:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 14000.0 |
| 2012-01-09 05:07:00 | AAPL | Stock | 15.1161 | 15.1161 | 15.1161 | 15.1161 | 11200.0 |
| 2012-01-09 05:26:00 | AAPL | Stock | 15.1075 | 15.1075 | 15.1075 | 15.1075 | 5600.0 |
| 2012-01-09 06:01:00 | AAPL | Stock | 15.0982 | 15.0982 | 15.0982 | 15.0982 | 5600.0 |
| 2012-01-09 06:02:00 | AAPL | Stock | 15.0982 | 15.0982 | 15.0982 | 15.0982 | 5600.0 |
| 2012-01-09 06:04:00 | AAPL | Stock | 15.0982 | 15.0982 | 15.0982 | 15.0982 | 16800.0 |
| 2012-01-09 06:05:00 | AAPL | Stock | 15.0914 | 15.0914 | 15.0914 | 15.0914 | 2800.0 |
| 2012-01-09 07:01:00 | AAPL | Stock | 15.0964 | 15.0964 | 15.0964 | 15.0964 | 2940.0 |
| 2012-01-09 07:02:00 | AAPL | Stock | 15.1021 | 15.1271 | 15.0914 | 15.0914 | 36428.0 |
| 2012-01-09 07:03:00 | AAPL | Stock | 15.1214 | 15.1329 | 15.1214 | 15.1271 | 28000.0 |
| 2012-01-09 07:04:00 | AAPL | Stock | 15.1207 | 15.1207 | 15.1207 | 15.1207 | 5600.0 |
| 2012-01-09 07:05:00 | AAPL | Stock | 15.1221 | 15.1332 | 15.1221 | 15.1332 | 61600.0 |
| 2012-01-09 07:07:00 | AAPL | Stock | 15.1339 | 15.1429 | 15.1339 | 15.1429 | 25200.0 |
| 2012-01-09 07:10:00 | AAPL | Stock | 15.1339 | 15.1339 | 15.1339 | 15.1339 | 67480.0 |
| 2012-01-09 07:16:00 | AAPL | Stock | 15.1304 | 15.1304 | 15.1304 | 15.1304 | 8400.0 |
| 2012-01-09 07:18:00 | AAPL | Stock | 15.1304 | 15.1304 | 15.1214 | 15.1214 | 8400.0 |
| 2012-01-09 07:19:00 | AAPL | Stock | 15.1207 | 15.1207 | 15.1207 | 15.1207 | 5600.0 |
| 2012-01-09 07:20:00 | AAPL | Stock | 15.1246 | 15.1246 | 15.1246 | 15.1246 | 28000.0 |
| 2012-01-09 07:24:00 | AAPL | Stock | 15.1254 | 15.1254 | 15.1254 | 15.1254 | 2800.0 |
| 2012-01-09 07:29:00 | AAPL | Stock | 15.1257 | 15.1475 | 15.1257 | 15.1429 | 82740.0 |
| 2012-01-09 07:31:00 | AAPL | Stock | 15.1425 | 15.1425 | 15.1425 | 15.1425 | 2800.0 |
| 2012-01-09 07:32:00 | AAPL | Stock | 15.1439 | 15.1475 | 15.1439 | 15.1475 | 5600.0 |
| 2012-01-09 07:33:00 | AAPL | Stock | 15.1329 | 15.1329 | 15.1329 | 15.1329 | 5600.0 |
| 2012-01-09 07:34:00 | AAPL | Stock | 15.1471 | 15.15 | 15.1471 | 15.1475 | 14000.0 |
| 2012-01-09 07:36:00 | AAPL | Stock | 15.1514 | 15.1514 | 15.1479 | 15.1479 | 5600.0 |
| 2012-01-09 07:37:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 2800.0 |
| 2012-01-09 07:38:00 | AAPL | Stock | 15.1475 | 15.1475 | 15.1475 | 15.1475 | 8680.0 |
| 2012-01-09 07:40:00 | AAPL | Stock | 15.1568 | 15.1582 | 15.1568 | 15.1571 | 30800.0 |
| 2012-01-09 07:44:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 8400.0 |
| 2012-01-09 07:45:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 16800.0 |
| 2012-01-09 07:46:00 | AAPL | Stock | 15.1514 | 15.1514 | 15.1514 | 15.1514 | 2800.0 |
| 2012-01-09 07:47:00 | AAPL | Stock | 15.1475 | 15.1514 | 15.1429 | 15.1429 | 12600.0 |
| 2012-01-09 07:48:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1339 | 15.1339 | 8400.0 |
| 2012-01-09 07:51:00 | AAPL | Stock | 15.1332 | 15.1339 | 15.1332 | 15.1339 | 5600.0 |
| 2012-01-09 07:53:00 | AAPL | Stock | 15.1321 | 15.1321 | 15.1304 | 15.1321 | 22400.0 |
| 2012-01-09 07:54:00 | AAPL | Stock | 15.1404 | 15.1457 | 15.1404 | 15.1457 | 16800.0 |
| 2012-01-09 07:56:00 | AAPL | Stock | 15.1507 | 15.1514 | 15.1375 | 15.1375 | 112700.0 |
| 2012-01-09 07:57:00 | AAPL | Stock | 15.1404 | 15.1421 | 15.1404 | 15.1418 | 33320.0 |
| 2012-01-09 07:58:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1393 | 15.1393 | 40992.0 |
| 2012-01-09 07:59:00 | AAPL | Stock | 15.1421 | 15.1429 | 15.1421 | 15.1429 | 36400.0 |
| 2012-01-09 08:00:00 | AAPL | Stock | 15.1332 | 15.1429 | 15.1232 | 15.1386 | 138040.0 |
| 2012-01-09 08:01:00 | AAPL | Stock | 15.1386 | 15.1386 | 15.1386 | 15.1386 | 2800.0 |
| 2012-01-09 08:02:00 | AAPL | Stock | 15.1389 | 15.1411 | 15.1389 | 15.1411 | 13020.0 |
| 2012-01-09 08:03:00 | AAPL | Stock | 15.1407 | 15.1429 | 15.1393 | 15.1429 | 105980.0 |
| 2012-01-09 08:04:00 | AAPL | Stock | 15.1425 | 15.1429 | 15.1393 | 15.1407 | 72884.0 |
| 2012-01-09 08:05:00 | AAPL | Stock | 15.1404 | 15.1407 | 15.1404 | 15.1407 | 8400.0 |
| 2012-01-09 08:06:00 | AAPL | Stock | 15.1404 | 15.1411 | 15.1393 | 15.1393 | 39200.0 |
> showing 50 of 949,482 rows — these rows as CSV