PREVIEW / stock_5min / 2018-02-22
file: by_date/stock_5min/2018/2018-02-22.parquet size: 5.6 MB rows: 357,874 symbols: 2,872
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-22 04:00:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.5025 | 42.5025 | 1208.0 |
| 2018-02-22 04:10:00 | AAPL | Stock | 42.5075 | 42.5075 | 42.5 | 42.5 | 2800.0 |
| 2018-02-22 04:35:00 | AAPL | Stock | 42.525 | 42.56 | 42.525 | 42.56 | 1600.0 |
| 2018-02-22 04:45:00 | AAPL | Stock | 42.575 | 42.5775 | 42.575 | 42.5775 | 12384.0 |
| 2018-02-22 04:50:00 | AAPL | Stock | 42.64 | 42.675 | 42.64 | 42.675 | 30244.0 |
| 2018-02-22 04:55:00 | AAPL | Stock | 42.6625 | 42.7125 | 42.6625 | 42.7 | 29600.0 |
| 2018-02-22 05:05:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 800.0 |
| 2018-02-22 05:15:00 | AAPL | Stock | 42.6925 | 42.6925 | 42.6925 | 42.6925 | 488.0 |
| 2018-02-22 05:25:00 | AAPL | Stock | 42.745 | 42.745 | 42.745 | 42.745 | 1200.0 |
| 2018-02-22 05:40:00 | AAPL | Stock | 42.7925 | 42.82 | 42.7925 | 42.82 | 1880.0 |
| 2018-02-22 05:50:00 | AAPL | Stock | 42.77 | 42.77 | 42.77 | 42.77 | 816.0 |
| 2018-02-22 05:55:00 | AAPL | Stock | 42.74 | 42.74 | 42.74 | 42.74 | 400.0 |
| 2018-02-22 06:00:00 | AAPL | Stock | 42.785 | 42.7875 | 42.785 | 42.7875 | 8000.0 |
| 2018-02-22 06:05:00 | AAPL | Stock | 42.74 | 42.7475 | 42.7025 | 42.7475 | 6440.0 |
| 2018-02-22 06:15:00 | AAPL | Stock | 42.7975 | 42.825 | 42.7975 | 42.825 | 8984.0 |
| 2018-02-22 06:20:00 | AAPL | Stock | 42.8375 | 42.925 | 42.8375 | 42.9 | 19380.0 |
| 2018-02-22 06:25:00 | AAPL | Stock | 42.8775 | 42.8775 | 42.8775 | 42.8775 | 800.0 |
| 2018-02-22 06:30:00 | AAPL | Stock | 42.925 | 42.9925 | 42.925 | 42.9925 | 3200.0 |
| 2018-02-22 06:35:00 | AAPL | Stock | 42.925 | 42.925 | 42.925 | 42.925 | 1200.0 |
| 2018-02-22 06:40:00 | AAPL | Stock | 42.925 | 42.925 | 42.8825 | 42.8875 | 5600.0 |
| 2018-02-22 06:50:00 | AAPL | Stock | 42.9 | 42.9125 | 42.9 | 42.9125 | 4000.0 |
| 2018-02-22 06:55:00 | AAPL | Stock | 42.8075 | 42.8375 | 42.8075 | 42.8375 | 9252.0 |
| 2018-02-22 07:00:00 | AAPL | Stock | 42.8625 | 42.925 | 42.8625 | 42.9125 | 43572.0 |
| 2018-02-22 07:05:00 | AAPL | Stock | 42.945 | 42.9975 | 42.9375 | 42.9975 | 42060.0 |
| 2018-02-22 07:10:00 | AAPL | Stock | 42.955 | 42.985 | 42.94 | 42.94 | 22068.0 |
| 2018-02-22 07:15:00 | AAPL | Stock | 42.9375 | 42.9475 | 42.9225 | 42.9375 | 9200.0 |
| 2018-02-22 07:20:00 | AAPL | Stock | 42.9475 | 42.9975 | 42.9475 | 42.9925 | 39460.0 |
| 2018-02-22 07:25:00 | AAPL | Stock | 42.975 | 42.9875 | 42.9575 | 42.9775 | 23724.0 |
| 2018-02-22 07:30:00 | AAPL | Stock | 42.97 | 42.9825 | 42.9575 | 42.98 | 15068.0 |
| 2018-02-22 07:35:00 | AAPL | Stock | 42.9575 | 42.9675 | 42.9375 | 42.9375 | 17528.0 |
| 2018-02-22 07:40:00 | AAPL | Stock | 42.9375 | 42.9875 | 42.9375 | 42.9675 | 13148.0 |
| 2018-02-22 07:45:00 | AAPL | Stock | 42.975 | 43.0 | 42.925 | 42.9275 | 24176.0 |
| 2018-02-22 07:50:00 | AAPL | Stock | 42.94 | 42.9625 | 42.925 | 42.95 | 22120.0 |
| 2018-02-22 07:55:00 | AAPL | Stock | 42.9575 | 42.9575 | 42.915 | 42.915 | 22004.0 |
| 2018-02-22 08:00:00 | AAPL | Stock | 42.9263 | 42.9975 | 42.845 | 42.9425 | 93948.0 |
| 2018-02-22 08:05:00 | AAPL | Stock | 42.9425 | 42.9425 | 42.925 | 42.925 | 11288.0 |
| 2018-02-22 08:10:00 | AAPL | Stock | 42.925 | 42.9425 | 42.8875 | 42.8925 | 23864.0 |
| 2018-02-22 08:15:00 | AAPL | Stock | 42.8925 | 42.9075 | 42.8875 | 42.8875 | 12948.0 |
| 2018-02-22 08:20:00 | AAPL | Stock | 42.88 | 42.925 | 42.88 | 42.9 | 32600.0 |
| 2018-02-22 08:25:00 | AAPL | Stock | 42.91 | 42.9125 | 42.8875 | 42.9125 | 27828.0 |
| 2018-02-22 08:30:00 | AAPL | Stock | 42.925 | 42.97 | 42.925 | 42.97 | 28424.0 |
| 2018-02-22 08:35:00 | AAPL | Stock | 42.965 | 42.975 | 42.9425 | 42.95 | 61144.0 |
| 2018-02-22 08:40:00 | AAPL | Stock | 42.9525 | 42.9625 | 42.95 | 42.95 | 45084.0 |
| 2018-02-22 08:45:00 | AAPL | Stock | 42.945 | 42.95 | 42.9425 | 42.95 | 47208.0 |
| 2018-02-22 08:50:00 | AAPL | Stock | 42.9475 | 43.0225 | 42.9475 | 43.02 | 51868.0 |
| 2018-02-22 08:55:00 | AAPL | Stock | 43.02 | 43.04 | 42.9775 | 42.995 | 72884.0 |
| 2018-02-22 09:00:00 | AAPL | Stock | 42.99 | 43.025 | 42.99 | 43.0175 | 63456.0 |
| 2018-02-22 09:05:00 | AAPL | Stock | 43.035 | 43.07 | 43.035 | 43.0475 | 59424.0 |
| 2018-02-22 09:10:00 | AAPL | Stock | 43.0425 | 43.05 | 43.0125 | 43.03 | 27088.0 |
| 2018-02-22 09:15:00 | AAPL | Stock | 43.015 | 43.02 | 42.975 | 42.9875 | 36192.0 |
> showing 50 of 357,874 rows — these rows as CSV