PREVIEW / stock_30min / 2017-06-29
file: by_date/stock_30min/2017/2017-06-29.parquet size: 1.6 MB rows: 82,348 symbols: 3,019
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-06-29 04:00:00 | AAPL | Stock | 36.4475 | 36.45 | 36.41 | 36.41 | 7864.0 |
| 2017-06-29 04:30:00 | AAPL | Stock | 36.41 | 36.41 | 36.385 | 36.385 | 4000.0 |
| 2017-06-29 05:00:00 | AAPL | Stock | 36.375 | 36.3925 | 36.3725 | 36.3925 | 6824.0 |
| 2017-06-29 05:30:00 | AAPL | Stock | 36.3925 | 36.3925 | 36.3475 | 36.3475 | 7880.0 |
| 2017-06-29 06:00:00 | AAPL | Stock | 36.3525 | 36.3525 | 36.315 | 36.33 | 20420.0 |
| 2017-06-29 06:30:00 | AAPL | Stock | 36.33 | 36.33 | 36.31 | 36.3225 | 13960.0 |
| 2017-06-29 07:00:00 | AAPL | Stock | 36.325 | 36.4025 | 36.325 | 36.4025 | 49508.0 |
| 2017-06-29 07:30:00 | AAPL | Stock | 36.4125 | 36.435 | 36.4 | 36.4 | 30176.0 |
| 2017-06-29 08:00:00 | AAPL | Stock | 36.4 | 36.4 | 36.2775 | 36.2825 | 205328.0 |
| 2017-06-29 08:30:00 | AAPL | Stock | 36.3225 | 36.3225 | 36.2075 | 36.2125 | 245156.0 |
| 2017-06-29 09:00:00 | AAPL | Stock | 36.2125 | 36.235 | 36.155 | 36.1925 | 330068.0 |
| 2017-06-29 09:30:00 | AAPL | Stock | 36.1875 | 36.2825 | 36.05 | 36.095 | 13809868.0 |
| 2017-06-29 10:00:00 | AAPL | Stock | 36.0975 | 36.1575 | 35.9925 | 36.1 | 9790716.0 |
| 2017-06-29 10:30:00 | AAPL | Stock | 36.0995 | 36.19 | 36.0125 | 36.0808 | 6165300.0 |
| 2017-06-29 11:00:00 | AAPL | Stock | 36.0775 | 36.1275 | 35.8575 | 35.8935 | 8632856.0 |
| 2017-06-29 11:30:00 | AAPL | Stock | 35.893 | 35.9425 | 35.7475 | 35.8 | 8827508.0 |
| 2017-06-29 12:00:00 | AAPL | Stock | 35.805 | 35.9825 | 35.74 | 35.8718 | 5870392.0 |
| 2017-06-29 12:30:00 | AAPL | Stock | 35.8625 | 35.9175 | 35.6825 | 35.72 | 6932356.0 |
| 2017-06-29 13:00:00 | AAPL | Stock | 35.7222 | 35.78 | 35.6 | 35.6475 | 7452096.0 |
| 2017-06-29 13:30:00 | AAPL | Stock | 35.65 | 35.7975 | 35.57 | 35.615 | 7823420.0 |
| 2017-06-29 14:00:00 | AAPL | Stock | 35.6125 | 35.785 | 35.575 | 35.736 | 6625664.0 |
| 2017-06-29 14:30:00 | AAPL | Stock | 35.735 | 35.82 | 35.6825 | 35.76 | 5526512.0 |
| 2017-06-29 15:00:00 | AAPL | Stock | 35.76 | 35.9675 | 35.75 | 35.855 | 7309648.0 |
| 2017-06-29 15:30:00 | AAPL | Stock | 35.8575 | 36.015 | 35.85 | 35.9175 | 11933700.0 |
| 2017-06-29 16:00:00 | AAPL | Stock | 35.92 | 35.9625 | 35.8975 | 35.9425 | 7090108.0 |
| 2017-06-29 16:30:00 | AAPL | Stock | 35.95 | 35.95 | 35.8125 | 35.8925 | 217876.0 |
| 2017-06-29 17:00:00 | AAPL | Stock | 35.89 | 35.92 | 35.85 | 35.855 | 171956.0 |
| 2017-06-29 17:30:00 | AAPL | Stock | 35.86 | 35.92 | 35.8375 | 35.8375 | 49436.0 |
| 2017-06-29 18:00:00 | AAPL | Stock | 35.8725 | 35.885 | 35.8225 | 35.825 | 22240.0 |
| 2017-06-29 18:30:00 | AAPL | Stock | 35.87 | 35.87 | 35.8325 | 35.8325 | 3064.0 |
| 2017-06-29 19:00:00 | AAPL | Stock | 35.8325 | 35.8375 | 35.825 | 35.8325 | 15052.0 |
| 2017-06-29 19:30:00 | AAPL | Stock | 35.835 | 35.8625 | 35.8275 | 35.8475 | 24304.0 |
| 2017-06-29 04:00:00 | MSFT | Stock | 70.15 | 70.15 | 69.9 | 69.9 | 3100.0 |
| 2017-06-29 06:00:00 | MSFT | Stock | 69.88 | 69.88 | 69.85 | 69.85 | 1450.0 |
| 2017-06-29 07:30:00 | MSFT | Stock | 69.8 | 69.8 | 69.8 | 69.8 | 700.0 |
| 2017-06-29 08:00:00 | MSFT | Stock | 69.9 | 69.9 | 69.68 | 69.68 | 2066.0 |
| 2017-06-29 08:30:00 | MSFT | Stock | 69.5 | 69.5 | 69.3 | 69.3 | 5967.0 |
| 2017-06-29 09:00:00 | MSFT | Stock | 69.31 | 69.5 | 69.3 | 69.36 | 9001.0 |
| 2017-06-29 09:30:00 | MSFT | Stock | 69.38 | 69.49 | 68.7 | 68.888 | 2683547.0 |
| 2017-06-29 10:00:00 | MSFT | Stock | 68.89 | 69.02 | 68.7 | 68.91 | 2067994.0 |
| 2017-06-29 10:30:00 | MSFT | Stock | 68.9 | 69.086 | 68.79 | 68.945 | 1354401.0 |
| 2017-06-29 11:00:00 | MSFT | Stock | 68.94 | 68.99 | 68.57 | 68.675 | 1532737.0 |
| 2017-06-29 11:30:00 | MSFT | Stock | 68.67 | 68.79 | 68.46 | 68.5 | 2018833.0 |
| 2017-06-29 12:00:00 | MSFT | Stock | 68.5 | 68.74 | 68.38 | 68.595 | 1401865.0 |
| 2017-06-29 12:30:00 | MSFT | Stock | 68.59 | 68.73 | 68.38 | 68.41 | 1683724.0 |
| 2017-06-29 13:00:00 | MSFT | Stock | 68.407 | 68.55 | 68.09 | 68.15 | 1573963.0 |
| 2017-06-29 13:30:00 | MSFT | Stock | 68.16 | 68.55 | 68.155 | 68.42 | 2140680.0 |
| 2017-06-29 14:00:00 | MSFT | Stock | 68.41 | 68.54 | 68.24 | 68.355 | 2138630.0 |
| 2017-06-29 14:30:00 | MSFT | Stock | 68.355 | 68.41 | 68.13 | 68.28 | 1656398.0 |
| 2017-06-29 15:00:00 | MSFT | Stock | 68.27 | 68.725 | 68.26 | 68.54 | 1560891.0 |
> showing 50 of 82,348 rows — these rows as CSV