PREVIEW / stock_1min / 2007-08-22
file: by_date/stock_1min/2007/2007-08-22.parquet size: 11.7 MB rows: 964,764 symbols: 2,550
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.6896 | 4.6743 | 4.6871 | 11592252.0 |
| 2007-08-22 09:31:00 | AAPL | Stock | 4.6868 | 4.7214 | 4.6739 | 4.7175 | 15265824.0 |
| 2007-08-22 09:32:00 | AAPL | Stock | 4.7175 | 4.7254 | 4.6809 | 4.7182 | 17066280.0 |
| 2007-08-22 09:33:00 | AAPL | Stock | 4.7179 | 4.725 | 4.6979 | 4.7107 | 13951000.0 |
| 2007-08-22 09:34:00 | AAPL | Stock | 4.7096 | 4.7236 | 4.7036 | 4.7125 | 9360288.0 |
| 2007-08-22 09:35:00 | AAPL | Stock | 4.7132 | 4.7136 | 4.6968 | 4.7118 | 7594468.0 |
| 2007-08-22 09:36:00 | AAPL | Stock | 4.7125 | 4.7368 | 4.7118 | 4.7329 | 11406612.0 |
| 2007-08-22 09:37:00 | AAPL | Stock | 4.7325 | 4.7359 | 4.7216 | 4.7268 | 8507492.0 |
| 2007-08-22 09:38:00 | AAPL | Stock | 4.7271 | 4.7318 | 4.7107 | 4.7156 | 7443044.0 |
| 2007-08-22 09:39:00 | AAPL | Stock | 4.7154 | 4.7157 | 4.7036 | 4.7061 | 6841324.0 |
| 2007-08-22 09:40:00 | AAPL | Stock | 4.7057 | 4.7196 | 4.7057 | 4.7168 | 4571000.0 |
| 2007-08-22 09:41:00 | AAPL | Stock | 4.7188 | 4.72 | 4.7054 | 4.7118 | 5410356.0 |
| 2007-08-22 09:42:00 | AAPL | Stock | 4.7135 | 4.7135 | 4.6921 | 4.6964 | 6785324.0 |
| 2007-08-22 09:43:00 | AAPL | Stock | 4.6964 | 4.7029 | 4.6932 | 4.6979 | 5809132.0 |
| 2007-08-22 09:44:00 | AAPL | Stock | 4.6971 | 4.7082 | 4.6964 | 4.705 | 5535236.0 |
| 2007-08-22 09:45:00 | AAPL | Stock | 4.7036 | 4.7064 | 4.6929 | 4.6939 | 4257652.0 |
| 2007-08-22 09:46:00 | AAPL | Stock | 4.6939 | 4.7014 | 4.6914 | 4.6968 | 4309060.0 |
| 2007-08-22 09:47:00 | AAPL | Stock | 4.6979 | 4.6982 | 4.6871 | 4.6925 | 6095348.0 |
| 2007-08-22 09:48:00 | AAPL | Stock | 4.6925 | 4.7004 | 4.6879 | 4.6993 | 5486068.0 |
| 2007-08-22 09:49:00 | AAPL | Stock | 4.6989 | 4.7014 | 4.6918 | 4.6942 | 5861156.0 |
| 2007-08-22 09:50:00 | AAPL | Stock | 4.6954 | 4.6959 | 4.6854 | 4.6861 | 4736816.0 |
| 2007-08-22 09:51:00 | AAPL | Stock | 4.6864 | 4.6925 | 4.6839 | 4.6921 | 3396960.0 |
| 2007-08-22 09:52:00 | AAPL | Stock | 4.6921 | 4.7036 | 4.6904 | 4.7032 | 3617012.0 |
| 2007-08-22 09:53:00 | AAPL | Stock | 4.7036 | 4.7054 | 4.6964 | 4.7021 | 4146408.0 |
| 2007-08-22 09:54:00 | AAPL | Stock | 4.7019 | 4.7114 | 4.7011 | 4.7071 | 4039420.0 |
| 2007-08-22 09:55:00 | AAPL | Stock | 4.7064 | 4.7086 | 4.6989 | 4.6989 | 3004176.0 |
| 2007-08-22 09:56:00 | AAPL | Stock | 4.6989 | 4.6996 | 4.6893 | 4.6936 | 3502436.0 |
| 2007-08-22 09:57:00 | AAPL | Stock | 4.6925 | 4.7025 | 4.6921 | 4.7021 | 2283008.0 |
| 2007-08-22 09:58:00 | AAPL | Stock | 4.7029 | 4.7071 | 4.7 | 4.7013 | 2052624.0 |
| 2007-08-22 09:59:00 | AAPL | Stock | 4.7021 | 4.7046 | 4.6968 | 4.6968 | 1986012.0 |
| 2007-08-22 10:00:00 | AAPL | Stock | 4.6968 | 4.6982 | 4.6893 | 4.6943 | 3656884.0 |
| 2007-08-22 10:01:00 | AAPL | Stock | 4.695 | 4.6968 | 4.6911 | 4.6911 | 2018240.0 |
| 2007-08-22 10:02:00 | AAPL | Stock | 4.6911 | 4.6914 | 4.6786 | 4.6836 | 6126344.0 |
| 2007-08-22 10:03:00 | AAPL | Stock | 4.6832 | 4.6857 | 4.6804 | 4.6811 | 3722600.0 |
| 2007-08-22 10:04:00 | AAPL | Stock | 4.6825 | 4.6825 | 4.6707 | 4.6754 | 8106588.0 |
| 2007-08-22 10:05:00 | AAPL | Stock | 4.6771 | 4.6774 | 4.6721 | 4.6761 | 4569460.0 |
| 2007-08-22 10:06:00 | AAPL | Stock | 4.6768 | 4.6882 | 4.6743 | 4.6868 | 6689872.0 |
| 2007-08-22 10:07:00 | AAPL | Stock | 4.6868 | 4.6943 | 4.6782 | 4.6832 | 4672360.0 |
| 2007-08-22 10:08:00 | AAPL | Stock | 4.6839 | 4.6857 | 4.6764 | 4.68 | 2816044.0 |
| 2007-08-22 10:09:00 | AAPL | Stock | 4.6804 | 4.6839 | 4.6757 | 4.6839 | 2941428.0 |
| 2007-08-22 10:10:00 | AAPL | Stock | 4.6839 | 4.6871 | 4.6825 | 4.6839 | 2341864.0 |
| 2007-08-22 10:11:00 | AAPL | Stock | 4.6836 | 4.6864 | 4.6786 | 4.6804 | 2996140.0 |
| 2007-08-22 10:12:00 | AAPL | Stock | 4.6811 | 4.6857 | 4.675 | 4.6829 | 2805124.0 |
| 2007-08-22 10:13:00 | AAPL | Stock | 4.6834 | 4.6943 | 4.6804 | 4.6929 | 3765188.0 |
| 2007-08-22 10:14:00 | AAPL | Stock | 4.6918 | 4.6946 | 4.6871 | 4.6882 | 2863616.0 |
| 2007-08-22 10:15:00 | AAPL | Stock | 4.6882 | 4.6921 | 4.6825 | 4.6882 | 2346064.0 |
| 2007-08-22 10:16:00 | AAPL | Stock | 4.6886 | 4.6887 | 4.6807 | 4.6836 | 2742628.0 |
| 2007-08-22 10:17:00 | AAPL | Stock | 4.6832 | 4.6843 | 4.6771 | 4.6807 | 3286332.0 |
| 2007-08-22 10:18:00 | AAPL | Stock | 4.6804 | 4.6907 | 4.6804 | 4.6843 | 1968092.0 |
| 2007-08-22 10:19:00 | AAPL | Stock | 4.6836 | 4.6889 | 4.6814 | 4.6821 | 1928080.0 |
> showing 50 of 964,764 rows — these rows as CSV