PREVIEW / stock_5min / 2011-01-06
file: by_date/stock_5min/2011/2011-01-06.parquet size: 4.9 MB rows: 330,114 symbols: 3,520
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-01-06 05:10:00 | AAPL | Stock | 11.9968 | 11.9968 | 11.9661 | 11.9707 | 8400.0 |
| 2011-01-06 05:15:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 8400.0 |
| 2011-01-06 05:25:00 | AAPL | Stock | 11.9857 | 11.9857 | 11.9857 | 11.9857 | 2800.0 |
| 2011-01-06 05:30:00 | AAPL | Stock | 11.9786 | 11.9786 | 11.9786 | 11.9786 | 2800.0 |
| 2011-01-06 05:35:00 | AAPL | Stock | 11.9971 | 11.9971 | 11.9971 | 11.9971 | 2800.0 |
| 2011-01-06 05:40:00 | AAPL | Stock | 11.9971 | 11.9989 | 11.9971 | 11.9989 | 5600.0 |
| 2011-01-06 06:20:00 | AAPL | Stock | 12.0025 | 12.0025 | 12.0025 | 12.0025 | 3640.0 |
| 2011-01-06 06:35:00 | AAPL | Stock | 12.0279 | 12.0279 | 11.9789 | 12.025 | 8400.0 |
| 2011-01-06 06:50:00 | AAPL | Stock | 11.9821 | 12.0321 | 11.9532 | 12.0036 | 61880.0 |
| 2011-01-06 07:05:00 | AAPL | Stock | 12.0089 | 12.0107 | 12.0089 | 12.0107 | 29400.0 |
| 2011-01-06 07:10:00 | AAPL | Stock | 12.0096 | 12.0096 | 12.0096 | 12.0096 | 11200.0 |
| 2011-01-06 07:15:00 | AAPL | Stock | 12.0 | 12.0043 | 12.0 | 12.0 | 36400.0 |
| 2011-01-06 07:20:00 | AAPL | Stock | 12.0089 | 12.0089 | 12.0 | 12.0 | 8400.0 |
| 2011-01-06 07:25:00 | AAPL | Stock | 11.9971 | 11.9971 | 11.9971 | 11.9971 | 2800.0 |
| 2011-01-06 07:30:00 | AAPL | Stock | 12.0043 | 12.0071 | 12.0036 | 12.0071 | 38640.0 |
| 2011-01-06 07:35:00 | AAPL | Stock | 12.0068 | 12.0068 | 12.0036 | 12.0036 | 30800.0 |
| 2011-01-06 07:40:00 | AAPL | Stock | 12.0 | 12.0 | 11.9971 | 11.9971 | 17500.0 |
| 2011-01-06 07:50:00 | AAPL | Stock | 11.9857 | 11.9964 | 11.985 | 11.9954 | 30800.0 |
| 2011-01-06 07:55:00 | AAPL | Stock | 11.9879 | 11.9954 | 11.9871 | 11.9871 | 19600.0 |
| 2011-01-06 08:00:00 | AAPL | Stock | 11.9821 | 12.0 | 11.9821 | 12.0 | 184632.0 |
| 2011-01-06 08:05:00 | AAPL | Stock | 12.0004 | 12.0125 | 12.0 | 12.0114 | 234780.0 |
| 2011-01-06 08:10:00 | AAPL | Stock | 12.0136 | 12.0168 | 12.0036 | 12.0039 | 194264.0 |
| 2011-01-06 08:15:00 | AAPL | Stock | 12.0039 | 12.0039 | 11.9946 | 11.9993 | 171528.0 |
| 2011-01-06 08:20:00 | AAPL | Stock | 11.9982 | 12.0036 | 11.9929 | 12.0 | 136248.0 |
| 2011-01-06 08:25:00 | AAPL | Stock | 12.0 | 12.0 | 11.9929 | 11.9964 | 34496.0 |
| 2011-01-06 08:30:00 | AAPL | Stock | 12.0 | 12.0054 | 11.9911 | 11.9971 | 249788.0 |
| 2011-01-06 08:35:00 | AAPL | Stock | 11.9914 | 11.9964 | 11.9825 | 11.9893 | 196280.0 |
| 2011-01-06 08:40:00 | AAPL | Stock | 11.9911 | 11.9954 | 11.9286 | 11.9814 | 251216.0 |
| 2011-01-06 08:45:00 | AAPL | Stock | 11.9814 | 11.9839 | 11.9757 | 11.9786 | 154308.0 |
| 2011-01-06 08:50:00 | AAPL | Stock | 11.9764 | 11.9821 | 11.9714 | 11.9757 | 88900.0 |
| 2011-01-06 08:55:00 | AAPL | Stock | 11.9789 | 11.9839 | 11.9789 | 11.9836 | 92120.0 |
| 2011-01-06 09:00:00 | AAPL | Stock | 11.9796 | 11.9854 | 11.9793 | 11.9793 | 151284.0 |
| 2011-01-06 09:05:00 | AAPL | Stock | 11.9796 | 11.985 | 11.975 | 11.975 | 222460.0 |
| 2011-01-06 09:10:00 | AAPL | Stock | 11.9754 | 11.9768 | 11.9646 | 11.9764 | 59220.0 |
| 2011-01-06 09:15:00 | AAPL | Stock | 11.9779 | 11.9793 | 11.9661 | 11.9679 | 246372.0 |
| 2011-01-06 09:20:00 | AAPL | Stock | 11.9711 | 11.9711 | 11.9525 | 11.9571 | 403592.0 |
| 2011-01-06 09:25:00 | AAPL | Stock | 11.9639 | 11.9768 | 11.9536 | 11.9632 | 682808.0 |
| 2011-01-06 09:30:00 | AAPL | Stock | 11.9632 | 11.9725 | 11.9396 | 11.9443 | 7146692.0 |
| 2011-01-06 09:35:00 | AAPL | Stock | 11.9432 | 11.946 | 11.9129 | 11.92 | 9087680.0 |
| 2011-01-06 09:40:00 | AAPL | Stock | 11.9182 | 11.9521 | 11.9168 | 11.9511 | 8282988.0 |
| 2011-01-06 09:45:00 | AAPL | Stock | 11.9521 | 11.9679 | 11.9482 | 11.9643 | 8844360.0 |
| 2011-01-06 09:50:00 | AAPL | Stock | 11.9639 | 11.9679 | 11.9611 | 11.9642 | 4423860.0 |
| 2011-01-06 09:55:00 | AAPL | Stock | 11.9641 | 11.9671 | 11.9464 | 11.9464 | 4428648.0 |
| 2011-01-06 10:00:00 | AAPL | Stock | 11.9464 | 11.9646 | 11.9457 | 11.9568 | 5735072.0 |
| 2011-01-06 10:05:00 | AAPL | Stock | 11.9546 | 11.9654 | 11.9543 | 11.9571 | 3183600.0 |
| 2011-01-06 10:10:00 | AAPL | Stock | 11.9582 | 11.9707 | 11.9468 | 11.9546 | 5749128.0 |
| 2011-01-06 10:15:00 | AAPL | Stock | 11.9546 | 11.9643 | 11.9536 | 11.9643 | 3122840.0 |
| 2011-01-06 10:20:00 | AAPL | Stock | 11.9639 | 11.9689 | 11.9614 | 11.9654 | 4011504.0 |
| 2011-01-06 10:25:00 | AAPL | Stock | 11.9654 | 11.9668 | 11.9571 | 11.9639 | 2482340.0 |
| 2011-01-06 10:30:00 | AAPL | Stock | 11.9639 | 11.9656 | 11.9561 | 11.9629 | 2597980.0 |
> showing 50 of 330,114 rows — these rows as CSV