PREVIEW / stock_5min / 2005-08-16
file: by_date/stock_5min/2005/2005-08-16.parquet size: 2.8 MB rows: 203,000 symbols: 2,057
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-16 08:00:00 | AAPL | Stock | 1.7043 | 1.7043 | 1.6964 | 1.6964 | 28000.0 |
| 2005-08-16 08:05:00 | AAPL | Stock | 1.6964 | 1.7 | 1.6964 | 1.7 | 42000.0 |
| 2005-08-16 08:10:00 | AAPL | Stock | 1.7 | 1.7018 | 1.7 | 1.7018 | 28420.0 |
| 2005-08-16 08:15:00 | AAPL | Stock | 1.6989 | 1.6989 | 1.6964 | 1.6964 | 133280.0 |
| 2005-08-16 08:20:00 | AAPL | Stock | 1.6971 | 1.6971 | 1.6954 | 1.6964 | 151200.0 |
| 2005-08-16 08:25:00 | AAPL | Stock | 1.6954 | 1.6961 | 1.6929 | 1.6961 | 113680.0 |
| 2005-08-16 08:30:00 | AAPL | Stock | 1.6932 | 1.695 | 1.6929 | 1.6932 | 89320.0 |
| 2005-08-16 08:35:00 | AAPL | Stock | 1.695 | 1.695 | 1.6911 | 1.6929 | 91840.0 |
| 2005-08-16 08:40:00 | AAPL | Stock | 1.6929 | 1.6929 | 1.6925 | 1.6925 | 48160.0 |
| 2005-08-16 08:45:00 | AAPL | Stock | 1.6914 | 1.6914 | 1.6893 | 1.6893 | 47600.0 |
| 2005-08-16 08:50:00 | AAPL | Stock | 1.6911 | 1.6925 | 1.6911 | 1.6925 | 67200.0 |
| 2005-08-16 08:55:00 | AAPL | Stock | 1.6929 | 1.6932 | 1.6929 | 1.6932 | 19600.0 |
| 2005-08-16 09:00:00 | AAPL | Stock | 1.6932 | 1.6932 | 1.6918 | 1.6918 | 44800.0 |
| 2005-08-16 09:05:00 | AAPL | Stock | 1.6925 | 1.6925 | 1.6921 | 1.6921 | 36400.0 |
| 2005-08-16 09:10:00 | AAPL | Stock | 1.6911 | 1.6929 | 1.6911 | 1.6911 | 14280.0 |
| 2005-08-16 09:15:00 | AAPL | Stock | 1.6932 | 1.6932 | 1.6932 | 1.6932 | 4116.0 |
| 2005-08-16 09:20:00 | AAPL | Stock | 1.6925 | 1.6925 | 1.6911 | 1.6925 | 53480.0 |
| 2005-08-16 09:25:00 | AAPL | Stock | 1.6954 | 1.6957 | 1.6925 | 1.6932 | 574336.0 |
| 2005-08-16 09:30:00 | AAPL | Stock | 1.6925 | 1.6946 | 1.6836 | 1.6889 | 24687460.0 |
| 2005-08-16 09:35:00 | AAPL | Stock | 1.6886 | 1.6946 | 1.6875 | 1.6886 | 13671504.0 |
| 2005-08-16 09:40:00 | AAPL | Stock | 1.6882 | 1.6929 | 1.6864 | 1.6904 | 10301872.0 |
| 2005-08-16 09:45:00 | AAPL | Stock | 1.6904 | 1.6961 | 1.69 | 1.6957 | 12267220.0 |
| 2005-08-16 09:50:00 | AAPL | Stock | 1.6954 | 1.6964 | 1.69 | 1.6907 | 15823052.0 |
| 2005-08-16 09:55:00 | AAPL | Stock | 1.6911 | 1.6911 | 1.6882 | 1.69 | 7155680.0 |
| 2005-08-16 10:00:00 | AAPL | Stock | 1.6896 | 1.6911 | 1.6857 | 1.6879 | 10187072.0 |
| 2005-08-16 10:05:00 | AAPL | Stock | 1.6875 | 1.6911 | 1.6864 | 1.6868 | 5864880.0 |
| 2005-08-16 10:10:00 | AAPL | Stock | 1.6871 | 1.6875 | 1.6789 | 1.68 | 14783888.0 |
| 2005-08-16 10:15:00 | AAPL | Stock | 1.6796 | 1.6836 | 1.6793 | 1.6807 | 9684556.0 |
| 2005-08-16 10:20:00 | AAPL | Stock | 1.6804 | 1.6807 | 1.6721 | 1.6775 | 18311664.0 |
| 2005-08-16 10:25:00 | AAPL | Stock | 1.6771 | 1.6782 | 1.6746 | 1.6775 | 6713000.0 |
| 2005-08-16 10:30:00 | AAPL | Stock | 1.6771 | 1.6814 | 1.6732 | 1.6732 | 12129152.0 |
| 2005-08-16 10:35:00 | AAPL | Stock | 1.6732 | 1.6814 | 1.6718 | 1.6743 | 7779128.0 |
| 2005-08-16 10:40:00 | AAPL | Stock | 1.6743 | 1.6746 | 1.6682 | 1.6689 | 10101392.0 |
| 2005-08-16 10:45:00 | AAPL | Stock | 1.6686 | 1.6711 | 1.6643 | 1.6657 | 14144900.0 |
| 2005-08-16 10:50:00 | AAPL | Stock | 1.6657 | 1.6689 | 1.6646 | 1.6671 | 8685152.0 |
| 2005-08-16 10:55:00 | AAPL | Stock | 1.6675 | 1.6732 | 1.6632 | 1.6725 | 15128400.0 |
| 2005-08-16 11:00:00 | AAPL | Stock | 1.6725 | 1.6736 | 1.6686 | 1.6729 | 9264388.0 |
| 2005-08-16 11:05:00 | AAPL | Stock | 1.6732 | 1.6746 | 1.67 | 1.6729 | 6813100.0 |
| 2005-08-16 11:10:00 | AAPL | Stock | 1.6729 | 1.6739 | 1.6707 | 1.6707 | 3261664.0 |
| 2005-08-16 11:15:00 | AAPL | Stock | 1.6707 | 1.6721 | 1.6679 | 1.6721 | 4312112.0 |
| 2005-08-16 11:20:00 | AAPL | Stock | 1.6725 | 1.6786 | 1.6718 | 1.6764 | 6080368.0 |
| 2005-08-16 11:25:00 | AAPL | Stock | 1.6761 | 1.6764 | 1.6718 | 1.675 | 5260416.0 |
| 2005-08-16 11:30:00 | AAPL | Stock | 1.675 | 1.6764 | 1.6729 | 1.6732 | 3922072.0 |
| 2005-08-16 11:35:00 | AAPL | Stock | 1.6732 | 1.6739 | 1.6704 | 1.6729 | 4551736.0 |
| 2005-08-16 11:40:00 | AAPL | Stock | 1.6729 | 1.675 | 1.6721 | 1.6729 | 5701248.0 |
| 2005-08-16 11:45:00 | AAPL | Stock | 1.6729 | 1.6732 | 1.67 | 1.6704 | 3871448.0 |
| 2005-08-16 11:50:00 | AAPL | Stock | 1.6707 | 1.6721 | 1.6704 | 1.6711 | 5043556.0 |
| 2005-08-16 11:55:00 | AAPL | Stock | 1.6714 | 1.6721 | 1.6707 | 1.6721 | 6259484.0 |
| 2005-08-16 12:00:00 | AAPL | Stock | 1.6721 | 1.6729 | 1.6693 | 1.6714 | 4084052.0 |
| 2005-08-16 12:05:00 | AAPL | Stock | 1.6718 | 1.6718 | 1.6707 | 1.6714 | 6631772.0 |
> showing 50 of 203,000 rows — these rows as CSV