PREVIEW / stock_5min / 2012-08-06
file: by_date/stock_5min/2012/2012-08-06.parquet size: 4.6 MB rows: 315,582 symbols: 3,463
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-06 06:25:00 | AAPL | Stock | 22.0661 | 22.0661 | 22.0554 | 22.0554 | 44800.0 |
| 2012-08-06 06:35:00 | AAPL | Stock | 22.0661 | 22.0661 | 22.0661 | 22.0661 | 11200.0 |
| 2012-08-06 06:55:00 | AAPL | Stock | 22.0625 | 22.0625 | 22.0589 | 22.0589 | 14000.0 |
| 2012-08-06 07:00:00 | AAPL | Stock | 22.0589 | 22.0664 | 22.0554 | 22.0664 | 67760.0 |
| 2012-08-06 07:05:00 | AAPL | Stock | 22.0707 | 22.0714 | 22.0593 | 22.0643 | 69272.0 |
| 2012-08-06 07:10:00 | AAPL | Stock | 22.0643 | 22.0982 | 22.0643 | 22.09 | 118048.0 |
| 2012-08-06 07:15:00 | AAPL | Stock | 22.0882 | 22.1014 | 22.0882 | 22.0961 | 26712.0 |
| 2012-08-06 07:20:00 | AAPL | Stock | 22.0943 | 22.0954 | 22.0714 | 22.0804 | 47600.0 |
| 2012-08-06 07:25:00 | AAPL | Stock | 22.0661 | 22.0661 | 22.0661 | 22.0661 | 11424.0 |
| 2012-08-06 07:30:00 | AAPL | Stock | 22.075 | 22.075 | 22.0664 | 22.0714 | 11900.0 |
| 2012-08-06 07:35:00 | AAPL | Stock | 22.0779 | 22.0846 | 22.0754 | 22.0846 | 71540.0 |
| 2012-08-06 07:40:00 | AAPL | Stock | 22.0857 | 22.0929 | 22.0857 | 22.0868 | 70000.0 |
| 2012-08-06 07:45:00 | AAPL | Stock | 22.0875 | 22.0946 | 22.0864 | 22.0946 | 27524.0 |
| 2012-08-06 07:50:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0946 | 22.0946 | 22792.0 |
| 2012-08-06 07:55:00 | AAPL | Stock | 22.0946 | 22.0946 | 22.0914 | 22.0946 | 22400.0 |
| 2012-08-06 08:00:00 | AAPL | Stock | 22.0875 | 22.0921 | 22.0725 | 22.09 | 205296.0 |
| 2012-08-06 08:05:00 | AAPL | Stock | 22.0861 | 22.0893 | 22.0714 | 22.0725 | 267204.0 |
| 2012-08-06 08:10:00 | AAPL | Stock | 22.0757 | 22.0821 | 22.0714 | 22.0768 | 253484.0 |
| 2012-08-06 08:15:00 | AAPL | Stock | 22.0771 | 22.0811 | 22.0714 | 22.0721 | 61600.0 |
| 2012-08-06 08:20:00 | AAPL | Stock | 22.0775 | 22.0839 | 22.0714 | 22.0789 | 113008.0 |
| 2012-08-06 08:25:00 | AAPL | Stock | 22.0789 | 22.0807 | 22.0764 | 22.0789 | 27048.0 |
| 2012-08-06 08:30:00 | AAPL | Stock | 22.0825 | 22.085 | 22.0789 | 22.085 | 25480.0 |
| 2012-08-06 08:35:00 | AAPL | Stock | 22.0821 | 22.0861 | 22.075 | 22.075 | 108500.0 |
| 2012-08-06 08:40:00 | AAPL | Stock | 22.0821 | 22.0821 | 22.0779 | 22.0821 | 115220.0 |
| 2012-08-06 08:45:00 | AAPL | Stock | 22.0821 | 22.0857 | 22.075 | 22.075 | 95200.0 |
| 2012-08-06 08:50:00 | AAPL | Stock | 22.0768 | 22.0779 | 22.0689 | 22.0725 | 147196.0 |
| 2012-08-06 08:55:00 | AAPL | Stock | 22.0739 | 22.0746 | 22.0689 | 22.0743 | 55580.0 |
| 2012-08-06 09:00:00 | AAPL | Stock | 22.0743 | 22.0821 | 22.0714 | 22.0821 | 209440.0 |
| 2012-08-06 09:05:00 | AAPL | Stock | 22.0811 | 22.0893 | 22.075 | 22.0821 | 288092.0 |
| 2012-08-06 09:10:00 | AAPL | Stock | 22.0818 | 22.0893 | 22.0789 | 22.0893 | 110292.0 |
| 2012-08-06 09:15:00 | AAPL | Stock | 22.0893 | 22.0918 | 22.0714 | 22.0725 | 99876.0 |
| 2012-08-06 09:20:00 | AAPL | Stock | 22.0786 | 22.0786 | 22.0625 | 22.0625 | 211344.0 |
| 2012-08-06 09:25:00 | AAPL | Stock | 22.0586 | 22.07 | 22.0361 | 22.0393 | 496496.0 |
| 2012-08-06 09:30:00 | AAPL | Stock | 22.0411 | 22.0554 | 21.9911 | 22.0024 | 10818108.0 |
| 2012-08-06 09:35:00 | AAPL | Stock | 22.0014 | 22.0921 | 21.9736 | 22.0382 | 12398092.0 |
| 2012-08-06 09:40:00 | AAPL | Stock | 22.0404 | 22.0796 | 22.025 | 22.065 | 5060524.0 |
| 2012-08-06 09:45:00 | AAPL | Stock | 22.0629 | 22.1029 | 22.0482 | 22.0836 | 7045724.0 |
| 2012-08-06 09:50:00 | AAPL | Stock | 22.0829 | 22.0914 | 22.0357 | 22.0575 | 5201448.0 |
| 2012-08-06 09:55:00 | AAPL | Stock | 22.0589 | 22.0964 | 22.0589 | 22.0646 | 3976980.0 |
| 2012-08-06 10:00:00 | AAPL | Stock | 22.0622 | 22.09 | 22.0536 | 22.0729 | 4373740.0 |
| 2012-08-06 10:05:00 | AAPL | Stock | 22.0778 | 22.1154 | 22.0704 | 22.0986 | 7552272.0 |
| 2012-08-06 10:10:00 | AAPL | Stock | 22.1021 | 22.1121 | 22.0843 | 22.0864 | 3723944.0 |
| 2012-08-06 10:15:00 | AAPL | Stock | 22.0861 | 22.1018 | 22.0714 | 22.096 | 3923864.0 |
| 2012-08-06 10:20:00 | AAPL | Stock | 22.0975 | 22.1007 | 22.0757 | 22.0786 | 1977752.0 |
| 2012-08-06 10:25:00 | AAPL | Stock | 22.0786 | 22.1032 | 22.0761 | 22.1018 | 2392768.0 |
| 2012-08-06 10:30:00 | AAPL | Stock | 22.1029 | 22.1296 | 22.0922 | 22.12 | 6598228.0 |
| 2012-08-06 10:35:00 | AAPL | Stock | 22.1171 | 22.1371 | 22.1129 | 22.1193 | 5173700.0 |
| 2012-08-06 10:40:00 | AAPL | Stock | 22.12 | 22.1382 | 22.1139 | 22.1349 | 5348028.0 |
| 2012-08-06 10:45:00 | AAPL | Stock | 22.135 | 22.1782 | 22.1304 | 22.173 | 13368432.0 |
| 2012-08-06 10:50:00 | AAPL | Stock | 22.1736 | 22.2286 | 22.1714 | 22.2236 | 13984264.0 |
> showing 50 of 315,582 rows — these rows as CSV