PREVIEW / stock_5min / 2010-11-15
file: by_date/stock_5min/2010/2010-11-15.parquet size: 4.8 MB rows: 325,836 symbols: 3,507
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-15 04:05:00 | AAPL | Stock | 11.0154 | 11.0154 | 11.0154 | 11.0154 | 2800.0 |
| 2010-11-15 06:20:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 3640.0 |
| 2010-11-15 06:40:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 8400.0 |
| 2010-11-15 06:45:00 | AAPL | Stock | 11.0625 | 11.0625 | 11.0625 | 11.0625 | 25200.0 |
| 2010-11-15 06:50:00 | AAPL | Stock | 11.0625 | 11.0625 | 11.0625 | 11.0625 | 5600.0 |
| 2010-11-15 07:00:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 5600.0 |
| 2010-11-15 07:05:00 | AAPL | Stock | 11.0464 | 11.0532 | 11.0446 | 11.0532 | 8400.0 |
| 2010-11-15 07:10:00 | AAPL | Stock | 11.0546 | 11.0611 | 11.0539 | 11.0611 | 116200.0 |
| 2010-11-15 07:15:00 | AAPL | Stock | 11.0611 | 11.0611 | 11.0611 | 11.0611 | 19880.0 |
| 2010-11-15 07:20:00 | AAPL | Stock | 11.0611 | 11.0693 | 11.0611 | 11.0611 | 75488.0 |
| 2010-11-15 07:25:00 | AAPL | Stock | 11.0611 | 11.0611 | 11.0564 | 11.0564 | 12600.0 |
| 2010-11-15 07:30:00 | AAPL | Stock | 11.0579 | 11.0579 | 11.0579 | 11.0579 | 2800.0 |
| 2010-11-15 07:35:00 | AAPL | Stock | 11.0611 | 11.0689 | 11.0611 | 11.0689 | 53200.0 |
| 2010-11-15 07:40:00 | AAPL | Stock | 11.0671 | 11.0707 | 11.0586 | 11.0707 | 22260.0 |
| 2010-11-15 07:45:00 | AAPL | Stock | 11.0718 | 11.0718 | 11.0707 | 11.0714 | 42308.0 |
| 2010-11-15 07:50:00 | AAPL | Stock | 11.0732 | 11.0732 | 11.0714 | 11.0714 | 31108.0 |
| 2010-11-15 07:55:00 | AAPL | Stock | 11.0714 | 11.0764 | 11.0714 | 11.0714 | 25200.0 |
| 2010-11-15 08:00:00 | AAPL | Stock | 11.0625 | 11.0786 | 11.0489 | 11.0782 | 435540.0 |
| 2010-11-15 08:05:00 | AAPL | Stock | 11.0786 | 11.0786 | 11.0571 | 11.0714 | 484624.0 |
| 2010-11-15 08:10:00 | AAPL | Stock | 11.0714 | 11.0786 | 11.0682 | 11.0746 | 212996.0 |
| 2010-11-15 08:15:00 | AAPL | Stock | 11.0746 | 11.0786 | 11.065 | 11.0654 | 383152.0 |
| 2010-11-15 08:20:00 | AAPL | Stock | 11.0646 | 11.0714 | 11.0643 | 11.0646 | 142016.0 |
| 2010-11-15 08:25:00 | AAPL | Stock | 11.0693 | 11.0714 | 11.0661 | 11.0707 | 129220.0 |
| 2010-11-15 08:30:00 | AAPL | Stock | 11.0668 | 11.0714 | 11.0557 | 11.0621 | 350868.0 |
| 2010-11-15 08:35:00 | AAPL | Stock | 11.0614 | 11.0643 | 11.0554 | 11.0604 | 164360.0 |
| 2010-11-15 08:40:00 | AAPL | Stock | 11.0579 | 11.0618 | 11.0579 | 11.0589 | 58800.0 |
| 2010-11-15 08:45:00 | AAPL | Stock | 11.0607 | 11.0607 | 11.0571 | 11.0596 | 82320.0 |
| 2010-11-15 08:50:00 | AAPL | Stock | 11.0593 | 11.0621 | 11.0554 | 11.0621 | 121016.0 |
| 2010-11-15 08:55:00 | AAPL | Stock | 11.0636 | 11.0746 | 11.0621 | 11.0714 | 857500.0 |
| 2010-11-15 09:00:00 | AAPL | Stock | 11.0718 | 11.0761 | 11.0675 | 11.0711 | 258300.0 |
| 2010-11-15 09:05:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0625 | 11.0625 | 125300.0 |
| 2010-11-15 09:10:00 | AAPL | Stock | 11.0625 | 11.0679 | 11.0604 | 11.0646 | 195076.0 |
| 2010-11-15 09:15:00 | AAPL | Stock | 11.0661 | 11.0682 | 11.0643 | 11.0679 | 116900.0 |
| 2010-11-15 09:20:00 | AAPL | Stock | 11.0668 | 11.0696 | 11.0614 | 11.0643 | 135492.0 |
| 2010-11-15 09:25:00 | AAPL | Stock | 11.0679 | 11.0732 | 11.0182 | 11.0182 | 631848.0 |
| 2010-11-15 09:30:00 | AAPL | Stock | 11.0182 | 11.0661 | 11.0132 | 11.0471 | 15236396.0 |
| 2010-11-15 09:35:00 | AAPL | Stock | 11.0511 | 11.0871 | 11.0429 | 11.0857 | 14380856.0 |
| 2010-11-15 09:40:00 | AAPL | Stock | 11.0854 | 11.0907 | 11.0679 | 11.0707 | 9414832.0 |
| 2010-11-15 09:45:00 | AAPL | Stock | 11.0696 | 11.0709 | 11.0268 | 11.0314 | 8544424.0 |
| 2010-11-15 09:50:00 | AAPL | Stock | 11.0318 | 11.0361 | 10.9964 | 11.0007 | 14207312.0 |
| 2010-11-15 09:55:00 | AAPL | Stock | 11.0004 | 11.0289 | 11.0 | 11.0068 | 7744604.0 |
| 2010-11-15 10:00:00 | AAPL | Stock | 11.0054 | 11.0054 | 10.9554 | 10.9796 | 13854316.0 |
| 2010-11-15 10:05:00 | AAPL | Stock | 10.9793 | 10.9827 | 10.9382 | 10.9507 | 10636192.0 |
| 2010-11-15 10:10:00 | AAPL | Stock | 10.9507 | 10.9904 | 10.9464 | 10.9889 | 8173088.0 |
| 2010-11-15 10:15:00 | AAPL | Stock | 10.9882 | 11.0175 | 10.9779 | 11.0139 | 8629768.0 |
| 2010-11-15 10:20:00 | AAPL | Stock | 11.0154 | 11.0232 | 10.9932 | 11.0214 | 7726012.0 |
| 2010-11-15 10:25:00 | AAPL | Stock | 11.0232 | 11.0471 | 11.0204 | 11.0257 | 11750592.0 |
| 2010-11-15 10:30:00 | AAPL | Stock | 11.0268 | 11.0464 | 11.0154 | 11.0154 | 6319656.0 |
| 2010-11-15 10:35:00 | AAPL | Stock | 11.0164 | 11.0525 | 11.0121 | 11.0514 | 5712000.0 |
| 2010-11-15 10:40:00 | AAPL | Stock | 11.0525 | 11.0554 | 11.0414 | 11.045 | 5195960.0 |
> showing 50 of 325,836 rows — these rows as CSV