PREVIEW / stock_30min / 2017-11-08
file: by_date/stock_30min/2017/2017-11-08.parquet size: 1.6 MB rows: 82,863 symbols: 2,932
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-08 04:00:00 | AAPL | Stock | 43.6 | 43.6 | 43.6 | 43.6 | 800.0 |
| 2017-11-08 04:30:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 792.0 |
| 2017-11-08 05:00:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.5925 | 43.5925 | 1596.0 |
| 2017-11-08 05:30:00 | AAPL | Stock | 43.55 | 43.5925 | 43.55 | 43.5875 | 13924.0 |
| 2017-11-08 06:00:00 | AAPL | Stock | 43.5875 | 43.625 | 43.575 | 43.625 | 18780.0 |
| 2017-11-08 07:00:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.595 | 43.6 | 34060.0 |
| 2017-11-08 07:30:00 | AAPL | Stock | 43.59 | 43.6225 | 43.5625 | 43.575 | 89988.0 |
| 2017-11-08 08:00:00 | AAPL | Stock | 43.6125 | 43.6175 | 43.575 | 43.6125 | 123500.0 |
| 2017-11-08 08:30:00 | AAPL | Stock | 43.6125 | 43.62 | 43.6 | 43.6 | 73528.0 |
| 2017-11-08 09:00:00 | AAPL | Stock | 43.605 | 43.685 | 43.6 | 43.6675 | 241820.0 |
| 2017-11-08 09:30:00 | AAPL | Stock | 43.67 | 43.7575 | 43.5825 | 43.6525 | 13228972.0 |
| 2017-11-08 10:00:00 | AAPL | Stock | 43.6525 | 43.81 | 43.6525 | 43.78 | 9132944.0 |
| 2017-11-08 10:30:00 | AAPL | Stock | 43.7812 | 43.845 | 43.7175 | 43.81 | 5190656.0 |
| 2017-11-08 11:00:00 | AAPL | Stock | 43.8125 | 43.875 | 43.775 | 43.8128 | 5486504.0 |
| 2017-11-08 11:30:00 | AAPL | Stock | 43.8125 | 43.945 | 43.775 | 43.8575 | 4387296.0 |
| 2017-11-08 12:00:00 | AAPL | Stock | 43.858 | 43.9175 | 43.85 | 43.902 | 4899856.0 |
| 2017-11-08 12:30:00 | AAPL | Stock | 43.9 | 43.9115 | 43.83 | 43.8907 | 3965144.0 |
| 2017-11-08 13:00:00 | AAPL | Stock | 43.8925 | 43.9475 | 43.8725 | 43.933 | 4436868.0 |
| 2017-11-08 13:30:00 | AAPL | Stock | 43.9328 | 43.94 | 43.885 | 43.935 | 3111588.0 |
| 2017-11-08 14:00:00 | AAPL | Stock | 43.9338 | 44.0 | 43.905 | 43.9938 | 4379688.0 |
| 2017-11-08 14:30:00 | AAPL | Stock | 43.995 | 44.0075 | 43.9575 | 43.995 | 4244168.0 |
| 2017-11-08 15:00:00 | AAPL | Stock | 43.9925 | 44.05 | 43.975 | 43.997 | 4563980.0 |
| 2017-11-08 15:30:00 | AAPL | Stock | 43.9968 | 44.06 | 43.9525 | 44.06 | 7923920.0 |
| 2017-11-08 16:00:00 | AAPL | Stock | 44.06 | 44.06 | 43.8858 | 44.025 | 10433808.0 |
| 2017-11-08 16:30:00 | AAPL | Stock | 44.0375 | 44.1875 | 44.035 | 44.165 | 198864.0 |
| 2017-11-08 17:00:00 | AAPL | Stock | 44.1825 | 44.275 | 44.1625 | 44.2125 | 178060.0 |
| 2017-11-08 17:30:00 | AAPL | Stock | 44.185 | 44.2225 | 44.145 | 44.1525 | 50896.0 |
| 2017-11-08 18:00:00 | AAPL | Stock | 44.145 | 44.175 | 44.1375 | 44.14 | 24764.0 |
| 2017-11-08 18:30:00 | AAPL | Stock | 44.16 | 44.16 | 44.1375 | 44.15 | 18536.0 |
| 2017-11-08 19:00:00 | AAPL | Stock | 44.1575 | 44.18 | 44.14 | 44.1675 | 42480.0 |
| 2017-11-08 19:30:00 | AAPL | Stock | 44.1575 | 44.2 | 44.1575 | 44.1875 | 42628.0 |
| 2017-11-08 04:00:00 | MSFT | Stock | 84.25 | 84.25 | 84.2 | 84.2 | 300.0 |
| 2017-11-08 04:30:00 | MSFT | Stock | 84.25 | 84.25 | 84.25 | 84.25 | 100.0 |
| 2017-11-08 05:30:00 | MSFT | Stock | 84.24 | 84.24 | 84.24 | 84.24 | 100.0 |
| 2017-11-08 08:30:00 | MSFT | Stock | 84.16 | 84.18 | 84.16 | 84.18 | 590.0 |
| 2017-11-08 09:00:00 | MSFT | Stock | 84.15 | 84.2 | 84.14 | 84.17 | 3733.0 |
| 2017-11-08 09:30:00 | MSFT | Stock | 84.16 | 84.35 | 83.83 | 83.98 | 1684121.0 |
| 2017-11-08 10:00:00 | MSFT | Stock | 83.98 | 84.11 | 83.91 | 83.955 | 803315.0 |
| 2017-11-08 10:30:00 | MSFT | Stock | 83.95 | 84.17 | 83.91 | 84.14 | 794752.0 |
| 2017-11-08 11:00:00 | MSFT | Stock | 84.13 | 84.35 | 84.13 | 84.23 | 904760.0 |
| 2017-11-08 11:30:00 | MSFT | Stock | 84.23 | 84.23 | 84.06 | 84.13 | 507553.0 |
| 2017-11-08 12:00:00 | MSFT | Stock | 84.135 | 84.16 | 83.87 | 83.94 | 865104.0 |
| 2017-11-08 12:30:00 | MSFT | Stock | 83.93 | 84.215 | 83.93 | 84.21 | 526910.0 |
| 2017-11-08 13:00:00 | MSFT | Stock | 84.21 | 84.31 | 84.2 | 84.27 | 651584.0 |
| 2017-11-08 13:30:00 | MSFT | Stock | 84.27 | 84.39 | 84.22 | 84.38 | 506338.0 |
| 2017-11-08 14:00:00 | MSFT | Stock | 84.379 | 84.495 | 84.34 | 84.455 | 574994.0 |
| 2017-11-08 14:30:00 | MSFT | Stock | 84.46 | 84.49 | 84.37 | 84.455 | 672910.0 |
| 2017-11-08 15:00:00 | MSFT | Stock | 84.45 | 84.53 | 84.42 | 84.515 | 728999.0 |
| 2017-11-08 15:30:00 | MSFT | Stock | 84.515 | 84.61 | 84.37 | 84.57 | 2041987.0 |
| 2017-11-08 16:00:00 | MSFT | Stock | 84.57 | 84.75 | 84.339 | 84.7 | 5093552.0 |
> showing 50 of 82,863 rows — these rows as CSV