PREVIEW / stock_30min / 2015-12-09
file: by_date/stock_30min/2015/2015-12-09.parquet size: 1.6 MB rows: 83,185 symbols: 3,410
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-09 04:00:00 | AAPL | Stock | 29.49 | 29.525 | 29.47 | 29.47 | 12400.0 |
| 2015-12-09 04:30:00 | AAPL | Stock | 29.465 | 29.4675 | 29.465 | 29.4675 | 1360.0 |
| 2015-12-09 05:00:00 | AAPL | Stock | 29.45 | 29.45 | 29.425 | 29.425 | 2460.0 |
| 2015-12-09 05:30:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 10420.0 |
| 2015-12-09 06:00:00 | AAPL | Stock | 29.4525 | 29.475 | 29.435 | 29.475 | 18800.0 |
| 2015-12-09 06:30:00 | AAPL | Stock | 29.45 | 29.4575 | 29.425 | 29.4275 | 17780.0 |
| 2015-12-09 07:00:00 | AAPL | Stock | 29.45 | 29.505 | 29.4375 | 29.4625 | 39020.0 |
| 2015-12-09 07:30:00 | AAPL | Stock | 29.4625 | 29.475 | 29.4625 | 29.475 | 16400.0 |
| 2015-12-09 08:00:00 | AAPL | Stock | 29.485 | 29.5225 | 29.4375 | 29.505 | 114696.0 |
| 2015-12-09 08:30:00 | AAPL | Stock | 29.5125 | 29.5375 | 29.4525 | 29.455 | 145260.0 |
| 2015-12-09 09:00:00 | AAPL | Stock | 29.455 | 29.5575 | 29.38 | 29.39 | 322436.0 |
| 2015-12-09 09:30:00 | AAPL | Stock | 29.3775 | 29.4225 | 29.24 | 29.2625 | 17892400.0 |
| 2015-12-09 10:00:00 | AAPL | Stock | 29.2625 | 29.38 | 29.235 | 29.2785 | 11375400.0 |
| 2015-12-09 10:30:00 | AAPL | Stock | 29.28 | 29.38 | 29.26 | 29.275 | 9826420.0 |
| 2015-12-09 11:00:00 | AAPL | Stock | 29.275 | 29.2925 | 29.195 | 29.2125 | 8097136.0 |
| 2015-12-09 11:30:00 | AAPL | Stock | 29.21 | 29.2575 | 29.0725 | 29.125 | 10600588.0 |
| 2015-12-09 12:00:00 | AAPL | Stock | 29.125 | 29.1375 | 28.9375 | 28.95 | 10739468.0 |
| 2015-12-09 12:30:00 | AAPL | Stock | 28.95 | 28.985 | 28.8475 | 28.875 | 13591388.0 |
| 2015-12-09 13:00:00 | AAPL | Stock | 28.8688 | 28.925 | 28.77 | 28.835 | 12122036.0 |
| 2015-12-09 13:30:00 | AAPL | Stock | 28.8375 | 28.9575 | 28.7825 | 28.8762 | 14259664.0 |
| 2015-12-09 14:00:00 | AAPL | Stock | 28.875 | 28.92 | 28.85 | 28.8825 | 10324000.0 |
| 2015-12-09 14:30:00 | AAPL | Stock | 28.88 | 28.91 | 28.7875 | 28.79 | 10146288.0 |
| 2015-12-09 15:00:00 | AAPL | Stock | 28.7875 | 28.9225 | 28.775 | 28.876 | 10288024.0 |
| 2015-12-09 15:30:00 | AAPL | Stock | 28.875 | 28.9625 | 28.8125 | 28.9075 | 17289932.0 |
| 2015-12-09 16:00:00 | AAPL | Stock | 28.905 | 28.9075 | 28.822 | 28.822 | 10081068.0 |
| 2015-12-09 16:30:00 | AAPL | Stock | 28.905 | 28.905 | 28.8775 | 28.905 | 126152.0 |
| 2015-12-09 17:00:00 | AAPL | Stock | 28.905 | 28.935 | 28.9025 | 28.93 | 81768.0 |
| 2015-12-09 17:30:00 | AAPL | Stock | 28.9275 | 28.93 | 28.9075 | 28.915 | 23032.0 |
| 2015-12-09 18:00:00 | AAPL | Stock | 28.92 | 28.9375 | 28.92 | 28.9325 | 27760.0 |
| 2015-12-09 18:30:00 | AAPL | Stock | 28.925 | 28.925 | 28.9125 | 28.9125 | 43596.0 |
| 2015-12-09 19:00:00 | AAPL | Stock | 28.9175 | 28.9375 | 28.9125 | 28.925 | 6824.0 |
| 2015-12-09 19:30:00 | AAPL | Stock | 28.925 | 28.95 | 28.925 | 28.95 | 39412.0 |
| 2015-12-09 04:00:00 | MSFT | Stock | 55.66 | 55.66 | 55.66 | 55.66 | 200.0 |
| 2015-12-09 04:30:00 | MSFT | Stock | 55.52 | 55.52 | 55.52 | 55.52 | 100.0 |
| 2015-12-09 05:30:00 | MSFT | Stock | 55.5 | 55.5 | 55.45 | 55.45 | 417.0 |
| 2015-12-09 06:00:00 | MSFT | Stock | 55.45 | 55.5 | 55.45 | 55.5 | 582.0 |
| 2015-12-09 06:30:00 | MSFT | Stock | 55.95 | 55.95 | 55.95 | 55.95 | 100.0 |
| 2015-12-09 07:00:00 | MSFT | Stock | 55.64 | 55.64 | 55.63 | 55.63 | 400.0 |
| 2015-12-09 08:00:00 | MSFT | Stock | 55.63 | 55.63 | 55.6 | 55.6 | 5200.0 |
| 2015-12-09 08:30:00 | MSFT | Stock | 55.63 | 55.64 | 55.56 | 55.61 | 5078.0 |
| 2015-12-09 09:00:00 | MSFT | Stock | 55.53 | 55.57 | 55.33 | 55.41 | 45895.0 |
| 2015-12-09 09:30:00 | MSFT | Stock | 55.37 | 55.74 | 55.12 | 55.67 | 3221034.0 |
| 2015-12-09 10:00:00 | MSFT | Stock | 55.68 | 55.82 | 55.575 | 55.68 | 2502244.0 |
| 2015-12-09 10:30:00 | MSFT | Stock | 55.68 | 55.87 | 55.6 | 55.64 | 2174907.0 |
| 2015-12-09 11:00:00 | MSFT | Stock | 55.65 | 55.72 | 55.5 | 55.525 | 1651251.0 |
| 2015-12-09 11:30:00 | MSFT | Stock | 55.525 | 55.54 | 55.11 | 55.31 | 2145191.0 |
| 2015-12-09 12:00:00 | MSFT | Stock | 55.31 | 55.44 | 55.0 | 55.01 | 2209023.0 |
| 2015-12-09 12:30:00 | MSFT | Stock | 55.01 | 55.13 | 54.65 | 54.695 | 2803253.0 |
| 2015-12-09 13:00:00 | MSFT | Stock | 54.69 | 54.88 | 54.56 | 54.68 | 2460188.0 |
| 2015-12-09 13:30:00 | MSFT | Stock | 54.69 | 54.79 | 54.57 | 54.72 | 2291481.0 |
> showing 50 of 83,185 rows — these rows as CSV