PREVIEW / stock_5min / 2004-09-02
file: by_date/stock_5min/2004/2004-09-02.parquet size: 2.3 MB rows: 174,795 symbols: 1,829
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-02 08:00:00 | AAPL | Stock | 0.6384 | 0.6429 | 0.6339 | 0.6339 | 159600.0 |
| 2004-09-02 08:05:00 | AAPL | Stock | 0.6366 | 0.6366 | 0.6366 | 0.6366 | 11200.0 |
| 2004-09-02 08:10:00 | AAPL | Stock | 0.6388 | 0.6402 | 0.6388 | 0.64 | 154560.0 |
| 2004-09-02 08:20:00 | AAPL | Stock | 0.64 | 0.64 | 0.64 | 0.64 | 28000.0 |
| 2004-09-02 08:50:00 | AAPL | Stock | 0.6393 | 0.6393 | 0.6393 | 0.6393 | 5600.0 |
| 2004-09-02 09:00:00 | AAPL | Stock | 0.6375 | 0.6379 | 0.6375 | 0.6375 | 139552.0 |
| 2004-09-02 09:05:00 | AAPL | Stock | 0.6379 | 0.6379 | 0.6375 | 0.6377 | 109816.0 |
| 2004-09-02 09:10:00 | AAPL | Stock | 0.6375 | 0.6375 | 0.6366 | 0.6366 | 89600.0 |
| 2004-09-02 09:15:00 | AAPL | Stock | 0.6363 | 0.6363 | 0.6357 | 0.6357 | 44800.0 |
| 2004-09-02 09:20:00 | AAPL | Stock | 0.6357 | 0.6366 | 0.635 | 0.6366 | 1114400.0 |
| 2004-09-02 09:25:00 | AAPL | Stock | 0.6366 | 0.6368 | 0.6334 | 0.6339 | 1663200.0 |
| 2004-09-02 09:30:00 | AAPL | Stock | 0.6339 | 0.6388 | 0.6329 | 0.6371 | 13668312.0 |
| 2004-09-02 09:35:00 | AAPL | Stock | 0.6371 | 0.6377 | 0.6336 | 0.6359 | 11171608.0 |
| 2004-09-02 09:40:00 | AAPL | Stock | 0.6357 | 0.6357 | 0.6321 | 0.6339 | 5848136.0 |
| 2004-09-02 09:45:00 | AAPL | Stock | 0.6329 | 0.6361 | 0.6325 | 0.6332 | 6884192.0 |
| 2004-09-02 09:50:00 | AAPL | Stock | 0.6332 | 0.6338 | 0.6311 | 0.6327 | 13161176.0 |
| 2004-09-02 09:55:00 | AAPL | Stock | 0.6327 | 0.6327 | 0.6302 | 0.6309 | 4497080.0 |
| 2004-09-02 10:00:00 | AAPL | Stock | 0.6309 | 0.6334 | 0.6309 | 0.6316 | 4913720.0 |
| 2004-09-02 10:05:00 | AAPL | Stock | 0.6316 | 0.6329 | 0.6313 | 0.6321 | 4888240.0 |
| 2004-09-02 10:10:00 | AAPL | Stock | 0.632 | 0.6334 | 0.6313 | 0.633 | 6148576.0 |
| 2004-09-02 10:15:00 | AAPL | Stock | 0.6334 | 0.6334 | 0.6323 | 0.6329 | 2877952.0 |
| 2004-09-02 10:20:00 | AAPL | Stock | 0.6329 | 0.6348 | 0.6321 | 0.6329 | 3993920.0 |
| 2004-09-02 10:25:00 | AAPL | Stock | 0.6332 | 0.6343 | 0.6329 | 0.6336 | 8304128.0 |
| 2004-09-02 10:30:00 | AAPL | Stock | 0.6339 | 0.6339 | 0.6327 | 0.6332 | 1882608.0 |
| 2004-09-02 10:35:00 | AAPL | Stock | 0.6334 | 0.6339 | 0.6327 | 0.6329 | 3184104.0 |
| 2004-09-02 10:40:00 | AAPL | Stock | 0.6329 | 0.633 | 0.6321 | 0.6323 | 3498992.0 |
| 2004-09-02 10:45:00 | AAPL | Stock | 0.6323 | 0.6323 | 0.6313 | 0.6314 | 3149216.0 |
| 2004-09-02 10:50:00 | AAPL | Stock | 0.6316 | 0.632 | 0.6302 | 0.6313 | 10955784.0 |
| 2004-09-02 10:55:00 | AAPL | Stock | 0.6318 | 0.6323 | 0.6313 | 0.632 | 8872024.0 |
| 2004-09-02 11:00:00 | AAPL | Stock | 0.632 | 0.6327 | 0.6298 | 0.6304 | 5665352.0 |
| 2004-09-02 11:05:00 | AAPL | Stock | 0.6304 | 0.6313 | 0.6295 | 0.6298 | 7244664.0 |
| 2004-09-02 11:10:00 | AAPL | Stock | 0.6298 | 0.6302 | 0.6268 | 0.627 | 8016120.0 |
| 2004-09-02 11:15:00 | AAPL | Stock | 0.627 | 0.6273 | 0.6243 | 0.6257 | 10956624.0 |
| 2004-09-02 11:20:00 | AAPL | Stock | 0.6257 | 0.6268 | 0.625 | 0.6264 | 3841712.0 |
| 2004-09-02 11:25:00 | AAPL | Stock | 0.6264 | 0.6275 | 0.6263 | 0.6271 | 4308920.0 |
| 2004-09-02 11:30:00 | AAPL | Stock | 0.6271 | 0.6271 | 0.6261 | 0.6263 | 2450840.0 |
| 2004-09-02 11:35:00 | AAPL | Stock | 0.6264 | 0.6268 | 0.6263 | 0.6264 | 2527560.0 |
| 2004-09-02 11:40:00 | AAPL | Stock | 0.6266 | 0.6266 | 0.6255 | 0.6255 | 2348808.0 |
| 2004-09-02 11:45:00 | AAPL | Stock | 0.6255 | 0.6259 | 0.6232 | 0.6243 | 6456800.0 |
| 2004-09-02 11:50:00 | AAPL | Stock | 0.6243 | 0.6252 | 0.6241 | 0.625 | 2187696.0 |
| 2004-09-02 11:55:00 | AAPL | Stock | 0.625 | 0.6254 | 0.6246 | 0.6254 | 2737896.0 |
| 2004-09-02 12:00:00 | AAPL | Stock | 0.6252 | 0.6255 | 0.6238 | 0.6239 | 2245600.0 |
| 2004-09-02 12:05:00 | AAPL | Stock | 0.6239 | 0.6246 | 0.6239 | 0.6241 | 594776.0 |
| 2004-09-02 12:10:00 | AAPL | Stock | 0.6241 | 0.6243 | 0.6236 | 0.6236 | 1885016.0 |
| 2004-09-02 12:15:00 | AAPL | Stock | 0.6236 | 0.6238 | 0.6225 | 0.6227 | 1364944.0 |
| 2004-09-02 12:20:00 | AAPL | Stock | 0.6225 | 0.623 | 0.622 | 0.622 | 3094840.0 |
| 2004-09-02 12:25:00 | AAPL | Stock | 0.622 | 0.6255 | 0.622 | 0.6245 | 4795280.0 |
| 2004-09-02 12:30:00 | AAPL | Stock | 0.6245 | 0.6245 | 0.6232 | 0.6236 | 2060688.0 |
| 2004-09-02 12:35:00 | AAPL | Stock | 0.6236 | 0.6238 | 0.6236 | 0.6238 | 695576.0 |
| 2004-09-02 12:40:00 | AAPL | Stock | 0.6238 | 0.6246 | 0.6238 | 0.6246 | 1345848.0 |
> showing 50 of 174,795 rows — these rows as CSV