PREVIEW / stock_1min / 2013-03-05
file: by_date/stock_1min/2013/2013-03-05.parquet size: 13.8 MB rows: 1,014,428 symbols: 2,832
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-05 04:00:00 | AAPL | Stock | 14.9893 | 14.9893 | 14.9893 | 14.9893 | 2800.0 |
| 2013-03-05 04:05:00 | AAPL | Stock | 14.9714 | 14.9714 | 14.9496 | 14.9496 | 9324.0 |
| 2013-03-05 04:30:00 | AAPL | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 11200.0 |
| 2013-03-05 04:31:00 | AAPL | Stock | 14.9893 | 14.9893 | 14.9893 | 14.9893 | 5600.0 |
| 2013-03-05 04:40:00 | AAPL | Stock | 14.9893 | 14.9893 | 14.9893 | 14.9893 | 2800.0 |
| 2013-03-05 05:10:00 | AAPL | Stock | 14.995 | 14.995 | 14.9946 | 14.9946 | 14644.0 |
| 2013-03-05 05:18:00 | AAPL | Stock | 14.9946 | 14.9946 | 14.9946 | 14.9946 | 2800.0 |
| 2013-03-05 05:20:00 | AAPL | Stock | 14.9946 | 14.9946 | 14.9946 | 14.9946 | 2800.0 |
| 2013-03-05 05:29:00 | AAPL | Stock | 14.9946 | 15.0 | 14.9946 | 15.0 | 5600.0 |
| 2013-03-05 05:30:00 | AAPL | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 28000.0 |
| 2013-03-05 05:44:00 | AAPL | Stock | 14.9964 | 14.9964 | 14.9946 | 14.9946 | 14000.0 |
| 2013-03-05 05:45:00 | AAPL | Stock | 14.9946 | 15.0 | 14.9946 | 15.0 | 5600.0 |
| 2013-03-05 05:49:00 | AAPL | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 8400.0 |
| 2013-03-05 06:19:00 | AAPL | Stock | 15.0 | 15.0125 | 15.0 | 15.0125 | 25620.0 |
| 2013-03-05 06:24:00 | AAPL | Stock | 15.0107 | 15.0107 | 15.0107 | 15.0107 | 8400.0 |
| 2013-03-05 06:25:00 | AAPL | Stock | 15.0018 | 15.0018 | 15.0004 | 15.0004 | 5600.0 |
| 2013-03-05 06:29:00 | AAPL | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 2800.0 |
| 2013-03-05 06:43:00 | AAPL | Stock | 15.0071 | 15.0071 | 15.0071 | 15.0071 | 2800.0 |
| 2013-03-05 06:44:00 | AAPL | Stock | 15.0171 | 15.0179 | 15.0171 | 15.0179 | 19488.0 |
| 2013-03-05 06:46:00 | AAPL | Stock | 15.0039 | 15.0039 | 15.0004 | 15.0004 | 5600.0 |
| 2013-03-05 06:54:00 | AAPL | Stock | 15.0211 | 15.0211 | 15.0211 | 15.0211 | 2828.0 |
| 2013-03-05 06:57:00 | AAPL | Stock | 15.025 | 15.025 | 15.025 | 15.025 | 7000.0 |
| 2013-03-05 06:58:00 | AAPL | Stock | 15.0275 | 15.0404 | 15.0275 | 15.0404 | 21196.0 |
| 2013-03-05 06:59:00 | AAPL | Stock | 15.0357 | 15.0357 | 15.0357 | 15.0357 | 5600.0 |
| 2013-03-05 07:00:00 | AAPL | Stock | 15.0246 | 15.0246 | 15.0246 | 15.0246 | 4424.0 |
| 2013-03-05 07:01:00 | AAPL | Stock | 15.0357 | 15.0357 | 15.0357 | 15.0357 | 5600.0 |
| 2013-03-05 07:02:00 | AAPL | Stock | 15.0404 | 15.0404 | 15.0404 | 15.0404 | 16800.0 |
| 2013-03-05 07:03:00 | AAPL | Stock | 15.0489 | 15.05 | 15.0489 | 15.05 | 8400.0 |
| 2013-03-05 07:05:00 | AAPL | Stock | 15.0446 | 15.0446 | 15.0446 | 15.0446 | 2800.0 |
| 2013-03-05 07:07:00 | AAPL | Stock | 15.0454 | 15.0454 | 15.0454 | 15.0454 | 2800.0 |
| 2013-03-05 07:08:00 | AAPL | Stock | 15.0461 | 15.0625 | 15.0461 | 15.0625 | 19600.0 |
| 2013-03-05 07:09:00 | AAPL | Stock | 15.0846 | 15.0936 | 15.0846 | 15.0936 | 10444.0 |
| 2013-03-05 07:10:00 | AAPL | Stock | 15.1064 | 15.1068 | 15.1064 | 15.1068 | 16100.0 |
| 2013-03-05 07:11:00 | AAPL | Stock | 15.0893 | 15.0893 | 15.0893 | 15.0893 | 2800.0 |
| 2013-03-05 07:12:00 | AAPL | Stock | 15.0964 | 15.0964 | 15.0893 | 15.0893 | 40600.0 |
| 2013-03-05 07:13:00 | AAPL | Stock | 15.0893 | 15.125 | 15.0893 | 15.125 | 28140.0 |
| 2013-03-05 07:14:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 2800.0 |
| 2013-03-05 07:16:00 | AAPL | Stock | 15.1021 | 15.1021 | 15.1 | 15.1 | 9688.0 |
| 2013-03-05 07:17:00 | AAPL | Stock | 15.1104 | 15.1229 | 15.1096 | 15.1096 | 8400.0 |
| 2013-03-05 07:19:00 | AAPL | Stock | 15.1175 | 15.12 | 15.1175 | 15.12 | 27020.0 |
| 2013-03-05 07:22:00 | AAPL | Stock | 15.1161 | 15.1304 | 15.1161 | 15.1304 | 18200.0 |
| 2013-03-05 07:24:00 | AAPL | Stock | 15.1354 | 15.1657 | 15.1354 | 15.165 | 121044.0 |
| 2013-03-05 07:25:00 | AAPL | Stock | 15.1604 | 15.1607 | 15.1589 | 15.1607 | 19600.0 |
| 2013-03-05 07:26:00 | AAPL | Stock | 15.1429 | 15.1604 | 15.1429 | 15.1432 | 42420.0 |
| 2013-03-05 07:27:00 | AAPL | Stock | 15.1464 | 15.1464 | 15.1411 | 15.1411 | 5600.0 |
| 2013-03-05 07:29:00 | AAPL | Stock | 15.1436 | 15.1436 | 15.1436 | 15.1436 | 2800.0 |
| 2013-03-05 07:30:00 | AAPL | Stock | 15.1425 | 15.1425 | 15.1425 | 15.1425 | 2800.0 |
| 2013-03-05 07:31:00 | AAPL | Stock | 15.1325 | 15.1339 | 15.1268 | 15.1268 | 63056.0 |
| 2013-03-05 07:32:00 | AAPL | Stock | 15.1286 | 15.1286 | 15.1071 | 15.1071 | 33600.0 |
| 2013-03-05 07:33:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1068 | 15.1071 | 21868.0 |
> showing 50 of 1,014,428 rows — these rows as CSV