PREVIEW / stock_30min / 2015-11-03
file: by_date/stock_30min/2015/2015-11-03.parquet size: 1.6 MB rows: 82,366 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-11-03 04:00:00 | AAPL | Stock | 30.25 | 30.25 | 30.17 | 30.17 | 2076.0 |
| 2015-11-03 04:30:00 | AAPL | Stock | 30.2125 | 30.235 | 30.2125 | 30.235 | 4260.0 |
| 2015-11-03 05:00:00 | AAPL | Stock | 30.225 | 30.225 | 30.2125 | 30.2125 | 1200.0 |
| 2015-11-03 05:30:00 | AAPL | Stock | 30.225 | 30.225 | 30.215 | 30.215 | 15832.0 |
| 2015-11-03 06:00:00 | AAPL | Stock | 30.205 | 30.21 | 30.15 | 30.1625 | 16932.0 |
| 2015-11-03 06:30:00 | AAPL | Stock | 30.1675 | 30.185 | 30.1625 | 30.1625 | 22116.0 |
| 2015-11-03 07:00:00 | AAPL | Stock | 30.175 | 30.175 | 30.0825 | 30.1475 | 75772.0 |
| 2015-11-03 07:30:00 | AAPL | Stock | 30.145 | 30.185 | 30.1425 | 30.1675 | 83396.0 |
| 2015-11-03 08:00:00 | AAPL | Stock | 30.175 | 30.2 | 30.1225 | 30.1525 | 376348.0 |
| 2015-11-03 08:30:00 | AAPL | Stock | 30.1625 | 30.1975 | 30.1375 | 30.16 | 237960.0 |
| 2015-11-03 09:00:00 | AAPL | Stock | 30.16 | 30.23 | 30.16 | 30.2 | 284092.0 |
| 2015-11-03 09:30:00 | AAPL | Stock | 30.1975 | 30.4625 | 30.175 | 30.39 | 23235752.0 |
| 2015-11-03 10:00:00 | AAPL | Stock | 30.3888 | 30.6075 | 30.3875 | 30.57 | 20451496.0 |
| 2015-11-03 10:30:00 | AAPL | Stock | 30.5675 | 30.7025 | 30.56 | 30.6325 | 15171020.0 |
| 2015-11-03 11:00:00 | AAPL | Stock | 30.6342 | 30.6575 | 30.5525 | 30.5675 | 9812484.0 |
| 2015-11-03 11:30:00 | AAPL | Stock | 30.57 | 30.655 | 30.55 | 30.62 | 10617956.0 |
| 2015-11-03 12:00:00 | AAPL | Stock | 30.6175 | 30.6688 | 30.596 | 30.6485 | 6229492.0 |
| 2015-11-03 12:30:00 | AAPL | Stock | 30.6475 | 30.6575 | 30.6125 | 30.6375 | 4692608.0 |
| 2015-11-03 13:00:00 | AAPL | Stock | 30.6388 | 30.6925 | 30.63 | 30.6802 | 4869096.0 |
| 2015-11-03 13:30:00 | AAPL | Stock | 30.68 | 30.795 | 30.6708 | 30.792 | 11421632.0 |
| 2015-11-03 14:00:00 | AAPL | Stock | 30.792 | 30.8725 | 30.7825 | 30.83 | 11112140.0 |
| 2015-11-03 14:30:00 | AAPL | Stock | 30.83 | 30.87 | 30.775 | 30.835 | 10173912.0 |
| 2015-11-03 15:00:00 | AAPL | Stock | 30.8325 | 30.8475 | 30.7175 | 30.7175 | 11616848.0 |
| 2015-11-03 15:30:00 | AAPL | Stock | 30.718 | 30.7425 | 30.605 | 30.6475 | 18301668.0 |
| 2015-11-03 16:00:00 | AAPL | Stock | 30.6425 | 30.65 | 30.585 | 30.6325 | 10948252.0 |
| 2015-11-03 16:30:00 | AAPL | Stock | 30.6275 | 30.6275 | 30.6025 | 30.6075 | 116360.0 |
| 2015-11-03 17:00:00 | AAPL | Stock | 30.62 | 30.62 | 30.6125 | 30.615 | 25172.0 |
| 2015-11-03 17:30:00 | AAPL | Stock | 30.615 | 30.625 | 30.61 | 30.625 | 27188.0 |
| 2015-11-03 18:00:00 | AAPL | Stock | 30.625 | 30.6375 | 30.6075 | 30.61 | 27332.0 |
| 2015-11-03 18:30:00 | AAPL | Stock | 30.6175 | 30.62 | 30.605 | 30.62 | 15784.0 |
| 2015-11-03 19:00:00 | AAPL | Stock | 30.615 | 30.6175 | 30.6025 | 30.6175 | 26232.0 |
| 2015-11-03 19:30:00 | AAPL | Stock | 30.6025 | 30.63 | 30.6025 | 30.63 | 52972.0 |
| 2015-11-03 04:00:00 | MSFT | Stock | 52.96 | 52.96 | 52.95 | 52.95 | 1000.0 |
| 2015-11-03 07:00:00 | MSFT | Stock | 53.16 | 53.2 | 53.16 | 53.2 | 1000.0 |
| 2015-11-03 07:30:00 | MSFT | Stock | 53.16 | 53.16 | 53.16 | 53.16 | 1400.0 |
| 2015-11-03 08:00:00 | MSFT | Stock | 53.13 | 53.13 | 53.07 | 53.1 | 6800.0 |
| 2015-11-03 09:00:00 | MSFT | Stock | 53.16 | 53.16 | 52.91 | 52.91 | 43453.0 |
| 2015-11-03 09:30:00 | MSFT | Stock | 52.93 | 53.34 | 52.9 | 53.15 | 3365772.0 |
| 2015-11-03 10:00:00 | MSFT | Stock | 53.145 | 53.55 | 53.112 | 53.55 | 2474273.0 |
| 2015-11-03 10:30:00 | MSFT | Stock | 53.55 | 53.63 | 53.45 | 53.57 | 2984765.0 |
| 2015-11-03 11:00:00 | MSFT | Stock | 53.57 | 53.78 | 53.5 | 53.735 | 1974242.0 |
| 2015-11-03 11:30:00 | MSFT | Stock | 53.73 | 53.93 | 53.71 | 53.9 | 1638711.0 |
| 2015-11-03 12:00:00 | MSFT | Stock | 53.89 | 54.0 | 53.885 | 53.975 | 1848673.0 |
| 2015-11-03 12:30:00 | MSFT | Stock | 53.975 | 54.04 | 53.88 | 54.0 | 1687298.0 |
| 2015-11-03 13:00:00 | MSFT | Stock | 54.0 | 54.19 | 53.98 | 54.19 | 2255076.0 |
| 2015-11-03 13:30:00 | MSFT | Stock | 54.185 | 54.24 | 53.99 | 54.165 | 2149605.0 |
| 2015-11-03 14:00:00 | MSFT | Stock | 54.165 | 54.33 | 53.921 | 54.3 | 3108809.0 |
| 2015-11-03 14:30:00 | MSFT | Stock | 54.302 | 54.307 | 54.155 | 54.26 | 2667458.0 |
| 2015-11-03 15:00:00 | MSFT | Stock | 54.25 | 54.39 | 53.94 | 54.26 | 2528916.0 |
| 2015-11-03 15:30:00 | MSFT | Stock | 54.255 | 54.28 | 54.06 | 54.16 | 3694716.0 |
> showing 50 of 82,366 rows — these rows as CSV