PREVIEW / stock_5min / 2007-05-07
file: by_date/stock_5min/2007/2007-05-07.parquet size: 3.8 MB rows: 279,233 symbols: 2,723
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-07 09:30:00 | AAPL | Stock | 3.61 | 3.6429 | 3.6075 | 3.6143 | 14563304.0 |
| 2007-05-07 09:35:00 | AAPL | Stock | 3.6143 | 3.6161 | 3.6121 | 3.6143 | 5906376.0 |
| 2007-05-07 09:40:00 | AAPL | Stock | 3.615 | 3.6179 | 3.6107 | 3.6154 | 6459432.0 |
| 2007-05-07 09:45:00 | AAPL | Stock | 3.615 | 3.6207 | 3.6129 | 3.6182 | 6800024.0 |
| 2007-05-07 09:50:00 | AAPL | Stock | 3.6182 | 3.6304 | 3.6146 | 3.6186 | 19254648.0 |
| 2007-05-07 09:55:00 | AAPL | Stock | 3.6189 | 3.6268 | 3.6161 | 3.625 | 8828708.0 |
| 2007-05-07 10:00:00 | AAPL | Stock | 3.6254 | 3.6268 | 3.6168 | 3.6211 | 6775664.0 |
| 2007-05-07 10:05:00 | AAPL | Stock | 3.6211 | 3.6261 | 3.62 | 3.625 | 5569564.0 |
| 2007-05-07 10:10:00 | AAPL | Stock | 3.625 | 3.625 | 3.6196 | 3.6218 | 7122080.0 |
| 2007-05-07 10:15:00 | AAPL | Stock | 3.6218 | 3.625 | 3.6214 | 3.6236 | 6747132.0 |
| 2007-05-07 10:20:00 | AAPL | Stock | 3.6236 | 3.6393 | 3.6232 | 3.6379 | 19501580.0 |
| 2007-05-07 10:25:00 | AAPL | Stock | 3.6379 | 3.6404 | 3.6311 | 3.6364 | 12396440.0 |
| 2007-05-07 10:30:00 | AAPL | Stock | 3.6368 | 3.6386 | 3.6311 | 3.635 | 6489700.0 |
| 2007-05-07 10:35:00 | AAPL | Stock | 3.635 | 3.65 | 3.6343 | 3.6492 | 29198428.0 |
| 2007-05-07 10:40:00 | AAPL | Stock | 3.6486 | 3.6629 | 3.6486 | 3.6621 | 33248880.0 |
| 2007-05-07 10:45:00 | AAPL | Stock | 3.6621 | 3.6629 | 3.6536 | 3.6557 | 15686776.0 |
| 2007-05-07 10:50:00 | AAPL | Stock | 3.6557 | 3.6725 | 3.6554 | 3.6714 | 21372820.0 |
| 2007-05-07 10:55:00 | AAPL | Stock | 3.6714 | 3.6743 | 3.6661 | 3.6679 | 17970848.0 |
| 2007-05-07 11:00:00 | AAPL | Stock | 3.6682 | 3.6779 | 3.6679 | 3.6736 | 13573448.0 |
| 2007-05-07 11:05:00 | AAPL | Stock | 3.6743 | 3.6746 | 3.6682 | 3.6704 | 10416588.0 |
| 2007-05-07 11:10:00 | AAPL | Stock | 3.6704 | 3.6725 | 3.6661 | 3.6671 | 7303408.0 |
| 2007-05-07 11:15:00 | AAPL | Stock | 3.6679 | 3.6686 | 3.6636 | 3.6657 | 6426420.0 |
| 2007-05-07 11:20:00 | AAPL | Stock | 3.6657 | 3.6754 | 3.6654 | 3.6746 | 6259624.0 |
| 2007-05-07 11:25:00 | AAPL | Stock | 3.6743 | 3.6782 | 3.6704 | 3.6729 | 8223096.0 |
| 2007-05-07 11:30:00 | AAPL | Stock | 3.6725 | 3.6821 | 3.6718 | 3.6804 | 13298740.0 |
| 2007-05-07 11:35:00 | AAPL | Stock | 3.6804 | 3.6846 | 3.6768 | 3.6821 | 15276184.0 |
| 2007-05-07 11:40:00 | AAPL | Stock | 3.6829 | 3.6832 | 3.6736 | 3.6804 | 9104676.0 |
| 2007-05-07 11:45:00 | AAPL | Stock | 3.6804 | 3.6868 | 3.6768 | 3.6768 | 10173800.0 |
| 2007-05-07 11:50:00 | AAPL | Stock | 3.6771 | 3.6789 | 3.6704 | 3.6786 | 8302308.0 |
| 2007-05-07 11:55:00 | AAPL | Stock | 3.6782 | 3.6832 | 3.6772 | 3.6811 | 7923832.0 |
| 2007-05-07 12:00:00 | AAPL | Stock | 3.6814 | 3.6839 | 3.6789 | 3.6807 | 4571980.0 |
| 2007-05-07 12:05:00 | AAPL | Stock | 3.6807 | 3.6821 | 3.6761 | 3.6764 | 4898684.0 |
| 2007-05-07 12:10:00 | AAPL | Stock | 3.6768 | 3.6804 | 3.6736 | 3.6796 | 3901464.0 |
| 2007-05-07 12:15:00 | AAPL | Stock | 3.6796 | 3.6821 | 3.6779 | 3.6789 | 5276656.0 |
| 2007-05-07 12:20:00 | AAPL | Stock | 3.6789 | 3.6871 | 3.6789 | 3.687 | 8612940.0 |
| 2007-05-07 12:25:00 | AAPL | Stock | 3.6868 | 3.6868 | 3.6821 | 3.6827 | 9519636.0 |
| 2007-05-07 12:30:00 | AAPL | Stock | 3.6821 | 3.6825 | 3.6732 | 3.675 | 12684140.0 |
| 2007-05-07 12:35:00 | AAPL | Stock | 3.675 | 3.6771 | 3.6721 | 3.6731 | 6004824.0 |
| 2007-05-07 12:40:00 | AAPL | Stock | 3.6721 | 3.6725 | 3.6646 | 3.6689 | 11451440.0 |
| 2007-05-07 12:45:00 | AAPL | Stock | 3.6689 | 3.6736 | 3.6686 | 3.6721 | 5011412.0 |
| 2007-05-07 12:50:00 | AAPL | Stock | 3.6722 | 3.6761 | 3.6721 | 3.6757 | 3833424.0 |
| 2007-05-07 12:55:00 | AAPL | Stock | 3.6757 | 3.6764 | 3.6743 | 3.6761 | 1958236.0 |
| 2007-05-07 13:00:00 | AAPL | Stock | 3.6761 | 3.6782 | 3.675 | 3.6775 | 2800672.0 |
| 2007-05-07 13:05:00 | AAPL | Stock | 3.6779 | 3.6793 | 3.6771 | 3.6789 | 2794708.0 |
| 2007-05-07 13:10:00 | AAPL | Stock | 3.6789 | 3.6804 | 3.6768 | 3.6768 | 3753008.0 |
| 2007-05-07 13:15:00 | AAPL | Stock | 3.6771 | 3.6771 | 3.6721 | 3.6742 | 3519796.0 |
| 2007-05-07 13:20:00 | AAPL | Stock | 3.6736 | 3.6736 | 3.6629 | 3.6657 | 6382684.0 |
| 2007-05-07 13:25:00 | AAPL | Stock | 3.6655 | 3.67 | 3.6646 | 3.6696 | 3017392.0 |
| 2007-05-07 13:30:00 | AAPL | Stock | 3.6696 | 3.6725 | 3.6682 | 3.6707 | 3485608.0 |
| 2007-05-07 13:35:00 | AAPL | Stock | 3.6707 | 3.6721 | 3.6679 | 3.6686 | 2988216.0 |
> showing 50 of 279,233 rows — these rows as CSV