PREVIEW / stock_30min / 2015-05-11
file: by_date/stock_30min/2015/2015-05-11.parquet size: 1.6 MB rows: 82,458 symbols: 3,512
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-05-11 04:00:00 | AAPL | Stock | 31.885 | 31.9575 | 31.885 | 31.9575 | 4900.0 |
| 2015-05-11 04:30:00 | AAPL | Stock | 31.9225 | 31.9225 | 31.89 | 31.89 | 6000.0 |
| 2015-05-11 05:00:00 | AAPL | Stock | 31.895 | 31.895 | 31.895 | 31.895 | 400.0 |
| 2015-05-11 05:30:00 | AAPL | Stock | 31.8725 | 31.915 | 31.8725 | 31.8875 | 2284.0 |
| 2015-05-11 06:00:00 | AAPL | Stock | 31.8875 | 31.8875 | 31.87 | 31.8875 | 20340.0 |
| 2015-05-11 06:30:00 | AAPL | Stock | 31.88 | 31.8875 | 31.85 | 31.8875 | 10980.0 |
| 2015-05-11 07:00:00 | AAPL | Stock | 31.875 | 31.875 | 31.8375 | 31.845 | 21364.0 |
| 2015-05-11 07:30:00 | AAPL | Stock | 31.83 | 31.875 | 31.8175 | 31.85 | 45532.0 |
| 2015-05-11 08:00:00 | AAPL | Stock | 31.85 | 31.9 | 31.82 | 31.8498 | 345536.0 |
| 2015-05-11 08:30:00 | AAPL | Stock | 31.835 | 31.8425 | 31.815 | 31.8325 | 131140.0 |
| 2015-05-11 09:00:00 | AAPL | Stock | 31.835 | 31.86 | 31.7625 | 31.85 | 277720.0 |
| 2015-05-11 09:30:00 | AAPL | Stock | 31.8475 | 31.89 | 31.47 | 31.552 | 31129680.0 |
| 2015-05-11 10:00:00 | AAPL | Stock | 31.55 | 31.6325 | 31.4525 | 31.4575 | 15078532.0 |
| 2015-05-11 10:30:00 | AAPL | Stock | 31.4578 | 31.5375 | 31.4062 | 31.5338 | 14141664.0 |
| 2015-05-11 11:00:00 | AAPL | Stock | 31.535 | 31.5975 | 31.455 | 31.525 | 10542216.0 |
| 2015-05-11 11:30:00 | AAPL | Stock | 31.525 | 31.6825 | 31.525 | 31.68 | 7603208.0 |
| 2015-05-11 12:00:00 | AAPL | Stock | 31.68 | 31.6925 | 31.5625 | 31.6325 | 7081872.0 |
| 2015-05-11 12:30:00 | AAPL | Stock | 31.635 | 31.6425 | 31.581 | 31.6225 | 5043624.0 |
| 2015-05-11 13:00:00 | AAPL | Stock | 31.62 | 31.7 | 31.6112 | 31.6975 | 4991676.0 |
| 2015-05-11 13:30:00 | AAPL | Stock | 31.7 | 31.74 | 31.6575 | 31.6625 | 6493152.0 |
| 2015-05-11 14:00:00 | AAPL | Stock | 31.66 | 31.695 | 31.6 | 31.685 | 5448292.0 |
| 2015-05-11 14:30:00 | AAPL | Stock | 31.685 | 31.72 | 31.6175 | 31.6275 | 6196260.0 |
| 2015-05-11 15:00:00 | AAPL | Stock | 31.6275 | 31.6675 | 31.545 | 31.6125 | 7555984.0 |
| 2015-05-11 15:30:00 | AAPL | Stock | 31.6125 | 31.6575 | 31.5775 | 31.58 | 10658480.0 |
| 2015-05-11 16:00:00 | AAPL | Stock | 31.58 | 31.6478 | 31.55 | 31.58 | 14496144.0 |
| 2015-05-11 16:30:00 | AAPL | Stock | 31.58 | 31.585 | 31.5575 | 31.5575 | 176096.0 |
| 2015-05-11 17:00:00 | AAPL | Stock | 31.555 | 31.6125 | 31.555 | 31.605 | 128280.0 |
| 2015-05-11 17:30:00 | AAPL | Stock | 31.605 | 31.6075 | 31.58 | 31.595 | 44648.0 |
| 2015-05-11 18:00:00 | AAPL | Stock | 31.5875 | 31.6 | 31.585 | 31.6 | 26736.0 |
| 2015-05-11 18:30:00 | AAPL | Stock | 31.6 | 31.6075 | 31.595 | 31.5975 | 33628.0 |
| 2015-05-11 19:00:00 | AAPL | Stock | 31.6075 | 31.6075 | 31.5725 | 31.5725 | 21280.0 |
| 2015-05-11 19:30:00 | AAPL | Stock | 31.585 | 31.595 | 31.5475 | 31.5848 | 112260.0 |
| 2015-05-11 07:00:00 | MSFT | Stock | 47.7 | 47.7 | 47.7 | 47.7 | 1000.0 |
| 2015-05-11 07:30:00 | MSFT | Stock | 47.7 | 47.7 | 47.7 | 47.7 | 2000.0 |
| 2015-05-11 08:00:00 | MSFT | Stock | 47.75 | 47.75 | 47.68 | 47.7 | 1400.0 |
| 2015-05-11 08:30:00 | MSFT | Stock | 47.66 | 47.7 | 47.61 | 47.61 | 1800.0 |
| 2015-05-11 09:00:00 | MSFT | Stock | 47.61 | 47.68 | 47.5 | 47.55 | 45881.0 |
| 2015-05-11 09:30:00 | MSFT | Stock | 47.7 | 47.91 | 47.52 | 47.67 | 3336441.0 |
| 2015-05-11 10:00:00 | MSFT | Stock | 47.66 | 47.85 | 47.66 | 47.78 | 1487167.0 |
| 2015-05-11 10:30:00 | MSFT | Stock | 47.78 | 47.79 | 47.6 | 47.625 | 1433559.0 |
| 2015-05-11 11:00:00 | MSFT | Stock | 47.62 | 47.72 | 47.52 | 47.61 | 1055409.0 |
| 2015-05-11 11:30:00 | MSFT | Stock | 47.61 | 47.75 | 47.52 | 47.73 | 983395.0 |
| 2015-05-11 12:00:00 | MSFT | Stock | 47.73 | 47.735 | 47.55 | 47.654 | 1302076.0 |
| 2015-05-11 12:30:00 | MSFT | Stock | 47.655 | 47.665 | 47.525 | 47.633 | 885944.0 |
| 2015-05-11 13:00:00 | MSFT | Stock | 47.63 | 47.71 | 47.615 | 47.66 | 836901.0 |
| 2015-05-11 13:30:00 | MSFT | Stock | 47.66 | 47.68 | 47.58 | 47.587 | 633623.0 |
| 2015-05-11 14:00:00 | MSFT | Stock | 47.58 | 47.64 | 47.48 | 47.57 | 947868.0 |
| 2015-05-11 14:30:00 | MSFT | Stock | 47.57 | 47.6 | 47.49 | 47.525 | 966977.0 |
| 2015-05-11 15:00:00 | MSFT | Stock | 47.515 | 47.52 | 47.4 | 47.48 | 1404147.0 |
| 2015-05-11 15:30:00 | MSFT | Stock | 47.49 | 47.5 | 47.37 | 47.37 | 2070940.0 |
> showing 50 of 82,458 rows — these rows as CSV