PREVIEW / stock_30min / 2016-12-13
file: by_date/stock_30min/2016/2016-12-13.parquet size: 1.6 MB rows: 83,132 symbols: 3,152
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 |
|---|---|---|---|---|---|---|---|
| 2016-12-13 04:00:00 | AAPL | Stock | 28.2825 | 28.2825 | 28.2825 | 28.2825 | 1200.0 |
| 2016-12-13 04:30:00 | AAPL | Stock | 28.3325 | 28.3325 | 28.3325 | 28.3325 | 840.0 |
| 2016-12-13 05:30:00 | AAPL | Stock | 28.355 | 28.4175 | 28.355 | 28.4175 | 5160.0 |
| 2016-12-13 06:30:00 | AAPL | Stock | 28.3775 | 28.3875 | 28.3775 | 28.3775 | 5680.0 |
| 2016-12-13 07:00:00 | AAPL | Stock | 28.3625 | 28.43 | 28.3625 | 28.43 | 16996.0 |
| 2016-12-13 07:30:00 | AAPL | Stock | 28.43 | 28.4375 | 28.41 | 28.41 | 10244.0 |
| 2016-12-13 08:00:00 | AAPL | Stock | 28.435 | 28.4375 | 28.325 | 28.42 | 148048.0 |
| 2016-12-13 08:30:00 | AAPL | Stock | 28.4 | 28.4425 | 28.38 | 28.4125 | 78944.0 |
| 2016-12-13 09:00:00 | AAPL | Stock | 28.42 | 28.49 | 28.42 | 28.4475 | 280476.0 |
| 2016-12-13 09:30:00 | AAPL | Stock | 28.445 | 28.8075 | 28.4375 | 28.7732 | 26461172.0 |
| 2016-12-13 10:00:00 | AAPL | Stock | 28.7742 | 28.8425 | 28.71 | 28.7688 | 17078636.0 |
| 2016-12-13 10:30:00 | AAPL | Stock | 28.7675 | 28.825 | 28.705 | 28.74 | 10623880.0 |
| 2016-12-13 11:00:00 | AAPL | Stock | 28.7412 | 28.86 | 28.7225 | 28.86 | 9321876.0 |
| 2016-12-13 11:30:00 | AAPL | Stock | 28.8575 | 28.9625 | 28.84 | 28.9475 | 9902216.0 |
| 2016-12-13 12:00:00 | AAPL | Stock | 28.9475 | 28.9488 | 28.8775 | 28.8895 | 7077468.0 |
| 2016-12-13 12:30:00 | AAPL | Stock | 28.89 | 28.925 | 28.8575 | 28.9012 | 5760260.0 |
| 2016-12-13 13:00:00 | AAPL | Stock | 28.9025 | 28.9675 | 28.8775 | 28.9632 | 5763284.0 |
| 2016-12-13 13:30:00 | AAPL | Stock | 28.9638 | 28.98 | 28.8675 | 28.9138 | 6301992.0 |
| 2016-12-13 14:00:00 | AAPL | Stock | 28.9138 | 28.95 | 28.865 | 28.8838 | 6656252.0 |
| 2016-12-13 14:30:00 | AAPL | Stock | 28.8845 | 28.9225 | 28.85 | 28.875 | 7670148.0 |
| 2016-12-13 15:00:00 | AAPL | Stock | 28.8775 | 28.955 | 28.8725 | 28.9275 | 8687136.0 |
| 2016-12-13 15:30:00 | AAPL | Stock | 28.9275 | 28.95 | 28.765 | 28.7975 | 17061076.0 |
| 2016-12-13 16:00:00 | AAPL | Stock | 28.7975 | 28.8125 | 28.7675 | 28.8075 | 12496400.0 |
| 2016-12-13 16:30:00 | AAPL | Stock | 28.8 | 28.8125 | 28.7975 | 28.8125 | 33560.0 |
| 2016-12-13 17:00:00 | AAPL | Stock | 28.8125 | 28.815 | 28.7975 | 28.8025 | 31256.0 |
| 2016-12-13 17:30:00 | AAPL | Stock | 28.8125 | 28.815 | 28.7975 | 28.8 | 11868.0 |
| 2016-12-13 18:00:00 | AAPL | Stock | 28.8 | 28.825 | 28.8 | 28.82 | 25628.0 |
| 2016-12-13 18:30:00 | AAPL | Stock | 28.8225 | 28.825 | 28.82 | 28.8225 | 9080.0 |
| 2016-12-13 19:00:00 | AAPL | Stock | 28.8225 | 28.825 | 28.82 | 28.82 | 30980.0 |
| 2016-12-13 19:30:00 | AAPL | Stock | 28.8 | 28.8275 | 28.8 | 28.82 | 16764.0 |
| 2016-12-13 07:00:00 | MSFT | Stock | 62.2 | 62.2 | 62.2 | 62.2 | 2035.0 |
| 2016-12-13 08:00:00 | MSFT | Stock | 62.3 | 62.41 | 62.25 | 62.25 | 8549.0 |
| 2016-12-13 08:30:00 | MSFT | Stock | 62.29 | 62.3 | 62.29 | 62.3 | 3437.0 |
| 2016-12-13 09:00:00 | MSFT | Stock | 62.32 | 62.56 | 62.27 | 62.56 | 13375.0 |
| 2016-12-13 09:30:00 | MSFT | Stock | 62.5 | 63.0 | 62.24 | 62.88 | 4260782.0 |
| 2016-12-13 10:00:00 | MSFT | Stock | 62.875 | 63.23 | 62.71 | 63.185 | 2584971.0 |
| 2016-12-13 10:30:00 | MSFT | Stock | 63.18 | 63.29 | 62.96 | 63.08 | 2525804.0 |
| 2016-12-13 11:00:00 | MSFT | Stock | 63.086 | 63.18 | 62.86 | 63.15 | 1799865.0 |
| 2016-12-13 11:30:00 | MSFT | Stock | 63.144 | 63.33 | 63.12 | 63.295 | 1544351.0 |
| 2016-12-13 12:00:00 | MSFT | Stock | 63.3 | 63.42 | 63.13 | 63.14 | 1902028.0 |
| 2016-12-13 12:30:00 | MSFT | Stock | 63.14 | 63.285 | 63.1 | 63.1 | 1831794.0 |
| 2016-12-13 13:00:00 | MSFT | Stock | 63.09 | 63.4 | 63.08 | 63.39 | 1417267.0 |
| 2016-12-13 13:30:00 | MSFT | Stock | 63.38 | 63.4 | 63.19 | 63.26 | 1156860.0 |
| 2016-12-13 14:00:00 | MSFT | Stock | 63.26 | 63.28 | 62.97 | 62.994 | 1410039.0 |
| 2016-12-13 14:30:00 | MSFT | Stock | 62.99 | 63.175 | 62.98 | 63.13 | 1782265.0 |
| 2016-12-13 15:00:00 | MSFT | Stock | 63.13 | 63.24 | 63.11 | 63.19 | 1337065.0 |
| 2016-12-13 15:30:00 | MSFT | Stock | 63.195 | 63.255 | 62.91 | 62.98 | 4535811.0 |
| 2016-12-13 16:00:00 | MSFT | Stock | 62.98 | 63.263 | 62.91 | 62.97 | 3462483.0 |
| 2016-12-13 16:30:00 | MSFT | Stock | 62.98 | 63.08 | 62.98 | 63.03 | 2889.0 |
| 2016-12-13 17:00:00 | MSFT | Stock | 63.08 | 63.08 | 63.08 | 63.08 | 9621.0 |
> showing 50 of 83,132 rows — these rows as CSV