PREVIEW / stock_5min / 2017-04-04
file: by_date/stock_5min/2017/2017-04-04.parquet size: 5.4 MB rows: 357,658 symbols: 3,051
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-04 04:00:00 | AAPL | Stock | 35.8375 | 35.8975 | 35.8275 | 35.8975 | 7028.0 |
| 2017-04-04 05:05:00 | AAPL | Stock | 35.8975 | 35.8975 | 35.8975 | 35.8975 | 800.0 |
| 2017-04-04 05:10:00 | AAPL | Stock | 35.8975 | 35.8975 | 35.8975 | 35.8975 | 800.0 |
| 2017-04-04 05:30:00 | AAPL | Stock | 35.9025 | 35.9025 | 35.9025 | 35.9025 | 400.0 |
| 2017-04-04 05:35:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.885 | 35.885 | 800.0 |
| 2017-04-04 05:40:00 | AAPL | Stock | 35.9 | 35.9 | 35.885 | 35.885 | 1200.0 |
| 2017-04-04 05:50:00 | AAPL | Stock | 35.8875 | 35.895 | 35.8875 | 35.895 | 2412.0 |
| 2017-04-04 06:10:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.885 | 35.885 | 800.0 |
| 2017-04-04 06:20:00 | AAPL | Stock | 35.885 | 35.885 | 35.885 | 35.885 | 760.0 |
| 2017-04-04 06:35:00 | AAPL | Stock | 35.885 | 35.885 | 35.885 | 35.885 | 492.0 |
| 2017-04-04 06:45:00 | AAPL | Stock | 35.8775 | 35.8775 | 35.8775 | 35.8775 | 900.0 |
| 2017-04-04 06:55:00 | AAPL | Stock | 35.8775 | 35.8775 | 35.875 | 35.875 | 1200.0 |
| 2017-04-04 07:00:00 | AAPL | Stock | 35.875 | 35.875 | 35.875 | 35.875 | 2872.0 |
| 2017-04-04 07:10:00 | AAPL | Stock | 35.875 | 35.875 | 35.875 | 35.875 | 800.0 |
| 2017-04-04 07:15:00 | AAPL | Stock | 35.875 | 35.875 | 35.8625 | 35.8625 | 1600.0 |
| 2017-04-04 07:25:00 | AAPL | Stock | 35.8625 | 35.8625 | 35.85 | 35.85 | 11976.0 |
| 2017-04-04 07:30:00 | AAPL | Stock | 35.845 | 35.845 | 35.825 | 35.825 | 6400.0 |
| 2017-04-04 07:35:00 | AAPL | Stock | 35.8275 | 35.8275 | 35.8125 | 35.8125 | 3600.0 |
| 2017-04-04 07:40:00 | AAPL | Stock | 35.8075 | 35.825 | 35.8025 | 35.825 | 9284.0 |
| 2017-04-04 07:45:00 | AAPL | Stock | 35.8 | 35.8225 | 35.8 | 35.8125 | 8284.0 |
| 2017-04-04 08:00:00 | AAPL | Stock | 35.85 | 35.85 | 35.8125 | 35.8125 | 21860.0 |
| 2017-04-04 08:05:00 | AAPL | Stock | 35.8075 | 35.83 | 35.8025 | 35.83 | 14148.0 |
| 2017-04-04 08:10:00 | AAPL | Stock | 35.8275 | 35.83 | 35.805 | 35.82 | 16060.0 |
| 2017-04-04 08:15:00 | AAPL | Stock | 35.82 | 35.82 | 35.8125 | 35.815 | 7348.0 |
| 2017-04-04 08:20:00 | AAPL | Stock | 35.825 | 35.825 | 35.82 | 35.82 | 1800.0 |
| 2017-04-04 08:30:00 | AAPL | Stock | 35.825 | 35.8325 | 35.8225 | 35.8325 | 11644.0 |
| 2017-04-04 08:40:00 | AAPL | Stock | 35.8325 | 35.84 | 35.8175 | 35.8175 | 36888.0 |
| 2017-04-04 08:45:00 | AAPL | Stock | 35.8175 | 35.8375 | 35.8175 | 35.83 | 19512.0 |
| 2017-04-04 08:50:00 | AAPL | Stock | 35.8375 | 35.8375 | 35.8175 | 35.825 | 15636.0 |
| 2017-04-04 08:55:00 | AAPL | Stock | 35.8175 | 35.825 | 35.8175 | 35.825 | 5600.0 |
| 2017-04-04 09:00:00 | AAPL | Stock | 35.825 | 35.825 | 35.825 | 35.825 | 29744.0 |
| 2017-04-04 09:05:00 | AAPL | Stock | 35.825 | 35.825 | 35.815 | 35.82 | 21712.0 |
| 2017-04-04 09:10:00 | AAPL | Stock | 35.82 | 35.825 | 35.82 | 35.825 | 29128.0 |
| 2017-04-04 09:15:00 | AAPL | Stock | 35.82 | 35.8375 | 35.8175 | 35.8375 | 10996.0 |
| 2017-04-04 09:20:00 | AAPL | Stock | 35.83 | 35.83 | 35.825 | 35.83 | 2400.0 |
| 2017-04-04 09:25:00 | AAPL | Stock | 35.835 | 35.8375 | 35.8 | 35.815 | 15136.0 |
| 2017-04-04 09:30:00 | AAPL | Stock | 35.8125 | 35.8847 | 35.7925 | 35.8425 | 2923616.0 |
| 2017-04-04 09:35:00 | AAPL | Stock | 35.85 | 35.91 | 35.8452 | 35.905 | 1481964.0 |
| 2017-04-04 09:40:00 | AAPL | Stock | 35.905 | 35.9875 | 35.9025 | 35.9425 | 2511148.0 |
| 2017-04-04 09:45:00 | AAPL | Stock | 35.945 | 35.9775 | 35.94 | 35.94 | 1244676.0 |
| 2017-04-04 09:50:00 | AAPL | Stock | 35.94 | 35.95 | 35.9025 | 35.9025 | 1004924.0 |
| 2017-04-04 09:55:00 | AAPL | Stock | 35.905 | 35.93 | 35.8975 | 35.9225 | 918168.0 |
| 2017-04-04 10:00:00 | AAPL | Stock | 35.92 | 35.945 | 35.855 | 35.8875 | 1009856.0 |
| 2017-04-04 10:05:00 | AAPL | Stock | 35.8875 | 35.9225 | 35.885 | 35.9022 | 1013296.0 |
| 2017-04-04 10:10:00 | AAPL | Stock | 35.9025 | 35.925 | 35.885 | 35.9215 | 1143448.0 |
| 2017-04-04 10:15:00 | AAPL | Stock | 35.925 | 35.9675 | 35.9225 | 35.9475 | 745624.0 |
| 2017-04-04 10:20:00 | AAPL | Stock | 35.945 | 35.965 | 35.935 | 35.95 | 855108.0 |
| 2017-04-04 10:25:00 | AAPL | Stock | 35.9512 | 36.019 | 35.9512 | 36.0175 | 1362300.0 |
| 2017-04-04 10:30:00 | AAPL | Stock | 36.02 | 36.05 | 35.995 | 36.0125 | 1645040.0 |
| 2017-04-04 10:35:00 | AAPL | Stock | 36.015 | 36.0575 | 36.01 | 36.045 | 1203144.0 |
> showing 50 of 357,658 rows — these rows as CSV