PREVIEW / stock_1min / 2006-01-13
file: by_date/stock_1min/2006/2006-01-13.parquet size: 7.4 MB rows: 604,558 symbols: 1,770
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-13 07:00:00 | AAPL | Stock | 3.0036 | 3.0068 | 3.0036 | 3.005 | 16800.0 |
| 2006-01-13 07:01:00 | AAPL | Stock | 3.005 | 3.0104 | 3.005 | 3.0104 | 30800.0 |
| 2006-01-13 07:02:00 | AAPL | Stock | 3.0104 | 3.0104 | 3.0104 | 3.0104 | 2800.0 |
| 2006-01-13 07:09:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0111 | 3.0111 | 2800.0 |
| 2006-01-13 07:10:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0111 | 3.0111 | 2800.0 |
| 2006-01-13 07:20:00 | AAPL | Stock | 3.0089 | 3.0089 | 3.0089 | 3.0089 | 14000.0 |
| 2006-01-13 07:21:00 | AAPL | Stock | 3.0104 | 3.0104 | 3.0104 | 3.0104 | 2800.0 |
| 2006-01-13 07:28:00 | AAPL | Stock | 3.0089 | 3.0089 | 3.0089 | 3.0089 | 42000.0 |
| 2006-01-13 07:34:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0107 | 3.0107 | 2800.0 |
| 2006-01-13 07:37:00 | AAPL | Stock | 3.0139 | 3.0139 | 3.0139 | 3.0139 | 2800.0 |
| 2006-01-13 07:43:00 | AAPL | Stock | 3.0179 | 3.0196 | 3.0179 | 3.0196 | 5600.0 |
| 2006-01-13 07:44:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0179 | 3.0179 | 30800.0 |
| 2006-01-13 07:45:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 5320.0 |
| 2006-01-13 07:46:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 14000.0 |
| 2006-01-13 07:50:00 | AAPL | Stock | 3.0232 | 3.0232 | 3.0232 | 3.0232 | 16800.0 |
| 2006-01-13 07:51:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 2800.0 |
| 2006-01-13 07:52:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 11200.0 |
| 2006-01-13 07:53:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0261 | 3.0261 | 16800.0 |
| 2006-01-13 07:54:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0261 | 3.0261 | 14000.0 |
| 2006-01-13 07:55:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0179 | 3.0179 | 110600.0 |
| 2006-01-13 07:56:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0129 | 3.0129 | 5600.0 |
| 2006-01-13 07:57:00 | AAPL | Stock | 3.0129 | 3.0179 | 3.0129 | 3.0179 | 20384.0 |
| 2006-01-13 07:59:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0107 | 3.0107 | 8400.0 |
| 2006-01-13 08:00:00 | AAPL | Stock | 3.0204 | 3.0329 | 3.0164 | 3.0164 | 425740.0 |
| 2006-01-13 08:01:00 | AAPL | Stock | 3.0179 | 3.0339 | 3.0129 | 3.0207 | 444276.0 |
| 2006-01-13 08:02:00 | AAPL | Stock | 3.0207 | 3.0214 | 3.0146 | 3.0214 | 224700.0 |
| 2006-01-13 08:03:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0179 | 3.0186 | 75320.0 |
| 2006-01-13 08:04:00 | AAPL | Stock | 3.0186 | 3.0232 | 3.0179 | 3.0232 | 184072.0 |
| 2006-01-13 08:05:00 | AAPL | Stock | 3.0232 | 3.0304 | 3.0232 | 3.0268 | 123592.0 |
| 2006-01-13 08:06:00 | AAPL | Stock | 3.0275 | 3.0282 | 3.0275 | 3.0282 | 187600.0 |
| 2006-01-13 08:07:00 | AAPL | Stock | 3.0282 | 3.0393 | 3.0282 | 3.0343 | 545048.0 |
| 2006-01-13 08:08:00 | AAPL | Stock | 3.0343 | 3.0357 | 3.0321 | 3.0339 | 93380.0 |
| 2006-01-13 08:09:00 | AAPL | Stock | 3.0325 | 3.0325 | 3.0286 | 3.0286 | 43540.0 |
| 2006-01-13 08:10:00 | AAPL | Stock | 3.0286 | 3.0293 | 3.0286 | 3.0293 | 110600.0 |
| 2006-01-13 08:11:00 | AAPL | Stock | 3.0314 | 3.0318 | 3.0296 | 3.0296 | 39200.0 |
| 2006-01-13 08:12:00 | AAPL | Stock | 3.0296 | 3.0296 | 3.0254 | 3.0286 | 167608.0 |
| 2006-01-13 08:13:00 | AAPL | Stock | 3.0268 | 3.0286 | 3.0268 | 3.0286 | 39200.0 |
| 2006-01-13 08:14:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0232 | 3.0232 | 290528.0 |
| 2006-01-13 08:15:00 | AAPL | Stock | 3.0214 | 3.025 | 3.0186 | 3.0214 | 56280.0 |
| 2006-01-13 08:16:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0193 | 3.0193 | 42000.0 |
| 2006-01-13 08:17:00 | AAPL | Stock | 3.0214 | 3.0218 | 3.0196 | 3.0214 | 183680.0 |
| 2006-01-13 08:18:00 | AAPL | Stock | 3.0196 | 3.0214 | 3.0179 | 3.0179 | 213472.0 |
| 2006-01-13 08:19:00 | AAPL | Stock | 3.0196 | 3.0196 | 3.0179 | 3.0179 | 120260.0 |
| 2006-01-13 08:20:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 23800.0 |
| 2006-01-13 08:21:00 | AAPL | Stock | 3.0193 | 3.0225 | 3.0193 | 3.0225 | 33600.0 |
| 2006-01-13 08:22:00 | AAPL | Stock | 3.0221 | 3.0232 | 3.0214 | 3.0214 | 8932.0 |
| 2006-01-13 08:23:00 | AAPL | Stock | 3.0214 | 3.0232 | 3.0214 | 3.0232 | 19600.0 |
| 2006-01-13 08:24:00 | AAPL | Stock | 3.0225 | 3.0243 | 3.0225 | 3.0243 | 86800.0 |
| 2006-01-13 08:25:00 | AAPL | Stock | 3.0243 | 3.0264 | 3.0243 | 3.0264 | 162876.0 |
| 2006-01-13 08:26:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0246 | 3.025 | 47824.0 |
> showing 50 of 604,558 rows — these rows as CSV