PREVIEW / stock_1hour / 2000-11-28
file: by_date/stock_1hour/2000/2000-11-28.parquet size: 309 KB rows: 16,020 symbols: 1,252
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-11-28 08:00:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.3304 | 0.3304 | 448000.0 |
| 2000-11-28 09:00:00 | AAPL | Stock | 0.3304 | 0.3348 | 0.3292 | 0.3337 | 30441600.0 |
| 2000-11-28 10:00:00 | AAPL | Stock | 0.3348 | 0.3393 | 0.3315 | 0.3326 | 28963200.0 |
| 2000-11-28 11:00:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.327 | 0.3304 | 35319200.0 |
| 2000-11-28 12:00:00 | AAPL | Stock | 0.3304 | 0.3326 | 0.3281 | 0.3315 | 30665600.0 |
| 2000-11-28 13:00:00 | AAPL | Stock | 0.3304 | 0.3315 | 0.3281 | 0.3304 | 22344000.0 |
| 2000-11-28 14:00:00 | AAPL | Stock | 0.3292 | 0.3304 | 0.3237 | 0.3259 | 24124800.0 |
| 2000-11-28 15:00:00 | AAPL | Stock | 0.3253 | 0.327 | 0.3203 | 0.3225 | 46771200.0 |
| 2000-11-28 16:00:00 | AAPL | Stock | 0.322 | 0.327 | 0.3214 | 0.322 | 37396800.0 |
| 2000-11-28 17:00:00 | AAPL | Stock | 0.3237 | 0.3237 | 0.3214 | 0.3214 | 56000.0 |
| 2000-11-28 18:00:00 | AAPL | Stock | 0.3225 | 0.3259 | 0.3225 | 0.3225 | 134400.0 |
| 2000-11-28 08:00:00 | MSFT | Stock | 35.0 | 35.3594 | 34.3438 | 34.6875 | 868200.0 |
| 2000-11-28 09:00:00 | MSFT | Stock | 34.6875 | 35.375 | 34.3125 | 34.5625 | 22513600.0 |
| 2000-11-28 10:00:00 | MSFT | Stock | 34.5625 | 34.6875 | 33.7188 | 33.8125 | 24392800.0 |
| 2000-11-28 11:00:00 | MSFT | Stock | 33.7812 | 33.875 | 33.5625 | 33.8438 | 12250200.0 |
| 2000-11-28 12:00:00 | MSFT | Stock | 33.8438 | 34.0625 | 33.75 | 34.0 | 12608600.0 |
| 2000-11-28 13:00:00 | MSFT | Stock | 34.0 | 34.0312 | 33.7812 | 34.0312 | 9781600.0 |
| 2000-11-28 14:00:00 | MSFT | Stock | 34.0312 | 34.0312 | 33.5312 | 33.6562 | 10973600.0 |
| 2000-11-28 15:00:00 | MSFT | Stock | 33.6562 | 33.6562 | 33.4062 | 33.5 | 18028200.0 |
| 2000-11-28 16:00:00 | MSFT | Stock | 33.5 | 34.0312 | 33.4375 | 33.5 | 5754800.0 |
| 2000-11-28 17:00:00 | MSFT | Stock | 33.5 | 33.7188 | 33.5 | 33.6875 | 15600.0 |
| 2000-11-28 18:00:00 | MSFT | Stock | 33.625 | 33.7188 | 33.625 | 33.7188 | 3400.0 |
| 2000-11-28 09:00:00 | NVDA | Stock | 0.2323 | 0.2375 | 0.2292 | 0.2332 | 28968000.0 |
| 2000-11-28 10:00:00 | NVDA | Stock | 0.2333 | 0.2333 | 0.2229 | 0.2242 | 43632000.0 |
| 2000-11-28 11:00:00 | NVDA | Stock | 0.2242 | 0.226 | 0.2198 | 0.2227 | 56520000.0 |
| 2000-11-28 12:00:00 | NVDA | Stock | 0.2229 | 0.2271 | 0.2214 | 0.225 | 38064000.0 |
| 2000-11-28 13:00:00 | NVDA | Stock | 0.225 | 0.2268 | 0.2219 | 0.225 | 32136000.0 |
| 2000-11-28 14:00:00 | NVDA | Stock | 0.2258 | 0.2258 | 0.2128 | 0.2128 | 70800000.0 |
| 2000-11-28 15:00:00 | NVDA | Stock | 0.2128 | 0.2174 | 0.2091 | 0.2143 | 64560000.0 |
| 2000-11-28 16:00:00 | NVDA | Stock | 0.2146 | 0.2146 | 0.2125 | 0.213 | 5520000.0 |
| 2000-11-28 17:00:00 | NVDA | Stock | 0.2125 | 0.2125 | 0.2125 | 0.2125 | 168000.0 |
| 2000-11-28 18:00:00 | NVDA | Stock | 0.2115 | 0.2115 | 0.2115 | 0.2115 | 96000.0 |
| 2000-11-28 08:00:00 | AMZN | Stock | 1.3688 | 1.3688 | 1.2875 | 1.3063 | 1536000.0 |
| 2000-11-28 09:00:00 | AMZN | Stock | 1.3 | 1.325 | 1.2375 | 1.2656 | 56258000.0 |
| 2000-11-28 10:00:00 | AMZN | Stock | 1.2656 | 1.3094 | 1.2562 | 1.2812 | 38066000.0 |
| 2000-11-28 11:00:00 | AMZN | Stock | 1.2781 | 1.2906 | 1.2625 | 1.2719 | 21582000.0 |
| 2000-11-28 12:00:00 | AMZN | Stock | 1.2656 | 1.275 | 1.25 | 1.2594 | 20252000.0 |
| 2000-11-28 13:00:00 | AMZN | Stock | 1.2531 | 1.2719 | 1.25 | 1.2719 | 19684000.0 |
| 2000-11-28 14:00:00 | AMZN | Stock | 1.2688 | 1.2797 | 1.2344 | 1.2406 | 15128000.0 |
| 2000-11-28 15:00:00 | AMZN | Stock | 1.2375 | 1.2688 | 1.2313 | 1.25 | 32446000.0 |
| 2000-11-28 16:00:00 | AMZN | Stock | 1.25 | 1.2562 | 1.2375 | 1.2562 | 4422000.0 |
| 2000-11-28 17:00:00 | AMZN | Stock | 1.25 | 1.2625 | 1.2438 | 1.25 | 30000.0 |
| 2000-11-28 18:00:00 | AMZN | Stock | 1.25 | 1.25 | 1.25 | 1.25 | 6000.0 |
| 2000-11-28 09:00:00 | CL | Stock | 28.95 | 28.95 | 28.85 | 28.915 | 319600.0 |
| 2000-11-28 10:00:00 | CL | Stock | 28.9 | 29.3 | 28.89 | 29.29 | 530200.0 |
| 2000-11-28 11:00:00 | CL | Stock | 29.29 | 29.525 | 29.19 | 29.23 | 383400.0 |
| 2000-11-28 12:00:00 | CL | Stock | 29.235 | 29.345 | 29.065 | 29.34 | 364400.0 |
| 2000-11-28 13:00:00 | CL | Stock | 29.345 | 29.375 | 29.3 | 29.35 | 261800.0 |
| 2000-11-28 14:00:00 | CL | Stock | 29.36 | 29.44 | 29.3 | 29.3 | 456400.0 |
| 2000-11-28 15:00:00 | CL | Stock | 29.3 | 29.3 | 29.15 | 29.22 | 896000.0 |
> showing 50 of 16,020 rows — these rows as CSV