PREVIEW / stock_5min / 2008-05-23
file: by_date/stock_5min/2008/2008-05-23.parquet size: 4.3 MB rows: 311,154 symbols: 3,282
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-05-23 04:15:00 | AAPL | Stock | 6.4079 | 6.4079 | 6.4079 | 6.4079 | 25200.0 |
| 2008-05-23 04:20:00 | AAPL | Stock | 6.4086 | 6.4086 | 6.3739 | 6.3739 | 30800.0 |
| 2008-05-23 04:30:00 | AAPL | Stock | 6.4214 | 6.425 | 6.4214 | 6.425 | 78400.0 |
| 2008-05-23 05:15:00 | AAPL | Stock | 6.4268 | 6.4268 | 6.4268 | 6.4268 | 2800.0 |
| 2008-05-23 05:20:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 2800.0 |
| 2008-05-23 05:35:00 | AAPL | Stock | 6.4179 | 6.4179 | 6.4179 | 6.4179 | 2800.0 |
| 2008-05-23 05:50:00 | AAPL | Stock | 6.3982 | 6.3982 | 6.3982 | 6.3982 | 13468.0 |
| 2008-05-23 06:05:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 2800.0 |
| 2008-05-23 06:30:00 | AAPL | Stock | 6.4125 | 6.4125 | 6.4125 | 6.4125 | 112000.0 |
| 2008-05-23 06:35:00 | AAPL | Stock | 6.4246 | 6.425 | 6.4246 | 6.425 | 117152.0 |
| 2008-05-23 06:40:00 | AAPL | Stock | 6.4282 | 6.4289 | 6.4214 | 6.4214 | 242200.0 |
| 2008-05-23 06:45:00 | AAPL | Stock | 6.425 | 6.425 | 6.425 | 6.425 | 14000.0 |
| 2008-05-23 06:50:00 | AAPL | Stock | 6.4339 | 6.4357 | 6.4321 | 6.4357 | 22400.0 |
| 2008-05-23 07:00:00 | AAPL | Stock | 6.4179 | 6.4232 | 6.4179 | 6.4214 | 131600.0 |
| 2008-05-23 07:05:00 | AAPL | Stock | 6.4254 | 6.4393 | 6.425 | 6.4393 | 30800.0 |
| 2008-05-23 07:10:00 | AAPL | Stock | 6.4454 | 6.4464 | 6.4393 | 6.4393 | 217532.0 |
| 2008-05-23 07:15:00 | AAPL | Stock | 6.4393 | 6.4464 | 6.4393 | 6.4461 | 74200.0 |
| 2008-05-23 07:20:00 | AAPL | Stock | 6.4436 | 6.4436 | 6.4393 | 6.4429 | 14000.0 |
| 2008-05-23 07:25:00 | AAPL | Stock | 6.4357 | 6.4554 | 6.4357 | 6.45 | 221368.0 |
| 2008-05-23 07:30:00 | AAPL | Stock | 6.45 | 6.45 | 6.4464 | 6.4471 | 39200.0 |
| 2008-05-23 07:35:00 | AAPL | Stock | 6.4507 | 6.4643 | 6.4504 | 6.4643 | 582400.0 |
| 2008-05-23 07:40:00 | AAPL | Stock | 6.4643 | 6.4679 | 6.4614 | 6.4643 | 143780.0 |
| 2008-05-23 07:45:00 | AAPL | Stock | 6.4614 | 6.4818 | 6.4518 | 6.4818 | 817684.0 |
| 2008-05-23 07:50:00 | AAPL | Stock | 6.4818 | 6.5039 | 6.4807 | 6.5025 | 821296.0 |
| 2008-05-23 07:55:00 | AAPL | Stock | 6.5025 | 6.525 | 6.5 | 6.5107 | 611240.0 |
| 2008-05-23 08:00:00 | AAPL | Stock | 6.5107 | 6.5182 | 6.4286 | 6.4929 | 3578568.0 |
| 2008-05-23 08:05:00 | AAPL | Stock | 6.4929 | 6.5043 | 6.4825 | 6.4857 | 1815072.0 |
| 2008-05-23 08:10:00 | AAPL | Stock | 6.4832 | 6.4857 | 6.475 | 6.4843 | 872900.0 |
| 2008-05-23 08:15:00 | AAPL | Stock | 6.4832 | 6.4911 | 6.4786 | 6.4886 | 722232.0 |
| 2008-05-23 08:20:00 | AAPL | Stock | 6.4861 | 6.4861 | 6.4771 | 6.4771 | 558180.0 |
| 2008-05-23 08:25:00 | AAPL | Stock | 6.4761 | 6.4821 | 6.4718 | 6.475 | 595504.0 |
| 2008-05-23 08:30:00 | AAPL | Stock | 6.475 | 6.4768 | 6.4625 | 6.4625 | 839440.0 |
| 2008-05-23 08:35:00 | AAPL | Stock | 6.4629 | 6.4643 | 6.4539 | 6.4539 | 1263696.0 |
| 2008-05-23 08:40:00 | AAPL | Stock | 6.4546 | 6.4679 | 6.4514 | 6.4636 | 1109864.0 |
| 2008-05-23 08:45:00 | AAPL | Stock | 6.4636 | 6.4639 | 6.4554 | 6.4586 | 424424.0 |
| 2008-05-23 08:50:00 | AAPL | Stock | 6.4568 | 6.4661 | 6.4546 | 6.4575 | 550200.0 |
| 2008-05-23 08:55:00 | AAPL | Stock | 6.4579 | 6.4604 | 6.45 | 6.4504 | 486836.0 |
| 2008-05-23 09:00:00 | AAPL | Stock | 6.4504 | 6.4675 | 6.4475 | 6.4675 | 955360.0 |
| 2008-05-23 09:05:00 | AAPL | Stock | 6.4679 | 6.4818 | 6.4679 | 6.4729 | 1078196.0 |
| 2008-05-23 09:10:00 | AAPL | Stock | 6.4714 | 6.4786 | 6.4661 | 6.4693 | 648704.0 |
| 2008-05-23 09:15:00 | AAPL | Stock | 6.4693 | 6.4693 | 6.4643 | 6.4643 | 362768.0 |
| 2008-05-23 09:20:00 | AAPL | Stock | 6.4646 | 6.4668 | 6.4575 | 6.4589 | 408240.0 |
| 2008-05-23 09:25:00 | AAPL | Stock | 6.4579 | 6.4625 | 6.4504 | 6.4571 | 824684.0 |
| 2008-05-23 09:30:00 | AAPL | Stock | 6.4575 | 6.4643 | 6.4296 | 6.4643 | 37191308.0 |
| 2008-05-23 09:35:00 | AAPL | Stock | 6.4643 | 6.4889 | 6.4498 | 6.4753 | 33262236.0 |
| 2008-05-23 09:40:00 | AAPL | Stock | 6.475 | 6.4757 | 6.4446 | 6.4568 | 21210028.0 |
| 2008-05-23 09:45:00 | AAPL | Stock | 6.4568 | 6.4868 | 6.4518 | 6.4796 | 19841164.0 |
| 2008-05-23 09:50:00 | AAPL | Stock | 6.48 | 6.4843 | 6.4611 | 6.4729 | 20430340.0 |
| 2008-05-23 09:55:00 | AAPL | Stock | 6.4732 | 6.4741 | 6.4389 | 6.4425 | 17894604.0 |
| 2008-05-23 10:00:00 | AAPL | Stock | 6.4418 | 6.4714 | 6.4325 | 6.4714 | 18508224.0 |
> showing 50 of 311,154 rows — these rows as CSV