PREVIEW / stock_5min / 2009-08-26
file: by_date/stock_5min/2009/2009-08-26.parquet size: 4.5 MB rows: 312,209 symbols: 3,367
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-08-26 04:20:00 | AAPL | Stock | 6.0696 | 6.0696 | 6.0696 | 6.0696 | 2800.0 |
| 2009-08-26 06:55:00 | AAPL | Stock | 6.0536 | 6.0536 | 6.0536 | 6.0536 | 2800.0 |
| 2009-08-26 07:30:00 | AAPL | Stock | 6.0375 | 6.0529 | 6.0357 | 6.0357 | 55888.0 |
| 2009-08-26 07:35:00 | AAPL | Stock | 6.0346 | 6.0346 | 6.0346 | 6.0346 | 2800.0 |
| 2009-08-26 07:40:00 | AAPL | Stock | 6.0368 | 6.0368 | 6.0368 | 6.0368 | 2800.0 |
| 2009-08-26 07:50:00 | AAPL | Stock | 6.0371 | 6.0371 | 6.0371 | 6.0371 | 53172.0 |
| 2009-08-26 07:55:00 | AAPL | Stock | 6.0504 | 6.0504 | 6.0504 | 6.0504 | 2800.0 |
| 2009-08-26 08:00:00 | AAPL | Stock | 6.0375 | 6.05 | 6.0375 | 6.0411 | 41132.0 |
| 2009-08-26 08:05:00 | AAPL | Stock | 6.0407 | 6.0407 | 6.0382 | 6.0382 | 67872.0 |
| 2009-08-26 08:10:00 | AAPL | Stock | 6.0432 | 6.0432 | 6.0432 | 6.0432 | 2800.0 |
| 2009-08-26 08:15:00 | AAPL | Stock | 6.0411 | 6.0429 | 6.0411 | 6.0429 | 14728.0 |
| 2009-08-26 08:20:00 | AAPL | Stock | 6.0436 | 6.0436 | 6.0436 | 6.0436 | 3500.0 |
| 2009-08-26 08:25:00 | AAPL | Stock | 6.0464 | 6.0514 | 6.0464 | 6.0514 | 40852.0 |
| 2009-08-26 08:30:00 | AAPL | Stock | 6.0464 | 6.0514 | 6.0429 | 6.045 | 99372.0 |
| 2009-08-26 08:35:00 | AAPL | Stock | 6.0446 | 6.0446 | 6.0429 | 6.0429 | 33600.0 |
| 2009-08-26 08:40:00 | AAPL | Stock | 6.045 | 6.0514 | 6.045 | 6.0514 | 25620.0 |
| 2009-08-26 08:45:00 | AAPL | Stock | 6.0489 | 6.0489 | 6.0489 | 6.0489 | 4200.0 |
| 2009-08-26 08:50:00 | AAPL | Stock | 6.0482 | 6.05 | 6.0482 | 6.05 | 16800.0 |
| 2009-08-26 08:55:00 | AAPL | Stock | 6.05 | 6.05 | 6.0457 | 6.0482 | 77616.0 |
| 2009-08-26 09:00:00 | AAPL | Stock | 6.0482 | 6.0482 | 6.0464 | 6.0464 | 5600.0 |
| 2009-08-26 09:05:00 | AAPL | Stock | 6.0432 | 6.0457 | 6.0429 | 6.0457 | 18200.0 |
| 2009-08-26 09:10:00 | AAPL | Stock | 6.0439 | 6.0482 | 6.0411 | 6.0432 | 148736.0 |
| 2009-08-26 09:15:00 | AAPL | Stock | 6.0446 | 6.0446 | 6.0446 | 6.0446 | 2800.0 |
| 2009-08-26 09:20:00 | AAPL | Stock | 6.0421 | 6.0421 | 6.0421 | 6.0421 | 8400.0 |
| 2009-08-26 09:25:00 | AAPL | Stock | 6.0421 | 6.0432 | 6.0332 | 6.0346 | 216468.0 |
| 2009-08-26 09:30:00 | AAPL | Stock | 6.0329 | 6.0529 | 6.0236 | 6.0412 | 6265644.0 |
| 2009-08-26 09:35:00 | AAPL | Stock | 6.0414 | 6.0482 | 6.0232 | 6.0482 | 5557328.0 |
| 2009-08-26 09:40:00 | AAPL | Stock | 6.0481 | 6.0554 | 6.0446 | 6.0489 | 5838252.0 |
| 2009-08-26 09:45:00 | AAPL | Stock | 6.0479 | 6.0536 | 6.0336 | 6.0336 | 5637324.0 |
| 2009-08-26 09:50:00 | AAPL | Stock | 6.0339 | 6.0368 | 6.025 | 6.0364 | 5101824.0 |
| 2009-08-26 09:55:00 | AAPL | Stock | 6.0364 | 6.0393 | 6.0286 | 6.0354 | 3701376.0 |
| 2009-08-26 10:00:00 | AAPL | Stock | 6.0343 | 6.0454 | 6.0232 | 6.03 | 9757720.0 |
| 2009-08-26 10:05:00 | AAPL | Stock | 6.0304 | 6.0404 | 6.0236 | 6.0279 | 6686932.0 |
| 2009-08-26 10:10:00 | AAPL | Stock | 6.0282 | 6.0446 | 6.0218 | 6.0396 | 5644464.0 |
| 2009-08-26 10:15:00 | AAPL | Stock | 6.0396 | 6.05 | 6.0389 | 6.0418 | 5580652.0 |
| 2009-08-26 10:20:00 | AAPL | Stock | 6.0421 | 6.0471 | 6.0339 | 6.0357 | 3631572.0 |
| 2009-08-26 10:25:00 | AAPL | Stock | 6.0357 | 6.0375 | 6.0286 | 6.0348 | 3918964.0 |
| 2009-08-26 10:30:00 | AAPL | Stock | 6.0346 | 6.0446 | 6.0296 | 6.0393 | 2974384.0 |
| 2009-08-26 10:35:00 | AAPL | Stock | 6.0393 | 6.0443 | 6.0314 | 6.0368 | 3312064.0 |
| 2009-08-26 10:40:00 | AAPL | Stock | 6.0364 | 6.0364 | 6.025 | 6.0254 | 3187772.0 |
| 2009-08-26 10:45:00 | AAPL | Stock | 6.0257 | 6.0295 | 6.0196 | 6.0216 | 4004028.0 |
| 2009-08-26 10:50:00 | AAPL | Stock | 6.0211 | 6.0264 | 6.02 | 6.0243 | 2987460.0 |
| 2009-08-26 10:55:00 | AAPL | Stock | 6.0243 | 6.0243 | 6.0143 | 6.0211 | 3897964.0 |
| 2009-08-26 11:00:00 | AAPL | Stock | 6.0204 | 6.0239 | 6.0118 | 6.0129 | 3134292.0 |
| 2009-08-26 11:05:00 | AAPL | Stock | 6.0125 | 6.0132 | 5.9918 | 5.9921 | 8250172.0 |
| 2009-08-26 11:10:00 | AAPL | Stock | 5.9925 | 5.9952 | 5.9836 | 5.9896 | 6904380.0 |
| 2009-08-26 11:15:00 | AAPL | Stock | 5.9889 | 5.9911 | 5.9829 | 5.9875 | 4718532.0 |
| 2009-08-26 11:20:00 | AAPL | Stock | 5.9874 | 5.9896 | 5.9675 | 5.9711 | 7239596.0 |
| 2009-08-26 11:25:00 | AAPL | Stock | 5.9714 | 5.98 | 5.9693 | 5.9765 | 4021276.0 |
| 2009-08-26 11:30:00 | AAPL | Stock | 5.9771 | 5.9779 | 5.9704 | 5.9764 | 3461556.0 |
> showing 50 of 312,209 rows — these rows as CSV