PREVIEW / stock_30min / 2015-12-22
file: by_date/stock_30min/2015/2015-12-22.parquet size: 1.6 MB rows: 82,819 symbols: 3,416
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-22 04:00:00 | AAPL | Stock | 26.925 | 26.925 | 26.9 | 26.9175 | 5136.0 |
| 2015-12-22 04:30:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.7625 | 26.7625 | 12324.0 |
| 2015-12-22 05:00:00 | AAPL | Stock | 26.7625 | 26.8 | 26.7625 | 26.8 | 17896.0 |
| 2015-12-22 05:30:00 | AAPL | Stock | 26.7625 | 26.8525 | 26.7625 | 26.8525 | 24984.0 |
| 2015-12-22 06:00:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.815 | 26.815 | 8936.0 |
| 2015-12-22 06:30:00 | AAPL | Stock | 26.8375 | 26.8475 | 26.7725 | 26.7725 | 9600.0 |
| 2015-12-22 07:00:00 | AAPL | Stock | 26.81 | 26.81 | 26.7625 | 26.7875 | 30356.0 |
| 2015-12-22 07:30:00 | AAPL | Stock | 26.76 | 26.805 | 26.75 | 26.79 | 38432.0 |
| 2015-12-22 08:00:00 | AAPL | Stock | 26.7875 | 26.7975 | 26.705 | 26.725 | 160324.0 |
| 2015-12-22 08:30:00 | AAPL | Stock | 26.725 | 26.75 | 26.7125 | 26.75 | 133976.0 |
| 2015-12-22 09:00:00 | AAPL | Stock | 26.7575 | 26.86 | 26.75 | 26.845 | 533072.0 |
| 2015-12-22 09:30:00 | AAPL | Stock | 26.85 | 26.87 | 26.6525 | 26.665 | 16350796.0 |
| 2015-12-22 10:00:00 | AAPL | Stock | 26.665 | 26.745 | 26.6128 | 26.734 | 11301676.0 |
| 2015-12-22 10:30:00 | AAPL | Stock | 26.7348 | 26.8075 | 26.62 | 26.63 | 10075960.0 |
| 2015-12-22 11:00:00 | AAPL | Stock | 26.6295 | 26.7425 | 26.6295 | 26.6792 | 6266972.0 |
| 2015-12-22 11:30:00 | AAPL | Stock | 26.6792 | 26.84 | 26.6725 | 26.81 | 9541664.0 |
| 2015-12-22 12:00:00 | AAPL | Stock | 26.81 | 26.845 | 26.74 | 26.8325 | 6504372.0 |
| 2015-12-22 12:30:00 | AAPL | Stock | 26.8325 | 26.93 | 26.8245 | 26.845 | 9288060.0 |
| 2015-12-22 13:00:00 | AAPL | Stock | 26.845 | 26.8575 | 26.7675 | 26.81 | 5295064.0 |
| 2015-12-22 13:30:00 | AAPL | Stock | 26.8075 | 26.8675 | 26.7525 | 26.8615 | 5261408.0 |
| 2015-12-22 14:00:00 | AAPL | Stock | 26.8625 | 26.8675 | 26.7975 | 26.8125 | 5238628.0 |
| 2015-12-22 14:30:00 | AAPL | Stock | 26.8125 | 26.865 | 26.8025 | 26.855 | 4700400.0 |
| 2015-12-22 15:00:00 | AAPL | Stock | 26.855 | 26.875 | 26.82 | 26.83 | 7774792.0 |
| 2015-12-22 15:30:00 | AAPL | Stock | 26.83 | 26.8475 | 26.755 | 26.8025 | 13376108.0 |
| 2015-12-22 16:00:00 | AAPL | Stock | 26.8075 | 26.8475 | 26.79 | 26.8125 | 9099816.0 |
| 2015-12-22 16:30:00 | AAPL | Stock | 26.8125 | 26.8425 | 26.8075 | 26.8225 | 72012.0 |
| 2015-12-22 17:00:00 | AAPL | Stock | 26.8125 | 26.825 | 26.8125 | 26.82 | 56800.0 |
| 2015-12-22 17:30:00 | AAPL | Stock | 26.8175 | 26.8175 | 26.81 | 26.81 | 11600.0 |
| 2015-12-22 18:00:00 | AAPL | Stock | 26.8325 | 26.8475 | 26.8075 | 26.8475 | 22212.0 |
| 2015-12-22 18:30:00 | AAPL | Stock | 26.8325 | 26.845 | 26.82 | 26.83 | 19112.0 |
| 2015-12-22 19:00:00 | AAPL | Stock | 26.83 | 26.83 | 26.825 | 26.825 | 65652.0 |
| 2015-12-22 19:30:00 | AAPL | Stock | 26.83 | 26.83 | 26.8075 | 26.83 | 10892.0 |
| 2015-12-22 07:30:00 | MSFT | Stock | 54.85 | 55.09 | 54.85 | 55.09 | 3398.0 |
| 2015-12-22 08:00:00 | MSFT | Stock | 55.0 | 55.05 | 54.84 | 54.99 | 4308.0 |
| 2015-12-22 08:30:00 | MSFT | Stock | 54.95 | 55.0 | 54.92 | 54.92 | 1700.0 |
| 2015-12-22 09:00:00 | MSFT | Stock | 54.97 | 55.12 | 54.78 | 54.87 | 76676.0 |
| 2015-12-22 09:30:00 | MSFT | Stock | 54.92 | 55.0 | 54.5 | 54.85 | 3372462.0 |
| 2015-12-22 10:00:00 | MSFT | Stock | 54.85 | 55.14 | 54.71 | 55.09 | 2517642.0 |
| 2015-12-22 10:30:00 | MSFT | Stock | 55.095 | 55.1 | 54.76 | 54.83 | 1963488.0 |
| 2015-12-22 11:00:00 | MSFT | Stock | 54.835 | 54.98 | 54.77 | 54.946 | 1843117.0 |
| 2015-12-22 11:30:00 | MSFT | Stock | 54.95 | 55.2 | 54.91 | 55.055 | 1611115.0 |
| 2015-12-22 12:00:00 | MSFT | Stock | 55.06 | 55.095 | 54.96 | 55.045 | 1054853.0 |
| 2015-12-22 12:30:00 | MSFT | Stock | 55.05 | 55.18 | 55.025 | 55.1 | 1443987.0 |
| 2015-12-22 13:00:00 | MSFT | Stock | 55.1 | 55.125 | 54.89 | 55.01 | 1710593.0 |
| 2015-12-22 13:30:00 | MSFT | Stock | 55.01 | 55.25 | 54.95 | 55.21 | 1169380.0 |
| 2015-12-22 14:00:00 | MSFT | Stock | 55.21 | 55.24 | 55.095 | 55.158 | 1088107.0 |
| 2015-12-22 14:30:00 | MSFT | Stock | 55.15 | 55.247 | 55.09 | 55.235 | 1123209.0 |
| 2015-12-22 15:00:00 | MSFT | Stock | 55.24 | 55.48 | 55.18 | 55.435 | 2019456.0 |
| 2015-12-22 15:30:00 | MSFT | Stock | 55.43 | 55.445 | 55.23 | 55.35 | 3479529.0 |
| 2015-12-22 16:00:00 | MSFT | Stock | 55.35 | 55.45 | 55.35 | 55.35 | 2206273.0 |
> showing 50 of 82,819 rows — these rows as CSV