PREVIEW / stock_5min / 2011-05-26
file: by_date/stock_5min/2011/2011-05-26.parquet size: 4.8 MB rows: 325,882 symbols: 3,534
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-05-26 04:55:00 | AAPL | Stock | 12.0357 | 12.0357 | 12.0357 | 12.0357 | 2800.0 |
| 2011-05-26 05:00:00 | AAPL | Stock | 12.0357 | 12.0357 | 12.0357 | 12.0357 | 5600.0 |
| 2011-05-26 05:35:00 | AAPL | Stock | 12.0357 | 12.0357 | 12.0357 | 12.0357 | 2800.0 |
| 2011-05-26 06:00:00 | AAPL | Stock | 12.0607 | 12.0607 | 12.0607 | 12.0607 | 2800.0 |
| 2011-05-26 06:15:00 | AAPL | Stock | 12.0461 | 12.0461 | 12.0461 | 12.0461 | 2800.0 |
| 2011-05-26 07:00:00 | AAPL | Stock | 12.0532 | 12.0532 | 12.0532 | 12.0532 | 5600.0 |
| 2011-05-26 07:15:00 | AAPL | Stock | 12.0436 | 12.0436 | 12.0436 | 12.0436 | 12320.0 |
| 2011-05-26 07:25:00 | AAPL | Stock | 12.0393 | 12.0393 | 12.0393 | 12.0393 | 2800.0 |
| 2011-05-26 07:30:00 | AAPL | Stock | 12.0393 | 12.0393 | 12.0393 | 12.0393 | 2800.0 |
| 2011-05-26 07:35:00 | AAPL | Stock | 12.0393 | 12.0393 | 12.0393 | 12.0393 | 2800.0 |
| 2011-05-26 07:40:00 | AAPL | Stock | 12.04 | 12.04 | 12.0357 | 12.0357 | 9520.0 |
| 2011-05-26 08:00:00 | AAPL | Stock | 12.0432 | 12.0571 | 12.0357 | 12.0536 | 225764.0 |
| 2011-05-26 08:05:00 | AAPL | Stock | 12.0443 | 12.0571 | 12.0443 | 12.0571 | 21000.0 |
| 2011-05-26 08:10:00 | AAPL | Stock | 12.0564 | 12.0564 | 12.0536 | 12.0536 | 60956.0 |
| 2011-05-26 08:15:00 | AAPL | Stock | 12.0464 | 12.0525 | 12.0443 | 12.0525 | 26404.0 |
| 2011-05-26 08:20:00 | AAPL | Stock | 12.0514 | 12.0514 | 12.0475 | 12.05 | 17500.0 |
| 2011-05-26 08:25:00 | AAPL | Stock | 12.05 | 12.05 | 12.0479 | 12.0479 | 69580.0 |
| 2011-05-26 08:30:00 | AAPL | Stock | 12.0479 | 12.0479 | 12.0182 | 12.0204 | 245336.0 |
| 2011-05-26 08:35:00 | AAPL | Stock | 12.0179 | 12.0196 | 11.9911 | 12.0132 | 185416.0 |
| 2011-05-26 08:40:00 | AAPL | Stock | 12.0036 | 12.0068 | 12.0036 | 12.0068 | 15960.0 |
| 2011-05-26 08:45:00 | AAPL | Stock | 12.0036 | 12.0196 | 12.0036 | 12.0179 | 102340.0 |
| 2011-05-26 08:50:00 | AAPL | Stock | 12.0179 | 12.0214 | 12.0018 | 12.0071 | 103992.0 |
| 2011-05-26 08:55:00 | AAPL | Stock | 12.0107 | 12.0107 | 12.0107 | 12.0107 | 36568.0 |
| 2011-05-26 09:00:00 | AAPL | Stock | 12.0011 | 12.01 | 12.0004 | 12.01 | 74256.0 |
| 2011-05-26 09:05:00 | AAPL | Stock | 12.0104 | 12.0125 | 12.0089 | 12.0107 | 27720.0 |
| 2011-05-26 09:10:00 | AAPL | Stock | 12.0107 | 12.0143 | 11.9968 | 11.9971 | 72800.0 |
| 2011-05-26 09:15:00 | AAPL | Stock | 11.9971 | 12.0043 | 11.9971 | 12.0043 | 5600.0 |
| 2011-05-26 09:20:00 | AAPL | Stock | 11.9986 | 11.9986 | 11.9968 | 11.9971 | 11256.0 |
| 2011-05-26 09:25:00 | AAPL | Stock | 12.0 | 12.0 | 11.9929 | 11.9929 | 26264.0 |
| 2011-05-26 09:30:00 | AAPL | Stock | 11.9929 | 12.0264 | 11.9821 | 12.0214 | 9947728.0 |
| 2011-05-26 09:35:00 | AAPL | Stock | 12.0196 | 12.0318 | 11.9739 | 11.9768 | 8601964.0 |
| 2011-05-26 09:40:00 | AAPL | Stock | 11.9746 | 11.9946 | 11.9743 | 11.9857 | 5869220.0 |
| 2011-05-26 09:45:00 | AAPL | Stock | 11.9854 | 11.9986 | 11.9789 | 11.9973 | 4545492.0 |
| 2011-05-26 09:50:00 | AAPL | Stock | 11.9989 | 12.0182 | 11.9875 | 11.9903 | 6650700.0 |
| 2011-05-26 09:55:00 | AAPL | Stock | 11.9904 | 11.9904 | 11.9596 | 11.9661 | 10636780.0 |
| 2011-05-26 10:00:00 | AAPL | Stock | 11.964 | 11.9782 | 11.9579 | 11.9734 | 4899888.0 |
| 2011-05-26 10:05:00 | AAPL | Stock | 11.9732 | 11.99 | 11.9718 | 11.9779 | 4925200.0 |
| 2011-05-26 10:10:00 | AAPL | Stock | 11.9782 | 11.9807 | 11.9575 | 11.9668 | 3962056.0 |
| 2011-05-26 10:15:00 | AAPL | Stock | 11.9668 | 11.9768 | 11.9661 | 11.9707 | 2081464.0 |
| 2011-05-26 10:20:00 | AAPL | Stock | 11.9704 | 11.9862 | 11.9632 | 11.9771 | 3299744.0 |
| 2011-05-26 10:25:00 | AAPL | Stock | 11.9761 | 11.9797 | 11.9607 | 11.9654 | 2728488.0 |
| 2011-05-26 10:30:00 | AAPL | Stock | 11.9643 | 11.9675 | 11.9507 | 11.9575 | 3837512.0 |
| 2011-05-26 10:35:00 | AAPL | Stock | 11.9584 | 11.9736 | 11.9518 | 11.9669 | 2480380.0 |
| 2011-05-26 10:40:00 | AAPL | Stock | 11.9669 | 11.9732 | 11.9514 | 11.9707 | 2918776.0 |
| 2011-05-26 10:45:00 | AAPL | Stock | 11.9708 | 11.9714 | 11.9618 | 11.9668 | 3001880.0 |
| 2011-05-26 10:50:00 | AAPL | Stock | 11.9671 | 11.9721 | 11.9571 | 11.9621 | 2903936.0 |
| 2011-05-26 10:55:00 | AAPL | Stock | 11.9611 | 11.9632 | 11.9529 | 11.9536 | 2415924.0 |
| 2011-05-26 11:00:00 | AAPL | Stock | 11.9546 | 11.9632 | 11.9464 | 11.9532 | 2882320.0 |
| 2011-05-26 11:05:00 | AAPL | Stock | 11.9511 | 11.9617 | 11.9441 | 11.9601 | 2999640.0 |
| 2011-05-26 11:10:00 | AAPL | Stock | 11.9604 | 11.9661 | 11.9546 | 11.9604 | 2786644.0 |
> showing 50 of 325,882 rows — these rows as CSV