PREVIEW / stock_5min / 2006-11-09
file: by_date/stock_5min/2006/2006-11-09.parquet size: 3.3 MB rows: 239,056 symbols: 2,425
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-09 07:20:00 | AAPL | Stock | 2.9607 | 2.9607 | 2.9607 | 2.9607 | 22400.0 |
| 2006-11-09 07:25:00 | AAPL | Stock | 2.9607 | 2.9621 | 2.9607 | 2.9614 | 42000.0 |
| 2006-11-09 07:35:00 | AAPL | Stock | 2.9643 | 2.9704 | 2.9643 | 2.9679 | 168000.0 |
| 2006-11-09 07:40:00 | AAPL | Stock | 2.9675 | 2.9689 | 2.9675 | 2.9675 | 164808.0 |
| 2006-11-09 07:45:00 | AAPL | Stock | 2.9689 | 2.9689 | 2.9646 | 2.9646 | 39200.0 |
| 2006-11-09 07:50:00 | AAPL | Stock | 2.9625 | 2.9625 | 2.9625 | 2.9625 | 14000.0 |
| 2006-11-09 07:55:00 | AAPL | Stock | 2.9571 | 2.9607 | 2.9571 | 2.9607 | 30800.0 |
| 2006-11-09 08:00:00 | AAPL | Stock | 2.9625 | 2.9679 | 2.9607 | 2.9643 | 969668.0 |
| 2006-11-09 08:05:00 | AAPL | Stock | 2.9643 | 2.9643 | 2.9589 | 2.9607 | 181160.0 |
| 2006-11-09 08:10:00 | AAPL | Stock | 2.9589 | 2.9643 | 2.9589 | 2.9639 | 381864.0 |
| 2006-11-09 08:15:00 | AAPL | Stock | 2.9607 | 2.9643 | 2.9607 | 2.9643 | 225120.0 |
| 2006-11-09 08:20:00 | AAPL | Stock | 2.9607 | 2.9636 | 2.9589 | 2.9607 | 80920.0 |
| 2006-11-09 08:25:00 | AAPL | Stock | 2.9593 | 2.9593 | 2.9589 | 2.9589 | 98000.0 |
| 2006-11-09 08:30:00 | AAPL | Stock | 2.9607 | 2.9632 | 2.9589 | 2.9614 | 30800.0 |
| 2006-11-09 08:35:00 | AAPL | Stock | 2.9614 | 2.9625 | 2.9596 | 2.9596 | 230440.0 |
| 2006-11-09 08:40:00 | AAPL | Stock | 2.9607 | 2.9643 | 2.9589 | 2.9636 | 329000.0 |
| 2006-11-09 08:45:00 | AAPL | Stock | 2.9643 | 2.9643 | 2.9571 | 2.9571 | 84280.0 |
| 2006-11-09 08:50:00 | AAPL | Stock | 2.9589 | 2.9589 | 2.9571 | 2.9589 | 99960.0 |
| 2006-11-09 08:55:00 | AAPL | Stock | 2.9575 | 2.9639 | 2.9571 | 2.9625 | 330680.0 |
| 2006-11-09 09:00:00 | AAPL | Stock | 2.9639 | 2.9646 | 2.9625 | 2.9643 | 551992.0 |
| 2006-11-09 09:05:00 | AAPL | Stock | 2.9643 | 2.9643 | 2.9625 | 2.9625 | 192220.0 |
| 2006-11-09 09:10:00 | AAPL | Stock | 2.9636 | 2.9689 | 2.9625 | 2.9675 | 333620.0 |
| 2006-11-09 09:15:00 | AAPL | Stock | 2.9671 | 2.9689 | 2.9664 | 2.9664 | 248220.0 |
| 2006-11-09 09:20:00 | AAPL | Stock | 2.9664 | 2.9664 | 2.9536 | 2.9625 | 634004.0 |
| 2006-11-09 09:25:00 | AAPL | Stock | 2.9604 | 2.9643 | 2.9589 | 2.9625 | 880600.0 |
| 2006-11-09 09:30:00 | AAPL | Stock | 2.9607 | 2.9689 | 2.955 | 2.9567 | 32721528.0 |
| 2006-11-09 09:35:00 | AAPL | Stock | 2.9564 | 2.9707 | 2.9564 | 2.9657 | 19173700.0 |
| 2006-11-09 09:40:00 | AAPL | Stock | 2.9657 | 2.9668 | 2.95 | 2.9571 | 17911964.0 |
| 2006-11-09 09:45:00 | AAPL | Stock | 2.9571 | 2.9689 | 2.9568 | 2.96 | 13755112.0 |
| 2006-11-09 09:50:00 | AAPL | Stock | 2.9597 | 2.9621 | 2.9536 | 2.9604 | 15542324.0 |
| 2006-11-09 09:55:00 | AAPL | Stock | 2.9604 | 2.9611 | 2.9464 | 2.9521 | 18745188.0 |
| 2006-11-09 10:00:00 | AAPL | Stock | 2.9525 | 2.955 | 2.9454 | 2.9454 | 20787620.0 |
| 2006-11-09 10:05:00 | AAPL | Stock | 2.9457 | 2.9464 | 2.9329 | 2.9436 | 19391148.0 |
| 2006-11-09 10:10:00 | AAPL | Stock | 2.9436 | 2.9521 | 2.9432 | 2.9507 | 11053476.0 |
| 2006-11-09 10:15:00 | AAPL | Stock | 2.9507 | 2.9589 | 2.9507 | 2.9561 | 10198664.0 |
| 2006-11-09 10:20:00 | AAPL | Stock | 2.9557 | 2.9636 | 2.9532 | 2.9607 | 10137092.0 |
| 2006-11-09 10:25:00 | AAPL | Stock | 2.9607 | 2.9743 | 2.9607 | 2.9707 | 22540168.0 |
| 2006-11-09 10:30:00 | AAPL | Stock | 2.9707 | 2.9732 | 2.9671 | 2.9721 | 11248552.0 |
| 2006-11-09 10:35:00 | AAPL | Stock | 2.9721 | 2.9821 | 2.97 | 2.9818 | 21624428.0 |
| 2006-11-09 10:40:00 | AAPL | Stock | 2.9821 | 2.9914 | 2.9818 | 2.9904 | 22089592.0 |
| 2006-11-09 10:45:00 | AAPL | Stock | 2.99 | 2.9954 | 2.9857 | 2.9914 | 24151708.0 |
| 2006-11-09 10:50:00 | AAPL | Stock | 2.9911 | 2.9989 | 2.9896 | 2.9936 | 19638080.0 |
| 2006-11-09 10:55:00 | AAPL | Stock | 2.9936 | 2.9946 | 2.9911 | 2.9939 | 8691228.0 |
| 2006-11-09 11:00:00 | AAPL | Stock | 2.9943 | 2.9943 | 2.9879 | 2.9889 | 12282424.0 |
| 2006-11-09 11:05:00 | AAPL | Stock | 2.9889 | 2.9921 | 2.9882 | 2.9914 | 6620264.0 |
| 2006-11-09 11:10:00 | AAPL | Stock | 2.9914 | 2.9964 | 2.9907 | 2.9957 | 8290380.0 |
| 2006-11-09 11:15:00 | AAPL | Stock | 2.9957 | 3.0011 | 2.9918 | 2.9939 | 14052528.0 |
| 2006-11-09 11:20:00 | AAPL | Stock | 2.9936 | 2.9939 | 2.9879 | 2.9893 | 9816828.0 |
| 2006-11-09 11:25:00 | AAPL | Stock | 2.9889 | 2.9925 | 2.985 | 2.9911 | 12756800.0 |
| 2006-11-09 11:30:00 | AAPL | Stock | 2.9911 | 2.9929 | 2.9871 | 2.99 | 6346200.0 |
> showing 50 of 239,056 rows — these rows as CSV