PREVIEW / stock_5min / 2009-07-21
file: by_date/stock_5min/2009/2009-07-21.parquet size: 4.5 MB rows: 309,562 symbols: 3,331
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-21 04:25:00 | AAPL | Stock | 5.5175 | 5.5175 | 5.5175 | 5.5175 | 8400.0 |
| 2009-07-21 05:35:00 | AAPL | Stock | 5.5175 | 5.5175 | 5.5175 | 5.5175 | 33600.0 |
| 2009-07-21 06:25:00 | AAPL | Stock | 5.495 | 5.495 | 5.495 | 5.495 | 14000.0 |
| 2009-07-21 07:05:00 | AAPL | Stock | 5.4843 | 5.4907 | 5.4821 | 5.4821 | 13384.0 |
| 2009-07-21 07:25:00 | AAPL | Stock | 5.4893 | 5.4911 | 5.4889 | 5.4911 | 61600.0 |
| 2009-07-21 07:30:00 | AAPL | Stock | 5.4911 | 5.5 | 5.4911 | 5.5 | 95200.0 |
| 2009-07-21 07:35:00 | AAPL | Stock | 5.5175 | 5.5207 | 5.5171 | 5.5171 | 78400.0 |
| 2009-07-21 07:40:00 | AAPL | Stock | 5.5146 | 5.5146 | 5.5 | 5.5 | 50400.0 |
| 2009-07-21 07:45:00 | AAPL | Stock | 5.5 | 5.5089 | 5.4946 | 5.4946 | 68600.0 |
| 2009-07-21 07:50:00 | AAPL | Stock | 5.5 | 5.5207 | 5.5 | 5.5182 | 229320.0 |
| 2009-07-21 07:55:00 | AAPL | Stock | 5.5171 | 5.5179 | 5.5171 | 5.5171 | 33600.0 |
| 2009-07-21 08:00:00 | AAPL | Stock | 5.5193 | 5.5286 | 5.5021 | 5.5175 | 372820.0 |
| 2009-07-21 08:05:00 | AAPL | Stock | 5.5179 | 5.5207 | 5.4936 | 5.4936 | 572236.0 |
| 2009-07-21 08:10:00 | AAPL | Stock | 5.4982 | 5.5 | 5.4911 | 5.4911 | 122584.0 |
| 2009-07-21 08:15:00 | AAPL | Stock | 5.4914 | 5.495 | 5.485 | 5.4914 | 192612.0 |
| 2009-07-21 08:20:00 | AAPL | Stock | 5.4932 | 5.5 | 5.4921 | 5.4964 | 299572.0 |
| 2009-07-21 08:25:00 | AAPL | Stock | 5.4996 | 5.5054 | 5.4982 | 5.5021 | 343252.0 |
| 2009-07-21 08:30:00 | AAPL | Stock | 5.5021 | 5.5021 | 5.4925 | 5.4975 | 134876.0 |
| 2009-07-21 08:35:00 | AAPL | Stock | 5.4982 | 5.5 | 5.4964 | 5.4986 | 106792.0 |
| 2009-07-21 08:40:00 | AAPL | Stock | 5.4964 | 5.4982 | 5.4929 | 5.4932 | 171220.0 |
| 2009-07-21 08:45:00 | AAPL | Stock | 5.4925 | 5.4932 | 5.4857 | 5.49 | 210308.0 |
| 2009-07-21 08:50:00 | AAPL | Stock | 5.4893 | 5.4929 | 5.4868 | 5.4896 | 131936.0 |
| 2009-07-21 08:55:00 | AAPL | Stock | 5.4961 | 5.4961 | 5.4918 | 5.4918 | 71736.0 |
| 2009-07-21 09:00:00 | AAPL | Stock | 5.4929 | 5.4954 | 5.4918 | 5.4939 | 49196.0 |
| 2009-07-21 09:05:00 | AAPL | Stock | 5.4946 | 5.4946 | 5.4904 | 5.4918 | 166880.0 |
| 2009-07-21 09:10:00 | AAPL | Stock | 5.4904 | 5.4921 | 5.4893 | 5.4893 | 277284.0 |
| 2009-07-21 09:15:00 | AAPL | Stock | 5.4889 | 5.4889 | 5.4789 | 5.4818 | 330624.0 |
| 2009-07-21 09:20:00 | AAPL | Stock | 5.4818 | 5.4818 | 5.4561 | 5.4639 | 1125544.0 |
| 2009-07-21 09:25:00 | AAPL | Stock | 5.4639 | 5.4879 | 5.4639 | 5.4743 | 1775984.0 |
| 2009-07-21 09:30:00 | AAPL | Stock | 5.4743 | 5.4796 | 5.4204 | 5.428 | 29667736.0 |
| 2009-07-21 09:35:00 | AAPL | Stock | 5.4277 | 5.455 | 5.4232 | 5.4543 | 24816064.0 |
| 2009-07-21 09:40:00 | AAPL | Stock | 5.4546 | 5.455 | 5.4321 | 5.4379 | 16181452.0 |
| 2009-07-21 09:45:00 | AAPL | Stock | 5.4364 | 5.4421 | 5.4157 | 5.4307 | 13295128.0 |
| 2009-07-21 09:50:00 | AAPL | Stock | 5.4318 | 5.4375 | 5.4157 | 5.4364 | 14901880.0 |
| 2009-07-21 09:55:00 | AAPL | Stock | 5.4364 | 5.4393 | 5.4282 | 5.4285 | 6138748.0 |
| 2009-07-21 10:00:00 | AAPL | Stock | 5.4282 | 5.4411 | 5.4182 | 5.4264 | 10916976.0 |
| 2009-07-21 10:05:00 | AAPL | Stock | 5.4268 | 5.4325 | 5.4204 | 5.4207 | 7040432.0 |
| 2009-07-21 10:10:00 | AAPL | Stock | 5.4204 | 5.4279 | 5.4075 | 5.4221 | 13013616.0 |
| 2009-07-21 10:15:00 | AAPL | Stock | 5.4221 | 5.4318 | 5.4146 | 5.4291 | 6919192.0 |
| 2009-07-21 10:20:00 | AAPL | Stock | 5.43 | 5.4343 | 5.4289 | 5.4332 | 6576220.0 |
| 2009-07-21 10:25:00 | AAPL | Stock | 5.4329 | 5.4364 | 5.4243 | 5.4311 | 6195196.0 |
| 2009-07-21 10:30:00 | AAPL | Stock | 5.4314 | 5.4396 | 5.4293 | 5.4368 | 6764548.0 |
| 2009-07-21 10:35:00 | AAPL | Stock | 5.4375 | 5.4379 | 5.4186 | 5.4211 | 9736412.0 |
| 2009-07-21 10:40:00 | AAPL | Stock | 5.4207 | 5.4307 | 5.4175 | 5.4304 | 6656328.0 |
| 2009-07-21 10:45:00 | AAPL | Stock | 5.4304 | 5.4304 | 5.4196 | 5.4207 | 4615996.0 |
| 2009-07-21 10:50:00 | AAPL | Stock | 5.42 | 5.4204 | 5.4096 | 5.4179 | 8884988.0 |
| 2009-07-21 10:55:00 | AAPL | Stock | 5.4175 | 5.4225 | 5.4111 | 5.4125 | 8632792.0 |
| 2009-07-21 11:00:00 | AAPL | Stock | 5.4136 | 5.4182 | 5.4114 | 5.4164 | 5465488.0 |
| 2009-07-21 11:05:00 | AAPL | Stock | 5.4157 | 5.4214 | 5.4107 | 5.4193 | 7121016.0 |
| 2009-07-21 11:10:00 | AAPL | Stock | 5.4196 | 5.4218 | 5.405 | 5.4101 | 6787480.0 |
> showing 50 of 309,562 rows — these rows as CSV