PREVIEW / stock_5min / 2009-09-22
file: by_date/stock_5min/2009/2009-09-22.parquet size: 4.7 MB rows: 321,880 symbols: 3,395
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-22 04:15:00 | AAPL | Stock | 6.5961 | 6.5961 | 6.5961 | 6.5961 | 2800.0 |
| 2009-09-22 05:50:00 | AAPL | Stock | 6.6079 | 6.6079 | 6.6079 | 6.6079 | 2800.0 |
| 2009-09-22 06:00:00 | AAPL | Stock | 6.6161 | 6.6161 | 6.6154 | 6.6154 | 8400.0 |
| 2009-09-22 06:20:00 | AAPL | Stock | 6.625 | 6.625 | 6.625 | 6.625 | 28000.0 |
| 2009-09-22 07:05:00 | AAPL | Stock | 6.6161 | 6.6161 | 6.6161 | 6.6161 | 2800.0 |
| 2009-09-22 07:15:00 | AAPL | Stock | 6.6089 | 6.6268 | 6.6089 | 6.6268 | 28000.0 |
| 2009-09-22 07:25:00 | AAPL | Stock | 6.6161 | 6.625 | 6.6161 | 6.625 | 33600.0 |
| 2009-09-22 07:30:00 | AAPL | Stock | 6.6268 | 6.6268 | 6.6261 | 6.6268 | 17920.0 |
| 2009-09-22 07:45:00 | AAPL | Stock | 6.6268 | 6.6268 | 6.6268 | 6.6268 | 2800.0 |
| 2009-09-22 07:50:00 | AAPL | Stock | 6.6246 | 6.6246 | 6.6246 | 6.6246 | 2800.0 |
| 2009-09-22 07:55:00 | AAPL | Stock | 6.6329 | 6.6329 | 6.625 | 6.6329 | 34160.0 |
| 2009-09-22 08:00:00 | AAPL | Stock | 6.6189 | 6.6286 | 6.6143 | 6.6268 | 442652.0 |
| 2009-09-22 08:05:00 | AAPL | Stock | 6.6268 | 6.6357 | 6.6268 | 6.6346 | 231140.0 |
| 2009-09-22 08:10:00 | AAPL | Stock | 6.6339 | 6.6393 | 6.6321 | 6.6375 | 108836.0 |
| 2009-09-22 08:15:00 | AAPL | Stock | 6.6379 | 6.6429 | 6.6329 | 6.6411 | 125104.0 |
| 2009-09-22 08:20:00 | AAPL | Stock | 6.6379 | 6.6425 | 6.6375 | 6.6396 | 92876.0 |
| 2009-09-22 08:25:00 | AAPL | Stock | 6.6393 | 6.6429 | 6.6375 | 6.6375 | 101500.0 |
| 2009-09-22 08:30:00 | AAPL | Stock | 6.6357 | 6.6382 | 6.6343 | 6.6343 | 65800.0 |
| 2009-09-22 08:35:00 | AAPL | Stock | 6.635 | 6.6368 | 6.6343 | 6.6357 | 91784.0 |
| 2009-09-22 08:40:00 | AAPL | Stock | 6.635 | 6.6357 | 6.6346 | 6.635 | 28000.0 |
| 2009-09-22 08:45:00 | AAPL | Stock | 6.6354 | 6.6354 | 6.6343 | 6.6343 | 30744.0 |
| 2009-09-22 08:50:00 | AAPL | Stock | 6.6321 | 6.6357 | 6.6293 | 6.6354 | 92400.0 |
| 2009-09-22 08:55:00 | AAPL | Stock | 6.6339 | 6.6357 | 6.6321 | 6.6336 | 133224.0 |
| 2009-09-22 09:00:00 | AAPL | Stock | 6.6336 | 6.6336 | 6.6293 | 6.6293 | 39200.0 |
| 2009-09-22 09:05:00 | AAPL | Stock | 6.6289 | 6.6336 | 6.6229 | 6.6336 | 218540.0 |
| 2009-09-22 09:10:00 | AAPL | Stock | 6.6321 | 6.6321 | 6.6279 | 6.6286 | 39760.0 |
| 2009-09-22 09:15:00 | AAPL | Stock | 6.6307 | 6.6307 | 6.6264 | 6.6307 | 70560.0 |
| 2009-09-22 09:20:00 | AAPL | Stock | 6.6318 | 6.6318 | 6.6268 | 6.6314 | 63392.0 |
| 2009-09-22 09:25:00 | AAPL | Stock | 6.6304 | 6.6318 | 6.6089 | 6.6125 | 776496.0 |
| 2009-09-22 09:30:00 | AAPL | Stock | 6.6136 | 6.6161 | 6.5882 | 6.6011 | 16918608.0 |
| 2009-09-22 09:35:00 | AAPL | Stock | 6.6004 | 6.6207 | 6.5882 | 6.6129 | 12892376.0 |
| 2009-09-22 09:40:00 | AAPL | Stock | 6.6137 | 6.6171 | 6.5754 | 6.5839 | 15175720.0 |
| 2009-09-22 09:45:00 | AAPL | Stock | 6.585 | 6.5857 | 6.5646 | 6.5736 | 11158952.0 |
| 2009-09-22 09:50:00 | AAPL | Stock | 6.5736 | 6.5925 | 6.5643 | 6.5907 | 8687000.0 |
| 2009-09-22 09:55:00 | AAPL | Stock | 6.5907 | 6.5907 | 6.5596 | 6.5636 | 9856924.0 |
| 2009-09-22 10:00:00 | AAPL | Stock | 6.5636 | 6.5768 | 6.5586 | 6.5721 | 7974792.0 |
| 2009-09-22 10:05:00 | AAPL | Stock | 6.5721 | 6.585 | 6.5711 | 6.5779 | 6826064.0 |
| 2009-09-22 10:10:00 | AAPL | Stock | 6.5779 | 6.5875 | 6.5746 | 6.5871 | 4667880.0 |
| 2009-09-22 10:15:00 | AAPL | Stock | 6.5886 | 6.5907 | 6.5768 | 6.5782 | 4464796.0 |
| 2009-09-22 10:20:00 | AAPL | Stock | 6.5775 | 6.5779 | 6.5618 | 6.5711 | 5262180.0 |
| 2009-09-22 10:25:00 | AAPL | Stock | 6.5711 | 6.5771 | 6.5589 | 6.56 | 5570012.0 |
| 2009-09-22 10:30:00 | AAPL | Stock | 6.56 | 6.5607 | 6.5304 | 6.5361 | 13122956.0 |
| 2009-09-22 10:35:00 | AAPL | Stock | 6.5366 | 6.5404 | 6.5325 | 6.5357 | 5614924.0 |
| 2009-09-22 10:40:00 | AAPL | Stock | 6.5354 | 6.5536 | 6.535 | 6.553 | 4785984.0 |
| 2009-09-22 10:45:00 | AAPL | Stock | 6.5529 | 6.5536 | 6.5407 | 6.5443 | 3236632.0 |
| 2009-09-22 10:50:00 | AAPL | Stock | 6.5446 | 6.5471 | 6.5368 | 6.5471 | 2012388.0 |
| 2009-09-22 10:55:00 | AAPL | Stock | 6.5471 | 6.5564 | 6.5471 | 6.5487 | 3664360.0 |
| 2009-09-22 11:00:00 | AAPL | Stock | 6.5493 | 6.5604 | 6.5486 | 6.5579 | 2030532.0 |
| 2009-09-22 11:05:00 | AAPL | Stock | 6.5575 | 6.5586 | 6.5536 | 6.5561 | 2511852.0 |
| 2009-09-22 11:10:00 | AAPL | Stock | 6.5563 | 6.5654 | 6.5507 | 6.565 | 2758392.0 |
> showing 50 of 321,880 rows — these rows as CSV