PREVIEW / stock_5min / 2006-08-22
file: by_date/stock_5min/2006/2006-08-22.parquet size: 3.0 MB rows: 219,580 symbols: 2,339
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-22 08:00:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3732 | 2.3732 | 28000.0 |
| 2006-08-22 08:05:00 | AAPL | Stock | 2.3661 | 2.3721 | 2.3661 | 2.3721 | 70000.0 |
| 2006-08-22 08:10:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3696 | 2.3714 | 65520.0 |
| 2006-08-22 08:15:00 | AAPL | Stock | 2.3718 | 2.3718 | 2.3714 | 2.3714 | 95200.0 |
| 2006-08-22 08:20:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3714 | 2.3714 | 14000.0 |
| 2006-08-22 08:25:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3732 | 2.3732 | 10780.0 |
| 2006-08-22 08:30:00 | AAPL | Stock | 2.3732 | 2.3768 | 2.3732 | 2.3768 | 126308.0 |
| 2006-08-22 08:35:00 | AAPL | Stock | 2.3779 | 2.3779 | 2.3768 | 2.3779 | 39480.0 |
| 2006-08-22 08:40:00 | AAPL | Stock | 2.3775 | 2.3775 | 2.3768 | 2.3768 | 60816.0 |
| 2006-08-22 08:50:00 | AAPL | Stock | 2.3779 | 2.3786 | 2.3779 | 2.3786 | 88704.0 |
| 2006-08-22 08:55:00 | AAPL | Stock | 2.3818 | 2.3843 | 2.3818 | 2.3829 | 79800.0 |
| 2006-08-22 09:00:00 | AAPL | Stock | 2.3839 | 2.3854 | 2.3821 | 2.3821 | 106400.0 |
| 2006-08-22 09:05:00 | AAPL | Stock | 2.38 | 2.3804 | 2.3793 | 2.3793 | 30800.0 |
| 2006-08-22 09:10:00 | AAPL | Stock | 2.3786 | 2.3804 | 2.3786 | 2.3804 | 30800.0 |
| 2006-08-22 09:20:00 | AAPL | Stock | 2.3814 | 2.3821 | 2.3814 | 2.3821 | 84000.0 |
| 2006-08-22 09:25:00 | AAPL | Stock | 2.3821 | 2.3821 | 2.375 | 2.3804 | 266336.0 |
| 2006-08-22 09:30:00 | AAPL | Stock | 2.3814 | 2.3925 | 2.375 | 2.3914 | 14046592.0 |
| 2006-08-22 09:35:00 | AAPL | Stock | 2.3914 | 2.4 | 2.3911 | 2.3979 | 15103284.0 |
| 2006-08-22 09:40:00 | AAPL | Stock | 2.3979 | 2.4018 | 2.3914 | 2.4007 | 13229020.0 |
| 2006-08-22 09:45:00 | AAPL | Stock | 2.4004 | 2.4061 | 2.3982 | 2.4 | 12207664.0 |
| 2006-08-22 09:50:00 | AAPL | Stock | 2.4004 | 2.4054 | 2.3954 | 2.3989 | 11677540.0 |
| 2006-08-22 09:55:00 | AAPL | Stock | 2.3989 | 2.4025 | 2.3954 | 2.3996 | 7503916.0 |
| 2006-08-22 10:00:00 | AAPL | Stock | 2.3996 | 2.405 | 2.3982 | 2.4032 | 8632736.0 |
| 2006-08-22 10:05:00 | AAPL | Stock | 2.4029 | 2.4032 | 2.3971 | 2.4007 | 6211520.0 |
| 2006-08-22 10:10:00 | AAPL | Stock | 2.4011 | 2.4093 | 2.4 | 2.4064 | 11734800.0 |
| 2006-08-22 10:15:00 | AAPL | Stock | 2.4064 | 2.4089 | 2.4036 | 2.4064 | 7873012.0 |
| 2006-08-22 10:20:00 | AAPL | Stock | 2.4064 | 2.4179 | 2.4064 | 2.4164 | 15288140.0 |
| 2006-08-22 10:25:00 | AAPL | Stock | 2.4164 | 2.4229 | 2.4143 | 2.4193 | 14541828.0 |
| 2006-08-22 10:30:00 | AAPL | Stock | 2.4193 | 2.4211 | 2.4164 | 2.4168 | 9503844.0 |
| 2006-08-22 10:35:00 | AAPL | Stock | 2.4164 | 2.4246 | 2.4164 | 2.4211 | 15311548.0 |
| 2006-08-22 10:40:00 | AAPL | Stock | 2.4207 | 2.4254 | 2.4175 | 2.4196 | 10436076.0 |
| 2006-08-22 10:45:00 | AAPL | Stock | 2.4193 | 2.4214 | 2.4164 | 2.42 | 6876660.0 |
| 2006-08-22 10:50:00 | AAPL | Stock | 2.4196 | 2.4214 | 2.4168 | 2.4214 | 7424396.0 |
| 2006-08-22 10:55:00 | AAPL | Stock | 2.4214 | 2.4243 | 2.4179 | 2.4207 | 7108388.0 |
| 2006-08-22 11:00:00 | AAPL | Stock | 2.4207 | 2.4207 | 2.4179 | 2.4189 | 4563580.0 |
| 2006-08-22 11:05:00 | AAPL | Stock | 2.4186 | 2.4193 | 2.4143 | 2.4161 | 6522432.0 |
| 2006-08-22 11:10:00 | AAPL | Stock | 2.4164 | 2.4204 | 2.4161 | 2.4186 | 3589376.0 |
| 2006-08-22 11:15:00 | AAPL | Stock | 2.4186 | 2.4214 | 2.4186 | 2.4211 | 2930816.0 |
| 2006-08-22 11:20:00 | AAPL | Stock | 2.4211 | 2.4279 | 2.4204 | 2.4243 | 9536968.0 |
| 2006-08-22 11:25:00 | AAPL | Stock | 2.4243 | 2.435 | 2.4236 | 2.4332 | 14190708.0 |
| 2006-08-22 11:30:00 | AAPL | Stock | 2.4332 | 2.4379 | 2.4325 | 2.4329 | 10993332.0 |
| 2006-08-22 11:35:00 | AAPL | Stock | 2.4332 | 2.44 | 2.4325 | 2.4382 | 9958900.0 |
| 2006-08-22 11:40:00 | AAPL | Stock | 2.4375 | 2.4393 | 2.4332 | 2.4343 | 7095088.0 |
| 2006-08-22 11:45:00 | AAPL | Stock | 2.4343 | 2.4354 | 2.4325 | 2.4343 | 3858932.0 |
| 2006-08-22 11:50:00 | AAPL | Stock | 2.4343 | 2.4364 | 2.4321 | 2.4361 | 4470788.0 |
| 2006-08-22 11:55:00 | AAPL | Stock | 2.4364 | 2.4382 | 2.4357 | 2.4361 | 4340616.0 |
| 2006-08-22 12:00:00 | AAPL | Stock | 2.4361 | 2.4368 | 2.4314 | 2.4318 | 4489968.0 |
| 2006-08-22 12:05:00 | AAPL | Stock | 2.4317 | 2.4332 | 2.4225 | 2.4264 | 11656540.0 |
| 2006-08-22 12:10:00 | AAPL | Stock | 2.4271 | 2.4304 | 2.4246 | 2.43 | 5774328.0 |
| 2006-08-22 12:15:00 | AAPL | Stock | 2.4304 | 2.4318 | 2.4282 | 2.4304 | 3974376.0 |
> showing 50 of 219,580 rows — these rows as CSV