PREVIEW / stock_5min / 2008-04-09
file: by_date/stock_5min/2008/2008-04-09.parquet size: 4.2 MB rows: 307,791 symbols: 3,289
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-09 04:15:00 | AAPL | Stock | 5.4518 | 5.4518 | 5.4518 | 5.4518 | 3948.0 |
| 2008-04-09 04:55:00 | AAPL | Stock | 5.4332 | 5.4332 | 5.4332 | 5.4332 | 2800.0 |
| 2008-04-09 06:30:00 | AAPL | Stock | 5.4536 | 5.4536 | 5.4536 | 5.4536 | 2800.0 |
| 2008-04-09 06:40:00 | AAPL | Stock | 5.4686 | 5.4686 | 5.4686 | 5.4686 | 2800.0 |
| 2008-04-09 07:05:00 | AAPL | Stock | 5.4696 | 5.4786 | 5.4696 | 5.4786 | 8400.0 |
| 2008-04-09 07:20:00 | AAPL | Stock | 5.4929 | 5.4929 | 5.4929 | 5.4929 | 25200.0 |
| 2008-04-09 07:30:00 | AAPL | Stock | 5.4921 | 5.4921 | 5.4921 | 5.4921 | 4312.0 |
| 2008-04-09 07:50:00 | AAPL | Stock | 5.4714 | 5.4714 | 5.4696 | 5.4696 | 36400.0 |
| 2008-04-09 07:55:00 | AAPL | Stock | 5.4696 | 5.4696 | 5.4664 | 5.4664 | 8400.0 |
| 2008-04-09 08:00:00 | AAPL | Stock | 5.4675 | 5.4821 | 5.4661 | 5.4714 | 442428.0 |
| 2008-04-09 08:05:00 | AAPL | Stock | 5.4736 | 5.4743 | 5.4643 | 5.4643 | 151620.0 |
| 2008-04-09 08:10:00 | AAPL | Stock | 5.4639 | 5.4704 | 5.4639 | 5.4679 | 108808.0 |
| 2008-04-09 08:15:00 | AAPL | Stock | 5.4696 | 5.4704 | 5.4611 | 5.4643 | 215096.0 |
| 2008-04-09 08:20:00 | AAPL | Stock | 5.4643 | 5.4646 | 5.4629 | 5.4646 | 123172.0 |
| 2008-04-09 08:25:00 | AAPL | Stock | 5.4643 | 5.4671 | 5.4643 | 5.4671 | 38892.0 |
| 2008-04-09 08:30:00 | AAPL | Stock | 5.4679 | 5.4704 | 5.4679 | 5.4704 | 148148.0 |
| 2008-04-09 08:35:00 | AAPL | Stock | 5.4729 | 5.4811 | 5.4729 | 5.4786 | 129976.0 |
| 2008-04-09 08:40:00 | AAPL | Stock | 5.4786 | 5.4821 | 5.4786 | 5.4821 | 369068.0 |
| 2008-04-09 08:45:00 | AAPL | Stock | 5.4839 | 5.4875 | 5.4804 | 5.4804 | 327488.0 |
| 2008-04-09 08:50:00 | AAPL | Stock | 5.4807 | 5.4893 | 5.4804 | 5.4864 | 162176.0 |
| 2008-04-09 08:55:00 | AAPL | Stock | 5.485 | 5.4893 | 5.4843 | 5.4868 | 186900.0 |
| 2008-04-09 09:00:00 | AAPL | Stock | 5.4875 | 5.4882 | 5.485 | 5.4857 | 138684.0 |
| 2008-04-09 09:05:00 | AAPL | Stock | 5.4864 | 5.4889 | 5.4811 | 5.4839 | 370832.0 |
| 2008-04-09 09:10:00 | AAPL | Stock | 5.4839 | 5.4875 | 5.4821 | 5.4821 | 163492.0 |
| 2008-04-09 09:15:00 | AAPL | Stock | 5.4832 | 5.4875 | 5.4821 | 5.4875 | 111580.0 |
| 2008-04-09 09:20:00 | AAPL | Stock | 5.4871 | 5.4889 | 5.4857 | 5.4861 | 206024.0 |
| 2008-04-09 09:25:00 | AAPL | Stock | 5.4836 | 5.4836 | 5.4786 | 5.4789 | 146860.0 |
| 2008-04-09 09:30:00 | AAPL | Stock | 5.4768 | 5.4961 | 5.4571 | 5.4864 | 23433424.0 |
| 2008-04-09 09:35:00 | AAPL | Stock | 5.4864 | 5.4921 | 5.4504 | 5.4568 | 20182260.0 |
| 2008-04-09 09:40:00 | AAPL | Stock | 5.4568 | 5.4664 | 5.4004 | 5.4132 | 30214352.0 |
| 2008-04-09 09:45:00 | AAPL | Stock | 5.4118 | 5.4293 | 5.4046 | 5.4286 | 22381604.0 |
| 2008-04-09 09:50:00 | AAPL | Stock | 5.4286 | 5.4414 | 5.4229 | 5.4291 | 22493772.0 |
| 2008-04-09 09:55:00 | AAPL | Stock | 5.4275 | 5.4318 | 5.4154 | 5.4304 | 19493236.0 |
| 2008-04-09 10:00:00 | AAPL | Stock | 5.4296 | 5.4308 | 5.4064 | 5.4261 | 16287432.0 |
| 2008-04-09 10:05:00 | AAPL | Stock | 5.4268 | 5.442 | 5.4129 | 5.4367 | 15945944.0 |
| 2008-04-09 10:10:00 | AAPL | Stock | 5.4363 | 5.4486 | 5.4289 | 5.4461 | 14558684.0 |
| 2008-04-09 10:15:00 | AAPL | Stock | 5.4457 | 5.4643 | 5.4364 | 5.4614 | 17105284.0 |
| 2008-04-09 10:20:00 | AAPL | Stock | 5.4611 | 5.4821 | 5.4611 | 5.4718 | 20423368.0 |
| 2008-04-09 10:25:00 | AAPL | Stock | 5.4721 | 5.4721 | 5.4561 | 5.4639 | 10930696.0 |
| 2008-04-09 10:30:00 | AAPL | Stock | 5.4643 | 5.4664 | 5.4364 | 5.4457 | 12905704.0 |
| 2008-04-09 10:35:00 | AAPL | Stock | 5.4461 | 5.4471 | 5.4286 | 5.4407 | 11234468.0 |
| 2008-04-09 10:40:00 | AAPL | Stock | 5.4418 | 5.4443 | 5.4268 | 5.4364 | 10061184.0 |
| 2008-04-09 10:45:00 | AAPL | Stock | 5.4361 | 5.4461 | 5.4357 | 5.4393 | 13469456.0 |
| 2008-04-09 10:50:00 | AAPL | Stock | 5.4396 | 5.4411 | 5.4293 | 5.4379 | 8132992.0 |
| 2008-04-09 10:55:00 | AAPL | Stock | 5.4375 | 5.4568 | 5.4371 | 5.4554 | 9524144.0 |
| 2008-04-09 11:00:00 | AAPL | Stock | 5.4564 | 5.4564 | 5.4479 | 5.4521 | 6639528.0 |
| 2008-04-09 11:05:00 | AAPL | Stock | 5.4525 | 5.4525 | 5.4329 | 5.4367 | 6680072.0 |
| 2008-04-09 11:10:00 | AAPL | Stock | 5.435 | 5.4404 | 5.4314 | 5.4339 | 5376700.0 |
| 2008-04-09 11:15:00 | AAPL | Stock | 5.4339 | 5.44 | 5.4329 | 5.4346 | 3649044.0 |
| 2008-04-09 11:20:00 | AAPL | Stock | 5.4343 | 5.4461 | 5.425 | 5.4311 | 9464448.0 |
> showing 50 of 307,791 rows — these rows as CSV