PREVIEW / stock_30min / 2015-05-26
file: by_date/stock_30min/2015/2015-05-26.parquet size: 1.6 MB rows: 82,771 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-26 04:00:00 | AAPL | Stock | 33.125 | 33.125 | 32.9425 | 32.9475 | 46552.0 |
| 2015-05-26 04:30:00 | AAPL | Stock | 32.965 | 32.9775 | 32.94 | 32.9775 | 7692.0 |
| 2015-05-26 05:00:00 | AAPL | Stock | 32.9975 | 33.01 | 32.9975 | 33.01 | 3368.0 |
| 2015-05-26 05:30:00 | AAPL | Stock | 33.0 | 33.025 | 33.0 | 33.025 | 44292.0 |
| 2015-05-26 06:00:00 | AAPL | Stock | 33.025 | 33.0575 | 33.0125 | 33.05 | 14552.0 |
| 2015-05-26 06:30:00 | AAPL | Stock | 33.06 | 33.0925 | 33.06 | 33.0925 | 3628.0 |
| 2015-05-26 07:00:00 | AAPL | Stock | 33.0875 | 33.12 | 33.0825 | 33.1125 | 41296.0 |
| 2015-05-26 07:30:00 | AAPL | Stock | 33.1175 | 33.16 | 33.1125 | 33.1325 | 77168.0 |
| 2015-05-26 08:00:00 | AAPL | Stock | 33.1475 | 33.225 | 33.03 | 33.205 | 458304.0 |
| 2015-05-26 08:30:00 | AAPL | Stock | 33.2025 | 33.225 | 33.125 | 33.195 | 526032.0 |
| 2015-05-26 09:00:00 | AAPL | Stock | 33.1925 | 33.1925 | 33.125 | 33.1575 | 471264.0 |
| 2015-05-26 09:30:00 | AAPL | Stock | 33.15 | 33.2275 | 32.805 | 32.845 | 34538116.0 |
| 2015-05-26 10:00:00 | AAPL | Stock | 32.84 | 32.9085 | 32.6925 | 32.7575 | 26727696.0 |
| 2015-05-26 10:30:00 | AAPL | Stock | 32.7575 | 32.765 | 32.6725 | 32.6975 | 16262372.0 |
| 2015-05-26 11:00:00 | AAPL | Stock | 32.6975 | 32.7222 | 32.5652 | 32.6195 | 17051756.0 |
| 2015-05-26 11:30:00 | AAPL | Stock | 32.6175 | 32.7175 | 32.6 | 32.6602 | 12756652.0 |
| 2015-05-26 12:00:00 | AAPL | Stock | 32.66 | 32.6775 | 32.61 | 32.6775 | 7015696.0 |
| 2015-05-26 12:30:00 | AAPL | Stock | 32.6775 | 32.6825 | 32.575 | 32.5775 | 8826504.0 |
| 2015-05-26 13:00:00 | AAPL | Stock | 32.5762 | 32.585 | 32.4875 | 32.555 | 15770716.0 |
| 2015-05-26 13:30:00 | AAPL | Stock | 32.5525 | 32.5585 | 32.4425 | 32.4475 | 13479368.0 |
| 2015-05-26 14:00:00 | AAPL | Stock | 32.4475 | 32.48 | 32.41 | 32.4275 | 14163756.0 |
| 2015-05-26 14:30:00 | AAPL | Stock | 32.4275 | 32.43 | 32.3025 | 32.3028 | 16753360.0 |
| 2015-05-26 15:00:00 | AAPL | Stock | 32.305 | 32.3762 | 32.28 | 32.3698 | 19997364.0 |
| 2015-05-26 15:30:00 | AAPL | Stock | 32.37 | 32.46 | 32.365 | 32.4075 | 23911848.0 |
| 2015-05-26 16:00:00 | AAPL | Stock | 32.405 | 33.15 | 32.395 | 32.425 | 19050716.0 |
| 2015-05-26 16:30:00 | AAPL | Stock | 32.4275 | 32.45 | 32.42 | 32.4375 | 111048.0 |
| 2015-05-26 17:00:00 | AAPL | Stock | 32.4375 | 32.47 | 32.4375 | 32.4675 | 139904.0 |
| 2015-05-26 17:30:00 | AAPL | Stock | 32.465 | 32.4725 | 32.455 | 32.4625 | 69192.0 |
| 2015-05-26 18:00:00 | AAPL | Stock | 32.4625 | 32.4625 | 32.425 | 32.45 | 81220.0 |
| 2015-05-26 18:30:00 | AAPL | Stock | 32.45 | 32.45 | 32.425 | 32.44 | 60612.0 |
| 2015-05-26 19:00:00 | AAPL | Stock | 32.4275 | 32.4375 | 32.4275 | 32.4325 | 67648.0 |
| 2015-05-26 19:30:00 | AAPL | Stock | 32.43 | 32.445 | 32.43 | 32.4375 | 43088.0 |
| 2015-05-26 04:00:00 | MSFT | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 200.0 |
| 2015-05-26 05:30:00 | MSFT | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 300.0 |
| 2015-05-26 08:00:00 | MSFT | Stock | 46.84 | 46.84 | 46.78 | 46.78 | 200.0 |
| 2015-05-26 08:30:00 | MSFT | Stock | 46.79 | 46.799 | 46.68 | 46.72 | 20175.0 |
| 2015-05-26 09:00:00 | MSFT | Stock | 46.71 | 46.88 | 46.64 | 46.83 | 30755.0 |
| 2015-05-26 09:30:00 | MSFT | Stock | 46.83 | 46.88 | 46.43 | 46.44 | 3076548.0 |
| 2015-05-26 10:00:00 | MSFT | Stock | 46.45 | 46.53 | 46.235 | 46.465 | 2848298.0 |
| 2015-05-26 10:30:00 | MSFT | Stock | 46.46 | 46.59 | 46.38 | 46.5 | 2035258.0 |
| 2015-05-26 11:00:00 | MSFT | Stock | 46.5 | 46.51 | 46.405 | 46.5 | 1920885.0 |
| 2015-05-26 11:30:00 | MSFT | Stock | 46.5 | 46.51 | 46.4 | 46.5 | 1520390.0 |
| 2015-05-26 12:00:00 | MSFT | Stock | 46.5 | 46.51 | 46.43 | 46.46 | 932774.0 |
| 2015-05-26 12:30:00 | MSFT | Stock | 46.46 | 46.48 | 46.3 | 46.345 | 1140296.0 |
| 2015-05-26 13:00:00 | MSFT | Stock | 46.35 | 46.48 | 46.26 | 46.45 | 1221569.0 |
| 2015-05-26 13:30:00 | MSFT | Stock | 46.45 | 46.456 | 46.25 | 46.29 | 1146900.0 |
| 2015-05-26 14:00:00 | MSFT | Stock | 46.3 | 46.365 | 46.19 | 46.25 | 1346747.0 |
| 2015-05-26 14:30:00 | MSFT | Stock | 46.255 | 46.32 | 46.2 | 46.295 | 1629698.0 |
| 2015-05-26 15:00:00 | MSFT | Stock | 46.29 | 46.45 | 46.29 | 46.45 | 1716714.0 |
| 2015-05-26 15:30:00 | MSFT | Stock | 46.45 | 46.66 | 46.45 | 46.6 | 4685616.0 |
> showing 50 of 82,771 rows — these rows as CSV