PREVIEW / stock_5min / 2005-03-11
file: by_date/stock_5min/2005/2005-03-11.parquet size: 2.6 MB rows: 192,574 symbols: 1,943
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-11 08:00:00 | AAPL | Stock | 1.4339 | 1.4407 | 1.4339 | 1.4364 | 327600.0 |
| 2005-03-11 08:05:00 | AAPL | Stock | 1.4357 | 1.4389 | 1.4357 | 1.4389 | 352800.0 |
| 2005-03-11 08:10:00 | AAPL | Stock | 1.4411 | 1.4429 | 1.4407 | 1.4421 | 240240.0 |
| 2005-03-11 08:15:00 | AAPL | Stock | 1.4425 | 1.4464 | 1.4425 | 1.4429 | 226660.0 |
| 2005-03-11 08:20:00 | AAPL | Stock | 1.4429 | 1.4457 | 1.4429 | 1.4429 | 190400.0 |
| 2005-03-11 08:25:00 | AAPL | Stock | 1.4429 | 1.4457 | 1.4429 | 1.4457 | 214620.0 |
| 2005-03-11 08:30:00 | AAPL | Stock | 1.4436 | 1.4454 | 1.4425 | 1.4429 | 424060.0 |
| 2005-03-11 08:35:00 | AAPL | Stock | 1.4429 | 1.4454 | 1.4429 | 1.445 | 310856.0 |
| 2005-03-11 08:40:00 | AAPL | Stock | 1.445 | 1.4461 | 1.4411 | 1.4411 | 614852.0 |
| 2005-03-11 08:45:00 | AAPL | Stock | 1.4411 | 1.4421 | 1.4371 | 1.4371 | 308140.0 |
| 2005-03-11 08:50:00 | AAPL | Stock | 1.4371 | 1.4393 | 1.4343 | 1.4361 | 266280.0 |
| 2005-03-11 08:55:00 | AAPL | Stock | 1.4361 | 1.4393 | 1.4357 | 1.4375 | 218400.0 |
| 2005-03-11 09:00:00 | AAPL | Stock | 1.4382 | 1.4393 | 1.4375 | 1.4382 | 150220.0 |
| 2005-03-11 09:05:00 | AAPL | Stock | 1.4382 | 1.4393 | 1.4361 | 1.4361 | 319900.0 |
| 2005-03-11 09:10:00 | AAPL | Stock | 1.4368 | 1.4382 | 1.4368 | 1.4375 | 197400.0 |
| 2005-03-11 09:15:00 | AAPL | Stock | 1.4361 | 1.4382 | 1.4357 | 1.4379 | 347900.0 |
| 2005-03-11 09:20:00 | AAPL | Stock | 1.4382 | 1.4382 | 1.4368 | 1.4375 | 120400.0 |
| 2005-03-11 09:25:00 | AAPL | Stock | 1.4279 | 1.4375 | 1.4279 | 1.435 | 1279572.0 |
| 2005-03-11 09:30:00 | AAPL | Stock | 1.4361 | 1.445 | 1.4289 | 1.4332 | 22459696.0 |
| 2005-03-11 09:35:00 | AAPL | Stock | 1.4336 | 1.4336 | 1.4214 | 1.4296 | 20785436.0 |
| 2005-03-11 09:40:00 | AAPL | Stock | 1.4296 | 1.4393 | 1.4275 | 1.4379 | 19123328.0 |
| 2005-03-11 09:45:00 | AAPL | Stock | 1.4379 | 1.4386 | 1.4325 | 1.4379 | 20764800.0 |
| 2005-03-11 09:50:00 | AAPL | Stock | 1.4386 | 1.4479 | 1.4371 | 1.4475 | 29001644.0 |
| 2005-03-11 09:55:00 | AAPL | Stock | 1.4471 | 1.4496 | 1.4404 | 1.4475 | 22659168.0 |
| 2005-03-11 10:00:00 | AAPL | Stock | 1.4475 | 1.4482 | 1.4418 | 1.4457 | 19046720.0 |
| 2005-03-11 10:05:00 | AAPL | Stock | 1.4457 | 1.4464 | 1.4357 | 1.4361 | 17301956.0 |
| 2005-03-11 10:10:00 | AAPL | Stock | 1.4357 | 1.4421 | 1.4357 | 1.4389 | 10328584.0 |
| 2005-03-11 10:15:00 | AAPL | Stock | 1.4389 | 1.4396 | 1.4318 | 1.4379 | 12687360.0 |
| 2005-03-11 10:20:00 | AAPL | Stock | 1.4375 | 1.4425 | 1.4357 | 1.4386 | 7372344.0 |
| 2005-03-11 10:25:00 | AAPL | Stock | 1.4386 | 1.4421 | 1.4357 | 1.4357 | 5631108.0 |
| 2005-03-11 10:30:00 | AAPL | Stock | 1.4361 | 1.4393 | 1.4336 | 1.435 | 7553504.0 |
| 2005-03-11 10:35:00 | AAPL | Stock | 1.4354 | 1.4371 | 1.4314 | 1.4343 | 8762404.0 |
| 2005-03-11 10:40:00 | AAPL | Stock | 1.4343 | 1.4354 | 1.4318 | 1.4332 | 8258320.0 |
| 2005-03-11 10:45:00 | AAPL | Stock | 1.4329 | 1.4361 | 1.4304 | 1.4332 | 9116044.0 |
| 2005-03-11 10:50:00 | AAPL | Stock | 1.4332 | 1.4339 | 1.4289 | 1.4311 | 11835432.0 |
| 2005-03-11 10:55:00 | AAPL | Stock | 1.4311 | 1.4357 | 1.4296 | 1.4304 | 10241812.0 |
| 2005-03-11 11:00:00 | AAPL | Stock | 1.4304 | 1.4336 | 1.4286 | 1.4289 | 10331580.0 |
| 2005-03-11 11:05:00 | AAPL | Stock | 1.4293 | 1.4325 | 1.4282 | 1.4318 | 10715824.0 |
| 2005-03-11 11:10:00 | AAPL | Stock | 1.4318 | 1.4321 | 1.4289 | 1.43 | 6261668.0 |
| 2005-03-11 11:15:00 | AAPL | Stock | 1.4304 | 1.4364 | 1.4289 | 1.4354 | 7466480.0 |
| 2005-03-11 11:20:00 | AAPL | Stock | 1.4354 | 1.4364 | 1.4329 | 1.4336 | 7621796.0 |
| 2005-03-11 11:25:00 | AAPL | Stock | 1.4332 | 1.4354 | 1.4307 | 1.4325 | 8331344.0 |
| 2005-03-11 11:30:00 | AAPL | Stock | 1.4325 | 1.4325 | 1.4304 | 1.4311 | 6164648.0 |
| 2005-03-11 11:35:00 | AAPL | Stock | 1.4311 | 1.4336 | 1.4307 | 1.4321 | 4008340.0 |
| 2005-03-11 11:40:00 | AAPL | Stock | 1.4314 | 1.435 | 1.4304 | 1.4339 | 4616612.0 |
| 2005-03-11 11:45:00 | AAPL | Stock | 1.4339 | 1.4361 | 1.4307 | 1.4321 | 5483744.0 |
| 2005-03-11 11:50:00 | AAPL | Stock | 1.4318 | 1.4343 | 1.4314 | 1.4343 | 2617272.0 |
| 2005-03-11 11:55:00 | AAPL | Stock | 1.4343 | 1.435 | 1.4332 | 1.4336 | 5557020.0 |
| 2005-03-11 12:00:00 | AAPL | Stock | 1.4339 | 1.4339 | 1.4311 | 1.4311 | 2344916.0 |
| 2005-03-11 12:05:00 | AAPL | Stock | 1.4314 | 1.4329 | 1.4311 | 1.4314 | 3980228.0 |
> showing 50 of 192,574 rows — these rows as CSV