PREVIEW / stock_30min / 2017-04-28
file: by_date/stock_30min/2017/2017-04-28.parquet size: 1.6 MB rows: 81,215 symbols: 3,050
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-28 04:30:00 | AAPL | Stock | 35.99 | 35.99 | 35.99 | 35.99 | 400.0 |
| 2017-04-28 05:00:00 | AAPL | Stock | 35.995 | 35.9975 | 35.995 | 35.9975 | 1820.0 |
| 2017-04-28 05:30:00 | AAPL | Stock | 35.995 | 35.9975 | 35.995 | 35.9975 | 800.0 |
| 2017-04-28 06:00:00 | AAPL | Stock | 35.9975 | 36.0 | 35.9975 | 36.0 | 3100.0 |
| 2017-04-28 06:30:00 | AAPL | Stock | 36.0 | 36.0 | 36.0 | 36.0 | 4000.0 |
| 2017-04-28 07:00:00 | AAPL | Stock | 35.975 | 36.0 | 35.9725 | 36.0 | 12192.0 |
| 2017-04-28 07:30:00 | AAPL | Stock | 35.995 | 36.0 | 35.965 | 35.995 | 28604.0 |
| 2017-04-28 08:00:00 | AAPL | Stock | 35.975 | 35.9975 | 35.9625 | 35.975 | 50996.0 |
| 2017-04-28 08:30:00 | AAPL | Stock | 35.975 | 36.0 | 35.9675 | 35.9875 | 48784.0 |
| 2017-04-28 09:00:00 | AAPL | Stock | 35.9875 | 36.045 | 35.94 | 36.0075 | 634044.0 |
| 2017-04-28 09:30:00 | AAPL | Stock | 36.0225 | 36.025 | 35.8175 | 35.8375 | 10780272.0 |
| 2017-04-28 10:00:00 | AAPL | Stock | 35.835 | 35.93 | 35.8342 | 35.915 | 4723952.0 |
| 2017-04-28 10:30:00 | AAPL | Stock | 35.915 | 35.9588 | 35.8775 | 35.9525 | 3198356.0 |
| 2017-04-28 11:00:00 | AAPL | Stock | 35.955 | 35.9725 | 35.9125 | 35.9238 | 3498388.0 |
| 2017-04-28 11:30:00 | AAPL | Stock | 35.9238 | 35.995 | 35.9025 | 35.9875 | 2807268.0 |
| 2017-04-28 12:00:00 | AAPL | Stock | 35.9862 | 36.045 | 35.9862 | 36.025 | 3489924.0 |
| 2017-04-28 12:30:00 | AAPL | Stock | 36.025 | 36.075 | 36.015 | 36.0675 | 3728008.0 |
| 2017-04-28 13:00:00 | AAPL | Stock | 36.0675 | 36.0725 | 35.995 | 36.005 | 2691044.0 |
| 2017-04-28 13:30:00 | AAPL | Stock | 36.0075 | 36.01 | 35.965 | 35.9725 | 2094536.0 |
| 2017-04-28 14:00:00 | AAPL | Stock | 35.9738 | 35.9775 | 35.8925 | 35.9375 | 3771448.0 |
| 2017-04-28 14:30:00 | AAPL | Stock | 35.94 | 35.955 | 35.8962 | 35.905 | 2865524.0 |
| 2017-04-28 15:00:00 | AAPL | Stock | 35.9025 | 35.9425 | 35.8825 | 35.8825 | 4251052.0 |
| 2017-04-28 15:30:00 | AAPL | Stock | 35.8825 | 35.9388 | 35.8625 | 35.91 | 10092924.0 |
| 2017-04-28 16:00:00 | AAPL | Stock | 35.92 | 35.9275 | 35.8962 | 35.9 | 10939088.0 |
| 2017-04-28 16:30:00 | AAPL | Stock | 35.9025 | 35.925 | 35.9 | 35.925 | 26836.0 |
| 2017-04-28 17:00:00 | AAPL | Stock | 35.925 | 35.925 | 35.8775 | 35.8775 | 45624.0 |
| 2017-04-28 17:30:00 | AAPL | Stock | 35.9 | 35.92 | 35.8875 | 35.9125 | 18496.0 |
| 2017-04-28 18:00:00 | AAPL | Stock | 35.925 | 35.935 | 35.9125 | 35.93 | 33508.0 |
| 2017-04-28 18:30:00 | AAPL | Stock | 35.9325 | 35.9425 | 35.9325 | 35.9375 | 7672.0 |
| 2017-04-28 19:00:00 | AAPL | Stock | 35.9375 | 35.975 | 35.9375 | 35.975 | 26656.0 |
| 2017-04-28 19:30:00 | AAPL | Stock | 35.955 | 35.975 | 35.955 | 35.975 | 15076.0 |
| 2017-04-28 04:00:00 | MSFT | Stock | 68.1 | 68.1 | 67.95 | 67.95 | 816.0 |
| 2017-04-28 04:30:00 | MSFT | Stock | 68.0 | 68.0 | 68.0 | 68.0 | 200.0 |
| 2017-04-28 05:00:00 | MSFT | Stock | 68.03 | 68.05 | 68.03 | 68.05 | 3722.0 |
| 2017-04-28 05:30:00 | MSFT | Stock | 68.02 | 68.02 | 68.02 | 68.02 | 100.0 |
| 2017-04-28 06:00:00 | MSFT | Stock | 68.01 | 68.02 | 67.95 | 67.95 | 850.0 |
| 2017-04-28 06:30:00 | MSFT | Stock | 68.05 | 68.07 | 68.05 | 68.06 | 1400.0 |
| 2017-04-28 07:00:00 | MSFT | Stock | 67.95 | 68.76 | 67.95 | 68.51 | 92654.0 |
| 2017-04-28 07:30:00 | MSFT | Stock | 68.52 | 68.6 | 68.4 | 68.4 | 25234.0 |
| 2017-04-28 08:00:00 | MSFT | Stock | 68.36 | 68.73 | 68.05 | 68.25 | 172769.0 |
| 2017-04-28 08:30:00 | MSFT | Stock | 68.29 | 68.59 | 68.0 | 68.35 | 118338.0 |
| 2017-04-28 09:00:00 | MSFT | Stock | 68.35 | 68.99 | 68.31 | 68.96 | 419872.0 |
| 2017-04-28 09:30:00 | MSFT | Stock | 68.89 | 69.14 | 68.12 | 68.26 | 9963262.0 |
| 2017-04-28 10:00:00 | MSFT | Stock | 68.26 | 68.59 | 68.155 | 68.59 | 2533186.0 |
| 2017-04-28 10:30:00 | MSFT | Stock | 68.585 | 68.59 | 68.2 | 68.24 | 2310005.0 |
| 2017-04-28 11:00:00 | MSFT | Stock | 68.23 | 68.24 | 68.02 | 68.08 | 1858089.0 |
| 2017-04-28 11:30:00 | MSFT | Stock | 68.08 | 68.087 | 67.69 | 67.82 | 2175135.0 |
| 2017-04-28 12:00:00 | MSFT | Stock | 67.82 | 68.115 | 67.81 | 68.07 | 1658554.0 |
| 2017-04-28 12:30:00 | MSFT | Stock | 68.065 | 68.11 | 68.0 | 68.05 | 869592.0 |
| 2017-04-28 13:00:00 | MSFT | Stock | 68.05 | 68.12 | 68.0 | 68.01 | 661956.0 |
> showing 50 of 81,215 rows — these rows as CSV