PREVIEW / stock_30min / 2015-12-29
file: by_date/stock_30min/2015/2015-12-29.parquet size: 1.6 MB rows: 82,762 symbols: 3,429
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-29 04:00:00 | AAPL | Stock | 26.75 | 26.875 | 26.75 | 26.875 | 6000.0 |
| 2015-12-29 05:30:00 | AAPL | Stock | 26.8375 | 26.8525 | 26.8275 | 26.845 | 3928.0 |
| 2015-12-29 06:00:00 | AAPL | Stock | 26.8375 | 26.85 | 26.815 | 26.815 | 10400.0 |
| 2015-12-29 06:30:00 | AAPL | Stock | 26.815 | 26.8375 | 26.78 | 26.785 | 15896.0 |
| 2015-12-29 07:00:00 | AAPL | Stock | 26.7975 | 26.7975 | 26.7975 | 26.7975 | 800.0 |
| 2015-12-29 07:30:00 | AAPL | Stock | 26.83 | 26.87 | 26.78 | 26.8 | 111320.0 |
| 2015-12-29 08:00:00 | AAPL | Stock | 26.7825 | 26.85 | 26.725 | 26.7475 | 327180.0 |
| 2015-12-29 08:30:00 | AAPL | Stock | 26.75 | 26.8375 | 26.75 | 26.8125 | 156464.0 |
| 2015-12-29 09:00:00 | AAPL | Stock | 26.8125 | 26.82 | 26.725 | 26.74 | 254540.0 |
| 2015-12-29 09:30:00 | AAPL | Stock | 26.74 | 26.925 | 26.715 | 26.8425 | 14180444.0 |
| 2015-12-29 10:00:00 | AAPL | Stock | 26.8425 | 26.9472 | 26.8325 | 26.9325 | 7912604.0 |
| 2015-12-29 10:30:00 | AAPL | Stock | 26.9325 | 26.945 | 26.85 | 26.875 | 6481644.0 |
| 2015-12-29 11:00:00 | AAPL | Stock | 26.875 | 26.9888 | 26.875 | 26.98 | 6545400.0 |
| 2015-12-29 11:30:00 | AAPL | Stock | 26.9812 | 27.0125 | 26.9525 | 26.9702 | 6713680.0 |
| 2015-12-29 12:00:00 | AAPL | Stock | 26.9712 | 27.125 | 26.9705 | 27.1038 | 7617552.0 |
| 2015-12-29 12:30:00 | AAPL | Stock | 27.1035 | 27.1525 | 27.0925 | 27.1335 | 6036604.0 |
| 2015-12-29 13:00:00 | AAPL | Stock | 27.135 | 27.2022 | 27.1325 | 27.1985 | 6090756.0 |
| 2015-12-29 13:30:00 | AAPL | Stock | 27.1975 | 27.2925 | 27.1962 | 27.2675 | 9335412.0 |
| 2015-12-29 14:00:00 | AAPL | Stock | 27.27 | 27.34 | 27.2542 | 27.325 | 7759884.0 |
| 2015-12-29 14:30:00 | AAPL | Stock | 27.3275 | 27.3575 | 27.265 | 27.3075 | 7354316.0 |
| 2015-12-29 15:00:00 | AAPL | Stock | 27.309 | 27.3275 | 27.2 | 27.215 | 8031004.0 |
| 2015-12-29 15:30:00 | AAPL | Stock | 27.215 | 27.2375 | 27.155 | 27.185 | 12701196.0 |
| 2015-12-29 16:00:00 | AAPL | Stock | 27.1825 | 27.2 | 26.956 | 27.1875 | 5426884.0 |
| 2015-12-29 16:30:00 | AAPL | Stock | 27.1875 | 27.2 | 27.1775 | 27.1775 | 69972.0 |
| 2015-12-29 17:00:00 | AAPL | Stock | 27.1775 | 27.19 | 27.175 | 27.18 | 150876.0 |
| 2015-12-29 17:30:00 | AAPL | Stock | 27.1775 | 27.1875 | 27.1775 | 27.1875 | 17592.0 |
| 2015-12-29 18:00:00 | AAPL | Stock | 27.1875 | 27.19 | 27.185 | 27.19 | 4008.0 |
| 2015-12-29 18:30:00 | AAPL | Stock | 27.1875 | 27.1875 | 27.1775 | 27.1775 | 24072.0 |
| 2015-12-29 19:00:00 | AAPL | Stock | 27.18 | 27.18 | 27.175 | 27.175 | 13168.0 |
| 2015-12-29 19:30:00 | AAPL | Stock | 27.185 | 27.1875 | 27.175 | 27.175 | 7044.0 |
| 2015-12-29 07:00:00 | MSFT | Stock | 56.08 | 56.08 | 56.08 | 56.08 | 100.0 |
| 2015-12-29 07:30:00 | MSFT | Stock | 56.15 | 56.15 | 56.15 | 56.15 | 929.0 |
| 2015-12-29 08:00:00 | MSFT | Stock | 56.16 | 56.3 | 56.16 | 56.3 | 8711.0 |
| 2015-12-29 08:30:00 | MSFT | Stock | 56.3 | 56.4 | 56.3 | 56.39 | 11164.0 |
| 2015-12-29 09:00:00 | MSFT | Stock | 56.34 | 56.38 | 56.18 | 56.18 | 16091.0 |
| 2015-12-29 09:30:00 | MSFT | Stock | 56.23 | 56.4 | 56.06 | 56.4 | 3289153.0 |
| 2015-12-29 10:00:00 | MSFT | Stock | 56.4 | 56.64 | 56.14 | 56.25 | 3367683.0 |
| 2015-12-29 10:30:00 | MSFT | Stock | 56.25 | 56.525 | 56.23 | 56.41 | 1797932.0 |
| 2015-12-29 11:00:00 | MSFT | Stock | 56.42 | 56.55 | 56.39 | 56.46 | 1062081.0 |
| 2015-12-29 11:30:00 | MSFT | Stock | 56.46 | 56.59 | 56.44 | 56.548 | 1161708.0 |
| 2015-12-29 12:00:00 | MSFT | Stock | 56.54 | 56.635 | 56.47 | 56.56 | 1070835.0 |
| 2015-12-29 12:30:00 | MSFT | Stock | 56.556 | 56.61 | 56.49 | 56.605 | 835999.0 |
| 2015-12-29 13:00:00 | MSFT | Stock | 56.6 | 56.62 | 56.48 | 56.615 | 1115035.0 |
| 2015-12-29 13:30:00 | MSFT | Stock | 56.615 | 56.85 | 56.61 | 56.804 | 1668819.0 |
| 2015-12-29 14:00:00 | MSFT | Stock | 56.81 | 56.85 | 56.69 | 56.77 | 1560372.0 |
| 2015-12-29 14:30:00 | MSFT | Stock | 56.76 | 56.82 | 56.66 | 56.756 | 1149612.0 |
| 2015-12-29 15:00:00 | MSFT | Stock | 56.752 | 56.84 | 56.68 | 56.78 | 1701629.0 |
| 2015-12-29 15:30:00 | MSFT | Stock | 56.78 | 56.78 | 56.53 | 56.55 | 3012383.0 |
| 2015-12-29 16:00:00 | MSFT | Stock | 56.55 | 56.56 | 56.5 | 56.5 | 3042166.0 |
| 2015-12-29 16:30:00 | MSFT | Stock | 56.55 | 56.55 | 56.55 | 56.55 | 134937.0 |
> showing 50 of 82,762 rows — these rows as CSV