PREVIEW / stock_1hour / 2002-08-30
file: by_date/stock_1hour/2002/2002-08-30.parquet size: 392 KB rows: 18,770 symbols: 1,463
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-30 08:00:00 | AAPL | Stock | 0.2624 | 0.2624 | 0.2621 | 0.2621 | 1596000.0 |
| 2002-08-30 09:00:00 | AAPL | Stock | 0.262 | 0.2646 | 0.2613 | 0.2625 | 21946848.0 |
| 2002-08-30 10:00:00 | AAPL | Stock | 0.2623 | 0.2704 | 0.2618 | 0.2645 | 53879952.0 |
| 2002-08-30 11:00:00 | AAPL | Stock | 0.2643 | 0.2648 | 0.2627 | 0.2639 | 14734552.0 |
| 2002-08-30 12:00:00 | AAPL | Stock | 0.2639 | 0.2664 | 0.2632 | 0.2648 | 16404304.0 |
| 2002-08-30 13:00:00 | AAPL | Stock | 0.265 | 0.2661 | 0.2634 | 0.2654 | 10016048.0 |
| 2002-08-30 14:00:00 | AAPL | Stock | 0.2654 | 0.2675 | 0.2646 | 0.2661 | 13010760.0 |
| 2002-08-30 15:00:00 | AAPL | Stock | 0.2661 | 0.2666 | 0.2604 | 0.262 | 30003064.0 |
| 2002-08-30 16:00:00 | AAPL | Stock | 0.2623 | 0.2636 | 0.2618 | 0.2634 | 12867120.0 |
| 2002-08-30 17:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2625 | 0.2625 | 2956800.0 |
| 2002-08-30 18:00:00 | AAPL | Stock | 0.2646 | 0.2648 | 0.2634 | 0.2634 | 106400.0 |
| 2002-08-30 08:00:00 | MSFT | Stock | 24.695 | 25.215 | 24.67 | 25.115 | 14976.0 |
| 2002-08-30 09:00:00 | MSFT | Stock | 25.149 | 25.28 | 24.92 | 24.975 | 7669048.0 |
| 2002-08-30 10:00:00 | MSFT | Stock | 24.975 | 25.24 | 24.945 | 25.0 | 11857126.0 |
| 2002-08-30 11:00:00 | MSFT | Stock | 25.01 | 25.035 | 24.825 | 24.851 | 6195716.0 |
| 2002-08-30 12:00:00 | MSFT | Stock | 24.8528 | 25.045 | 24.775 | 25.0 | 5075294.0 |
| 2002-08-30 13:00:00 | MSFT | Stock | 25.0 | 25.015 | 24.88 | 24.95 | 2932492.0 |
| 2002-08-30 14:00:00 | MSFT | Stock | 24.945 | 25.175 | 24.93 | 25.025 | 6770134.0 |
| 2002-08-30 15:00:00 | MSFT | Stock | 25.025 | 25.052 | 24.5 | 24.545 | 10476200.0 |
| 2002-08-30 16:00:00 | MSFT | Stock | 24.545 | 24.65 | 24.515 | 24.585 | 5931852.0 |
| 2002-08-30 17:00:00 | MSFT | Stock | 24.54 | 24.58 | 24.54 | 24.575 | 400200.0 |
| 2002-08-30 18:00:00 | MSFT | Stock | 24.56 | 24.58 | 24.54 | 24.58 | 279800.0 |
| 2002-08-30 08:00:00 | NVDA | Stock | 0.0865 | 0.0865 | 0.0852 | 0.0852 | 3216000.0 |
| 2002-08-30 09:00:00 | NVDA | Stock | 0.0852 | 0.0883 | 0.0842 | 0.087 | 77666760.0 |
| 2002-08-30 10:00:00 | NVDA | Stock | 0.0868 | 0.0892 | 0.0867 | 0.0872 | 110136600.0 |
| 2002-08-30 11:00:00 | NVDA | Stock | 0.0872 | 0.0881 | 0.0863 | 0.0869 | 77222040.0 |
| 2002-08-30 12:00:00 | NVDA | Stock | 0.0868 | 0.0876 | 0.0868 | 0.0873 | 53651400.0 |
| 2002-08-30 13:00:00 | NVDA | Stock | 0.0873 | 0.0874 | 0.0862 | 0.0862 | 66982560.0 |
| 2002-08-30 14:00:00 | NVDA | Stock | 0.0862 | 0.0876 | 0.0825 | 0.0849 | 433743720.0 |
| 2002-08-30 15:00:00 | NVDA | Stock | 0.085 | 0.0853 | 0.0837 | 0.0843 | 199357680.0 |
| 2002-08-30 16:00:00 | NVDA | Stock | 0.0843 | 0.0846 | 0.083 | 0.0837 | 31209360.0 |
| 2002-08-30 17:00:00 | NVDA | Stock | 0.0842 | 0.0842 | 0.0836 | 0.0836 | 2398920.0 |
| 2002-08-30 18:00:00 | NVDA | Stock | 0.0836 | 0.084 | 0.0833 | 0.084 | 1913760.0 |
| 2002-08-30 08:00:00 | AMZN | Stock | 0.75 | 0.76 | 0.75 | 0.76 | 48000.0 |
| 2002-08-30 09:00:00 | AMZN | Stock | 0.7495 | 0.756 | 0.7375 | 0.751 | 12810960.0 |
| 2002-08-30 10:00:00 | AMZN | Stock | 0.751 | 0.769 | 0.751 | 0.7635 | 19432380.0 |
| 2002-08-30 11:00:00 | AMZN | Stock | 0.763 | 0.765 | 0.75 | 0.7505 | 4942000.0 |
| 2002-08-30 12:00:00 | AMZN | Stock | 0.75 | 0.761 | 0.75 | 0.758 | 4532380.0 |
| 2002-08-30 13:00:00 | AMZN | Stock | 0.758 | 0.76 | 0.754 | 0.758 | 3252000.0 |
| 2002-08-30 14:00:00 | AMZN | Stock | 0.7575 | 0.7655 | 0.7575 | 0.759 | 6315620.0 |
| 2002-08-30 15:00:00 | AMZN | Stock | 0.76 | 0.7605 | 0.7455 | 0.7495 | 11913420.0 |
| 2002-08-30 16:00:00 | AMZN | Stock | 0.749 | 0.7505 | 0.745 | 0.745 | 2795060.0 |
| 2002-08-30 17:00:00 | AMZN | Stock | 0.747 | 0.75 | 0.747 | 0.75 | 553000.0 |
| 2002-08-30 18:00:00 | AMZN | Stock | 0.747 | 0.747 | 0.747 | 0.747 | 2000.0 |
| 2002-08-30 09:00:00 | CL | Stock | 26.825 | 27.21 | 26.8 | 27.2 | 296400.0 |
| 2002-08-30 10:00:00 | CL | Stock | 27.205 | 27.375 | 27.2 | 27.305 | 505000.0 |
| 2002-08-30 11:00:00 | CL | Stock | 27.335 | 27.475 | 27.305 | 27.46 | 252000.0 |
| 2002-08-30 12:00:00 | CL | Stock | 27.455 | 27.5 | 27.365 | 27.425 | 342400.0 |
| 2002-08-30 13:00:00 | CL | Stock | 27.435 | 27.535 | 27.415 | 27.51 | 233000.0 |
| 2002-08-30 14:00:00 | CL | Stock | 27.515 | 27.575 | 27.34 | 27.36 | 293800.0 |
> showing 50 of 18,770 rows — these rows as CSV