PREVIEW / stock_5min / 2004-09-14
file: by_date/stock_5min/2004/2004-09-14.parquet size: 2.3 MB rows: 172,966 symbols: 1,818
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-14 08:00:00 | AAPL | Stock | 0.6395 | 0.6429 | 0.6395 | 0.6429 | 22400.0 |
| 2004-09-14 08:35:00 | AAPL | Stock | 0.6355 | 0.6355 | 0.6355 | 0.6355 | 28000.0 |
| 2004-09-14 08:40:00 | AAPL | Stock | 0.6355 | 0.6355 | 0.6355 | 0.6355 | 42560.0 |
| 2004-09-14 08:45:00 | AAPL | Stock | 0.6355 | 0.6355 | 0.6355 | 0.6355 | 26152.0 |
| 2004-09-14 08:55:00 | AAPL | Stock | 0.6355 | 0.6355 | 0.6355 | 0.6355 | 29960.0 |
| 2004-09-14 09:05:00 | AAPL | Stock | 0.6338 | 0.6338 | 0.6268 | 0.6268 | 140056.0 |
| 2004-09-14 09:10:00 | AAPL | Stock | 0.6338 | 0.6338 | 0.6307 | 0.6307 | 16800.0 |
| 2004-09-14 09:15:00 | AAPL | Stock | 0.6307 | 0.633 | 0.6307 | 0.633 | 56056.0 |
| 2004-09-14 09:20:00 | AAPL | Stock | 0.6307 | 0.6307 | 0.6304 | 0.6304 | 582400.0 |
| 2004-09-14 09:25:00 | AAPL | Stock | 0.6304 | 0.6327 | 0.6289 | 0.6304 | 739200.0 |
| 2004-09-14 09:30:00 | AAPL | Stock | 0.6304 | 0.6313 | 0.6211 | 0.6221 | 26738376.0 |
| 2004-09-14 09:35:00 | AAPL | Stock | 0.622 | 0.6311 | 0.6216 | 0.6286 | 16207352.0 |
| 2004-09-14 09:40:00 | AAPL | Stock | 0.6286 | 0.6294 | 0.6266 | 0.6275 | 8799952.0 |
| 2004-09-14 09:45:00 | AAPL | Stock | 0.6275 | 0.6277 | 0.6257 | 0.627 | 5252296.0 |
| 2004-09-14 09:50:00 | AAPL | Stock | 0.627 | 0.6275 | 0.625 | 0.6266 | 5977944.0 |
| 2004-09-14 09:55:00 | AAPL | Stock | 0.627 | 0.6311 | 0.627 | 0.6273 | 6616624.0 |
| 2004-09-14 10:00:00 | AAPL | Stock | 0.6271 | 0.6295 | 0.6268 | 0.6284 | 6244616.0 |
| 2004-09-14 10:05:00 | AAPL | Stock | 0.6286 | 0.6288 | 0.6275 | 0.628 | 3574144.0 |
| 2004-09-14 10:10:00 | AAPL | Stock | 0.6282 | 0.6286 | 0.6271 | 0.6275 | 3166576.0 |
| 2004-09-14 10:15:00 | AAPL | Stock | 0.6275 | 0.6291 | 0.6275 | 0.6288 | 3497760.0 |
| 2004-09-14 10:20:00 | AAPL | Stock | 0.6288 | 0.6295 | 0.6275 | 0.6295 | 3716440.0 |
| 2004-09-14 10:25:00 | AAPL | Stock | 0.6291 | 0.6291 | 0.628 | 0.6288 | 3154256.0 |
| 2004-09-14 10:30:00 | AAPL | Stock | 0.6288 | 0.6296 | 0.6286 | 0.6286 | 4218424.0 |
| 2004-09-14 10:35:00 | AAPL | Stock | 0.6286 | 0.6288 | 0.6277 | 0.6284 | 2349704.0 |
| 2004-09-14 10:40:00 | AAPL | Stock | 0.6282 | 0.6284 | 0.6277 | 0.6277 | 1492624.0 |
| 2004-09-14 10:45:00 | AAPL | Stock | 0.6277 | 0.6279 | 0.6275 | 0.6279 | 1214304.0 |
| 2004-09-14 10:50:00 | AAPL | Stock | 0.6277 | 0.6279 | 0.6263 | 0.6264 | 2077376.0 |
| 2004-09-14 10:55:00 | AAPL | Stock | 0.6263 | 0.6264 | 0.6261 | 0.6261 | 1242080.0 |
| 2004-09-14 11:00:00 | AAPL | Stock | 0.6261 | 0.6284 | 0.6259 | 0.6284 | 3058328.0 |
| 2004-09-14 11:05:00 | AAPL | Stock | 0.6286 | 0.6291 | 0.6277 | 0.6289 | 2935912.0 |
| 2004-09-14 11:10:00 | AAPL | Stock | 0.6291 | 0.6307 | 0.6291 | 0.6291 | 4305616.0 |
| 2004-09-14 11:15:00 | AAPL | Stock | 0.6288 | 0.6293 | 0.6286 | 0.6293 | 1574160.0 |
| 2004-09-14 11:20:00 | AAPL | Stock | 0.6293 | 0.6293 | 0.6279 | 0.628 | 2010960.0 |
| 2004-09-14 11:25:00 | AAPL | Stock | 0.628 | 0.6288 | 0.6279 | 0.6284 | 1335600.0 |
| 2004-09-14 11:30:00 | AAPL | Stock | 0.6284 | 0.6288 | 0.6284 | 0.6288 | 1141672.0 |
| 2004-09-14 11:35:00 | AAPL | Stock | 0.6288 | 0.6291 | 0.6288 | 0.6291 | 1285984.0 |
| 2004-09-14 11:40:00 | AAPL | Stock | 0.6289 | 0.6296 | 0.6289 | 0.6293 | 942592.0 |
| 2004-09-14 11:45:00 | AAPL | Stock | 0.6293 | 0.6302 | 0.6293 | 0.6302 | 1966048.0 |
| 2004-09-14 11:50:00 | AAPL | Stock | 0.6302 | 0.6304 | 0.6298 | 0.63 | 1187312.0 |
| 2004-09-14 11:55:00 | AAPL | Stock | 0.6302 | 0.6313 | 0.6302 | 0.6309 | 2829960.0 |
| 2004-09-14 12:00:00 | AAPL | Stock | 0.6309 | 0.6327 | 0.6307 | 0.6327 | 3581256.0 |
| 2004-09-14 12:05:00 | AAPL | Stock | 0.6325 | 0.6334 | 0.6309 | 0.632 | 5694360.0 |
| 2004-09-14 12:10:00 | AAPL | Stock | 0.6316 | 0.6336 | 0.6314 | 0.633 | 7745752.0 |
| 2004-09-14 12:15:00 | AAPL | Stock | 0.633 | 0.6338 | 0.633 | 0.6336 | 2430232.0 |
| 2004-09-14 12:20:00 | AAPL | Stock | 0.6336 | 0.6336 | 0.6316 | 0.6318 | 3277736.0 |
| 2004-09-14 12:25:00 | AAPL | Stock | 0.6318 | 0.632 | 0.6304 | 0.6305 | 2723728.0 |
| 2004-09-14 12:30:00 | AAPL | Stock | 0.6307 | 0.6313 | 0.6305 | 0.6305 | 1759296.0 |
| 2004-09-14 12:35:00 | AAPL | Stock | 0.6305 | 0.6313 | 0.6305 | 0.6313 | 505232.0 |
| 2004-09-14 12:40:00 | AAPL | Stock | 0.6311 | 0.6313 | 0.6309 | 0.6309 | 603344.0 |
| 2004-09-14 12:45:00 | AAPL | Stock | 0.6309 | 0.6323 | 0.6309 | 0.6321 | 2148272.0 |
> showing 50 of 172,966 rows — these rows as CSV