PREVIEW / stock_1hour / 2000-10-23
file: by_date/stock_1hour/2000/2000-10-23.parquet size: 303 KB rows: 15,563 symbols: 1,232
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-23 08:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3504 | 0.3527 | 252000.0 |
| 2000-10-23 09:00:00 | AAPL | Stock | 0.3527 | 0.3616 | 0.3471 | 0.3516 | 58279200.0 |
| 2000-10-23 10:00:00 | AAPL | Stock | 0.3516 | 0.3672 | 0.3504 | 0.365 | 144060000.0 |
| 2000-10-23 11:00:00 | AAPL | Stock | 0.365 | 0.365 | 0.3594 | 0.3627 | 53967200.0 |
| 2000-10-23 12:00:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3594 | 0.3627 | 79676800.0 |
| 2000-10-23 13:00:00 | AAPL | Stock | 0.3622 | 0.365 | 0.3605 | 0.3627 | 41361600.0 |
| 2000-10-23 14:00:00 | AAPL | Stock | 0.3622 | 0.3638 | 0.3571 | 0.3571 | 35728000.0 |
| 2000-10-23 15:00:00 | AAPL | Stock | 0.3571 | 0.365 | 0.3571 | 0.3616 | 71971200.0 |
| 2000-10-23 16:00:00 | AAPL | Stock | 0.3627 | 0.3728 | 0.3599 | 0.3661 | 31785600.0 |
| 2000-10-23 17:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3638 | 0.3644 | 140000.0 |
| 2000-10-23 18:00:00 | AAPL | Stock | 0.3638 | 0.3638 | 0.3638 | 0.3638 | 106400.0 |
| 2000-10-23 08:00:00 | MSFT | Stock | 32.5 | 32.5 | 32.0 | 32.3125 | 35800.0 |
| 2000-10-23 09:00:00 | MSFT | Stock | 32.3125 | 33.125 | 32.25 | 32.5312 | 14501400.0 |
| 2000-10-23 10:00:00 | MSFT | Stock | 32.5 | 32.5938 | 31.6562 | 31.7812 | 36630200.0 |
| 2000-10-23 11:00:00 | MSFT | Stock | 31.8125 | 31.9688 | 31.6562 | 31.75 | 11882800.0 |
| 2000-10-23 12:00:00 | MSFT | Stock | 31.7812 | 31.7812 | 31.0 | 31.2188 | 33891600.0 |
| 2000-10-23 13:00:00 | MSFT | Stock | 31.1875 | 31.2188 | 30.5312 | 30.6875 | 21467600.0 |
| 2000-10-23 14:00:00 | MSFT | Stock | 30.6719 | 30.875 | 30.3438 | 30.625 | 21364800.0 |
| 2000-10-23 15:00:00 | MSFT | Stock | 30.625 | 31.125 | 30.5 | 31.0312 | 27537800.0 |
| 2000-10-23 16:00:00 | MSFT | Stock | 31.0312 | 31.6562 | 30.7031 | 31.0 | 6042200.0 |
| 2000-10-23 17:00:00 | MSFT | Stock | 31.0625 | 31.0781 | 30.9375 | 31.0312 | 19800.0 |
| 2000-10-23 18:00:00 | MSFT | Stock | 31.0 | 31.0312 | 31.0 | 31.0312 | 5400.0 |
| 2000-10-23 09:00:00 | NVDA | Stock | 0.2924 | 0.2943 | 0.2893 | 0.2917 | 23496000.0 |
| 2000-10-23 10:00:00 | NVDA | Stock | 0.2917 | 0.2922 | 0.2818 | 0.2865 | 43176000.0 |
| 2000-10-23 11:00:00 | NVDA | Stock | 0.2865 | 0.2896 | 0.2818 | 0.2833 | 18624000.0 |
| 2000-10-23 12:00:00 | NVDA | Stock | 0.2828 | 0.2924 | 0.2828 | 0.2901 | 25512000.0 |
| 2000-10-23 13:00:00 | NVDA | Stock | 0.2896 | 0.2901 | 0.2867 | 0.2892 | 11112000.0 |
| 2000-10-23 14:00:00 | NVDA | Stock | 0.2893 | 0.2896 | 0.2776 | 0.2857 | 22152000.0 |
| 2000-10-23 15:00:00 | NVDA | Stock | 0.2841 | 0.2854 | 0.2745 | 0.2839 | 19056000.0 |
| 2000-10-23 16:00:00 | NVDA | Stock | 0.2836 | 0.2896 | 0.2831 | 0.2854 | 3864000.0 |
| 2000-10-23 08:00:00 | AMZN | Stock | 1.5344 | 1.5375 | 1.4781 | 1.4875 | 248000.0 |
| 2000-10-23 09:00:00 | AMZN | Stock | 1.4844 | 1.5094 | 1.4125 | 1.4141 | 24572000.0 |
| 2000-10-23 10:00:00 | AMZN | Stock | 1.4156 | 1.4594 | 1.3812 | 1.4406 | 40178000.0 |
| 2000-10-23 11:00:00 | AMZN | Stock | 1.4406 | 1.4438 | 1.4094 | 1.4156 | 16590000.0 |
| 2000-10-23 12:00:00 | AMZN | Stock | 1.4141 | 1.4188 | 1.3938 | 1.4062 | 24762000.0 |
| 2000-10-23 13:00:00 | AMZN | Stock | 1.4094 | 1.45 | 1.4062 | 1.45 | 18370000.0 |
| 2000-10-23 14:00:00 | AMZN | Stock | 1.45 | 1.4688 | 1.4313 | 1.45 | 22846000.0 |
| 2000-10-23 15:00:00 | AMZN | Stock | 1.45 | 1.5188 | 1.45 | 1.5 | 40370000.0 |
| 2000-10-23 16:00:00 | AMZN | Stock | 1.5 | 1.5125 | 1.4625 | 1.475 | 4018000.0 |
| 2000-10-23 17:00:00 | AMZN | Stock | 1.4875 | 1.4906 | 1.475 | 1.4813 | 74000.0 |
| 2000-10-23 18:00:00 | AMZN | Stock | 1.4813 | 1.4906 | 1.4813 | 1.4813 | 58000.0 |
| 2000-10-23 09:00:00 | CL | Stock | 25.3 | 25.31 | 25.125 | 25.125 | 385200.0 |
| 2000-10-23 10:00:00 | CL | Stock | 25.085 | 25.125 | 25.02 | 25.095 | 517600.0 |
| 2000-10-23 11:00:00 | CL | Stock | 25.095 | 25.1 | 24.84 | 24.86 | 838000.0 |
| 2000-10-23 12:00:00 | CL | Stock | 24.875 | 24.97 | 24.75 | 24.79 | 441800.0 |
| 2000-10-23 13:00:00 | CL | Stock | 24.8 | 24.925 | 24.8 | 24.865 | 329600.0 |
| 2000-10-23 14:00:00 | CL | Stock | 24.875 | 25.0 | 24.825 | 24.825 | 498200.0 |
| 2000-10-23 15:00:00 | CL | Stock | 24.85 | 24.95 | 24.67 | 24.705 | 1013600.0 |
| 2000-10-23 16:00:00 | CL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 128000.0 |
| 2000-10-23 17:00:00 | CL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 44000.0 |
> showing 50 of 15,563 rows — these rows as CSV