PREVIEW / stock_5min / 2009-03-20
file: by_date/stock_5min/2009/2009-03-20.parquet size: 4.4 MB rows: 307,591 symbols: 3,304
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-03-20 07:00:00 | AAPL | Stock | 3.5996 | 3.5996 | 3.5996 | 3.5996 | 2800.0 |
| 2009-03-20 08:00:00 | AAPL | Stock | 3.6079 | 3.6079 | 3.6079 | 3.6079 | 2800.0 |
| 2009-03-20 08:05:00 | AAPL | Stock | 3.6304 | 3.6304 | 3.6179 | 3.6179 | 18144.0 |
| 2009-03-20 08:15:00 | AAPL | Stock | 3.61 | 3.61 | 3.6025 | 3.6025 | 33544.0 |
| 2009-03-20 08:20:00 | AAPL | Stock | 3.6054 | 3.6143 | 3.6025 | 3.6143 | 46480.0 |
| 2009-03-20 08:25:00 | AAPL | Stock | 3.6179 | 3.6179 | 3.6179 | 3.6179 | 16800.0 |
| 2009-03-20 08:30:00 | AAPL | Stock | 3.6211 | 3.6211 | 3.6211 | 3.6211 | 2800.0 |
| 2009-03-20 08:35:00 | AAPL | Stock | 3.6179 | 3.6243 | 3.6179 | 3.6243 | 28000.0 |
| 2009-03-20 08:40:00 | AAPL | Stock | 3.6254 | 3.6268 | 3.6254 | 3.6268 | 53200.0 |
| 2009-03-20 08:45:00 | AAPL | Stock | 3.6232 | 3.6232 | 3.6232 | 3.6232 | 5656.0 |
| 2009-03-20 08:55:00 | AAPL | Stock | 3.6232 | 3.6232 | 3.6232 | 3.6232 | 14000.0 |
| 2009-03-20 09:00:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6214 | 3.6214 | 2800.0 |
| 2009-03-20 09:05:00 | AAPL | Stock | 3.625 | 3.625 | 3.6196 | 3.6196 | 54740.0 |
| 2009-03-20 09:10:00 | AAPL | Stock | 3.6204 | 3.6211 | 3.6204 | 3.6204 | 25200.0 |
| 2009-03-20 09:15:00 | AAPL | Stock | 3.6236 | 3.6236 | 3.6236 | 3.6236 | 19600.0 |
| 2009-03-20 09:20:00 | AAPL | Stock | 3.6236 | 3.625 | 3.6236 | 3.6236 | 19600.0 |
| 2009-03-20 09:25:00 | AAPL | Stock | 3.625 | 3.645 | 3.6236 | 3.6429 | 1507660.0 |
| 2009-03-20 09:30:00 | AAPL | Stock | 3.6429 | 3.6625 | 3.6332 | 3.6575 | 17265164.0 |
| 2009-03-20 09:35:00 | AAPL | Stock | 3.6571 | 3.6671 | 3.6464 | 3.6546 | 13513108.0 |
| 2009-03-20 09:40:00 | AAPL | Stock | 3.6543 | 3.6561 | 3.6361 | 3.6454 | 12070324.0 |
| 2009-03-20 09:45:00 | AAPL | Stock | 3.6454 | 3.6714 | 3.6432 | 3.6636 | 13502608.0 |
| 2009-03-20 09:50:00 | AAPL | Stock | 3.6636 | 3.6825 | 3.6614 | 3.6732 | 19750976.0 |
| 2009-03-20 09:55:00 | AAPL | Stock | 3.6739 | 3.6786 | 3.6632 | 3.665 | 8824004.0 |
| 2009-03-20 10:00:00 | AAPL | Stock | 3.6657 | 3.6711 | 3.6625 | 3.6632 | 5739496.0 |
| 2009-03-20 10:05:00 | AAPL | Stock | 3.6639 | 3.6661 | 3.6525 | 3.6599 | 11241496.0 |
| 2009-03-20 10:10:00 | AAPL | Stock | 3.6611 | 3.6639 | 3.65 | 3.6554 | 6501768.0 |
| 2009-03-20 10:15:00 | AAPL | Stock | 3.6554 | 3.6668 | 3.6514 | 3.6525 | 5229476.0 |
| 2009-03-20 10:20:00 | AAPL | Stock | 3.6525 | 3.6554 | 3.6418 | 3.65 | 8531376.0 |
| 2009-03-20 10:25:00 | AAPL | Stock | 3.6479 | 3.6625 | 3.6454 | 3.6614 | 8017996.0 |
| 2009-03-20 10:30:00 | AAPL | Stock | 3.6614 | 3.6639 | 3.6556 | 3.6625 | 4822832.0 |
| 2009-03-20 10:35:00 | AAPL | Stock | 3.6625 | 3.6643 | 3.6582 | 3.6639 | 4498956.0 |
| 2009-03-20 10:40:00 | AAPL | Stock | 3.6639 | 3.6771 | 3.6618 | 3.6714 | 6484240.0 |
| 2009-03-20 10:45:00 | AAPL | Stock | 3.6714 | 3.6782 | 3.67 | 3.6732 | 5077856.0 |
| 2009-03-20 10:50:00 | AAPL | Stock | 3.6732 | 3.6775 | 3.6625 | 3.6771 | 6588988.0 |
| 2009-03-20 10:55:00 | AAPL | Stock | 3.6768 | 3.6786 | 3.6721 | 3.6757 | 7018788.0 |
| 2009-03-20 11:00:00 | AAPL | Stock | 3.6757 | 3.6764 | 3.6643 | 3.6654 | 5963496.0 |
| 2009-03-20 11:05:00 | AAPL | Stock | 3.6654 | 3.6693 | 3.6589 | 3.66 | 5613524.0 |
| 2009-03-20 11:10:00 | AAPL | Stock | 3.6594 | 3.6618 | 3.6539 | 3.6586 | 5013512.0 |
| 2009-03-20 11:15:00 | AAPL | Stock | 3.6586 | 3.66 | 3.6518 | 3.6554 | 5149060.0 |
| 2009-03-20 11:20:00 | AAPL | Stock | 3.6554 | 3.6564 | 3.6414 | 3.6429 | 6302856.0 |
| 2009-03-20 11:25:00 | AAPL | Stock | 3.6425 | 3.6546 | 3.6418 | 3.6532 | 7836528.0 |
| 2009-03-20 11:30:00 | AAPL | Stock | 3.6532 | 3.6654 | 3.6518 | 3.6612 | 7170604.0 |
| 2009-03-20 11:35:00 | AAPL | Stock | 3.6611 | 3.6657 | 3.6611 | 3.6632 | 3510472.0 |
| 2009-03-20 11:40:00 | AAPL | Stock | 3.6632 | 3.6689 | 3.6625 | 3.6661 | 3757488.0 |
| 2009-03-20 11:45:00 | AAPL | Stock | 3.6661 | 3.6696 | 3.6604 | 3.6664 | 4406332.0 |
| 2009-03-20 11:50:00 | AAPL | Stock | 3.6664 | 3.67 | 3.6632 | 3.6696 | 4331124.0 |
| 2009-03-20 11:55:00 | AAPL | Stock | 3.67 | 3.67 | 3.6625 | 3.6657 | 3399928.0 |
| 2009-03-20 12:00:00 | AAPL | Stock | 3.6655 | 3.6696 | 3.6629 | 3.6636 | 2638272.0 |
| 2009-03-20 12:05:00 | AAPL | Stock | 3.6639 | 3.6721 | 3.6621 | 3.6661 | 4188380.0 |
| 2009-03-20 12:10:00 | AAPL | Stock | 3.6661 | 3.6721 | 3.665 | 3.6696 | 4517268.0 |
> showing 50 of 307,591 rows — these rows as CSV