PREVIEW / stock_5min / 2007-12-03
file: by_date/stock_5min/2007/2007-12-03.parquet size: 4.3 MB rows: 319,393 symbols: 3,223
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-03 04:15:00 | AAPL | Stock | 6.4929 | 6.4929 | 6.4929 | 6.4929 | 12544.0 |
| 2007-12-03 06:05:00 | AAPL | Stock | 6.4696 | 6.4696 | 6.4696 | 6.4696 | 36400.0 |
| 2007-12-03 06:45:00 | AAPL | Stock | 6.4875 | 6.4875 | 6.4718 | 6.4718 | 8400.0 |
| 2007-12-03 06:50:00 | AAPL | Stock | 6.4929 | 6.4929 | 6.4929 | 6.4929 | 2800.0 |
| 2007-12-03 06:55:00 | AAPL | Stock | 6.5 | 6.5 | 6.4975 | 6.4975 | 16800.0 |
| 2007-12-03 07:05:00 | AAPL | Stock | 6.5061 | 6.5061 | 6.5061 | 6.5061 | 11200.0 |
| 2007-12-03 07:10:00 | AAPL | Stock | 6.5071 | 6.5071 | 6.5071 | 6.5071 | 5600.0 |
| 2007-12-03 07:15:00 | AAPL | Stock | 6.5071 | 6.5086 | 6.5071 | 6.5086 | 11200.0 |
| 2007-12-03 07:20:00 | AAPL | Stock | 6.5071 | 6.5161 | 6.5071 | 6.5104 | 64680.0 |
| 2007-12-03 07:25:00 | AAPL | Stock | 6.5161 | 6.5161 | 6.5039 | 6.5039 | 6860.0 |
| 2007-12-03 07:30:00 | AAPL | Stock | 6.5004 | 6.5004 | 6.5004 | 6.5004 | 10220.0 |
| 2007-12-03 07:35:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 2800.0 |
| 2007-12-03 07:40:00 | AAPL | Stock | 6.4929 | 6.4929 | 6.4732 | 6.4732 | 58100.0 |
| 2007-12-03 07:50:00 | AAPL | Stock | 6.4946 | 6.5071 | 6.4946 | 6.5071 | 35000.0 |
| 2007-12-03 08:00:00 | AAPL | Stock | 6.4964 | 6.5443 | 6.4964 | 6.5443 | 1009568.0 |
| 2007-12-03 08:05:00 | AAPL | Stock | 6.5443 | 6.5464 | 6.5343 | 6.5361 | 393428.0 |
| 2007-12-03 08:10:00 | AAPL | Stock | 6.5411 | 6.5411 | 6.5279 | 6.5286 | 393708.0 |
| 2007-12-03 08:15:00 | AAPL | Stock | 6.5275 | 6.5275 | 6.5114 | 6.5196 | 281820.0 |
| 2007-12-03 08:20:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5089 | 6.5107 | 128464.0 |
| 2007-12-03 08:25:00 | AAPL | Stock | 6.5107 | 6.5168 | 6.5 | 6.5096 | 203084.0 |
| 2007-12-03 08:30:00 | AAPL | Stock | 6.5089 | 6.5089 | 6.5 | 6.5021 | 247296.0 |
| 2007-12-03 08:35:00 | AAPL | Stock | 6.5007 | 6.5089 | 6.4896 | 6.5 | 394856.0 |
| 2007-12-03 08:40:00 | AAPL | Stock | 6.5 | 6.5179 | 6.4971 | 6.5136 | 315000.0 |
| 2007-12-03 08:45:00 | AAPL | Stock | 6.5132 | 6.5175 | 6.4932 | 6.5075 | 272664.0 |
| 2007-12-03 08:50:00 | AAPL | Stock | 6.5021 | 6.5079 | 6.4946 | 6.4964 | 118468.0 |
| 2007-12-03 08:55:00 | AAPL | Stock | 6.4964 | 6.4964 | 6.475 | 6.4757 | 424396.0 |
| 2007-12-03 09:00:00 | AAPL | Stock | 6.4786 | 6.4893 | 6.4786 | 6.4893 | 666708.0 |
| 2007-12-03 09:05:00 | AAPL | Stock | 6.4893 | 6.4925 | 6.4768 | 6.4814 | 254968.0 |
| 2007-12-03 09:10:00 | AAPL | Stock | 6.4804 | 6.4857 | 6.4579 | 6.4764 | 778988.0 |
| 2007-12-03 09:15:00 | AAPL | Stock | 6.4714 | 6.4718 | 6.4636 | 6.4643 | 177100.0 |
| 2007-12-03 09:20:00 | AAPL | Stock | 6.4661 | 6.4679 | 6.4593 | 6.4593 | 121660.0 |
| 2007-12-03 09:25:00 | AAPL | Stock | 6.4596 | 6.5 | 6.4586 | 6.4921 | 1885548.0 |
| 2007-12-03 09:30:00 | AAPL | Stock | 6.495 | 6.4964 | 6.4243 | 6.4514 | 30962288.0 |
| 2007-12-03 09:35:00 | AAPL | Stock | 6.4525 | 6.4643 | 6.4143 | 6.4264 | 23003988.0 |
| 2007-12-03 09:40:00 | AAPL | Stock | 6.4275 | 6.4486 | 6.3929 | 6.4125 | 27080760.0 |
| 2007-12-03 09:45:00 | AAPL | Stock | 6.412 | 6.435 | 6.4118 | 6.4314 | 17903004.0 |
| 2007-12-03 09:50:00 | AAPL | Stock | 6.4307 | 6.4393 | 6.4125 | 6.425 | 15124844.0 |
| 2007-12-03 09:55:00 | AAPL | Stock | 6.425 | 6.4271 | 6.3882 | 6.3986 | 16170000.0 |
| 2007-12-03 10:00:00 | AAPL | Stock | 6.3989 | 6.4196 | 6.3846 | 6.4061 | 23318932.0 |
| 2007-12-03 10:05:00 | AAPL | Stock | 6.4057 | 6.4293 | 6.395 | 6.4036 | 17760652.0 |
| 2007-12-03 10:10:00 | AAPL | Stock | 6.4039 | 6.4343 | 6.4025 | 6.4225 | 14083468.0 |
| 2007-12-03 10:15:00 | AAPL | Stock | 6.4225 | 6.4329 | 6.4175 | 6.4304 | 12105492.0 |
| 2007-12-03 10:20:00 | AAPL | Stock | 6.4289 | 6.4621 | 6.4268 | 6.4607 | 17740408.0 |
| 2007-12-03 10:25:00 | AAPL | Stock | 6.4611 | 6.4625 | 6.4421 | 6.4496 | 12755148.0 |
| 2007-12-03 10:30:00 | AAPL | Stock | 6.4504 | 6.4625 | 6.4407 | 6.4625 | 11650352.0 |
| 2007-12-03 10:35:00 | AAPL | Stock | 6.4621 | 6.49 | 6.4575 | 6.4839 | 18339076.0 |
| 2007-12-03 10:40:00 | AAPL | Stock | 6.4839 | 6.5 | 6.4782 | 6.4911 | 14689976.0 |
| 2007-12-03 10:45:00 | AAPL | Stock | 6.4911 | 6.5246 | 6.485 | 6.4968 | 18088448.0 |
| 2007-12-03 10:50:00 | AAPL | Stock | 6.4964 | 6.5136 | 6.4896 | 6.4986 | 12173112.0 |
| 2007-12-03 10:55:00 | AAPL | Stock | 6.4982 | 6.5357 | 6.4968 | 6.5271 | 16790340.0 |
> showing 50 of 319,393 rows — these rows as CSV