PREVIEW / stock_5min / 2008-06-20
file: by_date/stock_5min/2008/2008-06-20.parquet size: 4.6 MB rows: 326,327 symbols: 3,325
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-20 06:05:00 | AAPL | Stock | 6.4839 | 6.4839 | 6.4839 | 6.4839 | 5040.0 |
| 2008-06-20 06:15:00 | AAPL | Stock | 6.4779 | 6.4779 | 6.4779 | 6.4779 | 14000.0 |
| 2008-06-20 06:35:00 | AAPL | Stock | 6.4814 | 6.4814 | 6.4786 | 6.4786 | 11480.0 |
| 2008-06-20 06:40:00 | AAPL | Stock | 6.4693 | 6.4693 | 6.4693 | 6.4693 | 2800.0 |
| 2008-06-20 06:50:00 | AAPL | Stock | 6.4693 | 6.4693 | 6.4643 | 6.4643 | 14000.0 |
| 2008-06-20 07:00:00 | AAPL | Stock | 6.4536 | 6.4536 | 6.4536 | 6.4536 | 15400.0 |
| 2008-06-20 07:10:00 | AAPL | Stock | 6.4339 | 6.4339 | 6.4339 | 6.4339 | 5600.0 |
| 2008-06-20 07:15:00 | AAPL | Stock | 6.4343 | 6.4429 | 6.4343 | 6.4375 | 56000.0 |
| 2008-06-20 07:20:00 | AAPL | Stock | 6.4332 | 6.4332 | 6.4332 | 6.4332 | 2800.0 |
| 2008-06-20 07:25:00 | AAPL | Stock | 6.4361 | 6.4361 | 6.4304 | 6.4304 | 39200.0 |
| 2008-06-20 07:30:00 | AAPL | Stock | 6.4286 | 6.4318 | 6.4214 | 6.4304 | 27916.0 |
| 2008-06-20 07:35:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.3929 | 6.4036 | 294448.0 |
| 2008-06-20 07:45:00 | AAPL | Stock | 6.4243 | 6.4257 | 6.4107 | 6.4107 | 136360.0 |
| 2008-06-20 07:50:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 19600.0 |
| 2008-06-20 08:00:00 | AAPL | Stock | 6.4232 | 6.4257 | 6.4039 | 6.4154 | 145992.0 |
| 2008-06-20 08:05:00 | AAPL | Stock | 6.4107 | 6.4143 | 6.4054 | 6.4107 | 213584.0 |
| 2008-06-20 08:10:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4054 | 6.4071 | 99456.0 |
| 2008-06-20 08:15:00 | AAPL | Stock | 6.4046 | 6.4107 | 6.4046 | 6.4071 | 112000.0 |
| 2008-06-20 08:20:00 | AAPL | Stock | 6.4082 | 6.4204 | 6.4082 | 6.4146 | 131152.0 |
| 2008-06-20 08:25:00 | AAPL | Stock | 6.4143 | 6.4196 | 6.4079 | 6.4196 | 214480.0 |
| 2008-06-20 08:30:00 | AAPL | Stock | 6.4196 | 6.4221 | 6.4179 | 6.4179 | 366520.0 |
| 2008-06-20 08:35:00 | AAPL | Stock | 6.4175 | 6.4189 | 6.4104 | 6.4111 | 281176.0 |
| 2008-06-20 08:40:00 | AAPL | Stock | 6.4118 | 6.4154 | 6.4107 | 6.4107 | 92680.0 |
| 2008-06-20 08:45:00 | AAPL | Stock | 6.4107 | 6.4207 | 6.4107 | 6.4207 | 61684.0 |
| 2008-06-20 08:50:00 | AAPL | Stock | 6.4207 | 6.4207 | 6.4161 | 6.4164 | 33600.0 |
| 2008-06-20 08:55:00 | AAPL | Stock | 6.4171 | 6.4179 | 6.4164 | 6.4168 | 75600.0 |
| 2008-06-20 09:00:00 | AAPL | Stock | 6.4164 | 6.4182 | 6.4143 | 6.4143 | 181300.0 |
| 2008-06-20 09:05:00 | AAPL | Stock | 6.4146 | 6.4161 | 6.3929 | 6.4018 | 445816.0 |
| 2008-06-20 09:10:00 | AAPL | Stock | 6.405 | 6.4132 | 6.4007 | 6.4132 | 89600.0 |
| 2008-06-20 09:15:00 | AAPL | Stock | 6.4139 | 6.4143 | 6.4111 | 6.4125 | 39200.0 |
| 2008-06-20 09:20:00 | AAPL | Stock | 6.4111 | 6.4111 | 6.3979 | 6.4086 | 196560.0 |
| 2008-06-20 09:25:00 | AAPL | Stock | 6.4086 | 6.4086 | 6.3932 | 6.4004 | 529508.0 |
| 2008-06-20 09:30:00 | AAPL | Stock | 6.4004 | 6.4643 | 6.3861 | 6.4057 | 88886672.0 |
| 2008-06-20 09:35:00 | AAPL | Stock | 6.4057 | 6.4232 | 6.3943 | 6.4017 | 17651340.0 |
| 2008-06-20 09:40:00 | AAPL | Stock | 6.4011 | 6.4643 | 6.3607 | 6.3832 | 19773432.0 |
| 2008-06-20 09:45:00 | AAPL | Stock | 6.384 | 6.4068 | 6.375 | 6.3832 | 15584408.0 |
| 2008-06-20 09:50:00 | AAPL | Stock | 6.3832 | 6.3929 | 6.375 | 6.3871 | 10207428.0 |
| 2008-06-20 09:55:00 | AAPL | Stock | 6.3879 | 6.3971 | 6.3571 | 6.3679 | 14997332.0 |
| 2008-06-20 10:00:00 | AAPL | Stock | 6.3686 | 6.3736 | 6.3389 | 6.3393 | 17544716.0 |
| 2008-06-20 10:05:00 | AAPL | Stock | 6.3396 | 6.3625 | 6.3346 | 6.3518 | 19055092.0 |
| 2008-06-20 10:10:00 | AAPL | Stock | 6.3514 | 6.3679 | 6.3486 | 6.3671 | 8813196.0 |
| 2008-06-20 10:15:00 | AAPL | Stock | 6.3675 | 6.3725 | 6.3607 | 6.3657 | 5825316.0 |
| 2008-06-20 10:20:00 | AAPL | Stock | 6.3657 | 6.3675 | 6.35 | 6.3593 | 9275224.0 |
| 2008-06-20 10:25:00 | AAPL | Stock | 6.3593 | 6.3786 | 6.3525 | 6.3779 | 10604160.0 |
| 2008-06-20 10:30:00 | AAPL | Stock | 6.3782 | 6.3786 | 6.3464 | 6.3475 | 10677296.0 |
| 2008-06-20 10:35:00 | AAPL | Stock | 6.3475 | 6.3564 | 6.3143 | 6.3254 | 18509708.0 |
| 2008-06-20 10:40:00 | AAPL | Stock | 6.3268 | 6.3343 | 6.315 | 6.3186 | 14422688.0 |
| 2008-06-20 10:45:00 | AAPL | Stock | 6.3182 | 6.3389 | 6.3164 | 6.335 | 8224524.0 |
| 2008-06-20 10:50:00 | AAPL | Stock | 6.3354 | 6.3568 | 6.3219 | 6.3418 | 8598156.0 |
| 2008-06-20 10:55:00 | AAPL | Stock | 6.3425 | 6.3579 | 6.3407 | 6.3479 | 7561148.0 |
> showing 50 of 326,327 rows — these rows as CSV