PREVIEW / stock_30min / 2015-12-16
file: by_date/stock_30min/2015/2015-12-16.parquet size: 1.6 MB rows: 84,083 symbols: 3,435
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-16 04:00:00 | AAPL | Stock | 27.6925 | 27.7025 | 27.6925 | 27.7025 | 4400.0 |
| 2015-12-16 04:30:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7125 | 27.7125 | 800.0 |
| 2015-12-16 05:00:00 | AAPL | Stock | 27.8025 | 27.8025 | 27.735 | 27.735 | 1200.0 |
| 2015-12-16 05:30:00 | AAPL | Stock | 27.7525 | 27.825 | 27.75 | 27.825 | 8800.0 |
| 2015-12-16 06:00:00 | AAPL | Stock | 27.8 | 27.8 | 27.7375 | 27.7825 | 36924.0 |
| 2015-12-16 06:30:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7125 | 27.7375 | 36284.0 |
| 2015-12-16 07:00:00 | AAPL | Stock | 27.745 | 27.745 | 27.675 | 27.7125 | 52180.0 |
| 2015-12-16 07:30:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.6025 | 27.6725 | 109644.0 |
| 2015-12-16 08:00:00 | AAPL | Stock | 27.6725 | 27.825 | 27.6325 | 27.7825 | 325624.0 |
| 2015-12-16 08:30:00 | AAPL | Stock | 27.7775 | 27.78 | 27.7125 | 27.775 | 183916.0 |
| 2015-12-16 09:00:00 | AAPL | Stock | 27.755 | 27.795 | 27.675 | 27.7675 | 328320.0 |
| 2015-12-16 09:30:00 | AAPL | Stock | 27.7525 | 27.9975 | 27.6588 | 27.66 | 23137696.0 |
| 2015-12-16 10:00:00 | AAPL | Stock | 27.66 | 27.7225 | 27.5275 | 27.535 | 14384176.0 |
| 2015-12-16 10:30:00 | AAPL | Stock | 27.5325 | 27.6625 | 27.43 | 27.6012 | 18797024.0 |
| 2015-12-16 11:00:00 | AAPL | Stock | 27.6 | 27.6025 | 27.3562 | 27.3675 | 15211968.0 |
| 2015-12-16 11:30:00 | AAPL | Stock | 27.3675 | 27.425 | 27.2325 | 27.2712 | 17532468.0 |
| 2015-12-16 12:00:00 | AAPL | Stock | 27.2712 | 27.3175 | 27.2 | 27.315 | 13873952.0 |
| 2015-12-16 12:30:00 | AAPL | Stock | 27.315 | 27.3175 | 27.24 | 27.2625 | 9719856.0 |
| 2015-12-16 13:00:00 | AAPL | Stock | 27.2625 | 27.43 | 27.25 | 27.405 | 9077244.0 |
| 2015-12-16 13:30:00 | AAPL | Stock | 27.4075 | 27.6075 | 27.4 | 27.58 | 9838028.0 |
| 2015-12-16 14:00:00 | AAPL | Stock | 27.5775 | 27.65 | 27.32 | 27.54 | 19135724.0 |
| 2015-12-16 14:30:00 | AAPL | Stock | 27.5375 | 27.775 | 27.445 | 27.7738 | 15511248.0 |
| 2015-12-16 15:00:00 | AAPL | Stock | 27.7725 | 27.8575 | 27.64 | 27.835 | 14481756.0 |
| 2015-12-16 15:30:00 | AAPL | Stock | 27.8375 | 27.9 | 27.7825 | 27.835 | 18017848.0 |
| 2015-12-16 16:00:00 | AAPL | Stock | 27.835 | 27.85 | 27.677 | 27.677 | 9034420.0 |
| 2015-12-16 16:30:00 | AAPL | Stock | 27.8125 | 27.8125 | 27.805 | 27.81 | 29628.0 |
| 2015-12-16 17:00:00 | AAPL | Stock | 27.8075 | 27.825 | 27.805 | 27.805 | 60976.0 |
| 2015-12-16 17:30:00 | AAPL | Stock | 27.82 | 27.82 | 27.8 | 27.8 | 25848.0 |
| 2015-12-16 18:00:00 | AAPL | Stock | 27.8 | 27.8375 | 27.8 | 27.835 | 37208.0 |
| 2015-12-16 18:30:00 | AAPL | Stock | 27.835 | 27.835 | 27.82 | 27.825 | 16436.0 |
| 2015-12-16 19:00:00 | AAPL | Stock | 27.825 | 27.8375 | 27.81 | 27.8375 | 14320.0 |
| 2015-12-16 19:30:00 | AAPL | Stock | 27.8275 | 27.835 | 27.815 | 27.8175 | 26212.0 |
| 2015-12-16 06:30:00 | MSFT | Stock | 55.64 | 55.64 | 55.6 | 55.61 | 5300.0 |
| 2015-12-16 07:00:00 | MSFT | Stock | 55.5 | 55.51 | 55.5 | 55.51 | 1200.0 |
| 2015-12-16 07:30:00 | MSFT | Stock | 55.57 | 55.57 | 55.43 | 55.54 | 4927.0 |
| 2015-12-16 08:00:00 | MSFT | Stock | 55.48 | 55.57 | 55.48 | 55.56 | 18070.0 |
| 2015-12-16 08:30:00 | MSFT | Stock | 55.52 | 55.55 | 55.52 | 55.53 | 1200.0 |
| 2015-12-16 09:00:00 | MSFT | Stock | 55.53 | 55.64 | 55.53 | 55.64 | 27299.0 |
| 2015-12-16 09:30:00 | MSFT | Stock | 55.54 | 55.79 | 55.41 | 55.44 | 3643170.0 |
| 2015-12-16 10:00:00 | MSFT | Stock | 55.44 | 55.56 | 55.33 | 55.38 | 2057734.0 |
| 2015-12-16 10:30:00 | MSFT | Stock | 55.37 | 55.57 | 55.33 | 55.47 | 2400189.0 |
| 2015-12-16 11:00:00 | MSFT | Stock | 55.48 | 55.53 | 55.27 | 55.275 | 1187086.0 |
| 2015-12-16 11:30:00 | MSFT | Stock | 55.27 | 55.364 | 55.11 | 55.16 | 1228143.0 |
| 2015-12-16 12:00:00 | MSFT | Stock | 55.16 | 55.274 | 55.09 | 55.13 | 1420261.0 |
| 2015-12-16 12:30:00 | MSFT | Stock | 55.137 | 55.16 | 54.97 | 55.01 | 1119787.0 |
| 2015-12-16 13:00:00 | MSFT | Stock | 55.02 | 55.13 | 54.97 | 55.09 | 1288191.0 |
| 2015-12-16 13:30:00 | MSFT | Stock | 55.09 | 55.37 | 55.05 | 55.335 | 1719242.0 |
| 2015-12-16 14:00:00 | MSFT | Stock | 55.32 | 55.49 | 54.76 | 55.33 | 3415266.0 |
| 2015-12-16 14:30:00 | MSFT | Stock | 55.325 | 55.98 | 55.17 | 55.886 | 3316615.0 |
| 2015-12-16 15:00:00 | MSFT | Stock | 55.89 | 56.09 | 55.72 | 56.06 | 3327558.0 |
> showing 50 of 84,083 rows — these rows as CSV