PREVIEW / stock_30min / 2016-05-26
file: by_date/stock_30min/2016/2016-05-26.parquet size: 1.5 MB rows: 80,752 symbols: 3,297
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-26 04:00:00 | AAPL | Stock | 24.9625 | 24.9625 | 24.9625 | 24.9625 | 2136.0 |
| 2016-05-26 04:30:00 | AAPL | Stock | 24.9025 | 24.9025 | 24.9025 | 24.9025 | 2000.0 |
| 2016-05-26 05:30:00 | AAPL | Stock | 24.8725 | 24.875 | 24.8625 | 24.875 | 8912.0 |
| 2016-05-26 06:00:00 | AAPL | Stock | 24.875 | 24.88 | 24.8725 | 24.88 | 9568.0 |
| 2016-05-26 06:30:00 | AAPL | Stock | 24.8775 | 24.89 | 24.8775 | 24.885 | 25504.0 |
| 2016-05-26 07:00:00 | AAPL | Stock | 24.8875 | 24.8975 | 24.8525 | 24.8975 | 50444.0 |
| 2016-05-26 07:30:00 | AAPL | Stock | 24.8875 | 24.93 | 24.8875 | 24.9125 | 41948.0 |
| 2016-05-26 08:00:00 | AAPL | Stock | 24.8775 | 24.9375 | 24.8775 | 24.9 | 291644.0 |
| 2016-05-26 08:30:00 | AAPL | Stock | 24.895 | 24.925 | 24.8375 | 24.9125 | 402604.0 |
| 2016-05-26 09:00:00 | AAPL | Stock | 24.905 | 24.9925 | 24.905 | 24.92 | 643512.0 |
| 2016-05-26 09:30:00 | AAPL | Stock | 24.92 | 24.975 | 24.66 | 24.765 | 31063916.0 |
| 2016-05-26 10:00:00 | AAPL | Stock | 24.765 | 24.87 | 24.7525 | 24.815 | 11217192.0 |
| 2016-05-26 10:30:00 | AAPL | Stock | 24.815 | 24.8562 | 24.7388 | 24.7425 | 8098896.0 |
| 2016-05-26 11:00:00 | AAPL | Stock | 24.74 | 24.845 | 24.7275 | 24.8375 | 8459872.0 |
| 2016-05-26 11:30:00 | AAPL | Stock | 24.84 | 24.855 | 24.775 | 24.8185 | 6461432.0 |
| 2016-05-26 12:00:00 | AAPL | Stock | 24.82 | 24.8475 | 24.8 | 24.8212 | 5114524.0 |
| 2016-05-26 12:30:00 | AAPL | Stock | 24.8225 | 24.9138 | 24.82 | 24.9025 | 6410344.0 |
| 2016-05-26 13:00:00 | AAPL | Stock | 24.9025 | 25.0 | 24.8975 | 24.9975 | 8527516.0 |
| 2016-05-26 13:30:00 | AAPL | Stock | 24.995 | 25.064 | 24.96 | 25.0425 | 11673668.0 |
| 2016-05-26 14:00:00 | AAPL | Stock | 25.0425 | 25.1225 | 25.0305 | 25.0885 | 9501920.0 |
| 2016-05-26 14:30:00 | AAPL | Stock | 25.0888 | 25.0975 | 25.0525 | 25.0775 | 5855472.0 |
| 2016-05-26 15:00:00 | AAPL | Stock | 25.0763 | 25.1825 | 25.07 | 25.1488 | 10343916.0 |
| 2016-05-26 15:30:00 | AAPL | Stock | 25.1488 | 25.1675 | 25.0875 | 25.105 | 12912948.0 |
| 2016-05-26 16:00:00 | AAPL | Stock | 25.1025 | 25.12 | 24.997 | 25.1025 | 10927324.0 |
| 2016-05-26 16:30:00 | AAPL | Stock | 25.1125 | 25.135 | 25.1025 | 25.1125 | 369672.0 |
| 2016-05-26 17:00:00 | AAPL | Stock | 25.1125 | 25.1275 | 25.105 | 25.1275 | 25396.0 |
| 2016-05-26 17:30:00 | AAPL | Stock | 25.115 | 25.125 | 25.1025 | 25.1175 | 62416.0 |
| 2016-05-26 18:00:00 | AAPL | Stock | 25.115 | 25.1175 | 25.11 | 25.1175 | 22896.0 |
| 2016-05-26 18:30:00 | AAPL | Stock | 25.1225 | 25.125 | 25.1175 | 25.1175 | 4800.0 |
| 2016-05-26 19:00:00 | AAPL | Stock | 25.1175 | 25.1275 | 25.11 | 25.125 | 11120.0 |
| 2016-05-26 19:30:00 | AAPL | Stock | 25.125 | 25.135 | 25.11 | 25.135 | 36772.0 |
| 2016-05-26 04:30:00 | MSFT | Stock | 52.11 | 52.11 | 52.11 | 52.11 | 100.0 |
| 2016-05-26 07:00:00 | MSFT | Stock | 52.12 | 52.12 | 52.12 | 52.12 | 325.0 |
| 2016-05-26 08:00:00 | MSFT | Stock | 52.23 | 52.23 | 52.23 | 52.23 | 1000.0 |
| 2016-05-26 08:30:00 | MSFT | Stock | 52.22 | 52.22 | 52.2 | 52.22 | 2530.0 |
| 2016-05-26 09:00:00 | MSFT | Stock | 52.19 | 52.19 | 51.88 | 51.94 | 26783.0 |
| 2016-05-26 09:30:00 | MSFT | Stock | 51.94 | 51.97 | 51.38 | 51.395 | 3876773.0 |
| 2016-05-26 10:00:00 | MSFT | Stock | 51.4 | 51.68 | 51.36 | 51.535 | 2045477.0 |
| 2016-05-26 10:30:00 | MSFT | Stock | 51.53 | 51.77 | 51.53 | 51.55 | 1510819.0 |
| 2016-05-26 11:00:00 | MSFT | Stock | 51.54 | 51.81 | 51.53 | 51.785 | 1015573.0 |
| 2016-05-26 11:30:00 | MSFT | Stock | 51.78 | 51.878 | 51.7 | 51.73 | 1264353.0 |
| 2016-05-26 12:00:00 | MSFT | Stock | 51.723 | 51.765 | 51.67 | 51.695 | 851270.0 |
| 2016-05-26 12:30:00 | MSFT | Stock | 51.69 | 51.77 | 51.67 | 51.69 | 643419.0 |
| 2016-05-26 13:00:00 | MSFT | Stock | 51.695 | 51.735 | 51.63 | 51.68 | 1429686.0 |
| 2016-05-26 13:30:00 | MSFT | Stock | 51.67 | 51.7 | 51.62 | 51.69 | 823607.0 |
| 2016-05-26 14:00:00 | MSFT | Stock | 51.68 | 51.73 | 51.67 | 51.717 | 1258066.0 |
| 2016-05-26 14:30:00 | MSFT | Stock | 51.71 | 51.84 | 51.68 | 51.83 | 1255834.0 |
| 2016-05-26 15:00:00 | MSFT | Stock | 51.84 | 51.979 | 51.83 | 51.935 | 1171862.0 |
| 2016-05-26 15:30:00 | MSFT | Stock | 51.935 | 51.965 | 51.82 | 51.89 | 3519979.0 |
| 2016-05-26 16:00:00 | MSFT | Stock | 51.89 | 51.89 | 51.89 | 51.89 | 2018474.0 |
> showing 50 of 80,752 rows — these rows as CSV