PREVIEW / stock_30min / 2014-09-24
file: by_date/stock_30min/2014/2014-09-24.parquet size: 1.6 MB rows: 84,275 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-24 04:00:00 | AAPL | Stock | 25.595 | 25.595 | 25.5625 | 25.5625 | 4000.0 |
| 2014-09-24 04:30:00 | AAPL | Stock | 25.585 | 25.6175 | 25.57 | 25.6175 | 2328.0 |
| 2014-09-24 05:00:00 | AAPL | Stock | 25.575 | 25.605 | 25.575 | 25.605 | 2880.0 |
| 2014-09-24 05:30:00 | AAPL | Stock | 25.605 | 25.6125 | 25.605 | 25.605 | 4000.0 |
| 2014-09-24 06:00:00 | AAPL | Stock | 25.605 | 25.63 | 25.575 | 25.5875 | 12984.0 |
| 2014-09-24 06:30:00 | AAPL | Stock | 25.5875 | 25.635 | 25.585 | 25.5875 | 53184.0 |
| 2014-09-24 07:00:00 | AAPL | Stock | 25.6075 | 25.6075 | 25.475 | 25.4825 | 387000.0 |
| 2014-09-24 07:30:00 | AAPL | Stock | 25.495 | 25.55 | 25.49 | 25.525 | 267972.0 |
| 2014-09-24 08:00:00 | AAPL | Stock | 25.5125 | 25.66 | 25.4775 | 25.4975 | 8987384.0 |
| 2014-09-24 08:30:00 | AAPL | Stock | 25.5 | 25.5175 | 25.4575 | 25.4975 | 687480.0 |
| 2014-09-24 09:00:00 | AAPL | Stock | 25.4975 | 25.5625 | 25.4925 | 25.5325 | 883688.0 |
| 2014-09-24 09:30:00 | AAPL | Stock | 25.54 | 25.7125 | 25.4375 | 25.4925 | 37215764.0 |
| 2014-09-24 10:00:00 | AAPL | Stock | 25.4925 | 25.5225 | 25.3 | 25.485 | 27571308.0 |
| 2014-09-24 10:30:00 | AAPL | Stock | 25.485 | 25.5075 | 25.4088 | 25.4292 | 13902160.0 |
| 2014-09-24 11:00:00 | AAPL | Stock | 25.43 | 25.5362 | 25.395 | 25.505 | 14184644.0 |
| 2014-09-24 11:30:00 | AAPL | Stock | 25.505 | 25.5175 | 25.42 | 25.435 | 13224232.0 |
| 2014-09-24 12:00:00 | AAPL | Stock | 25.435 | 25.4825 | 25.4025 | 25.4615 | 8858536.0 |
| 2014-09-24 12:30:00 | AAPL | Stock | 25.4602 | 25.5 | 25.43 | 25.436 | 6719092.0 |
| 2014-09-24 13:00:00 | AAPL | Stock | 25.4362 | 25.5 | 25.415 | 25.4962 | 6510108.0 |
| 2014-09-24 13:30:00 | AAPL | Stock | 25.4975 | 25.5475 | 25.4525 | 25.5188 | 14532332.0 |
| 2014-09-24 14:00:00 | AAPL | Stock | 25.52 | 25.5375 | 25.4025 | 25.4138 | 11180748.0 |
| 2014-09-24 14:30:00 | AAPL | Stock | 25.4125 | 25.415 | 25.3375 | 25.395 | 18825108.0 |
| 2014-09-24 15:00:00 | AAPL | Stock | 25.3972 | 25.4825 | 25.38 | 25.4675 | 11625432.0 |
| 2014-09-24 15:30:00 | AAPL | Stock | 25.4675 | 25.4775 | 25.4125 | 25.4375 | 21425304.0 |
| 2014-09-24 16:00:00 | AAPL | Stock | 25.4362 | 25.475 | 25.4275 | 25.44 | 11766548.0 |
| 2014-09-24 16:30:00 | AAPL | Stock | 25.44 | 25.4518 | 25.3675 | 25.395 | 718980.0 |
| 2014-09-24 17:00:00 | AAPL | Stock | 25.3875 | 25.4375 | 25.355 | 25.36 | 288928.0 |
| 2014-09-24 17:30:00 | AAPL | Stock | 25.355 | 25.3575 | 25.3175 | 25.345 | 210952.0 |
| 2014-09-24 18:00:00 | AAPL | Stock | 25.335 | 25.3625 | 25.33 | 25.3625 | 110664.0 |
| 2014-09-24 18:30:00 | AAPL | Stock | 25.365 | 25.4375 | 25.35 | 25.37 | 192272.0 |
| 2014-09-24 19:00:00 | AAPL | Stock | 25.365 | 25.375 | 25.36 | 25.3725 | 66832.0 |
| 2014-09-24 19:30:00 | AAPL | Stock | 25.3675 | 25.375 | 25.34 | 25.345 | 144216.0 |
| 2014-09-24 07:00:00 | MSFT | Stock | 46.7 | 46.7 | 46.57 | 46.7 | 700.0 |
| 2014-09-24 07:30:00 | MSFT | Stock | 46.71 | 46.75 | 46.7 | 46.7 | 2198.0 |
| 2014-09-24 08:00:00 | MSFT | Stock | 46.78 | 46.78 | 46.68 | 46.72 | 11900.0 |
| 2014-09-24 08:30:00 | MSFT | Stock | 46.69 | 46.69 | 46.63 | 46.65 | 1563.0 |
| 2014-09-24 09:00:00 | MSFT | Stock | 46.63 | 46.69 | 46.62 | 46.65 | 2012.0 |
| 2014-09-24 09:30:00 | MSFT | Stock | 46.63 | 46.67 | 46.39 | 46.545 | 2529475.0 |
| 2014-09-24 10:00:00 | MSFT | Stock | 46.53 | 46.55 | 46.34 | 46.445 | 2583616.0 |
| 2014-09-24 10:30:00 | MSFT | Stock | 46.45 | 46.545 | 46.43 | 46.516 | 1686211.0 |
| 2014-09-24 11:00:00 | MSFT | Stock | 46.515 | 46.91 | 46.49 | 46.85 | 2428759.0 |
| 2014-09-24 11:30:00 | MSFT | Stock | 46.85 | 46.925 | 46.79 | 46.91 | 1595952.0 |
| 2014-09-24 12:00:00 | MSFT | Stock | 46.91 | 46.95 | 46.8 | 46.89 | 1080704.0 |
| 2014-09-24 12:30:00 | MSFT | Stock | 46.89 | 46.92 | 46.76 | 46.8 | 737423.0 |
| 2014-09-24 13:00:00 | MSFT | Stock | 46.8 | 46.85 | 46.77 | 46.79 | 965121.0 |
| 2014-09-24 13:30:00 | MSFT | Stock | 46.8 | 46.94 | 46.79 | 46.9 | 1061606.0 |
| 2014-09-24 14:00:00 | MSFT | Stock | 46.9 | 46.98 | 46.86 | 46.95 | 913997.0 |
| 2014-09-24 14:30:00 | MSFT | Stock | 46.95 | 46.97 | 46.88 | 46.964 | 1034439.0 |
| 2014-09-24 15:00:00 | MSFT | Stock | 46.97 | 46.99 | 46.94 | 46.948 | 1299239.0 |
| 2014-09-24 15:30:00 | MSFT | Stock | 46.95 | 47.11 | 46.94 | 47.08 | 3555799.0 |
> showing 50 of 84,275 rows — these rows as CSV