PREVIEW / stock_30min / 2001-04-27
file: by_date/stock_30min/2001/2001-04-27.parquet size: 517 KB rows: 27,335 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-27 08:00:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4446 | 0.4446 | 5600.0 |
| 2001-04-27 08:30:00 | AAPL | Stock | 0.4446 | 0.4554 | 0.4446 | 0.45 | 313600.0 |
| 2001-04-27 09:00:00 | AAPL | Stock | 0.45 | 0.4561 | 0.4464 | 0.4507 | 716800.0 |
| 2001-04-27 09:30:00 | AAPL | Stock | 0.45 | 0.4575 | 0.4446 | 0.4536 | 47941600.0 |
| 2001-04-27 10:00:00 | AAPL | Stock | 0.4536 | 0.458 | 0.4523 | 0.4527 | 36243200.0 |
| 2001-04-27 10:30:00 | AAPL | Stock | 0.4527 | 0.4546 | 0.4502 | 0.4514 | 29276800.0 |
| 2001-04-27 11:00:00 | AAPL | Stock | 0.4518 | 0.4518 | 0.4439 | 0.4443 | 22954400.0 |
| 2001-04-27 11:30:00 | AAPL | Stock | 0.4438 | 0.4527 | 0.442 | 0.452 | 25468800.0 |
| 2001-04-27 12:00:00 | AAPL | Stock | 0.452 | 0.4543 | 0.445 | 0.4471 | 17309600.0 |
| 2001-04-27 12:30:00 | AAPL | Stock | 0.4473 | 0.4523 | 0.4464 | 0.452 | 13160000.0 |
| 2001-04-27 13:00:00 | AAPL | Stock | 0.4525 | 0.4554 | 0.4496 | 0.455 | 9032800.0 |
| 2001-04-27 13:30:00 | AAPL | Stock | 0.4552 | 0.4571 | 0.453 | 0.4564 | 15064000.0 |
| 2001-04-27 14:00:00 | AAPL | Stock | 0.4566 | 0.458 | 0.453 | 0.4555 | 12964000.0 |
| 2001-04-27 14:30:00 | AAPL | Stock | 0.4555 | 0.4588 | 0.4516 | 0.4586 | 16895200.0 |
| 2001-04-27 15:00:00 | AAPL | Stock | 0.4586 | 0.4671 | 0.4563 | 0.4639 | 49033600.0 |
| 2001-04-27 15:30:00 | AAPL | Stock | 0.4639 | 0.4695 | 0.463 | 0.4679 | 52326400.0 |
| 2001-04-27 16:00:00 | AAPL | Stock | 0.468 | 0.4696 | 0.4552 | 0.4552 | 28593600.0 |
| 2001-04-27 16:30:00 | AAPL | Stock | 0.4679 | 0.4696 | 0.4679 | 0.4689 | 302400.0 |
| 2001-04-27 17:00:00 | AAPL | Stock | 0.4679 | 0.4679 | 0.4679 | 0.4679 | 44800.0 |
| 2001-04-27 17:30:00 | AAPL | Stock | 0.4689 | 0.4689 | 0.4689 | 0.4689 | 22400.0 |
| 2001-04-27 18:00:00 | AAPL | Stock | 0.47 | 0.47 | 0.4688 | 0.4689 | 134400.0 |
| 2001-04-27 08:00:00 | MSFT | Stock | 34.56 | 34.875 | 34.55 | 34.55 | 25400.0 |
| 2001-04-27 08:30:00 | MSFT | Stock | 34.625 | 35.1 | 34.565 | 34.985 | 237800.0 |
| 2001-04-27 09:00:00 | MSFT | Stock | 35.0 | 35.0 | 34.725 | 34.765 | 398000.0 |
| 2001-04-27 09:30:00 | MSFT | Stock | 34.765 | 34.84 | 34.33 | 34.525 | 10129200.0 |
| 2001-04-27 10:00:00 | MSFT | Stock | 34.525 | 34.77 | 34.365 | 34.395 | 6380000.0 |
| 2001-04-27 10:30:00 | MSFT | Stock | 34.39 | 34.515 | 34.0 | 34.08 | 6251000.0 |
| 2001-04-27 11:00:00 | MSFT | Stock | 34.085 | 34.24 | 33.88 | 33.915 | 5018400.0 |
| 2001-04-27 11:30:00 | MSFT | Stock | 33.915 | 34.215 | 33.9 | 33.95 | 5114600.0 |
| 2001-04-27 12:00:00 | MSFT | Stock | 33.955 | 34.005 | 33.5 | 33.895 | 10551400.0 |
| 2001-04-27 12:30:00 | MSFT | Stock | 33.88 | 33.965 | 33.58 | 33.61 | 8145400.0 |
| 2001-04-27 13:00:00 | MSFT | Stock | 33.61 | 33.78 | 33.575 | 33.68 | 4732000.0 |
| 2001-04-27 13:30:00 | MSFT | Stock | 33.685 | 33.71 | 33.575 | 33.59 | 5468600.0 |
| 2001-04-27 14:00:00 | MSFT | Stock | 33.59 | 33.625 | 33.12 | 33.28 | 14017000.0 |
| 2001-04-27 14:30:00 | MSFT | Stock | 33.275 | 33.35 | 33.11 | 33.25 | 8429000.0 |
| 2001-04-27 15:00:00 | MSFT | Stock | 33.25 | 33.52 | 33.11 | 33.495 | 10440400.0 |
| 2001-04-27 15:30:00 | MSFT | Stock | 33.49 | 33.825 | 33.475 | 33.56 | 15800400.0 |
| 2001-04-27 16:00:00 | MSFT | Stock | 33.565 | 34.725 | 33.375 | 33.565 | 4732200.0 |
| 2001-04-27 16:30:00 | MSFT | Stock | 33.565 | 33.725 | 33.525 | 33.7 | 45800.0 |
| 2001-04-27 17:00:00 | MSFT | Stock | 33.725 | 33.775 | 33.56 | 33.775 | 38200.0 |
| 2001-04-27 17:30:00 | MSFT | Stock | 33.75 | 33.825 | 33.67 | 33.675 | 14800.0 |
| 2001-04-27 18:00:00 | MSFT | Stock | 33.675 | 33.7 | 33.635 | 33.67 | 8000.0 |
| 2001-04-27 08:30:00 | NVDA | Stock | 0.3146 | 0.3208 | 0.3125 | 0.3167 | 3600000.0 |
| 2001-04-27 09:00:00 | NVDA | Stock | 0.3198 | 0.3213 | 0.3073 | 0.3194 | 8616000.0 |
| 2001-04-27 09:30:00 | NVDA | Stock | 0.3192 | 0.3255 | 0.3157 | 0.321 | 178680000.0 |
| 2001-04-27 10:00:00 | NVDA | Stock | 0.3216 | 0.3271 | 0.3198 | 0.3256 | 101808000.0 |
| 2001-04-27 10:30:00 | NVDA | Stock | 0.3256 | 0.3265 | 0.3171 | 0.3184 | 72096000.0 |
| 2001-04-27 11:00:00 | NVDA | Stock | 0.3179 | 0.3244 | 0.3172 | 0.318 | 42216000.0 |
| 2001-04-27 11:30:00 | NVDA | Stock | 0.318 | 0.3221 | 0.3167 | 0.3203 | 42768000.0 |
| 2001-04-27 12:00:00 | NVDA | Stock | 0.32 | 0.3213 | 0.313 | 0.3161 | 61056000.0 |
> showing 50 of 27,335 rows — these rows as CSV