PREVIEW / stock_30min / 2015-08-19
file: by_date/stock_30min/2015/2015-08-19.parquet size: 1.6 MB rows: 81,111 symbols: 3,451
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-08-19 04:00:00 | AAPL | Stock | 29.1225 | 29.1225 | 29.02 | 29.0325 | 18852.0 |
| 2015-08-19 04:30:00 | AAPL | Stock | 29.0275 | 29.0375 | 29.0 | 29.0375 | 14276.0 |
| 2015-08-19 05:00:00 | AAPL | Stock | 29.0375 | 29.04 | 29.0375 | 29.04 | 3200.0 |
| 2015-08-19 05:30:00 | AAPL | Stock | 29.065 | 29.07 | 29.065 | 29.07 | 4296.0 |
| 2015-08-19 06:00:00 | AAPL | Stock | 29.095 | 29.125 | 29.08 | 29.125 | 9624.0 |
| 2015-08-19 06:30:00 | AAPL | Stock | 29.0975 | 29.105 | 29.05 | 29.05 | 11796.0 |
| 2015-08-19 07:00:00 | AAPL | Stock | 29.06 | 29.1075 | 29.06 | 29.0875 | 14508.0 |
| 2015-08-19 07:30:00 | AAPL | Stock | 29.095 | 29.14 | 29.095 | 29.125 | 80184.0 |
| 2015-08-19 08:00:00 | AAPL | Stock | 29.125 | 29.1425 | 29.065 | 29.1275 | 147212.0 |
| 2015-08-19 08:30:00 | AAPL | Stock | 29.1275 | 29.1375 | 29.08 | 29.08 | 105336.0 |
| 2015-08-19 09:00:00 | AAPL | Stock | 29.095 | 29.095 | 28.965 | 28.995 | 425772.0 |
| 2015-08-19 09:30:00 | AAPL | Stock | 29.025 | 29.13 | 28.885 | 28.8962 | 24908056.0 |
| 2015-08-19 10:00:00 | AAPL | Stock | 28.895 | 29.0075 | 28.8862 | 28.9498 | 12752804.0 |
| 2015-08-19 10:30:00 | AAPL | Stock | 28.9475 | 28.95 | 28.7725 | 28.8175 | 15199708.0 |
| 2015-08-19 11:00:00 | AAPL | Stock | 28.8175 | 28.8625 | 28.6725 | 28.7015 | 14057524.0 |
| 2015-08-19 11:30:00 | AAPL | Stock | 28.7012 | 28.7675 | 28.67 | 28.737 | 11723548.0 |
| 2015-08-19 12:00:00 | AAPL | Stock | 28.7362 | 28.7475 | 28.68 | 28.7325 | 7346700.0 |
| 2015-08-19 12:30:00 | AAPL | Stock | 28.73 | 28.815 | 28.7175 | 28.765 | 7756972.0 |
| 2015-08-19 13:00:00 | AAPL | Stock | 28.765 | 28.85 | 28.7475 | 28.7475 | 7964820.0 |
| 2015-08-19 13:30:00 | AAPL | Stock | 28.7475 | 28.87 | 28.725 | 28.8175 | 10123640.0 |
| 2015-08-19 14:00:00 | AAPL | Stock | 28.82 | 29.0775 | 28.8075 | 28.9725 | 18222320.0 |
| 2015-08-19 14:30:00 | AAPL | Stock | 28.975 | 28.9948 | 28.7362 | 28.78 | 12046928.0 |
| 2015-08-19 15:00:00 | AAPL | Stock | 28.78 | 28.8375 | 28.7375 | 28.82 | 11649940.0 |
| 2015-08-19 15:30:00 | AAPL | Stock | 28.82 | 28.875 | 28.755 | 28.755 | 15833320.0 |
| 2015-08-19 16:00:00 | AAPL | Stock | 28.7525 | 28.7675 | 28.7125 | 28.7375 | 9535264.0 |
| 2015-08-19 16:30:00 | AAPL | Stock | 28.7375 | 28.7525 | 28.7125 | 28.7175 | 2294872.0 |
| 2015-08-19 17:00:00 | AAPL | Stock | 28.725 | 28.7525 | 28.7175 | 28.7525 | 557428.0 |
| 2015-08-19 17:30:00 | AAPL | Stock | 28.7175 | 28.7375 | 28.715 | 28.735 | 56028.0 |
| 2015-08-19 18:00:00 | AAPL | Stock | 28.735 | 28.7525 | 28.7325 | 28.7425 | 39400.0 |
| 2015-08-19 18:30:00 | AAPL | Stock | 28.7425 | 28.75 | 28.7425 | 28.745 | 30956.0 |
| 2015-08-19 19:00:00 | AAPL | Stock | 28.745 | 28.75 | 28.7275 | 28.7275 | 52204.0 |
| 2015-08-19 19:30:00 | AAPL | Stock | 28.7325 | 28.7325 | 28.7025 | 28.7025 | 81336.0 |
| 2015-08-19 08:00:00 | MSFT | Stock | 47.2 | 47.2 | 47.0 | 47.0 | 2300.0 |
| 2015-08-19 08:30:00 | MSFT | Stock | 47.1 | 47.13 | 47.1 | 47.13 | 2600.0 |
| 2015-08-19 09:00:00 | MSFT | Stock | 47.05 | 47.05 | 46.8 | 46.8 | 28610.0 |
| 2015-08-19 09:30:00 | MSFT | Stock | 46.78 | 46.9 | 46.495 | 46.565 | 3525548.0 |
| 2015-08-19 10:00:00 | MSFT | Stock | 46.56 | 46.836 | 46.56 | 46.836 | 2354484.0 |
| 2015-08-19 10:30:00 | MSFT | Stock | 46.83 | 46.86 | 46.58 | 46.59 | 2108677.0 |
| 2015-08-19 11:00:00 | MSFT | Stock | 46.595 | 46.66 | 46.42 | 46.489 | 1945960.0 |
| 2015-08-19 11:30:00 | MSFT | Stock | 46.48 | 46.5 | 46.3 | 46.44 | 1379531.0 |
| 2015-08-19 12:00:00 | MSFT | Stock | 46.43 | 46.54 | 46.38 | 46.52 | 1519777.0 |
| 2015-08-19 12:30:00 | MSFT | Stock | 46.52 | 46.67 | 46.5 | 46.555 | 1182471.0 |
| 2015-08-19 13:00:00 | MSFT | Stock | 46.56 | 46.64 | 46.49 | 46.49 | 1006519.0 |
| 2015-08-19 13:30:00 | MSFT | Stock | 46.5 | 46.725 | 46.493 | 46.64 | 1465571.0 |
| 2015-08-19 14:00:00 | MSFT | Stock | 46.63 | 47.08 | 46.62 | 46.98 | 3032970.0 |
| 2015-08-19 14:30:00 | MSFT | Stock | 46.979 | 46.99 | 46.565 | 46.6 | 2107933.0 |
| 2015-08-19 15:00:00 | MSFT | Stock | 46.6 | 46.74 | 46.52 | 46.666 | 2343199.0 |
| 2015-08-19 15:30:00 | MSFT | Stock | 46.67 | 46.83 | 46.61 | 46.625 | 3837021.0 |
| 2015-08-19 16:00:00 | MSFT | Stock | 46.61 | 46.71 | 46.54 | 46.56 | 2082041.0 |
| 2015-08-19 16:30:00 | MSFT | Stock | 46.6 | 46.653 | 46.6 | 46.65 | 6900.0 |
> showing 50 of 81,111 rows — these rows as CSV