PREVIEW / stock_1hour / 2000-02-01
file: by_date/stock_1hour/2000/2000-02-01.parquet size: 274 KB rows: 14,292 symbols: 1,130
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-02-01 09:00:00 | AAPL | Stock | 0.9286 | 0.9375 | 0.9163 | 0.9185 | 49840000.0 |
| 2000-02-01 10:00:00 | AAPL | Stock | 0.918 | 0.9286 | 0.9012 | 0.9113 | 73024000.0 |
| 2000-02-01 11:00:00 | AAPL | Stock | 0.911 | 0.9141 | 0.9018 | 0.9018 | 31360000.0 |
| 2000-02-01 12:00:00 | AAPL | Stock | 0.9018 | 0.9141 | 0.9018 | 0.9096 | 26342400.0 |
| 2000-02-01 13:00:00 | AAPL | Stock | 0.909 | 0.9196 | 0.9085 | 0.9146 | 24886400.0 |
| 2000-02-01 14:00:00 | AAPL | Stock | 0.9141 | 0.9174 | 0.9085 | 0.9118 | 21929600.0 |
| 2000-02-01 15:00:00 | AAPL | Stock | 0.9118 | 0.9196 | 0.8929 | 0.8951 | 68241600.0 |
| 2000-02-01 16:00:00 | AAPL | Stock | 0.8951 | 0.8984 | 0.8945 | 0.8951 | 2844800.0 |
| 2000-02-01 09:00:00 | MSFT | Stock | 49.25 | 49.9375 | 48.8438 | 49.4219 | 9643800.0 |
| 2000-02-01 10:00:00 | MSFT | Stock | 49.4375 | 50.375 | 49.0938 | 50.3125 | 14244600.0 |
| 2000-02-01 11:00:00 | MSFT | Stock | 50.3125 | 50.8125 | 50.125 | 50.2188 | 10116400.0 |
| 2000-02-01 12:00:00 | MSFT | Stock | 50.2188 | 50.875 | 50.125 | 50.5938 | 4972200.0 |
| 2000-02-01 13:00:00 | MSFT | Stock | 50.5938 | 50.875 | 50.2812 | 50.4062 | 3626200.0 |
| 2000-02-01 14:00:00 | MSFT | Stock | 50.4062 | 50.8438 | 50.375 | 50.6562 | 5400200.0 |
| 2000-02-01 15:00:00 | MSFT | Stock | 50.6562 | 51.625 | 50.4375 | 51.4688 | 15379400.0 |
| 2000-02-01 16:00:00 | MSFT | Stock | 51.4688 | 51.5312 | 51.4375 | 51.4688 | 631000.0 |
| 2000-02-01 09:00:00 | NVDA | Stock | 0.0773 | 0.0779 | 0.0771 | 0.0771 | 9600000.0 |
| 2000-02-01 10:00:00 | NVDA | Stock | 0.0771 | 0.0776 | 0.0745 | 0.075 | 17088000.0 |
| 2000-02-01 11:00:00 | NVDA | Stock | 0.075 | 0.0768 | 0.0749 | 0.0768 | 21792000.0 |
| 2000-02-01 12:00:00 | NVDA | Stock | 0.0755 | 0.0767 | 0.0753 | 0.076 | 4560000.0 |
| 2000-02-01 13:00:00 | NVDA | Stock | 0.076 | 0.0766 | 0.075 | 0.0759 | 17088000.0 |
| 2000-02-01 14:00:00 | NVDA | Stock | 0.0759 | 0.0797 | 0.0759 | 0.0786 | 14544000.0 |
| 2000-02-01 15:00:00 | NVDA | Stock | 0.0784 | 0.0792 | 0.0779 | 0.079 | 5712000.0 |
| 2000-02-01 16:00:00 | NVDA | Stock | 0.079 | 0.079 | 0.079 | 0.079 | 192000.0 |
| 2000-02-01 09:00:00 | AMZN | Stock | 3.375 | 3.3969 | 3.2719 | 3.3031 | 35040000.0 |
| 2000-02-01 10:00:00 | AMZN | Stock | 3.3062 | 3.3594 | 3.2188 | 3.3344 | 37814000.0 |
| 2000-02-01 11:00:00 | AMZN | Stock | 3.3344 | 3.525 | 3.3188 | 3.5188 | 74880000.0 |
| 2000-02-01 12:00:00 | AMZN | Stock | 3.525 | 3.5312 | 3.4312 | 3.45 | 29414000.0 |
| 2000-02-01 13:00:00 | AMZN | Stock | 3.4469 | 3.475 | 3.375 | 3.3844 | 19450000.0 |
| 2000-02-01 14:00:00 | AMZN | Stock | 3.3844 | 3.425 | 3.35 | 3.3719 | 22712000.0 |
| 2000-02-01 15:00:00 | AMZN | Stock | 3.3719 | 3.4344 | 3.3625 | 3.375 | 33752000.0 |
| 2000-02-01 16:00:00 | AMZN | Stock | 3.3734 | 3.375 | 3.3719 | 3.3719 | 608000.0 |
| 2000-02-01 09:00:00 | CL | Stock | 29.625 | 29.6562 | 29.4062 | 29.4062 | 201800.0 |
| 2000-02-01 10:00:00 | CL | Stock | 29.4062 | 29.5625 | 29.2188 | 29.5625 | 594000.0 |
| 2000-02-01 11:00:00 | CL | Stock | 29.5312 | 29.7188 | 29.4688 | 29.6562 | 379200.0 |
| 2000-02-01 12:00:00 | CL | Stock | 29.6875 | 30.0 | 29.5625 | 29.9688 | 518600.0 |
| 2000-02-01 13:00:00 | CL | Stock | 29.9688 | 30.0938 | 29.75 | 29.8438 | 406200.0 |
| 2000-02-01 14:00:00 | CL | Stock | 29.8438 | 30.0312 | 29.5938 | 29.625 | 305800.0 |
| 2000-02-01 15:00:00 | CL | Stock | 29.5938 | 30.0 | 29.5938 | 29.7812 | 598800.0 |
| 2000-02-01 16:00:00 | CL | Stock | 29.8125 | 29.8125 | 29.7812 | 29.8125 | 63800.0 |
> showing 40 of 14,292 rows — these rows as CSV