PREVIEW / stock_1hour / 2000-05-02
file: by_date/stock_1hour/2000/2000-05-02.parquet size: 284 KB rows: 14,451 symbols: 1,162
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-02 09:00:00 | AAPL | Stock | 1.1004 | 1.1105 | 1.0949 | 1.1074 | 40465600.0 |
| 2000-05-02 10:00:00 | AAPL | Stock | 1.1071 | 1.1272 | 1.1027 | 1.1189 | 49313600.0 |
| 2000-05-02 11:00:00 | AAPL | Stock | 1.1189 | 1.1267 | 1.1094 | 1.115 | 18816000.0 |
| 2000-05-02 12:00:00 | AAPL | Stock | 1.1166 | 1.1205 | 1.1077 | 1.1161 | 10953600.0 |
| 2000-05-02 13:00:00 | AAPL | Stock | 1.115 | 1.1172 | 1.1071 | 1.1083 | 11289600.0 |
| 2000-05-02 14:00:00 | AAPL | Stock | 1.1099 | 1.1105 | 1.0871 | 1.0871 | 32491200.0 |
| 2000-05-02 15:00:00 | AAPL | Stock | 1.0876 | 1.0977 | 1.0491 | 1.0536 | 57556800.0 |
| 2000-05-02 16:00:00 | AAPL | Stock | 1.0525 | 1.0541 | 1.0525 | 1.0525 | 929600.0 |
| 2000-05-02 09:00:00 | MSFT | Stock | 36.4062 | 36.75 | 35.6875 | 35.8125 | 17315000.0 |
| 2000-05-02 10:00:00 | MSFT | Stock | 35.9062 | 36.0 | 35.2812 | 35.5625 | 22816800.0 |
| 2000-05-02 11:00:00 | MSFT | Stock | 35.5625 | 35.6875 | 35.4375 | 35.5625 | 8241800.0 |
| 2000-05-02 12:00:00 | MSFT | Stock | 35.5625 | 35.75 | 35.5 | 35.6875 | 6205800.0 |
| 2000-05-02 13:00:00 | MSFT | Stock | 35.6562 | 35.7188 | 35.4375 | 35.4688 | 6706000.0 |
| 2000-05-02 14:00:00 | MSFT | Stock | 35.5 | 35.5312 | 35.0625 | 35.0938 | 10533200.0 |
| 2000-05-02 15:00:00 | MSFT | Stock | 35.0781 | 35.25 | 34.75 | 34.9844 | 16970400.0 |
| 2000-05-02 16:00:00 | MSFT | Stock | 35.0 | 35.0 | 34.875 | 34.9375 | 324200.0 |
| 2000-05-02 09:00:00 | NVDA | Stock | 0.1917 | 0.1932 | 0.187 | 0.1921 | 8880000.0 |
| 2000-05-02 10:00:00 | NVDA | Stock | 0.1922 | 0.1948 | 0.191 | 0.1914 | 34464000.0 |
| 2000-05-02 11:00:00 | NVDA | Stock | 0.1913 | 0.1967 | 0.1913 | 0.1967 | 25248000.0 |
| 2000-05-02 12:00:00 | NVDA | Stock | 0.1969 | 0.2029 | 0.1954 | 0.2009 | 57888000.0 |
| 2000-05-02 13:00:00 | NVDA | Stock | 0.201 | 0.201 | 0.1964 | 0.1971 | 19200000.0 |
| 2000-05-02 14:00:00 | NVDA | Stock | 0.1965 | 0.1965 | 0.1939 | 0.1941 | 12336000.0 |
| 2000-05-02 15:00:00 | NVDA | Stock | 0.1941 | 0.1941 | 0.1789 | 0.1844 | 55584000.0 |
| 2000-05-02 16:00:00 | NVDA | Stock | 0.1842 | 0.1842 | 0.1842 | 0.1842 | 5424000.0 |
| 2000-05-02 09:00:00 | AMZN | Stock | 2.9594 | 3.0 | 2.9313 | 2.9563 | 14028000.0 |
| 2000-05-02 10:00:00 | AMZN | Stock | 2.9531 | 2.9812 | 2.9094 | 2.9313 | 14666000.0 |
| 2000-05-02 11:00:00 | AMZN | Stock | 2.9313 | 2.9406 | 2.8688 | 2.9062 | 17824000.0 |
| 2000-05-02 12:00:00 | AMZN | Stock | 2.9062 | 2.95 | 2.9031 | 2.9219 | 16712000.0 |
| 2000-05-02 13:00:00 | AMZN | Stock | 2.9188 | 2.9469 | 2.9188 | 2.9438 | 7356000.0 |
| 2000-05-02 14:00:00 | AMZN | Stock | 2.9438 | 2.9688 | 2.8969 | 2.8969 | 20500000.0 |
| 2000-05-02 15:00:00 | AMZN | Stock | 2.8938 | 2.925 | 2.7938 | 2.8078 | 36720000.0 |
| 2000-05-02 16:00:00 | AMZN | Stock | 2.8078 | 2.8094 | 2.8063 | 2.8063 | 304000.0 |
| 2000-05-02 09:00:00 | CL | Stock | 27.5625 | 27.625 | 27.4688 | 27.625 | 308000.0 |
| 2000-05-02 10:00:00 | CL | Stock | 27.6562 | 27.875 | 27.6562 | 27.8125 | 351400.0 |
| 2000-05-02 11:00:00 | CL | Stock | 27.7812 | 28.0 | 27.75 | 28.0 | 345400.0 |
| 2000-05-02 12:00:00 | CL | Stock | 28.0 | 28.1562 | 28.0 | 28.0312 | 251600.0 |
| 2000-05-02 13:00:00 | CL | Stock | 28.0 | 28.4062 | 28.0 | 28.2188 | 232000.0 |
| 2000-05-02 14:00:00 | CL | Stock | 28.2188 | 28.3125 | 28.0 | 28.0625 | 354800.0 |
| 2000-05-02 15:00:00 | CL | Stock | 28.0625 | 28.2812 | 28.0312 | 28.0625 | 453400.0 |
| 2000-05-02 16:00:00 | CL | Stock | 28.0625 | 28.0625 | 28.0625 | 28.0625 | 159000.0 |
> showing 40 of 14,451 rows — these rows as CSV