PREVIEW / stock_1hour / 2000-05-22
file: by_date/stock_1hour/2000/2000-05-22.parquet size: 278 KB rows: 14,320 symbols: 1,160
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-22 09:00:00 | AAPL | Stock | 0.8371 | 0.8371 | 0.7796 | 0.7818 | 127982400.0 |
| 2000-05-22 10:00:00 | AAPL | Stock | 0.7801 | 0.7941 | 0.7768 | 0.7874 | 199012800.0 |
| 2000-05-22 11:00:00 | AAPL | Stock | 0.7874 | 0.7874 | 0.774 | 0.7768 | 125809600.0 |
| 2000-05-22 12:00:00 | AAPL | Stock | 0.7765 | 0.7807 | 0.769 | 0.7746 | 48955200.0 |
| 2000-05-22 13:00:00 | AAPL | Stock | 0.7751 | 0.7807 | 0.7684 | 0.7701 | 37766400.0 |
| 2000-05-22 14:00:00 | AAPL | Stock | 0.7701 | 0.793 | 0.769 | 0.7818 | 82264000.0 |
| 2000-05-22 15:00:00 | AAPL | Stock | 0.7813 | 0.8103 | 0.779 | 0.8036 | 117980800.0 |
| 2000-05-22 16:00:00 | AAPL | Stock | 0.803 | 0.8041 | 0.803 | 0.803 | 1108800.0 |
| 2000-05-22 09:00:00 | MSFT | Stock | 32.5625 | 32.5938 | 31.8125 | 31.9375 | 9544400.0 |
| 2000-05-22 10:00:00 | MSFT | Stock | 32.0 | 32.0625 | 31.4062 | 31.6875 | 15590400.0 |
| 2000-05-22 11:00:00 | MSFT | Stock | 31.6875 | 31.875 | 31.375 | 31.5 | 8305000.0 |
| 2000-05-22 12:00:00 | MSFT | Stock | 31.5156 | 31.6875 | 31.25 | 31.4688 | 5458000.0 |
| 2000-05-22 13:00:00 | MSFT | Stock | 31.5 | 31.5312 | 31.2188 | 31.25 | 4693200.0 |
| 2000-05-22 14:00:00 | MSFT | Stock | 31.3125 | 31.6875 | 31.2188 | 31.5312 | 8842200.0 |
| 2000-05-22 15:00:00 | MSFT | Stock | 31.5 | 32.1562 | 31.5 | 32.0625 | 14275400.0 |
| 2000-05-22 16:00:00 | MSFT | Stock | 32.0938 | 32.125 | 32.0625 | 32.0938 | 215600.0 |
| 2000-05-22 09:00:00 | NVDA | Stock | 0.2104 | 0.2107 | 0.1918 | 0.2003 | 67200000.0 |
| 2000-05-22 10:00:00 | NVDA | Stock | 0.1992 | 0.2047 | 0.1974 | 0.2042 | 102624000.0 |
| 2000-05-22 11:00:00 | NVDA | Stock | 0.2031 | 0.2167 | 0.2031 | 0.212 | 71568000.0 |
| 2000-05-22 12:00:00 | NVDA | Stock | 0.2115 | 0.2145 | 0.2102 | 0.2135 | 56064000.0 |
| 2000-05-22 13:00:00 | NVDA | Stock | 0.2133 | 0.216 | 0.2086 | 0.2099 | 45120000.0 |
| 2000-05-22 14:00:00 | NVDA | Stock | 0.2086 | 0.2146 | 0.2042 | 0.2137 | 57216000.0 |
| 2000-05-22 15:00:00 | NVDA | Stock | 0.2107 | 0.2266 | 0.2107 | 0.2255 | 105120000.0 |
| 2000-05-22 16:00:00 | NVDA | Stock | 0.2255 | 0.2266 | 0.2255 | 0.2266 | 2016000.0 |
| 2000-05-22 09:00:00 | AMZN | Stock | 2.65 | 2.6562 | 2.4844 | 2.4844 | 22046000.0 |
| 2000-05-22 10:00:00 | AMZN | Stock | 2.4844 | 2.5 | 2.3812 | 2.4375 | 39224000.0 |
| 2000-05-22 11:00:00 | AMZN | Stock | 2.4313 | 2.5 | 2.4062 | 2.4656 | 14520000.0 |
| 2000-05-22 12:00:00 | AMZN | Stock | 2.4656 | 2.475 | 2.4125 | 2.45 | 8818000.0 |
| 2000-05-22 13:00:00 | AMZN | Stock | 2.45 | 2.4625 | 2.3688 | 2.3719 | 10690000.0 |
| 2000-05-22 14:00:00 | AMZN | Stock | 2.3719 | 2.5188 | 2.3438 | 2.4781 | 34312000.0 |
| 2000-05-22 15:00:00 | AMZN | Stock | 2.4781 | 2.6125 | 2.4688 | 2.5953 | 31706000.0 |
| 2000-05-22 16:00:00 | AMZN | Stock | 2.5969 | 2.5969 | 2.5938 | 2.5938 | 188000.0 |
| 2000-05-22 09:00:00 | CL | Stock | 28.5 | 28.8125 | 28.4375 | 28.5938 | 234000.0 |
| 2000-05-22 10:00:00 | CL | Stock | 28.625 | 28.7812 | 28.25 | 28.3438 | 461400.0 |
| 2000-05-22 11:00:00 | CL | Stock | 28.2812 | 28.3438 | 28.0 | 28.1875 | 286800.0 |
| 2000-05-22 12:00:00 | CL | Stock | 28.1875 | 28.2812 | 28.0625 | 28.2188 | 196600.0 |
| 2000-05-22 13:00:00 | CL | Stock | 28.2188 | 28.3438 | 28.0 | 28.0938 | 137600.0 |
| 2000-05-22 14:00:00 | CL | Stock | 28.125 | 28.3125 | 28.0 | 28.2188 | 154600.0 |
| 2000-05-22 15:00:00 | CL | Stock | 28.1562 | 28.3438 | 28.1562 | 28.25 | 344800.0 |
| 2000-05-22 16:00:00 | CL | Stock | 28.25 | 28.2812 | 28.25 | 28.2812 | 67000.0 |
> showing 40 of 14,320 rows — these rows as CSV