PREVIEW / stock_5min / 2007-06-22
file: by_date/stock_5min/2007/2007-06-22.parquet size: 4.3 MB rows: 308,750 symbols: 3,031
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-06-22 09:30:00 | AAPL | Stock | 4.4232 | 4.4429 | 4.4139 | 4.4143 | 24266088.0 |
| 2007-06-22 09:35:00 | AAPL | Stock | 4.4143 | 4.425 | 4.3996 | 4.4175 | 18784864.0 |
| 2007-06-22 09:40:00 | AAPL | Stock | 4.4182 | 4.4204 | 4.4018 | 4.4111 | 11253900.0 |
| 2007-06-22 09:45:00 | AAPL | Stock | 4.4114 | 4.4232 | 4.4 | 4.4225 | 12677672.0 |
| 2007-06-22 09:50:00 | AAPL | Stock | 4.4225 | 4.4446 | 4.4182 | 4.43 | 21048580.0 |
| 2007-06-22 09:55:00 | AAPL | Stock | 4.43 | 4.4332 | 4.4236 | 4.4275 | 9980656.0 |
| 2007-06-22 10:00:00 | AAPL | Stock | 4.4275 | 4.4286 | 4.4182 | 4.4221 | 10647924.0 |
| 2007-06-22 10:05:00 | AAPL | Stock | 4.4225 | 4.4257 | 4.4121 | 4.425 | 8476748.0 |
| 2007-06-22 10:10:00 | AAPL | Stock | 4.4246 | 4.4357 | 4.4154 | 4.4332 | 12844412.0 |
| 2007-06-22 10:15:00 | AAPL | Stock | 4.4332 | 4.4446 | 4.4307 | 4.4334 | 16842224.0 |
| 2007-06-22 10:20:00 | AAPL | Stock | 4.4336 | 4.4407 | 4.4314 | 4.4339 | 6526492.0 |
| 2007-06-22 10:25:00 | AAPL | Stock | 4.4338 | 4.4364 | 4.4196 | 4.4246 | 9519776.0 |
| 2007-06-22 10:30:00 | AAPL | Stock | 4.4246 | 4.4282 | 4.4125 | 4.4275 | 11978176.0 |
| 2007-06-22 10:35:00 | AAPL | Stock | 4.4275 | 4.4357 | 4.4232 | 4.4354 | 7270284.0 |
| 2007-06-22 10:40:00 | AAPL | Stock | 4.435 | 4.4382 | 4.4268 | 4.4282 | 6885704.0 |
| 2007-06-22 10:45:00 | AAPL | Stock | 4.4286 | 4.435 | 4.4261 | 4.4286 | 7038948.0 |
| 2007-06-22 10:50:00 | AAPL | Stock | 4.4293 | 4.4318 | 4.4232 | 4.4275 | 5782028.0 |
| 2007-06-22 10:55:00 | AAPL | Stock | 4.4279 | 4.4318 | 4.4207 | 4.4229 | 7895300.0 |
| 2007-06-22 11:00:00 | AAPL | Stock | 4.4239 | 4.425 | 4.4118 | 4.415 | 10064292.0 |
| 2007-06-22 11:05:00 | AAPL | Stock | 4.4146 | 4.4168 | 4.4075 | 4.4161 | 9663248.0 |
| 2007-06-22 11:10:00 | AAPL | Stock | 4.4161 | 4.42 | 4.4139 | 4.4154 | 4032392.0 |
| 2007-06-22 11:15:00 | AAPL | Stock | 4.4154 | 4.4157 | 4.4046 | 4.4132 | 7392364.0 |
| 2007-06-22 11:20:00 | AAPL | Stock | 4.4132 | 4.4168 | 4.4107 | 4.4118 | 3885952.0 |
| 2007-06-22 11:25:00 | AAPL | Stock | 4.4121 | 4.4196 | 4.4118 | 4.4175 | 3840844.0 |
| 2007-06-22 11:30:00 | AAPL | Stock | 4.4175 | 4.425 | 4.4157 | 4.4207 | 5094432.0 |
| 2007-06-22 11:35:00 | AAPL | Stock | 4.4207 | 4.4214 | 4.4136 | 4.4189 | 3973368.0 |
| 2007-06-22 11:40:00 | AAPL | Stock | 4.4186 | 4.4186 | 4.4046 | 4.4064 | 6582464.0 |
| 2007-06-22 11:45:00 | AAPL | Stock | 4.4054 | 4.4082 | 4.3943 | 4.3982 | 11043228.0 |
| 2007-06-22 11:50:00 | AAPL | Stock | 4.3982 | 4.4032 | 4.3954 | 4.4021 | 6064436.0 |
| 2007-06-22 11:55:00 | AAPL | Stock | 4.4021 | 4.4089 | 4.3989 | 4.4068 | 5133688.0 |
| 2007-06-22 12:00:00 | AAPL | Stock | 4.4065 | 4.4107 | 4.4032 | 4.4104 | 4275516.0 |
| 2007-06-22 12:05:00 | AAPL | Stock | 4.4104 | 4.4107 | 4.3968 | 4.4007 | 4671520.0 |
| 2007-06-22 12:10:00 | AAPL | Stock | 4.4007 | 4.401 | 4.3911 | 4.3945 | 10145940.0 |
| 2007-06-22 12:15:00 | AAPL | Stock | 4.3946 | 4.4036 | 4.3939 | 4.4036 | 4534740.0 |
| 2007-06-22 12:20:00 | AAPL | Stock | 4.4035 | 4.4036 | 4.3954 | 4.4018 | 5300848.0 |
| 2007-06-22 12:25:00 | AAPL | Stock | 4.4021 | 4.4039 | 4.3961 | 4.3988 | 7106120.0 |
| 2007-06-22 12:30:00 | AAPL | Stock | 4.3986 | 4.4064 | 4.3936 | 4.3993 | 9957388.0 |
| 2007-06-22 12:35:00 | AAPL | Stock | 4.3993 | 4.4007 | 4.3879 | 4.3882 | 11076576.0 |
| 2007-06-22 12:40:00 | AAPL | Stock | 4.3882 | 4.3979 | 4.3793 | 4.3964 | 10257576.0 |
| 2007-06-22 12:45:00 | AAPL | Stock | 4.3961 | 4.3979 | 4.3882 | 4.3929 | 5223792.0 |
| 2007-06-22 12:50:00 | AAPL | Stock | 4.3932 | 4.4007 | 4.3911 | 4.3929 | 6141016.0 |
| 2007-06-22 12:55:00 | AAPL | Stock | 4.3921 | 4.3989 | 4.3918 | 4.3982 | 3825444.0 |
| 2007-06-22 13:00:00 | AAPL | Stock | 4.3979 | 4.4007 | 4.3871 | 4.3886 | 7620256.0 |
| 2007-06-22 13:05:00 | AAPL | Stock | 4.3882 | 4.3882 | 4.375 | 4.3789 | 11834284.0 |
| 2007-06-22 13:10:00 | AAPL | Stock | 4.3789 | 4.3871 | 4.3707 | 4.3736 | 8481480.0 |
| 2007-06-22 13:15:00 | AAPL | Stock | 4.3736 | 4.3868 | 4.3736 | 4.3804 | 7683144.0 |
| 2007-06-22 13:20:00 | AAPL | Stock | 4.3807 | 4.3925 | 4.3768 | 4.3914 | 6193628.0 |
| 2007-06-22 13:25:00 | AAPL | Stock | 4.3921 | 4.4 | 4.3868 | 4.3918 | 8196440.0 |
| 2007-06-22 13:30:00 | AAPL | Stock | 4.3923 | 4.3932 | 4.3843 | 4.3893 | 5731488.0 |
| 2007-06-22 13:35:00 | AAPL | Stock | 4.3893 | 4.3914 | 4.3879 | 4.3914 | 2575132.0 |
> showing 50 of 308,750 rows — these rows as CSV