PREVIEW / stock_30min / 2016-03-08
file: by_date/stock_30min/2016/2016-03-08.parquet size: 1.6 MB rows: 82,405 symbols: 3,338
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-03-08 04:00:00 | AAPL | Stock | 25.395 | 25.395 | 25.195 | 25.25 | 7040.0 |
| 2016-03-08 04:30:00 | AAPL | Stock | 25.2375 | 25.2375 | 25.2375 | 25.2375 | 3396.0 |
| 2016-03-08 05:00:00 | AAPL | Stock | 25.195 | 25.195 | 25.1675 | 25.1675 | 7052.0 |
| 2016-03-08 05:30:00 | AAPL | Stock | 25.195 | 25.195 | 25.195 | 25.195 | 1600.0 |
| 2016-03-08 06:00:00 | AAPL | Stock | 25.165 | 25.165 | 25.075 | 25.1625 | 22568.0 |
| 2016-03-08 06:30:00 | AAPL | Stock | 25.1625 | 25.175 | 25.16 | 25.1725 | 24292.0 |
| 2016-03-08 07:00:00 | AAPL | Stock | 25.175 | 25.3 | 25.17 | 25.2725 | 96392.0 |
| 2016-03-08 07:30:00 | AAPL | Stock | 25.2675 | 25.3225 | 25.2675 | 25.305 | 11312.0 |
| 2016-03-08 08:00:00 | AAPL | Stock | 25.305 | 25.32 | 25.1625 | 25.275 | 262852.0 |
| 2016-03-08 08:30:00 | AAPL | Stock | 25.28 | 25.3225 | 25.2675 | 25.3 | 111800.0 |
| 2016-03-08 09:00:00 | AAPL | Stock | 25.3 | 25.3 | 25.195 | 25.195 | 257856.0 |
| 2016-03-08 09:30:00 | AAPL | Stock | 25.195 | 25.2775 | 25.1 | 25.225 | 16360640.0 |
| 2016-03-08 10:00:00 | AAPL | Stock | 25.2225 | 25.3025 | 25.19 | 25.235 | 9129168.0 |
| 2016-03-08 10:30:00 | AAPL | Stock | 25.2375 | 25.2725 | 25.1675 | 25.21 | 8295748.0 |
| 2016-03-08 11:00:00 | AAPL | Stock | 25.215 | 25.3725 | 25.1985 | 25.34 | 10020004.0 |
| 2016-03-08 11:30:00 | AAPL | Stock | 25.34 | 25.375 | 25.2925 | 25.36 | 7030432.0 |
| 2016-03-08 12:00:00 | AAPL | Stock | 25.36 | 25.44 | 25.3 | 25.395 | 5738064.0 |
| 2016-03-08 12:30:00 | AAPL | Stock | 25.3975 | 25.43 | 25.3298 | 25.36 | 4975168.0 |
| 2016-03-08 13:00:00 | AAPL | Stock | 25.3612 | 25.385 | 25.2815 | 25.3565 | 5078940.0 |
| 2016-03-08 13:30:00 | AAPL | Stock | 25.355 | 25.415 | 25.3362 | 25.3775 | 3988580.0 |
| 2016-03-08 14:00:00 | AAPL | Stock | 25.375 | 25.3925 | 25.275 | 25.2925 | 5465636.0 |
| 2016-03-08 14:30:00 | AAPL | Stock | 25.2925 | 25.3568 | 25.24 | 25.2952 | 7436652.0 |
| 2016-03-08 15:00:00 | AAPL | Stock | 25.295 | 25.3472 | 25.27 | 25.305 | 7371696.0 |
| 2016-03-08 15:30:00 | AAPL | Stock | 25.305 | 25.3775 | 25.205 | 25.26 | 16137616.0 |
| 2016-03-08 16:00:00 | AAPL | Stock | 25.2575 | 25.2875 | 25.2425 | 25.275 | 8493956.0 |
| 2016-03-08 16:30:00 | AAPL | Stock | 25.27 | 25.27 | 25.25 | 25.25 | 41668.0 |
| 2016-03-08 17:00:00 | AAPL | Stock | 25.25 | 25.2525 | 25.2475 | 25.2525 | 23180.0 |
| 2016-03-08 17:30:00 | AAPL | Stock | 25.2525 | 25.2575 | 25.245 | 25.245 | 6800.0 |
| 2016-03-08 18:00:00 | AAPL | Stock | 25.25 | 25.2575 | 25.25 | 25.25 | 7200.0 |
| 2016-03-08 18:30:00 | AAPL | Stock | 25.245 | 25.25 | 25.225 | 25.2475 | 14132.0 |
| 2016-03-08 19:00:00 | AAPL | Stock | 25.24 | 25.24 | 25.2175 | 25.2175 | 7776.0 |
| 2016-03-08 19:30:00 | AAPL | Stock | 25.255 | 25.2625 | 25.255 | 25.26 | 9092.0 |
| 2016-03-08 06:00:00 | MSFT | Stock | 50.98 | 51.15 | 50.98 | 51.15 | 8717.0 |
| 2016-03-08 07:00:00 | MSFT | Stock | 51.02 | 51.03 | 50.93 | 50.93 | 300.0 |
| 2016-03-08 07:30:00 | MSFT | Stock | 50.9 | 50.9 | 50.9 | 50.9 | 3500.0 |
| 2016-03-08 08:00:00 | MSFT | Stock | 50.99 | 51.03 | 50.73 | 50.73 | 177649.0 |
| 2016-03-08 08:30:00 | MSFT | Stock | 50.73 | 50.97 | 50.73 | 50.97 | 915.0 |
| 2016-03-08 09:00:00 | MSFT | Stock | 50.96 | 50.97 | 50.75 | 50.96 | 10600.0 |
| 2016-03-08 09:30:00 | MSFT | Stock | 51.0 | 51.63 | 50.595 | 51.506 | 4338879.0 |
| 2016-03-08 10:00:00 | MSFT | Stock | 51.5 | 51.75 | 51.24 | 51.242 | 2738692.0 |
| 2016-03-08 10:30:00 | MSFT | Stock | 51.243 | 51.45 | 51.19 | 51.4 | 1317620.0 |
| 2016-03-08 11:00:00 | MSFT | Stock | 51.4 | 51.59 | 51.3 | 51.51 | 1792932.0 |
| 2016-03-08 11:30:00 | MSFT | Stock | 51.51 | 51.8 | 51.42 | 51.78 | 1669353.0 |
| 2016-03-08 12:00:00 | MSFT | Stock | 51.78 | 52.02 | 51.74 | 51.976 | 2016739.0 |
| 2016-03-08 12:30:00 | MSFT | Stock | 51.98 | 52.08 | 51.81 | 51.83 | 1803911.0 |
| 2016-03-08 13:00:00 | MSFT | Stock | 51.83 | 52.07 | 51.82 | 52.07 | 1462416.0 |
| 2016-03-08 13:30:00 | MSFT | Stock | 52.07 | 52.13 | 52.035 | 52.07 | 1103951.0 |
| 2016-03-08 14:00:00 | MSFT | Stock | 52.06 | 52.09 | 51.78 | 51.81 | 1248909.0 |
| 2016-03-08 14:30:00 | MSFT | Stock | 51.8 | 51.95 | 51.745 | 51.8 | 1109200.0 |
| 2016-03-08 15:00:00 | MSFT | Stock | 51.795 | 51.89 | 51.635 | 51.74 | 1885583.0 |
> showing 50 of 82,405 rows — these rows as CSV