PREVIEW / stock_30min / 2015-12-11
file: by_date/stock_30min/2015/2015-12-11.parquet size: 1.6 MB rows: 84,322 symbols: 3,405
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-11 04:00:00 | AAPL | Stock | 29.0425 | 29.0425 | 28.95 | 28.95 | 27736.0 |
| 2015-12-11 04:30:00 | AAPL | Stock | 28.975 | 28.9875 | 28.9325 | 28.9875 | 55440.0 |
| 2015-12-11 05:00:00 | AAPL | Stock | 28.965 | 28.965 | 28.965 | 28.965 | 2000.0 |
| 2015-12-11 05:30:00 | AAPL | Stock | 28.875 | 28.875 | 28.805 | 28.8125 | 7680.0 |
| 2015-12-11 06:00:00 | AAPL | Stock | 28.83 | 28.845 | 28.7775 | 28.79 | 22364.0 |
| 2015-12-11 06:30:00 | AAPL | Stock | 28.8125 | 28.8325 | 28.8075 | 28.8125 | 9200.0 |
| 2015-12-11 07:00:00 | AAPL | Stock | 28.8375 | 28.875 | 28.805 | 28.805 | 92232.0 |
| 2015-12-11 07:30:00 | AAPL | Stock | 28.8 | 28.8025 | 28.72 | 28.725 | 207268.0 |
| 2015-12-11 08:00:00 | AAPL | Stock | 28.75 | 28.84 | 28.7325 | 28.7675 | 422404.0 |
| 2015-12-11 08:30:00 | AAPL | Stock | 28.7675 | 28.86 | 28.7675 | 28.8325 | 187112.0 |
| 2015-12-11 09:00:00 | AAPL | Stock | 28.825 | 28.825 | 28.7025 | 28.8 | 850564.0 |
| 2015-12-11 09:30:00 | AAPL | Stock | 28.8025 | 28.8475 | 28.5525 | 28.6265 | 23125496.0 |
| 2015-12-11 10:00:00 | AAPL | Stock | 28.6225 | 28.7125 | 28.51 | 28.6252 | 16322636.0 |
| 2015-12-11 10:30:00 | AAPL | Stock | 28.62 | 28.6325 | 28.445 | 28.49 | 12714072.0 |
| 2015-12-11 11:00:00 | AAPL | Stock | 28.4888 | 28.52 | 28.335 | 28.36 | 11997788.0 |
| 2015-12-11 11:30:00 | AAPL | Stock | 28.36 | 28.4375 | 28.295 | 28.33 | 12612032.0 |
| 2015-12-11 12:00:00 | AAPL | Stock | 28.3325 | 28.3675 | 28.2128 | 28.285 | 13305552.0 |
| 2015-12-11 12:30:00 | AAPL | Stock | 28.285 | 28.3875 | 28.26 | 28.375 | 8804056.0 |
| 2015-12-11 13:00:00 | AAPL | Stock | 28.374 | 28.45 | 28.3338 | 28.3525 | 8716836.0 |
| 2015-12-11 13:30:00 | AAPL | Stock | 28.3525 | 28.4325 | 28.295 | 28.4088 | 7246536.0 |
| 2015-12-11 14:00:00 | AAPL | Stock | 28.41 | 28.45 | 28.3525 | 28.39 | 7411556.0 |
| 2015-12-11 14:30:00 | AAPL | Stock | 28.3925 | 28.4025 | 28.3125 | 28.345 | 6820512.0 |
| 2015-12-11 15:00:00 | AAPL | Stock | 28.345 | 28.42 | 28.215 | 28.2702 | 11330964.0 |
| 2015-12-11 15:30:00 | AAPL | Stock | 28.2725 | 28.33 | 28.2525 | 28.2925 | 17219556.0 |
| 2015-12-11 16:00:00 | AAPL | Stock | 28.295 | 28.325 | 28.2875 | 28.295 | 14844008.0 |
| 2015-12-11 16:30:00 | AAPL | Stock | 28.2975 | 28.3025 | 28.295 | 28.295 | 325708.0 |
| 2015-12-11 17:00:00 | AAPL | Stock | 28.3 | 28.31 | 28.295 | 28.295 | 33308.0 |
| 2015-12-11 17:30:00 | AAPL | Stock | 28.295 | 28.305 | 28.285 | 28.285 | 16748.0 |
| 2015-12-11 18:00:00 | AAPL | Stock | 28.285 | 28.2875 | 28.2525 | 28.27 | 114452.0 |
| 2015-12-11 18:30:00 | AAPL | Stock | 28.2675 | 28.27 | 28.25 | 28.26 | 47228.0 |
| 2015-12-11 19:00:00 | AAPL | Stock | 28.25 | 28.26 | 28.225 | 28.225 | 29332.0 |
| 2015-12-11 19:30:00 | AAPL | Stock | 28.22 | 28.25 | 28.22 | 28.2375 | 26328.0 |
| 2015-12-11 04:00:00 | MSFT | Stock | 55.2 | 55.2 | 55.2 | 55.2 | 500.0 |
| 2015-12-11 05:30:00 | MSFT | Stock | 55.0 | 55.0 | 55.0 | 55.0 | 400.0 |
| 2015-12-11 07:00:00 | MSFT | Stock | 55.0 | 55.0 | 54.9 | 54.9 | 500.0 |
| 2015-12-11 07:30:00 | MSFT | Stock | 54.9 | 54.9 | 54.7 | 54.7 | 34701.0 |
| 2015-12-11 08:00:00 | MSFT | Stock | 54.79 | 54.87 | 54.72 | 54.83 | 12685.0 |
| 2015-12-11 08:30:00 | MSFT | Stock | 54.81 | 54.95 | 54.8 | 54.87 | 39380.0 |
| 2015-12-11 09:00:00 | MSFT | Stock | 54.82 | 54.82 | 54.38 | 54.38 | 144059.0 |
| 2015-12-11 09:30:00 | MSFT | Stock | 54.39 | 54.896 | 54.38 | 54.885 | 4536183.0 |
| 2015-12-11 10:00:00 | MSFT | Stock | 54.89 | 55.1 | 54.77 | 54.94 | 2860140.0 |
| 2015-12-11 10:30:00 | MSFT | Stock | 54.95 | 55.01 | 54.73 | 54.75 | 2327867.0 |
| 2015-12-11 11:00:00 | MSFT | Stock | 54.75 | 54.84 | 54.55 | 54.596 | 2156111.0 |
| 2015-12-11 11:30:00 | MSFT | Stock | 54.6 | 54.64 | 54.3 | 54.3 | 1940223.0 |
| 2015-12-11 12:00:00 | MSFT | Stock | 54.31 | 54.375 | 54.12 | 54.315 | 2266662.0 |
| 2015-12-11 12:30:00 | MSFT | Stock | 54.315 | 54.6 | 54.245 | 54.49 | 1898385.0 |
| 2015-12-11 13:00:00 | MSFT | Stock | 54.48 | 54.58 | 54.3 | 54.325 | 1423084.0 |
| 2015-12-11 13:30:00 | MSFT | Stock | 54.33 | 54.68 | 54.257 | 54.57 | 1396491.0 |
| 2015-12-11 14:00:00 | MSFT | Stock | 54.57 | 54.69 | 54.5 | 54.545 | 1463614.0 |
| 2015-12-11 14:30:00 | MSFT | Stock | 54.55 | 54.58 | 54.285 | 54.32 | 1854652.0 |
> showing 50 of 84,322 rows — these rows as CSV