PREVIEW / stock_5min / 2011-07-25
file: by_date/stock_5min/2011/2011-07-25.parquet size: 4.7 MB rows: 322,501 symbols: 3,539
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-25 05:05:00 | AAPL | Stock | 13.9536 | 13.9536 | 13.9536 | 13.9536 | 2800.0 |
| 2011-07-25 05:10:00 | AAPL | Stock | 13.9471 | 13.9471 | 13.9471 | 13.9471 | 2800.0 |
| 2011-07-25 05:15:00 | AAPL | Stock | 13.9464 | 13.9464 | 13.9464 | 13.9464 | 2800.0 |
| 2011-07-25 05:25:00 | AAPL | Stock | 13.9736 | 13.9736 | 13.9464 | 13.9464 | 5600.0 |
| 2011-07-25 05:55:00 | AAPL | Stock | 13.9743 | 13.9743 | 13.9743 | 13.9743 | 14000.0 |
| 2011-07-25 07:00:00 | AAPL | Stock | 13.9411 | 13.9464 | 13.9311 | 13.9464 | 66360.0 |
| 2011-07-25 07:05:00 | AAPL | Stock | 13.9357 | 13.9643 | 13.9357 | 13.9643 | 132104.0 |
| 2011-07-25 07:10:00 | AAPL | Stock | 13.9668 | 13.9693 | 13.9607 | 13.9643 | 27440.0 |
| 2011-07-25 07:15:00 | AAPL | Stock | 13.9643 | 13.9679 | 13.9643 | 13.9679 | 44800.0 |
| 2011-07-25 07:20:00 | AAPL | Stock | 13.9707 | 13.9743 | 13.9707 | 13.9743 | 45640.0 |
| 2011-07-25 07:25:00 | AAPL | Stock | 13.9643 | 13.9804 | 13.9643 | 13.9768 | 109704.0 |
| 2011-07-25 07:30:00 | AAPL | Stock | 13.9804 | 13.9932 | 13.975 | 13.975 | 97020.0 |
| 2011-07-25 07:35:00 | AAPL | Stock | 13.9757 | 13.9757 | 13.9657 | 13.9657 | 39480.0 |
| 2011-07-25 07:40:00 | AAPL | Stock | 13.9757 | 13.9768 | 13.9643 | 13.9646 | 56000.0 |
| 2011-07-25 07:45:00 | AAPL | Stock | 13.9679 | 13.9679 | 13.9625 | 13.9679 | 51660.0 |
| 2011-07-25 07:50:00 | AAPL | Stock | 13.9646 | 13.9646 | 13.9646 | 13.9646 | 5600.0 |
| 2011-07-25 07:55:00 | AAPL | Stock | 13.975 | 13.9782 | 13.9661 | 13.9661 | 18060.0 |
| 2011-07-25 08:00:00 | AAPL | Stock | 13.9686 | 13.9775 | 13.935 | 13.9461 | 443660.0 |
| 2011-07-25 08:05:00 | AAPL | Stock | 13.9464 | 13.9618 | 13.9429 | 13.9618 | 285320.0 |
| 2011-07-25 08:10:00 | AAPL | Stock | 13.9636 | 13.9682 | 13.9554 | 13.9643 | 151368.0 |
| 2011-07-25 08:15:00 | AAPL | Stock | 13.9657 | 13.9714 | 13.9579 | 13.9579 | 177296.0 |
| 2011-07-25 08:20:00 | AAPL | Stock | 13.9636 | 13.9768 | 13.9636 | 13.9714 | 203784.0 |
| 2011-07-25 08:25:00 | AAPL | Stock | 13.9714 | 13.9839 | 13.9714 | 13.9839 | 101920.0 |
| 2011-07-25 08:30:00 | AAPL | Stock | 13.9821 | 13.9846 | 13.9754 | 13.98 | 260624.0 |
| 2011-07-25 08:35:00 | AAPL | Stock | 13.9736 | 13.9768 | 13.9461 | 13.9625 | 173152.0 |
| 2011-07-25 08:40:00 | AAPL | Stock | 13.9607 | 13.9632 | 13.9461 | 13.9518 | 273000.0 |
| 2011-07-25 08:45:00 | AAPL | Stock | 13.9579 | 13.9625 | 13.9504 | 13.9611 | 151256.0 |
| 2011-07-25 08:50:00 | AAPL | Stock | 13.9543 | 13.9571 | 13.9461 | 13.9461 | 193564.0 |
| 2011-07-25 08:55:00 | AAPL | Stock | 13.9464 | 13.9571 | 13.9429 | 13.9482 | 189588.0 |
| 2011-07-25 09:00:00 | AAPL | Stock | 13.9486 | 13.9596 | 13.9486 | 13.9536 | 115164.0 |
| 2011-07-25 09:05:00 | AAPL | Stock | 13.9529 | 13.9536 | 13.9464 | 13.9507 | 191520.0 |
| 2011-07-25 09:10:00 | AAPL | Stock | 13.9511 | 13.9629 | 13.9511 | 13.9607 | 249200.0 |
| 2011-07-25 09:15:00 | AAPL | Stock | 13.9604 | 13.9711 | 13.9596 | 13.9711 | 413896.0 |
| 2011-07-25 09:20:00 | AAPL | Stock | 13.9693 | 13.9771 | 13.9671 | 13.9671 | 244412.0 |
| 2011-07-25 09:25:00 | AAPL | Stock | 13.9664 | 13.97 | 13.9325 | 13.9407 | 1175608.0 |
| 2011-07-25 09:30:00 | AAPL | Stock | 13.935 | 13.9893 | 13.915 | 13.9889 | 26014884.0 |
| 2011-07-25 09:35:00 | AAPL | Stock | 13.9889 | 14.0332 | 13.9857 | 14.01 | 16536464.0 |
| 2011-07-25 09:40:00 | AAPL | Stock | 14.0093 | 14.0518 | 14.0029 | 14.0489 | 14377356.0 |
| 2011-07-25 09:45:00 | AAPL | Stock | 14.0506 | 14.0711 | 14.0236 | 14.0496 | 14942592.0 |
| 2011-07-25 09:50:00 | AAPL | Stock | 14.0486 | 14.063 | 14.0357 | 14.0486 | 10858764.0 |
| 2011-07-25 09:55:00 | AAPL | Stock | 14.0529 | 14.0661 | 14.0379 | 14.0539 | 7438844.0 |
| 2011-07-25 10:00:00 | AAPL | Stock | 14.0539 | 14.0632 | 14.0379 | 14.0414 | 6419028.0 |
| 2011-07-25 10:05:00 | AAPL | Stock | 14.0419 | 14.0629 | 14.0243 | 14.0579 | 7502460.0 |
| 2011-07-25 10:10:00 | AAPL | Stock | 14.0604 | 14.0679 | 14.0321 | 14.0436 | 6360760.0 |
| 2011-07-25 10:15:00 | AAPL | Stock | 14.0421 | 14.0682 | 14.0375 | 14.0618 | 3858960.0 |
| 2011-07-25 10:20:00 | AAPL | Stock | 14.0646 | 14.0939 | 14.0621 | 14.084 | 11751292.0 |
| 2011-07-25 10:25:00 | AAPL | Stock | 14.0879 | 14.0932 | 14.0714 | 14.0771 | 5317508.0 |
| 2011-07-25 10:30:00 | AAPL | Stock | 14.0779 | 14.0782 | 14.0614 | 14.0662 | 5147016.0 |
| 2011-07-25 10:35:00 | AAPL | Stock | 14.0661 | 14.0714 | 14.0507 | 14.0668 | 4431056.0 |
| 2011-07-25 10:40:00 | AAPL | Stock | 14.0671 | 14.1093 | 14.0657 | 14.0971 | 8451772.0 |
> showing 50 of 322,501 rows — these rows as CSV