PREVIEW / stock_5min / 2007-12-17
file: by_date/stock_5min/2007/2007-12-17.parquet size: 4.4 MB rows: 321,015 symbols: 3,232
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-12-17 05:00:00 | AAPL | Stock | 6.7589 | 6.7589 | 6.7589 | 6.7589 | 8400.0 |
| 2007-12-17 06:10:00 | AAPL | Stock | 6.7568 | 6.7568 | 6.7568 | 6.7568 | 2800.0 |
| 2007-12-17 07:00:00 | AAPL | Stock | 6.7518 | 6.7518 | 6.75 | 6.75 | 8400.0 |
| 2007-12-17 07:05:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 92400.0 |
| 2007-12-17 07:10:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 70000.0 |
| 2007-12-17 07:20:00 | AAPL | Stock | 6.7668 | 6.7857 | 6.75 | 6.75 | 56000.0 |
| 2007-12-17 07:25:00 | AAPL | Stock | 6.75 | 6.7679 | 6.75 | 6.7504 | 57820.0 |
| 2007-12-17 07:30:00 | AAPL | Stock | 6.7786 | 6.7854 | 6.7786 | 6.7854 | 60144.0 |
| 2007-12-17 07:45:00 | AAPL | Stock | 6.7589 | 6.7589 | 6.7589 | 6.7589 | 13244.0 |
| 2007-12-17 07:55:00 | AAPL | Stock | 6.7846 | 6.7946 | 6.7846 | 6.7857 | 28000.0 |
| 2007-12-17 08:00:00 | AAPL | Stock | 6.7839 | 6.8054 | 6.7718 | 6.8039 | 183988.0 |
| 2007-12-17 08:05:00 | AAPL | Stock | 6.8 | 6.8175 | 6.8 | 6.8018 | 563976.0 |
| 2007-12-17 08:10:00 | AAPL | Stock | 6.8036 | 6.8157 | 6.7957 | 6.8139 | 321188.0 |
| 2007-12-17 08:15:00 | AAPL | Stock | 6.8132 | 6.8282 | 6.8125 | 6.8221 | 353304.0 |
| 2007-12-17 08:20:00 | AAPL | Stock | 6.8239 | 6.8239 | 6.8146 | 6.8161 | 403816.0 |
| 2007-12-17 08:25:00 | AAPL | Stock | 6.8218 | 6.8221 | 6.805 | 6.81 | 288428.0 |
| 2007-12-17 08:30:00 | AAPL | Stock | 6.8125 | 6.8182 | 6.7996 | 6.8104 | 91336.0 |
| 2007-12-17 08:35:00 | AAPL | Stock | 6.8139 | 6.8161 | 6.8139 | 6.815 | 31080.0 |
| 2007-12-17 08:40:00 | AAPL | Stock | 6.8154 | 6.8161 | 6.8125 | 6.8125 | 20748.0 |
| 2007-12-17 08:45:00 | AAPL | Stock | 6.8125 | 6.8125 | 6.8054 | 6.8054 | 52612.0 |
| 2007-12-17 08:50:00 | AAPL | Stock | 6.8064 | 6.8104 | 6.8054 | 6.8061 | 128240.0 |
| 2007-12-17 08:55:00 | AAPL | Stock | 6.8057 | 6.8089 | 6.8054 | 6.8089 | 117180.0 |
| 2007-12-17 09:00:00 | AAPL | Stock | 6.8121 | 6.8357 | 6.8093 | 6.8357 | 706748.0 |
| 2007-12-17 09:05:00 | AAPL | Stock | 6.8357 | 6.8386 | 6.8286 | 6.8314 | 493668.0 |
| 2007-12-17 09:10:00 | AAPL | Stock | 6.83 | 6.8314 | 6.8225 | 6.8232 | 200424.0 |
| 2007-12-17 09:15:00 | AAPL | Stock | 6.8246 | 6.8293 | 6.8246 | 6.8268 | 100800.0 |
| 2007-12-17 09:20:00 | AAPL | Stock | 6.8257 | 6.8332 | 6.8257 | 6.8286 | 147056.0 |
| 2007-12-17 09:25:00 | AAPL | Stock | 6.8282 | 6.8286 | 6.8071 | 6.8111 | 894572.0 |
| 2007-12-17 09:30:00 | AAPL | Stock | 6.8111 | 6.8675 | 6.8104 | 6.8589 | 27366584.0 |
| 2007-12-17 09:35:00 | AAPL | Stock | 6.8593 | 6.8804 | 6.85 | 6.8571 | 23617944.0 |
| 2007-12-17 09:40:00 | AAPL | Stock | 6.8568 | 6.8711 | 6.8314 | 6.8411 | 19358836.0 |
| 2007-12-17 09:45:00 | AAPL | Stock | 6.8411 | 6.8536 | 6.8311 | 6.85 | 17440136.0 |
| 2007-12-17 09:50:00 | AAPL | Stock | 6.8511 | 6.8521 | 6.8168 | 6.8246 | 15729476.0 |
| 2007-12-17 09:55:00 | AAPL | Stock | 6.8254 | 6.8457 | 6.8196 | 6.825 | 14252280.0 |
| 2007-12-17 10:00:00 | AAPL | Stock | 6.8239 | 6.8254 | 6.8007 | 6.8061 | 15774080.0 |
| 2007-12-17 10:05:00 | AAPL | Stock | 6.8046 | 6.8118 | 6.7575 | 6.7654 | 23504236.0 |
| 2007-12-17 10:10:00 | AAPL | Stock | 6.7657 | 6.7814 | 6.7321 | 6.7321 | 22087156.0 |
| 2007-12-17 10:15:00 | AAPL | Stock | 6.7332 | 6.7529 | 6.7286 | 6.7396 | 22596728.0 |
| 2007-12-17 10:20:00 | AAPL | Stock | 6.74 | 6.7668 | 6.7389 | 6.7554 | 17968160.0 |
| 2007-12-17 10:25:00 | AAPL | Stock | 6.7554 | 6.7643 | 6.7382 | 6.7464 | 11143944.0 |
| 2007-12-17 10:30:00 | AAPL | Stock | 6.7454 | 6.7614 | 6.7354 | 6.7589 | 9627884.0 |
| 2007-12-17 10:35:00 | AAPL | Stock | 6.7582 | 6.8114 | 6.75 | 6.7579 | 11261684.0 |
| 2007-12-17 10:40:00 | AAPL | Stock | 6.7579 | 6.7704 | 6.7564 | 6.7611 | 6676768.0 |
| 2007-12-17 10:45:00 | AAPL | Stock | 6.7621 | 6.7804 | 6.75 | 6.7543 | 8393784.0 |
| 2007-12-17 10:50:00 | AAPL | Stock | 6.7536 | 6.7582 | 6.7414 | 6.7471 | 8095892.0 |
| 2007-12-17 10:55:00 | AAPL | Stock | 6.7481 | 6.7514 | 6.7393 | 6.7492 | 7571256.0 |
| 2007-12-17 11:00:00 | AAPL | Stock | 6.7486 | 6.7668 | 6.7439 | 6.7596 | 8563996.0 |
| 2007-12-17 11:05:00 | AAPL | Stock | 6.7593 | 6.7596 | 6.7321 | 6.7346 | 5978168.0 |
| 2007-12-17 11:10:00 | AAPL | Stock | 6.735 | 6.7446 | 6.7143 | 6.7296 | 14679672.0 |
| 2007-12-17 11:15:00 | AAPL | Stock | 6.73 | 6.7375 | 6.7232 | 6.7264 | 8686104.0 |
> showing 50 of 321,015 rows — these rows as CSV