PREVIEW / stock_30min / 2015-11-13
file: by_date/stock_30min/2015/2015-11-13.parquet size: 1.6 MB rows: 81,958 symbols: 3,383
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-11-13 04:00:00 | AAPL | Stock | 28.93 | 28.9375 | 28.93 | 28.9375 | 1200.0 |
| 2015-11-13 05:30:00 | AAPL | Stock | 28.9 | 28.95 | 28.895 | 28.95 | 2204.0 |
| 2015-11-13 06:00:00 | AAPL | Stock | 28.895 | 28.9 | 28.8225 | 28.8525 | 16864.0 |
| 2015-11-13 06:30:00 | AAPL | Stock | 28.8425 | 28.8425 | 28.74 | 28.775 | 28436.0 |
| 2015-11-13 07:00:00 | AAPL | Stock | 28.775 | 28.8125 | 28.75 | 28.7875 | 20772.0 |
| 2015-11-13 07:30:00 | AAPL | Stock | 28.775 | 28.845 | 28.76 | 28.8175 | 33544.0 |
| 2015-11-13 08:00:00 | AAPL | Stock | 28.845 | 28.8525 | 28.775 | 28.845 | 112892.0 |
| 2015-11-13 08:30:00 | AAPL | Stock | 28.8275 | 28.885 | 28.8125 | 28.8375 | 159312.0 |
| 2015-11-13 09:00:00 | AAPL | Stock | 28.8475 | 28.905 | 28.79 | 28.8 | 248712.0 |
| 2015-11-13 09:30:00 | AAPL | Stock | 28.8 | 28.8925 | 28.5375 | 28.555 | 23125352.0 |
| 2015-11-13 10:00:00 | AAPL | Stock | 28.555 | 28.625 | 28.3288 | 28.4425 | 20580916.0 |
| 2015-11-13 10:30:00 | AAPL | Stock | 28.4425 | 28.4875 | 28.375 | 28.393 | 12414544.0 |
| 2015-11-13 11:00:00 | AAPL | Stock | 28.395 | 28.4 | 28.17 | 28.3585 | 20976996.0 |
| 2015-11-13 11:30:00 | AAPL | Stock | 28.3585 | 28.4225 | 28.29 | 28.4225 | 7920316.0 |
| 2015-11-13 12:00:00 | AAPL | Stock | 28.4225 | 28.535 | 28.4025 | 28.4425 | 9475668.0 |
| 2015-11-13 12:30:00 | AAPL | Stock | 28.441 | 28.46 | 28.3025 | 28.3325 | 6385380.0 |
| 2015-11-13 13:00:00 | AAPL | Stock | 28.335 | 28.3675 | 28.2588 | 28.3225 | 6555836.0 |
| 2015-11-13 13:30:00 | AAPL | Stock | 28.3225 | 28.35 | 28.2775 | 28.3325 | 5134776.0 |
| 2015-11-13 14:00:00 | AAPL | Stock | 28.33 | 28.3525 | 28.285 | 28.3012 | 6820968.0 |
| 2015-11-13 14:30:00 | AAPL | Stock | 28.3008 | 28.3225 | 28.1975 | 28.2325 | 8729780.0 |
| 2015-11-13 15:00:00 | AAPL | Stock | 28.2325 | 28.2675 | 28.1375 | 28.19 | 10042040.0 |
| 2015-11-13 15:30:00 | AAPL | Stock | 28.1888 | 28.255 | 28.0675 | 28.0825 | 22041476.0 |
| 2015-11-13 16:00:00 | AAPL | Stock | 28.085 | 28.15 | 28.045 | 28.0775 | 9232856.0 |
| 2015-11-13 16:30:00 | AAPL | Stock | 28.075 | 28.09 | 28.0025 | 28.0375 | 731688.0 |
| 2015-11-13 17:00:00 | AAPL | Stock | 28.0375 | 28.0425 | 28.0025 | 28.0275 | 125444.0 |
| 2015-11-13 17:30:00 | AAPL | Stock | 28.0025 | 28.025 | 27.8775 | 27.9125 | 171960.0 |
| 2015-11-13 18:00:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.75 | 27.7525 | 132844.0 |
| 2015-11-13 18:30:00 | AAPL | Stock | 27.75 | 27.7625 | 27.6225 | 27.7625 | 273176.0 |
| 2015-11-13 19:00:00 | AAPL | Stock | 27.7575 | 27.805 | 27.7025 | 27.725 | 119076.0 |
| 2015-11-13 19:30:00 | AAPL | Stock | 27.725 | 27.75 | 27.675 | 27.725 | 136768.0 |
| 2015-11-13 04:30:00 | MSFT | Stock | 53.22 | 53.22 | 53.21 | 53.22 | 2460.0 |
| 2015-11-13 05:00:00 | MSFT | Stock | 53.13 | 53.13 | 53.13 | 53.13 | 200.0 |
| 2015-11-13 06:30:00 | MSFT | Stock | 53.0 | 53.0 | 52.83 | 52.84 | 6617.0 |
| 2015-11-13 07:00:00 | MSFT | Stock | 52.96 | 52.96 | 52.96 | 52.96 | 400.0 |
| 2015-11-13 07:30:00 | MSFT | Stock | 52.96 | 52.99 | 52.9 | 52.98 | 4575.0 |
| 2015-11-13 08:00:00 | MSFT | Stock | 53.0 | 53.0 | 52.86 | 52.87 | 31447.0 |
| 2015-11-13 08:30:00 | MSFT | Stock | 52.92 | 53.07 | 52.85 | 52.88 | 10776.0 |
| 2015-11-13 09:00:00 | MSFT | Stock | 52.9 | 53.05 | 52.88 | 52.97 | 29104.0 |
| 2015-11-13 09:30:00 | MSFT | Stock | 53.07 | 53.29 | 52.595 | 53.04 | 5605599.0 |
| 2015-11-13 10:00:00 | MSFT | Stock | 53.03 | 53.03 | 52.53 | 52.93 | 3629994.0 |
| 2015-11-13 10:30:00 | MSFT | Stock | 52.93 | 52.98 | 52.66 | 52.726 | 2058881.0 |
| 2015-11-13 11:00:00 | MSFT | Stock | 52.73 | 52.795 | 52.59 | 52.71 | 1696701.0 |
| 2015-11-13 11:30:00 | MSFT | Stock | 52.71 | 52.85 | 52.58 | 52.819 | 1436032.0 |
| 2015-11-13 12:00:00 | MSFT | Stock | 52.81 | 53.157 | 52.8 | 52.96 | 1670842.0 |
| 2015-11-13 12:30:00 | MSFT | Stock | 52.96 | 53.07 | 52.85 | 53.07 | 1259214.0 |
| 2015-11-13 13:00:00 | MSFT | Stock | 53.07 | 53.15 | 52.96 | 53.074 | 1686869.0 |
| 2015-11-13 13:30:00 | MSFT | Stock | 53.08 | 53.16 | 52.97 | 53.091 | 1369913.0 |
| 2015-11-13 14:00:00 | MSFT | Stock | 53.09 | 53.15 | 52.95 | 53.082 | 1609752.0 |
| 2015-11-13 14:30:00 | MSFT | Stock | 53.08 | 53.165 | 52.74 | 52.964 | 2395136.0 |
| 2015-11-13 15:00:00 | MSFT | Stock | 52.96 | 53.1 | 52.93 | 52.955 | 2221232.0 |
> showing 50 of 81,958 rows — these rows as CSV