PREVIEW / stock_1min / 2005-04-14
file: by_date/stock_1min/2005/2005-04-14.parquet size: 6.9 MB rows: 562,488 symbols: 1,613
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-04-14 05:54:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.4518 | 1.4518 | 140000.0 |
| 2005-04-14 05:55:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.4518 | 1.4518 | 39200.0 |
| 2005-04-14 06:54:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 28000.0 |
| 2005-04-14 06:55:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 28000.0 |
| 2005-04-14 07:32:00 | AAPL | Stock | 1.4286 | 1.4286 | 1.4286 | 1.4286 | 36400.0 |
| 2005-04-14 07:33:00 | AAPL | Stock | 1.4286 | 1.4286 | 1.4286 | 1.4286 | 56000.0 |
| 2005-04-14 07:37:00 | AAPL | Stock | 1.4357 | 1.4389 | 1.4357 | 1.4389 | 11200.0 |
| 2005-04-14 07:39:00 | AAPL | Stock | 1.4364 | 1.4364 | 1.4364 | 1.4364 | 28000.0 |
| 2005-04-14 07:44:00 | AAPL | Stock | 1.4375 | 1.4375 | 1.4375 | 1.4375 | 8400.0 |
| 2005-04-14 07:49:00 | AAPL | Stock | 1.4429 | 1.4429 | 1.4429 | 1.4429 | 28000.0 |
| 2005-04-14 07:51:00 | AAPL | Stock | 1.4393 | 1.4393 | 1.4393 | 1.4393 | 28000.0 |
| 2005-04-14 07:55:00 | AAPL | Stock | 1.4429 | 1.4429 | 1.4386 | 1.4386 | 76720.0 |
| 2005-04-14 07:59:00 | AAPL | Stock | 1.4304 | 1.4304 | 1.4261 | 1.4286 | 272860.0 |
| 2005-04-14 08:00:00 | AAPL | Stock | 1.4286 | 1.4421 | 1.4286 | 1.4318 | 173600.0 |
| 2005-04-14 08:01:00 | AAPL | Stock | 1.4286 | 1.4429 | 1.4268 | 1.4393 | 4416692.0 |
| 2005-04-14 08:02:00 | AAPL | Stock | 1.4407 | 1.4429 | 1.4407 | 1.4407 | 705768.0 |
| 2005-04-14 08:03:00 | AAPL | Stock | 1.4382 | 1.4429 | 1.4371 | 1.4411 | 285600.0 |
| 2005-04-14 08:04:00 | AAPL | Stock | 1.4407 | 1.4407 | 1.4336 | 1.4375 | 367640.0 |
| 2005-04-14 08:05:00 | AAPL | Stock | 1.4364 | 1.4375 | 1.435 | 1.4357 | 88760.0 |
| 2005-04-14 08:06:00 | AAPL | Stock | 1.4339 | 1.4339 | 1.4321 | 1.4321 | 164500.0 |
| 2005-04-14 08:07:00 | AAPL | Stock | 1.4321 | 1.4339 | 1.4304 | 1.4321 | 710332.0 |
| 2005-04-14 08:08:00 | AAPL | Stock | 1.4307 | 1.4307 | 1.4261 | 1.4271 | 912688.0 |
| 2005-04-14 08:09:00 | AAPL | Stock | 1.4271 | 1.4304 | 1.4254 | 1.4282 | 487928.0 |
| 2005-04-14 08:10:00 | AAPL | Stock | 1.4293 | 1.43 | 1.4279 | 1.4279 | 435400.0 |
| 2005-04-14 08:11:00 | AAPL | Stock | 1.4282 | 1.4357 | 1.425 | 1.425 | 962472.0 |
| 2005-04-14 08:12:00 | AAPL | Stock | 1.4246 | 1.4279 | 1.4229 | 1.4261 | 680652.0 |
| 2005-04-14 08:13:00 | AAPL | Stock | 1.4261 | 1.4275 | 1.4236 | 1.425 | 680008.0 |
| 2005-04-14 08:14:00 | AAPL | Stock | 1.425 | 1.425 | 1.4214 | 1.4221 | 1000552.0 |
| 2005-04-14 08:15:00 | AAPL | Stock | 1.4236 | 1.4264 | 1.4186 | 1.4196 | 1739556.0 |
| 2005-04-14 08:16:00 | AAPL | Stock | 1.4193 | 1.4225 | 1.4182 | 1.4196 | 911820.0 |
| 2005-04-14 08:17:00 | AAPL | Stock | 1.4196 | 1.4214 | 1.4161 | 1.4214 | 1332520.0 |
| 2005-04-14 08:18:00 | AAPL | Stock | 1.4207 | 1.4232 | 1.4189 | 1.4221 | 512400.0 |
| 2005-04-14 08:19:00 | AAPL | Stock | 1.4229 | 1.4232 | 1.42 | 1.4214 | 791168.0 |
| 2005-04-14 08:20:00 | AAPL | Stock | 1.4214 | 1.4243 | 1.4211 | 1.4243 | 1593816.0 |
| 2005-04-14 08:21:00 | AAPL | Stock | 1.4236 | 1.4264 | 1.4214 | 1.425 | 4746000.0 |
| 2005-04-14 08:22:00 | AAPL | Stock | 1.4246 | 1.425 | 1.4207 | 1.4246 | 1092560.0 |
| 2005-04-14 08:23:00 | AAPL | Stock | 1.4243 | 1.4246 | 1.4229 | 1.4232 | 1219064.0 |
| 2005-04-14 08:24:00 | AAPL | Stock | 1.4232 | 1.4243 | 1.4218 | 1.4243 | 1118040.0 |
| 2005-04-14 08:25:00 | AAPL | Stock | 1.4243 | 1.4261 | 1.4243 | 1.4254 | 1064000.0 |
| 2005-04-14 08:26:00 | AAPL | Stock | 1.4261 | 1.4264 | 1.425 | 1.4257 | 546000.0 |
| 2005-04-14 08:27:00 | AAPL | Stock | 1.4261 | 1.4261 | 1.4254 | 1.4254 | 372400.0 |
| 2005-04-14 08:28:00 | AAPL | Stock | 1.4257 | 1.4257 | 1.4232 | 1.4246 | 2034396.0 |
| 2005-04-14 08:29:00 | AAPL | Stock | 1.4239 | 1.425 | 1.4239 | 1.4239 | 91756.0 |
| 2005-04-14 08:30:00 | AAPL | Stock | 1.4239 | 1.4254 | 1.4196 | 1.4204 | 1028972.0 |
| 2005-04-14 08:31:00 | AAPL | Stock | 1.42 | 1.4207 | 1.4196 | 1.42 | 639800.0 |
| 2005-04-14 08:32:00 | AAPL | Stock | 1.42 | 1.4214 | 1.415 | 1.4182 | 1404564.0 |
| 2005-04-14 08:33:00 | AAPL | Stock | 1.4182 | 1.4186 | 1.4157 | 1.4171 | 1465212.0 |
| 2005-04-14 08:34:00 | AAPL | Stock | 1.4171 | 1.4193 | 1.4171 | 1.4182 | 669144.0 |
| 2005-04-14 08:35:00 | AAPL | Stock | 1.4179 | 1.4179 | 1.4132 | 1.4132 | 933436.0 |
| 2005-04-14 08:36:00 | AAPL | Stock | 1.4129 | 1.4196 | 1.4114 | 1.4161 | 1574160.0 |
> showing 50 of 562,488 rows — these rows as CSV