PREVIEW / stock_5min / 2004-09-03
file: by_date/stock_5min/2004/2004-09-03.parquet size: 2.3 MB rows: 169,514 symbols: 1,806
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-03 08:20:00 | AAPL | Stock | 0.633 | 0.635 | 0.633 | 0.635 | 28000.0 |
| 2004-09-03 08:30:00 | AAPL | Stock | 0.633 | 0.635 | 0.633 | 0.6339 | 35000.0 |
| 2004-09-03 08:35:00 | AAPL | Stock | 0.6321 | 0.6321 | 0.6321 | 0.6321 | 5600.0 |
| 2004-09-03 08:40:00 | AAPL | Stock | 0.6277 | 0.6277 | 0.6277 | 0.6277 | 16800.0 |
| 2004-09-03 08:45:00 | AAPL | Stock | 0.6268 | 0.6268 | 0.6268 | 0.6268 | 5600.0 |
| 2004-09-03 08:50:00 | AAPL | Stock | 0.6268 | 0.6304 | 0.6255 | 0.6255 | 61600.0 |
| 2004-09-03 09:00:00 | AAPL | Stock | 0.6268 | 0.6268 | 0.6268 | 0.6268 | 84000.0 |
| 2004-09-03 09:05:00 | AAPL | Stock | 0.6268 | 0.6271 | 0.6268 | 0.6271 | 39200.0 |
| 2004-09-03 09:10:00 | AAPL | Stock | 0.6268 | 0.6275 | 0.6268 | 0.6275 | 22400.0 |
| 2004-09-03 09:25:00 | AAPL | Stock | 0.6286 | 0.6286 | 0.6254 | 0.6259 | 473200.0 |
| 2004-09-03 09:30:00 | AAPL | Stock | 0.6255 | 0.6334 | 0.6252 | 0.6316 | 6844600.0 |
| 2004-09-03 09:35:00 | AAPL | Stock | 0.6318 | 0.6334 | 0.6293 | 0.6304 | 5916792.0 |
| 2004-09-03 09:40:00 | AAPL | Stock | 0.6305 | 0.6354 | 0.6295 | 0.6346 | 8469608.0 |
| 2004-09-03 09:45:00 | AAPL | Stock | 0.6341 | 0.6357 | 0.6325 | 0.6357 | 4093152.0 |
| 2004-09-03 09:50:00 | AAPL | Stock | 0.6361 | 0.6366 | 0.6339 | 0.6346 | 7992488.0 |
| 2004-09-03 09:55:00 | AAPL | Stock | 0.6346 | 0.6357 | 0.6329 | 0.6355 | 9546880.0 |
| 2004-09-03 10:00:00 | AAPL | Stock | 0.6355 | 0.6384 | 0.6341 | 0.6379 | 6805232.0 |
| 2004-09-03 10:05:00 | AAPL | Stock | 0.6379 | 0.6395 | 0.637 | 0.6384 | 7084056.0 |
| 2004-09-03 10:10:00 | AAPL | Stock | 0.6389 | 0.6407 | 0.6371 | 0.6384 | 7161224.0 |
| 2004-09-03 10:15:00 | AAPL | Stock | 0.638 | 0.638 | 0.6366 | 0.6375 | 5455856.0 |
| 2004-09-03 10:20:00 | AAPL | Stock | 0.6366 | 0.6388 | 0.6366 | 0.6368 | 2744112.0 |
| 2004-09-03 10:25:00 | AAPL | Stock | 0.6371 | 0.6375 | 0.6345 | 0.6355 | 6745088.0 |
| 2004-09-03 10:30:00 | AAPL | Stock | 0.6357 | 0.6366 | 0.6348 | 0.6363 | 4750144.0 |
| 2004-09-03 10:35:00 | AAPL | Stock | 0.6361 | 0.6366 | 0.6354 | 0.6354 | 1830920.0 |
| 2004-09-03 10:40:00 | AAPL | Stock | 0.6355 | 0.6389 | 0.6355 | 0.6388 | 3297448.0 |
| 2004-09-03 10:45:00 | AAPL | Stock | 0.6388 | 0.6414 | 0.6386 | 0.6393 | 5588072.0 |
| 2004-09-03 10:50:00 | AAPL | Stock | 0.6393 | 0.6398 | 0.6386 | 0.6388 | 3630200.0 |
| 2004-09-03 10:55:00 | AAPL | Stock | 0.6386 | 0.6389 | 0.6345 | 0.635 | 6238120.0 |
| 2004-09-03 11:00:00 | AAPL | Stock | 0.635 | 0.635 | 0.6332 | 0.6339 | 4112808.0 |
| 2004-09-03 11:05:00 | AAPL | Stock | 0.6338 | 0.6346 | 0.6325 | 0.6345 | 9937032.0 |
| 2004-09-03 11:10:00 | AAPL | Stock | 0.6343 | 0.6345 | 0.6323 | 0.6323 | 3227952.0 |
| 2004-09-03 11:15:00 | AAPL | Stock | 0.6323 | 0.6329 | 0.6316 | 0.6316 | 2193856.0 |
| 2004-09-03 11:20:00 | AAPL | Stock | 0.6314 | 0.6338 | 0.6311 | 0.6325 | 4283776.0 |
| 2004-09-03 11:25:00 | AAPL | Stock | 0.6325 | 0.6341 | 0.6323 | 0.6336 | 2306696.0 |
| 2004-09-03 11:30:00 | AAPL | Stock | 0.6336 | 0.6345 | 0.633 | 0.6339 | 2346736.0 |
| 2004-09-03 11:35:00 | AAPL | Stock | 0.6339 | 0.6346 | 0.6338 | 0.6345 | 2777544.0 |
| 2004-09-03 11:40:00 | AAPL | Stock | 0.6343 | 0.6366 | 0.6343 | 0.6363 | 2237032.0 |
| 2004-09-03 11:45:00 | AAPL | Stock | 0.6363 | 0.6368 | 0.6355 | 0.6366 | 2572024.0 |
| 2004-09-03 11:50:00 | AAPL | Stock | 0.6366 | 0.6384 | 0.6363 | 0.6375 | 2653728.0 |
| 2004-09-03 11:55:00 | AAPL | Stock | 0.6375 | 0.6377 | 0.6354 | 0.6354 | 1915928.0 |
| 2004-09-03 12:00:00 | AAPL | Stock | 0.6354 | 0.6355 | 0.6348 | 0.6348 | 1466752.0 |
| 2004-09-03 12:05:00 | AAPL | Stock | 0.6354 | 0.6354 | 0.633 | 0.6334 | 2741760.0 |
| 2004-09-03 12:10:00 | AAPL | Stock | 0.6338 | 0.6343 | 0.6334 | 0.6338 | 775600.0 |
| 2004-09-03 12:15:00 | AAPL | Stock | 0.6339 | 0.6345 | 0.6338 | 0.6343 | 3518760.0 |
| 2004-09-03 12:20:00 | AAPL | Stock | 0.6343 | 0.6346 | 0.6339 | 0.6345 | 1486800.0 |
| 2004-09-03 12:25:00 | AAPL | Stock | 0.6346 | 0.6355 | 0.6345 | 0.6346 | 948416.0 |
| 2004-09-03 12:30:00 | AAPL | Stock | 0.6346 | 0.6346 | 0.6339 | 0.6341 | 1113280.0 |
| 2004-09-03 12:35:00 | AAPL | Stock | 0.6341 | 0.6354 | 0.6338 | 0.6339 | 2664704.0 |
| 2004-09-03 12:40:00 | AAPL | Stock | 0.6338 | 0.6343 | 0.6338 | 0.6343 | 1617336.0 |
| 2004-09-03 12:45:00 | AAPL | Stock | 0.6343 | 0.6348 | 0.6338 | 0.6345 | 1055824.0 |
> showing 50 of 169,514 rows — these rows as CSV