PREVIEW / stock_1hour / 2017-09-18
file: by_date/stock_1hour/2017/2017-09-18.parquet size: 1.1 MB rows: 48,613 symbols: 2,965
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-09-18 04:00:00 | AAPL | Stock | 40.055 | 40.15 | 40.05 | 40.15 | 7764.0 |
| 2017-09-18 05:00:00 | AAPL | Stock | 40.125 | 40.1575 | 40.1225 | 40.1375 | 6900.0 |
| 2017-09-18 06:00:00 | AAPL | Stock | 40.16 | 40.1625 | 40.1125 | 40.15 | 29652.0 |
| 2017-09-18 07:00:00 | AAPL | Stock | 40.1425 | 40.1425 | 40.075 | 40.08 | 93996.0 |
| 2017-09-18 08:00:00 | AAPL | Stock | 40.08 | 40.145 | 39.97 | 40.02 | 308404.0 |
| 2017-09-18 09:00:00 | AAPL | Stock | 40.025 | 40.125 | 39.9275 | 40.018 | 14950288.0 |
| 2017-09-18 10:00:00 | AAPL | Stock | 40.015 | 40.03 | 39.7625 | 39.8288 | 16565940.0 |
| 2017-09-18 11:00:00 | AAPL | Stock | 39.8278 | 40.0225 | 39.8278 | 39.9375 | 9995728.0 |
| 2017-09-18 12:00:00 | AAPL | Stock | 39.9375 | 39.975 | 39.8675 | 39.9 | 4956580.0 |
| 2017-09-18 13:00:00 | AAPL | Stock | 39.9 | 39.905 | 39.8 | 39.8225 | 5579716.0 |
| 2017-09-18 14:00:00 | AAPL | Stock | 39.82 | 39.8375 | 39.4988 | 39.6075 | 18500884.0 |
| 2017-09-18 15:00:00 | AAPL | Stock | 39.605 | 39.7475 | 39.525 | 39.66 | 13838672.0 |
| 2017-09-18 16:00:00 | AAPL | Stock | 39.6675 | 39.9162 | 39.635 | 39.665 | 18073864.0 |
| 2017-09-18 17:00:00 | AAPL | Stock | 39.6825 | 39.6875 | 39.665 | 39.6875 | 24664.0 |
| 2017-09-18 18:00:00 | AAPL | Stock | 39.68 | 39.68 | 39.655 | 39.6625 | 32372.0 |
| 2017-09-18 19:00:00 | AAPL | Stock | 39.6675 | 39.6875 | 39.655 | 39.675 | 19020.0 |
| 2017-09-18 06:00:00 | MSFT | Stock | 75.53 | 75.53 | 75.53 | 75.53 | 300.0 |
| 2017-09-18 07:00:00 | MSFT | Stock | 75.5 | 75.5 | 75.47 | 75.48 | 2254.0 |
| 2017-09-18 08:00:00 | MSFT | Stock | 75.41 | 75.47 | 75.29 | 75.35 | 9729.0 |
| 2017-09-18 09:00:00 | MSFT | Stock | 75.35 | 75.53 | 75.15 | 75.52 | 1717256.0 |
| 2017-09-18 10:00:00 | MSFT | Stock | 75.515 | 75.66 | 75.49 | 75.6 | 1782883.0 |
| 2017-09-18 11:00:00 | MSFT | Stock | 75.6 | 75.89 | 75.585 | 75.845 | 1581141.0 |
| 2017-09-18 12:00:00 | MSFT | Stock | 75.85 | 75.97 | 75.54 | 75.6 | 1447014.0 |
| 2017-09-18 13:00:00 | MSFT | Stock | 75.605 | 75.71 | 75.515 | 75.58 | 1423565.0 |
| 2017-09-18 14:00:00 | MSFT | Stock | 75.58 | 75.59 | 75.07 | 75.17 | 3057083.0 |
| 2017-09-18 15:00:00 | MSFT | Stock | 75.17 | 75.28 | 75.04 | 75.16 | 2834502.0 |
| 2017-09-18 16:00:00 | MSFT | Stock | 75.16 | 75.477 | 75.16 | 75.477 | 7028897.0 |
| 2017-09-18 17:00:00 | MSFT | Stock | 75.09 | 75.1 | 75.08 | 75.1 | 776.0 |
| 2017-09-18 18:00:00 | MSFT | Stock | 75.11 | 75.11 | 75.11 | 75.11 | 100.0 |
| 2017-09-18 19:00:00 | MSFT | Stock | 75.15 | 75.17 | 75.15 | 75.17 | 1030.0 |
| 2017-09-18 04:00:00 | NVDA | Stock | 4.5175 | 4.5435 | 4.5175 | 4.5435 | 263200.0 |
| 2017-09-18 05:00:00 | NVDA | Stock | 4.55 | 4.5782 | 4.5498 | 4.575 | 639520.0 |
| 2017-09-18 06:00:00 | NVDA | Stock | 4.5838 | 4.622 | 4.5805 | 4.59 | 1222280.0 |
| 2017-09-18 07:00:00 | NVDA | Stock | 4.5925 | 4.61 | 4.59 | 4.604 | 2489840.0 |
| 2017-09-18 08:00:00 | NVDA | Stock | 4.6018 | 4.615 | 4.5028 | 4.615 | 10738840.0 |
| 2017-09-18 09:00:00 | NVDA | Stock | 4.6148 | 4.7108 | 4.6125 | 4.64 | 351258200.0 |
| 2017-09-18 10:00:00 | NVDA | Stock | 4.64 | 4.7205 | 4.6288 | 4.7098 | 253088360.0 |
| 2017-09-18 11:00:00 | NVDA | Stock | 4.7096 | 4.7525 | 4.7085 | 4.726 | 232389040.0 |
| 2017-09-18 12:00:00 | NVDA | Stock | 4.7268 | 4.746 | 4.721 | 4.733 | 107218600.0 |
| 2017-09-18 13:00:00 | NVDA | Stock | 4.7335 | 4.78 | 4.7298 | 4.7745 | 158828520.0 |
| 2017-09-18 14:00:00 | NVDA | Stock | 4.7742 | 4.775 | 4.647 | 4.6915 | 286099840.0 |
| 2017-09-18 15:00:00 | NVDA | Stock | 4.6918 | 4.7112 | 4.6652 | 4.6898 | 191354600.0 |
| 2017-09-18 16:00:00 | NVDA | Stock | 4.6923 | 4.711 | 4.6632 | 4.6862 | 44259920.0 |
| 2017-09-18 17:00:00 | NVDA | Stock | 4.686 | 4.686 | 4.6755 | 4.6775 | 10731640.0 |
| 2017-09-18 18:00:00 | NVDA | Stock | 4.6788 | 4.6888 | 4.6562 | 4.6575 | 3785440.0 |
| 2017-09-18 19:00:00 | NVDA | Stock | 4.655 | 4.6562 | 4.6422 | 4.6438 | 3468080.0 |
| 2017-09-18 06:00:00 | AMZN | Stock | 49.5595 | 49.5595 | 49.5595 | 49.5595 | 5000.0 |
| 2017-09-18 07:00:00 | AMZN | Stock | 49.511 | 49.5725 | 49.5 | 49.5325 | 34260.0 |
| 2017-09-18 08:00:00 | AMZN | Stock | 49.533 | 49.5375 | 49.425 | 49.4625 | 129140.0 |
| 2017-09-18 09:00:00 | AMZN | Stock | 49.475 | 49.6396 | 49.3425 | 49.4948 | 6922720.0 |
> showing 50 of 48,613 rows — these rows as CSV