PREVIEW / stock_5min / 2004-09-09
file: by_date/stock_5min/2004/2004-09-09.parquet size: 2.4 MB rows: 179,484 symbols: 1,829
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-09-09 08:00:00 | AAPL | Stock | 0.6366 | 0.6402 | 0.632 | 0.6402 | 375200.0 |
| 2004-09-09 08:05:00 | AAPL | Stock | 0.6389 | 0.6402 | 0.6357 | 0.6402 | 157360.0 |
| 2004-09-09 08:10:00 | AAPL | Stock | 0.6402 | 0.6409 | 0.6389 | 0.6389 | 101584.0 |
| 2004-09-09 08:15:00 | AAPL | Stock | 0.6391 | 0.6393 | 0.6384 | 0.6384 | 128800.0 |
| 2004-09-09 08:20:00 | AAPL | Stock | 0.6377 | 0.6377 | 0.6357 | 0.6366 | 454888.0 |
| 2004-09-09 08:25:00 | AAPL | Stock | 0.6366 | 0.6366 | 0.6357 | 0.6357 | 156240.0 |
| 2004-09-09 08:30:00 | AAPL | Stock | 0.6357 | 0.6382 | 0.6357 | 0.6382 | 229320.0 |
| 2004-09-09 08:35:00 | AAPL | Stock | 0.6382 | 0.6411 | 0.6382 | 0.6411 | 357840.0 |
| 2004-09-09 08:40:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6409 | 0.6409 | 28000.0 |
| 2004-09-09 08:45:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6409 | 0.6409 | 28000.0 |
| 2004-09-09 08:50:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6409 | 0.6409 | 16800.0 |
| 2004-09-09 08:55:00 | AAPL | Stock | 0.642 | 0.642 | 0.642 | 0.642 | 28000.0 |
| 2004-09-09 09:00:00 | AAPL | Stock | 0.6429 | 0.643 | 0.6427 | 0.6429 | 249200.0 |
| 2004-09-09 09:05:00 | AAPL | Stock | 0.6429 | 0.6429 | 0.6429 | 0.6429 | 56000.0 |
| 2004-09-09 09:10:00 | AAPL | Stock | 0.6436 | 0.6436 | 0.6413 | 0.6434 | 280000.0 |
| 2004-09-09 09:15:00 | AAPL | Stock | 0.642 | 0.6491 | 0.6413 | 0.6491 | 3449600.0 |
| 2004-09-09 09:20:00 | AAPL | Stock | 0.6434 | 0.6434 | 0.6434 | 0.6434 | 5600.0 |
| 2004-09-09 09:25:00 | AAPL | Stock | 0.6429 | 0.645 | 0.6429 | 0.645 | 799232.0 |
| 2004-09-09 09:30:00 | AAPL | Stock | 0.6446 | 0.6464 | 0.6411 | 0.6464 | 17041024.0 |
| 2004-09-09 09:35:00 | AAPL | Stock | 0.6459 | 0.6482 | 0.6421 | 0.6427 | 22116416.0 |
| 2004-09-09 09:40:00 | AAPL | Stock | 0.6429 | 0.6452 | 0.6414 | 0.6432 | 9340128.0 |
| 2004-09-09 09:45:00 | AAPL | Stock | 0.6434 | 0.6448 | 0.6404 | 0.6429 | 10138576.0 |
| 2004-09-09 09:50:00 | AAPL | Stock | 0.6427 | 0.6432 | 0.6418 | 0.643 | 3672928.0 |
| 2004-09-09 09:55:00 | AAPL | Stock | 0.643 | 0.6434 | 0.642 | 0.6434 | 4053056.0 |
| 2004-09-09 10:00:00 | AAPL | Stock | 0.6432 | 0.6438 | 0.6425 | 0.6432 | 4699072.0 |
| 2004-09-09 10:05:00 | AAPL | Stock | 0.6432 | 0.6446 | 0.6427 | 0.6432 | 6191808.0 |
| 2004-09-09 10:10:00 | AAPL | Stock | 0.6432 | 0.6434 | 0.642 | 0.6425 | 3669344.0 |
| 2004-09-09 10:15:00 | AAPL | Stock | 0.6425 | 0.6429 | 0.6418 | 0.6427 | 3281152.0 |
| 2004-09-09 10:20:00 | AAPL | Stock | 0.6425 | 0.6429 | 0.6421 | 0.6425 | 4494448.0 |
| 2004-09-09 10:25:00 | AAPL | Stock | 0.6425 | 0.6429 | 0.6418 | 0.6425 | 4310264.0 |
| 2004-09-09 10:30:00 | AAPL | Stock | 0.6425 | 0.6432 | 0.6421 | 0.6423 | 6951392.0 |
| 2004-09-09 10:35:00 | AAPL | Stock | 0.6423 | 0.6425 | 0.6411 | 0.6416 | 5593168.0 |
| 2004-09-09 10:40:00 | AAPL | Stock | 0.6416 | 0.6418 | 0.6407 | 0.6409 | 5345704.0 |
| 2004-09-09 10:45:00 | AAPL | Stock | 0.6407 | 0.6413 | 0.6402 | 0.6404 | 3884104.0 |
| 2004-09-09 10:50:00 | AAPL | Stock | 0.6402 | 0.6407 | 0.6395 | 0.6404 | 5496120.0 |
| 2004-09-09 10:55:00 | AAPL | Stock | 0.6404 | 0.6411 | 0.6398 | 0.6402 | 4404512.0 |
| 2004-09-09 11:00:00 | AAPL | Stock | 0.6402 | 0.6407 | 0.6386 | 0.6386 | 3741360.0 |
| 2004-09-09 11:05:00 | AAPL | Stock | 0.6386 | 0.6388 | 0.6366 | 0.637 | 4811184.0 |
| 2004-09-09 11:10:00 | AAPL | Stock | 0.6368 | 0.6377 | 0.6363 | 0.6375 | 6044136.0 |
| 2004-09-09 11:15:00 | AAPL | Stock | 0.6373 | 0.6388 | 0.6373 | 0.6382 | 3110240.0 |
| 2004-09-09 11:20:00 | AAPL | Stock | 0.6382 | 0.6384 | 0.6375 | 0.6379 | 4850888.0 |
| 2004-09-09 11:25:00 | AAPL | Stock | 0.6379 | 0.638 | 0.6366 | 0.6368 | 2581712.0 |
| 2004-09-09 11:30:00 | AAPL | Stock | 0.6366 | 0.6371 | 0.6366 | 0.6371 | 2816296.0 |
| 2004-09-09 11:35:00 | AAPL | Stock | 0.6371 | 0.6375 | 0.6366 | 0.6368 | 4632208.0 |
| 2004-09-09 11:40:00 | AAPL | Stock | 0.6371 | 0.6371 | 0.6363 | 0.6363 | 8744064.0 |
| 2004-09-09 11:45:00 | AAPL | Stock | 0.6364 | 0.6364 | 0.6355 | 0.6357 | 2735544.0 |
| 2004-09-09 11:50:00 | AAPL | Stock | 0.6357 | 0.6364 | 0.6354 | 0.6364 | 2161712.0 |
| 2004-09-09 11:55:00 | AAPL | Stock | 0.6364 | 0.6368 | 0.6354 | 0.6364 | 2611728.0 |
| 2004-09-09 12:00:00 | AAPL | Stock | 0.6363 | 0.6364 | 0.6357 | 0.6363 | 1597456.0 |
| 2004-09-09 12:05:00 | AAPL | Stock | 0.6363 | 0.6364 | 0.6359 | 0.6364 | 4362008.0 |
> showing 50 of 179,484 rows — these rows as CSV