PREVIEW / stock_1hour / 2017-06-29
file: by_date/stock_1hour/2017/2017-06-29.parquet size: 1.0 MB rows: 48,505 symbols: 3,019
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-29 04:00:00 | AAPL | Stock | 36.4475 | 36.45 | 36.385 | 36.385 | 11864.0 |
| 2017-06-29 05:00:00 | AAPL | Stock | 36.375 | 36.3925 | 36.3475 | 36.3475 | 14704.0 |
| 2017-06-29 06:00:00 | AAPL | Stock | 36.3525 | 36.3525 | 36.31 | 36.3225 | 34380.0 |
| 2017-06-29 07:00:00 | AAPL | Stock | 36.325 | 36.435 | 36.325 | 36.4 | 79684.0 |
| 2017-06-29 08:00:00 | AAPL | Stock | 36.4 | 36.4 | 36.2075 | 36.2125 | 450484.0 |
| 2017-06-29 09:00:00 | AAPL | Stock | 36.2125 | 36.2825 | 36.05 | 36.095 | 14139936.0 |
| 2017-06-29 10:00:00 | AAPL | Stock | 36.0975 | 36.19 | 35.9925 | 36.0808 | 15956016.0 |
| 2017-06-29 11:00:00 | AAPL | Stock | 36.0775 | 36.1275 | 35.7475 | 35.8 | 17460364.0 |
| 2017-06-29 12:00:00 | AAPL | Stock | 35.805 | 35.9825 | 35.6825 | 35.72 | 12802748.0 |
| 2017-06-29 13:00:00 | AAPL | Stock | 35.7222 | 35.7975 | 35.57 | 35.615 | 15275516.0 |
| 2017-06-29 14:00:00 | AAPL | Stock | 35.6125 | 35.82 | 35.575 | 35.76 | 12152176.0 |
| 2017-06-29 15:00:00 | AAPL | Stock | 35.76 | 36.015 | 35.75 | 35.9175 | 19243348.0 |
| 2017-06-29 16:00:00 | AAPL | Stock | 35.92 | 35.9625 | 35.8125 | 35.8925 | 7307984.0 |
| 2017-06-29 17:00:00 | AAPL | Stock | 35.89 | 35.92 | 35.8375 | 35.8375 | 221392.0 |
| 2017-06-29 18:00:00 | AAPL | Stock | 35.8725 | 35.885 | 35.8225 | 35.8325 | 25304.0 |
| 2017-06-29 19:00:00 | AAPL | Stock | 35.8325 | 35.8625 | 35.825 | 35.8475 | 39356.0 |
| 2017-06-29 04:00:00 | MSFT | Stock | 70.15 | 70.15 | 69.9 | 69.9 | 3100.0 |
| 2017-06-29 06:00:00 | MSFT | Stock | 69.88 | 69.88 | 69.85 | 69.85 | 1450.0 |
| 2017-06-29 07:00:00 | MSFT | Stock | 69.8 | 69.8 | 69.8 | 69.8 | 700.0 |
| 2017-06-29 08:00:00 | MSFT | Stock | 69.9 | 69.9 | 69.3 | 69.3 | 8033.0 |
| 2017-06-29 09:00:00 | MSFT | Stock | 69.31 | 69.5 | 68.7 | 68.888 | 2692548.0 |
| 2017-06-29 10:00:00 | MSFT | Stock | 68.89 | 69.086 | 68.7 | 68.945 | 3422395.0 |
| 2017-06-29 11:00:00 | MSFT | Stock | 68.94 | 68.99 | 68.46 | 68.5 | 3551570.0 |
| 2017-06-29 12:00:00 | MSFT | Stock | 68.5 | 68.74 | 68.38 | 68.41 | 3085589.0 |
| 2017-06-29 13:00:00 | MSFT | Stock | 68.407 | 68.55 | 68.09 | 68.42 | 3714643.0 |
| 2017-06-29 14:00:00 | MSFT | Stock | 68.41 | 68.54 | 68.13 | 68.28 | 3795028.0 |
| 2017-06-29 15:00:00 | MSFT | Stock | 68.27 | 68.77 | 68.26 | 68.5 | 4610055.0 |
| 2017-06-29 16:00:00 | MSFT | Stock | 68.49 | 68.66 | 68.49 | 68.51 | 1697491.0 |
| 2017-06-29 17:00:00 | MSFT | Stock | 68.5 | 68.51 | 68.25 | 68.25 | 21970.0 |
| 2017-06-29 18:00:00 | MSFT | Stock | 68.4 | 68.47 | 68.37 | 68.4 | 2700.0 |
| 2017-06-29 19:00:00 | MSFT | Stock | 68.39 | 68.44 | 68.39 | 68.44 | 2200.0 |
| 2017-06-29 04:00:00 | NVDA | Stock | 3.815 | 3.8218 | 3.815 | 3.8215 | 20000.0 |
| 2017-06-29 05:00:00 | NVDA | Stock | 3.8215 | 3.8215 | 3.8025 | 3.8025 | 116000.0 |
| 2017-06-29 06:00:00 | NVDA | Stock | 3.8108 | 3.8108 | 3.7925 | 3.7942 | 71920.0 |
| 2017-06-29 07:00:00 | NVDA | Stock | 3.8045 | 3.805 | 3.7875 | 3.7975 | 488960.0 |
| 2017-06-29 08:00:00 | NVDA | Stock | 3.8 | 3.8038 | 3.7505 | 3.7622 | 5025840.0 |
| 2017-06-29 09:00:00 | NVDA | Stock | 3.7558 | 3.768 | 3.69 | 3.7038 | 135118880.0 |
| 2017-06-29 10:00:00 | NVDA | Stock | 3.7038 | 3.7225 | 3.6792 | 3.6875 | 149383400.0 |
| 2017-06-29 11:00:00 | NVDA | Stock | 3.6878 | 3.7072 | 3.6302 | 3.6455 | 180145200.0 |
| 2017-06-29 12:00:00 | NVDA | Stock | 3.6466 | 3.674 | 3.6375 | 3.643 | 95843720.0 |
| 2017-06-29 13:00:00 | NVDA | Stock | 3.6428 | 3.656 | 3.602 | 3.6312 | 134628600.0 |
| 2017-06-29 14:00:00 | NVDA | Stock | 3.631 | 3.6708 | 3.6212 | 3.661 | 99237600.0 |
| 2017-06-29 15:00:00 | NVDA | Stock | 3.661 | 3.6848 | 3.653 | 3.6678 | 148495000.0 |
| 2017-06-29 16:00:00 | NVDA | Stock | 3.6662 | 3.6778 | 3.65 | 3.6575 | 60171600.0 |
| 2017-06-29 17:00:00 | NVDA | Stock | 3.6568 | 3.667 | 3.6475 | 3.6568 | 3091400.0 |
| 2017-06-29 18:00:00 | NVDA | Stock | 3.6618 | 3.6618 | 3.629 | 3.6375 | 2360880.0 |
| 2017-06-29 19:00:00 | NVDA | Stock | 3.64 | 3.6495 | 3.634 | 3.6475 | 529680.0 |
| 2017-06-29 04:00:00 | AMZN | Stock | 49.755 | 49.755 | 49.55 | 49.6 | 22000.0 |
| 2017-06-29 05:00:00 | AMZN | Stock | 49.55 | 49.575 | 49.55 | 49.575 | 4000.0 |
| 2017-06-29 06:00:00 | AMZN | Stock | 49.51 | 49.5165 | 49.4605 | 49.5165 | 10340.0 |
> showing 50 of 48,505 rows — these rows as CSV