PREVIEW / stock_5min / 2007-08-22
file: by_date/stock_5min/2007/2007-08-22.parquet size: 4.1 MB rows: 302,038 symbols: 3,111
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-08-22 09:30:00 | AAPL | Stock | 4.6864 | 4.7254 | 4.6739 | 4.7125 | 67235644.0 |
| 2007-08-22 09:35:00 | AAPL | Stock | 4.7132 | 4.7368 | 4.6968 | 4.7061 | 41792940.0 |
| 2007-08-22 09:40:00 | AAPL | Stock | 4.7057 | 4.72 | 4.6921 | 4.705 | 28111048.0 |
| 2007-08-22 09:45:00 | AAPL | Stock | 4.7036 | 4.7064 | 4.6871 | 4.6942 | 26009284.0 |
| 2007-08-22 09:50:00 | AAPL | Stock | 4.6954 | 4.7114 | 4.6839 | 4.7071 | 19936616.0 |
| 2007-08-22 09:55:00 | AAPL | Stock | 4.7064 | 4.7086 | 4.6893 | 4.6968 | 12828256.0 |
| 2007-08-22 10:00:00 | AAPL | Stock | 4.6968 | 4.6982 | 4.6707 | 4.6754 | 23630656.0 |
| 2007-08-22 10:05:00 | AAPL | Stock | 4.6771 | 4.6943 | 4.6721 | 4.6839 | 21689164.0 |
| 2007-08-22 10:10:00 | AAPL | Stock | 4.6839 | 4.6946 | 4.675 | 4.6882 | 14771932.0 |
| 2007-08-22 10:15:00 | AAPL | Stock | 4.6882 | 4.6921 | 4.6771 | 4.6821 | 12271196.0 |
| 2007-08-22 10:20:00 | AAPL | Stock | 4.6818 | 4.6836 | 4.6714 | 4.6785 | 18196500.0 |
| 2007-08-22 10:25:00 | AAPL | Stock | 4.6779 | 4.6871 | 4.6761 | 4.6846 | 11303992.0 |
| 2007-08-22 10:30:00 | AAPL | Stock | 4.6846 | 4.6964 | 4.6793 | 4.6936 | 13755168.0 |
| 2007-08-22 10:35:00 | AAPL | Stock | 4.6936 | 4.7046 | 4.6886 | 4.7021 | 12602772.0 |
| 2007-08-22 10:40:00 | AAPL | Stock | 4.7021 | 4.7043 | 4.6911 | 4.6918 | 9794904.0 |
| 2007-08-22 10:45:00 | AAPL | Stock | 4.6914 | 4.7054 | 4.6904 | 4.6974 | 10922296.0 |
| 2007-08-22 10:50:00 | AAPL | Stock | 4.6975 | 4.6993 | 4.685 | 4.687 | 8843828.0 |
| 2007-08-22 10:55:00 | AAPL | Stock | 4.6875 | 4.6904 | 4.6786 | 4.6796 | 12265876.0 |
| 2007-08-22 11:00:00 | AAPL | Stock | 4.68 | 4.6846 | 4.6736 | 4.6804 | 17545892.0 |
| 2007-08-22 11:05:00 | AAPL | Stock | 4.6804 | 4.6818 | 4.6661 | 4.6754 | 19943644.0 |
| 2007-08-22 11:10:00 | AAPL | Stock | 4.6757 | 4.6832 | 4.6682 | 4.6796 | 9733192.0 |
| 2007-08-22 11:15:00 | AAPL | Stock | 4.68 | 4.6886 | 4.6764 | 4.6875 | 8275708.0 |
| 2007-08-22 11:20:00 | AAPL | Stock | 4.6875 | 4.6907 | 4.6839 | 4.6866 | 6296276.0 |
| 2007-08-22 11:25:00 | AAPL | Stock | 4.6861 | 4.6904 | 4.6804 | 4.6818 | 8594964.0 |
| 2007-08-22 11:30:00 | AAPL | Stock | 4.6825 | 4.6839 | 4.6768 | 4.6829 | 6731368.0 |
| 2007-08-22 11:35:00 | AAPL | Stock | 4.6825 | 4.6886 | 4.6793 | 4.685 | 5066040.0 |
| 2007-08-22 11:40:00 | AAPL | Stock | 4.685 | 4.6939 | 4.685 | 4.6921 | 7109816.0 |
| 2007-08-22 11:45:00 | AAPL | Stock | 4.6921 | 4.6982 | 4.6839 | 4.6879 | 10789324.0 |
| 2007-08-22 11:50:00 | AAPL | Stock | 4.6884 | 4.6961 | 4.6879 | 4.6914 | 6394528.0 |
| 2007-08-22 11:55:00 | AAPL | Stock | 4.6914 | 4.6936 | 4.6875 | 4.6889 | 5357296.0 |
| 2007-08-22 12:00:00 | AAPL | Stock | 4.6886 | 4.6893 | 4.6821 | 4.6868 | 7900704.0 |
| 2007-08-22 12:05:00 | AAPL | Stock | 4.6868 | 4.7 | 4.6864 | 4.6979 | 8516116.0 |
| 2007-08-22 12:10:00 | AAPL | Stock | 4.6979 | 4.7 | 4.6936 | 4.6957 | 4776380.0 |
| 2007-08-22 12:15:00 | AAPL | Stock | 4.6964 | 4.6989 | 4.6936 | 4.6968 | 4249056.0 |
| 2007-08-22 12:20:00 | AAPL | Stock | 4.6968 | 4.6979 | 4.6875 | 4.6889 | 7195832.0 |
| 2007-08-22 12:25:00 | AAPL | Stock | 4.6893 | 4.6921 | 4.6811 | 4.6857 | 8070664.0 |
| 2007-08-22 12:30:00 | AAPL | Stock | 4.6857 | 4.6896 | 4.6743 | 4.6821 | 12218920.0 |
| 2007-08-22 12:35:00 | AAPL | Stock | 4.6818 | 4.6839 | 4.6721 | 4.6808 | 9614724.0 |
| 2007-08-22 12:40:00 | AAPL | Stock | 4.6807 | 4.6829 | 4.6771 | 4.6804 | 6664420.0 |
| 2007-08-22 12:45:00 | AAPL | Stock | 4.6804 | 4.6824 | 4.6732 | 4.6759 | 6188476.0 |
| 2007-08-22 12:50:00 | AAPL | Stock | 4.6757 | 4.6761 | 4.6664 | 4.6736 | 9979536.0 |
| 2007-08-22 12:55:00 | AAPL | Stock | 4.6736 | 4.6743 | 4.6689 | 4.6689 | 4582368.0 |
| 2007-08-22 13:00:00 | AAPL | Stock | 4.6689 | 4.6746 | 4.6579 | 4.662 | 14866124.0 |
| 2007-08-22 13:05:00 | AAPL | Stock | 4.6618 | 4.6661 | 4.6546 | 4.6636 | 12163900.0 |
| 2007-08-22 13:10:00 | AAPL | Stock | 4.6643 | 4.6746 | 4.6636 | 4.6707 | 7678776.0 |
| 2007-08-22 13:15:00 | AAPL | Stock | 4.6711 | 4.6757 | 4.6664 | 4.675 | 7643552.0 |
| 2007-08-22 13:20:00 | AAPL | Stock | 4.6746 | 4.6814 | 4.6743 | 4.68 | 9616320.0 |
| 2007-08-22 13:25:00 | AAPL | Stock | 4.68 | 4.6857 | 4.6789 | 4.6829 | 7639548.0 |
| 2007-08-22 13:30:00 | AAPL | Stock | 4.6829 | 4.6893 | 4.6825 | 4.6886 | 8505112.0 |
| 2007-08-22 13:35:00 | AAPL | Stock | 4.6889 | 4.6936 | 4.6857 | 4.6936 | 12942468.0 |
> showing 50 of 302,038 rows — these rows as CSV