PREVIEW / stock_1hour / 2017-06-28
file: by_date/stock_1hour/2017/2017-06-28.parquet size: 1.0 MB rows: 48,503 symbols: 3,012
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-06-28 04:00:00 | AAPL | Stock | 35.6875 | 35.7125 | 35.425 | 35.525 | 43204.0 |
| 2017-06-28 05:00:00 | AAPL | Stock | 35.6 | 35.7625 | 35.525 | 35.75 | 48964.0 |
| 2017-06-28 06:00:00 | AAPL | Stock | 35.75 | 35.7725 | 35.7 | 35.75 | 122224.0 |
| 2017-06-28 07:00:00 | AAPL | Stock | 35.7475 | 35.89 | 35.675 | 35.88 | 338148.0 |
| 2017-06-28 08:00:00 | AAPL | Stock | 35.7125 | 36.185 | 35.7025 | 36.0825 | 592312.0 |
| 2017-06-28 09:00:00 | AAPL | Stock | 36.1 | 36.1625 | 35.8485 | 35.8915 | 13786240.0 |
| 2017-06-28 10:00:00 | AAPL | Stock | 35.8925 | 36.315 | 35.79 | 36.2575 | 16854680.0 |
| 2017-06-28 11:00:00 | AAPL | Stock | 36.255 | 36.3325 | 36.19 | 36.275 | 7531784.0 |
| 2017-06-28 12:00:00 | AAPL | Stock | 36.27 | 36.465 | 36.235 | 36.4175 | 8455888.0 |
| 2017-06-28 13:00:00 | AAPL | Stock | 36.42 | 36.51 | 36.365 | 36.3675 | 7311076.0 |
| 2017-06-28 14:00:00 | AAPL | Stock | 36.37 | 36.4775 | 36.37 | 36.4575 | 5892312.0 |
| 2017-06-28 15:00:00 | AAPL | Stock | 36.4575 | 36.5275 | 36.4075 | 36.4575 | 11942184.0 |
| 2017-06-28 16:00:00 | AAPL | Stock | 36.4575 | 36.4775 | 36.1362 | 36.4575 | 6483112.0 |
| 2017-06-28 17:00:00 | AAPL | Stock | 36.4575 | 36.4575 | 36.435 | 36.435 | 29952.0 |
| 2017-06-28 18:00:00 | AAPL | Stock | 36.445 | 36.475 | 36.4375 | 36.4625 | 56224.0 |
| 2017-06-28 19:00:00 | AAPL | Stock | 36.4625 | 36.475 | 36.4425 | 36.4625 | 37888.0 |
| 2017-06-28 04:00:00 | MSFT | Stock | 68.8 | 68.8 | 68.5 | 68.55 | 4130.0 |
| 2017-06-28 05:00:00 | MSFT | Stock | 68.93 | 68.96 | 68.93 | 68.96 | 600.0 |
| 2017-06-28 07:00:00 | MSFT | Stock | 69.0 | 69.05 | 68.88 | 69.03 | 19760.0 |
| 2017-06-28 08:00:00 | MSFT | Stock | 68.97 | 69.4 | 68.97 | 69.29 | 36837.0 |
| 2017-06-28 09:00:00 | MSFT | Stock | 69.3 | 69.34 | 68.79 | 68.945 | 3867333.0 |
| 2017-06-28 10:00:00 | MSFT | Stock | 68.94 | 69.54 | 68.91 | 69.49 | 5327464.0 |
| 2017-06-28 11:00:00 | MSFT | Stock | 69.49 | 69.51 | 69.28 | 69.35 | 2309547.0 |
| 2017-06-28 12:00:00 | MSFT | Stock | 69.355 | 69.63 | 69.33 | 69.58 | 1814531.0 |
| 2017-06-28 13:00:00 | MSFT | Stock | 69.59 | 69.73 | 69.51 | 69.62 | 1801724.0 |
| 2017-06-28 14:00:00 | MSFT | Stock | 69.63 | 69.69 | 69.5 | 69.66 | 1696023.0 |
| 2017-06-28 15:00:00 | MSFT | Stock | 69.666 | 69.841 | 69.66 | 69.8 | 5167384.0 |
| 2017-06-28 16:00:00 | MSFT | Stock | 69.8 | 69.85 | 69.75 | 69.82 | 2009695.0 |
| 2017-06-28 17:00:00 | MSFT | Stock | 69.82 | 69.99 | 69.82 | 69.99 | 3892.0 |
| 2017-06-28 19:00:00 | MSFT | Stock | 69.83 | 69.99 | 69.83 | 69.99 | 1510.0 |
| 2017-06-28 04:00:00 | NVDA | Stock | 3.65 | 3.65 | 3.6098 | 3.6238 | 463560.0 |
| 2017-06-28 05:00:00 | NVDA | Stock | 3.6163 | 3.6472 | 3.6163 | 3.6472 | 167920.0 |
| 2017-06-28 06:00:00 | NVDA | Stock | 3.648 | 3.6572 | 3.6395 | 3.655 | 169360.0 |
| 2017-06-28 07:00:00 | NVDA | Stock | 3.6488 | 3.6833 | 3.645 | 3.6812 | 393040.0 |
| 2017-06-28 08:00:00 | NVDA | Stock | 3.68 | 3.737 | 3.6598 | 3.712 | 12002440.0 |
| 2017-06-28 09:00:00 | NVDA | Stock | 3.7095 | 3.7432 | 3.6438 | 3.6612 | 163043560.0 |
| 2017-06-28 10:00:00 | NVDA | Stock | 3.6612 | 3.7682 | 3.6498 | 3.7595 | 213613160.0 |
| 2017-06-28 11:00:00 | NVDA | Stock | 3.7582 | 3.7665 | 3.7225 | 3.7263 | 124588280.0 |
| 2017-06-28 12:00:00 | NVDA | Stock | 3.7258 | 3.7645 | 3.725 | 3.7565 | 76543920.0 |
| 2017-06-28 13:00:00 | NVDA | Stock | 3.7572 | 3.777 | 3.7518 | 3.7648 | 74764520.0 |
| 2017-06-28 14:00:00 | NVDA | Stock | 3.7638 | 3.7675 | 3.7355 | 3.7568 | 90315520.0 |
| 2017-06-28 15:00:00 | NVDA | Stock | 3.7568 | 3.7985 | 3.7538 | 3.7938 | 137271880.0 |
| 2017-06-28 16:00:00 | NVDA | Stock | 3.7938 | 3.8 | 3.7888 | 3.7925 | 35643160.0 |
| 2017-06-28 17:00:00 | NVDA | Stock | 3.7925 | 3.8013 | 3.7922 | 3.797 | 561560.0 |
| 2017-06-28 18:00:00 | NVDA | Stock | 3.7972 | 3.805 | 3.7962 | 3.805 | 457680.0 |
| 2017-06-28 19:00:00 | NVDA | Stock | 3.805 | 3.8168 | 3.8015 | 3.8125 | 797480.0 |
| 2017-06-28 04:00:00 | AMZN | Stock | 48.7345 | 48.7345 | 48.7345 | 48.7345 | 11020.0 |
| 2017-06-28 05:00:00 | AMZN | Stock | 48.772 | 48.8 | 48.772 | 48.7745 | 65700.0 |
| 2017-06-28 06:00:00 | AMZN | Stock | 49.0345 | 49.0345 | 48.9505 | 48.9505 | 6120.0 |
| 2017-06-28 07:00:00 | AMZN | Stock | 48.9 | 49.0 | 48.865 | 48.98 | 123060.0 |
> showing 50 of 48,503 rows — these rows as CSV