PREVIEW / stock_30min / 2001-04-19
file: by_date/stock_30min/2001/2001-04-19.parquet size: 537 KB rows: 27,930 symbols: 1,294
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-19 08:00:00 | AAPL | Stock | 0.4643 | 0.4732 | 0.4554 | 0.4652 | 29025248.0 |
| 2001-04-19 08:30:00 | AAPL | Stock | 0.4645 | 0.4652 | 0.4566 | 0.4591 | 7302400.0 |
| 2001-04-19 09:00:00 | AAPL | Stock | 0.4598 | 0.4714 | 0.4539 | 0.4539 | 14072800.0 |
| 2001-04-19 09:30:00 | AAPL | Stock | 0.4563 | 0.458 | 0.4214 | 0.4225 | 381701600.0 |
| 2001-04-19 10:00:00 | AAPL | Stock | 0.4229 | 0.4345 | 0.422 | 0.4313 | 169786400.0 |
| 2001-04-19 10:30:00 | AAPL | Stock | 0.4307 | 0.435 | 0.4295 | 0.435 | 160916000.0 |
| 2001-04-19 11:00:00 | AAPL | Stock | 0.435 | 0.4402 | 0.4336 | 0.4366 | 89073600.0 |
| 2001-04-19 11:30:00 | AAPL | Stock | 0.4363 | 0.4473 | 0.4348 | 0.4459 | 139938400.0 |
| 2001-04-19 12:00:00 | AAPL | Stock | 0.4455 | 0.4486 | 0.4411 | 0.4464 | 111020000.0 |
| 2001-04-19 12:30:00 | AAPL | Stock | 0.4466 | 0.4468 | 0.4441 | 0.445 | 42851200.0 |
| 2001-04-19 13:00:00 | AAPL | Stock | 0.4452 | 0.4484 | 0.4446 | 0.4464 | 111277600.0 |
| 2001-04-19 13:30:00 | AAPL | Stock | 0.4464 | 0.4523 | 0.4464 | 0.4509 | 80416000.0 |
| 2001-04-19 14:00:00 | AAPL | Stock | 0.4509 | 0.4548 | 0.45 | 0.4545 | 87925600.0 |
| 2001-04-19 14:30:00 | AAPL | Stock | 0.4543 | 0.4564 | 0.4429 | 0.4438 | 94096800.0 |
| 2001-04-19 15:00:00 | AAPL | Stock | 0.4443 | 0.4552 | 0.4357 | 0.4548 | 90479200.0 |
| 2001-04-19 15:30:00 | AAPL | Stock | 0.4548 | 0.4598 | 0.4507 | 0.4591 | 134478400.0 |
| 2001-04-19 16:00:00 | AAPL | Stock | 0.4591 | 0.4598 | 0.4432 | 0.4554 | 40756800.0 |
| 2001-04-19 16:30:00 | AAPL | Stock | 0.45 | 0.4593 | 0.45 | 0.452 | 23189600.0 |
| 2001-04-19 17:00:00 | AAPL | Stock | 0.4554 | 0.458 | 0.4518 | 0.4518 | 140000.0 |
| 2001-04-19 17:30:00 | AAPL | Stock | 0.4554 | 0.458 | 0.4554 | 0.458 | 224000.0 |
| 2001-04-19 18:00:00 | AAPL | Stock | 0.4554 | 0.4625 | 0.4554 | 0.4589 | 464800.0 |
| 2001-04-19 08:00:00 | MSFT | Stock | 33.35 | 33.48 | 32.95 | 33.25 | 169600.0 |
| 2001-04-19 08:30:00 | MSFT | Stock | 33.205 | 33.25 | 32.985 | 33.1 | 323000.0 |
| 2001-04-19 09:00:00 | MSFT | Stock | 33.1 | 33.275 | 32.45 | 32.91 | 531400.0 |
| 2001-04-19 09:30:00 | MSFT | Stock | 32.905 | 33.52 | 32.875 | 33.45 | 18176600.0 |
| 2001-04-19 10:00:00 | MSFT | Stock | 33.43 | 33.875 | 33.375 | 33.77 | 15849000.0 |
| 2001-04-19 10:30:00 | MSFT | Stock | 33.77 | 34.18 | 33.705 | 33.75 | 13877200.0 |
| 2001-04-19 11:00:00 | MSFT | Stock | 33.75 | 33.82 | 33.3 | 33.35 | 7176400.0 |
| 2001-04-19 11:30:00 | MSFT | Stock | 33.355 | 33.68 | 33.29 | 33.525 | 5275400.0 |
| 2001-04-19 12:00:00 | MSFT | Stock | 33.5 | 33.885 | 33.44 | 33.87 | 4961400.0 |
| 2001-04-19 12:30:00 | MSFT | Stock | 33.87 | 33.9 | 33.8 | 33.865 | 5585600.0 |
| 2001-04-19 13:00:00 | MSFT | Stock | 33.875 | 34.055 | 33.815 | 33.9 | 6206000.0 |
| 2001-04-19 13:30:00 | MSFT | Stock | 33.93 | 34.05 | 33.875 | 33.975 | 4594800.0 |
| 2001-04-19 14:00:00 | MSFT | Stock | 33.99 | 34.05 | 33.83 | 33.915 | 6356800.0 |
| 2001-04-19 14:30:00 | MSFT | Stock | 33.91 | 34.02 | 33.595 | 33.725 | 7624800.0 |
| 2001-04-19 15:00:00 | MSFT | Stock | 33.74 | 33.99 | 33.685 | 33.88 | 8911400.0 |
| 2001-04-19 15:30:00 | MSFT | Stock | 33.88 | 34.175 | 33.865 | 34.02 | 22193800.0 |
| 2001-04-19 16:00:00 | MSFT | Stock | 34.02 | 35.25 | 33.67 | 34.46 | 10988200.0 |
| 2001-04-19 16:30:00 | MSFT | Stock | 34.45 | 35.5 | 33.535 | 35.4 | 5433000.0 |
| 2001-04-19 17:00:00 | MSFT | Stock | 35.41 | 36.2 | 33.97 | 36.14 | 3267200.0 |
| 2001-04-19 17:30:00 | MSFT | Stock | 36.15 | 36.2 | 35.255 | 35.96 | 1155800.0 |
| 2001-04-19 18:00:00 | MSFT | Stock | 35.985 | 36.25 | 35.925 | 36.175 | 907000.0 |
| 2001-04-19 08:00:00 | NVDA | Stock | 0.3103 | 0.3275 | 0.3103 | 0.326 | 192000.0 |
| 2001-04-19 08:30:00 | NVDA | Stock | 0.3276 | 0.3276 | 0.3208 | 0.3208 | 840000.0 |
| 2001-04-19 09:00:00 | NVDA | Stock | 0.3219 | 0.3242 | 0.3208 | 0.3242 | 3480000.0 |
| 2001-04-19 09:30:00 | NVDA | Stock | 0.3238 | 0.3354 | 0.3223 | 0.3315 | 246096000.0 |
| 2001-04-19 10:00:00 | NVDA | Stock | 0.3319 | 0.3352 | 0.3302 | 0.3335 | 134736000.0 |
| 2001-04-19 10:30:00 | NVDA | Stock | 0.3333 | 0.3368 | 0.3319 | 0.3333 | 118440000.0 |
| 2001-04-19 11:00:00 | NVDA | Stock | 0.334 | 0.3363 | 0.3319 | 0.3335 | 79224000.0 |
| 2001-04-19 11:30:00 | NVDA | Stock | 0.3335 | 0.3348 | 0.3333 | 0.3336 | 51408000.0 |
> showing 50 of 27,930 rows — these rows as CSV