PREVIEW / stock_30min / 2015-12-03
file: by_date/stock_30min/2015/2015-12-03.parquet size: 1.6 MB rows: 82,709 symbols: 3,408
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-03 04:00:00 | AAPL | Stock | 29.1775 | 29.22 | 29.175 | 29.175 | 14540.0 |
| 2015-12-03 04:30:00 | AAPL | Stock | 29.175 | 29.2375 | 29.175 | 29.2375 | 2016.0 |
| 2015-12-03 05:00:00 | AAPL | Stock | 29.2075 | 29.215 | 29.135 | 29.2125 | 28260.0 |
| 2015-12-03 05:30:00 | AAPL | Stock | 29.2175 | 29.235 | 29.2175 | 29.235 | 4728.0 |
| 2015-12-03 06:00:00 | AAPL | Stock | 29.22 | 29.2375 | 29.2025 | 29.2375 | 12008.0 |
| 2015-12-03 06:30:00 | AAPL | Stock | 29.2375 | 29.325 | 29.2125 | 29.28 | 33912.0 |
| 2015-12-03 07:00:00 | AAPL | Stock | 29.275 | 29.2775 | 29.25 | 29.27 | 46320.0 |
| 2015-12-03 07:30:00 | AAPL | Stock | 29.2725 | 29.2875 | 29.125 | 29.215 | 143276.0 |
| 2015-12-03 08:00:00 | AAPL | Stock | 29.215 | 29.325 | 29.1275 | 29.1875 | 200936.0 |
| 2015-12-03 08:30:00 | AAPL | Stock | 29.1875 | 29.235 | 29.05 | 29.19 | 557648.0 |
| 2015-12-03 09:00:00 | AAPL | Stock | 29.19 | 29.21 | 29.105 | 29.1375 | 198124.0 |
| 2015-12-03 09:30:00 | AAPL | Stock | 29.125 | 29.1975 | 28.935 | 29.105 | 18816208.0 |
| 2015-12-03 10:00:00 | AAPL | Stock | 29.1075 | 29.1225 | 28.935 | 28.98 | 11681612.0 |
| 2015-12-03 10:30:00 | AAPL | Stock | 28.9775 | 29.07 | 28.9275 | 29.01 | 7884672.0 |
| 2015-12-03 11:00:00 | AAPL | Stock | 29.0125 | 29.17 | 28.99 | 29.125 | 8603768.0 |
| 2015-12-03 11:30:00 | AAPL | Stock | 29.125 | 29.13 | 29.01 | 29.0475 | 4938216.0 |
| 2015-12-03 12:00:00 | AAPL | Stock | 29.0475 | 29.0575 | 28.795 | 28.8375 | 10578296.0 |
| 2015-12-03 12:30:00 | AAPL | Stock | 28.84 | 28.9275 | 28.7878 | 28.815 | 8141884.0 |
| 2015-12-03 13:00:00 | AAPL | Stock | 28.815 | 28.895 | 28.7525 | 28.8425 | 8626260.0 |
| 2015-12-03 13:30:00 | AAPL | Stock | 28.8425 | 28.8575 | 28.705 | 28.7075 | 8493460.0 |
| 2015-12-03 14:00:00 | AAPL | Stock | 28.708 | 28.7525 | 28.636 | 28.645 | 9695556.0 |
| 2015-12-03 14:30:00 | AAPL | Stock | 28.6475 | 28.73 | 28.555 | 28.7222 | 14046640.0 |
| 2015-12-03 15:00:00 | AAPL | Stock | 28.7225 | 28.7838 | 28.61 | 28.665 | 10115476.0 |
| 2015-12-03 15:30:00 | AAPL | Stock | 28.665 | 28.8175 | 28.62 | 28.8 | 16552872.0 |
| 2015-12-03 16:00:00 | AAPL | Stock | 28.8 | 28.83 | 28.7925 | 28.8225 | 14083372.0 |
| 2015-12-03 16:30:00 | AAPL | Stock | 28.81 | 28.8475 | 28.81 | 28.8425 | 51776.0 |
| 2015-12-03 17:00:00 | AAPL | Stock | 28.8425 | 28.8425 | 28.825 | 28.8375 | 32276.0 |
| 2015-12-03 17:30:00 | AAPL | Stock | 28.8275 | 28.8425 | 28.8275 | 28.8375 | 33200.0 |
| 2015-12-03 18:00:00 | AAPL | Stock | 28.8425 | 28.85 | 28.8425 | 28.85 | 14820.0 |
| 2015-12-03 18:30:00 | AAPL | Stock | 28.85 | 28.85 | 28.84 | 28.8475 | 49316.0 |
| 2015-12-03 19:00:00 | AAPL | Stock | 28.845 | 28.8625 | 28.845 | 28.855 | 18700.0 |
| 2015-12-03 19:30:00 | AAPL | Stock | 28.85 | 28.8675 | 28.8475 | 28.865 | 27828.0 |
| 2015-12-03 05:00:00 | MSFT | Stock | 55.65 | 55.65 | 55.65 | 55.65 | 900.0 |
| 2015-12-03 05:30:00 | MSFT | Stock | 55.7 | 55.7 | 55.7 | 55.7 | 2800.0 |
| 2015-12-03 07:00:00 | MSFT | Stock | 55.56 | 55.6 | 55.56 | 55.6 | 1100.0 |
| 2015-12-03 07:30:00 | MSFT | Stock | 55.56 | 55.6 | 55.39 | 55.55 | 5652.0 |
| 2015-12-03 08:00:00 | MSFT | Stock | 55.4 | 55.5 | 55.4 | 55.49 | 6075.0 |
| 2015-12-03 08:30:00 | MSFT | Stock | 55.42 | 55.42 | 55.03 | 55.25 | 48487.0 |
| 2015-12-03 09:00:00 | MSFT | Stock | 55.35 | 55.54 | 55.35 | 55.5 | 26208.0 |
| 2015-12-03 09:30:00 | MSFT | Stock | 55.45 | 55.77 | 54.992 | 55.18 | 2877029.0 |
| 2015-12-03 10:00:00 | MSFT | Stock | 55.175 | 55.18 | 54.85 | 54.94 | 2264883.0 |
| 2015-12-03 10:30:00 | MSFT | Stock | 54.935 | 55.225 | 54.85 | 55.06 | 1668679.0 |
| 2015-12-03 11:00:00 | MSFT | Stock | 55.06 | 55.33 | 55.0 | 55.165 | 2021313.0 |
| 2015-12-03 11:30:00 | MSFT | Stock | 55.165 | 55.65 | 54.73 | 54.89 | 1507958.0 |
| 2015-12-03 12:00:00 | MSFT | Stock | 54.88 | 54.92 | 54.25 | 54.38 | 2617965.0 |
| 2015-12-03 12:30:00 | MSFT | Stock | 54.375 | 54.53 | 54.2 | 54.22 | 2090095.0 |
| 2015-12-03 13:00:00 | MSFT | Stock | 54.22 | 54.43 | 54.031 | 54.41 | 2366339.0 |
| 2015-12-03 13:30:00 | MSFT | Stock | 54.41 | 54.44 | 54.05 | 54.07 | 1989421.0 |
| 2015-12-03 14:00:00 | MSFT | Stock | 54.08 | 54.21 | 53.97 | 54.13 | 2573738.0 |
| 2015-12-03 14:30:00 | MSFT | Stock | 54.13 | 54.29 | 54.02 | 54.25 | 2290176.0 |
> showing 50 of 82,709 rows — these rows as CSV