PREVIEW / stock_5min / 2008-04-11
file: by_date/stock_5min/2008/2008-04-11.parquet size: 4.2 MB rows: 307,924 symbols: 3,293
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-11 04:55:00 | AAPL | Stock | 5.5789 | 5.5789 | 5.5789 | 5.5789 | 5600.0 |
| 2008-04-11 05:20:00 | AAPL | Stock | 5.5871 | 5.5871 | 5.5871 | 5.5871 | 2800.0 |
| 2008-04-11 06:30:00 | AAPL | Stock | 5.5411 | 5.5411 | 5.5411 | 5.5411 | 5600.0 |
| 2008-04-11 06:35:00 | AAPL | Stock | 5.5361 | 5.5361 | 5.5361 | 5.5361 | 12348.0 |
| 2008-04-11 06:50:00 | AAPL | Stock | 5.5221 | 5.5221 | 5.5129 | 5.5129 | 11200.0 |
| 2008-04-11 06:55:00 | AAPL | Stock | 5.5129 | 5.5129 | 5.4979 | 5.4979 | 56000.0 |
| 2008-04-11 07:10:00 | AAPL | Stock | 5.4857 | 5.4857 | 5.4857 | 5.4857 | 28000.0 |
| 2008-04-11 07:15:00 | AAPL | Stock | 5.4857 | 5.495 | 5.4846 | 5.4946 | 88200.0 |
| 2008-04-11 07:20:00 | AAPL | Stock | 5.4911 | 5.4911 | 5.475 | 5.475 | 121660.0 |
| 2008-04-11 07:25:00 | AAPL | Stock | 5.4818 | 5.4818 | 5.4732 | 5.4732 | 20300.0 |
| 2008-04-11 07:30:00 | AAPL | Stock | 5.4679 | 5.4679 | 5.4643 | 5.4679 | 72800.0 |
| 2008-04-11 07:35:00 | AAPL | Stock | 5.4679 | 5.4679 | 5.4679 | 5.4679 | 5600.0 |
| 2008-04-11 07:40:00 | AAPL | Stock | 5.4868 | 5.4871 | 5.4868 | 5.4871 | 11200.0 |
| 2008-04-11 07:45:00 | AAPL | Stock | 5.4711 | 5.4711 | 5.4711 | 5.4711 | 8260.0 |
| 2008-04-11 07:50:00 | AAPL | Stock | 5.4807 | 5.4868 | 5.4807 | 5.4864 | 69860.0 |
| 2008-04-11 07:55:00 | AAPL | Stock | 5.4729 | 5.4807 | 5.4729 | 5.475 | 25200.0 |
| 2008-04-11 08:00:00 | AAPL | Stock | 5.4732 | 5.4836 | 5.4732 | 5.4786 | 348852.0 |
| 2008-04-11 08:05:00 | AAPL | Stock | 5.4768 | 5.4857 | 5.4761 | 5.4857 | 222880.0 |
| 2008-04-11 08:10:00 | AAPL | Stock | 5.4829 | 5.4829 | 5.4679 | 5.47 | 392224.0 |
| 2008-04-11 08:15:00 | AAPL | Stock | 5.4696 | 5.4696 | 5.46 | 5.4621 | 535696.0 |
| 2008-04-11 08:20:00 | AAPL | Stock | 5.4621 | 5.4621 | 5.4507 | 5.4539 | 726264.0 |
| 2008-04-11 08:25:00 | AAPL | Stock | 5.455 | 5.4589 | 5.4536 | 5.4557 | 284900.0 |
| 2008-04-11 08:30:00 | AAPL | Stock | 5.4554 | 5.4554 | 5.4507 | 5.4536 | 192920.0 |
| 2008-04-11 08:35:00 | AAPL | Stock | 5.455 | 5.4557 | 5.4543 | 5.4543 | 198940.0 |
| 2008-04-11 08:40:00 | AAPL | Stock | 5.4546 | 5.4607 | 5.4546 | 5.4589 | 203980.0 |
| 2008-04-11 08:45:00 | AAPL | Stock | 5.46 | 5.4646 | 5.4554 | 5.4554 | 634508.0 |
| 2008-04-11 08:50:00 | AAPL | Stock | 5.4593 | 5.4618 | 5.4532 | 5.4561 | 498372.0 |
| 2008-04-11 08:55:00 | AAPL | Stock | 5.4561 | 5.4571 | 5.4532 | 5.455 | 425852.0 |
| 2008-04-11 09:00:00 | AAPL | Stock | 5.455 | 5.4568 | 5.4532 | 5.4561 | 447384.0 |
| 2008-04-11 09:05:00 | AAPL | Stock | 5.4561 | 5.4564 | 5.45 | 5.4507 | 519708.0 |
| 2008-04-11 09:10:00 | AAPL | Stock | 5.4493 | 5.4511 | 5.4429 | 5.4482 | 772072.0 |
| 2008-04-11 09:15:00 | AAPL | Stock | 5.4489 | 5.4507 | 5.4482 | 5.45 | 184016.0 |
| 2008-04-11 09:20:00 | AAPL | Stock | 5.4489 | 5.4514 | 5.4436 | 5.4464 | 167412.0 |
| 2008-04-11 09:25:00 | AAPL | Stock | 5.4475 | 5.4554 | 5.4475 | 5.4536 | 593544.0 |
| 2008-04-11 09:30:00 | AAPL | Stock | 5.4536 | 5.4714 | 5.4468 | 5.4477 | 28566020.0 |
| 2008-04-11 09:35:00 | AAPL | Stock | 5.4479 | 5.4696 | 5.4471 | 5.4532 | 18186588.0 |
| 2008-04-11 09:40:00 | AAPL | Stock | 5.4532 | 5.4732 | 5.4521 | 5.4571 | 20617044.0 |
| 2008-04-11 09:45:00 | AAPL | Stock | 5.4561 | 5.475 | 5.4482 | 5.4686 | 23414104.0 |
| 2008-04-11 09:50:00 | AAPL | Stock | 5.4689 | 5.4704 | 5.4504 | 5.4589 | 18173764.0 |
| 2008-04-11 09:55:00 | AAPL | Stock | 5.4582 | 5.4625 | 5.4418 | 5.4461 | 23404332.0 |
| 2008-04-11 10:00:00 | AAPL | Stock | 5.4475 | 5.4529 | 5.425 | 5.4343 | 23711268.0 |
| 2008-04-11 10:05:00 | AAPL | Stock | 5.4339 | 5.4379 | 5.4179 | 5.4193 | 18762324.0 |
| 2008-04-11 10:10:00 | AAPL | Stock | 5.4194 | 5.4336 | 5.415 | 5.4293 | 14982716.0 |
| 2008-04-11 10:15:00 | AAPL | Stock | 5.4289 | 5.4464 | 5.4214 | 5.4443 | 16018912.0 |
| 2008-04-11 10:20:00 | AAPL | Stock | 5.4443 | 5.4568 | 5.4379 | 5.445 | 13096496.0 |
| 2008-04-11 10:25:00 | AAPL | Stock | 5.4446 | 5.4507 | 5.4393 | 5.4507 | 12548928.0 |
| 2008-04-11 10:30:00 | AAPL | Stock | 5.4511 | 5.455 | 5.4429 | 5.4436 | 11329864.0 |
| 2008-04-11 10:35:00 | AAPL | Stock | 5.4439 | 5.4496 | 5.4393 | 5.4429 | 10704260.0 |
| 2008-04-11 10:40:00 | AAPL | Stock | 5.4432 | 5.455 | 5.4396 | 5.4418 | 11356408.0 |
| 2008-04-11 10:45:00 | AAPL | Stock | 5.4418 | 5.4479 | 5.4336 | 5.4439 | 11108748.0 |
> showing 50 of 307,924 rows — these rows as CSV