PREVIEW / stock_30min / 2016-10-05
file: by_date/stock_30min/2016/2016-10-05.parquet size: 1.6 MB rows: 80,269 symbols: 3,194
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-10-05 04:00:00 | AAPL | Stock | 28.5725 | 28.5725 | 28.5725 | 28.5725 | 400.0 |
| 2016-10-05 04:30:00 | AAPL | Stock | 28.2875 | 28.2875 | 28.2875 | 28.2875 | 504.0 |
| 2016-10-05 05:00:00 | AAPL | Stock | 28.3075 | 28.3425 | 28.3075 | 28.3425 | 3688.0 |
| 2016-10-05 07:00:00 | AAPL | Stock | 28.2775 | 28.315 | 28.2725 | 28.31 | 8400.0 |
| 2016-10-05 07:30:00 | AAPL | Stock | 28.3225 | 28.335 | 28.3075 | 28.3325 | 20724.0 |
| 2016-10-05 08:00:00 | AAPL | Stock | 28.325 | 28.35 | 28.1875 | 28.305 | 91736.0 |
| 2016-10-05 08:30:00 | AAPL | Stock | 28.3125 | 28.35 | 28.3075 | 28.35 | 33088.0 |
| 2016-10-05 09:00:00 | AAPL | Stock | 28.35 | 28.4 | 28.3325 | 28.3675 | 233184.0 |
| 2016-10-05 09:30:00 | AAPL | Stock | 28.35 | 28.415 | 28.2125 | 28.3225 | 13116128.0 |
| 2016-10-05 10:00:00 | AAPL | Stock | 28.325 | 28.3675 | 28.255 | 28.285 | 7711492.0 |
| 2016-10-05 10:30:00 | AAPL | Stock | 28.2825 | 28.295 | 28.1725 | 28.2325 | 7798732.0 |
| 2016-10-05 11:00:00 | AAPL | Stock | 28.23 | 28.2635 | 28.22 | 28.2375 | 3667048.0 |
| 2016-10-05 11:30:00 | AAPL | Stock | 28.2375 | 28.2775 | 28.2375 | 28.26 | 3679160.0 |
| 2016-10-05 12:00:00 | AAPL | Stock | 28.26 | 28.2875 | 28.25 | 28.2725 | 2870584.0 |
| 2016-10-05 12:30:00 | AAPL | Stock | 28.2708 | 28.29 | 28.265 | 28.2735 | 2355992.0 |
| 2016-10-05 13:00:00 | AAPL | Stock | 28.2725 | 28.2975 | 28.23 | 28.2435 | 3716736.0 |
| 2016-10-05 13:30:00 | AAPL | Stock | 28.2425 | 28.3125 | 28.22 | 28.2875 | 5793656.0 |
| 2016-10-05 14:00:00 | AAPL | Stock | 28.2892 | 28.2925 | 28.2575 | 28.27 | 3226504.0 |
| 2016-10-05 14:30:00 | AAPL | Stock | 28.2685 | 28.3175 | 28.2675 | 28.2975 | 6659188.0 |
| 2016-10-05 15:00:00 | AAPL | Stock | 28.2975 | 28.3125 | 28.24 | 28.24 | 4469708.0 |
| 2016-10-05 15:30:00 | AAPL | Stock | 28.24 | 28.2675 | 28.2288 | 28.26 | 6800892.0 |
| 2016-10-05 16:00:00 | AAPL | Stock | 28.26 | 28.4775 | 28.2425 | 28.4775 | 7813924.0 |
| 2016-10-05 16:30:00 | AAPL | Stock | 28.45 | 28.47 | 28.325 | 28.3575 | 505264.0 |
| 2016-10-05 17:00:00 | AAPL | Stock | 28.3625 | 28.375 | 28.3225 | 28.345 | 113844.0 |
| 2016-10-05 17:30:00 | AAPL | Stock | 28.325 | 28.37 | 28.32 | 28.3675 | 69068.0 |
| 2016-10-05 18:00:00 | AAPL | Stock | 28.3675 | 28.37 | 28.35 | 28.37 | 17800.0 |
| 2016-10-05 18:30:00 | AAPL | Stock | 28.35 | 28.37 | 28.35 | 28.355 | 42572.0 |
| 2016-10-05 19:00:00 | AAPL | Stock | 28.37 | 28.37 | 28.365 | 28.365 | 16320.0 |
| 2016-10-05 19:30:00 | AAPL | Stock | 28.355 | 28.3675 | 28.345 | 28.365 | 34740.0 |
| 2016-10-05 08:00:00 | MSFT | Stock | 57.1 | 57.35 | 57.1 | 57.35 | 1190.0 |
| 2016-10-05 08:30:00 | MSFT | Stock | 57.42 | 57.42 | 57.24 | 57.24 | 16086.0 |
| 2016-10-05 09:00:00 | MSFT | Stock | 57.33 | 57.33 | 57.31 | 57.31 | 4807.0 |
| 2016-10-05 09:30:00 | MSFT | Stock | 57.32 | 57.7 | 57.26 | 57.58 | 2029764.0 |
| 2016-10-05 10:00:00 | MSFT | Stock | 57.59 | 57.792 | 57.529 | 57.792 | 1305121.0 |
| 2016-10-05 10:30:00 | MSFT | Stock | 57.8 | 57.83 | 57.62 | 57.72 | 1205291.0 |
| 2016-10-05 11:00:00 | MSFT | Stock | 57.725 | 57.84 | 57.68 | 57.833 | 810861.0 |
| 2016-10-05 11:30:00 | MSFT | Stock | 57.835 | 57.93 | 57.78 | 57.91 | 921898.0 |
| 2016-10-05 12:00:00 | MSFT | Stock | 57.9 | 57.96 | 57.885 | 57.955 | 847554.0 |
| 2016-10-05 12:30:00 | MSFT | Stock | 57.95 | 57.96 | 57.83 | 57.86 | 698836.0 |
| 2016-10-05 13:00:00 | MSFT | Stock | 57.87 | 57.89 | 57.73 | 57.78 | 641195.0 |
| 2016-10-05 13:30:00 | MSFT | Stock | 57.78 | 57.88 | 57.76 | 57.865 | 598295.0 |
| 2016-10-05 14:00:00 | MSFT | Stock | 57.86 | 57.915 | 57.82 | 57.855 | 751560.0 |
| 2016-10-05 14:30:00 | MSFT | Stock | 57.85 | 57.87 | 57.8 | 57.844 | 953756.0 |
| 2016-10-05 15:00:00 | MSFT | Stock | 57.84 | 57.877 | 57.63 | 57.65 | 1107092.0 |
| 2016-10-05 15:30:00 | MSFT | Stock | 57.643 | 57.695 | 57.6 | 57.64 | 1869452.0 |
| 2016-10-05 16:00:00 | MSFT | Stock | 57.634 | 57.72 | 57.61 | 57.64 | 1751531.0 |
| 2016-10-05 07:00:00 | NVDA | Stock | 1.7075 | 1.7075 | 1.7075 | 1.7075 | 12000.0 |
| 2016-10-05 07:30:00 | NVDA | Stock | 1.708 | 1.708 | 1.708 | 1.708 | 8000.0 |
| 2016-10-05 08:00:00 | NVDA | Stock | 1.7075 | 1.715 | 1.7075 | 1.7125 | 872960.0 |
| 2016-10-05 08:30:00 | NVDA | Stock | 1.7125 | 1.715 | 1.7125 | 1.7128 | 54400.0 |
> showing 50 of 80,269 rows — these rows as CSV