PREVIEW / stock_1hour / 2017-07-03
file: by_date/stock_1hour/2017/2017-07-03.parquet size: 718 KB rows: 30,190 symbols: 2,927
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-07-03 04:00:00 | AAPL | Stock | 36.18 | 36.1825 | 36.15 | 36.15 | 4644.0 |
| 2017-07-03 05:00:00 | AAPL | Stock | 36.165 | 36.165 | 36.16 | 36.16 | 2800.0 |
| 2017-07-03 06:00:00 | AAPL | Stock | 36.16 | 36.16 | 36.1125 | 36.125 | 2280.0 |
| 2017-07-03 07:00:00 | AAPL | Stock | 36.14 | 36.1775 | 36.1325 | 36.15 | 20036.0 |
| 2017-07-03 08:00:00 | AAPL | Stock | 36.075 | 36.1925 | 36.005 | 36.1925 | 102304.0 |
| 2017-07-03 09:00:00 | AAPL | Stock | 36.2025 | 36.325 | 36.1625 | 36.193 | 9476504.0 |
| 2017-07-03 10:00:00 | AAPL | Stock | 36.2 | 36.225 | 35.9375 | 35.94 | 10813456.0 |
| 2017-07-03 11:00:00 | AAPL | Stock | 35.9402 | 36.0175 | 35.775 | 36.0175 | 10088496.0 |
| 2017-07-03 12:00:00 | AAPL | Stock | 36.015 | 36.0162 | 35.79 | 35.875 | 14168276.0 |
| 2017-07-03 13:00:00 | AAPL | Stock | 35.8775 | 36.0155 | 35.8525 | 35.875 | 5551040.0 |
| 2017-07-03 14:00:00 | AAPL | Stock | 35.885 | 35.885 | 35.8725 | 35.8775 | 76344.0 |
| 2017-07-03 15:00:00 | AAPL | Stock | 35.8725 | 35.9 | 35.8725 | 35.8912 | 10748.0 |
| 2017-07-03 16:00:00 | AAPL | Stock | 35.8825 | 35.8825 | 35.8775 | 35.8775 | 3400.0 |
| 2017-07-03 05:00:00 | MSFT | Stock | 69.24 | 69.24 | 69.24 | 69.24 | 141.0 |
| 2017-07-03 07:00:00 | MSFT | Stock | 69.03 | 69.15 | 69.03 | 69.15 | 1552.0 |
| 2017-07-03 08:00:00 | MSFT | Stock | 69.15 | 69.45 | 68.93 | 69.45 | 17536.0 |
| 2017-07-03 09:00:00 | MSFT | Stock | 69.43 | 69.6 | 69.01 | 69.06 | 2506795.0 |
| 2017-07-03 10:00:00 | MSFT | Stock | 69.055 | 69.113 | 68.65 | 68.67 | 2725805.0 |
| 2017-07-03 11:00:00 | MSFT | Stock | 68.66 | 68.73 | 68.402 | 68.715 | 2739523.0 |
| 2017-07-03 12:00:00 | MSFT | Stock | 68.71 | 68.74 | 68.02 | 68.16 | 4818849.0 |
| 2017-07-03 13:00:00 | MSFT | Stock | 68.16 | 68.684 | 68.08 | 68.194 | 1882778.0 |
| 2017-07-03 14:00:00 | MSFT | Stock | 68.17 | 68.197 | 68.17 | 68.17 | 38960.0 |
| 2017-07-03 15:00:00 | MSFT | Stock | 68.18 | 68.18 | 68.16 | 68.18 | 2872.0 |
| 2017-07-03 16:00:00 | MSFT | Stock | 68.18 | 68.2 | 68.18 | 68.2 | 1087.0 |
| 2017-07-03 04:00:00 | NVDA | Stock | 3.6425 | 3.6625 | 3.6425 | 3.6483 | 205080.0 |
| 2017-07-03 05:00:00 | NVDA | Stock | 3.6622 | 3.6622 | 3.6438 | 3.6445 | 99600.0 |
| 2017-07-03 06:00:00 | NVDA | Stock | 3.6445 | 3.6445 | 3.642 | 3.642 | 16000.0 |
| 2017-07-03 07:00:00 | NVDA | Stock | 3.642 | 3.6445 | 3.628 | 3.6375 | 265800.0 |
| 2017-07-03 08:00:00 | NVDA | Stock | 3.6408 | 3.6445 | 3.614 | 3.636 | 2149840.0 |
| 2017-07-03 09:00:00 | NVDA | Stock | 3.6362 | 3.644 | 3.5968 | 3.6135 | 83670160.0 |
| 2017-07-03 10:00:00 | NVDA | Stock | 3.6141 | 3.6225 | 3.52 | 3.5206 | 176878480.0 |
| 2017-07-03 11:00:00 | NVDA | Stock | 3.5205 | 3.5468 | 3.4845 | 3.5142 | 207110480.0 |
| 2017-07-03 12:00:00 | NVDA | Stock | 3.5147 | 3.5153 | 3.4645 | 3.4815 | 178788280.0 |
| 2017-07-03 13:00:00 | NVDA | Stock | 3.4812 | 3.5362 | 3.4695 | 3.47 | 15037280.0 |
| 2017-07-03 14:00:00 | NVDA | Stock | 3.473 | 3.4833 | 3.4707 | 3.4775 | 2063600.0 |
| 2017-07-03 15:00:00 | NVDA | Stock | 3.4752 | 3.4812 | 3.475 | 3.48 | 514840.0 |
| 2017-07-03 16:00:00 | NVDA | Stock | 3.4798 | 3.48 | 3.475 | 3.475 | 149520.0 |
| 2017-07-03 05:00:00 | AMZN | Stock | 48.7 | 48.7 | 48.6 | 48.6 | 4000.0 |
| 2017-07-03 06:00:00 | AMZN | Stock | 48.5515 | 48.5515 | 48.5515 | 48.5515 | 2020.0 |
| 2017-07-03 07:00:00 | AMZN | Stock | 48.5275 | 48.587 | 48.525 | 48.587 | 45440.0 |
| 2017-07-03 08:00:00 | AMZN | Stock | 48.55 | 48.5935 | 48.4 | 48.5755 | 180060.0 |
| 2017-07-03 09:00:00 | AMZN | Stock | 48.5875 | 48.7245 | 48.3375 | 48.444 | 8221220.0 |
| 2017-07-03 10:00:00 | AMZN | Stock | 48.4495 | 48.5705 | 48.1 | 48.104 | 10513780.0 |
| 2017-07-03 11:00:00 | AMZN | Stock | 48.0885 | 48.125 | 47.65 | 47.9615 | 13686560.0 |
| 2017-07-03 12:00:00 | AMZN | Stock | 47.956 | 47.9645 | 47.55 | 47.683 | 16071720.0 |
| 2017-07-03 13:00:00 | AMZN | Stock | 47.683 | 47.683 | 47.6084 | 47.6416 | 2753620.0 |
| 2017-07-03 14:00:00 | AMZN | Stock | 47.6452 | 47.683 | 47.6414 | 47.683 | 40040.0 |
| 2017-07-03 15:00:00 | AMZN | Stock | 47.6825 | 47.732 | 47.6555 | 47.732 | 20760.0 |
| 2017-07-03 16:00:00 | AMZN | Stock | 47.744 | 47.7445 | 47.744 | 47.7445 | 6980.0 |
| 2017-07-03 07:00:00 | GOOGL | Stock | 46.7 | 46.7 | 46.7 | 46.7 | 8000.0 |
> showing 50 of 30,190 rows — these rows as CSV