PREVIEW / stock_30min / 2015-12-02
file: by_date/stock_30min/2015/2015-12-02.parquet size: 1.6 MB rows: 82,571 symbols: 3,445
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-02 04:00:00 | AAPL | Stock | 29.3425 | 29.3425 | 29.3425 | 29.3425 | 400.0 |
| 2015-12-02 04:30:00 | AAPL | Stock | 29.3725 | 29.3725 | 29.3725 | 29.3725 | 2000.0 |
| 2015-12-02 05:00:00 | AAPL | Stock | 29.365 | 29.365 | 29.365 | 29.365 | 400.0 |
| 2015-12-02 05:30:00 | AAPL | Stock | 29.35 | 29.35 | 29.35 | 29.35 | 400.0 |
| 2015-12-02 06:00:00 | AAPL | Stock | 29.35 | 29.3725 | 29.35 | 29.37 | 6204.0 |
| 2015-12-02 06:30:00 | AAPL | Stock | 29.3625 | 29.3625 | 29.335 | 29.335 | 4832.0 |
| 2015-12-02 07:00:00 | AAPL | Stock | 29.335 | 29.34 | 29.2975 | 29.31 | 22868.0 |
| 2015-12-02 07:30:00 | AAPL | Stock | 29.31 | 29.3125 | 29.2875 | 29.29 | 35448.0 |
| 2015-12-02 08:00:00 | AAPL | Stock | 29.3 | 29.3125 | 29.2625 | 29.265 | 125784.0 |
| 2015-12-02 08:30:00 | AAPL | Stock | 29.27 | 29.335 | 29.225 | 29.2425 | 157848.0 |
| 2015-12-02 09:00:00 | AAPL | Stock | 29.2475 | 29.28 | 29.235 | 29.2525 | 139592.0 |
| 2015-12-02 09:30:00 | AAPL | Stock | 29.2625 | 29.45 | 29.25 | 29.405 | 14647088.0 |
| 2015-12-02 10:00:00 | AAPL | Stock | 29.405 | 29.445 | 29.3402 | 29.3838 | 9752032.0 |
| 2015-12-02 10:30:00 | AAPL | Stock | 29.385 | 29.5275 | 29.335 | 29.47 | 11239108.0 |
| 2015-12-02 11:00:00 | AAPL | Stock | 29.47 | 29.5025 | 29.4275 | 29.4588 | 7111400.0 |
| 2015-12-02 11:30:00 | AAPL | Stock | 29.4562 | 29.4825 | 29.415 | 29.4388 | 5535864.0 |
| 2015-12-02 12:00:00 | AAPL | Stock | 29.44 | 29.51 | 29.4 | 29.4975 | 4696476.0 |
| 2015-12-02 12:30:00 | AAPL | Stock | 29.5125 | 29.5175 | 29.46 | 29.4825 | 4690736.0 |
| 2015-12-02 13:00:00 | AAPL | Stock | 29.48 | 29.4925 | 29.4025 | 29.4325 | 4286800.0 |
| 2015-12-02 13:30:00 | AAPL | Stock | 29.4325 | 29.4425 | 29.31 | 29.3225 | 4819524.0 |
| 2015-12-02 14:00:00 | AAPL | Stock | 29.32 | 29.32 | 29.185 | 29.2475 | 9197736.0 |
| 2015-12-02 14:30:00 | AAPL | Stock | 29.2465 | 29.25 | 29.0845 | 29.1275 | 8957840.0 |
| 2015-12-02 15:00:00 | AAPL | Stock | 29.13 | 29.2125 | 29.105 | 29.1325 | 8097132.0 |
| 2015-12-02 15:30:00 | AAPL | Stock | 29.1275 | 29.1648 | 29.02 | 29.075 | 17205372.0 |
| 2015-12-02 16:00:00 | AAPL | Stock | 29.07 | 29.11 | 29.07 | 29.0875 | 12981792.0 |
| 2015-12-02 16:30:00 | AAPL | Stock | 29.0875 | 29.1075 | 29.07 | 29.0975 | 178344.0 |
| 2015-12-02 17:00:00 | AAPL | Stock | 29.0975 | 29.105 | 29.055 | 29.0875 | 135012.0 |
| 2015-12-02 17:30:00 | AAPL | Stock | 29.075 | 29.0975 | 29.0725 | 29.0975 | 49440.0 |
| 2015-12-02 18:00:00 | AAPL | Stock | 29.09 | 29.11 | 29.0625 | 29.085 | 42516.0 |
| 2015-12-02 18:30:00 | AAPL | Stock | 29.08 | 29.1 | 29.08 | 29.1 | 9844.0 |
| 2015-12-02 19:00:00 | AAPL | Stock | 29.105 | 29.1075 | 29.1 | 29.1075 | 15748.0 |
| 2015-12-02 19:30:00 | AAPL | Stock | 29.1 | 29.11 | 29.095 | 29.1075 | 49492.0 |
| 2015-12-02 05:30:00 | MSFT | Stock | 55.33 | 55.33 | 55.33 | 55.33 | 400.0 |
| 2015-12-02 06:30:00 | MSFT | Stock | 55.26 | 55.26 | 55.26 | 55.26 | 300.0 |
| 2015-12-02 07:00:00 | MSFT | Stock | 55.3 | 55.3 | 55.24 | 55.24 | 2005.0 |
| 2015-12-02 07:30:00 | MSFT | Stock | 55.25 | 55.25 | 55.17 | 55.17 | 2992.0 |
| 2015-12-02 08:00:00 | MSFT | Stock | 55.35 | 55.38 | 55.24 | 55.28 | 23626.0 |
| 2015-12-02 08:30:00 | MSFT | Stock | 55.28 | 55.3 | 55.16 | 55.18 | 9285.0 |
| 2015-12-02 09:00:00 | MSFT | Stock | 55.22 | 55.38 | 55.17 | 55.37 | 23060.0 |
| 2015-12-02 09:30:00 | MSFT | Stock | 55.38 | 55.79 | 55.25 | 55.706 | 4919209.0 |
| 2015-12-02 10:00:00 | MSFT | Stock | 55.7 | 55.96 | 55.64 | 55.825 | 3039312.0 |
| 2015-12-02 10:30:00 | MSFT | Stock | 55.82 | 55.87 | 55.6 | 55.69 | 3492937.0 |
| 2015-12-02 11:00:00 | MSFT | Stock | 55.68 | 55.78 | 55.56 | 55.69 | 2782697.0 |
| 2015-12-02 11:30:00 | MSFT | Stock | 55.69 | 55.73 | 55.563 | 55.73 | 2580081.0 |
| 2015-12-02 12:00:00 | MSFT | Stock | 55.725 | 55.91 | 55.68 | 55.855 | 2016723.0 |
| 2015-12-02 12:30:00 | MSFT | Stock | 55.86 | 55.88 | 55.7 | 55.8 | 1961067.0 |
| 2015-12-02 13:00:00 | MSFT | Stock | 55.8 | 55.86 | 55.72 | 55.8 | 1307747.0 |
| 2015-12-02 13:30:00 | MSFT | Stock | 55.8 | 55.826 | 55.39 | 55.444 | 2830684.0 |
| 2015-12-02 14:00:00 | MSFT | Stock | 55.45 | 55.495 | 55.27 | 55.42 | 2603182.0 |
| 2015-12-02 14:30:00 | MSFT | Stock | 55.42 | 55.44 | 55.06 | 55.12 | 2320249.0 |
> showing 50 of 82,571 rows — these rows as CSV