PREVIEW / stock_30min / 2015-12-08
file: by_date/stock_30min/2015/2015-12-08.parquet size: 1.6 MB rows: 83,108 symbols: 3,419
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-08 04:00:00 | AAPL | Stock | 29.4875 | 29.5125 | 29.4875 | 29.49 | 15416.0 |
| 2015-12-08 04:30:00 | AAPL | Stock | 29.4875 | 29.4875 | 29.4075 | 29.475 | 11844.0 |
| 2015-12-08 05:00:00 | AAPL | Stock | 29.4675 | 29.4875 | 29.455 | 29.455 | 6800.0 |
| 2015-12-08 05:30:00 | AAPL | Stock | 29.485 | 29.4875 | 29.475 | 29.475 | 4800.0 |
| 2015-12-08 06:00:00 | AAPL | Stock | 29.475 | 29.475 | 29.4625 | 29.4625 | 4000.0 |
| 2015-12-08 06:30:00 | AAPL | Stock | 29.45 | 29.47 | 29.425 | 29.425 | 6200.0 |
| 2015-12-08 07:00:00 | AAPL | Stock | 29.425 | 29.4275 | 29.3975 | 29.3975 | 40904.0 |
| 2015-12-08 07:30:00 | AAPL | Stock | 29.385 | 29.385 | 29.305 | 29.32 | 60844.0 |
| 2015-12-08 08:00:00 | AAPL | Stock | 29.31 | 29.45 | 29.25 | 29.2525 | 294648.0 |
| 2015-12-08 08:30:00 | AAPL | Stock | 29.2725 | 29.305 | 29.25 | 29.275 | 259520.0 |
| 2015-12-08 09:00:00 | AAPL | Stock | 29.2725 | 29.375 | 29.1925 | 29.35 | 612144.0 |
| 2015-12-08 09:30:00 | AAPL | Stock | 29.35 | 29.525 | 29.2525 | 29.2638 | 19284736.0 |
| 2015-12-08 10:00:00 | AAPL | Stock | 29.265 | 29.345 | 29.215 | 29.2658 | 14337952.0 |
| 2015-12-08 10:30:00 | AAPL | Stock | 29.2675 | 29.5425 | 29.24 | 29.5 | 12075124.0 |
| 2015-12-08 11:00:00 | AAPL | Stock | 29.4975 | 29.65 | 29.4975 | 29.535 | 10213788.0 |
| 2015-12-08 11:30:00 | AAPL | Stock | 29.53 | 29.56 | 29.4275 | 29.475 | 6959768.0 |
| 2015-12-08 12:00:00 | AAPL | Stock | 29.475 | 29.48 | 29.34 | 29.41 | 5978520.0 |
| 2015-12-08 12:30:00 | AAPL | Stock | 29.41 | 29.46 | 29.36 | 29.458 | 4338288.0 |
| 2015-12-08 13:00:00 | AAPL | Stock | 29.4588 | 29.4975 | 29.3702 | 29.4075 | 5010072.0 |
| 2015-12-08 13:30:00 | AAPL | Stock | 29.4075 | 29.4575 | 29.395 | 29.435 | 4171184.0 |
| 2015-12-08 14:00:00 | AAPL | Stock | 29.4325 | 29.54 | 29.4275 | 29.4538 | 6720868.0 |
| 2015-12-08 14:30:00 | AAPL | Stock | 29.4525 | 29.52 | 29.41 | 29.4675 | 6054616.0 |
| 2015-12-08 15:00:00 | AAPL | Stock | 29.468 | 29.5325 | 29.4275 | 29.5025 | 6990044.0 |
| 2015-12-08 15:30:00 | AAPL | Stock | 29.5025 | 29.6275 | 29.475 | 29.56 | 15327000.0 |
| 2015-12-08 16:00:00 | AAPL | Stock | 29.5575 | 29.575 | 29.4362 | 29.535 | 10641904.0 |
| 2015-12-08 16:30:00 | AAPL | Stock | 29.5325 | 29.5575 | 29.5325 | 29.5575 | 37352.0 |
| 2015-12-08 17:00:00 | AAPL | Stock | 29.55 | 29.5575 | 29.5375 | 29.555 | 12412.0 |
| 2015-12-08 17:30:00 | AAPL | Stock | 29.55 | 29.55 | 29.545 | 29.545 | 5940.0 |
| 2015-12-08 18:00:00 | AAPL | Stock | 29.535 | 29.5375 | 29.5275 | 29.5275 | 4832.0 |
| 2015-12-08 18:30:00 | AAPL | Stock | 29.5275 | 29.565 | 29.5275 | 29.565 | 18976.0 |
| 2015-12-08 19:00:00 | AAPL | Stock | 29.5875 | 29.6175 | 29.5875 | 29.5875 | 6784.0 |
| 2015-12-08 19:30:00 | AAPL | Stock | 29.5875 | 29.625 | 29.585 | 29.6225 | 53600.0 |
| 2015-12-08 07:00:00 | MSFT | Stock | 55.57 | 55.6 | 55.46 | 55.46 | 2900.0 |
| 2015-12-08 07:30:00 | MSFT | Stock | 55.49 | 55.49 | 55.32 | 55.32 | 5498.0 |
| 2015-12-08 08:00:00 | MSFT | Stock | 55.4 | 55.55 | 55.12 | 55.12 | 15808.0 |
| 2015-12-08 08:30:00 | MSFT | Stock | 55.2 | 55.32 | 55.11 | 55.18 | 13730.0 |
| 2015-12-08 09:00:00 | MSFT | Stock | 55.13 | 55.57 | 55.11 | 55.41 | 102583.0 |
| 2015-12-08 09:30:00 | MSFT | Stock | 55.47 | 55.7 | 54.99 | 55.375 | 4920346.0 |
| 2015-12-08 10:00:00 | MSFT | Stock | 55.38 | 55.58 | 55.195 | 55.33 | 1732270.0 |
| 2015-12-08 10:30:00 | MSFT | Stock | 55.32 | 55.62 | 55.24 | 55.54 | 2406084.0 |
| 2015-12-08 11:00:00 | MSFT | Stock | 55.54 | 55.82 | 55.505 | 55.51 | 2610104.0 |
| 2015-12-08 11:30:00 | MSFT | Stock | 55.51 | 55.8 | 55.47 | 55.745 | 1594740.0 |
| 2015-12-08 12:00:00 | MSFT | Stock | 55.745 | 55.75 | 55.52 | 55.585 | 1037323.0 |
| 2015-12-08 12:30:00 | MSFT | Stock | 55.58 | 55.76 | 55.5 | 55.75 | 1043773.0 |
| 2015-12-08 13:00:00 | MSFT | Stock | 55.76 | 55.87 | 55.71 | 55.82 | 1698699.0 |
| 2015-12-08 13:30:00 | MSFT | Stock | 55.82 | 55.936 | 55.814 | 55.935 | 1298992.0 |
| 2015-12-08 14:00:00 | MSFT | Stock | 55.93 | 56.1 | 55.91 | 55.99 | 2234318.0 |
| 2015-12-08 14:30:00 | MSFT | Stock | 55.99 | 56.096 | 55.87 | 55.97 | 1684043.0 |
| 2015-12-08 15:00:00 | MSFT | Stock | 55.97 | 55.97 | 55.69 | 55.8 | 2051152.0 |
| 2015-12-08 15:30:00 | MSFT | Stock | 55.8 | 56.01 | 55.76 | 55.79 | 4218144.0 |
> showing 50 of 83,108 rows — these rows as CSV