PREVIEW / stock_1hour / 2017-07-11
file: by_date/stock_1hour/2017/2017-07-11.parquet size: 1.0 MB rows: 48,078 symbols: 3,001
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-11 04:00:00 | AAPL | Stock | 36.2325 | 36.275 | 36.225 | 36.25 | 10132.0 |
| 2017-07-11 05:00:00 | AAPL | Stock | 36.25 | 36.25 | 36.2125 | 36.2125 | 5148.0 |
| 2017-07-11 06:00:00 | AAPL | Stock | 36.2275 | 36.2375 | 36.19 | 36.2375 | 32700.0 |
| 2017-07-11 07:00:00 | AAPL | Stock | 36.2125 | 36.225 | 36.1025 | 36.125 | 88544.0 |
| 2017-07-11 08:00:00 | AAPL | Stock | 36.125 | 36.2375 | 36.0875 | 36.17 | 210392.0 |
| 2017-07-11 09:00:00 | AAPL | Stock | 36.15 | 36.2675 | 36.105 | 36.2045 | 10048852.0 |
| 2017-07-11 10:00:00 | AAPL | Stock | 36.205 | 36.4325 | 36.16 | 36.3365 | 11317156.0 |
| 2017-07-11 11:00:00 | AAPL | Stock | 36.335 | 36.35 | 36.095 | 36.28 | 10852136.0 |
| 2017-07-11 12:00:00 | AAPL | Stock | 36.28 | 36.305 | 36.1825 | 36.2775 | 4861124.0 |
| 2017-07-11 13:00:00 | AAPL | Stock | 36.28 | 36.4325 | 36.25 | 36.4125 | 6725120.0 |
| 2017-07-11 14:00:00 | AAPL | Stock | 36.4125 | 36.4625 | 36.3525 | 36.365 | 5677340.0 |
| 2017-07-11 15:00:00 | AAPL | Stock | 36.3638 | 36.445 | 36.3575 | 36.3875 | 10216700.0 |
| 2017-07-11 16:00:00 | AAPL | Stock | 36.3875 | 36.4175 | 36.37 | 36.37 | 7966336.0 |
| 2017-07-11 17:00:00 | AAPL | Stock | 36.37 | 36.3875 | 36.37 | 36.3825 | 8452.0 |
| 2017-07-11 18:00:00 | AAPL | Stock | 36.3875 | 36.395 | 36.3825 | 36.3875 | 171480.0 |
| 2017-07-11 19:00:00 | AAPL | Stock | 36.3875 | 36.395 | 36.3875 | 36.3875 | 9316.0 |
| 2017-07-11 08:00:00 | MSFT | Stock | 69.91 | 69.93 | 69.8 | 69.84 | 4138.0 |
| 2017-07-11 09:00:00 | MSFT | Stock | 69.75 | 70.17 | 69.75 | 70.14 | 1804721.0 |
| 2017-07-11 10:00:00 | MSFT | Stock | 70.14 | 70.68 | 70.11 | 70.375 | 2812190.0 |
| 2017-07-11 11:00:00 | MSFT | Stock | 70.376 | 70.48 | 69.82 | 70.09 | 2848529.0 |
| 2017-07-11 12:00:00 | MSFT | Stock | 70.09 | 70.145 | 69.85 | 70.0 | 950427.0 |
| 2017-07-11 13:00:00 | MSFT | Stock | 70.0 | 70.17 | 69.925 | 70.135 | 1011402.0 |
| 2017-07-11 14:00:00 | MSFT | Stock | 70.14 | 70.23 | 70.01 | 70.02 | 1154856.0 |
| 2017-07-11 15:00:00 | MSFT | Stock | 70.025 | 70.21 | 69.99 | 70.0 | 3662011.0 |
| 2017-07-11 16:00:00 | MSFT | Stock | 70.0 | 70.1 | 69.99 | 70.03 | 2017824.0 |
| 2017-07-11 17:00:00 | MSFT | Stock | 70.36 | 70.36 | 70.02 | 70.02 | 350.0 |
| 2017-07-11 18:00:00 | MSFT | Stock | 70.14 | 70.14 | 70.01 | 70.01 | 246.0 |
| 2017-07-11 19:00:00 | MSFT | Stock | 70.05 | 70.05 | 70.05 | 70.05 | 400.0 |
| 2017-07-11 04:00:00 | NVDA | Stock | 3.86 | 3.8625 | 3.86 | 3.8625 | 21080.0 |
| 2017-07-11 05:00:00 | NVDA | Stock | 3.8618 | 3.8618 | 3.85 | 3.8598 | 72080.0 |
| 2017-07-11 06:00:00 | NVDA | Stock | 3.861 | 3.8618 | 3.8462 | 3.855 | 164200.0 |
| 2017-07-11 07:00:00 | NVDA | Stock | 3.8572 | 3.858 | 3.847 | 3.8475 | 346200.0 |
| 2017-07-11 08:00:00 | NVDA | Stock | 3.85 | 3.8575 | 3.838 | 3.8482 | 3633920.0 |
| 2017-07-11 09:00:00 | NVDA | Stock | 3.8488 | 3.8635 | 3.8038 | 3.8498 | 161070200.0 |
| 2017-07-11 10:00:00 | NVDA | Stock | 3.8488 | 3.8693 | 3.8333 | 3.8545 | 134270160.0 |
| 2017-07-11 11:00:00 | NVDA | Stock | 3.8546 | 3.8625 | 3.8128 | 3.8515 | 111336720.0 |
| 2017-07-11 12:00:00 | NVDA | Stock | 3.8515 | 3.86 | 3.8295 | 3.8508 | 65995960.0 |
| 2017-07-11 13:00:00 | NVDA | Stock | 3.8508 | 3.8708 | 3.846 | 3.869 | 50288480.0 |
| 2017-07-11 14:00:00 | NVDA | Stock | 3.8682 | 3.8772 | 3.8665 | 3.8725 | 49967640.0 |
| 2017-07-11 15:00:00 | NVDA | Stock | 3.8728 | 3.9048 | 3.8693 | 3.897 | 109238080.0 |
| 2017-07-11 16:00:00 | NVDA | Stock | 3.897 | 3.9 | 3.8377 | 3.9 | 48613120.0 |
| 2017-07-11 17:00:00 | NVDA | Stock | 3.9 | 3.905 | 3.8992 | 3.9008 | 814200.0 |
| 2017-07-11 18:00:00 | NVDA | Stock | 3.9002 | 3.9002 | 3.8978 | 3.9 | 319680.0 |
| 2017-07-11 19:00:00 | NVDA | Stock | 3.899 | 3.9 | 3.8988 | 3.9 | 491920.0 |
| 2017-07-11 04:00:00 | AMZN | Stock | 49.972 | 49.972 | 49.905 | 49.905 | 8000.0 |
| 2017-07-11 07:00:00 | AMZN | Stock | 49.856 | 49.875 | 49.8005 | 49.833 | 36620.0 |
| 2017-07-11 08:00:00 | AMZN | Stock | 49.8305 | 49.875 | 49.7375 | 49.787 | 283580.0 |
| 2017-07-11 09:00:00 | AMZN | Stock | 49.7425 | 49.7425 | 49.3365 | 49.594 | 11071240.0 |
| 2017-07-11 10:00:00 | AMZN | Stock | 49.5815 | 49.764 | 49.462 | 49.5719 | 7546260.0 |
| 2017-07-11 11:00:00 | AMZN | Stock | 49.5717 | 49.6755 | 49.186 | 49.5372 | 7854240.0 |
> showing 50 of 48,078 rows — these rows as CSV