PREVIEW / stock_30min / 2015-12-30
file: by_date/stock_30min/2015/2015-12-30.parquet size: 1.6 MB rows: 81,495 symbols: 3,424
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-12-30 05:00:00 | AAPL | Stock | 27.1525 | 27.1525 | 27.125 | 27.125 | 936.0 |
| 2015-12-30 05:30:00 | AAPL | Stock | 27.125 | 27.125 | 27.095 | 27.125 | 8056.0 |
| 2015-12-30 06:00:00 | AAPL | Stock | 27.175 | 27.175 | 27.175 | 27.175 | 400.0 |
| 2015-12-30 07:00:00 | AAPL | Stock | 27.15 | 27.15 | 27.1375 | 27.15 | 7260.0 |
| 2015-12-30 07:30:00 | AAPL | Stock | 27.13 | 27.1675 | 27.1275 | 27.15 | 52216.0 |
| 2015-12-30 08:00:00 | AAPL | Stock | 27.14 | 27.1675 | 27.0925 | 27.0925 | 78756.0 |
| 2015-12-30 08:30:00 | AAPL | Stock | 27.11 | 27.15 | 27.095 | 27.125 | 51544.0 |
| 2015-12-30 09:00:00 | AAPL | Stock | 27.125 | 27.15 | 27.125 | 27.15 | 61756.0 |
| 2015-12-30 09:30:00 | AAPL | Stock | 27.145 | 27.175 | 26.85 | 26.8868 | 14574764.0 |
| 2015-12-30 10:00:00 | AAPL | Stock | 26.8875 | 26.95 | 26.795 | 26.8262 | 10466084.0 |
| 2015-12-30 10:30:00 | AAPL | Stock | 26.825 | 26.9475 | 26.8125 | 26.9115 | 7062788.0 |
| 2015-12-30 11:00:00 | AAPL | Stock | 26.9125 | 26.985 | 26.8925 | 26.97 | 5105272.0 |
| 2015-12-30 11:30:00 | AAPL | Stock | 26.9688 | 26.9725 | 26.875 | 26.8875 | 4278700.0 |
| 2015-12-30 12:00:00 | AAPL | Stock | 26.8868 | 26.94 | 26.875 | 26.9248 | 4072172.0 |
| 2015-12-30 12:30:00 | AAPL | Stock | 26.9225 | 26.945 | 26.895 | 26.925 | 3130960.0 |
| 2015-12-30 13:00:00 | AAPL | Stock | 26.9238 | 26.9425 | 26.875 | 26.9008 | 3857660.0 |
| 2015-12-30 13:30:00 | AAPL | Stock | 26.9025 | 26.9375 | 26.8925 | 26.9325 | 3345312.0 |
| 2015-12-30 14:00:00 | AAPL | Stock | 26.933 | 26.95 | 26.9 | 26.909 | 4215624.0 |
| 2015-12-30 14:30:00 | AAPL | Stock | 26.91 | 26.93 | 26.8875 | 26.9225 | 4131428.0 |
| 2015-12-30 15:00:00 | AAPL | Stock | 26.925 | 26.975 | 26.9075 | 26.935 | 5028020.0 |
| 2015-12-30 15:30:00 | AAPL | Stock | 26.935 | 26.935 | 26.8175 | 26.83 | 13321920.0 |
| 2015-12-30 16:00:00 | AAPL | Stock | 26.83 | 26.95 | 26.8125 | 26.8325 | 4875432.0 |
| 2015-12-30 16:30:00 | AAPL | Stock | 26.8375 | 26.85 | 26.8325 | 26.8375 | 38536.0 |
| 2015-12-30 17:00:00 | AAPL | Stock | 26.8425 | 26.85 | 26.8375 | 26.8375 | 17636.0 |
| 2015-12-30 17:30:00 | AAPL | Stock | 26.8375 | 26.8525 | 26.8375 | 26.8525 | 5740.0 |
| 2015-12-30 18:00:00 | AAPL | Stock | 26.8425 | 26.8525 | 26.8325 | 26.8325 | 54376.0 |
| 2015-12-30 18:30:00 | AAPL | Stock | 26.8525 | 26.8525 | 26.8325 | 26.8525 | 18544.0 |
| 2015-12-30 19:00:00 | AAPL | Stock | 26.86 | 26.885 | 26.8525 | 26.885 | 4200.0 |
| 2015-12-30 19:30:00 | AAPL | Stock | 26.8675 | 26.885 | 26.8675 | 26.885 | 13860.0 |
| 2015-12-30 07:30:00 | MSFT | Stock | 56.46 | 56.51 | 56.46 | 56.51 | 1095.0 |
| 2015-12-30 08:00:00 | MSFT | Stock | 56.4 | 56.4 | 56.4 | 56.4 | 300.0 |
| 2015-12-30 08:30:00 | MSFT | Stock | 56.48 | 56.5 | 56.45 | 56.45 | 2200.0 |
| 2015-12-30 09:00:00 | MSFT | Stock | 56.49 | 56.55 | 56.47 | 56.49 | 7737.0 |
| 2015-12-30 09:30:00 | MSFT | Stock | 56.47 | 56.6 | 56.288 | 56.54 | 1684596.0 |
| 2015-12-30 10:00:00 | MSFT | Stock | 56.55 | 56.78 | 56.53 | 56.58 | 1292763.0 |
| 2015-12-30 10:30:00 | MSFT | Stock | 56.57 | 56.72 | 56.5 | 56.67 | 1051378.0 |
| 2015-12-30 11:00:00 | MSFT | Stock | 56.67 | 56.69 | 56.47 | 56.585 | 954848.0 |
| 2015-12-30 11:30:00 | MSFT | Stock | 56.59 | 56.615 | 56.45 | 56.46 | 1192143.0 |
| 2015-12-30 12:00:00 | MSFT | Stock | 56.46 | 56.62 | 56.455 | 56.61 | 1040621.0 |
| 2015-12-30 12:30:00 | MSFT | Stock | 56.6 | 56.67 | 56.55 | 56.646 | 720808.0 |
| 2015-12-30 13:00:00 | MSFT | Stock | 56.645 | 56.7 | 56.555 | 56.61 | 686744.0 |
| 2015-12-30 13:30:00 | MSFT | Stock | 56.61 | 56.71 | 56.595 | 56.645 | 1069788.0 |
| 2015-12-30 14:00:00 | MSFT | Stock | 56.64 | 56.73 | 56.62 | 56.637 | 731732.0 |
| 2015-12-30 14:30:00 | MSFT | Stock | 56.637 | 56.7 | 56.61 | 56.65 | 1271414.0 |
| 2015-12-30 15:00:00 | MSFT | Stock | 56.65 | 56.72 | 56.58 | 56.62 | 1438679.0 |
| 2015-12-30 15:30:00 | MSFT | Stock | 56.62 | 56.635 | 56.29 | 56.31 | 2621076.0 |
| 2015-12-30 16:00:00 | MSFT | Stock | 56.31 | 56.39 | 56.31 | 56.32 | 3187377.0 |
| 2015-12-30 17:30:00 | MSFT | Stock | 56.36 | 56.36 | 56.36 | 56.36 | 100.0 |
| 2015-12-30 18:00:00 | MSFT | Stock | 56.36 | 56.36 | 56.36 | 56.36 | 100.0 |
| 2015-12-30 18:30:00 | MSFT | Stock | 56.36 | 56.36 | 56.36 | 56.36 | 600.0 |
> showing 50 of 81,495 rows — these rows as CSV