PREVIEW / stock_30min / 2015-12-10
file: by_date/stock_30min/2015/2015-12-10.parquet size: 1.6 MB rows: 82,206 symbols: 3,408
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-10 04:00:00 | AAPL | Stock | 28.985 | 29.0175 | 28.985 | 29.0175 | 6400.0 |
| 2015-12-10 04:30:00 | AAPL | Stock | 29.0 | 29.0 | 28.96 | 28.9875 | 2400.0 |
| 2015-12-10 05:00:00 | AAPL | Stock | 28.96 | 28.9725 | 28.96 | 28.9725 | 1184.0 |
| 2015-12-10 05:30:00 | AAPL | Stock | 29.0125 | 29.045 | 29.0125 | 29.035 | 1508.0 |
| 2015-12-10 06:00:00 | AAPL | Stock | 29.0375 | 29.0375 | 29.0 | 29.0 | 2000.0 |
| 2015-12-10 06:30:00 | AAPL | Stock | 28.975 | 29.0 | 28.95 | 28.9925 | 18384.0 |
| 2015-12-10 07:00:00 | AAPL | Stock | 29.0025 | 29.005 | 28.95 | 28.9875 | 11320.0 |
| 2015-12-10 07:30:00 | AAPL | Stock | 28.965 | 28.985 | 28.94 | 28.985 | 36608.0 |
| 2015-12-10 08:00:00 | AAPL | Stock | 28.985 | 29.05 | 28.9625 | 29.0125 | 148824.0 |
| 2015-12-10 08:30:00 | AAPL | Stock | 29.015 | 29.07 | 29.0125 | 29.02 | 207288.0 |
| 2015-12-10 09:00:00 | AAPL | Stock | 29.02 | 29.0725 | 29.0 | 29.065 | 327164.0 |
| 2015-12-10 09:30:00 | AAPL | Stock | 29.01 | 29.0975 | 28.9 | 28.96 | 18411488.0 |
| 2015-12-10 10:00:00 | AAPL | Stock | 28.9525 | 29.06 | 28.8775 | 29.025 | 12358124.0 |
| 2015-12-10 10:30:00 | AAPL | Stock | 29.025 | 29.1725 | 28.98 | 29.1 | 10011164.0 |
| 2015-12-10 11:00:00 | AAPL | Stock | 29.1 | 29.1175 | 29.025 | 29.025 | 6435868.0 |
| 2015-12-10 11:30:00 | AAPL | Stock | 29.025 | 29.0275 | 28.9425 | 28.9875 | 6339772.0 |
| 2015-12-10 12:00:00 | AAPL | Stock | 28.9878 | 29.0325 | 28.954 | 28.9825 | 4191912.0 |
| 2015-12-10 12:30:00 | AAPL | Stock | 28.9825 | 29.0525 | 28.9425 | 29.0225 | 6028964.0 |
| 2015-12-10 13:00:00 | AAPL | Stock | 29.025 | 29.085 | 29.0025 | 29.0528 | 4363028.0 |
| 2015-12-10 13:30:00 | AAPL | Stock | 29.055 | 29.125 | 29.0498 | 29.0638 | 4520576.0 |
| 2015-12-10 14:00:00 | AAPL | Stock | 29.0642 | 29.1975 | 29.06 | 29.195 | 5092168.0 |
| 2015-12-10 14:30:00 | AAPL | Stock | 29.1975 | 29.235 | 29.1525 | 29.165 | 6410932.0 |
| 2015-12-10 15:00:00 | AAPL | Stock | 29.1638 | 29.1775 | 29.0175 | 29.0725 | 6990652.0 |
| 2015-12-10 15:30:00 | AAPL | Stock | 29.07 | 29.075 | 28.975 | 29.045 | 10247788.0 |
| 2015-12-10 16:00:00 | AAPL | Stock | 29.0425 | 29.06 | 29.015 | 29.04 | 6410532.0 |
| 2015-12-10 16:30:00 | AAPL | Stock | 29.0375 | 29.05 | 29.0375 | 29.0475 | 22172.0 |
| 2015-12-10 17:00:00 | AAPL | Stock | 29.065 | 29.065 | 29.045 | 29.05 | 44792.0 |
| 2015-12-10 17:30:00 | AAPL | Stock | 29.055 | 29.07 | 29.05 | 29.05 | 15312.0 |
| 2015-12-10 18:00:00 | AAPL | Stock | 29.0525 | 29.0825 | 29.0525 | 29.0525 | 12100.0 |
| 2015-12-10 18:30:00 | AAPL | Stock | 29.0625 | 29.095 | 29.06 | 29.095 | 26680.0 |
| 2015-12-10 19:00:00 | AAPL | Stock | 29.0925 | 29.0975 | 29.0775 | 29.095 | 10400.0 |
| 2015-12-10 19:30:00 | AAPL | Stock | 29.0725 | 29.105 | 29.0725 | 29.105 | 26252.0 |
| 2015-12-10 06:00:00 | MSFT | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 500.0 |
| 2015-12-10 06:30:00 | MSFT | Stock | 55.05 | 55.05 | 55.03 | 55.03 | 400.0 |
| 2015-12-10 07:00:00 | MSFT | Stock | 55.11 | 55.11 | 55.0 | 55.0 | 5200.0 |
| 2015-12-10 07:30:00 | MSFT | Stock | 55.05 | 55.1 | 55.05 | 55.1 | 4900.0 |
| 2015-12-10 08:00:00 | MSFT | Stock | 55.05 | 55.23 | 55.05 | 55.18 | 27956.0 |
| 2015-12-10 08:30:00 | MSFT | Stock | 55.14 | 55.14 | 55.1 | 55.1 | 9790.0 |
| 2015-12-10 09:00:00 | MSFT | Stock | 55.1 | 55.38 | 55.1 | 55.38 | 21500.0 |
| 2015-12-10 09:30:00 | MSFT | Stock | 55.38 | 55.55 | 55.01 | 55.32 | 3341440.0 |
| 2015-12-10 10:00:00 | MSFT | Stock | 55.32 | 55.455 | 55.165 | 55.34 | 2053974.0 |
| 2015-12-10 10:30:00 | MSFT | Stock | 55.34 | 55.585 | 55.26 | 55.45 | 2289113.0 |
| 2015-12-10 11:00:00 | MSFT | Stock | 55.44 | 55.55 | 55.37 | 55.4 | 1360446.0 |
| 2015-12-10 11:30:00 | MSFT | Stock | 55.4 | 55.46 | 55.3 | 55.4 | 1443370.0 |
| 2015-12-10 12:00:00 | MSFT | Stock | 55.39 | 55.42 | 55.02 | 55.12 | 1562060.0 |
| 2015-12-10 12:30:00 | MSFT | Stock | 55.13 | 55.325 | 55.06 | 55.3 | 1345900.0 |
| 2015-12-10 13:00:00 | MSFT | Stock | 55.31 | 55.425 | 55.18 | 55.36 | 1070614.0 |
| 2015-12-10 13:30:00 | MSFT | Stock | 55.37 | 55.435 | 55.24 | 55.245 | 1167742.0 |
| 2015-12-10 14:00:00 | MSFT | Stock | 55.24 | 55.6 | 55.23 | 55.595 | 1539757.0 |
| 2015-12-10 14:30:00 | MSFT | Stock | 55.6 | 55.655 | 55.42 | 55.48 | 1510760.0 |
> showing 50 of 82,206 rows — these rows as CSV