PREVIEW / stock_1hour / 2001-01-12
file: by_date/stock_1hour/2001/2001-01-12.parquet size: 316 KB rows: 16,373 symbols: 1,261
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-12 08:00:00 | AAPL | Stock | 0.3214 | 0.3281 | 0.3153 | 0.3192 | 632800.0 |
| 2001-01-12 09:00:00 | AAPL | Stock | 0.3192 | 0.3214 | 0.3103 | 0.3125 | 52886400.0 |
| 2001-01-12 10:00:00 | AAPL | Stock | 0.3125 | 0.317 | 0.3069 | 0.3114 | 82135200.0 |
| 2001-01-12 11:00:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3069 | 0.3103 | 71080800.0 |
| 2001-01-12 12:00:00 | AAPL | Stock | 0.3114 | 0.3114 | 0.3058 | 0.308 | 37912000.0 |
| 2001-01-12 13:00:00 | AAPL | Stock | 0.3092 | 0.3103 | 0.3069 | 0.3103 | 20204800.0 |
| 2001-01-12 14:00:00 | AAPL | Stock | 0.3103 | 0.3103 | 0.3069 | 0.3092 | 42268800.0 |
| 2001-01-12 15:00:00 | AAPL | Stock | 0.3092 | 0.3092 | 0.3058 | 0.3069 | 54504800.0 |
| 2001-01-12 16:00:00 | AAPL | Stock | 0.3058 | 0.3092 | 0.3041 | 0.3069 | 8534400.0 |
| 2001-01-12 17:00:00 | AAPL | Stock | 0.3058 | 0.3058 | 0.3047 | 0.3047 | 123200.0 |
| 2001-01-12 18:00:00 | AAPL | Stock | 0.3058 | 0.3069 | 0.3058 | 0.3069 | 28000.0 |
| 2001-01-12 08:00:00 | MSFT | Stock | 27.5 | 27.5312 | 26.9688 | 27.3438 | 111200.0 |
| 2001-01-12 09:00:00 | MSFT | Stock | 27.375 | 27.5 | 26.8594 | 26.9375 | 9252000.0 |
| 2001-01-12 10:00:00 | MSFT | Stock | 27.0 | 27.3125 | 26.625 | 27.0 | 12604200.0 |
| 2001-01-12 11:00:00 | MSFT | Stock | 27.0 | 27.5 | 26.8438 | 26.875 | 9525000.0 |
| 2001-01-12 12:00:00 | MSFT | Stock | 26.875 | 26.9375 | 26.3438 | 26.4688 | 8291600.0 |
| 2001-01-12 13:00:00 | MSFT | Stock | 26.4688 | 26.9375 | 26.25 | 26.9375 | 8953600.0 |
| 2001-01-12 14:00:00 | MSFT | Stock | 26.9062 | 26.9688 | 26.625 | 26.8438 | 6893400.0 |
| 2001-01-12 15:00:00 | MSFT | Stock | 26.8125 | 27.0 | 26.6875 | 26.75 | 7480000.0 |
| 2001-01-12 16:00:00 | MSFT | Stock | 26.75 | 27.0625 | 26.6562 | 26.7812 | 2669600.0 |
| 2001-01-12 17:00:00 | MSFT | Stock | 26.8125 | 26.8438 | 26.75 | 26.75 | 5800.0 |
| 2001-01-12 18:00:00 | MSFT | Stock | 26.875 | 26.875 | 26.75 | 26.75 | 4000.0 |
| 2001-01-12 09:00:00 | NVDA | Stock | 0.2021 | 0.206 | 0.1938 | 0.1945 | 66264000.0 |
| 2001-01-12 10:00:00 | NVDA | Stock | 0.1951 | 0.2042 | 0.1945 | 0.2036 | 87264000.0 |
| 2001-01-12 11:00:00 | NVDA | Stock | 0.2036 | 0.2156 | 0.2031 | 0.2096 | 129888000.0 |
| 2001-01-12 12:00:00 | NVDA | Stock | 0.2091 | 0.2104 | 0.1984 | 0.2003 | 53448000.0 |
| 2001-01-12 13:00:00 | NVDA | Stock | 0.2003 | 0.2005 | 0.1958 | 0.1969 | 62448000.0 |
| 2001-01-12 14:00:00 | NVDA | Stock | 0.1966 | 0.1969 | 0.1948 | 0.1958 | 90864000.0 |
| 2001-01-12 15:00:00 | NVDA | Stock | 0.1964 | 0.2 | 0.1956 | 0.1958 | 72408000.0 |
| 2001-01-12 16:00:00 | NVDA | Stock | 0.1958 | 0.2083 | 0.1958 | 0.2083 | 4752000.0 |
| 2001-01-12 18:00:00 | NVDA | Stock | 0.1969 | 0.1969 | 0.1969 | 0.1969 | 24000.0 |
| 2001-01-12 08:00:00 | AMZN | Stock | 0.8469 | 0.8734 | 0.8375 | 0.8562 | 218000.0 |
| 2001-01-12 09:00:00 | AMZN | Stock | 0.8531 | 0.8875 | 0.85 | 0.8719 | 22136000.0 |
| 2001-01-12 10:00:00 | AMZN | Stock | 0.8719 | 0.9062 | 0.8562 | 0.9 | 31582000.0 |
| 2001-01-12 11:00:00 | AMZN | Stock | 0.9 | 0.925 | 0.8969 | 0.9031 | 30666000.0 |
| 2001-01-12 12:00:00 | AMZN | Stock | 0.9031 | 0.9062 | 0.8656 | 0.8719 | 17112000.0 |
| 2001-01-12 13:00:00 | AMZN | Stock | 0.8719 | 0.8875 | 0.8688 | 0.8844 | 11948000.0 |
| 2001-01-12 14:00:00 | AMZN | Stock | 0.8844 | 0.8875 | 0.8656 | 0.875 | 13248000.0 |
| 2001-01-12 15:00:00 | AMZN | Stock | 0.8719 | 0.8906 | 0.8719 | 0.8844 | 12252000.0 |
| 2001-01-12 16:00:00 | AMZN | Stock | 0.8875 | 0.8906 | 0.875 | 0.8781 | 2992000.0 |
| 2001-01-12 17:00:00 | AMZN | Stock | 0.8688 | 0.8812 | 0.8688 | 0.8781 | 44000.0 |
| 2001-01-12 18:00:00 | AMZN | Stock | 0.875 | 0.875 | 0.875 | 0.875 | 24000.0 |
| 2001-01-12 09:00:00 | CL | Stock | 29.08 | 29.325 | 29.075 | 29.325 | 233800.0 |
| 2001-01-12 10:00:00 | CL | Stock | 29.325 | 29.4 | 29.175 | 29.24 | 296200.0 |
| 2001-01-12 11:00:00 | CL | Stock | 29.245 | 29.425 | 29.025 | 29.07 | 418400.0 |
| 2001-01-12 12:00:00 | CL | Stock | 29.075 | 29.11 | 28.65 | 28.675 | 662200.0 |
| 2001-01-12 13:00:00 | CL | Stock | 28.655 | 28.825 | 28.55 | 28.825 | 346000.0 |
| 2001-01-12 14:00:00 | CL | Stock | 28.8 | 28.825 | 28.58 | 28.775 | 287400.0 |
| 2001-01-12 15:00:00 | CL | Stock | 28.8 | 29.0 | 28.75 | 29.0 | 409400.0 |
| 2001-01-12 16:00:00 | CL | Stock | 28.975 | 29.0 | 28.935 | 28.95 | 76800.0 |
> showing 50 of 16,373 rows — these rows as CSV