PREVIEW / stock_1hour / 2000-01-11
file: by_date/stock_1hour/2000/2000-01-11.parquet size: 278 KB rows: 14,363 symbols: 1,133
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-01-11 09:00:00 | AAPL | Stock | 0.8566 | 0.8817 | 0.8504 | 0.8811 | 48507200.0 |
| 2000-01-11 10:00:00 | AAPL | Stock | 0.8809 | 0.8873 | 0.8605 | 0.8627 | 62652800.0 |
| 2000-01-11 11:00:00 | AAPL | Stock | 0.8633 | 0.8641 | 0.8516 | 0.8521 | 61443200.0 |
| 2000-01-11 12:00:00 | AAPL | Stock | 0.8532 | 0.8549 | 0.8465 | 0.8471 | 39166400.0 |
| 2000-01-11 13:00:00 | AAPL | Stock | 0.8465 | 0.851 | 0.8359 | 0.8443 | 54992000.0 |
| 2000-01-11 14:00:00 | AAPL | Stock | 0.8443 | 0.8527 | 0.8376 | 0.8393 | 60625600.0 |
| 2000-01-11 15:00:00 | AAPL | Stock | 0.8393 | 0.8426 | 0.8214 | 0.8281 | 84840000.0 |
| 2000-01-11 16:00:00 | AAPL | Stock | 0.8281 | 0.8281 | 0.8281 | 0.8281 | 571200.0 |
| 2000-01-11 09:00:00 | MSFT | Stock | 55.75 | 56.375 | 55.4062 | 56.3438 | 4939200.0 |
| 2000-01-11 10:00:00 | MSFT | Stock | 56.3438 | 56.7969 | 56.0 | 56.7969 | 7654200.0 |
| 2000-01-11 11:00:00 | MSFT | Stock | 56.75 | 57.125 | 56.25 | 56.4062 | 8000200.0 |
| 2000-01-11 12:00:00 | MSFT | Stock | 56.4219 | 56.75 | 55.9688 | 56.0625 | 4683600.0 |
| 2000-01-11 13:00:00 | MSFT | Stock | 56.0625 | 56.5 | 55.7188 | 56.4688 | 3639400.0 |
| 2000-01-11 14:00:00 | MSFT | Stock | 56.4688 | 56.5938 | 55.5 | 55.5625 | 4757200.0 |
| 2000-01-11 15:00:00 | MSFT | Stock | 55.5938 | 55.6875 | 54.3438 | 54.6719 | 10125200.0 |
| 2000-01-11 16:00:00 | MSFT | Stock | 54.6875 | 54.7188 | 54.6562 | 54.6875 | 201600.0 |
| 2000-01-11 09:00:00 | NVDA | Stock | 0.0896 | 0.0906 | 0.0891 | 0.0901 | 2112000.0 |
| 2000-01-11 10:00:00 | NVDA | Stock | 0.0906 | 0.0906 | 0.0882 | 0.0885 | 12000000.0 |
| 2000-01-11 11:00:00 | NVDA | Stock | 0.0885 | 0.0891 | 0.0872 | 0.0875 | 55152000.0 |
| 2000-01-11 12:00:00 | NVDA | Stock | 0.0876 | 0.0878 | 0.0867 | 0.0872 | 13296000.0 |
| 2000-01-11 13:00:00 | NVDA | Stock | 0.0875 | 0.0875 | 0.0867 | 0.0867 | 19872000.0 |
| 2000-01-11 14:00:00 | NVDA | Stock | 0.0868 | 0.0879 | 0.0867 | 0.0875 | 21024000.0 |
| 2000-01-11 15:00:00 | NVDA | Stock | 0.0875 | 0.0876 | 0.0865 | 0.0865 | 21072000.0 |
| 2000-01-11 16:00:00 | NVDA | Stock | 0.0865 | 0.0865 | 0.0865 | 0.0865 | 1872000.0 |
| 2000-01-11 09:00:00 | AMZN | Stock | 3.3438 | 3.5 | 3.3438 | 3.475 | 22236000.0 |
| 2000-01-11 10:00:00 | AMZN | Stock | 3.4656 | 3.4875 | 3.3938 | 3.4156 | 23708000.0 |
| 2000-01-11 11:00:00 | AMZN | Stock | 3.4125 | 3.4312 | 3.3375 | 3.3594 | 28066000.0 |
| 2000-01-11 12:00:00 | AMZN | Stock | 3.3594 | 3.3656 | 3.3062 | 3.35 | 21550000.0 |
| 2000-01-11 13:00:00 | AMZN | Stock | 3.35 | 3.3969 | 3.3344 | 3.3906 | 24052000.0 |
| 2000-01-11 14:00:00 | AMZN | Stock | 3.3906 | 3.4031 | 3.325 | 3.3281 | 23694000.0 |
| 2000-01-11 15:00:00 | AMZN | Stock | 3.3281 | 3.3625 | 3.25 | 3.3375 | 54978000.0 |
| 2000-01-11 16:00:00 | AMZN | Stock | 3.3344 | 3.3375 | 3.3062 | 3.3375 | 344000.0 |
| 2000-01-11 09:00:00 | CL | Stock | 31.5 | 32.0 | 31.4688 | 31.9688 | 522600.0 |
| 2000-01-11 10:00:00 | CL | Stock | 32.0 | 32.4062 | 31.9688 | 32.0312 | 914800.0 |
| 2000-01-11 11:00:00 | CL | Stock | 32.0312 | 32.3125 | 31.9375 | 32.0312 | 483000.0 |
| 2000-01-11 12:00:00 | CL | Stock | 32.0625 | 32.3438 | 32.0625 | 32.0938 | 625600.0 |
| 2000-01-11 13:00:00 | CL | Stock | 32.0938 | 32.2188 | 32.0625 | 32.0938 | 230200.0 |
| 2000-01-11 14:00:00 | CL | Stock | 32.125 | 32.1875 | 31.9375 | 32.0 | 443400.0 |
| 2000-01-11 15:00:00 | CL | Stock | 32.0312 | 32.0938 | 31.9375 | 32.0 | 491800.0 |
| 2000-01-11 16:00:00 | CL | Stock | 31.9688 | 32.0 | 31.9688 | 31.9688 | 101800.0 |
> showing 40 of 14,363 rows — these rows as CSV