PREVIEW / stock_30min / 2016-11-25
file: by_date/stock_30min/2016/2016-11-25.parquet size: 1.0 MB rows: 47,660 symbols: 3,084
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-25 04:00:00 | AAPL | Stock | 27.6775 | 27.6775 | 27.6775 | 27.6775 | 400.0 |
| 2016-11-25 04:30:00 | AAPL | Stock | 27.6125 | 27.7 | 27.6125 | 27.7 | 1600.0 |
| 2016-11-25 06:00:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 1920.0 |
| 2016-11-25 06:30:00 | AAPL | Stock | 27.7425 | 27.7425 | 27.7425 | 27.7425 | 1760.0 |
| 2016-11-25 07:00:00 | AAPL | Stock | 27.745 | 27.75 | 27.745 | 27.75 | 3016.0 |
| 2016-11-25 07:30:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.76 | 27.76 | 5352.0 |
| 2016-11-25 08:00:00 | AAPL | Stock | 27.78 | 27.8 | 27.775 | 27.8 | 24136.0 |
| 2016-11-25 08:30:00 | AAPL | Stock | 27.7975 | 27.8 | 27.775 | 27.7825 | 31672.0 |
| 2016-11-25 09:00:00 | AAPL | Stock | 27.7875 | 27.8425 | 27.7775 | 27.8 | 127624.0 |
| 2016-11-25 09:30:00 | AAPL | Stock | 27.7825 | 27.8975 | 27.7375 | 27.88 | 10470776.0 |
| 2016-11-25 10:00:00 | AAPL | Stock | 27.88 | 27.8825 | 27.7675 | 27.8052 | 5127168.0 |
| 2016-11-25 10:30:00 | AAPL | Stock | 27.8075 | 27.85 | 27.8075 | 27.84 | 3294320.0 |
| 2016-11-25 11:00:00 | AAPL | Stock | 27.84 | 27.9125 | 27.835 | 27.905 | 3973996.0 |
| 2016-11-25 11:30:00 | AAPL | Stock | 27.9062 | 27.9575 | 27.89 | 27.9562 | 5066468.0 |
| 2016-11-25 12:00:00 | AAPL | Stock | 27.9562 | 27.9675 | 27.8925 | 27.9 | 3843528.0 |
| 2016-11-25 12:30:00 | AAPL | Stock | 27.9025 | 27.9475 | 27.8775 | 27.945 | 6756024.0 |
| 2016-11-25 13:00:00 | AAPL | Stock | 27.945 | 27.955 | 27.925 | 27.929 | 3746744.0 |
| 2016-11-25 13:30:00 | AAPL | Stock | 27.9375 | 27.9475 | 27.925 | 27.937 | 80604.0 |
| 2016-11-25 14:00:00 | AAPL | Stock | 27.935 | 27.935 | 27.9175 | 27.9275 | 6728.0 |
| 2016-11-25 14:30:00 | AAPL | Stock | 27.9275 | 27.945 | 27.9275 | 27.945 | 9248.0 |
| 2016-11-25 15:00:00 | AAPL | Stock | 27.945 | 28.0 | 27.9425 | 27.985 | 88668.0 |
| 2016-11-25 15:30:00 | AAPL | Stock | 27.9475 | 27.9475 | 27.9475 | 27.9475 | 7384.0 |
| 2016-11-25 16:00:00 | AAPL | Stock | 27.9325 | 27.9325 | 27.9325 | 27.9325 | 400.0 |
| 2016-11-25 16:30:00 | AAPL | Stock | 27.935 | 27.95 | 27.935 | 27.9375 | 10800.0 |
| 2016-11-25 06:00:00 | MSFT | Stock | 60.24 | 60.25 | 60.24 | 60.25 | 798.0 |
| 2016-11-25 08:00:00 | MSFT | Stock | 60.46 | 60.46 | 60.42 | 60.43 | 970.0 |
| 2016-11-25 08:30:00 | MSFT | Stock | 60.43 | 60.43 | 60.4 | 60.42 | 2858.0 |
| 2016-11-25 09:00:00 | MSFT | Stock | 60.42 | 60.44 | 60.36 | 60.41 | 6828.0 |
| 2016-11-25 09:30:00 | MSFT | Stock | 60.3 | 60.46 | 60.13 | 60.4 | 1581461.0 |
| 2016-11-25 10:00:00 | MSFT | Stock | 60.41 | 60.425 | 60.3 | 60.346 | 613376.0 |
| 2016-11-25 10:30:00 | MSFT | Stock | 60.345 | 60.425 | 60.34 | 60.4 | 469638.0 |
| 2016-11-25 11:00:00 | MSFT | Stock | 60.4 | 60.48 | 60.36 | 60.435 | 859801.0 |
| 2016-11-25 11:30:00 | MSFT | Stock | 60.435 | 60.44 | 60.32 | 60.34 | 501957.0 |
| 2016-11-25 12:00:00 | MSFT | Stock | 60.345 | 60.375 | 60.29 | 60.35 | 558225.0 |
| 2016-11-25 12:30:00 | MSFT | Stock | 60.35 | 60.53 | 60.34 | 60.53 | 1768861.0 |
| 2016-11-25 13:00:00 | MSFT | Stock | 60.52 | 60.541 | 60.322 | 60.53 | 1474154.0 |
| 2016-11-25 13:30:00 | MSFT | Stock | 60.501 | 60.53 | 60.42 | 60.42 | 35127.0 |
| 2016-11-25 14:30:00 | MSFT | Stock | 60.43 | 60.5 | 60.43 | 60.5 | 1075.0 |
| 2016-11-25 15:00:00 | MSFT | Stock | 60.5 | 60.53 | 60.5 | 60.53 | 600.0 |
| 2016-11-25 15:30:00 | MSFT | Stock | 60.5 | 60.5 | 60.35 | 60.35 | 840.0 |
| 2016-11-25 16:00:00 | MSFT | Stock | 60.25 | 60.25 | 60.25 | 60.25 | 140.0 |
| 2016-11-25 04:00:00 | NVDA | Stock | 2.3625 | 2.3625 | 2.355 | 2.3612 | 73840.0 |
| 2016-11-25 07:00:00 | NVDA | Stock | 2.3612 | 2.3625 | 2.3612 | 2.3625 | 69880.0 |
| 2016-11-25 07:30:00 | NVDA | Stock | 2.3625 | 2.3625 | 2.3625 | 2.3625 | 59160.0 |
| 2016-11-25 08:00:00 | NVDA | Stock | 2.3675 | 2.3675 | 2.3588 | 2.3588 | 180960.0 |
| 2016-11-25 08:30:00 | NVDA | Stock | 2.3588 | 2.3602 | 2.3588 | 2.3602 | 169640.0 |
| 2016-11-25 09:00:00 | NVDA | Stock | 2.3602 | 2.3648 | 2.3575 | 2.3605 | 260960.0 |
| 2016-11-25 09:30:00 | NVDA | Stock | 2.3605 | 2.3775 | 2.3352 | 2.3418 | 49282920.0 |
| 2016-11-25 10:00:00 | NVDA | Stock | 2.3415 | 2.3552 | 2.3385 | 2.3543 | 20554880.0 |
| 2016-11-25 10:30:00 | NVDA | Stock | 2.355 | 2.3588 | 2.3442 | 2.3458 | 14952080.0 |
> showing 50 of 47,660 rows — these rows as CSV