PREVIEW / stock_1hour / 2000-05-26
file: by_date/stock_1hour/2000/2000-05-26.parquet size: 270 KB rows: 14,106 symbols: 1,166
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-05-26 09:00:00 | AAPL | Stock | 0.7857 | 0.8025 | 0.7723 | 0.7723 | 32771200.0 |
| 2000-05-26 10:00:00 | AAPL | Stock | 0.7723 | 0.7785 | 0.7623 | 0.7701 | 41092800.0 |
| 2000-05-26 11:00:00 | AAPL | Stock | 0.7701 | 0.7857 | 0.7651 | 0.7765 | 22948800.0 |
| 2000-05-26 12:00:00 | AAPL | Stock | 0.7762 | 0.7835 | 0.7712 | 0.7757 | 20294400.0 |
| 2000-05-26 13:00:00 | AAPL | Stock | 0.7773 | 0.7773 | 0.7718 | 0.7734 | 10404800.0 |
| 2000-05-26 14:00:00 | AAPL | Stock | 0.7734 | 0.774 | 0.7662 | 0.769 | 22097600.0 |
| 2000-05-26 15:00:00 | AAPL | Stock | 0.7701 | 0.7723 | 0.7612 | 0.7712 | 24819200.0 |
| 2000-05-26 16:00:00 | AAPL | Stock | 0.7718 | 0.7718 | 0.7712 | 0.7712 | 1164800.0 |
| 2000-05-26 09:00:00 | MSFT | Stock | 31.0312 | 31.4688 | 30.8438 | 31.0625 | 9235000.0 |
| 2000-05-26 10:00:00 | MSFT | Stock | 31.0781 | 31.2188 | 30.75 | 31.0 | 8976200.0 |
| 2000-05-26 11:00:00 | MSFT | Stock | 30.9688 | 31.1875 | 30.875 | 31.0938 | 7420600.0 |
| 2000-05-26 12:00:00 | MSFT | Stock | 31.0938 | 31.125 | 30.7188 | 30.7812 | 4463400.0 |
| 2000-05-26 13:00:00 | MSFT | Stock | 30.75 | 30.7812 | 30.375 | 30.6562 | 5408600.0 |
| 2000-05-26 14:00:00 | MSFT | Stock | 30.625 | 30.75 | 30.3125 | 30.5625 | 7734400.0 |
| 2000-05-26 15:00:00 | MSFT | Stock | 30.5625 | 30.75 | 30.1875 | 30.7188 | 11090400.0 |
| 2000-05-26 16:00:00 | MSFT | Stock | 30.6875 | 30.7188 | 30.6875 | 30.7188 | 73400.0 |
| 2000-05-26 09:00:00 | NVDA | Stock | 0.2199 | 0.2259 | 0.2154 | 0.2156 | 29472000.0 |
| 2000-05-26 10:00:00 | NVDA | Stock | 0.2156 | 0.2183 | 0.2062 | 0.2133 | 65568000.0 |
| 2000-05-26 11:00:00 | NVDA | Stock | 0.2138 | 0.2172 | 0.2115 | 0.214 | 23136000.0 |
| 2000-05-26 12:00:00 | NVDA | Stock | 0.2141 | 0.2146 | 0.2116 | 0.213 | 11952000.0 |
| 2000-05-26 13:00:00 | NVDA | Stock | 0.2125 | 0.2146 | 0.2122 | 0.2141 | 8400000.0 |
| 2000-05-26 14:00:00 | NVDA | Stock | 0.2133 | 0.2141 | 0.2117 | 0.2141 | 15264000.0 |
| 2000-05-26 15:00:00 | NVDA | Stock | 0.2137 | 0.2206 | 0.2128 | 0.2194 | 24576000.0 |
| 2000-05-26 16:00:00 | NVDA | Stock | 0.2199 | 0.2199 | 0.2199 | 0.2199 | 96000.0 |
| 2000-05-26 09:00:00 | AMZN | Stock | 2.3125 | 2.3875 | 2.275 | 2.3 | 10472000.0 |
| 2000-05-26 10:00:00 | AMZN | Stock | 2.2969 | 2.3625 | 2.25 | 2.3062 | 17498000.0 |
| 2000-05-26 11:00:00 | AMZN | Stock | 2.3094 | 2.3453 | 2.2969 | 2.3313 | 6834000.0 |
| 2000-05-26 12:00:00 | AMZN | Stock | 2.3313 | 2.3406 | 2.275 | 2.2906 | 6942000.0 |
| 2000-05-26 13:00:00 | AMZN | Stock | 2.2906 | 2.3375 | 2.275 | 2.275 | 5426000.0 |
| 2000-05-26 14:00:00 | AMZN | Stock | 2.275 | 2.2875 | 2.2 | 2.275 | 11452000.0 |
| 2000-05-26 15:00:00 | AMZN | Stock | 2.275 | 2.325 | 2.2438 | 2.3219 | 11742000.0 |
| 2000-05-26 16:00:00 | AMZN | Stock | 2.325 | 2.325 | 2.3219 | 2.325 | 58000.0 |
| 2000-05-26 09:00:00 | CL | Stock | 28.0938 | 28.5 | 28.0938 | 28.1562 | 213600.0 |
| 2000-05-26 10:00:00 | CL | Stock | 28.125 | 28.125 | 27.6875 | 27.6875 | 438800.0 |
| 2000-05-26 11:00:00 | CL | Stock | 27.6875 | 27.8125 | 27.625 | 27.75 | 214200.0 |
| 2000-05-26 12:00:00 | CL | Stock | 27.75 | 27.8125 | 27.7188 | 27.7812 | 134800.0 |
| 2000-05-26 13:00:00 | CL | Stock | 27.7812 | 27.875 | 27.7188 | 27.875 | 120600.0 |
| 2000-05-26 14:00:00 | CL | Stock | 27.8438 | 28.125 | 27.8125 | 28.0 | 222600.0 |
| 2000-05-26 15:00:00 | CL | Stock | 28.0 | 28.0938 | 27.875 | 28.0 | 218800.0 |
| 2000-05-26 16:00:00 | CL | Stock | 28.0 | 28.0 | 27.875 | 27.875 | 55600.0 |
> showing 40 of 14,106 rows — these rows as CSV