PREVIEW / stock_5min / 2005-06-02
file: by_date/stock_5min/2005/2005-06-02.parquet size: 2.7 MB rows: 199,456 symbols: 1,984
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-02 08:00:00 | AAPL | Stock | 1.4421 | 1.4421 | 1.4411 | 1.4411 | 16800.0 |
| 2005-06-02 08:05:00 | AAPL | Stock | 1.4421 | 1.4421 | 1.4411 | 1.4411 | 70000.0 |
| 2005-06-02 08:10:00 | AAPL | Stock | 1.4375 | 1.4375 | 1.4375 | 1.4375 | 14000.0 |
| 2005-06-02 08:15:00 | AAPL | Stock | 1.4375 | 1.4375 | 1.425 | 1.4286 | 335384.0 |
| 2005-06-02 08:20:00 | AAPL | Stock | 1.4286 | 1.4393 | 1.4232 | 1.4232 | 638540.0 |
| 2005-06-02 08:25:00 | AAPL | Stock | 1.425 | 1.4393 | 1.4214 | 1.4225 | 481740.0 |
| 2005-06-02 08:30:00 | AAPL | Stock | 1.4232 | 1.4236 | 1.4204 | 1.4225 | 193564.0 |
| 2005-06-02 08:35:00 | AAPL | Stock | 1.4229 | 1.4232 | 1.4214 | 1.4232 | 19600.0 |
| 2005-06-02 08:40:00 | AAPL | Stock | 1.4236 | 1.4236 | 1.4204 | 1.4232 | 157584.0 |
| 2005-06-02 08:45:00 | AAPL | Stock | 1.4229 | 1.4236 | 1.4218 | 1.4236 | 61180.0 |
| 2005-06-02 08:50:00 | AAPL | Stock | 1.4257 | 1.4289 | 1.425 | 1.4275 | 215600.0 |
| 2005-06-02 08:55:00 | AAPL | Stock | 1.4286 | 1.4332 | 1.4282 | 1.4329 | 1395800.0 |
| 2005-06-02 09:00:00 | AAPL | Stock | 1.4314 | 1.4314 | 1.4282 | 1.4286 | 120400.0 |
| 2005-06-02 09:05:00 | AAPL | Stock | 1.4286 | 1.4293 | 1.4282 | 1.4293 | 98000.0 |
| 2005-06-02 09:10:00 | AAPL | Stock | 1.4286 | 1.4304 | 1.4286 | 1.4286 | 187600.0 |
| 2005-06-02 09:15:00 | AAPL | Stock | 1.4289 | 1.4289 | 1.4282 | 1.4282 | 230160.0 |
| 2005-06-02 09:20:00 | AAPL | Stock | 1.4286 | 1.4286 | 1.4257 | 1.4257 | 612640.0 |
| 2005-06-02 09:25:00 | AAPL | Stock | 1.4286 | 1.4404 | 1.4257 | 1.4314 | 2865380.0 |
| 2005-06-02 09:30:00 | AAPL | Stock | 1.4304 | 1.4354 | 1.4143 | 1.4175 | 22681316.0 |
| 2005-06-02 09:35:00 | AAPL | Stock | 1.4175 | 1.4325 | 1.4175 | 1.4207 | 14526008.0 |
| 2005-06-02 09:40:00 | AAPL | Stock | 1.4207 | 1.4325 | 1.4196 | 1.4268 | 16695896.0 |
| 2005-06-02 09:45:00 | AAPL | Stock | 1.4271 | 1.4286 | 1.4236 | 1.425 | 12701276.0 |
| 2005-06-02 09:50:00 | AAPL | Stock | 1.4246 | 1.44 | 1.4246 | 1.44 | 14584416.0 |
| 2005-06-02 09:55:00 | AAPL | Stock | 1.4396 | 1.44 | 1.4307 | 1.4339 | 8946560.0 |
| 2005-06-02 10:00:00 | AAPL | Stock | 1.4339 | 1.4371 | 1.4314 | 1.4368 | 5650036.0 |
| 2005-06-02 10:05:00 | AAPL | Stock | 1.4361 | 1.4375 | 1.4304 | 1.4304 | 7696444.0 |
| 2005-06-02 10:10:00 | AAPL | Stock | 1.4296 | 1.4304 | 1.4232 | 1.4243 | 11704588.0 |
| 2005-06-02 10:15:00 | AAPL | Stock | 1.4243 | 1.4264 | 1.4225 | 1.4246 | 10766308.0 |
| 2005-06-02 10:20:00 | AAPL | Stock | 1.4246 | 1.4286 | 1.4243 | 1.425 | 6491044.0 |
| 2005-06-02 10:25:00 | AAPL | Stock | 1.4254 | 1.4293 | 1.4254 | 1.4275 | 4481260.0 |
| 2005-06-02 10:30:00 | AAPL | Stock | 1.4271 | 1.4321 | 1.4271 | 1.4286 | 7857472.0 |
| 2005-06-02 10:35:00 | AAPL | Stock | 1.4286 | 1.4289 | 1.4257 | 1.4286 | 5159504.0 |
| 2005-06-02 10:40:00 | AAPL | Stock | 1.4289 | 1.4325 | 1.4271 | 1.4304 | 6506864.0 |
| 2005-06-02 10:45:00 | AAPL | Stock | 1.4304 | 1.4311 | 1.4246 | 1.425 | 4819892.0 |
| 2005-06-02 10:50:00 | AAPL | Stock | 1.4246 | 1.4271 | 1.4232 | 1.4264 | 2365720.0 |
| 2005-06-02 10:55:00 | AAPL | Stock | 1.4264 | 1.4271 | 1.4239 | 1.4271 | 3274712.0 |
| 2005-06-02 11:00:00 | AAPL | Stock | 1.4271 | 1.4275 | 1.4243 | 1.4243 | 3305064.0 |
| 2005-06-02 11:05:00 | AAPL | Stock | 1.4246 | 1.4264 | 1.4243 | 1.4257 | 2238684.0 |
| 2005-06-02 11:10:00 | AAPL | Stock | 1.4264 | 1.4279 | 1.425 | 1.4268 | 1935864.0 |
| 2005-06-02 11:15:00 | AAPL | Stock | 1.4271 | 1.4286 | 1.4268 | 1.4282 | 2417464.0 |
| 2005-06-02 11:20:00 | AAPL | Stock | 1.4282 | 1.4286 | 1.4261 | 1.4264 | 2858632.0 |
| 2005-06-02 11:25:00 | AAPL | Stock | 1.4264 | 1.4289 | 1.4264 | 1.4279 | 1527876.0 |
| 2005-06-02 11:30:00 | AAPL | Stock | 1.4279 | 1.4286 | 1.4271 | 1.4282 | 1775564.0 |
| 2005-06-02 11:35:00 | AAPL | Stock | 1.4279 | 1.4289 | 1.4279 | 1.4282 | 2501912.0 |
| 2005-06-02 11:40:00 | AAPL | Stock | 1.4286 | 1.4289 | 1.4261 | 1.4268 | 2607724.0 |
| 2005-06-02 11:45:00 | AAPL | Stock | 1.4271 | 1.4304 | 1.4261 | 1.4271 | 6059676.0 |
| 2005-06-02 11:50:00 | AAPL | Stock | 1.4268 | 1.4271 | 1.4264 | 1.4271 | 729120.0 |
| 2005-06-02 11:55:00 | AAPL | Stock | 1.4268 | 1.4271 | 1.4264 | 1.4264 | 507836.0 |
| 2005-06-02 12:00:00 | AAPL | Stock | 1.4264 | 1.4286 | 1.4261 | 1.4282 | 2160368.0 |
| 2005-06-02 12:05:00 | AAPL | Stock | 1.4282 | 1.4289 | 1.4264 | 1.4286 | 3775324.0 |
> showing 50 of 199,456 rows — these rows as CSV