PREVIEW / stock_1hour / 2017-05-11
file: by_date/stock_1hour/2017/2017-05-11.parquet size: 1.0 MB rows: 47,875 symbols: 3,034
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-05-11 04:00:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.2075 | 38.2075 | 2884.0 |
| 2017-05-11 05:00:00 | AAPL | Stock | 38.18 | 38.18 | 38.18 | 38.18 | 400.0 |
| 2017-05-11 06:00:00 | AAPL | Stock | 38.1875 | 38.2025 | 38.175 | 38.175 | 9620.0 |
| 2017-05-11 07:00:00 | AAPL | Stock | 38.1525 | 38.175 | 38.105 | 38.13 | 143624.0 |
| 2017-05-11 08:00:00 | AAPL | Stock | 38.145 | 38.215 | 38.12 | 38.17 | 328076.0 |
| 2017-05-11 09:00:00 | AAPL | Stock | 38.1675 | 38.39 | 38.0875 | 38.14 | 14719480.0 |
| 2017-05-11 10:00:00 | AAPL | Stock | 38.135 | 38.235 | 38.0775 | 38.115 | 12795820.0 |
| 2017-05-11 11:00:00 | AAPL | Stock | 38.1162 | 38.2225 | 38.0925 | 38.15 | 7581844.0 |
| 2017-05-11 12:00:00 | AAPL | Stock | 38.151 | 38.265 | 38.1425 | 38.1725 | 5848560.0 |
| 2017-05-11 13:00:00 | AAPL | Stock | 38.1725 | 38.335 | 38.16 | 38.325 | 7461832.0 |
| 2017-05-11 14:00:00 | AAPL | Stock | 38.3275 | 38.4275 | 38.2825 | 38.3488 | 10079604.0 |
| 2017-05-11 15:00:00 | AAPL | Stock | 38.35 | 38.5175 | 38.345 | 38.485 | 16606936.0 |
| 2017-05-11 16:00:00 | AAPL | Stock | 38.4875 | 38.5075 | 38.15 | 38.4625 | 8660548.0 |
| 2017-05-11 17:00:00 | AAPL | Stock | 38.46 | 38.465 | 38.45 | 38.465 | 37492.0 |
| 2017-05-11 18:00:00 | AAPL | Stock | 38.475 | 38.475 | 38.455 | 38.475 | 30780.0 |
| 2017-05-11 19:00:00 | AAPL | Stock | 38.47 | 38.4725 | 38.4625 | 38.47 | 10744.0 |
| 2017-05-11 04:00:00 | MSFT | Stock | 69.15 | 69.15 | 69.15 | 69.15 | 192.0 |
| 2017-05-11 07:00:00 | MSFT | Stock | 69.0 | 69.02 | 68.5 | 68.6 | 39117.0 |
| 2017-05-11 08:00:00 | MSFT | Stock | 68.75 | 68.75 | 68.41 | 68.5 | 139732.0 |
| 2017-05-11 09:00:00 | MSFT | Stock | 68.5 | 68.73 | 68.27 | 68.465 | 4457725.0 |
| 2017-05-11 10:00:00 | MSFT | Stock | 68.45 | 68.505 | 68.12 | 68.26 | 5128759.0 |
| 2017-05-11 11:00:00 | MSFT | Stock | 68.265 | 68.42 | 68.19 | 68.234 | 2191356.0 |
| 2017-05-11 12:00:00 | MSFT | Stock | 68.238 | 68.35 | 68.18 | 68.24 | 2229378.0 |
| 2017-05-11 13:00:00 | MSFT | Stock | 68.245 | 68.34 | 68.19 | 68.295 | 2277872.0 |
| 2017-05-11 14:00:00 | MSFT | Stock | 68.3 | 68.44 | 68.25 | 68.29 | 2149154.0 |
| 2017-05-11 15:00:00 | MSFT | Stock | 68.29 | 68.48 | 68.26 | 68.46 | 4044727.0 |
| 2017-05-11 16:00:00 | MSFT | Stock | 68.46 | 68.53 | 68.36 | 68.51 | 3451206.0 |
| 2017-05-11 17:00:00 | MSFT | Stock | 68.51 | 68.51 | 68.41 | 68.41 | 500.0 |
| 2017-05-11 18:00:00 | MSFT | Stock | 68.5 | 68.5 | 68.5 | 68.5 | 263.0 |
| 2017-05-11 19:00:00 | MSFT | Stock | 68.44 | 68.52 | 68.44 | 68.52 | 3456.0 |
| 2017-05-11 04:00:00 | NVDA | Stock | 3.0312 | 3.0312 | 3.0225 | 3.0253 | 116880.0 |
| 2017-05-11 05:00:00 | NVDA | Stock | 3.02 | 3.0238 | 3.015 | 3.0165 | 65040.0 |
| 2017-05-11 06:00:00 | NVDA | Stock | 3.017 | 3.0262 | 3.017 | 3.025 | 295800.0 |
| 2017-05-11 07:00:00 | NVDA | Stock | 3.026 | 3.0288 | 3.017 | 3.0198 | 469200.0 |
| 2017-05-11 08:00:00 | NVDA | Stock | 3.0188 | 3.0305 | 3.0075 | 3.0138 | 9106240.0 |
| 2017-05-11 09:00:00 | NVDA | Stock | 3.0138 | 3.087 | 2.9978 | 3.0788 | 273135080.0 |
| 2017-05-11 10:00:00 | NVDA | Stock | 3.0795 | 3.0968 | 3.0438 | 3.077 | 223748240.0 |
| 2017-05-11 11:00:00 | NVDA | Stock | 3.0772 | 3.1635 | 3.0758 | 3.1618 | 253701880.0 |
| 2017-05-11 12:00:00 | NVDA | Stock | 3.162 | 3.1888 | 3.1365 | 3.1885 | 179788360.0 |
| 2017-05-11 13:00:00 | NVDA | Stock | 3.1885 | 3.2413 | 3.1828 | 3.2375 | 236489960.0 |
| 2017-05-11 14:00:00 | NVDA | Stock | 3.238 | 3.2608 | 3.2065 | 3.23 | 314430200.0 |
| 2017-05-11 15:00:00 | NVDA | Stock | 3.23 | 3.23 | 3.1578 | 3.1608 | 270639160.0 |
| 2017-05-11 16:00:00 | NVDA | Stock | 3.1625 | 3.1632 | 3.1555 | 3.16 | 29458800.0 |
| 2017-05-11 17:00:00 | NVDA | Stock | 3.16 | 3.1613 | 3.1565 | 3.1588 | 387640.0 |
| 2017-05-11 18:00:00 | NVDA | Stock | 3.1565 | 3.1595 | 3.15 | 3.1525 | 1839000.0 |
| 2017-05-11 19:00:00 | NVDA | Stock | 3.1525 | 3.158 | 3.1355 | 3.1355 | 2010800.0 |
| 2017-05-11 05:00:00 | AMZN | Stock | 47.43 | 47.43 | 47.43 | 47.43 | 2000.0 |
| 2017-05-11 06:00:00 | AMZN | Stock | 47.4745 | 47.4745 | 47.4745 | 47.4745 | 2000.0 |
| 2017-05-11 07:00:00 | AMZN | Stock | 47.4535 | 47.4535 | 47.361 | 47.361 | 23240.0 |
| 2017-05-11 08:00:00 | AMZN | Stock | 47.3445 | 47.404 | 47.2 | 47.334 | 249180.0 |
> showing 50 of 47,875 rows — these rows as CSV