PREVIEW / stock_5min / 2008-10-23
file: by_date/stock_5min/2008/2008-10-23.parquet size: 4.5 MB rows: 318,105 symbols: 3,312
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-10-23 04:15:00 | AAPL | Stock | 3.4643 | 3.5 | 3.4643 | 3.5 | 16800.0 |
| 2008-10-23 07:05:00 | AAPL | Stock | 3.4536 | 3.4536 | 3.4536 | 3.4536 | 2800.0 |
| 2008-10-23 07:15:00 | AAPL | Stock | 3.4543 | 3.4554 | 3.4543 | 3.4554 | 16800.0 |
| 2008-10-23 07:20:00 | AAPL | Stock | 3.4554 | 3.4643 | 3.4554 | 3.4554 | 53340.0 |
| 2008-10-23 07:25:00 | AAPL | Stock | 3.4464 | 3.4464 | 3.4464 | 3.4464 | 2800.0 |
| 2008-10-23 07:30:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4286 | 3.4286 | 27440.0 |
| 2008-10-23 07:35:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4286 | 3.4286 | 3360.0 |
| 2008-10-23 07:40:00 | AAPL | Stock | 3.4393 | 3.4632 | 3.4118 | 3.4118 | 73780.0 |
| 2008-10-23 07:50:00 | AAPL | Stock | 3.3993 | 3.3993 | 3.395 | 3.395 | 13300.0 |
| 2008-10-23 07:55:00 | AAPL | Stock | 3.4107 | 3.4264 | 3.4107 | 3.4125 | 30800.0 |
| 2008-10-23 08:00:00 | AAPL | Stock | 3.4107 | 3.4207 | 3.4 | 3.4089 | 284676.0 |
| 2008-10-23 08:05:00 | AAPL | Stock | 3.4079 | 3.4236 | 3.4079 | 3.4161 | 201068.0 |
| 2008-10-23 08:10:00 | AAPL | Stock | 3.4086 | 3.4207 | 3.4086 | 3.4143 | 38640.0 |
| 2008-10-23 08:15:00 | AAPL | Stock | 3.4089 | 3.4214 | 3.4071 | 3.4214 | 133308.0 |
| 2008-10-23 08:20:00 | AAPL | Stock | 3.4146 | 3.4243 | 3.4143 | 3.4143 | 146972.0 |
| 2008-10-23 08:25:00 | AAPL | Stock | 3.4143 | 3.4289 | 3.4139 | 3.4289 | 194180.0 |
| 2008-10-23 08:30:00 | AAPL | Stock | 3.4289 | 3.4375 | 3.4211 | 3.4314 | 625576.0 |
| 2008-10-23 08:35:00 | AAPL | Stock | 3.4318 | 3.4375 | 3.4311 | 3.4339 | 154840.0 |
| 2008-10-23 08:40:00 | AAPL | Stock | 3.4321 | 3.4321 | 3.4282 | 3.4321 | 209860.0 |
| 2008-10-23 08:45:00 | AAPL | Stock | 3.4311 | 3.4446 | 3.4311 | 3.4411 | 133840.0 |
| 2008-10-23 08:50:00 | AAPL | Stock | 3.4425 | 3.4514 | 3.4396 | 3.45 | 697844.0 |
| 2008-10-23 08:55:00 | AAPL | Stock | 3.45 | 3.4571 | 3.4461 | 3.4571 | 278852.0 |
| 2008-10-23 09:00:00 | AAPL | Stock | 3.4586 | 3.4736 | 3.4521 | 3.4689 | 870016.0 |
| 2008-10-23 09:05:00 | AAPL | Stock | 3.4689 | 3.4736 | 3.4643 | 3.4721 | 317380.0 |
| 2008-10-23 09:10:00 | AAPL | Stock | 3.4707 | 3.4732 | 3.4643 | 3.4668 | 647248.0 |
| 2008-10-23 09:15:00 | AAPL | Stock | 3.4679 | 3.475 | 3.4671 | 3.47 | 338604.0 |
| 2008-10-23 09:20:00 | AAPL | Stock | 3.4696 | 3.4754 | 3.4646 | 3.4714 | 295988.0 |
| 2008-10-23 09:25:00 | AAPL | Stock | 3.4739 | 3.4743 | 3.4414 | 3.4468 | 928088.0 |
| 2008-10-23 09:30:00 | AAPL | Stock | 3.4468 | 3.5 | 3.4354 | 3.4929 | 32969440.0 |
| 2008-10-23 09:35:00 | AAPL | Stock | 3.4921 | 3.5089 | 3.4582 | 3.4593 | 32002908.0 |
| 2008-10-23 09:40:00 | AAPL | Stock | 3.4596 | 3.4804 | 3.4011 | 3.4189 | 37925076.0 |
| 2008-10-23 09:45:00 | AAPL | Stock | 3.4168 | 3.46 | 3.4025 | 3.4246 | 30428384.0 |
| 2008-10-23 09:50:00 | AAPL | Stock | 3.4239 | 3.4611 | 3.4014 | 3.4539 | 31196284.0 |
| 2008-10-23 09:55:00 | AAPL | Stock | 3.4539 | 3.4821 | 3.4532 | 3.4757 | 30154992.0 |
| 2008-10-23 10:00:00 | AAPL | Stock | 3.4771 | 3.4921 | 3.4454 | 3.4518 | 25344844.0 |
| 2008-10-23 10:05:00 | AAPL | Stock | 3.4507 | 3.4914 | 3.4446 | 3.4718 | 26656420.0 |
| 2008-10-23 10:10:00 | AAPL | Stock | 3.4689 | 3.4982 | 3.4639 | 3.4896 | 23538788.0 |
| 2008-10-23 10:15:00 | AAPL | Stock | 3.49 | 3.4914 | 3.4579 | 3.465 | 25711252.0 |
| 2008-10-23 10:20:00 | AAPL | Stock | 3.4657 | 3.4889 | 3.4589 | 3.4718 | 17725988.0 |
| 2008-10-23 10:25:00 | AAPL | Stock | 3.4718 | 3.4821 | 3.4486 | 3.4729 | 22834504.0 |
| 2008-10-23 10:30:00 | AAPL | Stock | 3.4739 | 3.4982 | 3.4618 | 3.4904 | 21674268.0 |
| 2008-10-23 10:35:00 | AAPL | Stock | 3.4914 | 3.5 | 3.4682 | 3.4893 | 21739788.0 |
| 2008-10-23 10:40:00 | AAPL | Stock | 3.4893 | 3.5107 | 3.4821 | 3.5097 | 27001856.0 |
| 2008-10-23 10:45:00 | AAPL | Stock | 3.5096 | 3.5154 | 3.4821 | 3.485 | 21728392.0 |
| 2008-10-23 10:50:00 | AAPL | Stock | 3.485 | 3.4979 | 3.4725 | 3.4861 | 17120348.0 |
| 2008-10-23 10:55:00 | AAPL | Stock | 3.4864 | 3.5161 | 3.4779 | 3.5082 | 18501504.0 |
| 2008-10-23 11:00:00 | AAPL | Stock | 3.5082 | 3.5168 | 3.4893 | 3.4896 | 20994036.0 |
| 2008-10-23 11:05:00 | AAPL | Stock | 3.4896 | 3.5121 | 3.4896 | 3.5068 | 15953420.0 |
| 2008-10-23 11:10:00 | AAPL | Stock | 3.5061 | 3.5396 | 3.5057 | 3.5143 | 25976916.0 |
| 2008-10-23 11:15:00 | AAPL | Stock | 3.5146 | 3.5232 | 3.4979 | 3.5114 | 20940276.0 |
> showing 50 of 318,105 rows — these rows as CSV