PREVIEW / stock_5min / 2006-01-04
file: by_date/stock_5min/2006/2006-01-04.parquet size: 3.0 MB rows: 218,093 symbols: 2,175
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-04 07:00:00 | AAPL | Stock | 2.6696 | 2.6696 | 2.6696 | 2.6696 | 2800.0 |
| 2006-01-04 07:55:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 14000.0 |
| 2006-01-04 08:00:00 | AAPL | Stock | 2.6779 | 2.6789 | 2.67 | 2.6786 | 624204.0 |
| 2006-01-04 08:05:00 | AAPL | Stock | 2.68 | 2.6857 | 2.6786 | 2.6839 | 232288.0 |
| 2006-01-04 08:10:00 | AAPL | Stock | 2.6804 | 2.6836 | 2.6796 | 2.6796 | 208600.0 |
| 2006-01-04 08:15:00 | AAPL | Stock | 2.6807 | 2.6829 | 2.6789 | 2.6804 | 240128.0 |
| 2006-01-04 08:20:00 | AAPL | Stock | 2.6793 | 2.68 | 2.675 | 2.6779 | 230860.0 |
| 2006-01-04 08:25:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6761 | 2.6786 | 67200.0 |
| 2006-01-04 08:30:00 | AAPL | Stock | 2.6779 | 2.6779 | 2.6732 | 2.6732 | 125300.0 |
| 2006-01-04 08:35:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6729 | 2.6771 | 91896.0 |
| 2006-01-04 08:40:00 | AAPL | Stock | 2.675 | 2.6821 | 2.675 | 2.68 | 480508.0 |
| 2006-01-04 08:45:00 | AAPL | Stock | 2.68 | 2.68 | 2.6779 | 2.6779 | 248948.0 |
| 2006-01-04 08:50:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6771 | 2.6786 | 133420.0 |
| 2006-01-04 08:55:00 | AAPL | Stock | 2.6771 | 2.6789 | 2.6768 | 2.6789 | 314328.0 |
| 2006-01-04 09:00:00 | AAPL | Stock | 2.6786 | 2.68 | 2.6786 | 2.6786 | 227920.0 |
| 2006-01-04 09:05:00 | AAPL | Stock | 2.6775 | 2.6786 | 2.6754 | 2.6782 | 219772.0 |
| 2006-01-04 09:10:00 | AAPL | Stock | 2.6782 | 2.6793 | 2.6771 | 2.6793 | 183064.0 |
| 2006-01-04 09:15:00 | AAPL | Stock | 2.6786 | 2.6796 | 2.6786 | 2.6786 | 92400.0 |
| 2006-01-04 09:20:00 | AAPL | Stock | 2.6782 | 2.6782 | 2.6725 | 2.6754 | 151508.0 |
| 2006-01-04 09:25:00 | AAPL | Stock | 2.6736 | 2.6868 | 2.6736 | 2.6832 | 2218888.0 |
| 2006-01-04 09:30:00 | AAPL | Stock | 2.6832 | 2.7136 | 2.6771 | 2.6979 | 43814960.0 |
| 2006-01-04 09:35:00 | AAPL | Stock | 2.6982 | 2.7032 | 2.6793 | 2.6936 | 34870556.0 |
| 2006-01-04 09:40:00 | AAPL | Stock | 2.6936 | 2.7032 | 2.6918 | 2.6946 | 22584744.0 |
| 2006-01-04 09:45:00 | AAPL | Stock | 2.6943 | 2.6954 | 2.6829 | 2.6868 | 15649704.0 |
| 2006-01-04 09:50:00 | AAPL | Stock | 2.6871 | 2.6918 | 2.6821 | 2.6882 | 12852868.0 |
| 2006-01-04 09:55:00 | AAPL | Stock | 2.6875 | 2.69 | 2.6775 | 2.6786 | 10814272.0 |
| 2006-01-04 10:00:00 | AAPL | Stock | 2.6786 | 2.6946 | 2.6782 | 2.6929 | 14297528.0 |
| 2006-01-04 10:05:00 | AAPL | Stock | 2.6921 | 2.6939 | 2.6829 | 2.6836 | 9238908.0 |
| 2006-01-04 10:10:00 | AAPL | Stock | 2.6839 | 2.689 | 2.6736 | 2.6786 | 18244912.0 |
| 2006-01-04 10:15:00 | AAPL | Stock | 2.6789 | 2.6793 | 2.665 | 2.6704 | 18541684.0 |
| 2006-01-04 10:20:00 | AAPL | Stock | 2.6704 | 2.68 | 2.6671 | 2.675 | 18791472.0 |
| 2006-01-04 10:25:00 | AAPL | Stock | 2.675 | 2.6757 | 2.6693 | 2.6718 | 9466156.0 |
| 2006-01-04 10:30:00 | AAPL | Stock | 2.6718 | 2.6821 | 2.6714 | 2.6811 | 8309784.0 |
| 2006-01-04 10:35:00 | AAPL | Stock | 2.681 | 2.6821 | 2.6757 | 2.6779 | 7858284.0 |
| 2006-01-04 10:40:00 | AAPL | Stock | 2.6782 | 2.6789 | 2.6632 | 2.6636 | 13558944.0 |
| 2006-01-04 10:45:00 | AAPL | Stock | 2.6632 | 2.6729 | 2.6607 | 2.6711 | 14265188.0 |
| 2006-01-04 10:50:00 | AAPL | Stock | 2.6711 | 2.6732 | 2.665 | 2.6689 | 6065276.0 |
| 2006-01-04 10:55:00 | AAPL | Stock | 2.6689 | 2.6754 | 2.6686 | 2.6725 | 6696536.0 |
| 2006-01-04 11:00:00 | AAPL | Stock | 2.6725 | 2.6739 | 2.6661 | 2.6714 | 4954852.0 |
| 2006-01-04 11:05:00 | AAPL | Stock | 2.6718 | 2.6732 | 2.6679 | 2.6696 | 3702384.0 |
| 2006-01-04 11:10:00 | AAPL | Stock | 2.67 | 2.67 | 2.6643 | 2.6679 | 5610836.0 |
| 2006-01-04 11:15:00 | AAPL | Stock | 2.6679 | 2.6779 | 2.6671 | 2.6746 | 6150144.0 |
| 2006-01-04 11:20:00 | AAPL | Stock | 2.6743 | 2.6793 | 2.6743 | 2.6789 | 7524664.0 |
| 2006-01-04 11:25:00 | AAPL | Stock | 2.6789 | 2.6818 | 2.6755 | 2.68 | 6380724.0 |
| 2006-01-04 11:30:00 | AAPL | Stock | 2.6804 | 2.6814 | 2.6775 | 2.6789 | 5155724.0 |
| 2006-01-04 11:35:00 | AAPL | Stock | 2.6786 | 2.68 | 2.6739 | 2.6775 | 4250764.0 |
| 2006-01-04 11:40:00 | AAPL | Stock | 2.6775 | 2.6814 | 2.6746 | 2.6806 | 4235728.0 |
| 2006-01-04 11:45:00 | AAPL | Stock | 2.6807 | 2.6839 | 2.6789 | 2.6829 | 6811560.0 |
| 2006-01-04 11:50:00 | AAPL | Stock | 2.6829 | 2.6893 | 2.6821 | 2.6846 | 8105216.0 |
| 2006-01-04 11:55:00 | AAPL | Stock | 2.685 | 2.6857 | 2.6811 | 2.6843 | 5563544.0 |
> showing 50 of 218,093 rows — these rows as CSV