PREVIEW / stock_1min / 2004-01-09
file: by_date/stock_1min/2004/2004-01-09.parquet size: 6.0 MB rows: 492,286 symbols: 1,407
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-09 08:30:00 | AAPL | Stock | 0.4205 | 0.4205 | 0.4188 | 0.4188 | 588000.0 |
| 2004-01-09 08:31:00 | AAPL | Stock | 0.4179 | 0.4196 | 0.417 | 0.417 | 314776.0 |
| 2004-01-09 08:32:00 | AAPL | Stock | 0.4169 | 0.4169 | 0.4152 | 0.4152 | 33600.0 |
| 2004-01-09 08:35:00 | AAPL | Stock | 0.4169 | 0.4169 | 0.4169 | 0.4169 | 11200.0 |
| 2004-01-09 08:37:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.4138 | 0.4138 | 22400.0 |
| 2004-01-09 08:39:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.4136 | 0.4136 | 25200.0 |
| 2004-01-09 08:40:00 | AAPL | Stock | 0.4136 | 0.4136 | 0.4136 | 0.4136 | 56000.0 |
| 2004-01-09 08:43:00 | AAPL | Stock | 0.4143 | 0.4143 | 0.4143 | 0.4143 | 5600.0 |
| 2004-01-09 08:44:00 | AAPL | Stock | 0.4145 | 0.4145 | 0.4145 | 0.4145 | 22400.0 |
| 2004-01-09 08:49:00 | AAPL | Stock | 0.4161 | 0.4177 | 0.4161 | 0.4177 | 50680.0 |
| 2004-01-09 08:59:00 | AAPL | Stock | 0.4175 | 0.4175 | 0.4175 | 0.4175 | 5600.0 |
| 2004-01-09 09:06:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4136 | 0.4143 | 162400.0 |
| 2004-01-09 09:14:00 | AAPL | Stock | 0.4145 | 0.4145 | 0.4136 | 0.4136 | 50400.0 |
| 2004-01-09 09:25:00 | AAPL | Stock | 0.4141 | 0.4141 | 0.4141 | 0.4141 | 11200.0 |
| 2004-01-09 09:26:00 | AAPL | Stock | 0.4136 | 0.4141 | 0.4136 | 0.4141 | 67200.0 |
| 2004-01-09 09:27:00 | AAPL | Stock | 0.4143 | 0.4143 | 0.4143 | 0.4143 | 145600.0 |
| 2004-01-09 09:29:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4159 | 0.4159 | 358400.0 |
| 2004-01-09 09:30:00 | AAPL | Stock | 0.4148 | 0.4182 | 0.4143 | 0.4179 | 2931264.0 |
| 2004-01-09 09:31:00 | AAPL | Stock | 0.4179 | 0.4182 | 0.4161 | 0.4182 | 2285192.0 |
| 2004-01-09 09:32:00 | AAPL | Stock | 0.418 | 0.4193 | 0.4179 | 0.4184 | 882896.0 |
| 2004-01-09 09:33:00 | AAPL | Stock | 0.4186 | 0.4211 | 0.4179 | 0.4211 | 1977976.0 |
| 2004-01-09 09:34:00 | AAPL | Stock | 0.4209 | 0.4214 | 0.4196 | 0.4196 | 2878456.0 |
| 2004-01-09 09:35:00 | AAPL | Stock | 0.42 | 0.4202 | 0.4196 | 0.4196 | 3134488.0 |
| 2004-01-09 09:36:00 | AAPL | Stock | 0.4197 | 0.42 | 0.4196 | 0.4196 | 2647008.0 |
| 2004-01-09 09:37:00 | AAPL | Stock | 0.4198 | 0.4202 | 0.4196 | 0.4196 | 5200160.0 |
| 2004-01-09 09:38:00 | AAPL | Stock | 0.4202 | 0.4211 | 0.4198 | 0.4207 | 964880.0 |
| 2004-01-09 09:39:00 | AAPL | Stock | 0.4207 | 0.4216 | 0.4202 | 0.421 | 3533656.0 |
| 2004-01-09 09:40:00 | AAPL | Stock | 0.4213 | 0.4213 | 0.4188 | 0.4196 | 6046880.0 |
| 2004-01-09 09:41:00 | AAPL | Stock | 0.4196 | 0.4202 | 0.4193 | 0.4195 | 2632000.0 |
| 2004-01-09 09:42:00 | AAPL | Stock | 0.4195 | 0.4209 | 0.4191 | 0.4196 | 2250360.0 |
| 2004-01-09 09:43:00 | AAPL | Stock | 0.4196 | 0.4204 | 0.4196 | 0.4202 | 628656.0 |
| 2004-01-09 09:44:00 | AAPL | Stock | 0.42 | 0.4204 | 0.4198 | 0.42 | 2798880.0 |
| 2004-01-09 09:45:00 | AAPL | Stock | 0.4202 | 0.4204 | 0.42 | 0.42 | 810656.0 |
| 2004-01-09 09:46:00 | AAPL | Stock | 0.42 | 0.4205 | 0.42 | 0.42 | 796768.0 |
| 2004-01-09 09:47:00 | AAPL | Stock | 0.42 | 0.4202 | 0.42 | 0.42 | 608104.0 |
| 2004-01-09 09:48:00 | AAPL | Stock | 0.4202 | 0.4204 | 0.4196 | 0.4202 | 1499176.0 |
| 2004-01-09 09:49:00 | AAPL | Stock | 0.4204 | 0.4205 | 0.4202 | 0.4204 | 1898400.0 |
| 2004-01-09 09:50:00 | AAPL | Stock | 0.4204 | 0.4216 | 0.4204 | 0.4214 | 3109960.0 |
| 2004-01-09 09:51:00 | AAPL | Stock | 0.4216 | 0.4227 | 0.4214 | 0.4223 | 1257200.0 |
| 2004-01-09 09:52:00 | AAPL | Stock | 0.4225 | 0.4227 | 0.422 | 0.4225 | 1588720.0 |
| 2004-01-09 09:53:00 | AAPL | Stock | 0.4225 | 0.4241 | 0.4225 | 0.4236 | 1739976.0 |
| 2004-01-09 09:54:00 | AAPL | Stock | 0.4239 | 0.4257 | 0.4236 | 0.4257 | 2288832.0 |
| 2004-01-09 09:55:00 | AAPL | Stock | 0.4254 | 0.4259 | 0.425 | 0.4259 | 2113160.0 |
| 2004-01-09 09:56:00 | AAPL | Stock | 0.4259 | 0.4268 | 0.425 | 0.4264 | 4198152.0 |
| 2004-01-09 09:57:00 | AAPL | Stock | 0.4263 | 0.4271 | 0.4248 | 0.4271 | 3236240.0 |
| 2004-01-09 09:58:00 | AAPL | Stock | 0.4273 | 0.4275 | 0.4266 | 0.4266 | 3986080.0 |
| 2004-01-09 09:59:00 | AAPL | Stock | 0.4264 | 0.4266 | 0.4252 | 0.4261 | 2552816.0 |
| 2004-01-09 10:00:00 | AAPL | Stock | 0.4261 | 0.4266 | 0.4259 | 0.4264 | 2552480.0 |
| 2004-01-09 10:01:00 | AAPL | Stock | 0.4266 | 0.4286 | 0.4263 | 0.4286 | 4372984.0 |
| 2004-01-09 10:02:00 | AAPL | Stock | 0.4286 | 0.4304 | 0.4284 | 0.4302 | 9530472.0 |
> showing 50 of 492,286 rows — these rows as CSV