PREVIEW / stock_5min / 2007-12-05
file: by_date/stock_5min/2007/2007-12-05.parquet size: 4.3 MB rows: 316,144 symbols: 3,203
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-05 04:45:00 | AAPL | Stock | 6.4636 | 6.4636 | 6.4636 | 6.4636 | 33600.0 |
| 2007-12-05 05:10:00 | AAPL | Stock | 6.4718 | 6.4718 | 6.4718 | 6.4718 | 2800.0 |
| 2007-12-05 06:20:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4811 | 6.4811 | 22400.0 |
| 2007-12-05 06:25:00 | AAPL | Stock | 6.4811 | 6.4811 | 6.4811 | 6.4811 | 2800.0 |
| 2007-12-05 06:50:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 8400.0 |
| 2007-12-05 07:00:00 | AAPL | Stock | 6.5 | 6.5 | 6.4929 | 6.4929 | 47600.0 |
| 2007-12-05 07:05:00 | AAPL | Stock | 6.4929 | 6.4929 | 6.4929 | 6.4929 | 3920.0 |
| 2007-12-05 07:10:00 | AAPL | Stock | 6.5 | 6.5 | 6.4821 | 6.4821 | 21924.0 |
| 2007-12-05 07:20:00 | AAPL | Stock | 6.5004 | 6.5004 | 6.5004 | 6.5004 | 14280.0 |
| 2007-12-05 07:25:00 | AAPL | Stock | 6.5004 | 6.5004 | 6.5004 | 6.5004 | 13720.0 |
| 2007-12-05 07:40:00 | AAPL | Stock | 6.4861 | 6.4861 | 6.4821 | 6.4821 | 16800.0 |
| 2007-12-05 07:45:00 | AAPL | Stock | 6.4814 | 6.4821 | 6.4814 | 6.4821 | 112000.0 |
| 2007-12-05 07:50:00 | AAPL | Stock | 6.4854 | 6.4911 | 6.4854 | 6.4911 | 14000.0 |
| 2007-12-05 08:00:00 | AAPL | Stock | 6.4893 | 6.4932 | 6.4218 | 6.4793 | 847868.0 |
| 2007-12-05 08:05:00 | AAPL | Stock | 6.4836 | 6.4929 | 6.4804 | 6.4857 | 261800.0 |
| 2007-12-05 08:10:00 | AAPL | Stock | 6.4839 | 6.4839 | 6.4736 | 6.4768 | 721868.0 |
| 2007-12-05 08:15:00 | AAPL | Stock | 6.48 | 6.5 | 6.48 | 6.4996 | 552160.0 |
| 2007-12-05 08:20:00 | AAPL | Stock | 6.4996 | 6.4996 | 6.4911 | 6.4911 | 435736.0 |
| 2007-12-05 08:25:00 | AAPL | Stock | 6.4946 | 6.495 | 6.4918 | 6.4921 | 130620.0 |
| 2007-12-05 08:30:00 | AAPL | Stock | 6.4921 | 6.5046 | 6.4911 | 6.5 | 304444.0 |
| 2007-12-05 08:35:00 | AAPL | Stock | 6.5004 | 6.5179 | 6.5 | 6.5161 | 720524.0 |
| 2007-12-05 08:40:00 | AAPL | Stock | 6.5161 | 6.5289 | 6.5161 | 6.5275 | 1131984.0 |
| 2007-12-05 08:45:00 | AAPL | Stock | 6.5275 | 6.5357 | 6.5275 | 6.5357 | 1194144.0 |
| 2007-12-05 08:50:00 | AAPL | Stock | 6.5354 | 6.5375 | 6.5282 | 6.5282 | 459928.0 |
| 2007-12-05 08:55:00 | AAPL | Stock | 6.5282 | 6.5311 | 6.524 | 6.5268 | 510832.0 |
| 2007-12-05 09:00:00 | AAPL | Stock | 6.5268 | 6.5357 | 6.525 | 6.5357 | 400512.0 |
| 2007-12-05 09:05:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5268 | 6.5325 | 419776.0 |
| 2007-12-05 09:10:00 | AAPL | Stock | 6.535 | 6.5407 | 6.5325 | 6.5407 | 651028.0 |
| 2007-12-05 09:15:00 | AAPL | Stock | 6.5393 | 6.5546 | 6.5393 | 6.5504 | 1004248.0 |
| 2007-12-05 09:20:00 | AAPL | Stock | 6.5468 | 6.5471 | 6.5293 | 6.5307 | 693756.0 |
| 2007-12-05 09:25:00 | AAPL | Stock | 6.5321 | 6.5443 | 6.5293 | 6.5325 | 646520.0 |
| 2007-12-05 09:30:00 | AAPL | Stock | 6.5329 | 6.55 | 6.5182 | 6.5207 | 28436548.0 |
| 2007-12-05 09:35:00 | AAPL | Stock | 6.5207 | 6.5464 | 6.5146 | 6.5413 | 18429068.0 |
| 2007-12-05 09:40:00 | AAPL | Stock | 6.5436 | 6.5536 | 6.5311 | 6.5414 | 26822600.0 |
| 2007-12-05 09:45:00 | AAPL | Stock | 6.5418 | 6.5536 | 6.5354 | 6.5427 | 15519924.0 |
| 2007-12-05 09:50:00 | AAPL | Stock | 6.5425 | 6.5514 | 6.5346 | 6.5439 | 14893676.0 |
| 2007-12-05 09:55:00 | AAPL | Stock | 6.5446 | 6.5589 | 6.5439 | 6.5575 | 17880688.0 |
| 2007-12-05 10:00:00 | AAPL | Stock | 6.5571 | 6.5754 | 6.5471 | 6.5743 | 22612240.0 |
| 2007-12-05 10:05:00 | AAPL | Stock | 6.5746 | 6.5793 | 6.5625 | 6.5638 | 16562560.0 |
| 2007-12-05 10:10:00 | AAPL | Stock | 6.5636 | 6.575 | 6.5536 | 6.559 | 11569012.0 |
| 2007-12-05 10:15:00 | AAPL | Stock | 6.5593 | 6.5607 | 6.5504 | 6.5593 | 8638056.0 |
| 2007-12-05 10:20:00 | AAPL | Stock | 6.5604 | 6.5661 | 6.5543 | 6.5571 | 8779624.0 |
| 2007-12-05 10:25:00 | AAPL | Stock | 6.5571 | 6.5657 | 6.5539 | 6.5596 | 8355396.0 |
| 2007-12-05 10:30:00 | AAPL | Stock | 6.5596 | 6.5621 | 6.5482 | 6.5586 | 7725872.0 |
| 2007-12-05 10:35:00 | AAPL | Stock | 6.5586 | 6.5657 | 6.5582 | 6.5596 | 7751548.0 |
| 2007-12-05 10:40:00 | AAPL | Stock | 6.5596 | 6.5746 | 6.5596 | 6.5739 | 9314816.0 |
| 2007-12-05 10:45:00 | AAPL | Stock | 6.5736 | 6.5868 | 6.5714 | 6.5761 | 14123956.0 |
| 2007-12-05 10:50:00 | AAPL | Stock | 6.5757 | 6.5943 | 6.5757 | 6.5882 | 10712772.0 |
| 2007-12-05 10:55:00 | AAPL | Stock | 6.5882 | 6.5907 | 6.5807 | 6.5889 | 6004516.0 |
| 2007-12-05 11:00:00 | AAPL | Stock | 6.5889 | 6.5989 | 6.5782 | 6.5789 | 10732792.0 |
> showing 50 of 316,144 rows — these rows as CSV