PREVIEW / stock_5min / 2002-01-28
file: by_date/stock_5min/2002/2002-01-28.parquet size: 1.6 MB rows: 114,747 symbols: 1,348
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-28 08:30:00 | AAPL | Stock | 0.4157 | 0.4157 | 0.4157 | 0.4157 | 67200.0 |
| 2002-01-28 08:35:00 | AAPL | Stock | 0.4195 | 0.4195 | 0.4195 | 0.4195 | 5600.0 |
| 2002-01-28 08:45:00 | AAPL | Stock | 0.4188 | 0.4188 | 0.4188 | 0.4188 | 28000.0 |
| 2002-01-28 09:10:00 | AAPL | Stock | 0.4175 | 0.4177 | 0.4175 | 0.4177 | 44800.0 |
| 2002-01-28 09:20:00 | AAPL | Stock | 0.4154 | 0.4154 | 0.4154 | 0.4154 | 44800.0 |
| 2002-01-28 09:25:00 | AAPL | Stock | 0.4173 | 0.4179 | 0.417 | 0.4175 | 128800.0 |
| 2002-01-28 09:30:00 | AAPL | Stock | 0.4179 | 0.4186 | 0.4154 | 0.4163 | 4261600.0 |
| 2002-01-28 09:35:00 | AAPL | Stock | 0.4163 | 0.4196 | 0.4161 | 0.4196 | 3035200.0 |
| 2002-01-28 09:40:00 | AAPL | Stock | 0.4197 | 0.4205 | 0.4179 | 0.4179 | 4373600.0 |
| 2002-01-28 09:45:00 | AAPL | Stock | 0.4179 | 0.4194 | 0.4175 | 0.4189 | 1769600.0 |
| 2002-01-28 09:50:00 | AAPL | Stock | 0.4193 | 0.4193 | 0.4166 | 0.4166 | 2576000.0 |
| 2002-01-28 09:55:00 | AAPL | Stock | 0.4173 | 0.4193 | 0.4168 | 0.4191 | 1523200.0 |
| 2002-01-28 10:00:00 | AAPL | Stock | 0.4193 | 0.4193 | 0.4154 | 0.4166 | 3427200.0 |
| 2002-01-28 10:05:00 | AAPL | Stock | 0.4161 | 0.4166 | 0.4161 | 0.4164 | 812000.0 |
| 2002-01-28 10:10:00 | AAPL | Stock | 0.4161 | 0.4166 | 0.4132 | 0.4139 | 2245600.0 |
| 2002-01-28 10:15:00 | AAPL | Stock | 0.4138 | 0.4146 | 0.4138 | 0.4145 | 1999200.0 |
| 2002-01-28 10:20:00 | AAPL | Stock | 0.4145 | 0.4152 | 0.4138 | 0.4148 | 1086400.0 |
| 2002-01-28 10:25:00 | AAPL | Stock | 0.4146 | 0.4152 | 0.413 | 0.4138 | 1601600.0 |
| 2002-01-28 10:30:00 | AAPL | Stock | 0.4134 | 0.4139 | 0.4127 | 0.4139 | 1131200.0 |
| 2002-01-28 10:35:00 | AAPL | Stock | 0.4139 | 0.4159 | 0.4138 | 0.4159 | 4300800.0 |
| 2002-01-28 10:40:00 | AAPL | Stock | 0.4155 | 0.4171 | 0.4155 | 0.4161 | 1948800.0 |
| 2002-01-28 10:45:00 | AAPL | Stock | 0.4164 | 0.4168 | 0.4161 | 0.4168 | 3869600.0 |
| 2002-01-28 10:50:00 | AAPL | Stock | 0.4166 | 0.4173 | 0.4163 | 0.4168 | 2150400.0 |
| 2002-01-28 10:55:00 | AAPL | Stock | 0.4173 | 0.4188 | 0.4166 | 0.4188 | 3208800.0 |
| 2002-01-28 11:00:00 | AAPL | Stock | 0.4186 | 0.4191 | 0.4179 | 0.4188 | 1747200.0 |
| 2002-01-28 11:05:00 | AAPL | Stock | 0.4186 | 0.4191 | 0.4173 | 0.4173 | 1579200.0 |
| 2002-01-28 11:10:00 | AAPL | Stock | 0.4179 | 0.4184 | 0.4175 | 0.4184 | 666400.0 |
| 2002-01-28 11:15:00 | AAPL | Stock | 0.4177 | 0.4182 | 0.4171 | 0.4175 | 840000.0 |
| 2002-01-28 11:20:00 | AAPL | Stock | 0.4176 | 0.4177 | 0.4171 | 0.4173 | 694400.0 |
| 2002-01-28 11:25:00 | AAPL | Stock | 0.4173 | 0.4191 | 0.4166 | 0.4189 | 1495200.0 |
| 2002-01-28 11:30:00 | AAPL | Stock | 0.4189 | 0.4191 | 0.4182 | 0.4189 | 672000.0 |
| 2002-01-28 11:35:00 | AAPL | Stock | 0.4182 | 0.4191 | 0.4179 | 0.4179 | 1993600.0 |
| 2002-01-28 11:40:00 | AAPL | Stock | 0.4177 | 0.4184 | 0.4173 | 0.4175 | 1943200.0 |
| 2002-01-28 11:45:00 | AAPL | Stock | 0.4179 | 0.4182 | 0.4164 | 0.417 | 5336800.0 |
| 2002-01-28 11:50:00 | AAPL | Stock | 0.4171 | 0.4179 | 0.4168 | 0.4173 | 453600.0 |
| 2002-01-28 11:55:00 | AAPL | Stock | 0.4179 | 0.4179 | 0.4129 | 0.4129 | 6529600.0 |
| 2002-01-28 12:00:00 | AAPL | Stock | 0.4129 | 0.4143 | 0.4105 | 0.4109 | 6815200.0 |
| 2002-01-28 12:05:00 | AAPL | Stock | 0.4111 | 0.4111 | 0.408 | 0.4102 | 6316800.0 |
| 2002-01-28 12:10:00 | AAPL | Stock | 0.4102 | 0.4116 | 0.4096 | 0.4113 | 3438400.0 |
| 2002-01-28 12:15:00 | AAPL | Stock | 0.4116 | 0.4121 | 0.4071 | 0.4077 | 10309600.0 |
| 2002-01-28 12:20:00 | AAPL | Stock | 0.4077 | 0.4089 | 0.4057 | 0.4082 | 4418400.0 |
| 2002-01-28 12:25:00 | AAPL | Stock | 0.4089 | 0.4091 | 0.408 | 0.4089 | 1808800.0 |
| 2002-01-28 12:30:00 | AAPL | Stock | 0.4093 | 0.4116 | 0.4089 | 0.4111 | 3063200.0 |
| 2002-01-28 12:35:00 | AAPL | Stock | 0.4111 | 0.4116 | 0.4107 | 0.4116 | 2637600.0 |
| 2002-01-28 12:40:00 | AAPL | Stock | 0.4114 | 0.4118 | 0.4113 | 0.4118 | 1797600.0 |
| 2002-01-28 12:45:00 | AAPL | Stock | 0.412 | 0.412 | 0.4111 | 0.4114 | 4267200.0 |
| 2002-01-28 12:50:00 | AAPL | Stock | 0.4109 | 0.4113 | 0.4107 | 0.4113 | 845600.0 |
| 2002-01-28 12:55:00 | AAPL | Stock | 0.4111 | 0.4113 | 0.4104 | 0.4105 | 1422400.0 |
| 2002-01-28 13:00:00 | AAPL | Stock | 0.4104 | 0.4105 | 0.4073 | 0.4086 | 1831200.0 |
| 2002-01-28 13:05:00 | AAPL | Stock | 0.4089 | 0.4093 | 0.4084 | 0.4089 | 1422400.0 |
> showing 50 of 114,747 rows — these rows as CSV