PREVIEW / stock_1min / 2012-01-23
file: by_date/stock_1min/2012/2012-01-23.parquet size: 12.6 MB rows: 935,834 symbols: 2,872
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-23 04:23:00 | AAPL | Stock | 15.0786 | 15.0786 | 15.0786 | 15.0786 | 2800.0 |
| 2012-01-23 04:40:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 5600.0 |
| 2012-01-23 04:41:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 8400.0 |
| 2012-01-23 05:14:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 2800.0 |
| 2012-01-23 05:18:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 5600.0 |
| 2012-01-23 05:38:00 | AAPL | Stock | 15.0982 | 15.0982 | 15.0982 | 15.0982 | 5460.0 |
| 2012-01-23 05:52:00 | AAPL | Stock | 15.1168 | 15.1168 | 15.1168 | 15.1168 | 2940.0 |
| 2012-01-23 05:57:00 | AAPL | Stock | 15.1214 | 15.1214 | 15.1214 | 15.1214 | 2800.0 |
| 2012-01-23 06:05:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2012-01-23 06:09:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 6468.0 |
| 2012-01-23 06:10:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2012-01-23 06:11:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5600.0 |
| 2012-01-23 06:15:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 14000.0 |
| 2012-01-23 06:25:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2012-01-23 06:29:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2012-01-23 06:30:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5600.0 |
| 2012-01-23 06:31:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5600.0 |
| 2012-01-23 06:34:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5600.0 |
| 2012-01-23 06:35:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 16800.0 |
| 2012-01-23 06:38:00 | AAPL | Stock | 15.1557 | 15.1557 | 15.1557 | 15.1557 | 2800.0 |
| 2012-01-23 06:39:00 | AAPL | Stock | 15.1736 | 15.1736 | 15.1736 | 15.1736 | 2800.0 |
| 2012-01-23 06:42:00 | AAPL | Stock | 15.1686 | 15.1686 | 15.1686 | 15.1686 | 5600.0 |
| 2012-01-23 06:43:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 2800.0 |
| 2012-01-23 06:51:00 | AAPL | Stock | 15.1464 | 15.1464 | 15.1464 | 15.1464 | 2800.0 |
| 2012-01-23 06:53:00 | AAPL | Stock | 15.1507 | 15.1507 | 15.1507 | 15.1507 | 2800.0 |
| 2012-01-23 06:55:00 | AAPL | Stock | 15.1464 | 15.1464 | 15.1464 | 15.1464 | 2800.0 |
| 2012-01-23 06:57:00 | AAPL | Stock | 15.1464 | 15.1464 | 15.1464 | 15.1464 | 5600.0 |
| 2012-01-23 07:00:00 | AAPL | Stock | 15.1411 | 15.1582 | 15.1411 | 15.1582 | 11200.0 |
| 2012-01-23 07:01:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5040.0 |
| 2012-01-23 07:02:00 | AAPL | Stock | 15.1354 | 15.1518 | 15.1339 | 15.1339 | 41160.0 |
| 2012-01-23 07:03:00 | AAPL | Stock | 15.1343 | 15.1343 | 15.1329 | 15.1329 | 14000.0 |
| 2012-01-23 07:04:00 | AAPL | Stock | 15.1329 | 15.1329 | 15.1329 | 15.1329 | 2800.0 |
| 2012-01-23 07:05:00 | AAPL | Stock | 15.1379 | 15.1379 | 15.1379 | 15.1379 | 2800.0 |
| 2012-01-23 07:06:00 | AAPL | Stock | 15.1371 | 15.1371 | 15.1339 | 15.1339 | 25200.0 |
| 2012-01-23 07:07:00 | AAPL | Stock | 15.1418 | 15.1429 | 15.1346 | 15.1429 | 8400.0 |
| 2012-01-23 07:08:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 5040.0 |
| 2012-01-23 07:09:00 | AAPL | Stock | 15.1368 | 15.1368 | 15.1293 | 15.1293 | 8400.0 |
| 2012-01-23 07:10:00 | AAPL | Stock | 15.1354 | 15.1354 | 15.1329 | 15.1346 | 14000.0 |
| 2012-01-23 07:11:00 | AAPL | Stock | 15.1261 | 15.1261 | 15.1246 | 15.1246 | 30100.0 |
| 2012-01-23 07:13:00 | AAPL | Stock | 15.115 | 15.1214 | 15.115 | 15.115 | 8400.0 |
| 2012-01-23 07:14:00 | AAPL | Stock | 15.115 | 15.115 | 15.1125 | 15.115 | 18088.0 |
| 2012-01-23 07:16:00 | AAPL | Stock | 15.1196 | 15.125 | 15.1071 | 15.1071 | 52136.0 |
| 2012-01-23 07:17:00 | AAPL | Stock | 15.1061 | 15.1061 | 15.1061 | 15.1061 | 2800.0 |
| 2012-01-23 07:19:00 | AAPL | Stock | 15.0946 | 15.0946 | 15.0893 | 15.0893 | 16800.0 |
| 2012-01-23 07:20:00 | AAPL | Stock | 15.1036 | 15.1036 | 15.1036 | 15.1036 | 2800.0 |
| 2012-01-23 07:27:00 | AAPL | Stock | 15.1032 | 15.1032 | 15.1032 | 15.1032 | 2800.0 |
| 2012-01-23 07:29:00 | AAPL | Stock | 15.1057 | 15.1057 | 15.1057 | 15.1057 | 2800.0 |
| 2012-01-23 07:32:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 11200.0 |
| 2012-01-23 07:33:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 8400.0 |
| 2012-01-23 07:37:00 | AAPL | Stock | 15.1036 | 15.1036 | 15.09 | 15.09 | 44100.0 |
> showing 50 of 935,834 rows — these rows as CSV