PREVIEW / stock_1min / 2002-05-01
file: by_date/stock_1min/2002/2002-05-01.parquet size: 4.3 MB rows: 333,940 symbols: 1,152
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-01 08:51:00 | AAPL | Stock | 0.4334 | 0.4334 | 0.4334 | 0.4334 | 89600.0 |
| 2002-05-01 08:55:00 | AAPL | Stock | 0.4334 | 0.4334 | 0.4334 | 0.4334 | 112000.0 |
| 2002-05-01 09:15:00 | AAPL | Stock | 0.4334 | 0.4334 | 0.4334 | 0.4334 | 78400.0 |
| 2002-05-01 09:16:00 | AAPL | Stock | 0.4339 | 0.4339 | 0.4338 | 0.4338 | 16800.0 |
| 2002-05-01 09:17:00 | AAPL | Stock | 0.4338 | 0.4338 | 0.4334 | 0.4334 | 33600.0 |
| 2002-05-01 09:22:00 | AAPL | Stock | 0.4334 | 0.4334 | 0.4334 | 0.4334 | 112000.0 |
| 2002-05-01 09:23:00 | AAPL | Stock | 0.433 | 0.433 | 0.433 | 0.433 | 11200.0 |
| 2002-05-01 09:26:00 | AAPL | Stock | 0.433 | 0.433 | 0.433 | 0.433 | 50400.0 |
| 2002-05-01 09:27:00 | AAPL | Stock | 0.433 | 0.4332 | 0.433 | 0.433 | 67200.0 |
| 2002-05-01 09:28:00 | AAPL | Stock | 0.4338 | 0.4339 | 0.4332 | 0.4339 | 162400.0 |
| 2002-05-01 09:29:00 | AAPL | Stock | 0.4338 | 0.4338 | 0.433 | 0.433 | 162400.0 |
| 2002-05-01 09:30:00 | AAPL | Stock | 0.4338 | 0.4338 | 0.4321 | 0.4321 | 2228800.0 |
| 2002-05-01 09:31:00 | AAPL | Stock | 0.4323 | 0.4338 | 0.4313 | 0.4313 | 767200.0 |
| 2002-05-01 09:32:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4304 | 0.4304 | 190400.0 |
| 2002-05-01 09:33:00 | AAPL | Stock | 0.4311 | 0.4318 | 0.4311 | 0.4314 | 375200.0 |
| 2002-05-01 09:34:00 | AAPL | Stock | 0.4316 | 0.432 | 0.4302 | 0.4302 | 498400.0 |
| 2002-05-01 09:35:00 | AAPL | Stock | 0.4302 | 0.4302 | 0.4291 | 0.4291 | 470400.0 |
| 2002-05-01 09:36:00 | AAPL | Stock | 0.4293 | 0.4304 | 0.4291 | 0.4293 | 655200.0 |
| 2002-05-01 09:37:00 | AAPL | Stock | 0.4293 | 0.4305 | 0.4293 | 0.43 | 464800.0 |
| 2002-05-01 09:38:00 | AAPL | Stock | 0.4295 | 0.4304 | 0.4295 | 0.4304 | 224000.0 |
| 2002-05-01 09:39:00 | AAPL | Stock | 0.4302 | 0.4302 | 0.4298 | 0.4302 | 324800.0 |
| 2002-05-01 09:40:00 | AAPL | Stock | 0.4304 | 0.4305 | 0.4291 | 0.4298 | 224000.0 |
| 2002-05-01 09:41:00 | AAPL | Stock | 0.4298 | 0.4298 | 0.4289 | 0.4289 | 218400.0 |
| 2002-05-01 09:42:00 | AAPL | Stock | 0.4289 | 0.4291 | 0.4273 | 0.4273 | 756000.0 |
| 2002-05-01 09:43:00 | AAPL | Stock | 0.4273 | 0.4273 | 0.4268 | 0.4271 | 711200.0 |
| 2002-05-01 09:44:00 | AAPL | Stock | 0.4271 | 0.428 | 0.4271 | 0.428 | 1030400.0 |
| 2002-05-01 09:45:00 | AAPL | Stock | 0.4277 | 0.4284 | 0.4277 | 0.4284 | 352800.0 |
| 2002-05-01 09:46:00 | AAPL | Stock | 0.4286 | 0.4295 | 0.4286 | 0.4288 | 884800.0 |
| 2002-05-01 09:47:00 | AAPL | Stock | 0.4288 | 0.4288 | 0.428 | 0.4282 | 1103200.0 |
| 2002-05-01 09:48:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.4275 | 0.4275 | 257600.0 |
| 2002-05-01 09:49:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4271 | 0.4271 | 1680000.0 |
| 2002-05-01 09:50:00 | AAPL | Stock | 0.4271 | 0.4277 | 0.4271 | 0.4275 | 296800.0 |
| 2002-05-01 09:51:00 | AAPL | Stock | 0.4275 | 0.4282 | 0.4273 | 0.428 | 795200.0 |
| 2002-05-01 09:52:00 | AAPL | Stock | 0.4279 | 0.428 | 0.4271 | 0.4271 | 582400.0 |
| 2002-05-01 09:53:00 | AAPL | Stock | 0.4271 | 0.4271 | 0.4255 | 0.4257 | 1136800.0 |
| 2002-05-01 09:54:00 | AAPL | Stock | 0.4259 | 0.4263 | 0.4252 | 0.4259 | 1327200.0 |
| 2002-05-01 09:55:00 | AAPL | Stock | 0.4264 | 0.4264 | 0.4254 | 0.4261 | 1288000.0 |
| 2002-05-01 09:56:00 | AAPL | Stock | 0.4264 | 0.4275 | 0.4261 | 0.4268 | 918400.0 |
| 2002-05-01 09:57:00 | AAPL | Stock | 0.4268 | 0.4271 | 0.4264 | 0.427 | 352800.0 |
| 2002-05-01 09:58:00 | AAPL | Stock | 0.4271 | 0.4271 | 0.4246 | 0.4247 | 705600.0 |
| 2002-05-01 09:59:00 | AAPL | Stock | 0.4255 | 0.4261 | 0.4248 | 0.4261 | 789600.0 |
| 2002-05-01 10:00:00 | AAPL | Stock | 0.4259 | 0.4261 | 0.4238 | 0.4239 | 1041600.0 |
| 2002-05-01 10:01:00 | AAPL | Stock | 0.4243 | 0.4243 | 0.423 | 0.423 | 1797600.0 |
| 2002-05-01 10:02:00 | AAPL | Stock | 0.4229 | 0.4254 | 0.4229 | 0.4241 | 1920800.0 |
| 2002-05-01 10:03:00 | AAPL | Stock | 0.4241 | 0.4252 | 0.4221 | 0.4223 | 1713600.0 |
| 2002-05-01 10:04:00 | AAPL | Stock | 0.4227 | 0.4243 | 0.4223 | 0.4238 | 369600.0 |
| 2002-05-01 10:05:00 | AAPL | Stock | 0.4243 | 0.4261 | 0.4243 | 0.4254 | 812000.0 |
| 2002-05-01 10:06:00 | AAPL | Stock | 0.4256 | 0.4256 | 0.4243 | 0.4243 | 716800.0 |
| 2002-05-01 10:07:00 | AAPL | Stock | 0.4241 | 0.4241 | 0.4223 | 0.4223 | 1601600.0 |
| 2002-05-01 10:08:00 | AAPL | Stock | 0.4225 | 0.4236 | 0.4223 | 0.4236 | 924000.0 |
> showing 50 of 333,940 rows — these rows as CSV