PREVIEW / stock_30min / 2015-12-07
file: by_date/stock_30min/2015/2015-12-07.parquet size: 1.6 MB rows: 83,696 symbols: 3,420
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-07 04:00:00 | AAPL | Stock | 29.81 | 29.88 | 29.81 | 29.88 | 17752.0 |
| 2015-12-07 04:30:00 | AAPL | Stock | 29.825 | 29.86 | 29.825 | 29.86 | 11600.0 |
| 2015-12-07 05:00:00 | AAPL | Stock | 29.8375 | 29.8375 | 29.8375 | 29.8375 | 4000.0 |
| 2015-12-07 05:30:00 | AAPL | Stock | 29.8775 | 29.8775 | 29.8525 | 29.8525 | 2288.0 |
| 2015-12-07 06:00:00 | AAPL | Stock | 29.8325 | 29.84 | 29.825 | 29.825 | 15880.0 |
| 2015-12-07 06:30:00 | AAPL | Stock | 29.825 | 29.8375 | 29.815 | 29.8375 | 6000.0 |
| 2015-12-07 07:00:00 | AAPL | Stock | 29.815 | 29.8325 | 29.78 | 29.7875 | 108468.0 |
| 2015-12-07 07:30:00 | AAPL | Stock | 29.805 | 29.805 | 29.78 | 29.7975 | 16332.0 |
| 2015-12-07 08:00:00 | AAPL | Stock | 29.7875 | 29.82 | 29.7025 | 29.7125 | 250508.0 |
| 2015-12-07 08:30:00 | AAPL | Stock | 29.7125 | 29.73 | 29.705 | 29.725 | 129720.0 |
| 2015-12-07 09:00:00 | AAPL | Stock | 29.7225 | 29.78 | 29.715 | 29.7325 | 220512.0 |
| 2015-12-07 09:30:00 | AAPL | Stock | 29.735 | 29.965 | 29.6325 | 29.782 | 24534040.0 |
| 2015-12-07 10:00:00 | AAPL | Stock | 29.7825 | 29.8375 | 29.66 | 29.724 | 12137572.0 |
| 2015-12-07 10:30:00 | AAPL | Stock | 29.725 | 29.7252 | 29.58 | 29.6325 | 9807936.0 |
| 2015-12-07 11:00:00 | AAPL | Stock | 29.6275 | 29.665 | 29.5025 | 29.5225 | 7648592.0 |
| 2015-12-07 11:30:00 | AAPL | Stock | 29.52 | 29.634 | 29.515 | 29.5962 | 5849552.0 |
| 2015-12-07 12:00:00 | AAPL | Stock | 29.595 | 29.595 | 29.5125 | 29.53 | 5194208.0 |
| 2015-12-07 12:30:00 | AAPL | Stock | 29.5275 | 29.5575 | 29.495 | 29.51 | 4797752.0 |
| 2015-12-07 13:00:00 | AAPL | Stock | 29.51 | 29.5775 | 29.4975 | 29.553 | 5257292.0 |
| 2015-12-07 13:30:00 | AAPL | Stock | 29.5525 | 29.575 | 29.5 | 29.5675 | 5023428.0 |
| 2015-12-07 14:00:00 | AAPL | Stock | 29.5675 | 29.625 | 29.516 | 29.5475 | 4977052.0 |
| 2015-12-07 14:30:00 | AAPL | Stock | 29.5485 | 29.57 | 29.485 | 29.51 | 7565644.0 |
| 2015-12-07 15:00:00 | AAPL | Stock | 29.51 | 29.565 | 29.4525 | 29.5425 | 7209600.0 |
| 2015-12-07 15:30:00 | AAPL | Stock | 29.5425 | 29.62 | 29.5175 | 29.5675 | 12541712.0 |
| 2015-12-07 16:00:00 | AAPL | Stock | 29.57 | 29.61 | 29.5345 | 29.5975 | 6254732.0 |
| 2015-12-07 16:30:00 | AAPL | Stock | 29.5975 | 29.62 | 29.595 | 29.6 | 60056.0 |
| 2015-12-07 17:00:00 | AAPL | Stock | 29.6 | 29.6125 | 29.6 | 29.605 | 5304.0 |
| 2015-12-07 17:30:00 | AAPL | Stock | 29.6 | 29.6125 | 29.595 | 29.5975 | 11740.0 |
| 2015-12-07 18:00:00 | AAPL | Stock | 29.605 | 29.605 | 29.595 | 29.6 | 10700.0 |
| 2015-12-07 18:30:00 | AAPL | Stock | 29.595 | 29.6 | 29.595 | 29.595 | 6460.0 |
| 2015-12-07 19:00:00 | AAPL | Stock | 29.59 | 29.59 | 29.5725 | 29.5825 | 14000.0 |
| 2015-12-07 19:30:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.5625 | 29.565 | 14460.0 |
| 2015-12-07 04:00:00 | MSFT | Stock | 55.99 | 55.99 | 55.99 | 55.99 | 500.0 |
| 2015-12-07 05:30:00 | MSFT | Stock | 56.0 | 56.0 | 56.0 | 56.0 | 300.0 |
| 2015-12-07 06:30:00 | MSFT | Stock | 55.98 | 55.98 | 55.81 | 55.97 | 500.0 |
| 2015-12-07 07:00:00 | MSFT | Stock | 55.95 | 56.02 | 55.95 | 56.02 | 2830.0 |
| 2015-12-07 07:30:00 | MSFT | Stock | 56.08 | 56.08 | 56.0 | 56.0 | 1850.0 |
| 2015-12-07 08:00:00 | MSFT | Stock | 56.0 | 56.08 | 55.81 | 55.87 | 10055.0 |
| 2015-12-07 08:30:00 | MSFT | Stock | 55.87 | 55.9 | 55.75 | 55.79 | 3562.0 |
| 2015-12-07 09:00:00 | MSFT | Stock | 55.76 | 55.88 | 55.73 | 55.74 | 31983.0 |
| 2015-12-07 09:30:00 | MSFT | Stock | 55.79 | 55.79 | 55.32 | 55.51 | 3338231.0 |
| 2015-12-07 10:00:00 | MSFT | Stock | 55.5 | 55.62 | 55.43 | 55.565 | 2444331.0 |
| 2015-12-07 10:30:00 | MSFT | Stock | 55.56 | 55.64 | 55.44 | 55.58 | 2073871.0 |
| 2015-12-07 11:00:00 | MSFT | Stock | 55.57 | 55.59 | 55.335 | 55.35 | 1535985.0 |
| 2015-12-07 11:30:00 | MSFT | Stock | 55.35 | 55.61 | 55.35 | 55.54 | 1553626.0 |
| 2015-12-07 12:00:00 | MSFT | Stock | 55.53 | 55.6 | 55.47 | 55.535 | 907605.0 |
| 2015-12-07 12:30:00 | MSFT | Stock | 55.53 | 55.55 | 55.34 | 55.37 | 1173881.0 |
| 2015-12-07 13:00:00 | MSFT | Stock | 55.36 | 55.61 | 55.29 | 55.577 | 1573212.0 |
| 2015-12-07 13:30:00 | MSFT | Stock | 55.57 | 55.61 | 55.43 | 55.57 | 1249711.0 |
| 2015-12-07 14:00:00 | MSFT | Stock | 55.57 | 55.795 | 55.54 | 55.7 | 1652245.0 |
> showing 50 of 83,696 rows — these rows as CSV