PREVIEW / stock_1min / 2005-12-14
file: by_date/stock_1min/2005/2005-12-14.parquet size: 7.5 MB rows: 609,734 symbols: 1,766
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-14 04:28:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6643 | 2.6643 | 8400.0 |
| 2005-12-14 04:35:00 | AAPL | Stock | 2.6532 | 2.6532 | 2.65 | 2.65 | 33600.0 |
| 2005-12-14 04:40:00 | AAPL | Stock | 2.6482 | 2.6482 | 2.6482 | 2.6482 | 8400.0 |
| 2005-12-14 04:45:00 | AAPL | Stock | 2.6436 | 2.6436 | 2.6436 | 2.6436 | 2800.0 |
| 2005-12-14 04:50:00 | AAPL | Stock | 2.6364 | 2.6364 | 2.6357 | 2.6357 | 5600.0 |
| 2005-12-14 05:02:00 | AAPL | Stock | 2.6268 | 2.6268 | 2.6268 | 2.6268 | 5600.0 |
| 2005-12-14 05:24:00 | AAPL | Stock | 2.6143 | 2.6143 | 2.6143 | 2.6143 | 29148.0 |
| 2005-12-14 05:25:00 | AAPL | Stock | 2.6161 | 2.6161 | 2.6161 | 2.6161 | 2800.0 |
| 2005-12-14 05:57:00 | AAPL | Stock | 2.6071 | 2.6071 | 2.6071 | 2.6071 | 14000.0 |
| 2005-12-14 06:01:00 | AAPL | Stock | 2.6161 | 2.6161 | 2.6161 | 2.6161 | 14000.0 |
| 2005-12-14 06:03:00 | AAPL | Stock | 2.6196 | 2.6196 | 2.6196 | 2.6196 | 14000.0 |
| 2005-12-14 06:19:00 | AAPL | Stock | 2.6193 | 2.6193 | 2.6193 | 2.6193 | 2800.0 |
| 2005-12-14 06:28:00 | AAPL | Stock | 2.6286 | 2.6286 | 2.6286 | 2.6286 | 2800.0 |
| 2005-12-14 06:29:00 | AAPL | Stock | 2.6321 | 2.6321 | 2.6321 | 2.6321 | 2800.0 |
| 2005-12-14 06:30:00 | AAPL | Stock | 2.6193 | 2.6193 | 2.6193 | 2.6193 | 25200.0 |
| 2005-12-14 06:56:00 | AAPL | Stock | 2.6286 | 2.6286 | 2.6286 | 2.6286 | 5600.0 |
| 2005-12-14 07:00:00 | AAPL | Stock | 2.6196 | 2.6196 | 2.6075 | 2.6075 | 148400.0 |
| 2005-12-14 07:01:00 | AAPL | Stock | 2.6068 | 2.6068 | 2.6068 | 2.6068 | 2800.0 |
| 2005-12-14 07:04:00 | AAPL | Stock | 2.6143 | 2.6143 | 2.6143 | 2.6143 | 8400.0 |
| 2005-12-14 07:05:00 | AAPL | Stock | 2.6082 | 2.6082 | 2.6082 | 2.6082 | 28000.0 |
| 2005-12-14 07:06:00 | AAPL | Stock | 2.6089 | 2.6107 | 2.6089 | 2.6107 | 42000.0 |
| 2005-12-14 07:10:00 | AAPL | Stock | 2.6161 | 2.6161 | 2.6161 | 2.6161 | 14000.0 |
| 2005-12-14 07:18:00 | AAPL | Stock | 2.6246 | 2.6246 | 2.6246 | 2.6246 | 2800.0 |
| 2005-12-14 07:19:00 | AAPL | Stock | 2.6239 | 2.6239 | 2.6236 | 2.6239 | 36400.0 |
| 2005-12-14 07:21:00 | AAPL | Stock | 2.6232 | 2.6232 | 2.6232 | 2.6232 | 86828.0 |
| 2005-12-14 07:32:00 | AAPL | Stock | 2.6182 | 2.6182 | 2.6182 | 2.6182 | 2800.0 |
| 2005-12-14 07:33:00 | AAPL | Stock | 2.6182 | 2.6182 | 2.6182 | 2.6182 | 21000.0 |
| 2005-12-14 07:34:00 | AAPL | Stock | 2.6182 | 2.6182 | 2.6182 | 2.6182 | 56000.0 |
| 2005-12-14 07:35:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6214 | 2.6214 | 2800.0 |
| 2005-12-14 07:38:00 | AAPL | Stock | 2.625 | 2.625 | 2.625 | 2.625 | 2800.0 |
| 2005-12-14 07:39:00 | AAPL | Stock | 2.625 | 2.625 | 2.625 | 2.625 | 2800.0 |
| 2005-12-14 07:40:00 | AAPL | Stock | 2.6279 | 2.6279 | 2.6279 | 2.6279 | 39200.0 |
| 2005-12-14 07:44:00 | AAPL | Stock | 2.6268 | 2.6268 | 2.6268 | 2.6268 | 14000.0 |
| 2005-12-14 07:45:00 | AAPL | Stock | 2.6268 | 2.6268 | 2.6268 | 2.6268 | 2800.0 |
| 2005-12-14 07:48:00 | AAPL | Stock | 2.6254 | 2.6254 | 2.625 | 2.625 | 193480.0 |
| 2005-12-14 07:52:00 | AAPL | Stock | 2.625 | 2.625 | 2.6214 | 2.6214 | 28000.0 |
| 2005-12-14 07:53:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6179 | 2.6179 | 295400.0 |
| 2005-12-14 07:54:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6214 | 2.6214 | 27860.0 |
| 2005-12-14 07:55:00 | AAPL | Stock | 2.6236 | 2.6246 | 2.6232 | 2.6232 | 56000.0 |
| 2005-12-14 07:56:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6214 | 2.6214 | 30800.0 |
| 2005-12-14 07:57:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6214 | 2.6214 | 5600.0 |
| 2005-12-14 07:58:00 | AAPL | Stock | 2.6189 | 2.6189 | 2.6186 | 2.6186 | 16660.0 |
| 2005-12-14 07:59:00 | AAPL | Stock | 2.6207 | 2.6211 | 2.6186 | 2.6186 | 61600.0 |
| 2005-12-14 08:00:00 | AAPL | Stock | 2.6211 | 2.6286 | 2.6186 | 2.6211 | 735364.0 |
| 2005-12-14 08:01:00 | AAPL | Stock | 2.6207 | 2.625 | 2.6186 | 2.6207 | 1071392.0 |
| 2005-12-14 08:02:00 | AAPL | Stock | 2.62 | 2.6214 | 2.62 | 2.6211 | 642656.0 |
| 2005-12-14 08:03:00 | AAPL | Stock | 2.6214 | 2.6218 | 2.6143 | 2.6143 | 1041992.0 |
| 2005-12-14 08:04:00 | AAPL | Stock | 2.6143 | 2.615 | 2.6118 | 2.6121 | 275016.0 |
| 2005-12-14 08:05:00 | AAPL | Stock | 2.6132 | 2.6143 | 2.6121 | 2.6121 | 536480.0 |
| 2005-12-14 08:06:00 | AAPL | Stock | 2.6125 | 2.6164 | 2.61 | 2.6111 | 529648.0 |
> showing 50 of 609,734 rows — these rows as CSV