PREVIEW / stock_5min / 2005-08-29
file: by_date/stock_5min/2005/2005-08-29.parquet size: 2.7 MB rows: 200,170 symbols: 2,079
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-08-29 08:00:00 | AAPL | Stock | 1.625 | 1.6286 | 1.625 | 1.6286 | 113400.0 |
| 2005-08-29 08:05:00 | AAPL | Stock | 1.6211 | 1.6211 | 1.6196 | 1.6204 | 44800.0 |
| 2005-08-29 08:10:00 | AAPL | Stock | 1.6204 | 1.6207 | 1.6161 | 1.6161 | 92568.0 |
| 2005-08-29 08:15:00 | AAPL | Stock | 1.6179 | 1.62 | 1.6146 | 1.62 | 330400.0 |
| 2005-08-29 08:20:00 | AAPL | Stock | 1.6182 | 1.6182 | 1.6182 | 1.6182 | 11200.0 |
| 2005-08-29 08:25:00 | AAPL | Stock | 1.6182 | 1.6182 | 1.6182 | 1.6182 | 7000.0 |
| 2005-08-29 08:30:00 | AAPL | Stock | 1.6179 | 1.6204 | 1.6168 | 1.6168 | 36400.0 |
| 2005-08-29 08:35:00 | AAPL | Stock | 1.6164 | 1.6164 | 1.6164 | 1.6164 | 26880.0 |
| 2005-08-29 08:50:00 | AAPL | Stock | 1.6218 | 1.6218 | 1.6218 | 1.6218 | 2800.0 |
| 2005-08-29 08:55:00 | AAPL | Stock | 1.6218 | 1.6218 | 1.6214 | 1.6214 | 8400.0 |
| 2005-08-29 09:00:00 | AAPL | Stock | 1.6179 | 1.6214 | 1.6179 | 1.6214 | 97580.0 |
| 2005-08-29 09:10:00 | AAPL | Stock | 1.6193 | 1.6214 | 1.6186 | 1.6186 | 92400.0 |
| 2005-08-29 09:15:00 | AAPL | Stock | 1.6214 | 1.6214 | 1.6175 | 1.6179 | 53200.0 |
| 2005-08-29 09:25:00 | AAPL | Stock | 1.6232 | 1.6232 | 1.6161 | 1.62 | 375564.0 |
| 2005-08-29 09:30:00 | AAPL | Stock | 1.6168 | 1.6268 | 1.6164 | 1.6246 | 8793764.0 |
| 2005-08-29 09:35:00 | AAPL | Stock | 1.6236 | 1.6239 | 1.6182 | 1.6225 | 6833540.0 |
| 2005-08-29 09:40:00 | AAPL | Stock | 1.6221 | 1.6311 | 1.62 | 1.6271 | 8029728.0 |
| 2005-08-29 09:45:00 | AAPL | Stock | 1.6271 | 1.6279 | 1.6214 | 1.6236 | 4869508.0 |
| 2005-08-29 09:50:00 | AAPL | Stock | 1.6235 | 1.6275 | 1.6214 | 1.6275 | 3989356.0 |
| 2005-08-29 09:55:00 | AAPL | Stock | 1.6275 | 1.6368 | 1.6275 | 1.6364 | 7537152.0 |
| 2005-08-29 10:00:00 | AAPL | Stock | 1.6368 | 1.6382 | 1.63 | 1.6322 | 7148316.0 |
| 2005-08-29 10:05:00 | AAPL | Stock | 1.6321 | 1.6353 | 1.6304 | 1.6343 | 2702252.0 |
| 2005-08-29 10:10:00 | AAPL | Stock | 1.6343 | 1.6371 | 1.6321 | 1.6364 | 4361896.0 |
| 2005-08-29 10:15:00 | AAPL | Stock | 1.6364 | 1.6425 | 1.6351 | 1.6351 | 5945632.0 |
| 2005-08-29 10:20:00 | AAPL | Stock | 1.6354 | 1.6368 | 1.6311 | 1.6364 | 5659164.0 |
| 2005-08-29 10:25:00 | AAPL | Stock | 1.6368 | 1.6379 | 1.6311 | 1.6318 | 3768632.0 |
| 2005-08-29 10:30:00 | AAPL | Stock | 1.6325 | 1.6336 | 1.6293 | 1.6296 | 2220008.0 |
| 2005-08-29 10:35:00 | AAPL | Stock | 1.6296 | 1.6357 | 1.6293 | 1.6339 | 5228440.0 |
| 2005-08-29 10:40:00 | AAPL | Stock | 1.6329 | 1.6332 | 1.6268 | 1.6293 | 4746840.0 |
| 2005-08-29 10:45:00 | AAPL | Stock | 1.6293 | 1.6325 | 1.6268 | 1.6293 | 3565100.0 |
| 2005-08-29 10:50:00 | AAPL | Stock | 1.63 | 1.6304 | 1.6257 | 1.6279 | 1959272.0 |
| 2005-08-29 10:55:00 | AAPL | Stock | 1.6275 | 1.6286 | 1.6254 | 1.6279 | 2701692.0 |
| 2005-08-29 11:00:00 | AAPL | Stock | 1.6279 | 1.63 | 1.6268 | 1.6271 | 2184140.0 |
| 2005-08-29 11:05:00 | AAPL | Stock | 1.6279 | 1.6321 | 1.6275 | 1.6282 | 3218600.0 |
| 2005-08-29 11:10:00 | AAPL | Stock | 1.6286 | 1.6304 | 1.6279 | 1.6286 | 2025688.0 |
| 2005-08-29 11:15:00 | AAPL | Stock | 1.6289 | 1.63 | 1.6264 | 1.6271 | 3248588.0 |
| 2005-08-29 11:20:00 | AAPL | Stock | 1.6279 | 1.6293 | 1.6275 | 1.6279 | 1037400.0 |
| 2005-08-29 11:25:00 | AAPL | Stock | 1.6279 | 1.6304 | 1.6271 | 1.6286 | 2209704.0 |
| 2005-08-29 11:30:00 | AAPL | Stock | 1.6289 | 1.6332 | 1.6289 | 1.6325 | 4816784.0 |
| 2005-08-29 11:35:00 | AAPL | Stock | 1.6314 | 1.635 | 1.6311 | 1.6336 | 2758672.0 |
| 2005-08-29 11:40:00 | AAPL | Stock | 1.6336 | 1.635 | 1.6332 | 1.6343 | 1410556.0 |
| 2005-08-29 11:45:00 | AAPL | Stock | 1.6346 | 1.635 | 1.6332 | 1.635 | 1031940.0 |
| 2005-08-29 11:50:00 | AAPL | Stock | 1.635 | 1.6371 | 1.6339 | 1.6343 | 2021152.0 |
| 2005-08-29 11:55:00 | AAPL | Stock | 1.6343 | 1.6364 | 1.6332 | 1.6332 | 1540140.0 |
| 2005-08-29 12:00:00 | AAPL | Stock | 1.6325 | 1.6339 | 1.6307 | 1.6336 | 2787568.0 |
| 2005-08-29 12:05:00 | AAPL | Stock | 1.6336 | 1.6346 | 1.6332 | 1.6343 | 957264.0 |
| 2005-08-29 12:10:00 | AAPL | Stock | 1.6343 | 1.6357 | 1.6321 | 1.635 | 1765092.0 |
| 2005-08-29 12:15:00 | AAPL | Stock | 1.6354 | 1.6357 | 1.6314 | 1.6318 | 1635396.0 |
| 2005-08-29 12:20:00 | AAPL | Stock | 1.6321 | 1.6325 | 1.6314 | 1.6325 | 1482460.0 |
| 2005-08-29 12:25:00 | AAPL | Stock | 1.6329 | 1.6339 | 1.6318 | 1.6321 | 861728.0 |
> showing 50 of 200,170 rows — these rows as CSV