PREVIEW / stock_5min / 2005-03-14
file: by_date/stock_5min/2005/2005-03-14.parquet size: 2.7 MB rows: 196,554 symbols: 1,952
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-03-14 08:00:00 | AAPL | Stock | 1.4518 | 1.4554 | 1.4471 | 1.4536 | 1284500.0 |
| 2005-03-14 08:05:00 | AAPL | Stock | 1.4546 | 1.4554 | 1.4521 | 1.4521 | 452200.0 |
| 2005-03-14 08:10:00 | AAPL | Stock | 1.4543 | 1.4543 | 1.4529 | 1.4543 | 310772.0 |
| 2005-03-14 08:15:00 | AAPL | Stock | 1.455 | 1.4625 | 1.4536 | 1.4554 | 379400.0 |
| 2005-03-14 08:20:00 | AAPL | Stock | 1.4554 | 1.4554 | 1.4546 | 1.4554 | 149520.0 |
| 2005-03-14 08:25:00 | AAPL | Stock | 1.455 | 1.4582 | 1.4539 | 1.4557 | 575400.0 |
| 2005-03-14 08:30:00 | AAPL | Stock | 1.4571 | 1.46 | 1.4571 | 1.4571 | 319200.0 |
| 2005-03-14 08:35:00 | AAPL | Stock | 1.4571 | 1.4575 | 1.4536 | 1.4546 | 498344.0 |
| 2005-03-14 08:40:00 | AAPL | Stock | 1.4536 | 1.4536 | 1.45 | 1.4529 | 324800.0 |
| 2005-03-14 08:45:00 | AAPL | Stock | 1.4536 | 1.4536 | 1.4504 | 1.4511 | 49000.0 |
| 2005-03-14 08:50:00 | AAPL | Stock | 1.4511 | 1.4536 | 1.4511 | 1.4536 | 215348.0 |
| 2005-03-14 08:55:00 | AAPL | Stock | 1.455 | 1.4557 | 1.4536 | 1.4543 | 559300.0 |
| 2005-03-14 09:00:00 | AAPL | Stock | 1.4554 | 1.4554 | 1.4518 | 1.4518 | 81648.0 |
| 2005-03-14 09:05:00 | AAPL | Stock | 1.4521 | 1.4536 | 1.4511 | 1.4536 | 277200.0 |
| 2005-03-14 09:10:00 | AAPL | Stock | 1.4536 | 1.4536 | 1.4518 | 1.4518 | 205660.0 |
| 2005-03-14 09:15:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.45 | 1.4514 | 270872.0 |
| 2005-03-14 09:20:00 | AAPL | Stock | 1.45 | 1.4507 | 1.45 | 1.45 | 198800.0 |
| 2005-03-14 09:25:00 | AAPL | Stock | 1.4414 | 1.4536 | 1.4414 | 1.4464 | 1080800.0 |
| 2005-03-14 09:30:00 | AAPL | Stock | 1.4471 | 1.4568 | 1.4439 | 1.4471 | 20690628.0 |
| 2005-03-14 09:35:00 | AAPL | Stock | 1.4468 | 1.4507 | 1.4443 | 1.4461 | 14962416.0 |
| 2005-03-14 09:40:00 | AAPL | Stock | 1.4461 | 1.4461 | 1.4332 | 1.4336 | 17310804.0 |
| 2005-03-14 09:45:00 | AAPL | Stock | 1.4332 | 1.4357 | 1.4257 | 1.4314 | 21903364.0 |
| 2005-03-14 09:50:00 | AAPL | Stock | 1.4318 | 1.4346 | 1.4304 | 1.4343 | 12929196.0 |
| 2005-03-14 09:55:00 | AAPL | Stock | 1.4329 | 1.4339 | 1.4314 | 1.4325 | 12384484.0 |
| 2005-03-14 10:00:00 | AAPL | Stock | 1.4321 | 1.4325 | 1.4314 | 1.4318 | 7370664.0 |
| 2005-03-14 10:05:00 | AAPL | Stock | 1.4318 | 1.4339 | 1.4314 | 1.4325 | 7876848.0 |
| 2005-03-14 10:10:00 | AAPL | Stock | 1.4325 | 1.4364 | 1.4318 | 1.4364 | 10293892.0 |
| 2005-03-14 10:15:00 | AAPL | Stock | 1.4346 | 1.4561 | 1.4336 | 1.4382 | 11761680.0 |
| 2005-03-14 10:20:00 | AAPL | Stock | 1.4382 | 1.4414 | 1.4371 | 1.4393 | 7693952.0 |
| 2005-03-14 10:25:00 | AAPL | Stock | 1.4393 | 1.4393 | 1.4346 | 1.4354 | 8620584.0 |
| 2005-03-14 10:30:00 | AAPL | Stock | 1.435 | 1.4407 | 1.4343 | 1.4393 | 10992016.0 |
| 2005-03-14 10:35:00 | AAPL | Stock | 1.4389 | 1.4393 | 1.4354 | 1.4361 | 6877248.0 |
| 2005-03-14 10:40:00 | AAPL | Stock | 1.4361 | 1.4364 | 1.4289 | 1.4289 | 14896588.0 |
| 2005-03-14 10:45:00 | AAPL | Stock | 1.4289 | 1.4307 | 1.4114 | 1.4182 | 29819020.0 |
| 2005-03-14 10:50:00 | AAPL | Stock | 1.4186 | 1.4243 | 1.4146 | 1.4221 | 17247664.0 |
| 2005-03-14 10:55:00 | AAPL | Stock | 1.4225 | 1.4264 | 1.4214 | 1.4229 | 11981340.0 |
| 2005-03-14 11:00:00 | AAPL | Stock | 1.4225 | 1.4229 | 1.4179 | 1.4207 | 7737548.0 |
| 2005-03-14 11:05:00 | AAPL | Stock | 1.4207 | 1.4225 | 1.4196 | 1.4207 | 5268648.0 |
| 2005-03-14 11:10:00 | AAPL | Stock | 1.4207 | 1.4243 | 1.42 | 1.4207 | 7213276.0 |
| 2005-03-14 11:15:00 | AAPL | Stock | 1.4211 | 1.4279 | 1.4196 | 1.4271 | 7110572.0 |
| 2005-03-14 11:20:00 | AAPL | Stock | 1.4268 | 1.4271 | 1.4232 | 1.4261 | 4856656.0 |
| 2005-03-14 11:25:00 | AAPL | Stock | 1.4261 | 1.4293 | 1.4261 | 1.4286 | 10551492.0 |
| 2005-03-14 11:30:00 | AAPL | Stock | 1.4286 | 1.4286 | 1.4246 | 1.4254 | 4386396.0 |
| 2005-03-14 11:35:00 | AAPL | Stock | 1.425 | 1.4286 | 1.4229 | 1.4246 | 6285244.0 |
| 2005-03-14 11:40:00 | AAPL | Stock | 1.4246 | 1.4246 | 1.4189 | 1.4221 | 12032916.0 |
| 2005-03-14 11:45:00 | AAPL | Stock | 1.4218 | 1.4261 | 1.4214 | 1.4261 | 3547012.0 |
| 2005-03-14 11:50:00 | AAPL | Stock | 1.4261 | 1.4332 | 1.4257 | 1.43 | 8958404.0 |
| 2005-03-14 11:55:00 | AAPL | Stock | 1.43 | 1.4321 | 1.4286 | 1.43 | 5301268.0 |
| 2005-03-14 12:00:00 | AAPL | Stock | 1.4296 | 1.4332 | 1.4289 | 1.4296 | 4492992.0 |
| 2005-03-14 12:05:00 | AAPL | Stock | 1.43 | 1.4318 | 1.4293 | 1.4311 | 2601004.0 |
> showing 50 of 196,554 rows — these rows as CSV