PREVIEW / stock_1hour / 2000-01-14
file: by_date/stock_1hour/2000/2000-01-14.parquet size: 284 KB rows: 14,500 symbols: 1,132
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-14 09:00:00 | AAPL | Stock | 0.8929 | 0.9085 | 0.8878 | 0.8884 | 96140800.0 |
| 2000-01-14 10:00:00 | AAPL | Stock | 0.8884 | 0.9129 | 0.8873 | 0.9107 | 98582400.0 |
| 2000-01-14 11:00:00 | AAPL | Stock | 0.9118 | 0.9129 | 0.8929 | 0.8996 | 25558400.0 |
| 2000-01-14 12:00:00 | AAPL | Stock | 0.8973 | 0.9035 | 0.8917 | 0.9023 | 41260800.0 |
| 2000-01-14 13:00:00 | AAPL | Stock | 0.9029 | 0.9046 | 0.9012 | 0.9023 | 22848000.0 |
| 2000-01-14 14:00:00 | AAPL | Stock | 0.9035 | 0.9063 | 0.8962 | 0.9012 | 29646400.0 |
| 2000-01-14 15:00:00 | AAPL | Stock | 0.9018 | 0.9107 | 0.8962 | 0.8968 | 53603200.0 |
| 2000-01-14 16:00:00 | AAPL | Stock | 0.8968 | 0.8968 | 0.8962 | 0.8968 | 2654400.0 |
| 2000-01-14 09:00:00 | MSFT | Stock | 53.5938 | 55.0625 | 52.875 | 54.6562 | 13629800.0 |
| 2000-01-14 10:00:00 | MSFT | Stock | 54.6406 | 55.125 | 54.1875 | 54.6406 | 13047000.0 |
| 2000-01-14 11:00:00 | MSFT | Stock | 54.6562 | 55.5938 | 54.5 | 55.5312 | 7744400.0 |
| 2000-01-14 12:00:00 | MSFT | Stock | 55.5312 | 55.625 | 54.8438 | 55.2188 | 7063600.0 |
| 2000-01-14 13:00:00 | MSFT | Stock | 55.1875 | 56.125 | 55.1875 | 56.0625 | 6800400.0 |
| 2000-01-14 14:00:00 | MSFT | Stock | 56.0938 | 56.625 | 55.875 | 56.25 | 9497200.0 |
| 2000-01-14 15:00:00 | MSFT | Stock | 56.2188 | 56.9688 | 55.75 | 56.125 | 10954400.0 |
| 2000-01-14 16:00:00 | MSFT | Stock | 56.125 | 56.125 | 55.875 | 56.125 | 306000.0 |
| 2000-01-14 09:00:00 | NVDA | Stock | 0.0891 | 0.0917 | 0.0889 | 0.0896 | 74064000.0 |
| 2000-01-14 10:00:00 | NVDA | Stock | 0.0896 | 0.0896 | 0.0888 | 0.0895 | 72096000.0 |
| 2000-01-14 11:00:00 | NVDA | Stock | 0.0896 | 0.0911 | 0.0896 | 0.0906 | 33024000.0 |
| 2000-01-14 12:00:00 | NVDA | Stock | 0.0906 | 0.0906 | 0.0896 | 0.0898 | 25440000.0 |
| 2000-01-14 13:00:00 | NVDA | Stock | 0.09 | 0.0906 | 0.0896 | 0.0906 | 37824000.0 |
| 2000-01-14 14:00:00 | NVDA | Stock | 0.0896 | 0.0909 | 0.0896 | 0.0908 | 19680000.0 |
| 2000-01-14 15:00:00 | NVDA | Stock | 0.0909 | 0.0952 | 0.0898 | 0.0915 | 317328000.0 |
| 2000-01-14 09:00:00 | AMZN | Stock | 3.3375 | 3.4312 | 3.325 | 3.3656 | 25416000.0 |
| 2000-01-14 10:00:00 | AMZN | Stock | 3.3656 | 3.375 | 3.3125 | 3.3562 | 22392000.0 |
| 2000-01-14 11:00:00 | AMZN | Stock | 3.3562 | 3.375 | 3.35 | 3.3594 | 7808000.0 |
| 2000-01-14 12:00:00 | AMZN | Stock | 3.3562 | 3.3594 | 3.3062 | 3.3438 | 11656000.0 |
| 2000-01-14 13:00:00 | AMZN | Stock | 3.3438 | 3.3625 | 3.3 | 3.3469 | 6918000.0 |
| 2000-01-14 14:00:00 | AMZN | Stock | 3.3469 | 3.3562 | 3.25 | 3.2594 | 27060000.0 |
| 2000-01-14 15:00:00 | AMZN | Stock | 3.2688 | 3.275 | 3.2 | 3.2125 | 26530000.0 |
| 2000-01-14 16:00:00 | AMZN | Stock | 3.2125 | 3.2188 | 3.2 | 3.2125 | 1292000.0 |
| 2000-01-14 09:00:00 | CL | Stock | 33.0 | 33.375 | 32.8125 | 32.875 | 949000.0 |
| 2000-01-14 10:00:00 | CL | Stock | 32.9062 | 32.9375 | 31.9375 | 31.9375 | 709000.0 |
| 2000-01-14 11:00:00 | CL | Stock | 31.8125 | 31.8438 | 31.125 | 31.3438 | 901000.0 |
| 2000-01-14 12:00:00 | CL | Stock | 31.25 | 31.7188 | 31.0312 | 31.7188 | 419800.0 |
| 2000-01-14 13:00:00 | CL | Stock | 31.6875 | 31.9375 | 31.6875 | 31.9062 | 490800.0 |
| 2000-01-14 14:00:00 | CL | Stock | 31.9062 | 32.0 | 31.75 | 31.875 | 438400.0 |
| 2000-01-14 15:00:00 | CL | Stock | 31.8438 | 31.9375 | 31.625 | 31.6562 | 679200.0 |
| 2000-01-14 16:00:00 | CL | Stock | 31.6562 | 31.6875 | 31.6562 | 31.6562 | 81600.0 |
> showing 39 of 14,500 rows — these rows as CSV