PREVIEW / stock_30min / 2016-02-17
file: by_date/stock_30min/2016/2016-02-17.parquet size: 1.6 MB rows: 82,194 symbols: 3,360
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-02-17 04:30:00 | AAPL | Stock | 24.1325 | 24.1325 | 24.1325 | 24.1325 | 1200.0 |
| 2016-02-17 05:00:00 | AAPL | Stock | 24.125 | 24.22 | 24.125 | 24.22 | 12080.0 |
| 2016-02-17 05:30:00 | AAPL | Stock | 24.19 | 24.2375 | 24.19 | 24.225 | 9724.0 |
| 2016-02-17 06:00:00 | AAPL | Stock | 24.22 | 24.225 | 24.2 | 24.2 | 17752.0 |
| 2016-02-17 06:30:00 | AAPL | Stock | 24.2 | 24.225 | 24.2 | 24.2125 | 64512.0 |
| 2016-02-17 07:00:00 | AAPL | Stock | 24.2 | 24.2175 | 24.15 | 24.1525 | 72060.0 |
| 2016-02-17 07:30:00 | AAPL | Stock | 24.15 | 24.2125 | 24.1375 | 24.2075 | 109408.0 |
| 2016-02-17 08:00:00 | AAPL | Stock | 24.19 | 24.2125 | 23.9675 | 24.0275 | 692904.0 |
| 2016-02-17 08:30:00 | AAPL | Stock | 24.0375 | 24.0825 | 24.0 | 24.055 | 323108.0 |
| 2016-02-17 09:00:00 | AAPL | Stock | 24.055 | 24.185 | 23.9875 | 24.1675 | 1420676.0 |
| 2016-02-17 09:30:00 | AAPL | Stock | 24.165 | 24.295 | 24.0375 | 24.208 | 25448708.0 |
| 2016-02-17 10:00:00 | AAPL | Stock | 24.21 | 24.2875 | 24.1675 | 24.285 | 13817316.0 |
| 2016-02-17 10:30:00 | AAPL | Stock | 24.285 | 24.29 | 24.175 | 24.27 | 15081524.0 |
| 2016-02-17 11:00:00 | AAPL | Stock | 24.2675 | 24.3475 | 24.2375 | 24.3068 | 11663860.0 |
| 2016-02-17 11:30:00 | AAPL | Stock | 24.3075 | 24.3375 | 24.235 | 24.25 | 8320800.0 |
| 2016-02-17 12:00:00 | AAPL | Stock | 24.25 | 24.37 | 24.2425 | 24.3425 | 7319528.0 |
| 2016-02-17 12:30:00 | AAPL | Stock | 24.345 | 24.485 | 24.3395 | 24.4275 | 11032816.0 |
| 2016-02-17 13:00:00 | AAPL | Stock | 24.425 | 24.4625 | 24.405 | 24.4275 | 6768800.0 |
| 2016-02-17 13:30:00 | AAPL | Stock | 24.426 | 24.4475 | 24.385 | 24.42 | 5724048.0 |
| 2016-02-17 14:00:00 | AAPL | Stock | 24.4182 | 24.5525 | 24.4 | 24.5325 | 10697988.0 |
| 2016-02-17 14:30:00 | AAPL | Stock | 24.5325 | 24.5375 | 24.42 | 24.459 | 8159624.0 |
| 2016-02-17 15:00:00 | AAPL | Stock | 24.46 | 24.53 | 24.4125 | 24.5 | 9537604.0 |
| 2016-02-17 15:30:00 | AAPL | Stock | 24.4975 | 24.55 | 24.475 | 24.5275 | 18906076.0 |
| 2016-02-17 16:00:00 | AAPL | Stock | 24.53 | 24.5375 | 24.1268 | 24.525 | 11282724.0 |
| 2016-02-17 16:30:00 | AAPL | Stock | 24.53 | 24.55 | 24.53 | 24.5475 | 45936.0 |
| 2016-02-17 17:00:00 | AAPL | Stock | 24.55 | 24.55 | 24.5325 | 24.5475 | 51100.0 |
| 2016-02-17 17:30:00 | AAPL | Stock | 24.5475 | 24.55 | 24.54 | 24.54 | 37568.0 |
| 2016-02-17 18:00:00 | AAPL | Stock | 24.54 | 24.5625 | 24.54 | 24.5625 | 22204.0 |
| 2016-02-17 18:30:00 | AAPL | Stock | 24.56 | 24.56 | 24.55 | 24.5575 | 17488.0 |
| 2016-02-17 19:00:00 | AAPL | Stock | 24.5575 | 24.57 | 24.54 | 24.57 | 37568.0 |
| 2016-02-17 19:30:00 | AAPL | Stock | 24.56 | 24.57 | 24.5475 | 24.565 | 60696.0 |
| 2016-02-17 05:00:00 | MSFT | Stock | 51.25 | 51.25 | 51.25 | 51.25 | 100.0 |
| 2016-02-17 05:30:00 | MSFT | Stock | 51.35 | 51.4 | 51.35 | 51.4 | 1549.0 |
| 2016-02-17 06:00:00 | MSFT | Stock | 51.28 | 51.28 | 51.28 | 51.28 | 300.0 |
| 2016-02-17 07:00:00 | MSFT | Stock | 51.25 | 51.38 | 51.25 | 51.26 | 690.0 |
| 2016-02-17 07:30:00 | MSFT | Stock | 51.39 | 51.45 | 51.39 | 51.45 | 10945.0 |
| 2016-02-17 08:00:00 | MSFT | Stock | 51.33 | 51.42 | 51.25 | 51.36 | 3950.0 |
| 2016-02-17 08:30:00 | MSFT | Stock | 51.35 | 51.43 | 51.32 | 51.41 | 17814.0 |
| 2016-02-17 09:00:00 | MSFT | Stock | 51.42 | 51.5 | 51.09 | 51.44 | 39581.0 |
| 2016-02-17 09:30:00 | MSFT | Stock | 51.49 | 51.76 | 51.45 | 51.615 | 3645642.0 |
| 2016-02-17 10:00:00 | MSFT | Stock | 51.62 | 52.28 | 51.615 | 52.26 | 2828675.0 |
| 2016-02-17 10:30:00 | MSFT | Stock | 52.26 | 52.45 | 52.13 | 52.37 | 2790245.0 |
| 2016-02-17 11:00:00 | MSFT | Stock | 52.36 | 52.37 | 51.93 | 52.14 | 2554637.0 |
| 2016-02-17 11:30:00 | MSFT | Stock | 52.14 | 52.255 | 52.045 | 52.195 | 1545479.0 |
| 2016-02-17 12:00:00 | MSFT | Stock | 52.2 | 52.455 | 52.14 | 52.42 | 1966779.0 |
| 2016-02-17 12:30:00 | MSFT | Stock | 52.42 | 52.52 | 52.364 | 52.45 | 1690470.0 |
| 2016-02-17 13:00:00 | MSFT | Stock | 52.45 | 52.77 | 52.435 | 52.75 | 1573081.0 |
| 2016-02-17 13:30:00 | MSFT | Stock | 52.745 | 52.75 | 52.51 | 52.59 | 1231508.0 |
| 2016-02-17 14:00:00 | MSFT | Stock | 52.58 | 52.72 | 52.53 | 52.595 | 1882392.0 |
| 2016-02-17 14:30:00 | MSFT | Stock | 52.6 | 52.63 | 52.39 | 52.42 | 1833102.0 |
> showing 50 of 82,194 rows — these rows as CSV