PREVIEW / stock_1hour / 2000-11-17
file: by_date/stock_1hour/2000/2000-11-17.parquet size: 298 KB rows: 15,350 symbols: 1,241
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-17 08:00:00 | AAPL | Stock | 0.3404 | 0.3426 | 0.3404 | 0.3426 | 67200.0 |
| 2000-11-17 09:00:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3304 | 0.3315 | 50187200.0 |
| 2000-11-17 10:00:00 | AAPL | Stock | 0.3315 | 0.3415 | 0.3315 | 0.3359 | 69428800.0 |
| 2000-11-17 11:00:00 | AAPL | Stock | 0.3359 | 0.3359 | 0.3281 | 0.3304 | 69624800.0 |
| 2000-11-17 12:00:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3259 | 0.3281 | 48994400.0 |
| 2000-11-17 13:00:00 | AAPL | Stock | 0.327 | 0.3337 | 0.3259 | 0.3309 | 37637600.0 |
| 2000-11-17 14:00:00 | AAPL | Stock | 0.3315 | 0.3348 | 0.3304 | 0.3337 | 47196800.0 |
| 2000-11-17 15:00:00 | AAPL | Stock | 0.3337 | 0.3348 | 0.3281 | 0.3292 | 69098400.0 |
| 2000-11-17 16:00:00 | AAPL | Stock | 0.3304 | 0.3326 | 0.3281 | 0.3315 | 14341600.0 |
| 2000-11-17 17:00:00 | AAPL | Stock | 0.3337 | 0.3337 | 0.3326 | 0.3337 | 582400.0 |
| 2000-11-17 18:00:00 | AAPL | Stock | 0.3326 | 0.3337 | 0.3326 | 0.3337 | 280000.0 |
| 2000-11-17 08:00:00 | MSFT | Stock | 34.4844 | 35.0 | 34.4844 | 34.75 | 275000.0 |
| 2000-11-17 09:00:00 | MSFT | Stock | 34.75 | 34.75 | 34.125 | 34.4375 | 10816200.0 |
| 2000-11-17 10:00:00 | MSFT | Stock | 34.4531 | 35.0 | 34.2812 | 34.3438 | 34009800.0 |
| 2000-11-17 11:00:00 | MSFT | Stock | 34.375 | 34.4688 | 33.8906 | 34.3438 | 8719600.0 |
| 2000-11-17 12:00:00 | MSFT | Stock | 34.3438 | 34.625 | 34.2812 | 34.3125 | 5294600.0 |
| 2000-11-17 13:00:00 | MSFT | Stock | 34.2812 | 34.9375 | 34.1875 | 34.9375 | 7946800.0 |
| 2000-11-17 14:00:00 | MSFT | Stock | 34.9375 | 35.0 | 34.6562 | 34.8125 | 11457200.0 |
| 2000-11-17 15:00:00 | MSFT | Stock | 34.8438 | 34.8438 | 34.3906 | 34.5312 | 16529400.0 |
| 2000-11-17 16:00:00 | MSFT | Stock | 34.5312 | 34.5938 | 33.9375 | 34.375 | 2100800.0 |
| 2000-11-17 17:00:00 | MSFT | Stock | 34.3594 | 34.4688 | 34.0625 | 34.25 | 45800.0 |
| 2000-11-17 18:00:00 | MSFT | Stock | 34.25 | 34.3125 | 34.25 | 34.25 | 2000.0 |
| 2000-11-17 09:00:00 | NVDA | Stock | 0.2714 | 0.275 | 0.2667 | 0.2672 | 11328000.0 |
| 2000-11-17 10:00:00 | NVDA | Stock | 0.2688 | 0.2852 | 0.2669 | 0.2672 | 34392000.0 |
| 2000-11-17 11:00:00 | NVDA | Stock | 0.2685 | 0.2708 | 0.2552 | 0.262 | 36264000.0 |
| 2000-11-17 12:00:00 | NVDA | Stock | 0.2625 | 0.2633 | 0.2583 | 0.2594 | 16128000.0 |
| 2000-11-17 13:00:00 | NVDA | Stock | 0.2604 | 0.2708 | 0.2583 | 0.2677 | 9816000.0 |
| 2000-11-17 14:00:00 | NVDA | Stock | 0.2667 | 0.2706 | 0.2609 | 0.2667 | 22272000.0 |
| 2000-11-17 15:00:00 | NVDA | Stock | 0.2667 | 0.2667 | 0.2599 | 0.2641 | 28080000.0 |
| 2000-11-17 16:00:00 | NVDA | Stock | 0.2641 | 0.2641 | 0.262 | 0.2625 | 1752000.0 |
| 2000-11-17 17:00:00 | NVDA | Stock | 0.262 | 0.2635 | 0.2604 | 0.2635 | 456000.0 |
| 2000-11-17 08:00:00 | AMZN | Stock | 1.4375 | 1.4516 | 1.4094 | 1.45 | 306000.0 |
| 2000-11-17 09:00:00 | AMZN | Stock | 1.4438 | 1.475 | 1.3625 | 1.425 | 15846000.0 |
| 2000-11-17 10:00:00 | AMZN | Stock | 1.425 | 1.4813 | 1.3969 | 1.4047 | 15586000.0 |
| 2000-11-17 11:00:00 | AMZN | Stock | 1.4047 | 1.4313 | 1.3438 | 1.35 | 14200000.0 |
| 2000-11-17 12:00:00 | AMZN | Stock | 1.3531 | 1.3531 | 1.3438 | 1.3438 | 8064000.0 |
| 2000-11-17 13:00:00 | AMZN | Stock | 1.3438 | 1.3812 | 1.3438 | 1.3812 | 7596000.0 |
| 2000-11-17 14:00:00 | AMZN | Stock | 1.3812 | 1.4156 | 1.3594 | 1.4125 | 15410000.0 |
| 2000-11-17 15:00:00 | AMZN | Stock | 1.4156 | 1.4219 | 1.3625 | 1.375 | 12128000.0 |
| 2000-11-17 16:00:00 | AMZN | Stock | 1.3719 | 1.3812 | 1.3719 | 1.375 | 4124000.0 |
| 2000-11-17 17:00:00 | AMZN | Stock | 1.375 | 1.3844 | 1.375 | 1.375 | 118000.0 |
| 2000-11-17 09:00:00 | CL | Stock | 29.525 | 29.55 | 29.435 | 29.505 | 397200.0 |
| 2000-11-17 10:00:00 | CL | Stock | 29.525 | 29.85 | 29.525 | 29.65 | 234000.0 |
| 2000-11-17 11:00:00 | CL | Stock | 29.65 | 29.75 | 29.425 | 29.445 | 211000.0 |
| 2000-11-17 12:00:00 | CL | Stock | 29.44 | 29.575 | 29.425 | 29.47 | 239000.0 |
| 2000-11-17 13:00:00 | CL | Stock | 29.475 | 29.575 | 29.38 | 29.45 | 301800.0 |
| 2000-11-17 14:00:00 | CL | Stock | 29.475 | 29.525 | 29.355 | 29.47 | 398600.0 |
| 2000-11-17 15:00:00 | CL | Stock | 29.47 | 29.56 | 29.375 | 29.56 | 429600.0 |
| 2000-11-17 16:00:00 | CL | Stock | 29.525 | 29.525 | 29.505 | 29.525 | 111200.0 |
> showing 49 of 15,350 rows — these rows as CSV