PREVIEW / stock_5min / 2014-06-05
file: by_date/stock_5min/2014/2014-06-05.parquet size: 5.4 MB rows: 361,529 symbols: 3,538
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-05 05:10:00 | AAPL | Stock | 23.0536 | 23.0536 | 23.0536 | 23.0536 | 2800.0 |
| 2014-06-05 06:30:00 | AAPL | Stock | 23.0571 | 23.0571 | 23.0571 | 23.0571 | 2800.0 |
| 2014-06-05 07:05:00 | AAPL | Stock | 23.0714 | 23.0714 | 23.0714 | 23.0714 | 11200.0 |
| 2014-06-05 07:10:00 | AAPL | Stock | 23.0714 | 23.0893 | 23.0714 | 23.0893 | 16800.0 |
| 2014-06-05 07:15:00 | AAPL | Stock | 23.0875 | 23.0939 | 23.0821 | 23.0939 | 53088.0 |
| 2014-06-05 07:20:00 | AAPL | Stock | 23.0968 | 23.0968 | 23.0821 | 23.0871 | 41272.0 |
| 2014-06-05 07:25:00 | AAPL | Stock | 23.0943 | 23.0964 | 23.0943 | 23.0964 | 15288.0 |
| 2014-06-05 07:30:00 | AAPL | Stock | 23.0893 | 23.0893 | 23.0571 | 23.0571 | 112168.0 |
| 2014-06-05 07:35:00 | AAPL | Stock | 23.0857 | 23.0857 | 23.075 | 23.075 | 37436.0 |
| 2014-06-05 07:40:00 | AAPL | Stock | 23.075 | 23.0893 | 23.075 | 23.0893 | 11200.0 |
| 2014-06-05 07:45:00 | AAPL | Stock | 23.0893 | 23.1 | 23.0539 | 23.1 | 120344.0 |
| 2014-06-05 07:50:00 | AAPL | Stock | 23.1 | 23.1036 | 23.0893 | 23.0989 | 41468.0 |
| 2014-06-05 07:55:00 | AAPL | Stock | 23.0725 | 23.0725 | 23.0679 | 23.0714 | 29120.0 |
| 2014-06-05 08:00:00 | AAPL | Stock | 23.0714 | 23.1071 | 23.0575 | 23.0729 | 137984.0 |
| 2014-06-05 08:05:00 | AAPL | Stock | 23.0714 | 23.1018 | 23.0714 | 23.0911 | 234780.0 |
| 2014-06-05 08:10:00 | AAPL | Stock | 23.0882 | 23.0882 | 23.0714 | 23.0857 | 124180.0 |
| 2014-06-05 08:15:00 | AAPL | Stock | 23.0821 | 23.0893 | 23.0761 | 23.0857 | 68600.0 |
| 2014-06-05 08:20:00 | AAPL | Stock | 23.0864 | 23.0871 | 23.0864 | 23.0871 | 16212.0 |
| 2014-06-05 08:25:00 | AAPL | Stock | 23.0893 | 23.0982 | 23.0893 | 23.0921 | 40460.0 |
| 2014-06-05 08:30:00 | AAPL | Stock | 23.0793 | 23.0982 | 23.0793 | 23.0821 | 112476.0 |
| 2014-06-05 08:35:00 | AAPL | Stock | 23.0889 | 23.1 | 23.0825 | 23.0893 | 319760.0 |
| 2014-06-05 08:40:00 | AAPL | Stock | 23.0911 | 23.0954 | 23.0821 | 23.0821 | 196896.0 |
| 2014-06-05 08:45:00 | AAPL | Stock | 23.0871 | 23.0979 | 23.0868 | 23.0943 | 154616.0 |
| 2014-06-05 08:50:00 | AAPL | Stock | 23.0957 | 23.1 | 23.0957 | 23.0993 | 89600.0 |
| 2014-06-05 08:55:00 | AAPL | Stock | 23.0964 | 23.1007 | 23.0964 | 23.1007 | 42420.0 |
| 2014-06-05 09:00:00 | AAPL | Stock | 23.0979 | 23.1007 | 23.0932 | 23.0982 | 77420.0 |
| 2014-06-05 09:05:00 | AAPL | Stock | 23.0946 | 23.095 | 23.0725 | 23.0743 | 359184.0 |
| 2014-06-05 09:10:00 | AAPL | Stock | 23.0796 | 23.0796 | 23.0714 | 23.0714 | 154868.0 |
| 2014-06-05 09:15:00 | AAPL | Stock | 23.0714 | 23.0789 | 23.0714 | 23.0789 | 125020.0 |
| 2014-06-05 09:20:00 | AAPL | Stock | 23.0764 | 23.0929 | 23.0764 | 23.0929 | 127848.0 |
| 2014-06-05 09:25:00 | AAPL | Stock | 23.09 | 23.0925 | 23.0714 | 23.0782 | 135996.0 |
| 2014-06-05 09:30:00 | AAPL | Stock | 23.0786 | 23.1918 | 23.0625 | 23.1789 | 15639568.0 |
| 2014-06-05 09:35:00 | AAPL | Stock | 23.1786 | 23.1821 | 23.1418 | 23.1729 | 7291704.0 |
| 2014-06-05 09:40:00 | AAPL | Stock | 23.1696 | 23.1732 | 23.0939 | 23.1305 | 9006312.0 |
| 2014-06-05 09:45:00 | AAPL | Stock | 23.1304 | 23.1732 | 23.1257 | 23.1472 | 6376272.0 |
| 2014-06-05 09:50:00 | AAPL | Stock | 23.1464 | 23.1582 | 23.0864 | 23.0929 | 4865560.0 |
| 2014-06-05 09:55:00 | AAPL | Stock | 23.0936 | 23.1129 | 23.045 | 23.1079 | 8201816.0 |
| 2014-06-05 10:00:00 | AAPL | Stock | 23.1089 | 23.1286 | 23.0475 | 23.0526 | 4449088.0 |
| 2014-06-05 10:05:00 | AAPL | Stock | 23.0532 | 23.0696 | 22.9961 | 23.0064 | 7259112.0 |
| 2014-06-05 10:10:00 | AAPL | Stock | 23.0058 | 23.01 | 22.9664 | 22.9829 | 7945532.0 |
| 2014-06-05 10:15:00 | AAPL | Stock | 22.9821 | 23.0271 | 22.9504 | 23.0257 | 6624240.0 |
| 2014-06-05 10:20:00 | AAPL | Stock | 23.0254 | 23.0796 | 23.0243 | 23.06 | 6297424.0 |
| 2014-06-05 10:25:00 | AAPL | Stock | 23.0625 | 23.0893 | 23.0532 | 23.0843 | 4651304.0 |
| 2014-06-05 10:30:00 | AAPL | Stock | 23.0846 | 23.0846 | 23.0554 | 23.071 | 3592960.0 |
| 2014-06-05 10:35:00 | AAPL | Stock | 23.0707 | 23.0707 | 23.0293 | 23.0337 | 3599988.0 |
| 2014-06-05 10:40:00 | AAPL | Stock | 23.035 | 23.0836 | 23.0321 | 23.0807 | 2912952.0 |
| 2014-06-05 10:45:00 | AAPL | Stock | 23.0816 | 23.1129 | 23.0764 | 23.0959 | 3566892.0 |
| 2014-06-05 10:50:00 | AAPL | Stock | 23.0896 | 23.0946 | 23.0579 | 23.0796 | 1896776.0 |
| 2014-06-05 10:55:00 | AAPL | Stock | 23.0807 | 23.0889 | 23.0664 | 23.0754 | 1359288.0 |
| 2014-06-05 11:00:00 | AAPL | Stock | 23.075 | 23.0889 | 23.0639 | 23.0714 | 1488844.0 |
> showing 50 of 361,529 rows — these rows as CSV