PREVIEW / stock_1hour / 2000-11-20
file: by_date/stock_1hour/2000/2000-11-20.parquet size: 302 KB rows: 15,741 symbols: 1,249
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-20 08:00:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3225 | 0.3225 | 772800.0 |
| 2000-11-20 09:00:00 | AAPL | Stock | 0.3237 | 0.3393 | 0.3225 | 0.3292 | 38057600.0 |
| 2000-11-20 10:00:00 | AAPL | Stock | 0.3292 | 0.3315 | 0.3259 | 0.3304 | 40684000.0 |
| 2000-11-20 11:00:00 | AAPL | Stock | 0.3304 | 0.3354 | 0.3281 | 0.3348 | 41423200.0 |
| 2000-11-20 12:00:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3315 | 0.3348 | 41120800.0 |
| 2000-11-20 13:00:00 | AAPL | Stock | 0.3348 | 0.3404 | 0.3348 | 0.3404 | 55305600.0 |
| 2000-11-20 14:00:00 | AAPL | Stock | 0.3393 | 0.3482 | 0.3382 | 0.3426 | 81306400.0 |
| 2000-11-20 15:00:00 | AAPL | Stock | 0.3426 | 0.346 | 0.3359 | 0.3382 | 71624000.0 |
| 2000-11-20 16:00:00 | AAPL | Stock | 0.3359 | 0.346 | 0.3337 | 0.3348 | 20232800.0 |
| 2000-11-20 17:00:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3315 | 0.3315 | 688800.0 |
| 2000-11-20 18:00:00 | AAPL | Stock | 0.3359 | 0.3359 | 0.3359 | 0.3359 | 11200.0 |
| 2000-11-20 08:00:00 | MSFT | Stock | 34.1562 | 34.1562 | 34.0 | 34.125 | 80400.0 |
| 2000-11-20 09:00:00 | MSFT | Stock | 34.0938 | 34.4375 | 33.875 | 34.0312 | 10586200.0 |
| 2000-11-20 10:00:00 | MSFT | Stock | 34.0 | 34.0938 | 33.4062 | 33.4375 | 15603800.0 |
| 2000-11-20 11:00:00 | MSFT | Stock | 33.4375 | 33.5312 | 33.2188 | 33.5 | 11333600.0 |
| 2000-11-20 12:00:00 | MSFT | Stock | 33.5 | 33.5 | 32.9688 | 33.0312 | 8185000.0 |
| 2000-11-20 13:00:00 | MSFT | Stock | 33.0625 | 33.25 | 32.7812 | 33.1562 | 6286600.0 |
| 2000-11-20 14:00:00 | MSFT | Stock | 33.1562 | 33.8438 | 33.0625 | 33.7812 | 9385800.0 |
| 2000-11-20 15:00:00 | MSFT | Stock | 33.7812 | 34.0625 | 33.4688 | 33.5625 | 10067200.0 |
| 2000-11-20 16:00:00 | MSFT | Stock | 33.5938 | 33.625 | 33.3125 | 33.4062 | 1585600.0 |
| 2000-11-20 17:00:00 | MSFT | Stock | 33.5 | 33.7188 | 33.5 | 33.7188 | 10400.0 |
| 2000-11-20 18:00:00 | MSFT | Stock | 33.4375 | 33.5625 | 33.4062 | 33.5625 | 1400.0 |
| 2000-11-20 09:00:00 | NVDA | Stock | 0.2583 | 0.2583 | 0.2443 | 0.2475 | 50736000.0 |
| 2000-11-20 10:00:00 | NVDA | Stock | 0.2464 | 0.25 | 0.2438 | 0.2456 | 41688000.0 |
| 2000-11-20 11:00:00 | NVDA | Stock | 0.2456 | 0.249 | 0.2438 | 0.2471 | 41736000.0 |
| 2000-11-20 12:00:00 | NVDA | Stock | 0.2471 | 0.2484 | 0.2419 | 0.2453 | 35136000.0 |
| 2000-11-20 13:00:00 | NVDA | Stock | 0.2453 | 0.2477 | 0.2409 | 0.2469 | 27192000.0 |
| 2000-11-20 14:00:00 | NVDA | Stock | 0.2477 | 0.2484 | 0.2456 | 0.2464 | 27024000.0 |
| 2000-11-20 15:00:00 | NVDA | Stock | 0.2464 | 0.2497 | 0.2432 | 0.2438 | 54768000.0 |
| 2000-11-20 16:00:00 | NVDA | Stock | 0.2438 | 0.244 | 0.2432 | 0.2438 | 1512000.0 |
| 2000-11-20 17:00:00 | NVDA | Stock | 0.2432 | 0.2461 | 0.2432 | 0.2461 | 264000.0 |
| 2000-11-20 08:00:00 | AMZN | Stock | 1.3625 | 1.3625 | 1.275 | 1.3063 | 910000.0 |
| 2000-11-20 09:00:00 | AMZN | Stock | 1.3031 | 1.3563 | 1.2531 | 1.2844 | 25456000.0 |
| 2000-11-20 10:00:00 | AMZN | Stock | 1.2844 | 1.2906 | 1.25 | 1.25 | 17936000.0 |
| 2000-11-20 11:00:00 | AMZN | Stock | 1.25 | 1.3 | 1.25 | 1.2969 | 17826000.0 |
| 2000-11-20 12:00:00 | AMZN | Stock | 1.2969 | 1.3125 | 1.2875 | 1.2969 | 11510000.0 |
| 2000-11-20 13:00:00 | AMZN | Stock | 1.2969 | 1.3406 | 1.2844 | 1.3156 | 12018000.0 |
| 2000-11-20 14:00:00 | AMZN | Stock | 1.3125 | 1.3938 | 1.3125 | 1.35 | 19398000.0 |
| 2000-11-20 15:00:00 | AMZN | Stock | 1.35 | 1.3594 | 1.2812 | 1.2938 | 16754000.0 |
| 2000-11-20 16:00:00 | AMZN | Stock | 1.2906 | 1.2969 | 1.2875 | 1.2906 | 760000.0 |
| 2000-11-20 17:00:00 | AMZN | Stock | 1.2906 | 1.3 | 1.2906 | 1.2938 | 28000.0 |
| 2000-11-20 18:00:00 | AMZN | Stock | 1.2938 | 1.3 | 1.2938 | 1.3 | 22000.0 |
| 2000-11-20 09:00:00 | CL | Stock | 30.0 | 30.4 | 29.925 | 30.375 | 220600.0 |
| 2000-11-20 10:00:00 | CL | Stock | 30.4 | 30.4 | 29.95 | 29.985 | 824000.0 |
| 2000-11-20 11:00:00 | CL | Stock | 29.95 | 29.95 | 29.7 | 29.7 | 296200.0 |
| 2000-11-20 12:00:00 | CL | Stock | 29.68 | 29.92 | 29.525 | 29.8 | 220600.0 |
| 2000-11-20 13:00:00 | CL | Stock | 29.82 | 29.995 | 29.8 | 29.975 | 219400.0 |
| 2000-11-20 14:00:00 | CL | Stock | 29.975 | 30.0 | 29.925 | 29.925 | 438600.0 |
| 2000-11-20 15:00:00 | CL | Stock | 29.93 | 30.0 | 29.875 | 29.91 | 409800.0 |
| 2000-11-20 16:00:00 | CL | Stock | 29.92 | 29.95 | 29.915 | 29.915 | 123600.0 |
> showing 50 of 15,741 rows — these rows as CSV