PREVIEW / stock_1hour / 2009-07-23
file: by_date/stock_1hour/2009/2009-07-23.parquet size: 870 KB rows: 41,919 symbols: 3,359
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-23 04:00:00 | AAPL | Stock | 5.6207 | 5.6207 | 5.6207 | 5.6207 | 8400.0 |
| 2009-07-23 07:00:00 | AAPL | Stock | 5.6071 | 5.6161 | 5.6068 | 5.6161 | 151200.0 |
| 2009-07-23 08:00:00 | AAPL | Stock | 5.6071 | 5.6175 | 5.5893 | 5.5929 | 1537480.0 |
| 2009-07-23 09:00:00 | AAPL | Stock | 5.5929 | 5.6286 | 5.5557 | 5.6286 | 78470672.0 |
| 2009-07-23 10:00:00 | AAPL | Stock | 5.6286 | 5.6418 | 5.6121 | 5.6203 | 95307016.0 |
| 2009-07-23 11:00:00 | AAPL | Stock | 5.6207 | 5.6511 | 5.6093 | 5.6364 | 77355460.0 |
| 2009-07-23 12:00:00 | AAPL | Stock | 5.6371 | 5.6545 | 5.635 | 5.6525 | 41637232.0 |
| 2009-07-23 13:00:00 | AAPL | Stock | 5.6521 | 5.6586 | 5.6393 | 5.6402 | 42441308.0 |
| 2009-07-23 14:00:00 | AAPL | Stock | 5.6407 | 5.6421 | 5.6136 | 5.6239 | 63347312.0 |
| 2009-07-23 15:00:00 | AAPL | Stock | 5.6239 | 5.6493 | 5.6086 | 5.6368 | 102170768.0 |
| 2009-07-23 16:00:00 | AAPL | Stock | 5.6368 | 5.6394 | 5.5646 | 5.5775 | 19938380.0 |
| 2009-07-23 17:00:00 | AAPL | Stock | 5.5775 | 5.5875 | 5.5714 | 5.5821 | 1198736.0 |
| 2009-07-23 18:00:00 | AAPL | Stock | 5.5807 | 5.6364 | 5.5732 | 5.5929 | 939344.0 |
| 2009-07-23 19:00:00 | AAPL | Stock | 5.59 | 5.5921 | 5.5739 | 5.5804 | 297640.0 |
| 2009-07-23 07:00:00 | MSFT | Stock | 24.99 | 24.99 | 24.9 | 24.9 | 9800.0 |
| 2009-07-23 08:00:00 | MSFT | Stock | 24.93 | 24.99 | 24.84 | 24.94 | 92123.0 |
| 2009-07-23 09:00:00 | MSFT | Stock | 24.94 | 25.08 | 24.84 | 25.08 | 6670633.0 |
| 2009-07-23 10:00:00 | MSFT | Stock | 25.08 | 25.331 | 25.03 | 25.267 | 14566763.0 |
| 2009-07-23 11:00:00 | MSFT | Stock | 25.27 | 25.5 | 25.25 | 25.36 | 11025306.0 |
| 2009-07-23 12:00:00 | MSFT | Stock | 25.37 | 25.46 | 25.29 | 25.46 | 8097100.0 |
| 2009-07-23 13:00:00 | MSFT | Stock | 25.457 | 25.66 | 25.4 | 25.583 | 10193492.0 |
| 2009-07-23 14:00:00 | MSFT | Stock | 25.59 | 25.65 | 25.44 | 25.628 | 10684589.0 |
| 2009-07-23 15:00:00 | MSFT | Stock | 25.62 | 25.72 | 25.34 | 25.57 | 26076591.0 |
| 2009-07-23 16:00:00 | MSFT | Stock | 25.57 | 25.6 | 23.31 | 23.5 | 14148167.0 |
| 2009-07-23 17:00:00 | MSFT | Stock | 23.5 | 23.73 | 23.45 | 23.5 | 1933765.0 |
| 2009-07-23 18:00:00 | MSFT | Stock | 23.52 | 25.56 | 23.5 | 23.65 | 727282.0 |
| 2009-07-23 19:00:00 | MSFT | Stock | 23.65 | 23.8 | 23.64 | 23.8 | 175846.0 |
| 2009-07-23 08:00:00 | NVDA | Stock | 0.3062 | 0.307 | 0.3062 | 0.3062 | 55840.0 |
| 2009-07-23 09:00:00 | NVDA | Stock | 0.3065 | 0.317 | 0.304 | 0.316 | 111801640.0 |
| 2009-07-23 10:00:00 | NVDA | Stock | 0.316 | 0.323 | 0.3123 | 0.32 | 270494720.0 |
| 2009-07-23 11:00:00 | NVDA | Stock | 0.32 | 0.325 | 0.3198 | 0.3235 | 147149840.0 |
| 2009-07-23 12:00:00 | NVDA | Stock | 0.3238 | 0.325 | 0.3218 | 0.3248 | 68535680.0 |
| 2009-07-23 13:00:00 | NVDA | Stock | 0.3248 | 0.325 | 0.322 | 0.3223 | 90082880.0 |
| 2009-07-23 14:00:00 | NVDA | Stock | 0.3223 | 0.3245 | 0.3203 | 0.324 | 101484120.0 |
| 2009-07-23 15:00:00 | NVDA | Stock | 0.324 | 0.326 | 0.3238 | 0.325 | 186403960.0 |
| 2009-07-23 16:00:00 | NVDA | Stock | 0.3248 | 0.3251 | 0.309 | 0.316 | 26787280.0 |
| 2009-07-23 17:00:00 | NVDA | Stock | 0.316 | 0.3246 | 0.3125 | 0.316 | 22000560.0 |
| 2009-07-23 18:00:00 | NVDA | Stock | 0.3163 | 0.3175 | 0.315 | 0.315 | 280000.0 |
| 2009-07-23 19:00:00 | NVDA | Stock | 0.3173 | 0.3173 | 0.3173 | 0.3173 | 20000.0 |
| 2009-07-23 04:00:00 | AMZN | Stock | 4.465 | 4.465 | 4.465 | 4.465 | 2000.0 |
| 2009-07-23 07:00:00 | AMZN | Stock | 4.5175 | 4.5175 | 4.5055 | 4.5055 | 14000.0 |
| 2009-07-23 08:00:00 | AMZN | Stock | 4.5125 | 4.515 | 4.5 | 4.513 | 439080.0 |
| 2009-07-23 09:00:00 | AMZN | Stock | 4.507 | 4.6335 | 4.4785 | 4.6235 | 41570220.0 |
| 2009-07-23 10:00:00 | AMZN | Stock | 4.625 | 4.693 | 4.6025 | 4.6775 | 69423680.0 |
| 2009-07-23 11:00:00 | AMZN | Stock | 4.6775 | 4.7095 | 4.657 | 4.6605 | 38896160.0 |
| 2009-07-23 12:00:00 | AMZN | Stock | 4.6605 | 4.703 | 4.6585 | 4.6975 | 24433940.0 |
| 2009-07-23 13:00:00 | AMZN | Stock | 4.6985 | 4.72 | 4.686 | 4.686 | 24225400.0 |
| 2009-07-23 14:00:00 | AMZN | Stock | 4.6865 | 4.7 | 4.66 | 4.67 | 27295420.0 |
| 2009-07-23 15:00:00 | AMZN | Stock | 4.6705 | 4.703 | 4.565 | 4.7015 | 46663640.0 |
| 2009-07-23 16:00:00 | AMZN | Stock | 4.7015 | 4.7125 | 4.2365 | 4.3235 | 88407600.0 |
> showing 50 of 41,919 rows — these rows as CSV