PREVIEW / stock_30min / 2014-10-29
file: by_date/stock_30min/2014/2014-10-29.parquet size: 1.6 MB rows: 82,729 symbols: 3,550
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-29 04:00:00 | AAPL | Stock | 26.62 | 26.6875 | 26.62 | 26.65 | 5508.0 |
| 2014-10-29 05:00:00 | AAPL | Stock | 26.6875 | 26.69 | 26.6775 | 26.69 | 15232.0 |
| 2014-10-29 05:30:00 | AAPL | Stock | 26.675 | 26.7 | 26.675 | 26.7 | 20524.0 |
| 2014-10-29 06:00:00 | AAPL | Stock | 26.7 | 26.7125 | 26.685 | 26.7125 | 38044.0 |
| 2014-10-29 06:30:00 | AAPL | Stock | 26.71 | 26.71 | 26.6725 | 26.675 | 19112.0 |
| 2014-10-29 07:00:00 | AAPL | Stock | 26.675 | 26.685 | 26.65 | 26.675 | 40920.0 |
| 2014-10-29 07:30:00 | AAPL | Stock | 26.655 | 26.6625 | 26.645 | 26.6475 | 48808.0 |
| 2014-10-29 08:00:00 | AAPL | Stock | 26.655 | 26.8175 | 26.645 | 26.675 | 354064.0 |
| 2014-10-29 08:30:00 | AAPL | Stock | 26.675 | 26.6825 | 26.6525 | 26.6525 | 131476.0 |
| 2014-10-29 09:00:00 | AAPL | Stock | 26.6525 | 26.6875 | 26.6475 | 26.6675 | 240032.0 |
| 2014-10-29 09:30:00 | AAPL | Stock | 26.6625 | 26.8075 | 26.6625 | 26.7225 | 22681536.0 |
| 2014-10-29 10:00:00 | AAPL | Stock | 26.7225 | 26.7725 | 26.69 | 26.7512 | 12242040.0 |
| 2014-10-29 10:30:00 | AAPL | Stock | 26.75 | 26.7975 | 26.75 | 26.79 | 11020328.0 |
| 2014-10-29 11:00:00 | AAPL | Stock | 26.7925 | 26.835 | 26.775 | 26.7815 | 10277584.0 |
| 2014-10-29 11:30:00 | AAPL | Stock | 26.78 | 26.795 | 26.7575 | 26.7875 | 6765496.0 |
| 2014-10-29 12:00:00 | AAPL | Stock | 26.7865 | 26.79 | 26.675 | 26.6838 | 8642928.0 |
| 2014-10-29 12:30:00 | AAPL | Stock | 26.6825 | 26.7075 | 26.6275 | 26.655 | 8723784.0 |
| 2014-10-29 13:00:00 | AAPL | Stock | 26.6575 | 26.7325 | 26.6575 | 26.7288 | 6085712.0 |
| 2014-10-29 13:30:00 | AAPL | Stock | 26.7225 | 26.7325 | 26.645 | 26.72 | 6539820.0 |
| 2014-10-29 14:00:00 | AAPL | Stock | 26.7198 | 26.775 | 26.59 | 26.77 | 16462588.0 |
| 2014-10-29 14:30:00 | AAPL | Stock | 26.7675 | 26.815 | 26.715 | 26.8038 | 11500568.0 |
| 2014-10-29 15:00:00 | AAPL | Stock | 26.8025 | 26.815 | 26.7312 | 26.795 | 11088528.0 |
| 2014-10-29 15:30:00 | AAPL | Stock | 26.7975 | 26.8425 | 26.785 | 26.835 | 16641188.0 |
| 2014-10-29 16:00:00 | AAPL | Stock | 26.835 | 26.8375 | 26.7468 | 26.8075 | 44010876.0 |
| 2014-10-29 16:30:00 | AAPL | Stock | 26.8025 | 26.835 | 26.6772 | 26.805 | 357576.0 |
| 2014-10-29 17:00:00 | AAPL | Stock | 26.7975 | 26.835 | 26.79 | 26.795 | 26960.0 |
| 2014-10-29 17:30:00 | AAPL | Stock | 26.795 | 26.8025 | 26.7702 | 26.79 | 120072.0 |
| 2014-10-29 18:00:00 | AAPL | Stock | 26.79 | 26.8025 | 26.72 | 26.755 | 302332.0 |
| 2014-10-29 18:30:00 | AAPL | Stock | 26.7725 | 26.835 | 26.7725 | 26.8 | 77560.0 |
| 2014-10-29 19:00:00 | AAPL | Stock | 26.8 | 26.8 | 26.775 | 26.775 | 20840.0 |
| 2014-10-29 19:30:00 | AAPL | Stock | 26.775 | 26.795 | 26.7625 | 26.7875 | 31472.0 |
| 2014-10-29 05:30:00 | MSFT | Stock | 46.48 | 46.48 | 46.38 | 46.38 | 700.0 |
| 2014-10-29 07:00:00 | MSFT | Stock | 46.4 | 46.4 | 46.38 | 46.38 | 3000.0 |
| 2014-10-29 08:00:00 | MSFT | Stock | 46.38 | 46.52 | 46.38 | 46.43 | 8602.0 |
| 2014-10-29 08:30:00 | MSFT | Stock | 46.44 | 46.44 | 46.44 | 46.44 | 100.0 |
| 2014-10-29 09:00:00 | MSFT | Stock | 46.44 | 46.49 | 46.43 | 46.45 | 17277.0 |
| 2014-10-29 09:30:00 | MSFT | Stock | 46.44 | 46.58 | 46.37 | 46.51 | 2973723.0 |
| 2014-10-29 10:00:00 | MSFT | Stock | 46.51 | 46.58 | 46.44 | 46.525 | 1445140.0 |
| 2014-10-29 10:30:00 | MSFT | Stock | 46.525 | 46.55 | 46.41 | 46.46 | 1595747.0 |
| 2014-10-29 11:00:00 | MSFT | Stock | 46.465 | 46.51 | 46.36 | 46.41 | 1518426.0 |
| 2014-10-29 11:30:00 | MSFT | Stock | 46.41 | 46.54 | 46.41 | 46.51 | 2158218.0 |
| 2014-10-29 12:00:00 | MSFT | Stock | 46.505 | 46.56 | 46.445 | 46.485 | 1656942.0 |
| 2014-10-29 12:30:00 | MSFT | Stock | 46.49 | 46.565 | 46.48 | 46.545 | 1126891.0 |
| 2014-10-29 13:00:00 | MSFT | Stock | 46.545 | 46.66 | 46.53 | 46.65 | 1031672.0 |
| 2014-10-29 13:30:00 | MSFT | Stock | 46.66 | 46.67 | 46.49 | 46.66 | 1434715.0 |
| 2014-10-29 14:00:00 | MSFT | Stock | 46.66 | 46.7 | 46.34 | 46.51 | 3351090.0 |
| 2014-10-29 14:30:00 | MSFT | Stock | 46.5 | 46.555 | 46.38 | 46.545 | 2169895.0 |
| 2014-10-29 15:00:00 | MSFT | Stock | 46.54 | 46.555 | 46.39 | 46.53 | 2093542.0 |
| 2014-10-29 15:30:00 | MSFT | Stock | 46.53 | 46.69 | 46.525 | 46.63 | 4573559.0 |
| 2014-10-29 16:00:00 | MSFT | Stock | 46.62 | 46.62 | 46.525 | 46.62 | 1983920.0 |
> showing 50 of 82,729 rows — these rows as CSV