PREVIEW / stock_30min / 2001-01-19
file: by_date/stock_30min/2001/2001-01-19.parquet size: 461 KB rows: 26,969 symbols: 1,261
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-19 08:00:00 | AAPL | Stock | 0.3482 | 0.3571 | 0.3415 | 0.3527 | 3505600.0 |
| 2001-01-19 08:30:00 | AAPL | Stock | 0.3488 | 0.3504 | 0.3415 | 0.3504 | 1904000.0 |
| 2001-01-19 09:00:00 | AAPL | Stock | 0.3504 | 0.3516 | 0.3415 | 0.3471 | 4838400.0 |
| 2001-01-19 09:30:00 | AAPL | Stock | 0.3471 | 0.3493 | 0.3359 | 0.3404 | 133851200.0 |
| 2001-01-19 10:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3337 | 0.3393 | 75516000.0 |
| 2001-01-19 10:30:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3371 | 0.3371 | 46603200.0 |
| 2001-01-19 11:00:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3359 | 0.3393 | 38516800.0 |
| 2001-01-19 11:30:00 | AAPL | Stock | 0.3387 | 0.3404 | 0.3348 | 0.3393 | 42638400.0 |
| 2001-01-19 12:00:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3382 | 0.3404 | 17320800.0 |
| 2001-01-19 12:30:00 | AAPL | Stock | 0.3398 | 0.346 | 0.3393 | 0.3438 | 34316800.0 |
| 2001-01-19 13:00:00 | AAPL | Stock | 0.3449 | 0.3482 | 0.3438 | 0.3471 | 25597600.0 |
| 2001-01-19 13:30:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.3449 | 0.346 | 41787200.0 |
| 2001-01-19 14:00:00 | AAPL | Stock | 0.346 | 0.3482 | 0.3415 | 0.3482 | 28403200.0 |
| 2001-01-19 14:30:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.3415 | 0.3415 | 20720000.0 |
| 2001-01-19 15:00:00 | AAPL | Stock | 0.3415 | 0.3449 | 0.3382 | 0.3393 | 69630400.0 |
| 2001-01-19 15:30:00 | AAPL | Stock | 0.3393 | 0.3493 | 0.3382 | 0.3471 | 83921600.0 |
| 2001-01-19 16:00:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.3393 | 0.3438 | 10029600.0 |
| 2001-01-19 16:30:00 | AAPL | Stock | 0.3449 | 0.3482 | 0.3337 | 0.3482 | 134400.0 |
| 2001-01-19 17:30:00 | AAPL | Stock | 0.3438 | 0.3482 | 0.3415 | 0.3482 | 117600.0 |
| 2001-01-19 18:00:00 | AAPL | Stock | 0.3449 | 0.346 | 0.3449 | 0.346 | 22400.0 |
| 2001-01-19 08:00:00 | MSFT | Stock | 29.75 | 30.0 | 29.25 | 29.75 | 1280000.0 |
| 2001-01-19 08:30:00 | MSFT | Stock | 29.75 | 30.0625 | 29.5625 | 30.0 | 2676000.0 |
| 2001-01-19 09:00:00 | MSFT | Stock | 30.0 | 30.125 | 27.9688 | 30.0625 | 4096600.0 |
| 2001-01-19 09:30:00 | MSFT | Stock | 30.0 | 30.125 | 29.5938 | 29.875 | 35576000.0 |
| 2001-01-19 10:00:00 | MSFT | Stock | 29.875 | 30.0938 | 29.4375 | 29.6562 | 21400000.0 |
| 2001-01-19 10:30:00 | MSFT | Stock | 29.6875 | 29.875 | 29.625 | 29.8125 | 10868400.0 |
| 2001-01-19 11:00:00 | MSFT | Stock | 29.8125 | 29.9688 | 29.7812 | 29.875 | 10654800.0 |
| 2001-01-19 11:30:00 | MSFT | Stock | 29.8438 | 30.0 | 29.75 | 29.9688 | 6325400.0 |
| 2001-01-19 12:00:00 | MSFT | Stock | 29.9688 | 30.0312 | 29.8438 | 29.9062 | 7372800.0 |
| 2001-01-19 12:30:00 | MSFT | Stock | 29.9062 | 30.0 | 29.875 | 29.9688 | 5304600.0 |
| 2001-01-19 13:00:00 | MSFT | Stock | 29.9688 | 30.125 | 29.9688 | 30.0625 | 7560800.0 |
| 2001-01-19 13:30:00 | MSFT | Stock | 30.0625 | 30.25 | 30.0 | 30.2031 | 7843400.0 |
| 2001-01-19 14:00:00 | MSFT | Stock | 30.2188 | 30.5 | 30.1875 | 30.5 | 13043000.0 |
| 2001-01-19 14:30:00 | MSFT | Stock | 30.4688 | 30.7188 | 30.4062 | 30.4375 | 13709200.0 |
| 2001-01-19 15:00:00 | MSFT | Stock | 30.4688 | 30.5312 | 30.2188 | 30.2812 | 14284000.0 |
| 2001-01-19 15:30:00 | MSFT | Stock | 30.375 | 30.625 | 30.25 | 30.5 | 17413200.0 |
| 2001-01-19 16:00:00 | MSFT | Stock | 30.5 | 30.5625 | 29.9062 | 30.5 | 4795200.0 |
| 2001-01-19 16:30:00 | MSFT | Stock | 30.5625 | 30.625 | 29.875 | 30.5625 | 448200.0 |
| 2001-01-19 17:00:00 | MSFT | Stock | 30.5938 | 30.5938 | 30.5312 | 30.5625 | 380000.0 |
| 2001-01-19 17:30:00 | MSFT | Stock | 30.5625 | 30.5938 | 30.5312 | 30.5625 | 18400.0 |
| 2001-01-19 18:00:00 | MSFT | Stock | 30.5312 | 30.5938 | 30.4375 | 30.5938 | 13400.0 |
| 2001-01-19 08:30:00 | NVDA | Stock | 0.2276 | 0.2292 | 0.2251 | 0.2286 | 528000.0 |
| 2001-01-19 09:00:00 | NVDA | Stock | 0.2281 | 0.2296 | 0.2281 | 0.2294 | 1896000.0 |
| 2001-01-19 09:30:00 | NVDA | Stock | 0.2292 | 0.2333 | 0.2188 | 0.2219 | 67512000.0 |
| 2001-01-19 10:00:00 | NVDA | Stock | 0.2219 | 0.2229 | 0.2135 | 0.222 | 47448000.0 |
| 2001-01-19 10:30:00 | NVDA | Stock | 0.2223 | 0.2292 | 0.2223 | 0.2284 | 124800000.0 |
| 2001-01-19 11:00:00 | NVDA | Stock | 0.2285 | 0.2299 | 0.2271 | 0.2281 | 53760000.0 |
| 2001-01-19 11:30:00 | NVDA | Stock | 0.2284 | 0.2346 | 0.2271 | 0.2333 | 45528000.0 |
| 2001-01-19 12:00:00 | NVDA | Stock | 0.2346 | 0.2375 | 0.2297 | 0.2323 | 71640000.0 |
| 2001-01-19 12:30:00 | NVDA | Stock | 0.2326 | 0.2333 | 0.2297 | 0.2328 | 77256000.0 |
> showing 50 of 26,969 rows — these rows as CSV