PREVIEW / stock_1hour / 2017-05-24
file: by_date/stock_1hour/2017/2017-05-24.parquet size: 1.0 MB rows: 47,491 symbols: 3,023
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-24 04:00:00 | AAPL | Stock | 38.5125 | 38.5125 | 38.5125 | 38.5125 | 400.0 |
| 2017-05-24 06:00:00 | AAPL | Stock | 38.535 | 38.55 | 38.5 | 38.5 | 15988.0 |
| 2017-05-24 07:00:00 | AAPL | Stock | 38.4775 | 38.5 | 38.475 | 38.5 | 11368.0 |
| 2017-05-24 08:00:00 | AAPL | Stock | 38.5 | 38.535 | 38.4275 | 38.475 | 130372.0 |
| 2017-05-24 09:00:00 | AAPL | Stock | 38.4625 | 38.5425 | 38.4025 | 38.41 | 8636552.0 |
| 2017-05-24 10:00:00 | AAPL | Stock | 38.4112 | 38.4285 | 38.26 | 38.2875 | 12349592.0 |
| 2017-05-24 11:00:00 | AAPL | Stock | 38.2875 | 38.315 | 38.1675 | 38.2225 | 10714276.0 |
| 2017-05-24 12:00:00 | AAPL | Stock | 38.22 | 38.33 | 38.2125 | 38.2712 | 6481620.0 |
| 2017-05-24 13:00:00 | AAPL | Stock | 38.271 | 38.335 | 38.2475 | 38.2962 | 4290304.0 |
| 2017-05-24 14:00:00 | AAPL | Stock | 38.2975 | 38.3725 | 38.2675 | 38.28 | 10444472.0 |
| 2017-05-24 15:00:00 | AAPL | Stock | 38.2825 | 38.3375 | 38.2275 | 38.325 | 12433780.0 |
| 2017-05-24 16:00:00 | AAPL | Stock | 38.3075 | 38.335 | 38.3 | 38.335 | 4535032.0 |
| 2017-05-24 17:00:00 | AAPL | Stock | 38.325 | 38.34 | 38.325 | 38.325 | 59112.0 |
| 2017-05-24 18:00:00 | AAPL | Stock | 38.325 | 38.34 | 38.3025 | 38.3175 | 20540.0 |
| 2017-05-24 19:00:00 | AAPL | Stock | 38.3175 | 38.34 | 38.3125 | 38.3125 | 20860.0 |
| 2017-05-24 08:00:00 | MSFT | Stock | 68.53 | 68.74 | 68.53 | 68.7 | 3661.0 |
| 2017-05-24 09:00:00 | MSFT | Stock | 68.74 | 68.88 | 68.468 | 68.59 | 1778312.0 |
| 2017-05-24 10:00:00 | MSFT | Stock | 68.6 | 68.65 | 68.505 | 68.59 | 1334427.0 |
| 2017-05-24 11:00:00 | MSFT | Stock | 68.58 | 68.67 | 68.52 | 68.6 | 1286794.0 |
| 2017-05-24 12:00:00 | MSFT | Stock | 68.607 | 68.655 | 68.55 | 68.58 | 794932.0 |
| 2017-05-24 13:00:00 | MSFT | Stock | 68.59 | 68.61 | 68.45 | 68.56 | 898200.0 |
| 2017-05-24 14:00:00 | MSFT | Stock | 68.56 | 68.69 | 68.51 | 68.645 | 1612792.0 |
| 2017-05-24 15:00:00 | MSFT | Stock | 68.65 | 68.79 | 68.59 | 68.77 | 3725773.0 |
| 2017-05-24 16:00:00 | MSFT | Stock | 68.77 | 68.77 | 68.69 | 68.77 | 1941427.0 |
| 2017-05-24 17:00:00 | MSFT | Stock | 68.77 | 68.77 | 68.69 | 68.69 | 20655.0 |
| 2017-05-24 18:00:00 | MSFT | Stock | 68.69 | 68.69 | 68.69 | 68.69 | 205.0 |
| 2017-05-24 19:00:00 | MSFT | Stock | 68.7 | 68.75 | 68.7 | 68.75 | 200.0 |
| 2017-05-24 04:00:00 | NVDA | Stock | 3.5 | 3.5 | 3.4752 | 3.4925 | 460920.0 |
| 2017-05-24 05:00:00 | NVDA | Stock | 3.4932 | 3.5375 | 3.4932 | 3.5288 | 396920.0 |
| 2017-05-24 06:00:00 | NVDA | Stock | 3.5308 | 3.546 | 3.5062 | 3.525 | 1189400.0 |
| 2017-05-24 07:00:00 | NVDA | Stock | 3.525 | 3.55 | 3.506 | 3.5388 | 7002760.0 |
| 2017-05-24 08:00:00 | NVDA | Stock | 3.5395 | 3.5498 | 3.5062 | 3.5138 | 14866960.0 |
| 2017-05-24 09:00:00 | NVDA | Stock | 3.514 | 3.5375 | 3.478 | 3.498 | 222480720.0 |
| 2017-05-24 10:00:00 | NVDA | Stock | 3.4978 | 3.502 | 3.472 | 3.4953 | 139720040.0 |
| 2017-05-24 11:00:00 | NVDA | Stock | 3.4959 | 3.4962 | 3.465 | 3.467 | 83955040.0 |
| 2017-05-24 12:00:00 | NVDA | Stock | 3.467 | 3.4788 | 3.464 | 3.474 | 76302640.0 |
| 2017-05-24 13:00:00 | NVDA | Stock | 3.4735 | 3.4738 | 3.456 | 3.4679 | 53352760.0 |
| 2017-05-24 14:00:00 | NVDA | Stock | 3.4672 | 3.4808 | 3.452 | 3.467 | 84070720.0 |
| 2017-05-24 15:00:00 | NVDA | Stock | 3.4669 | 3.4738 | 3.463 | 3.4642 | 82751080.0 |
| 2017-05-24 16:00:00 | NVDA | Stock | 3.4642 | 3.4672 | 3.4625 | 3.4663 | 2727080.0 |
| 2017-05-24 17:00:00 | NVDA | Stock | 3.4672 | 3.4672 | 3.4623 | 3.4623 | 211840.0 |
| 2017-05-24 18:00:00 | NVDA | Stock | 3.4612 | 3.4675 | 3.4612 | 3.4672 | 247760.0 |
| 2017-05-24 19:00:00 | NVDA | Stock | 3.4672 | 3.4725 | 3.465 | 3.467 | 301880.0 |
| 2017-05-24 07:00:00 | AMZN | Stock | 48.65 | 48.65 | 48.65 | 48.65 | 2000.0 |
| 2017-05-24 08:00:00 | AMZN | Stock | 48.65 | 48.6585 | 48.64 | 48.6585 | 27000.0 |
| 2017-05-24 09:00:00 | AMZN | Stock | 48.65 | 48.8 | 48.5115 | 48.606 | 7839100.0 |
| 2017-05-24 10:00:00 | AMZN | Stock | 48.6053 | 48.7515 | 48.6053 | 48.651 | 4443020.0 |
| 2017-05-24 11:00:00 | AMZN | Stock | 48.656 | 48.6995 | 48.5395 | 48.6575 | 3375120.0 |
| 2017-05-24 12:00:00 | AMZN | Stock | 48.6435 | 48.7215 | 48.6 | 48.7055 | 2096040.0 |
| 2017-05-24 13:00:00 | AMZN | Stock | 48.7 | 48.7835 | 48.6858 | 48.7744 | 2992220.0 |
> showing 50 of 47,491 rows — these rows as CSV