PREVIEW / stock_30min / 2015-07-30
file: by_date/stock_30min/2015/2015-07-30.parquet size: 1.6 MB rows: 81,218 symbols: 3,469
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-07-30 04:00:00 | AAPL | Stock | 30.625 | 30.6425 | 30.625 | 30.64 | 2196.0 |
| 2015-07-30 04:30:00 | AAPL | Stock | 30.665 | 30.675 | 30.6 | 30.6425 | 9348.0 |
| 2015-07-30 05:00:00 | AAPL | Stock | 30.6125 | 30.6425 | 30.6125 | 30.6425 | 1200.0 |
| 2015-07-30 05:30:00 | AAPL | Stock | 30.6425 | 30.685 | 30.6425 | 30.685 | 10524.0 |
| 2015-07-30 06:00:00 | AAPL | Stock | 30.7 | 30.74 | 30.6925 | 30.7375 | 10400.0 |
| 2015-07-30 06:30:00 | AAPL | Stock | 30.7 | 30.72 | 30.7 | 30.7 | 2000.0 |
| 2015-07-30 07:00:00 | AAPL | Stock | 30.7 | 30.7 | 30.6125 | 30.65 | 61904.0 |
| 2015-07-30 07:30:00 | AAPL | Stock | 30.67 | 30.695 | 30.65 | 30.6875 | 15352.0 |
| 2015-07-30 08:00:00 | AAPL | Stock | 30.685 | 30.7 | 30.625 | 30.6282 | 108208.0 |
| 2015-07-30 08:30:00 | AAPL | Stock | 30.6375 | 30.66 | 30.63 | 30.6375 | 161024.0 |
| 2015-07-30 09:00:00 | AAPL | Stock | 30.635 | 30.645 | 30.55 | 30.58 | 709000.0 |
| 2015-07-30 09:30:00 | AAPL | Stock | 30.57 | 30.64 | 30.4275 | 30.465 | 29260696.0 |
| 2015-07-30 10:00:00 | AAPL | Stock | 30.465 | 30.5475 | 30.435 | 30.5188 | 12489108.0 |
| 2015-07-30 10:30:00 | AAPL | Stock | 30.52 | 30.6075 | 30.485 | 30.5188 | 9348108.0 |
| 2015-07-30 11:00:00 | AAPL | Stock | 30.5198 | 30.5425 | 30.4425 | 30.5325 | 8859168.0 |
| 2015-07-30 11:30:00 | AAPL | Stock | 30.5325 | 30.5825 | 30.5275 | 30.565 | 5808672.0 |
| 2015-07-30 12:00:00 | AAPL | Stock | 30.565 | 30.6 | 30.54 | 30.5662 | 4868908.0 |
| 2015-07-30 12:30:00 | AAPL | Stock | 30.565 | 30.5788 | 30.5338 | 30.5775 | 3647264.0 |
| 2015-07-30 13:00:00 | AAPL | Stock | 30.5762 | 30.595 | 30.5375 | 30.56 | 5042656.0 |
| 2015-07-30 13:30:00 | AAPL | Stock | 30.5625 | 30.57 | 30.4825 | 30.492 | 5953784.0 |
| 2015-07-30 14:00:00 | AAPL | Stock | 30.4912 | 30.535 | 30.465 | 30.52 | 4850880.0 |
| 2015-07-30 14:30:00 | AAPL | Stock | 30.519 | 30.57 | 30.4962 | 30.535 | 4795932.0 |
| 2015-07-30 15:00:00 | AAPL | Stock | 30.535 | 30.6 | 30.5325 | 30.595 | 5859212.0 |
| 2015-07-30 15:30:00 | AAPL | Stock | 30.595 | 30.6425 | 30.58 | 30.5925 | 12506304.0 |
| 2015-07-30 16:00:00 | AAPL | Stock | 30.595 | 30.6475 | 30.5 | 30.6425 | 3795836.0 |
| 2015-07-30 16:30:00 | AAPL | Stock | 30.635 | 30.7125 | 30.6325 | 30.7125 | 458880.0 |
| 2015-07-30 17:00:00 | AAPL | Stock | 30.72 | 30.7425 | 30.6525 | 30.6525 | 350952.0 |
| 2015-07-30 17:30:00 | AAPL | Stock | 30.655 | 30.6975 | 30.5925 | 30.6375 | 206028.0 |
| 2015-07-30 18:00:00 | AAPL | Stock | 30.6375 | 30.6375 | 30.5175 | 30.5425 | 316748.0 |
| 2015-07-30 18:30:00 | AAPL | Stock | 30.55 | 30.55 | 30.5075 | 30.5375 | 152472.0 |
| 2015-07-30 19:00:00 | AAPL | Stock | 30.5425 | 30.6 | 30.5075 | 30.5692 | 146312.0 |
| 2015-07-30 19:30:00 | AAPL | Stock | 30.565 | 30.5775 | 30.55 | 30.5775 | 21252.0 |
| 2015-07-30 05:00:00 | MSFT | Stock | 46.25 | 46.25 | 46.25 | 46.25 | 143.0 |
| 2015-07-30 08:00:00 | MSFT | Stock | 46.36 | 46.36 | 46.23 | 46.26 | 10576.0 |
| 2015-07-30 08:30:00 | MSFT | Stock | 46.26 | 46.26 | 46.17 | 46.17 | 15908.0 |
| 2015-07-30 09:00:00 | MSFT | Stock | 46.21 | 46.27 | 46.15 | 46.27 | 8002.0 |
| 2015-07-30 09:30:00 | MSFT | Stock | 46.26 | 46.37 | 45.941 | 45.97 | 3758041.0 |
| 2015-07-30 10:00:00 | MSFT | Stock | 45.97 | 46.35 | 45.93 | 46.284 | 2274621.0 |
| 2015-07-30 10:30:00 | MSFT | Stock | 46.284 | 46.37 | 46.17 | 46.25 | 2189500.0 |
| 2015-07-30 11:00:00 | MSFT | Stock | 46.25 | 46.58 | 46.194 | 46.51 | 2328483.0 |
| 2015-07-30 11:30:00 | MSFT | Stock | 46.5 | 46.77 | 46.485 | 46.744 | 2520556.0 |
| 2015-07-30 12:00:00 | MSFT | Stock | 46.75 | 46.91 | 46.67 | 46.9 | 2025006.0 |
| 2015-07-30 12:30:00 | MSFT | Stock | 46.9 | 47.24 | 46.83 | 47.21 | 3168233.0 |
| 2015-07-30 13:00:00 | MSFT | Stock | 47.22 | 47.4 | 47.17 | 47.27 | 3585870.0 |
| 2015-07-30 13:30:00 | MSFT | Stock | 47.28 | 47.29 | 47.08 | 47.08 | 2598285.0 |
| 2015-07-30 14:00:00 | MSFT | Stock | 47.08 | 47.18 | 46.98 | 47.02 | 2033175.0 |
| 2015-07-30 14:30:00 | MSFT | Stock | 47.02 | 47.16 | 47.01 | 47.12 | 1476638.0 |
| 2015-07-30 15:00:00 | MSFT | Stock | 47.11 | 47.16 | 46.93 | 46.985 | 2372074.0 |
| 2015-07-30 15:30:00 | MSFT | Stock | 46.985 | 47.03 | 46.89 | 46.89 | 5303500.0 |
| 2015-07-30 16:00:00 | MSFT | Stock | 46.89 | 47.2 | 46.2 | 47.0 | 2246746.0 |
> showing 50 of 81,218 rows — these rows as CSV