PREVIEW / stock_30min / 2001-04-20
file: by_date/stock_30min/2001/2001-04-20.parquet size: 518 KB rows: 27,187 symbols: 1,287
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-04-20 08:00:00 | AAPL | Stock | 0.4596 | 0.4596 | 0.4511 | 0.4527 | 593600.0 |
| 2001-04-20 08:30:00 | AAPL | Stock | 0.4527 | 0.4527 | 0.442 | 0.442 | 1848000.0 |
| 2001-04-20 09:00:00 | AAPL | Stock | 0.4421 | 0.4571 | 0.442 | 0.4457 | 4088000.0 |
| 2001-04-20 09:30:00 | AAPL | Stock | 0.4452 | 0.4577 | 0.4441 | 0.4513 | 107654400.0 |
| 2001-04-20 10:00:00 | AAPL | Stock | 0.4513 | 0.4554 | 0.4464 | 0.4488 | 66931200.0 |
| 2001-04-20 10:30:00 | AAPL | Stock | 0.4488 | 0.4509 | 0.4438 | 0.4459 | 59651200.0 |
| 2001-04-20 11:00:00 | AAPL | Stock | 0.4457 | 0.4475 | 0.4429 | 0.4429 | 48837600.0 |
| 2001-04-20 11:30:00 | AAPL | Stock | 0.4429 | 0.4471 | 0.4393 | 0.4446 | 31556000.0 |
| 2001-04-20 12:00:00 | AAPL | Stock | 0.4446 | 0.4464 | 0.4427 | 0.4461 | 11687200.0 |
| 2001-04-20 12:30:00 | AAPL | Stock | 0.4461 | 0.4514 | 0.4446 | 0.4446 | 28117600.0 |
| 2001-04-20 13:00:00 | AAPL | Stock | 0.4446 | 0.4482 | 0.4441 | 0.4464 | 38091200.0 |
| 2001-04-20 13:30:00 | AAPL | Stock | 0.4464 | 0.4563 | 0.445 | 0.4555 | 24281600.0 |
| 2001-04-20 14:00:00 | AAPL | Stock | 0.4555 | 0.4555 | 0.45 | 0.4525 | 33784800.0 |
| 2001-04-20 14:30:00 | AAPL | Stock | 0.4525 | 0.4536 | 0.4464 | 0.4484 | 33801600.0 |
| 2001-04-20 15:00:00 | AAPL | Stock | 0.4484 | 0.4523 | 0.4459 | 0.4504 | 34372800.0 |
| 2001-04-20 15:30:00 | AAPL | Stock | 0.4504 | 0.4509 | 0.4459 | 0.4471 | 45808000.0 |
| 2001-04-20 16:00:00 | AAPL | Stock | 0.4464 | 0.4488 | 0.4425 | 0.4464 | 15960000.0 |
| 2001-04-20 16:30:00 | AAPL | Stock | 0.4471 | 0.4471 | 0.4455 | 0.4461 | 2402400.0 |
| 2001-04-20 17:00:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4455 | 0.4455 | 733600.0 |
| 2001-04-20 17:30:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4464 | 0.4464 | 28000.0 |
| 2001-04-20 18:00:00 | AAPL | Stock | 0.4477 | 0.4477 | 0.4464 | 0.4464 | 16800.0 |
| 2001-04-20 08:00:00 | MSFT | Stock | 35.95 | 36.45 | 35.5 | 35.76 | 1332600.0 |
| 2001-04-20 08:30:00 | MSFT | Stock | 35.775 | 36.08 | 34.0 | 35.215 | 2524600.0 |
| 2001-04-20 09:00:00 | MSFT | Stock | 35.3 | 36.3 | 34.475 | 35.15 | 4807400.0 |
| 2001-04-20 09:30:00 | MSFT | Stock | 35.15 | 35.225 | 34.885 | 35.125 | 40210200.0 |
| 2001-04-20 10:00:00 | MSFT | Stock | 35.13 | 35.55 | 35.105 | 35.195 | 25034200.0 |
| 2001-04-20 10:30:00 | MSFT | Stock | 35.21 | 35.25 | 34.95 | 35.0 | 15276600.0 |
| 2001-04-20 11:00:00 | MSFT | Stock | 34.985 | 35.51 | 34.675 | 34.89 | 11352800.0 |
| 2001-04-20 11:30:00 | MSFT | Stock | 34.91 | 34.91 | 34.615 | 34.725 | 11596000.0 |
| 2001-04-20 12:00:00 | MSFT | Stock | 34.72 | 34.945 | 34.7 | 34.8 | 8270600.0 |
| 2001-04-20 12:30:00 | MSFT | Stock | 34.795 | 34.885 | 34.75 | 34.78 | 5706800.0 |
| 2001-04-20 13:00:00 | MSFT | Stock | 34.785 | 35.04 | 34.76 | 34.995 | 6874000.0 |
| 2001-04-20 13:30:00 | MSFT | Stock | 35.0 | 35.015 | 34.815 | 34.99 | 4570000.0 |
| 2001-04-20 14:00:00 | MSFT | Stock | 34.99 | 35.055 | 34.69 | 34.765 | 6123600.0 |
| 2001-04-20 14:30:00 | MSFT | Stock | 34.785 | 35.0 | 34.715 | 34.925 | 6123000.0 |
| 2001-04-20 15:00:00 | MSFT | Stock | 34.925 | 35.025 | 34.25 | 34.565 | 13144200.0 |
| 2001-04-20 15:30:00 | MSFT | Stock | 34.57 | 34.625 | 34.345 | 34.52 | 15439600.0 |
| 2001-04-20 16:00:00 | MSFT | Stock | 34.5 | 34.96 | 34.37 | 34.45 | 3558000.0 |
| 2001-04-20 16:30:00 | MSFT | Stock | 34.465 | 34.915 | 34.415 | 34.415 | 339400.0 |
| 2001-04-20 17:00:00 | MSFT | Stock | 34.42 | 34.45 | 34.42 | 34.45 | 450400.0 |
| 2001-04-20 17:30:00 | MSFT | Stock | 34.45 | 34.5 | 34.45 | 34.5 | 10400.0 |
| 2001-04-20 18:00:00 | MSFT | Stock | 34.885 | 34.885 | 34.5 | 34.535 | 17400.0 |
| 2001-04-20 08:00:00 | NVDA | Stock | 0.3458 | 0.3479 | 0.3417 | 0.3458 | 624000.0 |
| 2001-04-20 08:30:00 | NVDA | Stock | 0.3458 | 0.3469 | 0.3415 | 0.3418 | 624000.0 |
| 2001-04-20 09:00:00 | NVDA | Stock | 0.3417 | 0.3456 | 0.3375 | 0.3456 | 2520000.0 |
| 2001-04-20 09:30:00 | NVDA | Stock | 0.3454 | 0.3499 | 0.3363 | 0.3479 | 178680000.0 |
| 2001-04-20 10:00:00 | NVDA | Stock | 0.3481 | 0.3569 | 0.3479 | 0.3513 | 168264000.0 |
| 2001-04-20 10:30:00 | NVDA | Stock | 0.3513 | 0.3517 | 0.3409 | 0.3433 | 210024000.0 |
| 2001-04-20 11:00:00 | NVDA | Stock | 0.3433 | 0.3475 | 0.3378 | 0.3453 | 85512000.0 |
| 2001-04-20 11:30:00 | NVDA | Stock | 0.3453 | 0.3473 | 0.3433 | 0.3436 | 90336000.0 |
> showing 50 of 27,187 rows — these rows as CSV