PREVIEW / stock_1min / 2007-08-23
file: by_date/stock_1min/2007/2007-08-23.parquet size: 11.4 MB rows: 935,284 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-23 09:30:00 | AAPL | Stock | 4.7532 | 4.7621 | 4.7404 | 4.745 | 8441580.0 |
| 2007-08-23 09:31:00 | AAPL | Stock | 4.745 | 4.7604 | 4.7393 | 4.745 | 4247012.0 |
| 2007-08-23 09:32:00 | AAPL | Stock | 4.7446 | 4.7618 | 4.741 | 4.7596 | 5444992.0 |
| 2007-08-23 09:33:00 | AAPL | Stock | 4.7596 | 4.7618 | 4.7449 | 4.75 | 4761624.0 |
| 2007-08-23 09:34:00 | AAPL | Stock | 4.75 | 4.7596 | 4.7243 | 4.7264 | 11354168.0 |
| 2007-08-23 09:35:00 | AAPL | Stock | 4.7261 | 4.7318 | 4.7179 | 4.7286 | 8051484.0 |
| 2007-08-23 09:36:00 | AAPL | Stock | 4.7286 | 4.7371 | 4.7243 | 4.7343 | 4799788.0 |
| 2007-08-23 09:37:00 | AAPL | Stock | 4.7336 | 4.7346 | 4.72 | 4.72 | 4374552.0 |
| 2007-08-23 09:38:00 | AAPL | Stock | 4.7196 | 4.7207 | 4.7057 | 4.7157 | 9483544.0 |
| 2007-08-23 09:39:00 | AAPL | Stock | 4.7154 | 4.7214 | 4.7132 | 4.7186 | 4729760.0 |
| 2007-08-23 09:40:00 | AAPL | Stock | 4.7186 | 4.7214 | 4.71 | 4.71 | 5041568.0 |
| 2007-08-23 09:41:00 | AAPL | Stock | 4.7108 | 4.716 | 4.7068 | 4.7136 | 4183480.0 |
| 2007-08-23 09:42:00 | AAPL | Stock | 4.7143 | 4.7161 | 4.7021 | 4.7021 | 6813940.0 |
| 2007-08-23 09:43:00 | AAPL | Stock | 4.7021 | 4.7132 | 4.7007 | 4.7104 | 5730928.0 |
| 2007-08-23 09:44:00 | AAPL | Stock | 4.7111 | 4.7161 | 4.7093 | 4.7111 | 3077592.0 |
| 2007-08-23 09:45:00 | AAPL | Stock | 4.7118 | 4.715 | 4.7086 | 4.7118 | 3205468.0 |
| 2007-08-23 09:46:00 | AAPL | Stock | 4.7125 | 4.7161 | 4.7086 | 4.7114 | 3563588.0 |
| 2007-08-23 09:47:00 | AAPL | Stock | 4.7117 | 4.7229 | 4.711 | 4.7218 | 3828440.0 |
| 2007-08-23 09:48:00 | AAPL | Stock | 4.7207 | 4.7221 | 4.7146 | 4.7175 | 3152744.0 |
| 2007-08-23 09:49:00 | AAPL | Stock | 4.7168 | 4.7214 | 4.7118 | 4.7154 | 3066392.0 |
| 2007-08-23 09:50:00 | AAPL | Stock | 4.7154 | 4.72 | 4.7114 | 4.7129 | 3018456.0 |
| 2007-08-23 09:51:00 | AAPL | Stock | 4.7129 | 4.7132 | 4.6921 | 4.705 | 8009148.0 |
| 2007-08-23 09:52:00 | AAPL | Stock | 4.7061 | 4.7286 | 4.7 | 4.7011 | 4231080.0 |
| 2007-08-23 09:53:00 | AAPL | Stock | 4.7011 | 4.7107 | 4.7011 | 4.71 | 1954988.0 |
| 2007-08-23 09:54:00 | AAPL | Stock | 4.7104 | 4.7104 | 4.6957 | 4.702 | 3312988.0 |
| 2007-08-23 09:55:00 | AAPL | Stock | 4.7025 | 4.7086 | 4.7007 | 4.7082 | 2042936.0 |
| 2007-08-23 09:56:00 | AAPL | Stock | 4.7079 | 4.7132 | 4.7046 | 4.7093 | 2614892.0 |
| 2007-08-23 09:57:00 | AAPL | Stock | 4.7096 | 4.7179 | 4.7085 | 4.7129 | 2751560.0 |
| 2007-08-23 09:58:00 | AAPL | Stock | 4.7143 | 4.7196 | 4.7125 | 4.7189 | 3239488.0 |
| 2007-08-23 09:59:00 | AAPL | Stock | 4.7189 | 4.7243 | 4.7179 | 4.7214 | 3405724.0 |
| 2007-08-23 10:00:00 | AAPL | Stock | 4.7207 | 4.7221 | 4.7182 | 4.7196 | 3083248.0 |
| 2007-08-23 10:01:00 | AAPL | Stock | 4.7196 | 4.7329 | 4.7161 | 4.7321 | 5249440.0 |
| 2007-08-23 10:02:00 | AAPL | Stock | 4.7328 | 4.7407 | 4.7261 | 4.7368 | 6247080.0 |
| 2007-08-23 10:03:00 | AAPL | Stock | 4.7371 | 4.7454 | 4.7336 | 4.7354 | 5547752.0 |
| 2007-08-23 10:04:00 | AAPL | Stock | 4.7357 | 4.7361 | 4.7254 | 4.7268 | 3285772.0 |
| 2007-08-23 10:05:00 | AAPL | Stock | 4.7268 | 4.7339 | 4.7261 | 4.7332 | 2040444.0 |
| 2007-08-23 10:06:00 | AAPL | Stock | 4.7325 | 4.7343 | 4.7232 | 4.725 | 2804200.0 |
| 2007-08-23 10:07:00 | AAPL | Stock | 4.7254 | 4.7254 | 4.7175 | 4.7232 | 2478784.0 |
| 2007-08-23 10:08:00 | AAPL | Stock | 4.7221 | 4.7241 | 4.7139 | 4.7157 | 2775304.0 |
| 2007-08-23 10:09:00 | AAPL | Stock | 4.7164 | 4.72 | 4.7115 | 4.7125 | 2735516.0 |
| 2007-08-23 10:10:00 | AAPL | Stock | 4.7121 | 4.7193 | 4.7118 | 4.7157 | 1929704.0 |
| 2007-08-23 10:11:00 | AAPL | Stock | 4.715 | 4.7164 | 4.7071 | 4.7089 | 3682476.0 |
| 2007-08-23 10:12:00 | AAPL | Stock | 4.7082 | 4.7143 | 4.7071 | 4.7143 | 2669128.0 |
| 2007-08-23 10:13:00 | AAPL | Stock | 4.7143 | 4.7204 | 4.7125 | 4.7193 | 1895908.0 |
| 2007-08-23 10:14:00 | AAPL | Stock | 4.7193 | 4.7207 | 4.7121 | 4.7129 | 1947568.0 |
| 2007-08-23 10:15:00 | AAPL | Stock | 4.7136 | 4.7136 | 4.7043 | 4.7046 | 2587144.0 |
| 2007-08-23 10:16:00 | AAPL | Stock | 4.7054 | 4.7094 | 4.7039 | 4.7071 | 2328144.0 |
| 2007-08-23 10:17:00 | AAPL | Stock | 4.7071 | 4.7143 | 4.7071 | 4.7129 | 1788136.0 |
| 2007-08-23 10:18:00 | AAPL | Stock | 4.7132 | 4.7143 | 4.7079 | 4.7111 | 1918084.0 |
| 2007-08-23 10:19:00 | AAPL | Stock | 4.7111 | 4.712 | 4.7029 | 4.7054 | 2312380.0 |
> showing 50 of 935,284 rows — these rows as CSV