PREVIEW / stock_30min / 2015-12-21
file: by_date/stock_30min/2015/2015-12-21.parquet size: 1.6 MB rows: 84,068 symbols: 3,418
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-21 04:00:00 | AAPL | Stock | 26.875 | 26.97 | 26.7575 | 26.9275 | 44976.0 |
| 2015-12-21 04:30:00 | AAPL | Stock | 26.905 | 26.925 | 26.8775 | 26.9 | 37372.0 |
| 2015-12-21 05:00:00 | AAPL | Stock | 26.9 | 26.9375 | 26.9 | 26.9075 | 22800.0 |
| 2015-12-21 05:30:00 | AAPL | Stock | 26.905 | 26.9375 | 26.9 | 26.9375 | 24980.0 |
| 2015-12-21 06:00:00 | AAPL | Stock | 26.9 | 26.9 | 26.875 | 26.88 | 14700.0 |
| 2015-12-21 06:30:00 | AAPL | Stock | 26.8925 | 26.8975 | 26.8425 | 26.86 | 42300.0 |
| 2015-12-21 07:00:00 | AAPL | Stock | 26.865 | 26.89 | 26.84 | 26.86 | 70592.0 |
| 2015-12-21 07:30:00 | AAPL | Stock | 26.85 | 26.875 | 26.7725 | 26.8125 | 102556.0 |
| 2015-12-21 08:00:00 | AAPL | Stock | 26.8025 | 26.8975 | 26.75 | 26.79 | 717580.0 |
| 2015-12-21 08:30:00 | AAPL | Stock | 26.7925 | 26.8325 | 26.775 | 26.825 | 163612.0 |
| 2015-12-21 09:00:00 | AAPL | Stock | 26.8225 | 26.8525 | 26.7975 | 26.8175 | 432924.0 |
| 2015-12-21 09:30:00 | AAPL | Stock | 26.82 | 26.8425 | 26.54 | 26.585 | 25520024.0 |
| 2015-12-21 10:00:00 | AAPL | Stock | 26.585 | 26.7175 | 26.53 | 26.5742 | 13585204.0 |
| 2015-12-21 10:30:00 | AAPL | Stock | 26.575 | 26.67 | 26.3925 | 26.4825 | 14217116.0 |
| 2015-12-21 11:00:00 | AAPL | Stock | 26.485 | 26.5375 | 26.4325 | 26.5125 | 11082620.0 |
| 2015-12-21 11:30:00 | AAPL | Stock | 26.5125 | 26.6425 | 26.4038 | 26.6305 | 11756724.0 |
| 2015-12-21 12:00:00 | AAPL | Stock | 26.63 | 26.76 | 26.6202 | 26.6785 | 13436228.0 |
| 2015-12-21 12:30:00 | AAPL | Stock | 26.68 | 26.8125 | 26.6675 | 26.76 | 8997772.0 |
| 2015-12-21 13:00:00 | AAPL | Stock | 26.7575 | 26.835 | 26.74 | 26.7928 | 7807796.0 |
| 2015-12-21 13:30:00 | AAPL | Stock | 26.795 | 26.81 | 26.715 | 26.77 | 6476724.0 |
| 2015-12-21 14:00:00 | AAPL | Stock | 26.7675 | 26.8025 | 26.6575 | 26.6775 | 6645532.0 |
| 2015-12-21 14:30:00 | AAPL | Stock | 26.675 | 26.6925 | 26.565 | 26.6075 | 7579948.0 |
| 2015-12-21 15:00:00 | AAPL | Stock | 26.605 | 26.6612 | 26.53 | 26.607 | 8381772.0 |
| 2015-12-21 15:30:00 | AAPL | Stock | 26.6075 | 26.8375 | 26.5625 | 26.83 | 16492936.0 |
| 2015-12-21 16:00:00 | AAPL | Stock | 26.8325 | 26.8375 | 26.795 | 26.8325 | 8885732.0 |
| 2015-12-21 16:30:00 | AAPL | Stock | 26.835 | 26.87 | 26.825 | 26.8475 | 209676.0 |
| 2015-12-21 17:00:00 | AAPL | Stock | 26.8475 | 26.8875 | 26.8475 | 26.8775 | 96208.0 |
| 2015-12-21 17:30:00 | AAPL | Stock | 26.8875 | 26.895 | 26.855 | 26.855 | 32956.0 |
| 2015-12-21 18:00:00 | AAPL | Stock | 26.8875 | 26.9125 | 26.8625 | 26.875 | 27128.0 |
| 2015-12-21 18:30:00 | AAPL | Stock | 26.8775 | 26.895 | 26.87 | 26.875 | 13156.0 |
| 2015-12-21 19:00:00 | AAPL | Stock | 26.89 | 26.9075 | 26.89 | 26.9075 | 15220.0 |
| 2015-12-21 19:30:00 | AAPL | Stock | 26.9 | 26.9075 | 26.8875 | 26.9075 | 35788.0 |
| 2015-12-21 04:00:00 | MSFT | Stock | 54.83 | 54.83 | 54.83 | 54.83 | 2000.0 |
| 2015-12-21 04:30:00 | MSFT | Stock | 54.83 | 54.83 | 54.82 | 54.83 | 7638.0 |
| 2015-12-21 05:00:00 | MSFT | Stock | 54.84 | 54.85 | 54.84 | 54.85 | 1100.0 |
| 2015-12-21 05:30:00 | MSFT | Stock | 54.72 | 54.72 | 54.72 | 54.72 | 6624.0 |
| 2015-12-21 06:00:00 | MSFT | Stock | 54.69 | 54.75 | 54.6 | 54.6 | 14854.0 |
| 2015-12-21 06:30:00 | MSFT | Stock | 54.62 | 54.62 | 54.6 | 54.6 | 1400.0 |
| 2015-12-21 07:00:00 | MSFT | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 12700.0 |
| 2015-12-21 07:30:00 | MSFT | Stock | 54.59 | 54.6 | 54.42 | 54.54 | 24119.0 |
| 2015-12-21 08:00:00 | MSFT | Stock | 54.64 | 54.79 | 54.42 | 54.7 | 45522.0 |
| 2015-12-21 08:30:00 | MSFT | Stock | 54.7 | 54.79 | 54.68 | 54.79 | 17440.0 |
| 2015-12-21 09:00:00 | MSFT | Stock | 54.79 | 54.95 | 54.76 | 54.92 | 84349.0 |
| 2015-12-21 09:30:00 | MSFT | Stock | 54.89 | 55.35 | 54.71 | 54.99 | 5620795.0 |
| 2015-12-21 10:00:00 | MSFT | Stock | 54.995 | 55.02 | 54.7 | 54.886 | 2959625.0 |
| 2015-12-21 10:30:00 | MSFT | Stock | 54.89 | 54.91 | 54.46 | 54.55 | 2351808.0 |
| 2015-12-21 11:00:00 | MSFT | Stock | 54.55 | 54.65 | 54.39 | 54.485 | 1839934.0 |
| 2015-12-21 11:30:00 | MSFT | Stock | 54.48 | 54.488 | 54.226 | 54.276 | 2379402.0 |
| 2015-12-21 12:00:00 | MSFT | Stock | 54.28 | 54.41 | 54.27 | 54.36 | 2351698.0 |
| 2015-12-21 12:30:00 | MSFT | Stock | 54.36 | 54.61 | 54.355 | 54.54 | 1415773.0 |
> showing 50 of 84,068 rows — these rows as CSV