PREVIEW / stock_5min / 2005-05-26
file: by_date/stock_5min/2005/2005-05-26.parquet size: 2.6 MB rows: 193,614 symbols: 1,981
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-05-26 07:45:00 | AAPL | Stock | 1.4293 | 1.4336 | 1.4293 | 1.4336 | 9800.0 |
| 2005-05-26 08:00:00 | AAPL | Stock | 1.4304 | 1.4339 | 1.4304 | 1.4318 | 348852.0 |
| 2005-05-26 08:05:00 | AAPL | Stock | 1.4339 | 1.4411 | 1.4339 | 1.4375 | 440860.0 |
| 2005-05-26 08:10:00 | AAPL | Stock | 1.4375 | 1.4393 | 1.4357 | 1.4379 | 273000.0 |
| 2005-05-26 08:15:00 | AAPL | Stock | 1.4379 | 1.4389 | 1.4375 | 1.4389 | 278600.0 |
| 2005-05-26 08:20:00 | AAPL | Stock | 1.4379 | 1.4425 | 1.4379 | 1.4411 | 361200.0 |
| 2005-05-26 08:25:00 | AAPL | Stock | 1.4393 | 1.4404 | 1.4393 | 1.4404 | 127652.0 |
| 2005-05-26 08:30:00 | AAPL | Stock | 1.4404 | 1.4429 | 1.4393 | 1.4404 | 805700.0 |
| 2005-05-26 08:35:00 | AAPL | Stock | 1.4414 | 1.4418 | 1.4407 | 1.4418 | 82320.0 |
| 2005-05-26 08:40:00 | AAPL | Stock | 1.4421 | 1.4436 | 1.4418 | 1.4429 | 511000.0 |
| 2005-05-26 08:45:00 | AAPL | Stock | 1.4432 | 1.4443 | 1.4429 | 1.4432 | 265720.0 |
| 2005-05-26 08:50:00 | AAPL | Stock | 1.4432 | 1.4446 | 1.4393 | 1.4429 | 1540000.0 |
| 2005-05-26 08:55:00 | AAPL | Stock | 1.4429 | 1.4464 | 1.4429 | 1.4454 | 393400.0 |
| 2005-05-26 09:00:00 | AAPL | Stock | 1.4454 | 1.4454 | 1.4429 | 1.4429 | 46200.0 |
| 2005-05-26 09:05:00 | AAPL | Stock | 1.4432 | 1.4461 | 1.4429 | 1.4446 | 696640.0 |
| 2005-05-26 09:10:00 | AAPL | Stock | 1.4461 | 1.4479 | 1.4418 | 1.4418 | 441840.0 |
| 2005-05-26 09:15:00 | AAPL | Stock | 1.4429 | 1.4429 | 1.4425 | 1.4425 | 236320.0 |
| 2005-05-26 09:20:00 | AAPL | Stock | 1.4421 | 1.4421 | 1.4357 | 1.4364 | 975100.0 |
| 2005-05-26 09:25:00 | AAPL | Stock | 1.4336 | 1.4393 | 1.4268 | 1.4268 | 4095756.0 |
| 2005-05-26 09:30:00 | AAPL | Stock | 1.4264 | 1.4436 | 1.4264 | 1.4436 | 32006212.0 |
| 2005-05-26 09:35:00 | AAPL | Stock | 1.4429 | 1.4461 | 1.44 | 1.4443 | 13577312.0 |
| 2005-05-26 09:40:00 | AAPL | Stock | 1.4446 | 1.445 | 1.4368 | 1.4389 | 13340264.0 |
| 2005-05-26 09:45:00 | AAPL | Stock | 1.4393 | 1.4429 | 1.4371 | 1.4414 | 10216584.0 |
| 2005-05-26 09:50:00 | AAPL | Stock | 1.4418 | 1.4429 | 1.4386 | 1.4414 | 7514108.0 |
| 2005-05-26 09:55:00 | AAPL | Stock | 1.4418 | 1.4429 | 1.4393 | 1.4425 | 7218064.0 |
| 2005-05-26 10:00:00 | AAPL | Stock | 1.4425 | 1.4461 | 1.3857 | 1.4457 | 10299660.0 |
| 2005-05-26 10:05:00 | AAPL | Stock | 1.4454 | 1.4454 | 1.4425 | 1.4446 | 6342196.0 |
| 2005-05-26 10:10:00 | AAPL | Stock | 1.4446 | 1.4496 | 1.4446 | 1.4475 | 14935508.0 |
| 2005-05-26 10:15:00 | AAPL | Stock | 1.4471 | 1.4561 | 1.4468 | 1.4543 | 24609816.0 |
| 2005-05-26 10:20:00 | AAPL | Stock | 1.4539 | 1.4621 | 1.4536 | 1.4557 | 24800608.0 |
| 2005-05-26 10:25:00 | AAPL | Stock | 1.455 | 1.4575 | 1.4536 | 1.4557 | 8184708.0 |
| 2005-05-26 10:30:00 | AAPL | Stock | 1.4557 | 1.46 | 1.4554 | 1.4568 | 7887572.0 |
| 2005-05-26 10:35:00 | AAPL | Stock | 1.4568 | 1.4589 | 1.4543 | 1.4564 | 5633712.0 |
| 2005-05-26 10:40:00 | AAPL | Stock | 1.4561 | 1.4589 | 1.455 | 1.4571 | 5316136.0 |
| 2005-05-26 10:45:00 | AAPL | Stock | 1.4568 | 1.4593 | 1.4543 | 1.455 | 6381256.0 |
| 2005-05-26 10:50:00 | AAPL | Stock | 1.4553 | 1.4554 | 1.4518 | 1.4536 | 5809664.0 |
| 2005-05-26 10:55:00 | AAPL | Stock | 1.4536 | 1.455 | 1.4525 | 1.4536 | 5638752.0 |
| 2005-05-26 11:00:00 | AAPL | Stock | 1.4536 | 1.4557 | 1.4525 | 1.4554 | 2676436.0 |
| 2005-05-26 11:05:00 | AAPL | Stock | 1.4557 | 1.4564 | 1.4539 | 1.455 | 3215436.0 |
| 2005-05-26 11:10:00 | AAPL | Stock | 1.455 | 1.455 | 1.4507 | 1.4521 | 7286384.0 |
| 2005-05-26 11:15:00 | AAPL | Stock | 1.4521 | 1.4543 | 1.4514 | 1.4539 | 3908240.0 |
| 2005-05-26 11:20:00 | AAPL | Stock | 1.4539 | 1.4543 | 1.4525 | 1.4529 | 4073104.0 |
| 2005-05-26 11:25:00 | AAPL | Stock | 1.4525 | 1.455 | 1.4525 | 1.4546 | 2488164.0 |
| 2005-05-26 11:30:00 | AAPL | Stock | 1.4543 | 1.4554 | 1.4525 | 1.4525 | 4302732.0 |
| 2005-05-26 11:35:00 | AAPL | Stock | 1.4525 | 1.4554 | 1.4521 | 1.455 | 3166184.0 |
| 2005-05-26 11:40:00 | AAPL | Stock | 1.4554 | 1.4557 | 1.4529 | 1.4529 | 3316152.0 |
| 2005-05-26 11:45:00 | AAPL | Stock | 1.4532 | 1.4532 | 1.4518 | 1.4525 | 3851484.0 |
| 2005-05-26 11:50:00 | AAPL | Stock | 1.4525 | 1.4532 | 1.4525 | 1.4529 | 2113132.0 |
| 2005-05-26 11:55:00 | AAPL | Stock | 1.4529 | 1.4557 | 1.4525 | 1.455 | 5969516.0 |
| 2005-05-26 12:00:00 | AAPL | Stock | 1.455 | 1.455 | 1.4521 | 1.4521 | 2847068.0 |
> showing 50 of 193,614 rows — these rows as CSV