PREVIEW / stock_5min / 2008-01-25
file: by_date/stock_5min/2008/2008-01-25.parquet size: 4.5 MB rows: 320,158 symbols: 3,270
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-25 04:35:00 | AAPL | Stock | 4.9461 | 4.9464 | 4.9461 | 4.9464 | 11200.0 |
| 2008-01-25 05:20:00 | AAPL | Stock | 4.9718 | 4.9718 | 4.9718 | 4.9718 | 5600.0 |
| 2008-01-25 05:25:00 | AAPL | Stock | 4.9839 | 4.9839 | 4.9839 | 4.9839 | 2940.0 |
| 2008-01-25 06:10:00 | AAPL | Stock | 4.9732 | 4.9732 | 4.9732 | 4.9732 | 8400.0 |
| 2008-01-25 06:20:00 | AAPL | Stock | 4.9732 | 4.9732 | 4.9732 | 4.9732 | 8400.0 |
| 2008-01-25 06:35:00 | AAPL | Stock | 4.9639 | 4.9639 | 4.9589 | 4.9589 | 42000.0 |
| 2008-01-25 06:40:00 | AAPL | Stock | 4.9586 | 4.9586 | 4.9586 | 4.9586 | 5600.0 |
| 2008-01-25 06:45:00 | AAPL | Stock | 4.9586 | 4.9586 | 4.9464 | 4.9464 | 11200.0 |
| 2008-01-25 06:50:00 | AAPL | Stock | 4.9464 | 4.9604 | 4.9464 | 4.9604 | 10472.0 |
| 2008-01-25 06:55:00 | AAPL | Stock | 4.9464 | 4.9607 | 4.9464 | 4.9593 | 19600.0 |
| 2008-01-25 07:00:00 | AAPL | Stock | 4.9471 | 4.9607 | 4.9464 | 4.9464 | 76300.0 |
| 2008-01-25 07:05:00 | AAPL | Stock | 4.9464 | 4.9586 | 4.9464 | 4.95 | 23380.0 |
| 2008-01-25 07:10:00 | AAPL | Stock | 4.9464 | 4.9464 | 4.9393 | 4.9393 | 38500.0 |
| 2008-01-25 07:15:00 | AAPL | Stock | 4.9396 | 4.9396 | 4.9325 | 4.9389 | 50400.0 |
| 2008-01-25 07:20:00 | AAPL | Stock | 4.9393 | 4.9393 | 4.9393 | 4.9393 | 5600.0 |
| 2008-01-25 07:25:00 | AAPL | Stock | 4.9464 | 4.9464 | 4.9375 | 4.9375 | 39228.0 |
| 2008-01-25 07:30:00 | AAPL | Stock | 4.9446 | 4.9446 | 4.9368 | 4.9368 | 42532.0 |
| 2008-01-25 07:35:00 | AAPL | Stock | 4.9357 | 4.9446 | 4.9325 | 4.9325 | 56000.0 |
| 2008-01-25 07:40:00 | AAPL | Stock | 4.9429 | 4.9429 | 4.9429 | 4.9429 | 11760.0 |
| 2008-01-25 07:45:00 | AAPL | Stock | 4.9325 | 4.9425 | 4.9275 | 4.9286 | 186900.0 |
| 2008-01-25 07:50:00 | AAPL | Stock | 4.9286 | 4.9286 | 4.9196 | 4.9196 | 81480.0 |
| 2008-01-25 07:55:00 | AAPL | Stock | 4.9196 | 4.9286 | 4.9196 | 4.9214 | 47320.0 |
| 2008-01-25 08:00:00 | AAPL | Stock | 4.9271 | 4.9286 | 4.9054 | 4.9107 | 1245440.0 |
| 2008-01-25 08:05:00 | AAPL | Stock | 4.9104 | 4.9175 | 4.8957 | 4.9175 | 357756.0 |
| 2008-01-25 08:10:00 | AAPL | Stock | 4.9107 | 4.9225 | 4.9079 | 4.9214 | 578480.0 |
| 2008-01-25 08:15:00 | AAPL | Stock | 4.9239 | 4.9354 | 4.9239 | 4.9286 | 458248.0 |
| 2008-01-25 08:20:00 | AAPL | Stock | 4.9275 | 4.9289 | 4.9196 | 4.9239 | 431340.0 |
| 2008-01-25 08:25:00 | AAPL | Stock | 4.9243 | 4.9246 | 4.9179 | 4.92 | 602448.0 |
| 2008-01-25 08:30:00 | AAPL | Stock | 4.9229 | 4.9368 | 4.9196 | 4.9357 | 740208.0 |
| 2008-01-25 08:35:00 | AAPL | Stock | 4.935 | 4.9643 | 4.9311 | 4.9636 | 1461684.0 |
| 2008-01-25 08:40:00 | AAPL | Stock | 4.9636 | 4.9661 | 4.9564 | 4.965 | 1819776.0 |
| 2008-01-25 08:45:00 | AAPL | Stock | 4.965 | 4.9711 | 4.9643 | 4.9675 | 1798132.0 |
| 2008-01-25 08:50:00 | AAPL | Stock | 4.9661 | 4.9679 | 4.9643 | 4.9643 | 943152.0 |
| 2008-01-25 08:55:00 | AAPL | Stock | 4.9657 | 4.9821 | 4.9554 | 4.9557 | 1267812.0 |
| 2008-01-25 09:00:00 | AAPL | Stock | 4.9571 | 4.9571 | 4.9432 | 4.9471 | 1315972.0 |
| 2008-01-25 09:05:00 | AAPL | Stock | 4.9489 | 4.96 | 4.9457 | 4.9536 | 1287552.0 |
| 2008-01-25 09:10:00 | AAPL | Stock | 4.9532 | 4.9554 | 4.95 | 4.9511 | 489104.0 |
| 2008-01-25 09:15:00 | AAPL | Stock | 4.9525 | 4.9529 | 4.9461 | 4.9486 | 668500.0 |
| 2008-01-25 09:20:00 | AAPL | Stock | 4.9464 | 4.95 | 4.9429 | 4.9454 | 536508.0 |
| 2008-01-25 09:25:00 | AAPL | Stock | 4.945 | 4.9657 | 4.9439 | 4.9643 | 2299332.0 |
| 2008-01-25 09:30:00 | AAPL | Stock | 4.9643 | 4.9675 | 4.8939 | 4.9086 | 63101584.0 |
| 2008-01-25 09:35:00 | AAPL | Stock | 4.9086 | 4.9171 | 4.8696 | 4.8729 | 38706108.0 |
| 2008-01-25 09:40:00 | AAPL | Stock | 4.87 | 4.8929 | 4.8525 | 4.8921 | 52295404.0 |
| 2008-01-25 09:45:00 | AAPL | Stock | 4.8921 | 4.9193 | 4.8786 | 4.9007 | 35380268.0 |
| 2008-01-25 09:50:00 | AAPL | Stock | 4.9007 | 4.9061 | 4.8889 | 4.8918 | 25956252.0 |
| 2008-01-25 09:55:00 | AAPL | Stock | 4.8896 | 4.9111 | 4.8875 | 4.905 | 26884592.0 |
| 2008-01-25 10:00:00 | AAPL | Stock | 4.9054 | 4.9054 | 4.8614 | 4.8813 | 28672784.0 |
| 2008-01-25 10:05:00 | AAPL | Stock | 4.8796 | 4.8889 | 4.8304 | 4.8368 | 34777512.0 |
| 2008-01-25 10:10:00 | AAPL | Stock | 4.8379 | 4.8661 | 4.8286 | 4.8482 | 31855572.0 |
| 2008-01-25 10:15:00 | AAPL | Stock | 4.8475 | 4.8704 | 4.8454 | 4.8651 | 22565984.0 |
> showing 50 of 320,158 rows — these rows as CSV