PREVIEW / stock_30min / 2016-11-28
file: by_date/stock_30min/2016/2016-11-28.parquet size: 1.6 MB rows: 82,139 symbols: 3,161
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-11-28 04:00:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.8325 | 27.8325 | 2256.0 |
| 2016-11-28 05:00:00 | AAPL | Stock | 27.875 | 27.875 | 27.875 | 27.875 | 3976.0 |
| 2016-11-28 05:30:00 | AAPL | Stock | 27.875 | 27.875 | 27.8625 | 27.8625 | 12400.0 |
| 2016-11-28 06:00:00 | AAPL | Stock | 27.855 | 27.855 | 27.8325 | 27.8325 | 8472.0 |
| 2016-11-28 06:30:00 | AAPL | Stock | 27.8325 | 27.8325 | 27.795 | 27.8 | 6568.0 |
| 2016-11-28 07:00:00 | AAPL | Stock | 27.8375 | 27.85 | 27.835 | 27.845 | 12004.0 |
| 2016-11-28 07:30:00 | AAPL | Stock | 27.845 | 27.91 | 27.845 | 27.865 | 22104.0 |
| 2016-11-28 08:00:00 | AAPL | Stock | 27.8975 | 27.915 | 27.8625 | 27.9 | 39356.0 |
| 2016-11-28 08:30:00 | AAPL | Stock | 27.8775 | 27.8925 | 27.8775 | 27.8875 | 23540.0 |
| 2016-11-28 09:00:00 | AAPL | Stock | 27.8875 | 27.89 | 27.8475 | 27.855 | 113836.0 |
| 2016-11-28 09:30:00 | AAPL | Stock | 27.8575 | 28.0475 | 27.8475 | 28.045 | 16119336.0 |
| 2016-11-28 10:00:00 | AAPL | Stock | 28.0435 | 28.07 | 27.99 | 28.065 | 8221332.0 |
| 2016-11-28 10:30:00 | AAPL | Stock | 28.065 | 28.1162 | 27.9575 | 27.9625 | 7174600.0 |
| 2016-11-28 11:00:00 | AAPL | Stock | 27.9625 | 27.98 | 27.925 | 27.9475 | 4923884.0 |
| 2016-11-28 11:30:00 | AAPL | Stock | 27.9458 | 27.98 | 27.925 | 27.9772 | 5282396.0 |
| 2016-11-28 12:00:00 | AAPL | Stock | 27.9775 | 28.0 | 27.935 | 27.965 | 4494936.0 |
| 2016-11-28 12:30:00 | AAPL | Stock | 27.9638 | 27.9975 | 27.945 | 27.9525 | 2957360.0 |
| 2016-11-28 13:00:00 | AAPL | Stock | 27.9538 | 27.96 | 27.935 | 27.95 | 2758616.0 |
| 2016-11-28 13:30:00 | AAPL | Stock | 27.9525 | 27.99 | 27.945 | 27.965 | 3165604.0 |
| 2016-11-28 14:00:00 | AAPL | Stock | 27.965 | 27.9875 | 27.9525 | 27.954 | 3738768.0 |
| 2016-11-28 14:30:00 | AAPL | Stock | 27.9525 | 27.9625 | 27.9325 | 27.9575 | 3618712.0 |
| 2016-11-28 15:00:00 | AAPL | Stock | 27.9575 | 27.9625 | 27.888 | 27.8925 | 4471176.0 |
| 2016-11-28 15:30:00 | AAPL | Stock | 27.8932 | 27.9225 | 27.8625 | 27.895 | 10304644.0 |
| 2016-11-28 16:00:00 | AAPL | Stock | 27.8925 | 27.8975 | 27.888 | 27.8975 | 20520732.0 |
| 2016-11-28 16:30:00 | AAPL | Stock | 27.8975 | 27.8975 | 27.875 | 27.8925 | 104384.0 |
| 2016-11-28 17:00:00 | AAPL | Stock | 27.875 | 27.875 | 27.875 | 27.875 | 2000.0 |
| 2016-11-28 17:30:00 | AAPL | Stock | 27.8925 | 27.8925 | 27.875 | 27.875 | 2700.0 |
| 2016-11-28 18:00:00 | AAPL | Stock | 27.875 | 27.8875 | 27.875 | 27.8875 | 6152.0 |
| 2016-11-28 18:30:00 | AAPL | Stock | 27.875 | 27.875 | 27.875 | 27.875 | 400.0 |
| 2016-11-28 19:00:00 | AAPL | Stock | 27.8875 | 27.8875 | 27.8875 | 27.8875 | 532.0 |
| 2016-11-28 19:30:00 | AAPL | Stock | 27.88 | 27.88 | 27.875 | 27.875 | 9004.0 |
| 2016-11-28 06:30:00 | MSFT | Stock | 60.4 | 60.43 | 60.4 | 60.43 | 500.0 |
| 2016-11-28 08:00:00 | MSFT | Stock | 60.25 | 60.41 | 60.25 | 60.41 | 1000.0 |
| 2016-11-28 08:30:00 | MSFT | Stock | 60.41 | 60.41 | 60.38 | 60.38 | 1699.0 |
| 2016-11-28 09:00:00 | MSFT | Stock | 60.35 | 60.43 | 60.32 | 60.32 | 1984.0 |
| 2016-11-28 09:30:00 | MSFT | Stock | 60.34 | 60.5 | 60.21 | 60.425 | 1858303.0 |
| 2016-11-28 10:00:00 | MSFT | Stock | 60.425 | 60.56 | 60.355 | 60.556 | 1017022.0 |
| 2016-11-28 10:30:00 | MSFT | Stock | 60.55 | 60.72 | 60.55 | 60.62 | 1482185.0 |
| 2016-11-28 11:00:00 | MSFT | Stock | 60.615 | 60.8 | 60.6 | 60.795 | 1370171.0 |
| 2016-11-28 11:30:00 | MSFT | Stock | 60.8 | 60.9 | 60.77 | 60.885 | 1042389.0 |
| 2016-11-28 12:00:00 | MSFT | Stock | 60.89 | 60.94 | 60.83 | 60.875 | 730573.0 |
| 2016-11-28 12:30:00 | MSFT | Stock | 60.88 | 61.02 | 60.87 | 60.935 | 937308.0 |
| 2016-11-28 13:00:00 | MSFT | Stock | 60.93 | 60.935 | 60.74 | 60.75 | 749661.0 |
| 2016-11-28 13:30:00 | MSFT | Stock | 60.75 | 60.87 | 60.75 | 60.79 | 670309.0 |
| 2016-11-28 14:00:00 | MSFT | Stock | 60.785 | 60.81 | 60.69 | 60.697 | 664545.0 |
| 2016-11-28 14:30:00 | MSFT | Stock | 60.69 | 60.69 | 60.6 | 60.66 | 735484.0 |
| 2016-11-28 15:00:00 | MSFT | Stock | 60.66 | 60.68 | 60.505 | 60.52 | 867490.0 |
| 2016-11-28 15:30:00 | MSFT | Stock | 60.52 | 60.67 | 60.5 | 60.63 | 2381196.0 |
| 2016-11-28 16:00:00 | MSFT | Stock | 60.61 | 60.61 | 60.61 | 60.61 | 4960844.0 |
| 2016-11-28 17:30:00 | MSFT | Stock | 60.61 | 60.62 | 60.61 | 60.62 | 10007.0 |
> showing 50 of 82,139 rows — these rows as CSV