PREVIEW / stock_30min / 2014-12-08
file: by_date/stock_30min/2014/2014-12-08.parquet size: 1.7 MB rows: 84,935 symbols: 3,562
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-08 04:00:00 | AAPL | Stock | 28.6875 | 28.695 | 28.65 | 28.65 | 11780.0 |
| 2014-12-08 05:30:00 | AAPL | Stock | 28.5875 | 28.5925 | 28.575 | 28.5925 | 20640.0 |
| 2014-12-08 06:00:00 | AAPL | Stock | 28.575 | 28.6375 | 28.5725 | 28.625 | 49456.0 |
| 2014-12-08 06:30:00 | AAPL | Stock | 28.65 | 28.7075 | 28.575 | 28.5775 | 59520.0 |
| 2014-12-08 07:00:00 | AAPL | Stock | 28.6075 | 28.6675 | 28.6075 | 28.65 | 96532.0 |
| 2014-12-08 07:30:00 | AAPL | Stock | 28.65 | 28.7075 | 28.5925 | 28.5925 | 123864.0 |
| 2014-12-08 08:00:00 | AAPL | Stock | 28.6025 | 28.67 | 28.6025 | 28.62 | 355348.0 |
| 2014-12-08 08:30:00 | AAPL | Stock | 28.62 | 28.62 | 28.4775 | 28.49 | 543968.0 |
| 2014-12-08 09:00:00 | AAPL | Stock | 28.49 | 28.585 | 28.49 | 28.53 | 442768.0 |
| 2014-12-08 09:30:00 | AAPL | Stock | 28.525 | 28.662 | 28.2825 | 28.5628 | 26777568.0 |
| 2014-12-08 10:00:00 | AAPL | Stock | 28.5775 | 28.62 | 28.45 | 28.5265 | 11870544.0 |
| 2014-12-08 10:30:00 | AAPL | Stock | 28.5275 | 28.5822 | 28.44 | 28.464 | 9524996.0 |
| 2014-12-08 11:00:00 | AAPL | Stock | 28.4628 | 28.4628 | 28.315 | 28.32 | 13828400.0 |
| 2014-12-08 11:30:00 | AAPL | Stock | 28.32 | 28.4425 | 28.32 | 28.42 | 12072104.0 |
| 2014-12-08 12:00:00 | AAPL | Stock | 28.42 | 28.455 | 28.0675 | 28.11 | 22563868.0 |
| 2014-12-08 12:30:00 | AAPL | Stock | 28.11 | 28.1998 | 28.005 | 28.0522 | 18053788.0 |
| 2014-12-08 13:00:00 | AAPL | Stock | 28.0525 | 28.205 | 28.035 | 28.0775 | 12433064.0 |
| 2014-12-08 13:30:00 | AAPL | Stock | 28.08 | 28.0898 | 27.9325 | 27.9775 | 17559092.0 |
| 2014-12-08 14:00:00 | AAPL | Stock | 27.9775 | 28.115 | 27.905 | 28.075 | 14793020.0 |
| 2014-12-08 14:30:00 | AAPL | Stock | 28.0748 | 28.16 | 28.045 | 28.1275 | 10513480.0 |
| 2014-12-08 15:00:00 | AAPL | Stock | 28.1275 | 28.146 | 28.065 | 28.07 | 8587220.0 |
| 2014-12-08 15:30:00 | AAPL | Stock | 28.07 | 28.12 | 28.02 | 28.1025 | 18012740.0 |
| 2014-12-08 16:00:00 | AAPL | Stock | 28.105 | 28.813 | 28.0638 | 28.1125 | 16364556.0 |
| 2014-12-08 16:30:00 | AAPL | Stock | 28.1125 | 28.115 | 28.0965 | 28.105 | 198896.0 |
| 2014-12-08 17:00:00 | AAPL | Stock | 28.105 | 28.2528 | 28.1 | 28.12 | 299232.0 |
| 2014-12-08 17:30:00 | AAPL | Stock | 28.12 | 28.135 | 28.1 | 28.135 | 328748.0 |
| 2014-12-08 18:00:00 | AAPL | Stock | 28.135 | 28.14 | 28.1 | 28.1375 | 180148.0 |
| 2014-12-08 18:30:00 | AAPL | Stock | 28.1375 | 28.1475 | 28.1275 | 28.1375 | 160976.0 |
| 2014-12-08 19:00:00 | AAPL | Stock | 28.1425 | 28.1475 | 28.1375 | 28.1375 | 40160.0 |
| 2014-12-08 19:30:00 | AAPL | Stock | 28.1375 | 28.165 | 28.1375 | 28.16 | 144240.0 |
| 2014-12-08 04:00:00 | MSFT | Stock | 48.5 | 48.5 | 48.5 | 48.5 | 220.0 |
| 2014-12-08 05:30:00 | MSFT | Stock | 48.4 | 48.4 | 48.2 | 48.2 | 300.0 |
| 2014-12-08 07:00:00 | MSFT | Stock | 48.25 | 48.25 | 48.25 | 48.25 | 600.0 |
| 2014-12-08 08:00:00 | MSFT | Stock | 48.25 | 48.25 | 48.21 | 48.21 | 979.0 |
| 2014-12-08 08:30:00 | MSFT | Stock | 48.25 | 48.25 | 48.21 | 48.24 | 1277.0 |
| 2014-12-08 09:00:00 | MSFT | Stock | 48.24 | 48.49 | 48.15 | 48.2 | 18567.0 |
| 2014-12-08 09:30:00 | MSFT | Stock | 48.26 | 48.35 | 48.12 | 48.25 | 2324024.0 |
| 2014-12-08 10:00:00 | MSFT | Stock | 48.25 | 48.34 | 48.14 | 48.246 | 1285248.0 |
| 2014-12-08 10:30:00 | MSFT | Stock | 48.24 | 48.27 | 48.15 | 48.23 | 918979.0 |
| 2014-12-08 11:00:00 | MSFT | Stock | 48.231 | 48.24 | 48.1 | 48.12 | 1214874.0 |
| 2014-12-08 11:30:00 | MSFT | Stock | 48.12 | 48.27 | 48.09 | 48.27 | 1032061.0 |
| 2014-12-08 12:00:00 | MSFT | Stock | 48.27 | 48.27 | 47.88 | 47.947 | 1339789.0 |
| 2014-12-08 12:30:00 | MSFT | Stock | 47.94 | 47.99 | 47.81 | 47.875 | 1493175.0 |
| 2014-12-08 13:00:00 | MSFT | Stock | 47.88 | 47.91 | 47.63 | 47.68 | 1678123.0 |
| 2014-12-08 13:30:00 | MSFT | Stock | 47.68 | 47.68 | 47.51 | 47.546 | 1297538.0 |
| 2014-12-08 14:00:00 | MSFT | Stock | 47.545 | 47.72 | 47.445 | 47.716 | 1211356.0 |
| 2014-12-08 14:30:00 | MSFT | Stock | 47.715 | 47.755 | 47.665 | 47.675 | 1121299.0 |
| 2014-12-08 15:00:00 | MSFT | Stock | 47.675 | 47.71 | 47.57 | 47.66 | 1569193.0 |
| 2014-12-08 15:30:00 | MSFT | Stock | 47.669 | 47.79 | 47.63 | 47.69 | 4621966.0 |
| 2014-12-08 16:00:00 | MSFT | Stock | 47.695 | 47.865 | 47.644 | 47.72 | 4387567.0 |
> showing 50 of 84,935 rows — these rows as CSV