PREVIEW / stock_5min / 2011-12-29
file: by_date/stock_5min/2011/2011-12-29.parquet size: 4.6 MB rows: 316,681 symbols: 3,564
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-29 06:45:00 | AAPL | Stock | 14.3707 | 14.3707 | 14.3696 | 14.3696 | 16800.0 |
| 2011-12-29 06:55:00 | AAPL | Stock | 14.3696 | 14.375 | 14.3696 | 14.375 | 18200.0 |
| 2011-12-29 07:00:00 | AAPL | Stock | 14.3821 | 14.3893 | 14.3821 | 14.3893 | 39200.0 |
| 2011-12-29 07:10:00 | AAPL | Stock | 14.3954 | 14.4018 | 14.3929 | 14.3954 | 59892.0 |
| 2011-12-29 07:15:00 | AAPL | Stock | 14.3954 | 14.3954 | 14.3954 | 14.3954 | 2800.0 |
| 2011-12-29 07:20:00 | AAPL | Stock | 14.4 | 14.4 | 14.4 | 14.4 | 6300.0 |
| 2011-12-29 07:25:00 | AAPL | Stock | 14.4036 | 14.4039 | 14.4036 | 14.4039 | 8400.0 |
| 2011-12-29 07:30:00 | AAPL | Stock | 14.4107 | 14.42 | 14.4107 | 14.42 | 8400.0 |
| 2011-12-29 07:35:00 | AAPL | Stock | 14.4196 | 14.4346 | 14.4196 | 14.4343 | 22960.0 |
| 2011-12-29 07:40:00 | AAPL | Stock | 14.4286 | 14.4293 | 14.4286 | 14.4293 | 19600.0 |
| 2011-12-29 07:45:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 13860.0 |
| 2011-12-29 07:50:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.425 | 14.425 | 8400.0 |
| 2011-12-29 07:55:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4282 | 14.4282 | 8400.0 |
| 2011-12-29 08:00:00 | AAPL | Stock | 14.4125 | 14.4307 | 14.4125 | 14.425 | 69832.0 |
| 2011-12-29 08:05:00 | AAPL | Stock | 14.4286 | 14.4454 | 14.4282 | 14.4454 | 69720.0 |
| 2011-12-29 08:10:00 | AAPL | Stock | 14.445 | 14.4464 | 14.4357 | 14.4446 | 92260.0 |
| 2011-12-29 08:15:00 | AAPL | Stock | 14.4375 | 14.4464 | 14.4375 | 14.4457 | 125132.0 |
| 2011-12-29 08:20:00 | AAPL | Stock | 14.4457 | 14.4464 | 14.4321 | 14.4321 | 141232.0 |
| 2011-12-29 08:25:00 | AAPL | Stock | 14.4321 | 14.4429 | 14.4321 | 14.4429 | 70812.0 |
| 2011-12-29 08:30:00 | AAPL | Stock | 14.4289 | 14.4289 | 14.415 | 14.4157 | 16268.0 |
| 2011-12-29 08:35:00 | AAPL | Stock | 14.4143 | 14.4211 | 14.4107 | 14.4211 | 29652.0 |
| 2011-12-29 08:40:00 | AAPL | Stock | 14.4211 | 14.4211 | 14.4114 | 14.4114 | 19180.0 |
| 2011-12-29 08:45:00 | AAPL | Stock | 14.4125 | 14.4171 | 14.4029 | 14.4036 | 136528.0 |
| 2011-12-29 08:50:00 | AAPL | Stock | 14.4039 | 14.4107 | 14.3943 | 14.3946 | 66920.0 |
| 2011-12-29 08:55:00 | AAPL | Stock | 14.4104 | 14.4175 | 14.4054 | 14.4175 | 48468.0 |
| 2011-12-29 09:00:00 | AAPL | Stock | 14.4111 | 14.4111 | 14.4107 | 14.4107 | 44800.0 |
| 2011-12-29 09:05:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4104 | 14.4107 | 54628.0 |
| 2011-12-29 09:10:00 | AAPL | Stock | 14.4114 | 14.415 | 14.4107 | 14.415 | 36120.0 |
| 2011-12-29 09:15:00 | AAPL | Stock | 14.4196 | 14.4214 | 14.4118 | 14.4118 | 53844.0 |
| 2011-12-29 09:20:00 | AAPL | Stock | 14.4179 | 14.4214 | 14.4118 | 14.4214 | 57540.0 |
| 2011-12-29 09:25:00 | AAPL | Stock | 14.4157 | 14.4164 | 14.4054 | 14.4071 | 391048.0 |
| 2011-12-29 09:30:00 | AAPL | Stock | 14.4071 | 14.4393 | 14.3804 | 14.4004 | 8736588.0 |
| 2011-12-29 09:35:00 | AAPL | Stock | 14.4 | 14.4054 | 14.3689 | 14.3771 | 5687388.0 |
| 2011-12-29 09:40:00 | AAPL | Stock | 14.3789 | 14.3996 | 14.3729 | 14.3879 | 5290964.0 |
| 2011-12-29 09:45:00 | AAPL | Stock | 14.3875 | 14.3959 | 14.3471 | 14.3543 | 4915316.0 |
| 2011-12-29 09:50:00 | AAPL | Stock | 14.3518 | 14.3807 | 14.3514 | 14.3754 | 3890124.0 |
| 2011-12-29 09:55:00 | AAPL | Stock | 14.3771 | 14.3793 | 14.3593 | 14.3607 | 3252060.0 |
| 2011-12-29 10:00:00 | AAPL | Stock | 14.3646 | 14.3681 | 14.3114 | 14.3203 | 7245644.0 |
| 2011-12-29 10:05:00 | AAPL | Stock | 14.3214 | 14.3404 | 14.3039 | 14.3387 | 7902972.0 |
| 2011-12-29 10:10:00 | AAPL | Stock | 14.3364 | 14.3654 | 14.3364 | 14.3543 | 5146148.0 |
| 2011-12-29 10:15:00 | AAPL | Stock | 14.353 | 14.3568 | 14.3386 | 14.3411 | 2024428.0 |
| 2011-12-29 10:20:00 | AAPL | Stock | 14.3407 | 14.3564 | 14.3321 | 14.355 | 1936312.0 |
| 2011-12-29 10:25:00 | AAPL | Stock | 14.3546 | 14.3961 | 14.3529 | 14.3849 | 7282520.0 |
| 2011-12-29 10:30:00 | AAPL | Stock | 14.3823 | 14.3975 | 14.3821 | 14.3907 | 3328360.0 |
| 2011-12-29 10:35:00 | AAPL | Stock | 14.3918 | 14.3993 | 14.3761 | 14.3804 | 3536064.0 |
| 2011-12-29 10:40:00 | AAPL | Stock | 14.3814 | 14.3839 | 14.3643 | 14.3777 | 2401364.0 |
| 2011-12-29 10:45:00 | AAPL | Stock | 14.3782 | 14.3929 | 14.3739 | 14.3929 | 1429876.0 |
| 2011-12-29 10:50:00 | AAPL | Stock | 14.3918 | 14.3946 | 14.3793 | 14.39 | 1141476.0 |
| 2011-12-29 10:55:00 | AAPL | Stock | 14.39 | 14.3936 | 14.3804 | 14.3904 | 1712592.0 |
| 2011-12-29 11:00:00 | AAPL | Stock | 14.39 | 14.3931 | 14.3829 | 14.3864 | 1613164.0 |
> showing 50 of 316,681 rows — these rows as CSV