PREVIEW / stock_30min / 2001-08-09
file: by_date/stock_30min/2001/2001-08-09.parquet size: 525 KB rows: 27,585 symbols: 1,324
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-08-09 08:00:00 | AAPL | Stock | 0.3375 | 0.3375 | 0.3354 | 0.3354 | 274400.0 |
| 2001-08-09 08:30:00 | AAPL | Stock | 0.3373 | 0.3373 | 0.3373 | 0.3373 | 56000.0 |
| 2001-08-09 09:00:00 | AAPL | Stock | 0.3389 | 0.3389 | 0.3388 | 0.3388 | 190400.0 |
| 2001-08-09 09:30:00 | AAPL | Stock | 0.3386 | 0.3402 | 0.3348 | 0.34 | 18401600.0 |
| 2001-08-09 10:00:00 | AAPL | Stock | 0.34 | 0.3402 | 0.3343 | 0.3371 | 16251200.0 |
| 2001-08-09 10:30:00 | AAPL | Stock | 0.3371 | 0.3384 | 0.3348 | 0.337 | 24225600.0 |
| 2001-08-09 11:00:00 | AAPL | Stock | 0.3371 | 0.3405 | 0.3354 | 0.3395 | 21431200.0 |
| 2001-08-09 11:30:00 | AAPL | Stock | 0.3393 | 0.34 | 0.3355 | 0.3357 | 10309600.0 |
| 2001-08-09 12:00:00 | AAPL | Stock | 0.3357 | 0.337 | 0.3348 | 0.335 | 9766400.0 |
| 2001-08-09 12:30:00 | AAPL | Stock | 0.3348 | 0.3382 | 0.3348 | 0.3377 | 4536000.0 |
| 2001-08-09 13:00:00 | AAPL | Stock | 0.3377 | 0.3404 | 0.3366 | 0.3393 | 8971200.0 |
| 2001-08-09 13:30:00 | AAPL | Stock | 0.3395 | 0.3414 | 0.3379 | 0.3391 | 8226400.0 |
| 2001-08-09 14:00:00 | AAPL | Stock | 0.3391 | 0.3418 | 0.3384 | 0.3398 | 9234400.0 |
| 2001-08-09 14:30:00 | AAPL | Stock | 0.3391 | 0.3407 | 0.3375 | 0.34 | 8209600.0 |
| 2001-08-09 15:00:00 | AAPL | Stock | 0.34 | 0.342 | 0.3357 | 0.3361 | 16665600.0 |
| 2001-08-09 15:30:00 | AAPL | Stock | 0.3357 | 0.3405 | 0.3354 | 0.3402 | 25513600.0 |
| 2001-08-09 16:00:00 | AAPL | Stock | 0.3402 | 0.3427 | 0.34 | 0.3404 | 2749600.0 |
| 2001-08-09 16:30:00 | AAPL | Stock | 0.3402 | 0.3402 | 0.3393 | 0.3393 | 1304800.0 |
| 2001-08-09 17:30:00 | AAPL | Stock | 0.3409 | 0.3409 | 0.3409 | 0.3409 | 5600.0 |
| 2001-08-09 18:00:00 | AAPL | Stock | 0.3425 | 0.3425 | 0.3425 | 0.3425 | 11200.0 |
| 2001-08-09 08:00:00 | MSFT | Stock | 32.5 | 32.65 | 32.015 | 32.515 | 129800.0 |
| 2001-08-09 08:30:00 | MSFT | Stock | 32.55 | 32.65 | 32.44 | 32.6 | 85600.0 |
| 2001-08-09 09:00:00 | MSFT | Stock | 32.6 | 32.6 | 32.055 | 32.485 | 107600.0 |
| 2001-08-09 09:30:00 | MSFT | Stock | 32.49 | 32.7 | 32.305 | 32.695 | 6903200.0 |
| 2001-08-09 10:00:00 | MSFT | Stock | 32.695 | 32.72 | 32.375 | 32.49 | 4043800.0 |
| 2001-08-09 10:30:00 | MSFT | Stock | 32.49 | 32.5 | 32.15 | 32.3 | 3992000.0 |
| 2001-08-09 11:00:00 | MSFT | Stock | 32.3 | 32.51 | 32.16 | 32.415 | 3562200.0 |
| 2001-08-09 11:30:00 | MSFT | Stock | 32.41 | 32.56 | 32.27 | 32.27 | 2469400.0 |
| 2001-08-09 12:00:00 | MSFT | Stock | 32.265 | 32.465 | 32.21 | 32.265 | 1936600.0 |
| 2001-08-09 12:30:00 | MSFT | Stock | 32.29 | 32.585 | 32.265 | 32.55 | 2850400.0 |
| 2001-08-09 13:00:00 | MSFT | Stock | 32.555 | 32.75 | 32.485 | 32.605 | 3156600.0 |
| 2001-08-09 13:30:00 | MSFT | Stock | 32.62 | 32.75 | 32.465 | 32.55 | 1770800.0 |
| 2001-08-09 14:00:00 | MSFT | Stock | 32.56 | 32.68 | 32.425 | 32.475 | 1364200.0 |
| 2001-08-09 14:30:00 | MSFT | Stock | 32.455 | 32.6 | 32.375 | 32.52 | 1984200.0 |
| 2001-08-09 15:00:00 | MSFT | Stock | 32.52 | 32.67 | 32.485 | 32.52 | 3392600.0 |
| 2001-08-09 15:30:00 | MSFT | Stock | 32.515 | 32.605 | 32.45 | 32.505 | 3517600.0 |
| 2001-08-09 16:00:00 | MSFT | Stock | 32.5 | 32.75 | 32.425 | 32.54 | 2026800.0 |
| 2001-08-09 16:30:00 | MSFT | Stock | 32.55 | 32.55 | 32.505 | 32.51 | 111000.0 |
| 2001-08-09 17:00:00 | MSFT | Stock | 32.495 | 32.545 | 32.495 | 32.545 | 2600.0 |
| 2001-08-09 17:30:00 | MSFT | Stock | 32.55 | 32.55 | 32.55 | 32.55 | 400.0 |
| 2001-08-09 18:00:00 | MSFT | Stock | 32.55 | 32.55 | 32.55 | 32.55 | 1600.0 |
| 2001-08-09 08:00:00 | NVDA | Stock | 0.3592 | 0.3599 | 0.3592 | 0.3599 | 168000.0 |
| 2001-08-09 08:30:00 | NVDA | Stock | 0.3584 | 0.359 | 0.3573 | 0.3583 | 888000.0 |
| 2001-08-09 09:00:00 | NVDA | Stock | 0.3583 | 0.3587 | 0.3581 | 0.3583 | 1632000.0 |
| 2001-08-09 09:30:00 | NVDA | Stock | 0.3577 | 0.3629 | 0.357 | 0.3623 | 166848000.0 |
| 2001-08-09 10:00:00 | NVDA | Stock | 0.3623 | 0.3648 | 0.3527 | 0.3528 | 139464000.0 |
| 2001-08-09 10:30:00 | NVDA | Stock | 0.3528 | 0.3529 | 0.3475 | 0.35 | 226200000.0 |
| 2001-08-09 11:00:00 | NVDA | Stock | 0.3502 | 0.3531 | 0.3488 | 0.3528 | 134184000.0 |
| 2001-08-09 11:30:00 | NVDA | Stock | 0.3528 | 0.3544 | 0.3503 | 0.3505 | 131832000.0 |
| 2001-08-09 12:00:00 | NVDA | Stock | 0.3503 | 0.3523 | 0.3482 | 0.3483 | 30600000.0 |
> showing 50 of 27,585 rows — these rows as CSV