PREVIEW / stock_5min / 2007-07-13
file: by_date/stock_5min/2007/2007-07-13.parquet size: 3.9 MB rows: 292,618 symbols: 3,050
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-07-13 09:30:00 | AAPL | Stock | 4.8225 | 4.8379 | 4.8104 | 4.8246 | 50651496.0 |
| 2007-07-13 09:35:00 | AAPL | Stock | 4.8246 | 4.8334 | 4.8136 | 4.8261 | 19794964.0 |
| 2007-07-13 09:40:00 | AAPL | Stock | 4.8257 | 4.8286 | 4.8182 | 4.8261 | 18376428.0 |
| 2007-07-13 09:45:00 | AAPL | Stock | 4.8268 | 4.8321 | 4.8214 | 4.8214 | 17136028.0 |
| 2007-07-13 09:50:00 | AAPL | Stock | 4.8214 | 4.8275 | 4.815 | 4.8189 | 23136176.0 |
| 2007-07-13 09:55:00 | AAPL | Stock | 4.8193 | 4.8221 | 4.8043 | 4.8107 | 17951948.0 |
| 2007-07-13 10:00:00 | AAPL | Stock | 4.8107 | 4.8239 | 4.8104 | 4.8154 | 17931172.0 |
| 2007-07-13 10:05:00 | AAPL | Stock | 4.8154 | 4.8218 | 4.8082 | 4.8086 | 13228964.0 |
| 2007-07-13 10:10:00 | AAPL | Stock | 4.8082 | 4.8129 | 4.8068 | 4.8086 | 11795084.0 |
| 2007-07-13 10:15:00 | AAPL | Stock | 4.8089 | 4.8129 | 4.8064 | 4.8093 | 7931476.0 |
| 2007-07-13 10:20:00 | AAPL | Stock | 4.8089 | 4.8171 | 4.8089 | 4.815 | 7910140.0 |
| 2007-07-13 10:25:00 | AAPL | Stock | 4.8157 | 4.8161 | 4.8071 | 4.8125 | 8311884.0 |
| 2007-07-13 10:30:00 | AAPL | Stock | 4.8123 | 4.8204 | 4.81 | 4.8204 | 9581208.0 |
| 2007-07-13 10:35:00 | AAPL | Stock | 4.8204 | 4.8221 | 4.8182 | 4.8218 | 7844144.0 |
| 2007-07-13 10:40:00 | AAPL | Stock | 4.8218 | 4.8307 | 4.8182 | 4.8254 | 16533552.0 |
| 2007-07-13 10:45:00 | AAPL | Stock | 4.8257 | 4.8268 | 4.8207 | 4.8221 | 7497252.0 |
| 2007-07-13 10:50:00 | AAPL | Stock | 4.8218 | 4.8261 | 4.8189 | 4.8251 | 8481592.0 |
| 2007-07-13 10:55:00 | AAPL | Stock | 4.825 | 4.8254 | 4.8225 | 4.8246 | 4237660.0 |
| 2007-07-13 11:00:00 | AAPL | Stock | 4.8246 | 4.8246 | 4.82 | 4.8214 | 4068344.0 |
| 2007-07-13 11:05:00 | AAPL | Stock | 4.8214 | 4.8229 | 4.8168 | 4.8225 | 6427204.0 |
| 2007-07-13 11:10:00 | AAPL | Stock | 4.8222 | 4.8225 | 4.8143 | 4.8143 | 6459908.0 |
| 2007-07-13 11:15:00 | AAPL | Stock | 4.8146 | 4.8175 | 4.8143 | 4.8164 | 4776856.0 |
| 2007-07-13 11:20:00 | AAPL | Stock | 4.8164 | 4.8211 | 4.8164 | 4.82 | 4350892.0 |
| 2007-07-13 11:25:00 | AAPL | Stock | 4.8199 | 4.825 | 4.8171 | 4.8218 | 5499900.0 |
| 2007-07-13 11:30:00 | AAPL | Stock | 4.8221 | 4.8232 | 4.8182 | 4.8211 | 6977740.0 |
| 2007-07-13 11:35:00 | AAPL | Stock | 4.8214 | 4.8218 | 4.82 | 4.8207 | 4003916.0 |
| 2007-07-13 11:40:00 | AAPL | Stock | 4.8207 | 4.8282 | 4.8204 | 4.825 | 8137304.0 |
| 2007-07-13 11:45:00 | AAPL | Stock | 4.8254 | 4.8321 | 4.8221 | 4.8262 | 9920372.0 |
| 2007-07-13 11:50:00 | AAPL | Stock | 4.8254 | 4.8307 | 4.8243 | 4.8286 | 7054544.0 |
| 2007-07-13 11:55:00 | AAPL | Stock | 4.8289 | 4.8296 | 4.8232 | 4.825 | 6409340.0 |
| 2007-07-13 12:00:00 | AAPL | Stock | 4.825 | 4.8282 | 4.8239 | 4.8264 | 6144740.0 |
| 2007-07-13 12:05:00 | AAPL | Stock | 4.8268 | 4.8314 | 4.8257 | 4.8286 | 5987380.0 |
| 2007-07-13 12:10:00 | AAPL | Stock | 4.8286 | 4.8389 | 4.8201 | 4.835 | 14586124.0 |
| 2007-07-13 12:15:00 | AAPL | Stock | 4.8347 | 4.8418 | 4.8289 | 4.8354 | 15747900.0 |
| 2007-07-13 12:20:00 | AAPL | Stock | 4.8354 | 4.8357 | 4.8311 | 4.8311 | 6962004.0 |
| 2007-07-13 12:25:00 | AAPL | Stock | 4.8311 | 4.8393 | 4.8307 | 4.8354 | 7377580.0 |
| 2007-07-13 12:30:00 | AAPL | Stock | 4.835 | 4.8368 | 4.8304 | 4.8368 | 6204212.0 |
| 2007-07-13 12:35:00 | AAPL | Stock | 4.8364 | 4.8418 | 4.835 | 4.8404 | 6320748.0 |
| 2007-07-13 12:40:00 | AAPL | Stock | 4.8404 | 4.8482 | 4.8375 | 4.8457 | 13869716.0 |
| 2007-07-13 12:45:00 | AAPL | Stock | 4.8451 | 4.85 | 4.8375 | 4.8454 | 9107112.0 |
| 2007-07-13 12:50:00 | AAPL | Stock | 4.845 | 4.8482 | 4.8381 | 4.8429 | 11388440.0 |
| 2007-07-13 12:55:00 | AAPL | Stock | 4.8435 | 4.8514 | 4.8432 | 4.8457 | 8045884.0 |
| 2007-07-13 13:00:00 | AAPL | Stock | 4.8457 | 4.8475 | 4.8404 | 4.8421 | 7473396.0 |
| 2007-07-13 13:05:00 | AAPL | Stock | 4.8418 | 4.8421 | 4.8346 | 4.8361 | 7996184.0 |
| 2007-07-13 13:10:00 | AAPL | Stock | 4.8361 | 4.8375 | 4.8311 | 4.8364 | 6191052.0 |
| 2007-07-13 13:15:00 | AAPL | Stock | 4.8364 | 4.8482 | 4.8361 | 4.845 | 6105652.0 |
| 2007-07-13 13:20:00 | AAPL | Stock | 4.845 | 4.8479 | 4.8429 | 4.8464 | 4408292.0 |
| 2007-07-13 13:25:00 | AAPL | Stock | 4.8464 | 4.8464 | 4.8425 | 4.8426 | 3029852.0 |
| 2007-07-13 13:30:00 | AAPL | Stock | 4.8428 | 4.8482 | 4.8407 | 4.8454 | 4767616.0 |
| 2007-07-13 13:35:00 | AAPL | Stock | 4.8457 | 4.8489 | 4.845 | 4.8457 | 4191768.0 |
> showing 50 of 292,618 rows — these rows as CSV