PREVIEW / stock_1hour / 2000-05-17
file: by_date/stock_1hour/2000/2000-05-17.parquet size: 271 KB rows: 14,136 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-17 09:00:00 | AAPL | Stock | 0.9252 | 0.9258 | 0.9029 | 0.909 | 70884800.0 |
| 2000-05-17 10:00:00 | AAPL | Stock | 0.909 | 0.9163 | 0.8979 | 0.9146 | 90014400.0 |
| 2000-05-17 11:00:00 | AAPL | Stock | 0.9124 | 0.9135 | 0.9007 | 0.9057 | 38908800.0 |
| 2000-05-17 12:00:00 | AAPL | Stock | 0.9043 | 0.9185 | 0.9018 | 0.9157 | 38483200.0 |
| 2000-05-17 13:00:00 | AAPL | Stock | 0.9163 | 0.9196 | 0.9118 | 0.9169 | 26129600.0 |
| 2000-05-17 14:00:00 | AAPL | Stock | 0.9163 | 0.9169 | 0.8962 | 0.8984 | 47700800.0 |
| 2000-05-17 15:00:00 | AAPL | Stock | 0.8982 | 0.9185 | 0.8973 | 0.9029 | 75376000.0 |
| 2000-05-17 16:00:00 | AAPL | Stock | 0.9051 | 0.9051 | 0.9029 | 0.9051 | 1299200.0 |
| 2000-05-17 09:00:00 | MSFT | Stock | 34.4375 | 34.5625 | 34.0625 | 34.125 | 7050000.0 |
| 2000-05-17 10:00:00 | MSFT | Stock | 34.1562 | 34.1875 | 33.8125 | 33.9375 | 11949000.0 |
| 2000-05-17 11:00:00 | MSFT | Stock | 33.9375 | 33.9375 | 33.7188 | 33.875 | 5213000.0 |
| 2000-05-17 12:00:00 | MSFT | Stock | 33.8438 | 33.9688 | 33.625 | 33.6875 | 5503800.0 |
| 2000-05-17 13:00:00 | MSFT | Stock | 33.6562 | 34.0 | 33.625 | 33.9688 | 6556000.0 |
| 2000-05-17 14:00:00 | MSFT | Stock | 33.9375 | 33.9688 | 33.625 | 33.6875 | 5395600.0 |
| 2000-05-17 15:00:00 | MSFT | Stock | 33.6875 | 33.9688 | 33.625 | 33.875 | 9731600.0 |
| 2000-05-17 16:00:00 | MSFT | Stock | 33.8438 | 33.875 | 33.8438 | 33.8438 | 120400.0 |
| 2000-05-17 09:00:00 | NVDA | Stock | 0.2062 | 0.2208 | 0.2061 | 0.218 | 270528000.0 |
| 2000-05-17 10:00:00 | NVDA | Stock | 0.218 | 0.2203 | 0.2115 | 0.2169 | 175488000.0 |
| 2000-05-17 11:00:00 | NVDA | Stock | 0.2169 | 0.2254 | 0.2148 | 0.2247 | 149232000.0 |
| 2000-05-17 12:00:00 | NVDA | Stock | 0.2246 | 0.2301 | 0.2236 | 0.2281 | 195888000.0 |
| 2000-05-17 13:00:00 | NVDA | Stock | 0.2277 | 0.2388 | 0.2273 | 0.2368 | 158832000.0 |
| 2000-05-17 14:00:00 | NVDA | Stock | 0.2371 | 0.2383 | 0.2271 | 0.2298 | 164736000.0 |
| 2000-05-17 15:00:00 | NVDA | Stock | 0.2299 | 0.2344 | 0.2277 | 0.2303 | 156576000.0 |
| 2000-05-17 16:00:00 | NVDA | Stock | 0.2303 | 0.2303 | 0.2302 | 0.2302 | 144000.0 |
| 2000-05-17 09:00:00 | AMZN | Stock | 2.8594 | 2.9313 | 2.85 | 2.8812 | 14340000.0 |
| 2000-05-17 10:00:00 | AMZN | Stock | 2.8812 | 2.95 | 2.85 | 2.8969 | 16870000.0 |
| 2000-05-17 11:00:00 | AMZN | Stock | 2.8969 | 2.9125 | 2.8562 | 2.9062 | 13840000.0 |
| 2000-05-17 12:00:00 | AMZN | Stock | 2.9125 | 2.925 | 2.8906 | 2.9031 | 6336000.0 |
| 2000-05-17 13:00:00 | AMZN | Stock | 2.9 | 2.9438 | 2.9 | 2.9313 | 9184000.0 |
| 2000-05-17 14:00:00 | AMZN | Stock | 2.9313 | 2.9875 | 2.925 | 2.9688 | 16238000.0 |
| 2000-05-17 15:00:00 | AMZN | Stock | 2.975 | 3.1188 | 2.975 | 3.0516 | 57832000.0 |
| 2000-05-17 16:00:00 | AMZN | Stock | 3.05 | 3.0531 | 3.05 | 3.05 | 196000.0 |
| 2000-05-17 09:00:00 | CL | Stock | 29.0625 | 29.1562 | 28.875 | 28.9375 | 297600.0 |
| 2000-05-17 10:00:00 | CL | Stock | 28.9375 | 29.0938 | 28.7188 | 29.0 | 363400.0 |
| 2000-05-17 11:00:00 | CL | Stock | 29.0312 | 29.0625 | 28.8438 | 28.9375 | 128000.0 |
| 2000-05-17 12:00:00 | CL | Stock | 28.9688 | 29.25 | 28.9375 | 29.0625 | 121400.0 |
| 2000-05-17 13:00:00 | CL | Stock | 29.0625 | 29.3438 | 29.0312 | 29.2812 | 230400.0 |
| 2000-05-17 14:00:00 | CL | Stock | 29.2812 | 29.3125 | 28.875 | 28.9688 | 213600.0 |
| 2000-05-17 15:00:00 | CL | Stock | 28.9688 | 29.4375 | 28.9688 | 29.25 | 307600.0 |
| 2000-05-17 16:00:00 | CL | Stock | 29.3125 | 29.3125 | 29.2812 | 29.2812 | 49200.0 |
> showing 40 of 14,136 rows — these rows as CSV