PREVIEW / stock_5min / 2002-02-19
file: by_date/stock_5min/2002/2002-02-19.parquet size: 1.7 MB rows: 117,709 symbols: 1,405
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-02-19 08:05:00 | AAPL | Stock | 0.4263 | 0.4263 | 0.4263 | 0.4263 | 5600.0 |
| 2002-02-19 08:25:00 | AAPL | Stock | 0.4241 | 0.425 | 0.4241 | 0.4241 | 84000.0 |
| 2002-02-19 08:30:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4255 | 0.4259 | 212800.0 |
| 2002-02-19 08:55:00 | AAPL | Stock | 0.4241 | 0.4245 | 0.4232 | 0.4232 | 61600.0 |
| 2002-02-19 09:10:00 | AAPL | Stock | 0.4241 | 0.4259 | 0.4241 | 0.4259 | 33600.0 |
| 2002-02-19 09:25:00 | AAPL | Stock | 0.4252 | 0.4252 | 0.4246 | 0.4246 | 694400.0 |
| 2002-02-19 09:30:00 | AAPL | Stock | 0.4243 | 0.4266 | 0.4241 | 0.4243 | 5824000.0 |
| 2002-02-19 09:35:00 | AAPL | Stock | 0.4248 | 0.425 | 0.4227 | 0.4248 | 5465600.0 |
| 2002-02-19 09:40:00 | AAPL | Stock | 0.4246 | 0.4268 | 0.4243 | 0.425 | 3388000.0 |
| 2002-02-19 09:45:00 | AAPL | Stock | 0.425 | 0.4254 | 0.4234 | 0.4241 | 7257600.0 |
| 2002-02-19 09:50:00 | AAPL | Stock | 0.4243 | 0.4246 | 0.4223 | 0.4227 | 11082400.0 |
| 2002-02-19 09:55:00 | AAPL | Stock | 0.4229 | 0.4243 | 0.4221 | 0.4232 | 3628800.0 |
| 2002-02-19 10:00:00 | AAPL | Stock | 0.4232 | 0.4241 | 0.422 | 0.423 | 3444000.0 |
| 2002-02-19 10:05:00 | AAPL | Stock | 0.423 | 0.4241 | 0.4229 | 0.4241 | 2940000.0 |
| 2002-02-19 10:10:00 | AAPL | Stock | 0.4237 | 0.4241 | 0.4225 | 0.4239 | 1993600.0 |
| 2002-02-19 10:15:00 | AAPL | Stock | 0.4234 | 0.4239 | 0.4225 | 0.4238 | 3001600.0 |
| 2002-02-19 10:20:00 | AAPL | Stock | 0.4238 | 0.4239 | 0.423 | 0.4234 | 3505600.0 |
| 2002-02-19 10:25:00 | AAPL | Stock | 0.4232 | 0.4239 | 0.4216 | 0.4229 | 4541600.0 |
| 2002-02-19 10:30:00 | AAPL | Stock | 0.4229 | 0.4241 | 0.4218 | 0.4238 | 4804800.0 |
| 2002-02-19 10:35:00 | AAPL | Stock | 0.4234 | 0.4238 | 0.4218 | 0.4223 | 8092000.0 |
| 2002-02-19 10:40:00 | AAPL | Stock | 0.4221 | 0.4223 | 0.4173 | 0.4179 | 6384000.0 |
| 2002-02-19 10:45:00 | AAPL | Stock | 0.4173 | 0.4186 | 0.4168 | 0.4179 | 4463200.0 |
| 2002-02-19 10:50:00 | AAPL | Stock | 0.4177 | 0.4179 | 0.4164 | 0.4164 | 6059200.0 |
| 2002-02-19 10:55:00 | AAPL | Stock | 0.4166 | 0.4186 | 0.4161 | 0.4184 | 6384000.0 |
| 2002-02-19 11:00:00 | AAPL | Stock | 0.4188 | 0.4191 | 0.418 | 0.4189 | 2531200.0 |
| 2002-02-19 11:05:00 | AAPL | Stock | 0.4189 | 0.4196 | 0.4175 | 0.4194 | 7246400.0 |
| 2002-02-19 11:10:00 | AAPL | Stock | 0.4193 | 0.4196 | 0.4188 | 0.4189 | 1215200.0 |
| 2002-02-19 11:15:00 | AAPL | Stock | 0.4189 | 0.4195 | 0.4179 | 0.4184 | 1859200.0 |
| 2002-02-19 11:20:00 | AAPL | Stock | 0.4188 | 0.4193 | 0.4179 | 0.4189 | 2716000.0 |
| 2002-02-19 11:25:00 | AAPL | Stock | 0.4191 | 0.4207 | 0.4191 | 0.4196 | 1657600.0 |
| 2002-02-19 11:30:00 | AAPL | Stock | 0.4198 | 0.42 | 0.4189 | 0.4191 | 912800.0 |
| 2002-02-19 11:35:00 | AAPL | Stock | 0.4191 | 0.4205 | 0.4189 | 0.4204 | 2396800.0 |
| 2002-02-19 11:40:00 | AAPL | Stock | 0.4203 | 0.4241 | 0.4196 | 0.4209 | 8108800.0 |
| 2002-02-19 11:45:00 | AAPL | Stock | 0.4211 | 0.4232 | 0.4211 | 0.4215 | 2044000.0 |
| 2002-02-19 11:50:00 | AAPL | Stock | 0.422 | 0.4227 | 0.4214 | 0.4221 | 2296000.0 |
| 2002-02-19 11:55:00 | AAPL | Stock | 0.4221 | 0.4236 | 0.4214 | 0.4236 | 2542400.0 |
| 2002-02-19 12:00:00 | AAPL | Stock | 0.4236 | 0.4252 | 0.423 | 0.4241 | 4317600.0 |
| 2002-02-19 12:05:00 | AAPL | Stock | 0.4243 | 0.4248 | 0.4241 | 0.4243 | 800800.0 |
| 2002-02-19 12:10:00 | AAPL | Stock | 0.4241 | 0.4248 | 0.4234 | 0.4248 | 2324000.0 |
| 2002-02-19 12:15:00 | AAPL | Stock | 0.4234 | 0.4239 | 0.422 | 0.422 | 3399200.0 |
| 2002-02-19 12:20:00 | AAPL | Stock | 0.4229 | 0.4234 | 0.4221 | 0.4225 | 1646400.0 |
| 2002-02-19 12:25:00 | AAPL | Stock | 0.4227 | 0.4229 | 0.4218 | 0.4218 | 1808800.0 |
| 2002-02-19 12:30:00 | AAPL | Stock | 0.4225 | 0.423 | 0.4223 | 0.4223 | 476000.0 |
| 2002-02-19 12:35:00 | AAPL | Stock | 0.4223 | 0.423 | 0.4207 | 0.422 | 8971200.0 |
| 2002-02-19 12:40:00 | AAPL | Stock | 0.4219 | 0.422 | 0.4214 | 0.4214 | 1506400.0 |
| 2002-02-19 12:45:00 | AAPL | Stock | 0.4218 | 0.4218 | 0.4205 | 0.4207 | 1803200.0 |
| 2002-02-19 12:50:00 | AAPL | Stock | 0.4205 | 0.4214 | 0.4204 | 0.4205 | 1506400.0 |
| 2002-02-19 12:55:00 | AAPL | Stock | 0.4205 | 0.4205 | 0.4163 | 0.4163 | 8416800.0 |
| 2002-02-19 13:00:00 | AAPL | Stock | 0.4164 | 0.4188 | 0.4164 | 0.417 | 4821600.0 |
| 2002-02-19 13:05:00 | AAPL | Stock | 0.4168 | 0.4175 | 0.4152 | 0.4166 | 5112800.0 |
> showing 50 of 117,709 rows — these rows as CSV