PREVIEW / stock_5min / 2004-09-15
file: by_date/stock_5min/2004/2004-09-15.parquet size: 2.4 MB rows: 176,458 symbols: 1,812
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-15 08:20:00 | AAPL | Stock | 0.6325 | 0.6325 | 0.6325 | 0.6325 | 44800.0 |
| 2004-09-15 08:25:00 | AAPL | Stock | 0.6329 | 0.6329 | 0.6329 | 0.6329 | 14000.0 |
| 2004-09-15 09:00:00 | AAPL | Stock | 0.6325 | 0.6325 | 0.6321 | 0.6321 | 52080.0 |
| 2004-09-15 09:05:00 | AAPL | Stock | 0.6325 | 0.6325 | 0.6325 | 0.6325 | 95200.0 |
| 2004-09-15 09:10:00 | AAPL | Stock | 0.6321 | 0.6325 | 0.6321 | 0.6325 | 168000.0 |
| 2004-09-15 09:15:00 | AAPL | Stock | 0.6325 | 0.6325 | 0.6316 | 0.6316 | 72800.0 |
| 2004-09-15 09:25:00 | AAPL | Stock | 0.6313 | 0.6327 | 0.6284 | 0.6286 | 894432.0 |
| 2004-09-15 09:30:00 | AAPL | Stock | 0.6286 | 0.6323 | 0.6245 | 0.6261 | 15529024.0 |
| 2004-09-15 09:35:00 | AAPL | Stock | 0.6257 | 0.6257 | 0.6214 | 0.6238 | 10297840.0 |
| 2004-09-15 09:40:00 | AAPL | Stock | 0.6236 | 0.6264 | 0.6229 | 0.625 | 8791720.0 |
| 2004-09-15 09:45:00 | AAPL | Stock | 0.6252 | 0.6264 | 0.6252 | 0.6264 | 10772496.0 |
| 2004-09-15 09:50:00 | AAPL | Stock | 0.6263 | 0.6302 | 0.6263 | 0.6286 | 6455960.0 |
| 2004-09-15 09:55:00 | AAPL | Stock | 0.6286 | 0.6286 | 0.6259 | 0.627 | 6325032.0 |
| 2004-09-15 10:00:00 | AAPL | Stock | 0.627 | 0.6271 | 0.6266 | 0.6266 | 8189888.0 |
| 2004-09-15 10:05:00 | AAPL | Stock | 0.6264 | 0.6277 | 0.6264 | 0.6275 | 2106384.0 |
| 2004-09-15 10:10:00 | AAPL | Stock | 0.6275 | 0.6275 | 0.6268 | 0.6275 | 2015552.0 |
| 2004-09-15 10:15:00 | AAPL | Stock | 0.6275 | 0.6282 | 0.6271 | 0.6273 | 2324616.0 |
| 2004-09-15 10:20:00 | AAPL | Stock | 0.6273 | 0.6277 | 0.6259 | 0.6261 | 2910824.0 |
| 2004-09-15 10:25:00 | AAPL | Stock | 0.6259 | 0.6261 | 0.6254 | 0.6255 | 2775808.0 |
| 2004-09-15 10:30:00 | AAPL | Stock | 0.6254 | 0.6259 | 0.6234 | 0.6245 | 6318704.0 |
| 2004-09-15 10:35:00 | AAPL | Stock | 0.6245 | 0.6248 | 0.6232 | 0.6245 | 3528000.0 |
| 2004-09-15 10:40:00 | AAPL | Stock | 0.6246 | 0.6248 | 0.6243 | 0.6243 | 2493456.0 |
| 2004-09-15 10:45:00 | AAPL | Stock | 0.6245 | 0.6245 | 0.6238 | 0.6238 | 1892800.0 |
| 2004-09-15 10:50:00 | AAPL | Stock | 0.6239 | 0.6254 | 0.6239 | 0.625 | 1187200.0 |
| 2004-09-15 10:55:00 | AAPL | Stock | 0.625 | 0.6263 | 0.625 | 0.6261 | 898016.0 |
| 2004-09-15 11:00:00 | AAPL | Stock | 0.6261 | 0.6266 | 0.6261 | 0.6264 | 1535968.0 |
| 2004-09-15 11:05:00 | AAPL | Stock | 0.6264 | 0.6277 | 0.6264 | 0.6275 | 2705528.0 |
| 2004-09-15 11:10:00 | AAPL | Stock | 0.6277 | 0.6316 | 0.6275 | 0.6291 | 8715336.0 |
| 2004-09-15 11:15:00 | AAPL | Stock | 0.6291 | 0.6304 | 0.6289 | 0.6304 | 2167424.0 |
| 2004-09-15 11:20:00 | AAPL | Stock | 0.6304 | 0.6323 | 0.6302 | 0.6311 | 4372704.0 |
| 2004-09-15 11:25:00 | AAPL | Stock | 0.6311 | 0.6314 | 0.63 | 0.6314 | 5596080.0 |
| 2004-09-15 11:30:00 | AAPL | Stock | 0.6311 | 0.6313 | 0.63 | 0.63 | 2226672.0 |
| 2004-09-15 11:35:00 | AAPL | Stock | 0.6302 | 0.632 | 0.63 | 0.632 | 2990400.0 |
| 2004-09-15 11:40:00 | AAPL | Stock | 0.6316 | 0.632 | 0.6314 | 0.6314 | 3239152.0 |
| 2004-09-15 11:45:00 | AAPL | Stock | 0.6318 | 0.6318 | 0.6311 | 0.6313 | 1407560.0 |
| 2004-09-15 11:50:00 | AAPL | Stock | 0.6311 | 0.6318 | 0.6311 | 0.6316 | 2568048.0 |
| 2004-09-15 11:55:00 | AAPL | Stock | 0.6314 | 0.6318 | 0.6313 | 0.6318 | 1870120.0 |
| 2004-09-15 12:00:00 | AAPL | Stock | 0.6316 | 0.6327 | 0.6316 | 0.6327 | 3649016.0 |
| 2004-09-15 12:05:00 | AAPL | Stock | 0.6327 | 0.6334 | 0.6314 | 0.6316 | 2511600.0 |
| 2004-09-15 12:10:00 | AAPL | Stock | 0.6314 | 0.6318 | 0.6314 | 0.6316 | 1258096.0 |
| 2004-09-15 12:15:00 | AAPL | Stock | 0.6316 | 0.6316 | 0.6313 | 0.6316 | 3519656.0 |
| 2004-09-15 12:20:00 | AAPL | Stock | 0.6314 | 0.6323 | 0.6314 | 0.6321 | 1185856.0 |
| 2004-09-15 12:25:00 | AAPL | Stock | 0.6316 | 0.6318 | 0.6298 | 0.63 | 1259552.0 |
| 2004-09-15 12:30:00 | AAPL | Stock | 0.6304 | 0.6304 | 0.6296 | 0.6296 | 681072.0 |
| 2004-09-15 12:35:00 | AAPL | Stock | 0.6297 | 0.6298 | 0.6288 | 0.6289 | 1445808.0 |
| 2004-09-15 12:40:00 | AAPL | Stock | 0.6289 | 0.6291 | 0.628 | 0.6291 | 3646216.0 |
| 2004-09-15 12:45:00 | AAPL | Stock | 0.6289 | 0.6298 | 0.6282 | 0.6289 | 1217160.0 |
| 2004-09-15 12:50:00 | AAPL | Stock | 0.6289 | 0.6295 | 0.6289 | 0.6295 | 642152.0 |
| 2004-09-15 12:55:00 | AAPL | Stock | 0.6295 | 0.6296 | 0.6291 | 0.6296 | 1170848.0 |
| 2004-09-15 13:00:00 | AAPL | Stock | 0.6295 | 0.6298 | 0.6295 | 0.6298 | 564144.0 |
> showing 50 of 176,458 rows — these rows as CSV