PREVIEW / stock_30min / 2015-10-05
file: by_date/stock_30min/2015/2015-10-05.parquet size: 1.6 MB rows: 82,341 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-10-05 04:00:00 | AAPL | Stock | 27.675 | 27.7 | 27.6675 | 27.6675 | 4024.0 |
| 2015-10-05 04:30:00 | AAPL | Stock | 27.7225 | 27.7225 | 27.7075 | 27.71 | 3000.0 |
| 2015-10-05 05:00:00 | AAPL | Stock | 27.715 | 27.7275 | 27.6575 | 27.6575 | 9104.0 |
| 2015-10-05 05:30:00 | AAPL | Stock | 27.66 | 27.745 | 27.65 | 27.745 | 6560.0 |
| 2015-10-05 06:00:00 | AAPL | Stock | 27.75 | 27.775 | 27.725 | 27.75 | 26972.0 |
| 2015-10-05 06:30:00 | AAPL | Stock | 27.75 | 27.76 | 27.7075 | 27.7075 | 38308.0 |
| 2015-10-05 07:00:00 | AAPL | Stock | 27.7125 | 27.725 | 27.675 | 27.7 | 240168.0 |
| 2015-10-05 07:30:00 | AAPL | Stock | 27.6975 | 27.6975 | 27.465 | 27.5 | 350316.0 |
| 2015-10-05 08:00:00 | AAPL | Stock | 27.5 | 27.72 | 27.4525 | 27.5 | 720100.0 |
| 2015-10-05 08:30:00 | AAPL | Stock | 27.5025 | 27.525 | 27.375 | 27.455 | 724216.0 |
| 2015-10-05 09:00:00 | AAPL | Stock | 27.4525 | 27.5 | 27.4225 | 27.465 | 730144.0 |
| 2015-10-05 09:30:00 | AAPL | Stock | 27.4675 | 27.535 | 27.285 | 27.375 | 30170208.0 |
| 2015-10-05 10:00:00 | AAPL | Stock | 27.3725 | 27.425 | 27.2675 | 27.405 | 18288456.0 |
| 2015-10-05 10:30:00 | AAPL | Stock | 27.4075 | 27.55 | 27.33 | 27.485 | 16478560.0 |
| 2015-10-05 11:00:00 | AAPL | Stock | 27.485 | 27.5875 | 27.4225 | 27.4438 | 14277280.0 |
| 2015-10-05 11:30:00 | AAPL | Stock | 27.4425 | 27.48 | 27.3788 | 27.4275 | 7888296.0 |
| 2015-10-05 12:00:00 | AAPL | Stock | 27.4275 | 27.4775 | 27.3788 | 27.4548 | 11203412.0 |
| 2015-10-05 12:30:00 | AAPL | Stock | 27.455 | 27.54 | 27.4425 | 27.4875 | 11441432.0 |
| 2015-10-05 13:00:00 | AAPL | Stock | 27.4875 | 27.6775 | 27.465 | 27.62 | 11093488.0 |
| 2015-10-05 13:30:00 | AAPL | Stock | 27.6202 | 27.7175 | 27.615 | 27.67 | 9002372.0 |
| 2015-10-05 14:00:00 | AAPL | Stock | 27.6725 | 27.735 | 27.6305 | 27.725 | 7579256.0 |
| 2015-10-05 14:30:00 | AAPL | Stock | 27.7225 | 27.8425 | 27.66 | 27.725 | 12518464.0 |
| 2015-10-05 15:00:00 | AAPL | Stock | 27.7275 | 27.77 | 27.68 | 27.7015 | 9431540.0 |
| 2015-10-05 15:30:00 | AAPL | Stock | 27.7025 | 27.7125 | 27.5625 | 27.66 | 23246516.0 |
| 2015-10-05 16:00:00 | AAPL | Stock | 27.66 | 27.695 | 27.425 | 27.6 | 10279208.0 |
| 2015-10-05 16:30:00 | AAPL | Stock | 27.5925 | 27.6 | 27.575 | 27.6 | 49880.0 |
| 2015-10-05 17:00:00 | AAPL | Stock | 27.6025 | 27.695 | 27.6 | 27.6125 | 71740.0 |
| 2015-10-05 17:30:00 | AAPL | Stock | 27.6025 | 27.615 | 27.595 | 27.6125 | 19756.0 |
| 2015-10-05 18:00:00 | AAPL | Stock | 27.615 | 27.615 | 27.595 | 27.6 | 8320.0 |
| 2015-10-05 18:30:00 | AAPL | Stock | 27.6075 | 27.6075 | 27.59 | 27.59 | 23844.0 |
| 2015-10-05 19:00:00 | AAPL | Stock | 27.6 | 27.6 | 27.5825 | 27.5825 | 19196.0 |
| 2015-10-05 19:30:00 | AAPL | Stock | 27.58 | 27.61 | 27.58 | 27.59 | 25020.0 |
| 2015-10-05 05:30:00 | MSFT | Stock | 45.72 | 45.99 | 45.72 | 45.99 | 640.0 |
| 2015-10-05 06:00:00 | MSFT | Stock | 45.99 | 46.0 | 45.9 | 45.9 | 1200.0 |
| 2015-10-05 07:00:00 | MSFT | Stock | 45.91 | 45.91 | 45.91 | 45.91 | 249.0 |
| 2015-10-05 07:30:00 | MSFT | Stock | 45.92 | 46.01 | 45.91 | 46.0 | 16974.0 |
| 2015-10-05 08:00:00 | MSFT | Stock | 45.99 | 46.1 | 45.9 | 45.9 | 12669.0 |
| 2015-10-05 08:30:00 | MSFT | Stock | 45.9 | 45.98 | 45.85 | 45.95 | 9800.0 |
| 2015-10-05 09:00:00 | MSFT | Stock | 45.95 | 45.97 | 45.7 | 45.7 | 34905.0 |
| 2015-10-05 09:30:00 | MSFT | Stock | 45.79 | 46.24 | 45.7 | 46.015 | 4206508.0 |
| 2015-10-05 10:00:00 | MSFT | Stock | 46.015 | 46.4 | 45.98 | 46.335 | 2669430.0 |
| 2015-10-05 10:30:00 | MSFT | Stock | 46.34 | 46.39 | 46.132 | 46.38 | 1754926.0 |
| 2015-10-05 11:00:00 | MSFT | Stock | 46.37 | 46.63 | 46.36 | 46.505 | 1965531.0 |
| 2015-10-05 11:30:00 | MSFT | Stock | 46.504 | 46.59 | 46.43 | 46.585 | 1237813.0 |
| 2015-10-05 12:00:00 | MSFT | Stock | 46.585 | 46.75 | 46.55 | 46.71 | 1964498.0 |
| 2015-10-05 12:30:00 | MSFT | Stock | 46.72 | 46.82 | 46.671 | 46.705 | 2110369.0 |
| 2015-10-05 13:00:00 | MSFT | Stock | 46.71 | 46.85 | 46.65 | 46.751 | 1728929.0 |
| 2015-10-05 13:30:00 | MSFT | Stock | 46.75 | 46.755 | 46.64 | 46.67 | 1396105.0 |
| 2015-10-05 14:00:00 | MSFT | Stock | 46.67 | 46.79 | 46.64 | 46.757 | 1434452.0 |
| 2015-10-05 14:30:00 | MSFT | Stock | 46.75 | 46.89 | 46.75 | 46.786 | 1589386.0 |
> showing 50 of 82,341 rows — these rows as CSV