PREVIEW / stock_30min / 2015-11-11
file: by_date/stock_30min/2015/2015-11-11.parquet size: 1.6 MB rows: 80,804 symbols: 3,394
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-11 04:00:00 | AAPL | Stock | 29.1 | 29.135 | 29.085 | 29.1275 | 18628.0 |
| 2015-11-11 04:30:00 | AAPL | Stock | 29.15 | 29.15 | 29.1275 | 29.135 | 10560.0 |
| 2015-11-11 05:00:00 | AAPL | Stock | 29.1375 | 29.175 | 29.1325 | 29.1725 | 14372.0 |
| 2015-11-11 05:30:00 | AAPL | Stock | 29.17 | 29.1725 | 29.15 | 29.15 | 5840.0 |
| 2015-11-11 06:00:00 | AAPL | Stock | 29.13 | 29.155 | 29.1125 | 29.1125 | 7316.0 |
| 2015-11-11 06:30:00 | AAPL | Stock | 29.155 | 29.155 | 29.1075 | 29.135 | 21408.0 |
| 2015-11-11 07:00:00 | AAPL | Stock | 29.135 | 29.14 | 29.0275 | 29.065 | 79004.0 |
| 2015-11-11 07:30:00 | AAPL | Stock | 29.075 | 29.17 | 29.0625 | 29.17 | 60392.0 |
| 2015-11-11 08:00:00 | AAPL | Stock | 29.17 | 29.17 | 28.9 | 29.0 | 1213424.0 |
| 2015-11-11 08:30:00 | AAPL | Stock | 29.0 | 29.11 | 29.0 | 29.055 | 257676.0 |
| 2015-11-11 09:00:00 | AAPL | Stock | 29.04 | 29.0925 | 29.0175 | 29.0925 | 228352.0 |
| 2015-11-11 09:30:00 | AAPL | Stock | 29.0925 | 29.16 | 28.8025 | 28.855 | 32207260.0 |
| 2015-11-11 10:00:00 | AAPL | Stock | 28.8625 | 29.05 | 28.8075 | 28.9875 | 19413240.0 |
| 2015-11-11 10:30:00 | AAPL | Stock | 28.985 | 29.0475 | 28.8475 | 28.8775 | 13801872.0 |
| 2015-11-11 11:00:00 | AAPL | Stock | 28.8775 | 29.09 | 28.8325 | 29.0875 | 10115984.0 |
| 2015-11-11 11:30:00 | AAPL | Stock | 29.09 | 29.1375 | 29.045 | 29.096 | 11794812.0 |
| 2015-11-11 12:00:00 | AAPL | Stock | 29.0975 | 29.345 | 29.0675 | 29.2775 | 15467804.0 |
| 2015-11-11 12:30:00 | AAPL | Stock | 29.2775 | 29.355 | 29.17 | 29.275 | 9643872.0 |
| 2015-11-11 13:00:00 | AAPL | Stock | 29.275 | 29.285 | 29.1 | 29.13 | 9291492.0 |
| 2015-11-11 13:30:00 | AAPL | Stock | 29.13 | 29.2358 | 29.1175 | 29.145 | 6663688.0 |
| 2015-11-11 14:00:00 | AAPL | Stock | 29.1425 | 29.2975 | 29.13 | 29.2875 | 7333136.0 |
| 2015-11-11 14:30:00 | AAPL | Stock | 29.2875 | 29.3025 | 29.1125 | 29.1425 | 7600804.0 |
| 2015-11-11 15:00:00 | AAPL | Stock | 29.1425 | 29.2075 | 29.085 | 29.1685 | 9592980.0 |
| 2015-11-11 15:30:00 | AAPL | Stock | 29.1675 | 29.18 | 29.025 | 29.0275 | 13016804.0 |
| 2015-11-11 16:00:00 | AAPL | Stock | 29.0275 | 29.035 | 28.9975 | 29.025 | 3731300.0 |
| 2015-11-11 16:30:00 | AAPL | Stock | 29.025 | 29.025 | 28.965 | 28.98 | 54408.0 |
| 2015-11-11 17:00:00 | AAPL | Stock | 28.98 | 28.9925 | 28.9575 | 28.9625 | 39532.0 |
| 2015-11-11 17:30:00 | AAPL | Stock | 28.965 | 29.0 | 28.964 | 29.0 | 36580.0 |
| 2015-11-11 18:00:00 | AAPL | Stock | 29.0 | 29.005 | 28.9775 | 28.9875 | 12800.0 |
| 2015-11-11 18:30:00 | AAPL | Stock | 28.98 | 28.9975 | 28.975 | 28.9865 | 11100.0 |
| 2015-11-11 19:00:00 | AAPL | Stock | 28.985 | 28.9875 | 28.9775 | 28.98 | 22168.0 |
| 2015-11-11 19:30:00 | AAPL | Stock | 28.975 | 28.99 | 28.975 | 28.99 | 14640.0 |
| 2015-11-11 04:00:00 | MSFT | Stock | 53.59 | 53.59 | 53.59 | 53.59 | 500.0 |
| 2015-11-11 06:00:00 | MSFT | Stock | 53.63 | 53.63 | 53.63 | 53.63 | 500.0 |
| 2015-11-11 06:30:00 | MSFT | Stock | 53.64 | 53.65 | 53.64 | 53.65 | 4382.0 |
| 2015-11-11 07:00:00 | MSFT | Stock | 53.61 | 53.65 | 53.61 | 53.65 | 3818.0 |
| 2015-11-11 07:30:00 | MSFT | Stock | 53.69 | 53.74 | 53.67 | 53.7 | 8235.0 |
| 2015-11-11 08:00:00 | MSFT | Stock | 53.72 | 53.93 | 53.7 | 53.8 | 46243.0 |
| 2015-11-11 08:30:00 | MSFT | Stock | 53.77 | 53.84 | 53.7 | 53.75 | 30629.0 |
| 2015-11-11 09:00:00 | MSFT | Stock | 53.75 | 53.75 | 53.69 | 53.69 | 10572.0 |
| 2015-11-11 09:30:00 | MSFT | Stock | 53.7 | 54.0 | 53.46 | 53.47 | 4625217.0 |
| 2015-11-11 10:00:00 | MSFT | Stock | 53.47 | 53.69 | 53.464 | 53.565 | 4173140.0 |
| 2015-11-11 10:30:00 | MSFT | Stock | 53.57 | 53.775 | 53.52 | 53.74 | 3355448.0 |
| 2015-11-11 11:00:00 | MSFT | Stock | 53.75 | 53.84 | 53.67 | 53.835 | 2001457.0 |
| 2015-11-11 11:30:00 | MSFT | Stock | 53.84 | 53.995 | 53.84 | 53.96 | 1785503.0 |
| 2015-11-11 12:00:00 | MSFT | Stock | 53.95 | 54.08 | 53.94 | 54.058 | 2415470.0 |
| 2015-11-11 12:30:00 | MSFT | Stock | 54.06 | 54.2 | 54.01 | 54.19 | 1952321.0 |
| 2015-11-11 13:00:00 | MSFT | Stock | 54.19 | 54.2 | 53.895 | 53.95 | 1736514.0 |
| 2015-11-11 13:30:00 | MSFT | Stock | 53.955 | 54.065 | 53.9 | 54.0 | 1210137.0 |
| 2015-11-11 14:00:00 | MSFT | Stock | 53.996 | 54.07 | 53.91 | 54.05 | 1376680.0 |
> showing 50 of 80,804 rows — these rows as CSV