PREVIEW / stock_5min / 2016-06-08
file: by_date/stock_5min/2016/2016-06-08.parquet size: 5.4 MB rows: 360,416 symbols: 3,307
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-08 06:30:00 | AAPL | Stock | 24.75 | 24.75 | 24.75 | 24.75 | 800.0 |
| 2016-06-08 07:00:00 | AAPL | Stock | 24.7625 | 24.7625 | 24.7625 | 24.7625 | 2400.0 |
| 2016-06-08 07:05:00 | AAPL | Stock | 24.7625 | 24.7625 | 24.7625 | 24.7625 | 1000.0 |
| 2016-06-08 07:15:00 | AAPL | Stock | 24.76 | 24.76 | 24.7575 | 24.7575 | 7108.0 |
| 2016-06-08 07:50:00 | AAPL | Stock | 24.78 | 24.7875 | 24.78 | 24.7875 | 3240.0 |
| 2016-06-08 08:00:00 | AAPL | Stock | 24.7575 | 24.7875 | 24.7575 | 24.7875 | 12972.0 |
| 2016-06-08 08:05:00 | AAPL | Stock | 24.795 | 24.795 | 24.795 | 24.795 | 4080.0 |
| 2016-06-08 08:20:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.7875 | 24.7875 | 2328.0 |
| 2016-06-08 08:25:00 | AAPL | Stock | 24.7875 | 24.7875 | 24.785 | 24.785 | 8780.0 |
| 2016-06-08 08:30:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.775 | 24.7875 | 1404.0 |
| 2016-06-08 08:40:00 | AAPL | Stock | 24.7875 | 24.7875 | 24.7875 | 24.7875 | 3200.0 |
| 2016-06-08 08:45:00 | AAPL | Stock | 24.7875 | 24.7875 | 24.7875 | 24.7875 | 400.0 |
| 2016-06-08 08:50:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.7875 | 24.7875 | 4468.0 |
| 2016-06-08 08:55:00 | AAPL | Stock | 24.785 | 24.7875 | 24.785 | 24.7875 | 2636.0 |
| 2016-06-08 09:00:00 | AAPL | Stock | 24.795 | 24.8 | 24.795 | 24.8 | 7600.0 |
| 2016-06-08 09:05:00 | AAPL | Stock | 24.795 | 24.81 | 24.795 | 24.805 | 45044.0 |
| 2016-06-08 09:10:00 | AAPL | Stock | 24.8 | 24.8075 | 24.8 | 24.8075 | 2760.0 |
| 2016-06-08 09:15:00 | AAPL | Stock | 24.81 | 24.8125 | 24.805 | 24.8075 | 40924.0 |
| 2016-06-08 09:20:00 | AAPL | Stock | 24.8075 | 24.81 | 24.795 | 24.795 | 19840.0 |
| 2016-06-08 09:25:00 | AAPL | Stock | 24.805 | 24.81 | 24.7575 | 24.7575 | 94636.0 |
| 2016-06-08 09:30:00 | AAPL | Stock | 24.755 | 24.885 | 24.755 | 24.8305 | 3166756.0 |
| 2016-06-08 09:35:00 | AAPL | Stock | 24.8345 | 24.8825 | 24.8125 | 24.8625 | 1912596.0 |
| 2016-06-08 09:40:00 | AAPL | Stock | 24.8625 | 24.8875 | 24.8375 | 24.8875 | 1415684.0 |
| 2016-06-08 09:45:00 | AAPL | Stock | 24.8875 | 24.89 | 24.8475 | 24.8518 | 1078992.0 |
| 2016-06-08 09:50:00 | AAPL | Stock | 24.8525 | 24.8718 | 24.835 | 24.86 | 1181356.0 |
| 2016-06-08 09:55:00 | AAPL | Stock | 24.8575 | 24.875 | 24.8488 | 24.8725 | 1268888.0 |
| 2016-06-08 10:00:00 | AAPL | Stock | 24.875 | 24.8775 | 24.85 | 24.865 | 854680.0 |
| 2016-06-08 10:05:00 | AAPL | Stock | 24.865 | 24.8662 | 24.8175 | 24.8182 | 1185424.0 |
| 2016-06-08 10:10:00 | AAPL | Stock | 24.82 | 24.82 | 24.7525 | 24.7612 | 1531548.0 |
| 2016-06-08 10:15:00 | AAPL | Stock | 24.76 | 24.7612 | 24.7175 | 24.733 | 1970892.0 |
| 2016-06-08 10:20:00 | AAPL | Stock | 24.735 | 24.745 | 24.7078 | 24.745 | 1466600.0 |
| 2016-06-08 10:25:00 | AAPL | Stock | 24.7425 | 24.7625 | 24.73 | 24.7425 | 1649392.0 |
| 2016-06-08 10:30:00 | AAPL | Stock | 24.7425 | 24.78 | 24.72 | 24.77 | 1498964.0 |
| 2016-06-08 10:35:00 | AAPL | Stock | 24.7688 | 24.7725 | 24.73 | 24.73 | 944592.0 |
| 2016-06-08 10:40:00 | AAPL | Stock | 24.73 | 24.7425 | 24.7075 | 24.735 | 1208884.0 |
| 2016-06-08 10:45:00 | AAPL | Stock | 24.735 | 24.74 | 24.72 | 24.725 | 1307636.0 |
| 2016-06-08 10:50:00 | AAPL | Stock | 24.7265 | 24.735 | 24.7175 | 24.725 | 744820.0 |
| 2016-06-08 10:55:00 | AAPL | Stock | 24.7273 | 24.7275 | 24.6825 | 24.686 | 1425440.0 |
| 2016-06-08 11:00:00 | AAPL | Stock | 24.6852 | 24.7065 | 24.68 | 24.6925 | 866244.0 |
| 2016-06-08 11:05:00 | AAPL | Stock | 24.6925 | 24.6975 | 24.67 | 24.6755 | 901044.0 |
| 2016-06-08 11:10:00 | AAPL | Stock | 24.6775 | 24.7225 | 24.672 | 24.715 | 1089660.0 |
| 2016-06-08 11:15:00 | AAPL | Stock | 24.715 | 24.7315 | 24.6975 | 24.7062 | 937660.0 |
| 2016-06-08 11:20:00 | AAPL | Stock | 24.705 | 24.72 | 24.7 | 24.7062 | 501524.0 |
| 2016-06-08 11:25:00 | AAPL | Stock | 24.7038 | 24.7425 | 24.6925 | 24.7295 | 926616.0 |
| 2016-06-08 11:30:00 | AAPL | Stock | 24.73 | 24.76 | 24.73 | 24.75 | 890872.0 |
| 2016-06-08 11:35:00 | AAPL | Stock | 24.75 | 24.7878 | 24.749 | 24.7875 | 1065636.0 |
| 2016-06-08 11:40:00 | AAPL | Stock | 24.7875 | 24.805 | 24.7825 | 24.8 | 964876.0 |
| 2016-06-08 11:45:00 | AAPL | Stock | 24.7975 | 24.8025 | 24.7825 | 24.785 | 775916.0 |
| 2016-06-08 11:50:00 | AAPL | Stock | 24.7885 | 24.7922 | 24.7625 | 24.7702 | 593332.0 |
| 2016-06-08 11:55:00 | AAPL | Stock | 24.7725 | 24.7825 | 24.76 | 24.765 | 496548.0 |
> showing 50 of 360,416 rows — these rows as CSV