PREVIEW / stock_30min / 2015-12-28
file: by_date/stock_30min/2015/2015-12-28.parquet size: 1.6 MB rows: 82,757 symbols: 3,423
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-28 05:00:00 | AAPL | Stock | 26.925 | 26.925 | 26.9175 | 26.9175 | 3644.0 |
| 2015-12-28 05:30:00 | AAPL | Stock | 26.9075 | 26.9075 | 26.9075 | 26.9075 | 400.0 |
| 2015-12-28 07:00:00 | AAPL | Stock | 26.8425 | 26.8725 | 26.7925 | 26.7925 | 15548.0 |
| 2015-12-28 07:30:00 | AAPL | Stock | 26.8025 | 26.83 | 26.8 | 26.825 | 14492.0 |
| 2015-12-28 08:00:00 | AAPL | Stock | 26.8525 | 26.8875 | 26.825 | 26.875 | 73020.0 |
| 2015-12-28 08:30:00 | AAPL | Stock | 26.8825 | 26.925 | 26.8825 | 26.925 | 35220.0 |
| 2015-12-28 09:00:00 | AAPL | Stock | 26.925 | 26.9375 | 26.895 | 26.895 | 73764.0 |
| 2015-12-28 09:30:00 | AAPL | Stock | 26.8975 | 26.9225 | 26.675 | 26.6935 | 15424236.0 |
| 2015-12-28 10:00:00 | AAPL | Stock | 26.695 | 26.7375 | 26.615 | 26.6212 | 10016680.0 |
| 2015-12-28 10:30:00 | AAPL | Stock | 26.615 | 26.6625 | 26.5452 | 26.5525 | 9847620.0 |
| 2015-12-28 11:00:00 | AAPL | Stock | 26.5525 | 26.7575 | 26.55 | 26.755 | 7747680.0 |
| 2015-12-28 11:30:00 | AAPL | Stock | 26.7575 | 26.82 | 26.73 | 26.7925 | 7091100.0 |
| 2015-12-28 12:00:00 | AAPL | Stock | 26.7925 | 26.8188 | 26.7125 | 26.7462 | 4500132.0 |
| 2015-12-28 12:30:00 | AAPL | Stock | 26.7462 | 26.7805 | 26.717 | 26.744 | 4110872.0 |
| 2015-12-28 13:00:00 | AAPL | Stock | 26.745 | 26.8125 | 26.7428 | 26.7875 | 3101816.0 |
| 2015-12-28 13:30:00 | AAPL | Stock | 26.7875 | 26.835 | 26.72 | 26.737 | 4278708.0 |
| 2015-12-28 14:00:00 | AAPL | Stock | 26.7375 | 26.765 | 26.715 | 26.75 | 3680416.0 |
| 2015-12-28 14:30:00 | AAPL | Stock | 26.7525 | 26.7525 | 26.6975 | 26.702 | 4000496.0 |
| 2015-12-28 15:00:00 | AAPL | Stock | 26.704 | 26.7175 | 26.6575 | 26.671 | 5667120.0 |
| 2015-12-28 15:30:00 | AAPL | Stock | 26.67 | 26.7075 | 26.6275 | 26.705 | 11248144.0 |
| 2015-12-28 16:00:00 | AAPL | Stock | 26.705 | 26.71 | 26.6875 | 26.7025 | 7518496.0 |
| 2015-12-28 16:30:00 | AAPL | Stock | 26.705 | 26.72 | 26.7 | 26.7125 | 61020.0 |
| 2015-12-28 17:00:00 | AAPL | Stock | 26.72 | 26.72 | 26.7075 | 26.72 | 21304.0 |
| 2015-12-28 17:30:00 | AAPL | Stock | 26.71 | 26.72 | 26.7075 | 26.7075 | 16988.0 |
| 2015-12-28 18:00:00 | AAPL | Stock | 26.7175 | 26.73 | 26.7175 | 26.725 | 27084.0 |
| 2015-12-28 18:30:00 | AAPL | Stock | 26.7225 | 26.725 | 26.72 | 26.725 | 21344.0 |
| 2015-12-28 19:00:00 | AAPL | Stock | 26.7225 | 26.7225 | 26.7075 | 26.7225 | 5552.0 |
| 2015-12-28 19:30:00 | AAPL | Stock | 26.72 | 26.72 | 26.71 | 26.7175 | 9072.0 |
| 2015-12-28 07:30:00 | MSFT | Stock | 55.23 | 55.23 | 55.23 | 55.23 | 600.0 |
| 2015-12-28 08:00:00 | MSFT | Stock | 55.39 | 55.39 | 55.3 | 55.32 | 2700.0 |
| 2015-12-28 08:30:00 | MSFT | Stock | 55.32 | 55.5 | 55.32 | 55.5 | 3200.0 |
| 2015-12-28 09:00:00 | MSFT | Stock | 55.38 | 55.5 | 55.33 | 55.33 | 3190.0 |
| 2015-12-28 09:30:00 | MSFT | Stock | 55.33 | 55.45 | 55.03 | 55.27 | 2429252.0 |
| 2015-12-28 10:00:00 | MSFT | Stock | 55.28 | 55.285 | 55.11 | 55.15 | 1372355.0 |
| 2015-12-28 10:30:00 | MSFT | Stock | 55.14 | 55.235 | 54.98 | 55.04 | 1355557.0 |
| 2015-12-28 11:00:00 | MSFT | Stock | 55.04 | 55.19 | 55.01 | 55.18 | 1455718.0 |
| 2015-12-28 11:30:00 | MSFT | Stock | 55.18 | 55.34 | 55.155 | 55.3 | 898144.0 |
| 2015-12-28 12:00:00 | MSFT | Stock | 55.3 | 55.32 | 55.22 | 55.29 | 824269.0 |
| 2015-12-28 12:30:00 | MSFT | Stock | 55.29 | 55.42 | 55.23 | 55.37 | 1021062.0 |
| 2015-12-28 13:00:00 | MSFT | Stock | 55.37 | 55.666 | 55.368 | 55.648 | 1124250.0 |
| 2015-12-28 13:30:00 | MSFT | Stock | 55.64 | 55.73 | 55.5 | 55.61 | 1359154.0 |
| 2015-12-28 14:00:00 | MSFT | Stock | 55.61 | 55.86 | 55.61 | 55.835 | 1430043.0 |
| 2015-12-28 14:30:00 | MSFT | Stock | 55.84 | 55.9 | 55.75 | 55.89 | 1343346.0 |
| 2015-12-28 15:00:00 | MSFT | Stock | 55.89 | 55.95 | 55.76 | 55.81 | 1787366.0 |
| 2015-12-28 15:30:00 | MSFT | Stock | 55.815 | 55.95 | 55.8 | 55.95 | 2850899.0 |
| 2015-12-28 16:00:00 | MSFT | Stock | 55.95 | 55.97 | 55.525 | 55.95 | 1233524.0 |
| 2015-12-28 16:30:00 | MSFT | Stock | 55.99 | 56.01 | 55.94 | 56.01 | 2430.0 |
| 2015-12-28 17:00:00 | MSFT | Stock | 56.01 | 56.01 | 56.0 | 56.0 | 3372.0 |
| 2015-12-28 17:30:00 | MSFT | Stock | 55.95 | 56.0 | 55.95 | 56.0 | 1000.0 |
| 2015-12-28 18:00:00 | MSFT | Stock | 56.0 | 56.0 | 56.0 | 56.0 | 100.0 |
> showing 50 of 82,757 rows — these rows as CSV