PREVIEW / stock_5min / 2010-12-08
file: by_date/stock_5min/2010/2010-12-08.parquet size: 4.8 MB rows: 328,198 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-08 05:05:00 | AAPL | Stock | 11.3857 | 11.3857 | 11.3725 | 11.3725 | 5600.0 |
| 2010-12-08 05:35:00 | AAPL | Stock | 11.3725 | 11.3725 | 11.3725 | 11.3725 | 2800.0 |
| 2010-12-08 06:50:00 | AAPL | Stock | 11.4079 | 11.4079 | 11.4079 | 11.4079 | 2800.0 |
| 2010-12-08 07:00:00 | AAPL | Stock | 11.3843 | 11.3843 | 11.3839 | 11.3839 | 9800.0 |
| 2010-12-08 07:10:00 | AAPL | Stock | 11.3846 | 11.3846 | 11.3846 | 11.3846 | 2800.0 |
| 2010-12-08 07:15:00 | AAPL | Stock | 11.3846 | 11.3846 | 11.3846 | 11.3846 | 2800.0 |
| 2010-12-08 07:20:00 | AAPL | Stock | 11.3846 | 11.3846 | 11.3846 | 11.3846 | 28000.0 |
| 2010-12-08 07:25:00 | AAPL | Stock | 11.3914 | 11.3914 | 11.3914 | 11.3914 | 2800.0 |
| 2010-12-08 07:35:00 | AAPL | Stock | 11.3886 | 11.3886 | 11.3886 | 11.3886 | 2800.0 |
| 2010-12-08 07:45:00 | AAPL | Stock | 11.3843 | 11.3843 | 11.3786 | 11.3786 | 37800.0 |
| 2010-12-08 08:00:00 | AAPL | Stock | 11.3882 | 11.4029 | 11.3839 | 11.4029 | 355180.0 |
| 2010-12-08 08:05:00 | AAPL | Stock | 11.4 | 11.4089 | 11.3893 | 11.4036 | 308560.0 |
| 2010-12-08 08:10:00 | AAPL | Stock | 11.4039 | 11.4039 | 11.3946 | 11.4018 | 85764.0 |
| 2010-12-08 08:15:00 | AAPL | Stock | 11.4093 | 11.4243 | 11.4093 | 11.4214 | 315980.0 |
| 2010-12-08 08:20:00 | AAPL | Stock | 11.4196 | 11.4354 | 11.4179 | 11.4354 | 371868.0 |
| 2010-12-08 08:25:00 | AAPL | Stock | 11.4311 | 11.4357 | 11.4289 | 11.4318 | 128800.0 |
| 2010-12-08 08:30:00 | AAPL | Stock | 11.4304 | 11.4304 | 11.4225 | 11.425 | 165676.0 |
| 2010-12-08 08:35:00 | AAPL | Stock | 11.4268 | 11.4361 | 11.4261 | 11.4304 | 188552.0 |
| 2010-12-08 08:40:00 | AAPL | Stock | 11.4321 | 11.4393 | 11.4286 | 11.4293 | 169512.0 |
| 2010-12-08 08:45:00 | AAPL | Stock | 11.4321 | 11.4364 | 11.4268 | 11.4286 | 282660.0 |
| 2010-12-08 08:50:00 | AAPL | Stock | 11.4289 | 11.4304 | 11.425 | 11.4254 | 54600.0 |
| 2010-12-08 08:55:00 | AAPL | Stock | 11.4243 | 11.4268 | 11.4157 | 11.4179 | 99260.0 |
| 2010-12-08 09:00:00 | AAPL | Stock | 11.4182 | 11.4196 | 11.4018 | 11.41 | 375760.0 |
| 2010-12-08 09:05:00 | AAPL | Stock | 11.4107 | 11.4275 | 11.4107 | 11.4271 | 203168.0 |
| 2010-12-08 09:10:00 | AAPL | Stock | 11.425 | 11.4293 | 11.4221 | 11.4271 | 208656.0 |
| 2010-12-08 09:15:00 | AAPL | Stock | 11.4236 | 11.4275 | 11.4182 | 11.4182 | 84868.0 |
| 2010-12-08 09:20:00 | AAPL | Stock | 11.4196 | 11.4204 | 11.415 | 11.4196 | 112560.0 |
| 2010-12-08 09:25:00 | AAPL | Stock | 11.4154 | 11.4204 | 11.4154 | 11.4179 | 69944.0 |
| 2010-12-08 09:30:00 | AAPL | Stock | 11.4189 | 11.4275 | 11.3946 | 11.4193 | 11365508.0 |
| 2010-12-08 09:35:00 | AAPL | Stock | 11.4193 | 11.4343 | 11.3857 | 11.3903 | 10044972.0 |
| 2010-12-08 09:40:00 | AAPL | Stock | 11.3891 | 11.4221 | 11.3891 | 11.4207 | 6235880.0 |
| 2010-12-08 09:45:00 | AAPL | Stock | 11.4221 | 11.4389 | 11.4129 | 11.4179 | 8194116.0 |
| 2010-12-08 09:50:00 | AAPL | Stock | 11.4188 | 11.4339 | 11.4143 | 11.4218 | 5384372.0 |
| 2010-12-08 09:55:00 | AAPL | Stock | 11.4218 | 11.4418 | 11.4136 | 11.4186 | 5844692.0 |
| 2010-12-08 10:00:00 | AAPL | Stock | 11.4211 | 11.4211 | 11.3968 | 11.4076 | 7159796.0 |
| 2010-12-08 10:05:00 | AAPL | Stock | 11.4068 | 11.42 | 11.3932 | 11.4189 | 5849060.0 |
| 2010-12-08 10:10:00 | AAPL | Stock | 11.42 | 11.42 | 11.3718 | 11.3982 | 8287496.0 |
| 2010-12-08 10:15:00 | AAPL | Stock | 11.3975 | 11.4071 | 11.3829 | 11.3836 | 4265744.0 |
| 2010-12-08 10:20:00 | AAPL | Stock | 11.383 | 11.3954 | 11.3661 | 11.3895 | 5704076.0 |
| 2010-12-08 10:25:00 | AAPL | Stock | 11.3907 | 11.3982 | 11.375 | 11.3868 | 4689244.0 |
| 2010-12-08 10:30:00 | AAPL | Stock | 11.3825 | 11.3875 | 11.3646 | 11.365 | 4497976.0 |
| 2010-12-08 10:35:00 | AAPL | Stock | 11.3675 | 11.3718 | 11.3432 | 11.3457 | 7732620.0 |
| 2010-12-08 10:40:00 | AAPL | Stock | 11.3468 | 11.3486 | 11.3254 | 11.3468 | 8714216.0 |
| 2010-12-08 10:45:00 | AAPL | Stock | 11.3454 | 11.3475 | 11.3329 | 11.3429 | 4768372.0 |
| 2010-12-08 10:50:00 | AAPL | Stock | 11.3436 | 11.3714 | 11.3375 | 11.3652 | 5294380.0 |
| 2010-12-08 10:55:00 | AAPL | Stock | 11.3652 | 11.3686 | 11.3471 | 11.3571 | 4139324.0 |
| 2010-12-08 11:00:00 | AAPL | Stock | 11.3568 | 11.3696 | 11.3557 | 11.3686 | 3064460.0 |
| 2010-12-08 11:05:00 | AAPL | Stock | 11.3687 | 11.375 | 11.3646 | 11.367 | 2833516.0 |
| 2010-12-08 11:10:00 | AAPL | Stock | 11.3661 | 11.3725 | 11.3625 | 11.3721 | 2260104.0 |
| 2010-12-08 11:15:00 | AAPL | Stock | 11.3721 | 11.3725 | 11.3546 | 11.3554 | 2994740.0 |
> showing 50 of 328,198 rows — these rows as CSV