PREVIEW / stock_30min / 2000-10-19
file: by_date/stock_30min/2000/2000-10-19.parquet size: 453 KB rows: 25,788 symbols: 1,235
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-10-19 08:00:00 | AAPL | Stock | 0.3036 | 0.3304 | 0.2857 | 0.3259 | 19073600.0 |
| 2000-10-19 08:30:00 | AAPL | Stock | 0.3276 | 0.3348 | 0.3214 | 0.3315 | 7084000.0 |
| 2000-10-19 09:00:00 | AAPL | Stock | 0.3304 | 0.3438 | 0.3147 | 0.3415 | 33588800.0 |
| 2000-10-19 09:30:00 | AAPL | Stock | 0.3421 | 0.3426 | 0.327 | 0.3281 | 254699200.0 |
| 2000-10-19 10:00:00 | AAPL | Stock | 0.3292 | 0.3527 | 0.3281 | 0.346 | 183724800.0 |
| 2000-10-19 10:30:00 | AAPL | Stock | 0.346 | 0.3538 | 0.3438 | 0.346 | 127349600.0 |
| 2000-10-19 11:00:00 | AAPL | Stock | 0.3449 | 0.3527 | 0.3438 | 0.3516 | 102575200.0 |
| 2000-10-19 11:30:00 | AAPL | Stock | 0.3516 | 0.3516 | 0.3438 | 0.3449 | 74244800.0 |
| 2000-10-19 12:00:00 | AAPL | Stock | 0.3449 | 0.3482 | 0.3415 | 0.3415 | 70330400.0 |
| 2000-10-19 12:30:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3371 | 0.3393 | 58335200.0 |
| 2000-10-19 13:00:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3337 | 0.3359 | 76120800.0 |
| 2000-10-19 13:30:00 | AAPL | Stock | 0.3359 | 0.3359 | 0.3304 | 0.3315 | 78596000.0 |
| 2000-10-19 14:00:00 | AAPL | Stock | 0.3315 | 0.3393 | 0.3315 | 0.3337 | 40790400.0 |
| 2000-10-19 14:30:00 | AAPL | Stock | 0.3348 | 0.3393 | 0.3292 | 0.3348 | 58609600.0 |
| 2000-10-19 15:00:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3315 | 0.3371 | 72620800.0 |
| 2000-10-19 15:30:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3331 | 0.3382 | 131521600.0 |
| 2000-10-19 16:00:00 | AAPL | Stock | 0.3382 | 0.3415 | 0.3371 | 0.3415 | 13624800.0 |
| 2000-10-19 16:30:00 | AAPL | Stock | 0.3092 | 0.3426 | 0.3092 | 0.3393 | 1047200.0 |
| 2000-10-19 17:00:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3393 | 0.3404 | 246400.0 |
| 2000-10-19 17:30:00 | AAPL | Stock | 0.3404 | 0.3438 | 0.3404 | 0.3438 | 274400.0 |
| 2000-10-19 18:00:00 | AAPL | Stock | 0.3438 | 0.3527 | 0.3438 | 0.3482 | 1887200.0 |
| 2000-10-19 08:00:00 | MSFT | Stock | 28.0 | 28.75 | 28.0 | 28.375 | 2139600.0 |
| 2000-10-19 08:30:00 | MSFT | Stock | 28.4375 | 28.6875 | 28.3125 | 28.5625 | 1758000.0 |
| 2000-10-19 09:00:00 | MSFT | Stock | 28.625 | 29.25 | 26.0312 | 29.1875 | 5285400.0 |
| 2000-10-19 09:30:00 | MSFT | Stock | 29.1875 | 29.4688 | 29.0625 | 29.4375 | 43228200.0 |
| 2000-10-19 10:00:00 | MSFT | Stock | 29.4375 | 29.75 | 29.375 | 29.5312 | 21757000.0 |
| 2000-10-19 10:30:00 | MSFT | Stock | 29.5 | 30.0312 | 29.5 | 29.875 | 20525000.0 |
| 2000-10-19 11:00:00 | MSFT | Stock | 29.875 | 30.6562 | 29.75 | 30.625 | 20778200.0 |
| 2000-10-19 11:30:00 | MSFT | Stock | 30.5625 | 30.6562 | 30.3125 | 30.375 | 13642600.0 |
| 2000-10-19 12:00:00 | MSFT | Stock | 30.4062 | 30.625 | 30.3125 | 30.5 | 14105400.0 |
| 2000-10-19 12:30:00 | MSFT | Stock | 30.5 | 30.5625 | 30.25 | 30.375 | 8455800.0 |
| 2000-10-19 13:00:00 | MSFT | Stock | 30.375 | 30.375 | 30.1719 | 30.25 | 7968400.0 |
| 2000-10-19 13:30:00 | MSFT | Stock | 30.25 | 30.3438 | 29.9062 | 30.0 | 13482600.0 |
| 2000-10-19 14:00:00 | MSFT | Stock | 30.0312 | 30.375 | 30.0 | 30.2812 | 10292400.0 |
| 2000-10-19 14:30:00 | MSFT | Stock | 30.3125 | 30.9688 | 30.2812 | 30.7969 | 16105400.0 |
| 2000-10-19 15:00:00 | MSFT | Stock | 30.8438 | 31.0938 | 30.7188 | 31.0 | 14561200.0 |
| 2000-10-19 15:30:00 | MSFT | Stock | 31.0 | 31.0625 | 30.625 | 30.875 | 16341800.0 |
| 2000-10-19 16:00:00 | MSFT | Stock | 30.9062 | 30.9375 | 30.0469 | 30.9062 | 4472800.0 |
| 2000-10-19 16:30:00 | MSFT | Stock | 30.875 | 31.1875 | 30.1094 | 31.125 | 486800.0 |
| 2000-10-19 17:00:00 | MSFT | Stock | 31.1406 | 31.1406 | 29.7188 | 31.0 | 67400.0 |
| 2000-10-19 17:30:00 | MSFT | Stock | 30.9375 | 31.0625 | 30.9375 | 31.0625 | 20200.0 |
| 2000-10-19 18:00:00 | MSFT | Stock | 31.0625 | 31.1562 | 31.0 | 31.125 | 33200.0 |
| 2000-10-19 09:00:00 | NVDA | Stock | 0.2531 | 0.2583 | 0.2531 | 0.2581 | 648000.0 |
| 2000-10-19 09:30:00 | NVDA | Stock | 0.2576 | 0.2633 | 0.2557 | 0.2598 | 19200000.0 |
| 2000-10-19 10:00:00 | NVDA | Stock | 0.2598 | 0.2643 | 0.2557 | 0.2563 | 14328000.0 |
| 2000-10-19 10:30:00 | NVDA | Stock | 0.2557 | 0.2596 | 0.2536 | 0.2565 | 20304000.0 |
| 2000-10-19 11:00:00 | NVDA | Stock | 0.2565 | 0.2589 | 0.2542 | 0.2589 | 39768000.0 |
| 2000-10-19 11:30:00 | NVDA | Stock | 0.2589 | 0.2635 | 0.2583 | 0.2602 | 41928000.0 |
| 2000-10-19 12:00:00 | NVDA | Stock | 0.2599 | 0.2602 | 0.2573 | 0.2594 | 16848000.0 |
| 2000-10-19 12:30:00 | NVDA | Stock | 0.2594 | 0.2602 | 0.2583 | 0.2602 | 6816000.0 |
> showing 50 of 25,788 rows — these rows as CSV