PREVIEW / stock_1min / 2007-05-08
file: by_date/stock_1min/2007/2007-05-08.parquet size: 10.5 MB rows: 876,697 symbols: 2,233
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-05-08 09:30:00 | AAPL | Stock | 3.6954 | 3.7125 | 3.6939 | 3.7114 | 34952036.0 |
| 2007-05-08 09:31:00 | AAPL | Stock | 3.6975 | 3.7093 | 3.6936 | 3.7039 | 4224444.0 |
| 2007-05-08 09:32:00 | AAPL | Stock | 3.7043 | 3.7125 | 3.7025 | 3.7054 | 2681224.0 |
| 2007-05-08 09:33:00 | AAPL | Stock | 3.7057 | 3.7125 | 3.7 | 3.705 | 3435152.0 |
| 2007-05-08 09:34:00 | AAPL | Stock | 3.7046 | 3.7096 | 3.7 | 3.7054 | 3275356.0 |
| 2007-05-08 09:35:00 | AAPL | Stock | 3.7054 | 3.7089 | 3.7007 | 3.7057 | 4384156.0 |
| 2007-05-08 09:36:00 | AAPL | Stock | 3.7054 | 3.7071 | 3.7014 | 3.7068 | 3917480.0 |
| 2007-05-08 09:37:00 | AAPL | Stock | 3.7071 | 3.7229 | 3.7043 | 3.7182 | 10549308.0 |
| 2007-05-08 09:38:00 | AAPL | Stock | 3.7182 | 3.7214 | 3.7154 | 3.7211 | 5199320.0 |
| 2007-05-08 09:39:00 | AAPL | Stock | 3.7211 | 3.7311 | 3.7179 | 3.7257 | 8742496.0 |
| 2007-05-08 09:40:00 | AAPL | Stock | 3.7261 | 3.7268 | 3.7146 | 3.7186 | 8092084.0 |
| 2007-05-08 09:41:00 | AAPL | Stock | 3.7182 | 3.725 | 3.7182 | 3.7225 | 4333756.0 |
| 2007-05-08 09:42:00 | AAPL | Stock | 3.7221 | 3.7321 | 3.7207 | 3.7282 | 5976012.0 |
| 2007-05-08 09:43:00 | AAPL | Stock | 3.7279 | 3.7389 | 3.7221 | 3.7382 | 6327328.0 |
| 2007-05-08 09:44:00 | AAPL | Stock | 3.7382 | 3.7421 | 3.73 | 3.74 | 7367444.0 |
| 2007-05-08 09:45:00 | AAPL | Stock | 3.74 | 3.74 | 3.7321 | 3.74 | 4493608.0 |
| 2007-05-08 09:46:00 | AAPL | Stock | 3.7371 | 3.74 | 3.7336 | 3.7379 | 3143028.0 |
| 2007-05-08 09:47:00 | AAPL | Stock | 3.7375 | 3.7407 | 3.7314 | 3.7321 | 6162912.0 |
| 2007-05-08 09:48:00 | AAPL | Stock | 3.7311 | 3.7354 | 3.7182 | 3.7354 | 5508720.0 |
| 2007-05-08 09:49:00 | AAPL | Stock | 3.7354 | 3.7357 | 3.7318 | 3.7321 | 4194176.0 |
| 2007-05-08 09:50:00 | AAPL | Stock | 3.7318 | 3.7339 | 3.7311 | 3.7329 | 3660384.0 |
| 2007-05-08 09:51:00 | AAPL | Stock | 3.7329 | 3.7339 | 3.7271 | 3.73 | 4821516.0 |
| 2007-05-08 09:52:00 | AAPL | Stock | 3.7304 | 3.7336 | 3.7286 | 3.7329 | 2757804.0 |
| 2007-05-08 09:53:00 | AAPL | Stock | 3.7329 | 3.7339 | 3.7261 | 3.7275 | 2682988.0 |
| 2007-05-08 09:54:00 | AAPL | Stock | 3.7268 | 3.7311 | 3.7268 | 3.7304 | 2822120.0 |
| 2007-05-08 09:55:00 | AAPL | Stock | 3.7304 | 3.7321 | 3.7275 | 3.7275 | 3732680.0 |
| 2007-05-08 09:56:00 | AAPL | Stock | 3.7279 | 3.73 | 3.7239 | 3.7246 | 3139080.0 |
| 2007-05-08 09:57:00 | AAPL | Stock | 3.7243 | 3.7261 | 3.7229 | 3.7236 | 3340176.0 |
| 2007-05-08 09:58:00 | AAPL | Stock | 3.7236 | 3.7268 | 3.7207 | 3.7225 | 2437960.0 |
| 2007-05-08 09:59:00 | AAPL | Stock | 3.7218 | 3.7239 | 3.7218 | 3.7229 | 2328424.0 |
| 2007-05-08 10:00:00 | AAPL | Stock | 3.7221 | 3.7254 | 3.72 | 3.7207 | 3715488.0 |
| 2007-05-08 10:01:00 | AAPL | Stock | 3.7207 | 3.725 | 3.7182 | 3.7239 | 2685060.0 |
| 2007-05-08 10:02:00 | AAPL | Stock | 3.7239 | 3.7268 | 3.7229 | 3.7243 | 2193660.0 |
| 2007-05-08 10:03:00 | AAPL | Stock | 3.7243 | 3.7279 | 3.7239 | 3.7261 | 2107532.0 |
| 2007-05-08 10:04:00 | AAPL | Stock | 3.7257 | 3.7304 | 3.7254 | 3.7295 | 2920680.0 |
| 2007-05-08 10:05:00 | AAPL | Stock | 3.7289 | 3.7296 | 3.7268 | 3.7271 | 1707776.0 |
| 2007-05-08 10:06:00 | AAPL | Stock | 3.7264 | 3.7279 | 3.7236 | 3.725 | 2638664.0 |
| 2007-05-08 10:07:00 | AAPL | Stock | 3.7254 | 3.7261 | 3.7204 | 3.7214 | 3107328.0 |
| 2007-05-08 10:08:00 | AAPL | Stock | 3.7214 | 3.7246 | 3.7196 | 3.7229 | 2328396.0 |
| 2007-05-08 10:09:00 | AAPL | Stock | 3.7225 | 3.7229 | 3.7211 | 3.7211 | 1246112.0 |
| 2007-05-08 10:10:00 | AAPL | Stock | 3.7211 | 3.725 | 3.7211 | 3.7236 | 1690472.0 |
| 2007-05-08 10:11:00 | AAPL | Stock | 3.7243 | 3.7257 | 3.7221 | 3.7221 | 1976548.0 |
| 2007-05-08 10:12:00 | AAPL | Stock | 3.7243 | 3.7257 | 3.7229 | 3.7232 | 1412068.0 |
| 2007-05-08 10:13:00 | AAPL | Stock | 3.7236 | 3.7236 | 3.7211 | 3.7214 | 1843296.0 |
| 2007-05-08 10:14:00 | AAPL | Stock | 3.7214 | 3.7246 | 3.7196 | 3.7246 | 3580472.0 |
| 2007-05-08 10:15:00 | AAPL | Stock | 3.7246 | 3.7289 | 3.7236 | 3.7264 | 2878260.0 |
| 2007-05-08 10:16:00 | AAPL | Stock | 3.7264 | 3.7289 | 3.7254 | 3.7271 | 3157840.0 |
| 2007-05-08 10:17:00 | AAPL | Stock | 3.7275 | 3.7289 | 3.7243 | 3.7279 | 3899532.0 |
| 2007-05-08 10:18:00 | AAPL | Stock | 3.7279 | 3.7314 | 3.7264 | 3.7279 | 3005772.0 |
| 2007-05-08 10:19:00 | AAPL | Stock | 3.7282 | 3.7311 | 3.7282 | 3.7286 | 1798972.0 |
> showing 50 of 876,697 rows — these rows as CSV