PREVIEW / stock_5min / 2004-03-04
file: by_date/stock_5min/2004/2004-03-04.parquet size: 2.3 MB rows: 166,811 symbols: 1,728
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-03-04 08:45:00 | AAPL | Stock | 0.4298 | 0.4302 | 0.4298 | 0.4302 | 28000.0 |
| 2004-03-04 08:50:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4286 | 0.4286 | 89600.0 |
| 2004-03-04 08:55:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.4277 | 0.4277 | 22400.0 |
| 2004-03-04 09:00:00 | AAPL | Stock | 0.4271 | 0.4271 | 0.4271 | 0.4271 | 16800.0 |
| 2004-03-04 09:05:00 | AAPL | Stock | 0.4271 | 0.4271 | 0.4271 | 0.4271 | 16800.0 |
| 2004-03-04 09:10:00 | AAPL | Stock | 0.4271 | 0.4271 | 0.4271 | 0.4271 | 16800.0 |
| 2004-03-04 09:20:00 | AAPL | Stock | 0.4272 | 0.4272 | 0.4272 | 0.4272 | 5600.0 |
| 2004-03-04 09:25:00 | AAPL | Stock | 0.4272 | 0.4279 | 0.4266 | 0.4279 | 187152.0 |
| 2004-03-04 09:30:00 | AAPL | Stock | 0.4279 | 0.4288 | 0.427 | 0.4284 | 3758720.0 |
| 2004-03-04 09:35:00 | AAPL | Stock | 0.4284 | 0.4302 | 0.4284 | 0.4285 | 8563744.0 |
| 2004-03-04 09:40:00 | AAPL | Stock | 0.4289 | 0.4295 | 0.4288 | 0.4295 | 1694504.0 |
| 2004-03-04 09:45:00 | AAPL | Stock | 0.4293 | 0.433 | 0.4291 | 0.432 | 6443752.0 |
| 2004-03-04 09:50:00 | AAPL | Stock | 0.4318 | 0.4321 | 0.4307 | 0.4309 | 2544136.0 |
| 2004-03-04 09:55:00 | AAPL | Stock | 0.4309 | 0.4323 | 0.4309 | 0.4318 | 2902928.0 |
| 2004-03-04 10:00:00 | AAPL | Stock | 0.4317 | 0.4339 | 0.4317 | 0.4332 | 7904736.0 |
| 2004-03-04 10:05:00 | AAPL | Stock | 0.4333 | 0.4348 | 0.4332 | 0.4339 | 2636536.0 |
| 2004-03-04 10:10:00 | AAPL | Stock | 0.4341 | 0.4352 | 0.4339 | 0.4352 | 5550496.0 |
| 2004-03-04 10:15:00 | AAPL | Stock | 0.4352 | 0.4352 | 0.4332 | 0.4332 | 1798048.0 |
| 2004-03-04 10:20:00 | AAPL | Stock | 0.4332 | 0.4339 | 0.4318 | 0.4336 | 3613232.0 |
| 2004-03-04 10:25:00 | AAPL | Stock | 0.4339 | 0.4355 | 0.4339 | 0.4346 | 2112208.0 |
| 2004-03-04 10:30:00 | AAPL | Stock | 0.4346 | 0.4355 | 0.4345 | 0.4354 | 2394392.0 |
| 2004-03-04 10:35:00 | AAPL | Stock | 0.4355 | 0.4364 | 0.4354 | 0.4355 | 5784072.0 |
| 2004-03-04 10:40:00 | AAPL | Stock | 0.4355 | 0.4359 | 0.435 | 0.4351 | 2929976.0 |
| 2004-03-04 10:45:00 | AAPL | Stock | 0.4352 | 0.4355 | 0.4348 | 0.4355 | 4034576.0 |
| 2004-03-04 10:50:00 | AAPL | Stock | 0.4355 | 0.4366 | 0.4355 | 0.4366 | 3143336.0 |
| 2004-03-04 10:55:00 | AAPL | Stock | 0.4363 | 0.4371 | 0.4363 | 0.437 | 3933888.0 |
| 2004-03-04 11:00:00 | AAPL | Stock | 0.4368 | 0.4375 | 0.4364 | 0.4373 | 5232976.0 |
| 2004-03-04 11:05:00 | AAPL | Stock | 0.4371 | 0.4375 | 0.4371 | 0.4373 | 4481960.0 |
| 2004-03-04 11:10:00 | AAPL | Stock | 0.4373 | 0.4375 | 0.4368 | 0.437 | 3556896.0 |
| 2004-03-04 11:15:00 | AAPL | Stock | 0.437 | 0.4373 | 0.4364 | 0.4371 | 6196120.0 |
| 2004-03-04 11:20:00 | AAPL | Stock | 0.4372 | 0.4373 | 0.437 | 0.4371 | 2956744.0 |
| 2004-03-04 11:25:00 | AAPL | Stock | 0.437 | 0.4375 | 0.437 | 0.4371 | 2598288.0 |
| 2004-03-04 11:30:00 | AAPL | Stock | 0.4373 | 0.4373 | 0.4364 | 0.4366 | 2589048.0 |
| 2004-03-04 11:35:00 | AAPL | Stock | 0.4368 | 0.4373 | 0.4363 | 0.4363 | 1978368.0 |
| 2004-03-04 11:40:00 | AAPL | Stock | 0.4363 | 0.4366 | 0.4357 | 0.4359 | 2464000.0 |
| 2004-03-04 11:45:00 | AAPL | Stock | 0.4359 | 0.4363 | 0.4359 | 0.4361 | 797552.0 |
| 2004-03-04 11:50:00 | AAPL | Stock | 0.4363 | 0.4363 | 0.4345 | 0.435 | 2192680.0 |
| 2004-03-04 11:55:00 | AAPL | Stock | 0.4352 | 0.4357 | 0.4346 | 0.4354 | 844480.0 |
| 2004-03-04 12:00:00 | AAPL | Stock | 0.4354 | 0.4366 | 0.4354 | 0.4366 | 1530536.0 |
| 2004-03-04 12:05:00 | AAPL | Stock | 0.4364 | 0.4366 | 0.4361 | 0.4361 | 1778280.0 |
| 2004-03-04 12:10:00 | AAPL | Stock | 0.4361 | 0.4371 | 0.4359 | 0.4371 | 3781512.0 |
| 2004-03-04 12:15:00 | AAPL | Stock | 0.437 | 0.4373 | 0.4366 | 0.4366 | 2760968.0 |
| 2004-03-04 12:20:00 | AAPL | Stock | 0.4366 | 0.4375 | 0.4366 | 0.437 | 1988896.0 |
| 2004-03-04 12:25:00 | AAPL | Stock | 0.437 | 0.4375 | 0.4368 | 0.4368 | 4849992.0 |
| 2004-03-04 12:30:00 | AAPL | Stock | 0.4368 | 0.437 | 0.4364 | 0.4368 | 1664656.0 |
| 2004-03-04 12:35:00 | AAPL | Stock | 0.4368 | 0.437 | 0.4368 | 0.4368 | 874552.0 |
| 2004-03-04 12:40:00 | AAPL | Stock | 0.4368 | 0.437 | 0.4367 | 0.4368 | 602000.0 |
| 2004-03-04 12:45:00 | AAPL | Stock | 0.4368 | 0.4368 | 0.4368 | 0.4368 | 397600.0 |
| 2004-03-04 12:50:00 | AAPL | Stock | 0.4368 | 0.4375 | 0.4366 | 0.4375 | 8466024.0 |
| 2004-03-04 12:55:00 | AAPL | Stock | 0.4373 | 0.4382 | 0.4371 | 0.4375 | 4204872.0 |
> showing 50 of 166,811 rows — these rows as CSV