PREVIEW / stock_1min / 2007-05-10
file: by_date/stock_1min/2007/2007-05-10.parquet size: 11.0 MB rows: 912,146 symbols: 2,243
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-10 09:30:00 | AAPL | Stock | 3.8082 | 3.8114 | 3.8007 | 3.8032 | 6282304.0 |
| 2007-05-10 09:31:00 | AAPL | Stock | 3.8061 | 3.8071 | 3.7989 | 3.8011 | 3080868.0 |
| 2007-05-10 09:32:00 | AAPL | Stock | 3.8007 | 3.8027 | 3.7971 | 3.7996 | 3008348.0 |
| 2007-05-10 09:33:00 | AAPL | Stock | 3.7993 | 3.8029 | 3.7989 | 3.8018 | 3236660.0 |
| 2007-05-10 09:34:00 | AAPL | Stock | 3.8014 | 3.8071 | 3.8004 | 3.8061 | 2986704.0 |
| 2007-05-10 09:35:00 | AAPL | Stock | 3.8061 | 3.8161 | 3.8039 | 3.8161 | 2801848.0 |
| 2007-05-10 09:36:00 | AAPL | Stock | 3.8161 | 3.8204 | 3.8143 | 3.815 | 5332236.0 |
| 2007-05-10 09:37:00 | AAPL | Stock | 3.8143 | 3.8168 | 3.8118 | 3.8161 | 3236324.0 |
| 2007-05-10 09:38:00 | AAPL | Stock | 3.8161 | 3.8182 | 3.8125 | 3.8182 | 4166568.0 |
| 2007-05-10 09:39:00 | AAPL | Stock | 3.8182 | 3.8282 | 3.8182 | 3.8282 | 4607148.0 |
| 2007-05-10 09:40:00 | AAPL | Stock | 3.8282 | 3.8304 | 3.8229 | 3.8268 | 5147324.0 |
| 2007-05-10 09:41:00 | AAPL | Stock | 3.8268 | 3.8286 | 3.8232 | 3.8254 | 3637452.0 |
| 2007-05-10 09:42:00 | AAPL | Stock | 3.8257 | 3.8314 | 3.8236 | 3.8289 | 6112456.0 |
| 2007-05-10 09:43:00 | AAPL | Stock | 3.8279 | 3.8357 | 3.8275 | 3.8357 | 5419176.0 |
| 2007-05-10 09:44:00 | AAPL | Stock | 3.8357 | 3.8379 | 3.8325 | 3.8354 | 4485936.0 |
| 2007-05-10 09:45:00 | AAPL | Stock | 3.8354 | 3.8371 | 3.8325 | 3.8368 | 4636268.0 |
| 2007-05-10 09:46:00 | AAPL | Stock | 3.8371 | 3.8379 | 3.8325 | 3.8343 | 3240748.0 |
| 2007-05-10 09:47:00 | AAPL | Stock | 3.8336 | 3.8418 | 3.8325 | 3.8368 | 5434688.0 |
| 2007-05-10 09:48:00 | AAPL | Stock | 3.8371 | 3.8375 | 3.8271 | 3.8279 | 5270188.0 |
| 2007-05-10 09:49:00 | AAPL | Stock | 3.8279 | 3.8279 | 3.8111 | 3.8114 | 7775348.0 |
| 2007-05-10 09:50:00 | AAPL | Stock | 3.8114 | 3.8175 | 3.8111 | 3.815 | 5158328.0 |
| 2007-05-10 09:51:00 | AAPL | Stock | 3.815 | 3.815 | 3.8046 | 3.8129 | 6710340.0 |
| 2007-05-10 09:52:00 | AAPL | Stock | 3.81 | 3.8182 | 3.81 | 3.8182 | 3743292.0 |
| 2007-05-10 09:53:00 | AAPL | Stock | 3.8182 | 3.8293 | 3.8164 | 3.8289 | 3846668.0 |
| 2007-05-10 09:54:00 | AAPL | Stock | 3.8289 | 3.83 | 3.8218 | 3.8254 | 3666768.0 |
| 2007-05-10 09:55:00 | AAPL | Stock | 3.8254 | 3.8264 | 3.8218 | 3.8221 | 2593892.0 |
| 2007-05-10 09:56:00 | AAPL | Stock | 3.8221 | 3.8289 | 3.8218 | 3.8246 | 3008712.0 |
| 2007-05-10 09:57:00 | AAPL | Stock | 3.825 | 3.8261 | 3.8179 | 3.8179 | 2437820.0 |
| 2007-05-10 09:58:00 | AAPL | Stock | 3.8182 | 3.8354 | 3.8179 | 3.825 | 2359112.0 |
| 2007-05-10 09:59:00 | AAPL | Stock | 3.8253 | 3.8264 | 3.8236 | 3.825 | 1891932.0 |
| 2007-05-10 10:00:00 | AAPL | Stock | 3.8246 | 3.8268 | 3.8193 | 3.8196 | 1992200.0 |
| 2007-05-10 10:01:00 | AAPL | Stock | 3.82 | 3.8268 | 3.8196 | 3.8264 | 1256052.0 |
| 2007-05-10 10:02:00 | AAPL | Stock | 3.8257 | 3.8311 | 3.8257 | 3.8271 | 2575636.0 |
| 2007-05-10 10:03:00 | AAPL | Stock | 3.8275 | 3.8329 | 3.8266 | 3.8325 | 2920708.0 |
| 2007-05-10 10:04:00 | AAPL | Stock | 3.8329 | 3.8364 | 3.8318 | 3.8346 | 4561620.0 |
| 2007-05-10 10:05:00 | AAPL | Stock | 3.8343 | 3.8346 | 3.8275 | 3.83 | 3245340.0 |
| 2007-05-10 10:06:00 | AAPL | Stock | 3.83 | 3.8307 | 3.8279 | 3.8279 | 2605148.0 |
| 2007-05-10 10:07:00 | AAPL | Stock | 3.8279 | 3.8293 | 3.8236 | 3.8239 | 2779392.0 |
| 2007-05-10 10:08:00 | AAPL | Stock | 3.8241 | 3.8279 | 3.8236 | 3.8268 | 1867936.0 |
| 2007-05-10 10:09:00 | AAPL | Stock | 3.8268 | 3.8293 | 3.825 | 3.8293 | 2739380.0 |
| 2007-05-10 10:10:00 | AAPL | Stock | 3.8293 | 3.8293 | 3.82 | 3.8232 | 3404408.0 |
| 2007-05-10 10:11:00 | AAPL | Stock | 3.8225 | 3.8229 | 3.8171 | 3.8196 | 3284932.0 |
| 2007-05-10 10:12:00 | AAPL | Stock | 3.82 | 3.825 | 3.82 | 3.8239 | 1910524.0 |
| 2007-05-10 10:13:00 | AAPL | Stock | 3.8232 | 3.8246 | 3.8196 | 3.8225 | 1662444.0 |
| 2007-05-10 10:14:00 | AAPL | Stock | 3.8225 | 3.8246 | 3.8214 | 3.8225 | 1123164.0 |
| 2007-05-10 10:15:00 | AAPL | Stock | 3.8221 | 3.8293 | 3.8214 | 3.8286 | 1503180.0 |
| 2007-05-10 10:16:00 | AAPL | Stock | 3.8286 | 3.8321 | 3.8275 | 3.8299 | 2256716.0 |
| 2007-05-10 10:17:00 | AAPL | Stock | 3.8296 | 3.8304 | 3.8286 | 3.8286 | 1113924.0 |
| 2007-05-10 10:18:00 | AAPL | Stock | 3.8289 | 3.8339 | 3.8279 | 3.8293 | 1790488.0 |
| 2007-05-10 10:19:00 | AAPL | Stock | 3.8289 | 3.8321 | 3.8286 | 3.8311 | 2264584.0 |
> showing 50 of 912,146 rows — these rows as CSV