PREVIEW / stock_30min / 2017-10-05
file: by_date/stock_30min/2017/2017-10-05.parquet size: 1.6 MB rows: 81,469 symbols: 2,963
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-10-05 04:30:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 400.0 |
| 2017-10-05 05:00:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 2296.0 |
| 2017-10-05 06:00:00 | AAPL | Stock | 38.35 | 38.375 | 38.35 | 38.375 | 3224.0 |
| 2017-10-05 06:30:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 400.0 |
| 2017-10-05 07:00:00 | AAPL | Stock | 38.395 | 38.4175 | 38.39 | 38.3925 | 6508.0 |
| 2017-10-05 07:30:00 | AAPL | Stock | 38.4225 | 38.45 | 38.4225 | 38.45 | 5376.0 |
| 2017-10-05 08:00:00 | AAPL | Stock | 38.45 | 38.56 | 38.42 | 38.5475 | 134608.0 |
| 2017-10-05 08:30:00 | AAPL | Stock | 38.54 | 38.5675 | 38.5025 | 38.5475 | 141452.0 |
| 2017-10-05 09:00:00 | AAPL | Stock | 38.56 | 38.56 | 38.51 | 38.5275 | 82628.0 |
| 2017-10-05 09:30:00 | AAPL | Stock | 38.545 | 38.8405 | 38.5125 | 38.7475 | 14864412.0 |
| 2017-10-05 10:00:00 | AAPL | Stock | 38.7475 | 38.83 | 38.7375 | 38.75 | 7237076.0 |
| 2017-10-05 10:30:00 | AAPL | Stock | 38.7518 | 38.78 | 38.655 | 38.6725 | 5883596.0 |
| 2017-10-05 11:00:00 | AAPL | Stock | 38.6725 | 38.7375 | 38.6475 | 38.725 | 3465908.0 |
| 2017-10-05 11:30:00 | AAPL | Stock | 38.7225 | 38.75 | 38.69 | 38.71 | 3691880.0 |
| 2017-10-05 12:00:00 | AAPL | Stock | 38.7118 | 38.8175 | 38.695 | 38.781 | 3910132.0 |
| 2017-10-05 12:30:00 | AAPL | Stock | 38.7825 | 38.805 | 38.72 | 38.7225 | 2625412.0 |
| 2017-10-05 13:00:00 | AAPL | Stock | 38.7262 | 38.7625 | 38.695 | 38.7525 | 3073576.0 |
| 2017-10-05 13:30:00 | AAPL | Stock | 38.7525 | 38.7625 | 38.6975 | 38.715 | 2592032.0 |
| 2017-10-05 14:00:00 | AAPL | Stock | 38.715 | 38.7375 | 38.68 | 38.7125 | 2834688.0 |
| 2017-10-05 14:30:00 | AAPL | Stock | 38.715 | 38.8125 | 38.71 | 38.8125 | 3349844.0 |
| 2017-10-05 15:00:00 | AAPL | Stock | 38.8125 | 38.86 | 38.7985 | 38.815 | 5785908.0 |
| 2017-10-05 15:30:00 | AAPL | Stock | 38.816 | 38.855 | 38.805 | 38.85 | 8718360.0 |
| 2017-10-05 16:00:00 | AAPL | Stock | 38.8475 | 38.855 | 38.7525 | 38.8475 | 7577380.0 |
| 2017-10-05 16:30:00 | AAPL | Stock | 38.8375 | 38.85 | 38.8275 | 38.8425 | 43072.0 |
| 2017-10-05 17:00:00 | AAPL | Stock | 38.8475 | 38.8475 | 38.8425 | 38.8425 | 9640.0 |
| 2017-10-05 17:30:00 | AAPL | Stock | 38.8425 | 38.845 | 38.8075 | 38.825 | 26736.0 |
| 2017-10-05 18:00:00 | AAPL | Stock | 38.845 | 38.845 | 38.81 | 38.815 | 22832.0 |
| 2017-10-05 18:30:00 | AAPL | Stock | 38.815 | 38.835 | 38.805 | 38.825 | 12608.0 |
| 2017-10-05 19:00:00 | AAPL | Stock | 38.835 | 38.835 | 38.825 | 38.825 | 8380.0 |
| 2017-10-05 19:30:00 | AAPL | Stock | 38.81 | 38.8125 | 38.8075 | 38.81 | 14016.0 |
| 2017-10-05 04:00:00 | MSFT | Stock | 74.93 | 75.15 | 74.93 | 75.15 | 1079.0 |
| 2017-10-05 04:30:00 | MSFT | Stock | 75.1 | 75.25 | 75.1 | 75.25 | 7528.0 |
| 2017-10-05 05:00:00 | MSFT | Stock | 75.25 | 75.25 | 75.25 | 75.25 | 3212.0 |
| 2017-10-05 05:30:00 | MSFT | Stock | 75.25 | 75.25 | 75.25 | 75.25 | 749.0 |
| 2017-10-05 06:00:00 | MSFT | Stock | 75.25 | 75.32 | 75.25 | 75.25 | 1439.0 |
| 2017-10-05 06:30:00 | MSFT | Stock | 75.25 | 75.28 | 75.17 | 75.28 | 3464.0 |
| 2017-10-05 07:00:00 | MSFT | Stock | 75.19 | 75.35 | 75.19 | 75.35 | 1873.0 |
| 2017-10-05 07:30:00 | MSFT | Stock | 75.33 | 75.44 | 75.29 | 75.36 | 7360.0 |
| 2017-10-05 08:00:00 | MSFT | Stock | 75.18 | 75.5 | 75.18 | 75.49 | 16908.0 |
| 2017-10-05 08:30:00 | MSFT | Stock | 75.45 | 75.53 | 75.41 | 75.41 | 13048.0 |
| 2017-10-05 09:00:00 | MSFT | Stock | 75.41 | 75.53 | 75.12 | 75.26 | 45699.0 |
| 2017-10-05 09:30:00 | MSFT | Stock | 75.28 | 75.48 | 74.96 | 75.05 | 2663024.0 |
| 2017-10-05 10:00:00 | MSFT | Stock | 75.05 | 75.16 | 74.97 | 75.11 | 1029907.0 |
| 2017-10-05 10:30:00 | MSFT | Stock | 75.12 | 75.24 | 74.98 | 75.2 | 803293.0 |
| 2017-10-05 11:00:00 | MSFT | Stock | 75.205 | 75.437 | 75.2 | 75.43 | 781503.0 |
| 2017-10-05 11:30:00 | MSFT | Stock | 75.42 | 75.596 | 75.41 | 75.52 | 1196894.0 |
| 2017-10-05 12:00:00 | MSFT | Stock | 75.52 | 75.78 | 75.5 | 75.748 | 1113140.0 |
| 2017-10-05 12:30:00 | MSFT | Stock | 75.74 | 75.76 | 75.64 | 75.68 | 737673.0 |
| 2017-10-05 13:00:00 | MSFT | Stock | 75.685 | 75.84 | 75.675 | 75.835 | 744476.0 |
| 2017-10-05 13:30:00 | MSFT | Stock | 75.83 | 75.99 | 75.77 | 75.99 | 870358.0 |
> showing 50 of 81,469 rows — these rows as CSV