PREVIEW / stock_30min / 2015-12-23
file: by_date/stock_30min/2015/2015-12-23.parquet size: 1.6 MB rows: 82,738 symbols: 3,431
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-12-23 04:00:00 | AAPL | Stock | 26.85 | 26.875 | 26.85 | 26.875 | 3572.0 |
| 2015-12-23 04:30:00 | AAPL | Stock | 26.9 | 26.9 | 26.85 | 26.85 | 1272.0 |
| 2015-12-23 05:30:00 | AAPL | Stock | 26.875 | 26.8875 | 26.875 | 26.8875 | 8188.0 |
| 2015-12-23 06:00:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.875 | 26.8875 | 8000.0 |
| 2015-12-23 06:30:00 | AAPL | Stock | 26.875 | 26.875 | 26.8625 | 26.8625 | 2000.0 |
| 2015-12-23 07:00:00 | AAPL | Stock | 26.885 | 26.9075 | 26.8725 | 26.9075 | 24608.0 |
| 2015-12-23 07:30:00 | AAPL | Stock | 26.9025 | 26.925 | 26.895 | 26.895 | 25416.0 |
| 2015-12-23 08:00:00 | AAPL | Stock | 26.89 | 26.92 | 26.8325 | 26.89 | 104260.0 |
| 2015-12-23 08:30:00 | AAPL | Stock | 26.875 | 26.875 | 26.8075 | 26.81 | 145032.0 |
| 2015-12-23 09:00:00 | AAPL | Stock | 26.81 | 26.8375 | 26.795 | 26.805 | 154844.0 |
| 2015-12-23 09:30:00 | AAPL | Stock | 26.8175 | 27.12 | 26.8 | 27.0425 | 17159924.0 |
| 2015-12-23 10:00:00 | AAPL | Stock | 27.0475 | 27.1525 | 26.9625 | 26.995 | 12224040.0 |
| 2015-12-23 10:30:00 | AAPL | Stock | 26.995 | 27.1275 | 26.9825 | 27.12 | 8772884.0 |
| 2015-12-23 11:00:00 | AAPL | Stock | 27.12 | 27.125 | 27.03 | 27.0425 | 7049288.0 |
| 2015-12-23 11:30:00 | AAPL | Stock | 27.0425 | 27.125 | 27.03 | 27.1225 | 6079340.0 |
| 2015-12-23 12:00:00 | AAPL | Stock | 27.1238 | 27.2125 | 27.1125 | 27.19 | 9281296.0 |
| 2015-12-23 12:30:00 | AAPL | Stock | 27.1875 | 27.1925 | 27.0775 | 27.1 | 6889048.0 |
| 2015-12-23 13:00:00 | AAPL | Stock | 27.1012 | 27.11 | 27.0338 | 27.0725 | 4575512.0 |
| 2015-12-23 13:30:00 | AAPL | Stock | 27.07 | 27.0725 | 27.0075 | 27.0448 | 4643644.0 |
| 2015-12-23 14:00:00 | AAPL | Stock | 27.0425 | 27.1175 | 27.0412 | 27.105 | 5230132.0 |
| 2015-12-23 14:30:00 | AAPL | Stock | 27.1025 | 27.16 | 27.101 | 27.145 | 6333424.0 |
| 2015-12-23 15:00:00 | AAPL | Stock | 27.145 | 27.1525 | 27.06 | 27.135 | 5938496.0 |
| 2015-12-23 15:30:00 | AAPL | Stock | 27.135 | 27.1625 | 27.0925 | 27.1525 | 10392472.0 |
| 2015-12-23 16:00:00 | AAPL | Stock | 27.1525 | 27.155 | 27.1225 | 27.15 | 7659968.0 |
| 2015-12-23 16:30:00 | AAPL | Stock | 27.15 | 27.155 | 27.13 | 27.1375 | 407040.0 |
| 2015-12-23 17:00:00 | AAPL | Stock | 27.1525 | 27.155 | 27.1325 | 27.1475 | 47036.0 |
| 2015-12-23 17:30:00 | AAPL | Stock | 27.155 | 27.155 | 27.13 | 27.155 | 25256.0 |
| 2015-12-23 18:00:00 | AAPL | Stock | 27.1475 | 27.1625 | 27.1325 | 27.1325 | 35384.0 |
| 2015-12-23 18:30:00 | AAPL | Stock | 27.1275 | 27.1275 | 27.12 | 27.12 | 11700.0 |
| 2015-12-23 19:00:00 | AAPL | Stock | 27.125 | 27.125 | 27.12 | 27.125 | 13600.0 |
| 2015-12-23 19:30:00 | AAPL | Stock | 27.1525 | 27.17 | 27.1325 | 27.1625 | 14040.0 |
| 2015-12-23 07:00:00 | MSFT | Stock | 55.57 | 55.65 | 55.57 | 55.65 | 1700.0 |
| 2015-12-23 07:30:00 | MSFT | Stock | 55.65 | 55.65 | 55.65 | 55.65 | 460.0 |
| 2015-12-23 08:00:00 | MSFT | Stock | 55.55 | 55.65 | 55.55 | 55.59 | 1732.0 |
| 2015-12-23 08:30:00 | MSFT | Stock | 55.64 | 55.65 | 55.61 | 55.61 | 2730.0 |
| 2015-12-23 09:00:00 | MSFT | Stock | 55.6 | 55.7 | 55.53 | 55.6 | 16063.0 |
| 2015-12-23 09:30:00 | MSFT | Stock | 55.7 | 55.87 | 55.53 | 55.78 | 2651125.0 |
| 2015-12-23 10:00:00 | MSFT | Stock | 55.78 | 55.88 | 55.67 | 55.7 | 2198180.0 |
| 2015-12-23 10:30:00 | MSFT | Stock | 55.71 | 55.76 | 55.545 | 55.61 | 2460306.0 |
| 2015-12-23 11:00:00 | MSFT | Stock | 55.61 | 55.72 | 55.52 | 55.63 | 1215030.0 |
| 2015-12-23 11:30:00 | MSFT | Stock | 55.625 | 55.73 | 55.55 | 55.7 | 1157897.0 |
| 2015-12-23 12:00:00 | MSFT | Stock | 55.705 | 55.74 | 55.53 | 55.551 | 1423312.0 |
| 2015-12-23 12:30:00 | MSFT | Stock | 55.55 | 55.64 | 55.44 | 55.606 | 1366853.0 |
| 2015-12-23 13:00:00 | MSFT | Stock | 55.604 | 55.64 | 55.54 | 55.585 | 1048471.0 |
| 2015-12-23 13:30:00 | MSFT | Stock | 55.589 | 55.73 | 55.55 | 55.72 | 1177547.0 |
| 2015-12-23 14:00:00 | MSFT | Stock | 55.71 | 55.82 | 55.65 | 55.76 | 1410283.0 |
| 2015-12-23 14:30:00 | MSFT | Stock | 55.76 | 55.87 | 55.76 | 55.86 | 1337004.0 |
| 2015-12-23 15:00:00 | MSFT | Stock | 55.86 | 55.87 | 55.69 | 55.704 | 1261232.0 |
| 2015-12-23 15:30:00 | MSFT | Stock | 55.7 | 55.85 | 55.7 | 55.83 | 2530323.0 |
| 2015-12-23 16:00:00 | MSFT | Stock | 55.82 | 55.85 | 55.7 | 55.75 | 2425554.0 |
> showing 50 of 82,738 rows — these rows as CSV