PREVIEW / stock_30min / 2015-08-03
file: by_date/stock_30min/2015/2015-08-03.parquet size: 1.6 MB rows: 81,814 symbols: 3,466
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-08-03 04:00:00 | AAPL | Stock | 30.3475 | 30.3725 | 30.325 | 30.325 | 54876.0 |
| 2015-08-03 04:30:00 | AAPL | Stock | 30.305 | 30.3075 | 30.305 | 30.3075 | 2960.0 |
| 2015-08-03 05:00:00 | AAPL | Stock | 30.305 | 30.3075 | 30.3025 | 30.3025 | 6400.0 |
| 2015-08-03 05:30:00 | AAPL | Stock | 30.25 | 30.305 | 30.25 | 30.305 | 7600.0 |
| 2015-08-03 06:00:00 | AAPL | Stock | 30.305 | 30.345 | 30.295 | 30.295 | 8772.0 |
| 2015-08-03 06:30:00 | AAPL | Stock | 30.3175 | 30.3625 | 30.3175 | 30.3625 | 45916.0 |
| 2015-08-03 07:00:00 | AAPL | Stock | 30.3625 | 30.4225 | 30.35 | 30.4175 | 73200.0 |
| 2015-08-03 07:30:00 | AAPL | Stock | 30.3925 | 30.4175 | 30.37 | 30.41 | 39564.0 |
| 2015-08-03 08:00:00 | AAPL | Stock | 30.4 | 30.415 | 30.355 | 30.365 | 371664.0 |
| 2015-08-03 08:30:00 | AAPL | Stock | 30.3625 | 30.3725 | 30.35 | 30.365 | 89460.0 |
| 2015-08-03 09:00:00 | AAPL | Stock | 30.3575 | 30.38 | 30.35 | 30.375 | 169064.0 |
| 2015-08-03 09:30:00 | AAPL | Stock | 30.375 | 30.6425 | 30.2625 | 30.4425 | 29853668.0 |
| 2015-08-03 10:00:00 | AAPL | Stock | 30.4475 | 30.5 | 30.1938 | 30.255 | 17365168.0 |
| 2015-08-03 10:30:00 | AAPL | Stock | 30.2575 | 30.26 | 30.1325 | 30.1625 | 12497328.0 |
| 2015-08-03 11:00:00 | AAPL | Stock | 30.1625 | 30.295 | 30.1625 | 30.2488 | 9710472.0 |
| 2015-08-03 11:30:00 | AAPL | Stock | 30.25 | 30.28 | 30.0825 | 30.1225 | 9962816.0 |
| 2015-08-03 12:00:00 | AAPL | Stock | 30.125 | 30.1375 | 29.9525 | 30.0442 | 20121252.0 |
| 2015-08-03 12:30:00 | AAPL | Stock | 30.0425 | 30.045 | 29.38 | 29.5 | 35832892.0 |
| 2015-08-03 13:00:00 | AAPL | Stock | 29.502 | 29.6125 | 29.4025 | 29.59 | 29965896.0 |
| 2015-08-03 13:30:00 | AAPL | Stock | 29.59 | 29.71 | 29.55 | 29.6825 | 17772888.0 |
| 2015-08-03 14:00:00 | AAPL | Stock | 29.6825 | 29.6825 | 29.5825 | 29.6588 | 13211176.0 |
| 2015-08-03 14:30:00 | AAPL | Stock | 29.6575 | 29.7025 | 29.6175 | 29.685 | 12193632.0 |
| 2015-08-03 15:00:00 | AAPL | Stock | 29.6825 | 29.7175 | 29.465 | 29.5092 | 16944604.0 |
| 2015-08-03 15:30:00 | AAPL | Stock | 29.51 | 29.6125 | 29.47 | 29.6125 | 27777200.0 |
| 2015-08-03 16:00:00 | AAPL | Stock | 29.61 | 29.873 | 29.5675 | 29.873 | 6888140.0 |
| 2015-08-03 16:30:00 | AAPL | Stock | 29.58 | 30.3125 | 29.575 | 29.6 | 244920.0 |
| 2015-08-03 17:00:00 | AAPL | Stock | 29.6 | 29.605 | 29.55 | 29.55 | 144768.0 |
| 2015-08-03 17:30:00 | AAPL | Stock | 29.525 | 29.5475 | 29.3875 | 29.4 | 533272.0 |
| 2015-08-03 18:00:00 | AAPL | Stock | 29.4125 | 29.4975 | 29.4008 | 29.47 | 234688.0 |
| 2015-08-03 18:30:00 | AAPL | Stock | 29.47 | 29.47 | 29.4375 | 29.46 | 62192.0 |
| 2015-08-03 19:00:00 | AAPL | Stock | 29.4525 | 29.4625 | 29.445 | 29.46 | 39596.0 |
| 2015-08-03 19:30:00 | AAPL | Stock | 29.455 | 29.455 | 29.425 | 29.44 | 126296.0 |
| 2015-08-03 04:00:00 | MSFT | Stock | 46.76 | 46.77 | 46.76 | 46.77 | 350.0 |
| 2015-08-03 06:00:00 | MSFT | Stock | 46.71 | 46.71 | 46.71 | 46.71 | 250.0 |
| 2015-08-03 08:00:00 | MSFT | Stock | 46.71 | 46.8 | 46.7 | 46.8 | 3358.0 |
| 2015-08-03 08:30:00 | MSFT | Stock | 46.8 | 46.8 | 46.8 | 46.8 | 3500.0 |
| 2015-08-03 09:00:00 | MSFT | Stock | 46.7 | 47.0 | 46.7 | 46.99 | 8679.0 |
| 2015-08-03 09:30:00 | MSFT | Stock | 46.98 | 47.0 | 46.45 | 46.83 | 2570901.0 |
| 2015-08-03 10:00:00 | MSFT | Stock | 46.83 | 46.83 | 46.611 | 46.66 | 1962370.0 |
| 2015-08-03 10:30:00 | MSFT | Stock | 46.65 | 46.68 | 46.525 | 46.635 | 1767886.0 |
| 2015-08-03 11:00:00 | MSFT | Stock | 46.634 | 46.87 | 46.61 | 46.87 | 1600955.0 |
| 2015-08-03 11:30:00 | MSFT | Stock | 46.86 | 46.99 | 46.85 | 46.94 | 1889380.0 |
| 2015-08-03 12:00:00 | MSFT | Stock | 46.95 | 46.98 | 46.92 | 46.94 | 1204080.0 |
| 2015-08-03 12:30:00 | MSFT | Stock | 46.93 | 46.935 | 46.61 | 46.685 | 1739714.0 |
| 2015-08-03 13:00:00 | MSFT | Stock | 46.68 | 46.7 | 46.51 | 46.595 | 1906080.0 |
| 2015-08-03 13:30:00 | MSFT | Stock | 46.6 | 46.68 | 46.54 | 46.543 | 1526036.0 |
| 2015-08-03 14:00:00 | MSFT | Stock | 46.54 | 46.61 | 46.47 | 46.58 | 1097963.0 |
| 2015-08-03 14:30:00 | MSFT | Stock | 46.585 | 46.67 | 46.505 | 46.57 | 1127986.0 |
| 2015-08-03 15:00:00 | MSFT | Stock | 46.57 | 46.61 | 46.49 | 46.6 | 1242464.0 |
| 2015-08-03 15:30:00 | MSFT | Stock | 46.6 | 46.82 | 46.54 | 46.81 | 2250898.0 |
> showing 50 of 81,814 rows — these rows as CSV