PREVIEW / stock_1hour / 2009-05-21
file: by_date/stock_1hour/2009/2009-05-21.parquet size: 833 KB rows: 40,897 symbols: 3,343
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-05-21 06:00:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 5600.0 |
| 2009-05-21 07:00:00 | AAPL | Stock | 4.4757 | 4.4821 | 4.4757 | 4.4796 | 67200.0 |
| 2009-05-21 08:00:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4593 | 4.4679 | 584808.0 |
| 2009-05-21 09:00:00 | AAPL | Stock | 4.4686 | 4.5279 | 4.4464 | 4.5093 | 61463556.0 |
| 2009-05-21 10:00:00 | AAPL | Stock | 4.508 | 4.5239 | 4.4446 | 4.445 | 70139860.0 |
| 2009-05-21 11:00:00 | AAPL | Stock | 4.445 | 4.4461 | 4.4046 | 4.4314 | 62719832.0 |
| 2009-05-21 12:00:00 | AAPL | Stock | 4.4311 | 4.4363 | 4.4096 | 4.4286 | 34502496.0 |
| 2009-05-21 13:00:00 | AAPL | Stock | 4.4268 | 4.4368 | 4.3961 | 4.4261 | 37332596.0 |
| 2009-05-21 14:00:00 | AAPL | Stock | 4.4261 | 4.4757 | 4.3889 | 4.4046 | 51316524.0 |
| 2009-05-21 15:00:00 | AAPL | Stock | 4.4046 | 4.4375 | 4.3954 | 4.4257 | 71292928.0 |
| 2009-05-21 16:00:00 | AAPL | Stock | 4.4254 | 4.4582 | 4.4202 | 4.4393 | 15925616.0 |
| 2009-05-21 17:00:00 | AAPL | Stock | 4.4389 | 4.44 | 4.4128 | 4.4389 | 316400.0 |
| 2009-05-21 18:00:00 | AAPL | Stock | 4.4379 | 4.4379 | 4.4304 | 4.4311 | 604492.0 |
| 2009-05-21 19:00:00 | AAPL | Stock | 4.4321 | 4.4389 | 4.4275 | 4.4275 | 156800.0 |
| 2009-05-21 08:00:00 | MSFT | Stock | 20.36 | 20.4 | 20.25 | 20.25 | 10489.0 |
| 2009-05-21 09:00:00 | MSFT | Stock | 20.26 | 20.26 | 20.01 | 20.03 | 6169176.0 |
| 2009-05-21 10:00:00 | MSFT | Stock | 20.03 | 20.11 | 19.73 | 19.73 | 10930287.0 |
| 2009-05-21 11:00:00 | MSFT | Stock | 19.73 | 20.122 | 19.67 | 19.74 | 6677157.0 |
| 2009-05-21 12:00:00 | MSFT | Stock | 19.75 | 19.8 | 19.69 | 19.73 | 5832614.0 |
| 2009-05-21 13:00:00 | MSFT | Stock | 19.72 | 19.78 | 19.585 | 19.649 | 5487791.0 |
| 2009-05-21 14:00:00 | MSFT | Stock | 19.65 | 19.7 | 19.51 | 19.63 | 6083714.0 |
| 2009-05-21 15:00:00 | MSFT | Stock | 19.63 | 19.88 | 19.6 | 19.84 | 13285805.0 |
| 2009-05-21 16:00:00 | MSFT | Stock | 19.88 | 19.89 | 19.73 | 19.84 | 3591179.0 |
| 2009-05-21 17:00:00 | MSFT | Stock | 19.84 | 19.84 | 19.78 | 19.79 | 13670.0 |
| 2009-05-21 18:00:00 | MSFT | Stock | 19.82 | 19.82 | 19.8 | 19.82 | 3010.0 |
| 2009-05-21 19:00:00 | MSFT | Stock | 19.82 | 19.85 | 19.79 | 19.79 | 5740.0 |
| 2009-05-21 07:00:00 | NVDA | Stock | 0.2462 | 0.247 | 0.2462 | 0.247 | 80000.0 |
| 2009-05-21 08:00:00 | NVDA | Stock | 0.245 | 0.245 | 0.2322 | 0.2412 | 468000.0 |
| 2009-05-21 09:00:00 | NVDA | Stock | 0.2398 | 0.245 | 0.2332 | 0.241 | 123272880.0 |
| 2009-05-21 10:00:00 | NVDA | Stock | 0.2412 | 0.2442 | 0.2375 | 0.2382 | 151258400.0 |
| 2009-05-21 11:00:00 | NVDA | Stock | 0.238 | 0.2399 | 0.2358 | 0.2398 | 125346040.0 |
| 2009-05-21 12:00:00 | NVDA | Stock | 0.2398 | 0.2415 | 0.238 | 0.2415 | 70109080.0 |
| 2009-05-21 13:00:00 | NVDA | Stock | 0.2415 | 0.2418 | 0.237 | 0.2378 | 80330320.0 |
| 2009-05-21 14:00:00 | NVDA | Stock | 0.2375 | 0.2386 | 0.235 | 0.2362 | 81944560.0 |
| 2009-05-21 15:00:00 | NVDA | Stock | 0.2365 | 0.243 | 0.2362 | 0.2415 | 303074240.0 |
| 2009-05-21 16:00:00 | NVDA | Stock | 0.2415 | 0.2445 | 0.2399 | 0.2422 | 22850280.0 |
| 2009-05-21 17:00:00 | NVDA | Stock | 0.2438 | 0.2438 | 0.2438 | 0.2438 | 16160.0 |
| 2009-05-21 19:00:00 | NVDA | Stock | 0.2425 | 0.2425 | 0.2422 | 0.2425 | 108000.0 |
| 2009-05-21 07:00:00 | AMZN | Stock | 3.9175 | 3.9175 | 3.9175 | 3.9175 | 6000.0 |
| 2009-05-21 08:00:00 | AMZN | Stock | 3.885 | 3.885 | 3.8585 | 3.8585 | 90680.0 |
| 2009-05-21 09:00:00 | AMZN | Stock | 3.86 | 3.8985 | 3.81 | 3.8765 | 18318020.0 |
| 2009-05-21 10:00:00 | AMZN | Stock | 3.878 | 3.897 | 3.814 | 3.817 | 16319000.0 |
| 2009-05-21 11:00:00 | AMZN | Stock | 3.8165 | 3.8199 | 3.77 | 3.8075 | 17392620.0 |
| 2009-05-21 12:00:00 | AMZN | Stock | 3.808 | 3.812 | 3.782 | 3.803 | 10193220.0 |
| 2009-05-21 13:00:00 | AMZN | Stock | 3.802 | 3.811 | 3.77 | 3.788 | 9942240.0 |
| 2009-05-21 14:00:00 | AMZN | Stock | 3.788 | 3.802 | 3.7705 | 3.7845 | 13329520.0 |
| 2009-05-21 15:00:00 | AMZN | Stock | 3.7835 | 3.811 | 3.775 | 3.8005 | 21519660.0 |
| 2009-05-21 16:00:00 | AMZN | Stock | 3.7955 | 3.8112 | 3.7955 | 3.798 | 5313740.0 |
| 2009-05-21 17:00:00 | AMZN | Stock | 3.786 | 3.8125 | 3.786 | 3.8125 | 164760.0 |
| 2009-05-21 18:00:00 | AMZN | Stock | 3.8075 | 3.8075 | 3.8065 | 3.8065 | 5860.0 |
> showing 50 of 40,897 rows — these rows as CSV