PREVIEW / stock_30min / 2026-07-20
file: by_date/stock_30min/2026/2026-07-20.parquet size: 2.1 MB rows: 99,377
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 |
|---|---|---|---|---|---|---|---|
| 2026-07-20 04:00:00 | AAPL | Stock | 333.26 | 334.33 | 332.9112 | 333.64 | 42934.0 |
| 2026-07-20 04:30:00 | AAPL | Stock | 333.36 | 333.56 | 333.1481 | 333.51 | 2236.0 |
| 2026-07-20 05:00:00 | AAPL | Stock | 333.55 | 333.6 | 333.2 | 333.5644 | 6278.0 |
| 2026-07-20 05:30:00 | AAPL | Stock | 333.44 | 333.61 | 333.1648 | 333.29 | 6087.0 |
| 2026-07-20 06:00:00 | AAPL | Stock | 333.21 | 333.73 | 332.6 | 332.67 | 8844.0 |
| 2026-07-20 06:30:00 | AAPL | Stock | 332.89 | 335.0 | 332.62 | 333.1455 | 42885.0 |
| 2026-07-20 07:00:00 | AAPL | Stock | 332.99 | 333.0 | 331.27 | 331.85 | 57886.0 |
| 2026-07-20 07:30:00 | AAPL | Stock | 331.85 | 332.8 | 331.5 | 331.57 | 51250.0 |
| 2026-07-20 08:00:00 | AAPL | Stock | 331.6 | 332.47 | 331.27 | 332.47 | 56337.0 |
| 2026-07-20 08:30:00 | AAPL | Stock | 332.3 | 332.65 | 332.0 | 332.55 | 36436.0 |
| 2026-07-20 09:00:00 | AAPL | Stock | 332.54 | 333.6655 | 332.0 | 333.02 | 65148.0 |
| 2026-07-20 09:30:00 | AAPL | Stock | 333.505 | 333.71 | 328.4 | 328.9 | 4538292.0 |
| 2026-07-20 10:00:00 | AAPL | Stock | 328.88 | 329.01 | 326.11 | 327.02 | 3708890.0 |
| 2026-07-20 10:30:00 | AAPL | Stock | 327.0 | 328.02 | 326.02 | 326.43 | 2451314.0 |
| 2026-07-20 11:00:00 | AAPL | Stock | 326.45 | 327.015 | 324.42 | 324.9 | 2857301.0 |
| 2026-07-20 11:30:00 | AAPL | Stock | 324.94 | 326.545 | 324.905 | 325.975 | 1962686.0 |
| 2026-07-20 12:00:00 | AAPL | Stock | 325.98 | 326.04 | 324.87 | 325.0 | 1882028.0 |
| 2026-07-20 12:30:00 | AAPL | Stock | 325.0 | 325.09 | 323.68 | 324.245 | 1996735.0 |
| 2026-07-20 13:00:00 | AAPL | Stock | 324.26 | 325.16 | 323.91 | 324.72 | 1280744.0 |
| 2026-07-20 13:30:00 | AAPL | Stock | 324.73 | 325.3832 | 324.2 | 324.78 | 1389628.0 |
| 2026-07-20 14:00:00 | AAPL | Stock | 324.77 | 326.49 | 324.655 | 325.98 | 2077485.0 |
| 2026-07-20 14:30:00 | AAPL | Stock | 325.98 | 327.37 | 325.31 | 326.75 | 2414198.0 |
| 2026-07-20 15:00:00 | AAPL | Stock | 326.77 | 329.09 | 326.75 | 329.02 | 2535871.0 |
| 2026-07-20 15:30:00 | AAPL | Stock | 329.01 | 329.76 | 326.0 | 326.7 | 4804119.0 |
| 2026-07-20 16:00:00 | AAPL | Stock | 326.59 | 327.17 | 326.41 | 327.1 | 8389382.0 |
| 2026-07-20 16:30:00 | AAPL | Stock | 326.878 | 327.1658 | 326.59 | 326.95 | 55432.0 |
| 2026-07-20 17:00:00 | AAPL | Stock | 326.8501 | 327.2 | 326.85 | 326.85 | 5918.0 |
| 2026-07-20 17:30:00 | AAPL | Stock | 326.6 | 326.86 | 326.6 | 326.7972 | 3241.0 |
| 2026-07-20 18:00:00 | AAPL | Stock | 326.65 | 326.66 | 325.82 | 325.95 | 21210.0 |
| 2026-07-20 18:30:00 | AAPL | Stock | 325.8115 | 325.95 | 325.27 | 325.3155 | 15404.0 |
| 2026-07-20 19:00:00 | AAPL | Stock | 325.32 | 326.44 | 325.3 | 326.3 | 18265.0 |
| 2026-07-20 19:30:00 | AAPL | Stock | 326.5218 | 326.59 | 325.7819 | 326.0 | 23367.0 |
| 2026-07-20 04:00:00 | MSFT | Stock | 394.24 | 395.0224 | 392.1 | 393.41 | 47511.0 |
| 2026-07-20 04:30:00 | MSFT | Stock | 393.13 | 393.62 | 393.1 | 393.14 | 6804.0 |
| 2026-07-20 05:00:00 | MSFT | Stock | 393.1 | 393.13 | 392.5648 | 392.8 | 4567.0 |
| 2026-07-20 05:30:00 | MSFT | Stock | 392.75 | 393.2 | 392.3 | 392.43 | 9591.0 |
| 2026-07-20 06:00:00 | MSFT | Stock | 392.6 | 393.14 | 392.174 | 392.174 | 7675.0 |
| 2026-07-20 06:30:00 | MSFT | Stock | 392.5 | 392.5 | 391.16 | 392.1 | 12919.0 |
| 2026-07-20 07:00:00 | MSFT | Stock | 392.19 | 392.19 | 390.53 | 391.49 | 28499.0 |
| 2026-07-20 07:30:00 | MSFT | Stock | 391.25 | 392.07 | 390.75 | 391.1 | 39240.0 |
| 2026-07-20 08:00:00 | MSFT | Stock | 391.0 | 391.31 | 390.1 | 390.2301 | 32731.0 |
| 2026-07-20 08:30:00 | MSFT | Stock | 390.3 | 390.75 | 388.7641 | 389.25 | 83704.0 |
| 2026-07-20 09:00:00 | MSFT | Stock | 389.32 | 391.58 | 388.58 | 391.27 | 125619.0 |
| 2026-07-20 09:30:00 | MSFT | Stock | 391.41 | 392.99 | 389.65 | 390.97 | 2812312.0 |
| 2026-07-20 10:00:00 | MSFT | Stock | 390.98 | 395.24 | 390.15 | 394.325 | 1478809.0 |
| 2026-07-20 10:30:00 | MSFT | Stock | 394.36 | 396.26 | 394.0705 | 395.86 | 1318536.0 |
| 2026-07-20 11:00:00 | MSFT | Stock | 395.9 | 398.13 | 395.53 | 397.7466 | 1383041.0 |
| 2026-07-20 11:30:00 | MSFT | Stock | 397.69 | 399.2 | 397.07 | 398.95 | 1011502.0 |
| 2026-07-20 12:00:00 | MSFT | Stock | 398.96 | 401.76 | 398.7525 | 401.49 | 1264847.0 |
| 2026-07-20 12:30:00 | MSFT | Stock | 401.49 | 403.18 | 401.36 | 401.41 | 1488614.0 |
> showing 50 of 99,377 rows — these rows as CSV