PREVIEW / stock_1hour / 2000-09-25
file: by_date/stock_1hour/2000/2000-09-25.parquet size: 307 KB rows: 15,686 symbols: 1,231
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-09-25 08:00:00 | AAPL | Stock | 0.9509 | 0.9665 | 0.9509 | 0.9609 | 2027200.0 |
| 2000-09-25 09:00:00 | AAPL | Stock | 0.9598 | 0.9788 | 0.942 | 0.9676 | 42044800.0 |
| 2000-09-25 10:00:00 | AAPL | Stock | 0.9676 | 0.971 | 0.9621 | 0.9654 | 44542400.0 |
| 2000-09-25 11:00:00 | AAPL | Stock | 0.9643 | 0.971 | 0.9621 | 0.9643 | 68829600.0 |
| 2000-09-25 12:00:00 | AAPL | Stock | 0.9643 | 0.9743 | 0.9643 | 0.9688 | 37088800.0 |
| 2000-09-25 13:00:00 | AAPL | Stock | 0.9676 | 0.971 | 0.9643 | 0.971 | 41725600.0 |
| 2000-09-25 14:00:00 | AAPL | Stock | 0.971 | 0.9754 | 0.9442 | 0.9576 | 78758400.0 |
| 2000-09-25 15:00:00 | AAPL | Stock | 0.9565 | 0.9643 | 0.9464 | 0.9542 | 81048800.0 |
| 2000-09-25 16:00:00 | AAPL | Stock | 0.9542 | 0.9637 | 0.9464 | 0.9464 | 21229600.0 |
| 2000-09-25 17:00:00 | AAPL | Stock | 0.9442 | 0.9442 | 0.942 | 0.942 | 151200.0 |
| 2000-09-25 18:00:00 | AAPL | Stock | 0.9397 | 0.9397 | 0.9397 | 0.9397 | 44800.0 |
| 2000-09-25 08:00:00 | MSFT | Stock | 31.625 | 31.875 | 31.625 | 31.875 | 30400.0 |
| 2000-09-25 09:00:00 | MSFT | Stock | 31.75 | 31.875 | 31.1875 | 31.2188 | 4382400.0 |
| 2000-09-25 10:00:00 | MSFT | Stock | 31.2188 | 31.25 | 30.75 | 30.8438 | 8106800.0 |
| 2000-09-25 11:00:00 | MSFT | Stock | 30.8125 | 30.9688 | 30.5938 | 30.75 | 6598000.0 |
| 2000-09-25 12:00:00 | MSFT | Stock | 30.75 | 30.7812 | 30.5 | 30.5312 | 6310000.0 |
| 2000-09-25 13:00:00 | MSFT | Stock | 30.5312 | 30.625 | 30.375 | 30.5625 | 6940200.0 |
| 2000-09-25 14:00:00 | MSFT | Stock | 30.5312 | 30.7188 | 30.3438 | 30.5 | 5961600.0 |
| 2000-09-25 15:00:00 | MSFT | Stock | 30.4688 | 30.6562 | 30.2188 | 30.625 | 11295200.0 |
| 2000-09-25 16:00:00 | MSFT | Stock | 30.6562 | 31.0625 | 30.4375 | 30.5625 | 1791800.0 |
| 2000-09-25 17:00:00 | MSFT | Stock | 30.5625 | 30.6875 | 30.5 | 30.5938 | 7200.0 |
| 2000-09-25 18:00:00 | MSFT | Stock | 30.6562 | 30.6562 | 30.5 | 30.5938 | 6000.0 |
| 2000-09-25 09:00:00 | NVDA | Stock | 0.3 | 0.3083 | 0.3 | 0.3068 | 34512000.0 |
| 2000-09-25 10:00:00 | NVDA | Stock | 0.3065 | 0.3174 | 0.3044 | 0.3083 | 108000000.0 |
| 2000-09-25 11:00:00 | NVDA | Stock | 0.3083 | 0.3156 | 0.3078 | 0.312 | 77376000.0 |
| 2000-09-25 12:00:00 | NVDA | Stock | 0.3125 | 0.3151 | 0.3109 | 0.3141 | 55848000.0 |
| 2000-09-25 13:00:00 | NVDA | Stock | 0.3148 | 0.3156 | 0.313 | 0.3146 | 31992000.0 |
| 2000-09-25 14:00:00 | NVDA | Stock | 0.3151 | 0.3198 | 0.3146 | 0.3188 | 69552000.0 |
| 2000-09-25 15:00:00 | NVDA | Stock | 0.3188 | 0.3188 | 0.3115 | 0.3151 | 61752000.0 |
| 2000-09-25 16:00:00 | NVDA | Stock | 0.3156 | 0.3198 | 0.3146 | 0.3167 | 17544000.0 |
| 2000-09-25 17:00:00 | NVDA | Stock | 0.3206 | 0.3206 | 0.3206 | 0.3206 | 24000.0 |
| 2000-09-25 18:00:00 | NVDA | Stock | 0.3185 | 0.3185 | 0.3185 | 0.3185 | 24000.0 |
| 2000-09-25 08:00:00 | AMZN | Stock | 2.0625 | 2.0719 | 2.0125 | 2.0719 | 168000.0 |
| 2000-09-25 09:00:00 | AMZN | Stock | 2.0656 | 2.0938 | 2.0188 | 2.0625 | 12192000.0 |
| 2000-09-25 10:00:00 | AMZN | Stock | 2.0688 | 2.1188 | 2.0562 | 2.1125 | 18086000.0 |
| 2000-09-25 11:00:00 | AMZN | Stock | 2.1125 | 2.1188 | 2.075 | 2.075 | 10530000.0 |
| 2000-09-25 12:00:00 | AMZN | Stock | 2.0781 | 2.1281 | 2.0781 | 2.1188 | 14414000.0 |
| 2000-09-25 13:00:00 | AMZN | Stock | 2.1219 | 2.1281 | 2.0562 | 2.0844 | 14566000.0 |
| 2000-09-25 14:00:00 | AMZN | Stock | 2.0813 | 2.0875 | 2.0438 | 2.0656 | 11552000.0 |
| 2000-09-25 15:00:00 | AMZN | Stock | 2.0562 | 2.0844 | 2.0 | 2.0156 | 20568000.0 |
| 2000-09-25 16:00:00 | AMZN | Stock | 2.0219 | 2.0719 | 2.0188 | 2.0312 | 3378000.0 |
| 2000-09-25 17:00:00 | AMZN | Stock | 2.0312 | 2.0312 | 2.0312 | 2.0312 | 10000.0 |
| 2000-09-25 09:00:00 | CL | Stock | 22.575 | 22.775 | 22.375 | 22.425 | 683200.0 |
| 2000-09-25 10:00:00 | CL | Stock | 22.425 | 22.425 | 22.25 | 22.3 | 478400.0 |
| 2000-09-25 11:00:00 | CL | Stock | 22.31 | 22.375 | 22.05 | 22.175 | 511200.0 |
| 2000-09-25 12:00:00 | CL | Stock | 22.175 | 22.275 | 22.025 | 22.2 | 442400.0 |
| 2000-09-25 13:00:00 | CL | Stock | 22.17 | 22.35 | 22.16 | 22.2 | 658600.0 |
| 2000-09-25 14:00:00 | CL | Stock | 22.235 | 22.425 | 22.1 | 22.425 | 441600.0 |
| 2000-09-25 15:00:00 | CL | Stock | 22.44 | 22.475 | 22.15 | 22.29 | 844000.0 |
| 2000-09-25 16:00:00 | CL | Stock | 22.29 | 22.31 | 22.27 | 22.31 | 98800.0 |
> showing 50 of 15,686 rows — these rows as CSV