PREVIEW / stock_5min / 2007-11-29
file: by_date/stock_5min/2007/2007-11-29.parquet size: 4.3 MB rows: 311,327 symbols: 3,200
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-11-29 04:35:00 | AAPL | Stock | 6.4625 | 6.4643 | 6.4625 | 6.4643 | 5600.0 |
| 2007-11-29 04:55:00 | AAPL | Stock | 6.4461 | 6.4461 | 6.4461 | 6.4461 | 5600.0 |
| 2007-11-29 05:05:00 | AAPL | Stock | 6.4339 | 6.4339 | 6.4339 | 6.4339 | 11200.0 |
| 2007-11-29 05:20:00 | AAPL | Stock | 6.4304 | 6.4304 | 6.4304 | 6.4304 | 2800.0 |
| 2007-11-29 06:00:00 | AAPL | Stock | 6.4304 | 6.4304 | 6.4304 | 6.4304 | 2800.0 |
| 2007-11-29 06:10:00 | AAPL | Stock | 6.4218 | 6.4218 | 6.4218 | 6.4218 | 8400.0 |
| 2007-11-29 07:00:00 | AAPL | Stock | 6.4271 | 6.4271 | 6.4143 | 6.4143 | 10920.0 |
| 2007-11-29 07:10:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4025 | 6.4071 | 30800.0 |
| 2007-11-29 07:15:00 | AAPL | Stock | 6.4264 | 6.4264 | 6.4264 | 6.4264 | 3500.0 |
| 2007-11-29 07:20:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 8400.0 |
| 2007-11-29 07:30:00 | AAPL | Stock | 6.4114 | 6.4114 | 6.4114 | 6.4114 | 8400.0 |
| 2007-11-29 07:40:00 | AAPL | Stock | 6.4107 | 6.4286 | 6.4107 | 6.4286 | 181944.0 |
| 2007-11-29 07:45:00 | AAPL | Stock | 6.425 | 6.4304 | 6.425 | 6.4304 | 52052.0 |
| 2007-11-29 07:50:00 | AAPL | Stock | 6.4304 | 6.4443 | 6.4214 | 6.4443 | 33320.0 |
| 2007-11-29 07:55:00 | AAPL | Stock | 6.4429 | 6.4539 | 6.4429 | 6.4539 | 81200.0 |
| 2007-11-29 08:00:00 | AAPL | Stock | 6.45 | 6.45 | 6.4329 | 6.4429 | 545496.0 |
| 2007-11-29 08:05:00 | AAPL | Stock | 6.4429 | 6.4429 | 6.4286 | 6.4364 | 339640.0 |
| 2007-11-29 08:10:00 | AAPL | Stock | 6.4375 | 6.4464 | 6.4364 | 6.4446 | 104412.0 |
| 2007-11-29 08:15:00 | AAPL | Stock | 6.4432 | 6.4461 | 6.4357 | 6.4364 | 122332.0 |
| 2007-11-29 08:20:00 | AAPL | Stock | 6.4364 | 6.4364 | 6.4196 | 6.4232 | 1102528.0 |
| 2007-11-29 08:25:00 | AAPL | Stock | 6.4229 | 6.4254 | 6.4171 | 6.4232 | 744520.0 |
| 2007-11-29 08:30:00 | AAPL | Stock | 6.4225 | 6.4329 | 6.4179 | 6.42 | 681604.0 |
| 2007-11-29 08:35:00 | AAPL | Stock | 6.4432 | 6.4446 | 6.3986 | 6.3996 | 3593996.0 |
| 2007-11-29 08:40:00 | AAPL | Stock | 6.4007 | 6.4064 | 6.3886 | 6.3907 | 1034964.0 |
| 2007-11-29 08:45:00 | AAPL | Stock | 6.3914 | 6.4107 | 6.3868 | 6.4036 | 1117760.0 |
| 2007-11-29 08:50:00 | AAPL | Stock | 6.4068 | 6.4214 | 6.3982 | 6.4107 | 493052.0 |
| 2007-11-29 08:55:00 | AAPL | Stock | 6.4164 | 6.42 | 6.4086 | 6.4125 | 301280.0 |
| 2007-11-29 09:00:00 | AAPL | Stock | 6.4125 | 6.4143 | 6.4093 | 6.4143 | 216384.0 |
| 2007-11-29 09:05:00 | AAPL | Stock | 6.4143 | 6.4186 | 6.4125 | 6.4136 | 103292.0 |
| 2007-11-29 09:10:00 | AAPL | Stock | 6.4136 | 6.4139 | 6.4036 | 6.4036 | 219576.0 |
| 2007-11-29 09:15:00 | AAPL | Stock | 6.4018 | 6.4036 | 6.4 | 6.4029 | 100800.0 |
| 2007-11-29 09:20:00 | AAPL | Stock | 6.4036 | 6.4125 | 6.4025 | 6.4036 | 154000.0 |
| 2007-11-29 09:25:00 | AAPL | Stock | 6.4043 | 6.4121 | 6.3982 | 6.4082 | 338800.0 |
| 2007-11-29 09:30:00 | AAPL | Stock | 6.4111 | 6.4339 | 6.3982 | 6.4304 | 27987652.0 |
| 2007-11-29 09:35:00 | AAPL | Stock | 6.4346 | 6.4464 | 6.4071 | 6.44 | 26095048.0 |
| 2007-11-29 09:40:00 | AAPL | Stock | 6.44 | 6.4625 | 6.4293 | 6.4571 | 28417228.0 |
| 2007-11-29 09:45:00 | AAPL | Stock | 6.4564 | 6.4571 | 6.42 | 6.4246 | 22805776.0 |
| 2007-11-29 09:50:00 | AAPL | Stock | 6.4254 | 6.4286 | 6.4071 | 6.4193 | 17750432.0 |
| 2007-11-29 09:55:00 | AAPL | Stock | 6.4193 | 6.4332 | 6.4143 | 6.4189 | 16063768.0 |
| 2007-11-29 10:00:00 | AAPL | Stock | 6.4182 | 6.4339 | 6.4143 | 6.419 | 16404472.0 |
| 2007-11-29 10:05:00 | AAPL | Stock | 6.4193 | 6.4286 | 6.4082 | 6.4171 | 16157904.0 |
| 2007-11-29 10:10:00 | AAPL | Stock | 6.4168 | 6.4229 | 6.4071 | 6.4179 | 14912212.0 |
| 2007-11-29 10:15:00 | AAPL | Stock | 6.4179 | 6.4286 | 6.4154 | 6.4225 | 13048056.0 |
| 2007-11-29 10:20:00 | AAPL | Stock | 6.4218 | 6.4279 | 6.4146 | 6.4243 | 8880872.0 |
| 2007-11-29 10:25:00 | AAPL | Stock | 6.4243 | 6.4396 | 6.4168 | 6.4386 | 12147128.0 |
| 2007-11-29 10:30:00 | AAPL | Stock | 6.4386 | 6.4443 | 6.4286 | 6.44 | 13210008.0 |
| 2007-11-29 10:35:00 | AAPL | Stock | 6.4379 | 6.4625 | 6.4304 | 6.4611 | 15193164.0 |
| 2007-11-29 10:40:00 | AAPL | Stock | 6.4611 | 6.4911 | 6.4582 | 6.4825 | 22424472.0 |
| 2007-11-29 10:45:00 | AAPL | Stock | 6.4829 | 6.4932 | 6.47 | 6.4775 | 14976640.0 |
| 2007-11-29 10:50:00 | AAPL | Stock | 6.4771 | 6.485 | 6.4682 | 6.4807 | 9168628.0 |
> showing 50 of 311,327 rows — these rows as CSV