PREVIEW / stock_1hour / 2011-12-30
file: by_date/stock_1hour/2011/2011-12-30.parquet size: 946 KB rows: 45,226 symbols: 3,599
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-30 05:00:00 | AAPL | Stock | 14.4457 | 14.4457 | 14.4457 | 14.4457 | 28000.0 |
| 2011-12-30 06:00:00 | AAPL | Stock | 14.4675 | 14.4675 | 14.4554 | 14.4571 | 17500.0 |
| 2011-12-30 07:00:00 | AAPL | Stock | 14.4718 | 14.4839 | 14.4604 | 14.4714 | 150780.0 |
| 2011-12-30 08:00:00 | AAPL | Stock | 14.4714 | 14.4714 | 14.4286 | 14.4357 | 444136.0 |
| 2011-12-30 09:00:00 | AAPL | Stock | 14.4389 | 14.4804 | 14.3925 | 14.4772 | 26116160.0 |
| 2011-12-30 10:00:00 | AAPL | Stock | 14.4775 | 14.51 | 14.4686 | 14.4732 | 28397376.0 |
| 2011-12-30 11:00:00 | AAPL | Stock | 14.4711 | 14.4875 | 14.4643 | 14.4675 | 17593996.0 |
| 2011-12-30 12:00:00 | AAPL | Stock | 14.4675 | 14.4811 | 14.4666 | 14.4782 | 16584260.0 |
| 2011-12-30 13:00:00 | AAPL | Stock | 14.4789 | 14.4857 | 14.475 | 14.4789 | 13278972.0 |
| 2011-12-30 14:00:00 | AAPL | Stock | 14.4793 | 14.4814 | 14.4614 | 14.4643 | 18498844.0 |
| 2011-12-30 15:00:00 | AAPL | Stock | 14.4654 | 14.4707 | 14.4514 | 14.4639 | 40914020.0 |
| 2011-12-30 16:00:00 | AAPL | Stock | 14.4643 | 14.4708 | 14.4607 | 14.4629 | 13872488.0 |
| 2011-12-30 17:00:00 | AAPL | Stock | 14.4643 | 14.4679 | 14.4643 | 14.4657 | 65576.0 |
| 2011-12-30 18:00:00 | AAPL | Stock | 14.4661 | 14.4693 | 14.4643 | 14.465 | 81340.0 |
| 2011-12-30 19:00:00 | AAPL | Stock | 14.4643 | 14.4668 | 14.46 | 14.4636 | 72856.0 |
| 2011-12-30 04:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.96 | 25.96 | 100.0 |
| 2011-12-30 05:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.96 | 25.96 | 300.0 |
| 2011-12-30 08:00:00 | MSFT | Stock | 26.02 | 26.03 | 26.02 | 26.02 | 3773.0 |
| 2011-12-30 09:00:00 | MSFT | Stock | 25.99 | 26.04 | 25.95 | 26.0 | 2062651.0 |
| 2011-12-30 10:00:00 | MSFT | Stock | 26.0 | 26.12 | 26.0 | 26.08 | 3469401.0 |
| 2011-12-30 11:00:00 | MSFT | Stock | 26.08 | 26.12 | 26.05 | 26.05 | 2433006.0 |
| 2011-12-30 12:00:00 | MSFT | Stock | 26.05 | 26.095 | 26.03 | 26.08 | 2141738.0 |
| 2011-12-30 13:00:00 | MSFT | Stock | 26.08 | 26.1 | 26.05 | 26.08 | 1832907.0 |
| 2011-12-30 14:00:00 | MSFT | Stock | 26.08 | 26.09 | 25.91 | 25.951 | 4475397.0 |
| 2011-12-30 15:00:00 | MSFT | Stock | 25.953 | 26.03 | 25.95 | 25.97 | 5470975.0 |
| 2011-12-30 16:00:00 | MSFT | Stock | 25.961 | 26.03 | 25.95 | 25.97 | 4326334.0 |
| 2011-12-30 17:00:00 | MSFT | Stock | 25.99 | 25.99 | 25.97 | 25.97 | 1432.0 |
| 2011-12-30 18:00:00 | MSFT | Stock | 25.97 | 26.0 | 25.97 | 25.99 | 700.0 |
| 2011-12-30 19:00:00 | MSFT | Stock | 25.97 | 25.97 | 25.97 | 25.97 | 573.0 |
| 2011-12-30 09:00:00 | NVDA | Stock | 0.3488 | 0.3513 | 0.3465 | 0.3513 | 19293480.0 |
| 2011-12-30 10:00:00 | NVDA | Stock | 0.3513 | 0.3518 | 0.3495 | 0.35 | 31047040.0 |
| 2011-12-30 11:00:00 | NVDA | Stock | 0.3502 | 0.3508 | 0.3493 | 0.3493 | 23966840.0 |
| 2011-12-30 12:00:00 | NVDA | Stock | 0.3493 | 0.35 | 0.3493 | 0.3495 | 13025960.0 |
| 2011-12-30 13:00:00 | NVDA | Stock | 0.3497 | 0.3498 | 0.3488 | 0.349 | 11914400.0 |
| 2011-12-30 14:00:00 | NVDA | Stock | 0.349 | 0.3492 | 0.3462 | 0.3465 | 24882840.0 |
| 2011-12-30 15:00:00 | NVDA | Stock | 0.3465 | 0.3475 | 0.346 | 0.3462 | 47176200.0 |
| 2011-12-30 16:00:00 | NVDA | Stock | 0.346 | 0.3493 | 0.3455 | 0.3464 | 3387720.0 |
| 2011-12-30 17:00:00 | NVDA | Stock | 0.347 | 0.348 | 0.3455 | 0.348 | 64000.0 |
| 2011-12-30 19:00:00 | NVDA | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 8000.0 |
| 2011-12-30 07:00:00 | AMZN | Stock | 8.71 | 8.71 | 8.71 | 8.71 | 2000.0 |
| 2011-12-30 08:00:00 | AMZN | Stock | 8.701 | 8.7355 | 8.7005 | 8.7005 | 229760.0 |
| 2011-12-30 09:00:00 | AMZN | Stock | 8.696 | 8.7585 | 8.6305 | 8.706 | 15273720.0 |
| 2011-12-30 10:00:00 | AMZN | Stock | 8.706 | 8.738 | 8.6525 | 8.658 | 16260080.0 |
| 2011-12-30 11:00:00 | AMZN | Stock | 8.6585 | 8.6945 | 8.642 | 8.668 | 13682280.0 |
| 2011-12-30 12:00:00 | AMZN | Stock | 8.6673 | 8.688 | 8.66 | 8.6805 | 7013300.0 |
| 2011-12-30 13:00:00 | AMZN | Stock | 8.682 | 8.6885 | 8.6565 | 8.6645 | 7930360.0 |
| 2011-12-30 14:00:00 | AMZN | Stock | 8.6645 | 8.6705 | 8.6245 | 8.6405 | 8695540.0 |
| 2011-12-30 15:00:00 | AMZN | Stock | 8.6415 | 8.6735 | 8.6407 | 8.6575 | 11785040.0 |
| 2011-12-30 16:00:00 | AMZN | Stock | 8.657 | 8.693 | 8.645 | 8.659 | 4034940.0 |
| 2011-12-30 17:00:00 | AMZN | Stock | 8.65 | 8.6535 | 8.6465 | 8.6465 | 15080.0 |
> showing 50 of 45,226 rows — these rows as CSV