PREVIEW / stock_5min / 2016-02-04
file: by_date/stock_5min/2016/2016-02-04.parquet size: 5.4 MB rows: 359,724 symbols: 3,360
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-02-04 04:00:00 | AAPL | Stock | 24.0025 | 24.0025 | 23.97 | 23.97 | 3600.0 |
| 2016-02-04 04:05:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 1976.0 |
| 2016-02-04 04:20:00 | AAPL | Stock | 23.9725 | 23.9725 | 23.97 | 23.97 | 800.0 |
| 2016-02-04 04:30:00 | AAPL | Stock | 24.02 | 24.02 | 24.02 | 24.02 | 400.0 |
| 2016-02-04 04:35:00 | AAPL | Stock | 24.025 | 24.025 | 24.0 | 24.0 | 1160.0 |
| 2016-02-04 04:45:00 | AAPL | Stock | 24.0475 | 24.0475 | 24.0475 | 24.0475 | 400.0 |
| 2016-02-04 04:55:00 | AAPL | Stock | 24.07 | 24.1 | 24.07 | 24.0975 | 3200.0 |
| 2016-02-04 05:25:00 | AAPL | Stock | 24.06 | 24.06 | 24.06 | 24.06 | 400.0 |
| 2016-02-04 06:15:00 | AAPL | Stock | 24.06 | 24.06 | 24.06 | 24.06 | 3600.0 |
| 2016-02-04 06:50:00 | AAPL | Stock | 24.0075 | 24.01 | 24.0075 | 24.01 | 4000.0 |
| 2016-02-04 07:00:00 | AAPL | Stock | 23.975 | 24.0 | 23.975 | 24.0 | 3200.0 |
| 2016-02-04 07:05:00 | AAPL | Stock | 23.9775 | 23.9875 | 23.975 | 23.9875 | 3680.0 |
| 2016-02-04 07:10:00 | AAPL | Stock | 23.975 | 23.975 | 23.975 | 23.975 | 1016.0 |
| 2016-02-04 07:15:00 | AAPL | Stock | 23.98 | 23.98 | 23.98 | 23.98 | 596.0 |
| 2016-02-04 07:20:00 | AAPL | Stock | 23.95 | 23.95 | 23.915 | 23.915 | 8400.0 |
| 2016-02-04 07:30:00 | AAPL | Stock | 23.95 | 23.95 | 23.9225 | 23.925 | 1200.0 |
| 2016-02-04 07:50:00 | AAPL | Stock | 23.9375 | 23.9375 | 23.9375 | 23.9375 | 2000.0 |
| 2016-02-04 07:55:00 | AAPL | Stock | 23.9375 | 23.9375 | 23.91 | 23.91 | 3004.0 |
| 2016-02-04 08:00:00 | AAPL | Stock | 23.9575 | 23.9875 | 23.85 | 23.85 | 76776.0 |
| 2016-02-04 08:05:00 | AAPL | Stock | 23.85 | 23.8675 | 23.8475 | 23.85 | 11104.0 |
| 2016-02-04 08:10:00 | AAPL | Stock | 23.83 | 23.83 | 23.785 | 23.8025 | 40980.0 |
| 2016-02-04 08:15:00 | AAPL | Stock | 23.8125 | 23.8375 | 23.8125 | 23.8125 | 4380.0 |
| 2016-02-04 08:20:00 | AAPL | Stock | 23.8075 | 23.8375 | 23.7875 | 23.8375 | 73676.0 |
| 2016-02-04 08:25:00 | AAPL | Stock | 23.85 | 23.85 | 23.8175 | 23.82 | 8000.0 |
| 2016-02-04 08:30:00 | AAPL | Stock | 23.825 | 23.84 | 23.79 | 23.825 | 66228.0 |
| 2016-02-04 08:35:00 | AAPL | Stock | 23.8125 | 23.8425 | 23.79 | 23.8425 | 42648.0 |
| 2016-02-04 08:40:00 | AAPL | Stock | 23.845 | 23.8625 | 23.825 | 23.825 | 16800.0 |
| 2016-02-04 08:45:00 | AAPL | Stock | 23.825 | 23.8425 | 23.7875 | 23.7875 | 51188.0 |
| 2016-02-04 08:50:00 | AAPL | Stock | 23.7825 | 23.9575 | 23.7625 | 23.795 | 159720.0 |
| 2016-02-04 08:55:00 | AAPL | Stock | 23.8 | 23.8125 | 23.78 | 23.785 | 15240.0 |
| 2016-02-04 09:00:00 | AAPL | Stock | 23.8 | 23.83 | 23.8 | 23.815 | 47800.0 |
| 2016-02-04 09:05:00 | AAPL | Stock | 23.8125 | 23.85 | 23.8125 | 23.85 | 2720.0 |
| 2016-02-04 09:10:00 | AAPL | Stock | 23.8525 | 23.855 | 23.825 | 23.835 | 17600.0 |
| 2016-02-04 09:15:00 | AAPL | Stock | 23.825 | 23.8475 | 23.825 | 23.845 | 32400.0 |
| 2016-02-04 09:20:00 | AAPL | Stock | 23.8475 | 23.91 | 23.8475 | 23.8875 | 69892.0 |
| 2016-02-04 09:25:00 | AAPL | Stock | 23.89 | 23.985 | 23.89 | 23.97 | 80836.0 |
| 2016-02-04 09:30:00 | AAPL | Stock | 23.965 | 24.0925 | 23.9075 | 23.9388 | 4355288.0 |
| 2016-02-04 09:35:00 | AAPL | Stock | 23.9375 | 23.97 | 23.855 | 23.8975 | 2782900.0 |
| 2016-02-04 09:40:00 | AAPL | Stock | 23.8975 | 23.9325 | 23.7975 | 23.8325 | 2610792.0 |
| 2016-02-04 09:45:00 | AAPL | Stock | 23.8325 | 23.8625 | 23.7975 | 23.85 | 2088220.0 |
| 2016-02-04 09:50:00 | AAPL | Stock | 23.85 | 23.9375 | 23.84 | 23.9092 | 2659988.0 |
| 2016-02-04 09:55:00 | AAPL | Stock | 23.9075 | 24.0175 | 23.9 | 23.9725 | 1796604.0 |
| 2016-02-04 10:00:00 | AAPL | Stock | 23.9675 | 23.9875 | 23.8575 | 23.935 | 1999900.0 |
| 2016-02-04 10:05:00 | AAPL | Stock | 23.935 | 24.09 | 23.9325 | 24.0875 | 2844256.0 |
| 2016-02-04 10:10:00 | AAPL | Stock | 24.087 | 24.2025 | 24.0452 | 24.1875 | 3359676.0 |
| 2016-02-04 10:15:00 | AAPL | Stock | 24.1875 | 24.2875 | 24.1725 | 24.2725 | 3657604.0 |
| 2016-02-04 10:20:00 | AAPL | Stock | 24.275 | 24.3325 | 24.22 | 24.295 | 3865204.0 |
| 2016-02-04 10:25:00 | AAPL | Stock | 24.295 | 24.3275 | 24.2475 | 24.2625 | 2271564.0 |
| 2016-02-04 10:30:00 | AAPL | Stock | 24.2638 | 24.31 | 24.2025 | 24.3075 | 2197776.0 |
| 2016-02-04 10:35:00 | AAPL | Stock | 24.3075 | 24.3312 | 24.26 | 24.2975 | 2208256.0 |
> showing 50 of 359,724 rows — these rows as CSV