PREVIEW / stock_30min / 2015-10-15
file: by_date/stock_30min/2015/2015-10-15.parquet size: 1.6 MB rows: 82,148 symbols: 3,439
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-10-15 04:00:00 | AAPL | Stock | 27.7125 | 27.7475 | 27.7125 | 27.7175 | 10948.0 |
| 2015-10-15 04:30:00 | AAPL | Stock | 27.725 | 27.725 | 27.725 | 27.725 | 724.0 |
| 2015-10-15 05:00:00 | AAPL | Stock | 27.725 | 27.7375 | 27.675 | 27.7 | 4908.0 |
| 2015-10-15 05:30:00 | AAPL | Stock | 27.71 | 27.715 | 27.7 | 27.715 | 7700.0 |
| 2015-10-15 06:00:00 | AAPL | Stock | 27.71 | 27.71 | 27.675 | 27.675 | 7592.0 |
| 2015-10-15 06:30:00 | AAPL | Stock | 27.675 | 27.7125 | 27.675 | 27.7125 | 12908.0 |
| 2015-10-15 07:00:00 | AAPL | Stock | 27.685 | 27.715 | 27.6475 | 27.6475 | 25916.0 |
| 2015-10-15 07:30:00 | AAPL | Stock | 27.645 | 27.685 | 27.6425 | 27.685 | 16344.0 |
| 2015-10-15 08:00:00 | AAPL | Stock | 27.6875 | 27.8 | 27.6625 | 27.75 | 321640.0 |
| 2015-10-15 08:30:00 | AAPL | Stock | 27.75 | 27.75 | 27.65 | 27.7025 | 309060.0 |
| 2015-10-15 09:00:00 | AAPL | Stock | 27.6925 | 27.7425 | 27.6625 | 27.7325 | 193248.0 |
| 2015-10-15 09:30:00 | AAPL | Stock | 27.735 | 28.025 | 27.6225 | 28.0025 | 29675312.0 |
| 2015-10-15 10:00:00 | AAPL | Stock | 28.0025 | 28.0048 | 27.7778 | 27.8325 | 14886308.0 |
| 2015-10-15 10:30:00 | AAPL | Stock | 27.8325 | 27.9325 | 27.8025 | 27.865 | 7146780.0 |
| 2015-10-15 11:00:00 | AAPL | Stock | 27.8625 | 27.875 | 27.7525 | 27.8075 | 6638052.0 |
| 2015-10-15 11:30:00 | AAPL | Stock | 27.8062 | 27.82 | 27.6275 | 27.6625 | 9908660.0 |
| 2015-10-15 12:00:00 | AAPL | Stock | 27.6625 | 27.734 | 27.6325 | 27.73 | 7159960.0 |
| 2015-10-15 12:30:00 | AAPL | Stock | 27.7325 | 27.82 | 27.715 | 27.8125 | 6760188.0 |
| 2015-10-15 13:00:00 | AAPL | Stock | 27.81 | 27.935 | 27.8025 | 27.9175 | 8020284.0 |
| 2015-10-15 13:30:00 | AAPL | Stock | 27.9175 | 27.9275 | 27.85 | 27.89 | 6245972.0 |
| 2015-10-15 14:00:00 | AAPL | Stock | 27.89 | 28.005 | 27.8888 | 27.925 | 9119504.0 |
| 2015-10-15 14:30:00 | AAPL | Stock | 27.9272 | 27.95 | 27.89 | 27.9225 | 6338696.0 |
| 2015-10-15 15:00:00 | AAPL | Stock | 27.9215 | 27.97 | 27.895 | 27.9625 | 7050928.0 |
| 2015-10-15 15:30:00 | AAPL | Stock | 27.96 | 27.975 | 27.9175 | 27.9625 | 14241452.0 |
| 2015-10-15 16:00:00 | AAPL | Stock | 27.965 | 27.965 | 27.94 | 27.955 | 6273976.0 |
| 2015-10-15 16:30:00 | AAPL | Stock | 27.9525 | 27.96 | 27.95 | 27.95 | 26784.0 |
| 2015-10-15 17:00:00 | AAPL | Stock | 27.95 | 27.96 | 27.94 | 27.95 | 46616.0 |
| 2015-10-15 17:30:00 | AAPL | Stock | 27.95 | 27.9575 | 27.94 | 27.9525 | 12240.0 |
| 2015-10-15 18:00:00 | AAPL | Stock | 27.955 | 27.96 | 27.9475 | 27.9575 | 15028.0 |
| 2015-10-15 18:30:00 | AAPL | Stock | 27.9475 | 27.9875 | 27.9475 | 27.985 | 23968.0 |
| 2015-10-15 19:00:00 | AAPL | Stock | 27.9825 | 27.985 | 27.97 | 27.975 | 17588.0 |
| 2015-10-15 19:30:00 | AAPL | Stock | 27.97 | 27.9875 | 27.97 | 27.985 | 36340.0 |
| 2015-10-15 07:00:00 | MSFT | Stock | 46.9 | 46.91 | 46.9 | 46.9 | 2400.0 |
| 2015-10-15 07:30:00 | MSFT | Stock | 46.88 | 46.9 | 46.85 | 46.9 | 700.0 |
| 2015-10-15 08:00:00 | MSFT | Stock | 46.94 | 46.94 | 46.88 | 46.88 | 4370.0 |
| 2015-10-15 08:30:00 | MSFT | Stock | 46.88 | 46.88 | 46.8 | 46.85 | 1200.0 |
| 2015-10-15 09:00:00 | MSFT | Stock | 46.9 | 47.04 | 46.85 | 47.04 | 33380.0 |
| 2015-10-15 09:30:00 | MSFT | Stock | 47.01 | 47.02 | 46.53 | 46.595 | 2360000.0 |
| 2015-10-15 10:00:00 | MSFT | Stock | 46.59 | 46.8 | 46.53 | 46.795 | 1091798.0 |
| 2015-10-15 10:30:00 | MSFT | Stock | 46.8 | 46.93 | 46.745 | 46.91 | 1138196.0 |
| 2015-10-15 11:00:00 | MSFT | Stock | 46.9 | 47.01 | 46.84 | 46.895 | 1103012.0 |
| 2015-10-15 11:30:00 | MSFT | Stock | 46.9 | 46.97 | 46.78 | 46.79 | 1720630.0 |
| 2015-10-15 12:00:00 | MSFT | Stock | 46.79 | 46.79 | 46.65 | 46.75 | 1028280.0 |
| 2015-10-15 12:30:00 | MSFT | Stock | 46.747 | 46.76 | 46.63 | 46.7 | 1627895.0 |
| 2015-10-15 13:00:00 | MSFT | Stock | 46.69 | 46.85 | 46.675 | 46.781 | 1303731.0 |
| 2015-10-15 13:30:00 | MSFT | Stock | 46.79 | 46.79 | 46.65 | 46.7 | 1209109.0 |
| 2015-10-15 14:00:00 | MSFT | Stock | 46.69 | 46.79 | 46.69 | 46.79 | 1357489.0 |
| 2015-10-15 14:30:00 | MSFT | Stock | 46.78 | 46.87 | 46.745 | 46.745 | 1961008.0 |
| 2015-10-15 15:00:00 | MSFT | Stock | 46.75 | 47.02 | 46.75 | 46.91 | 2924644.0 |
| 2015-10-15 15:30:00 | MSFT | Stock | 46.91 | 47.03 | 46.81 | 47.03 | 4813106.0 |
> showing 50 of 82,148 rows — these rows as CSV