PREVIEW / stock_30min / 2017-04-26
file: by_date/stock_30min/2017/2017-04-26.parquet size: 1.6 MB rows: 82,444 symbols: 3,051
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-26 04:00:00 | AAPL | Stock | 36.18 | 36.185 | 36.1775 | 36.185 | 4628.0 |
| 2017-04-26 04:30:00 | AAPL | Stock | 36.185 | 36.2 | 36.185 | 36.2 | 6720.0 |
| 2017-04-26 05:00:00 | AAPL | Stock | 36.1975 | 36.1975 | 36.1975 | 36.1975 | 1456.0 |
| 2017-04-26 05:30:00 | AAPL | Stock | 36.1975 | 36.225 | 36.1875 | 36.1975 | 12156.0 |
| 2017-04-26 06:00:00 | AAPL | Stock | 36.1975 | 36.2175 | 36.175 | 36.175 | 19692.0 |
| 2017-04-26 06:30:00 | AAPL | Stock | 36.1875 | 36.1875 | 36.1575 | 36.1575 | 16648.0 |
| 2017-04-26 07:00:00 | AAPL | Stock | 36.1375 | 36.14 | 36.125 | 36.125 | 28540.0 |
| 2017-04-26 07:30:00 | AAPL | Stock | 36.1 | 36.1725 | 36.0925 | 36.15 | 92140.0 |
| 2017-04-26 08:00:00 | AAPL | Stock | 36.125 | 36.175 | 36.1 | 36.1475 | 67956.0 |
| 2017-04-26 08:30:00 | AAPL | Stock | 36.15 | 36.1525 | 36.1 | 36.135 | 223528.0 |
| 2017-04-26 09:00:00 | AAPL | Stock | 36.1325 | 36.1375 | 36.0975 | 36.1225 | 116496.0 |
| 2017-04-26 09:30:00 | AAPL | Stock | 36.1225 | 36.15 | 36.015 | 36.1 | 9787028.0 |
| 2017-04-26 10:00:00 | AAPL | Stock | 36.1 | 36.1088 | 35.9525 | 35.9975 | 7038728.0 |
| 2017-04-26 10:30:00 | AAPL | Stock | 35.9988 | 36.045 | 35.9725 | 36.0258 | 5238784.0 |
| 2017-04-26 11:00:00 | AAPL | Stock | 36.025 | 36.0525 | 35.9625 | 36.0425 | 3675668.0 |
| 2017-04-26 11:30:00 | AAPL | Stock | 36.0412 | 36.0775 | 35.9828 | 36.01 | 3877880.0 |
| 2017-04-26 12:00:00 | AAPL | Stock | 36.0075 | 36.07 | 35.9912 | 36.024 | 2006992.0 |
| 2017-04-26 12:30:00 | AAPL | Stock | 36.025 | 36.045 | 35.9825 | 36.03 | 2262624.0 |
| 2017-04-26 13:00:00 | AAPL | Stock | 36.0312 | 36.0488 | 36.0 | 36.0352 | 2233372.0 |
| 2017-04-26 13:30:00 | AAPL | Stock | 36.0362 | 36.15 | 36.0 | 36.02 | 6978912.0 |
| 2017-04-26 14:00:00 | AAPL | Stock | 36.02 | 36.085 | 36.0 | 36.0075 | 4060960.0 |
| 2017-04-26 14:30:00 | AAPL | Stock | 36.0075 | 36.04 | 35.9785 | 35.98 | 3225348.0 |
| 2017-04-26 15:00:00 | AAPL | Stock | 35.9788 | 36.0262 | 35.97 | 35.99 | 3674972.0 |
| 2017-04-26 15:30:00 | AAPL | Stock | 35.9875 | 35.9912 | 35.844 | 35.915 | 11365524.0 |
| 2017-04-26 16:00:00 | AAPL | Stock | 35.905 | 35.9475 | 35.9025 | 35.9225 | 4910556.0 |
| 2017-04-26 16:30:00 | AAPL | Stock | 35.925 | 35.9375 | 35.925 | 35.9325 | 15500.0 |
| 2017-04-26 17:00:00 | AAPL | Stock | 35.9375 | 35.945 | 35.9275 | 35.945 | 11284.0 |
| 2017-04-26 17:30:00 | AAPL | Stock | 35.945 | 35.9575 | 35.9375 | 35.9575 | 57116.0 |
| 2017-04-26 18:00:00 | AAPL | Stock | 35.95 | 35.9525 | 35.9375 | 35.9375 | 8000.0 |
| 2017-04-26 18:30:00 | AAPL | Stock | 35.9375 | 35.9375 | 35.9375 | 35.9375 | 2800.0 |
| 2017-04-26 19:00:00 | AAPL | Stock | 35.9375 | 35.9575 | 35.9375 | 35.9575 | 3800.0 |
| 2017-04-26 19:30:00 | AAPL | Stock | 35.96 | 35.9675 | 35.9525 | 35.9675 | 22696.0 |
| 2017-04-26 05:00:00 | MSFT | Stock | 68.14 | 68.15 | 68.14 | 68.15 | 616.0 |
| 2017-04-26 05:30:00 | MSFT | Stock | 68.0 | 68.01 | 68.0 | 68.01 | 200.0 |
| 2017-04-26 06:00:00 | MSFT | Stock | 68.09 | 68.17 | 68.09 | 68.14 | 1736.0 |
| 2017-04-26 07:00:00 | MSFT | Stock | 68.05 | 68.08 | 68.05 | 68.05 | 2651.0 |
| 2017-04-26 07:30:00 | MSFT | Stock | 68.08 | 68.08 | 68.05 | 68.07 | 960.0 |
| 2017-04-26 08:00:00 | MSFT | Stock | 68.05 | 68.15 | 68.03 | 68.1 | 8182.0 |
| 2017-04-26 08:30:00 | MSFT | Stock | 68.15 | 68.15 | 68.1 | 68.14 | 4024.0 |
| 2017-04-26 09:00:00 | MSFT | Stock | 68.14 | 68.14 | 68.12 | 68.12 | 5794.0 |
| 2017-04-26 09:30:00 | MSFT | Stock | 68.08 | 68.14 | 67.64 | 67.69 | 3223153.0 |
| 2017-04-26 10:00:00 | MSFT | Stock | 67.69 | 67.93 | 67.62 | 67.87 | 2127231.0 |
| 2017-04-26 10:30:00 | MSFT | Stock | 67.88 | 68.12 | 67.734 | 68.11 | 1614670.0 |
| 2017-04-26 11:00:00 | MSFT | Stock | 68.11 | 68.3 | 68.03 | 68.27 | 1319387.0 |
| 2017-04-26 11:30:00 | MSFT | Stock | 68.276 | 68.31 | 67.94 | 67.96 | 2017295.0 |
| 2017-04-26 12:00:00 | MSFT | Stock | 67.965 | 68.185 | 67.942 | 68.01 | 1094779.0 |
| 2017-04-26 12:30:00 | MSFT | Stock | 68.01 | 68.06 | 67.87 | 67.875 | 1380272.0 |
| 2017-04-26 13:00:00 | MSFT | Stock | 67.875 | 67.99 | 67.86 | 67.92 | 640276.0 |
| 2017-04-26 13:30:00 | MSFT | Stock | 67.92 | 67.98 | 67.81 | 67.875 | 1252544.0 |
| 2017-04-26 14:00:00 | MSFT | Stock | 67.87 | 67.93 | 67.76 | 67.83 | 1138482.0 |
> showing 50 of 82,444 rows — these rows as CSV