PREVIEW / stock_30min / 2026-07-31
file: by_date/stock_30min/2026/2026-07-31.parquet size: 2.1 MB rows: 100,997
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-31 04:00:00 | AAPL | Stock | 312.35 | 314.12 | 308.11 | 308.4 | 384720.0 |
| 2026-07-31 04:30:00 | AAPL | Stock | 308.59 | 310.6 | 308.41 | 309.53 | 77435.0 |
| 2026-07-31 05:00:00 | AAPL | Stock | 309.54 | 310.4671 | 308.8 | 309.5 | 112048.0 |
| 2026-07-31 05:30:00 | AAPL | Stock | 309.5 | 309.9 | 308.69 | 309.0 | 73790.0 |
| 2026-07-31 06:00:00 | AAPL | Stock | 309.0 | 309.88 | 308.68 | 309.01 | 79727.0 |
| 2026-07-31 06:30:00 | AAPL | Stock | 309.21 | 309.9 | 307.36 | 308.36 | 192507.0 |
| 2026-07-31 07:00:00 | AAPL | Stock | 308.54 | 309.28 | 306.33 | 307.5 | 467131.0 |
| 2026-07-31 07:30:00 | AAPL | Stock | 307.49 | 308.52 | 306.52 | 308.01 | 362695.0 |
| 2026-07-31 08:00:00 | AAPL | Stock | 308.0 | 308.5 | 307.04 | 308.0 | 689767.0 |
| 2026-07-31 08:30:00 | AAPL | Stock | 308.0 | 308.73 | 306.5 | 308.34 | 869287.0 |
| 2026-07-31 09:00:00 | AAPL | Stock | 308.285 | 308.38 | 303.45 | 304.7 | 1668090.0 |
| 2026-07-31 09:30:00 | AAPL | Stock | 304.7 | 306.9 | 300.32 | 302.79 | 24890661.0 |
| 2026-07-31 10:00:00 | AAPL | Stock | 302.79 | 303.57 | 301.3501 | 302.74 | 7005884.0 |
| 2026-07-31 10:30:00 | AAPL | Stock | 302.755 | 303.2 | 301.7 | 303.16 | 4178118.0 |
| 2026-07-31 11:00:00 | AAPL | Stock | 303.16 | 304.25 | 301.64 | 301.73 | 4996409.0 |
| 2026-07-31 11:30:00 | AAPL | Stock | 301.73 | 302.82 | 300.38 | 301.295 | 4639782.0 |
| 2026-07-31 12:00:00 | AAPL | Stock | 301.285 | 302.34 | 300.47 | 300.54 | 3115594.0 |
| 2026-07-31 12:30:00 | AAPL | Stock | 300.56 | 301.55 | 300.0 | 300.855 | 3917464.0 |
| 2026-07-31 13:00:00 | AAPL | Stock | 300.86 | 301.8343 | 300.855 | 301.2 | 2585020.0 |
| 2026-07-31 13:30:00 | AAPL | Stock | 301.2 | 301.72 | 300.5 | 300.64 | 2433586.0 |
| 2026-07-31 14:00:00 | AAPL | Stock | 300.64 | 302.42 | 300.595 | 301.73 | 3184911.0 |
| 2026-07-31 14:30:00 | AAPL | Stock | 301.76 | 303.0 | 301.745 | 302.83 | 3257650.0 |
| 2026-07-31 15:00:00 | AAPL | Stock | 302.83 | 305.71 | 302.78 | 305.65 | 5993140.0 |
| 2026-07-31 15:30:00 | AAPL | Stock | 305.65 | 310.69 | 305.02 | 309.03 | 18622871.0 |
| 2026-07-31 16:00:00 | AAPL | Stock | 309.22 | 310.19 | 308.28 | 308.66 | 14947179.0 |
| 2026-07-31 16:30:00 | AAPL | Stock | 308.6598 | 308.91 | 306.69 | 306.69 | 230467.0 |
| 2026-07-31 17:00:00 | AAPL | Stock | 306.91 | 307.2 | 306.26 | 306.41 | 151954.0 |
| 2026-07-31 17:30:00 | AAPL | Stock | 306.41 | 306.6 | 306.3028 | 306.5 | 78746.0 |
| 2026-07-31 18:00:00 | AAPL | Stock | 306.51 | 307.1427 | 306.51 | 306.8942 | 36555.0 |
| 2026-07-31 18:30:00 | AAPL | Stock | 306.91 | 307.35 | 306.91 | 307.29 | 48101.0 |
| 2026-07-31 19:00:00 | AAPL | Stock | 307.27 | 307.8 | 307.2 | 307.73 | 29127.0 |
| 2026-07-31 19:30:00 | AAPL | Stock | 307.72 | 307.8 | 307.1801 | 307.3554 | 43137.0 |
| 2026-07-31 04:00:00 | MSFT | Stock | 447.8 | 449.63 | 445.0 | 448.94 | 107126.0 |
| 2026-07-31 04:30:00 | MSFT | Stock | 448.19 | 448.72 | 447.31 | 448.01 | 15269.0 |
| 2026-07-31 05:00:00 | MSFT | Stock | 447.86 | 448.8 | 447.0 | 448.8 | 20171.0 |
| 2026-07-31 05:30:00 | MSFT | Stock | 448.08 | 448.85 | 447.627 | 448.79 | 18035.0 |
| 2026-07-31 06:00:00 | MSFT | Stock | 448.82 | 448.94 | 447.66 | 448.21 | 15249.0 |
| 2026-07-31 06:30:00 | MSFT | Stock | 448.1 | 448.5 | 447.66 | 448.1318 | 17207.0 |
| 2026-07-31 07:00:00 | MSFT | Stock | 448.06 | 449.8818 | 447.71 | 448.87 | 78976.0 |
| 2026-07-31 07:30:00 | MSFT | Stock | 448.64 | 451.0 | 448.43 | 449.55 | 88461.0 |
| 2026-07-31 08:00:00 | MSFT | Stock | 449.43 | 451.88 | 448.48 | 451.54 | 86020.0 |
| 2026-07-31 08:30:00 | MSFT | Stock | 451.54 | 451.92 | 450.0 | 451.4824 | 59800.0 |
| 2026-07-31 09:00:00 | MSFT | Stock | 451.46 | 452.5 | 448.89 | 450.0 | 153366.0 |
| 2026-07-31 09:30:00 | MSFT | Stock | 449.97 | 462.86 | 449.33 | 462.57 | 7343705.0 |
| 2026-07-31 10:00:00 | MSFT | Stock | 462.57 | 462.95 | 452.81 | 453.315 | 4122117.0 |
| 2026-07-31 10:30:00 | MSFT | Stock | 453.38 | 456.21 | 451.72 | 452.455 | 2502275.0 |
| 2026-07-31 11:00:00 | MSFT | Stock | 452.53 | 458.98 | 450.69 | 457.825 | 2701955.0 |
| 2026-07-31 11:30:00 | MSFT | Stock | 457.825 | 463.57 | 456.54 | 463.1 | 2910001.0 |
| 2026-07-31 12:00:00 | MSFT | Stock | 463.07 | 464.8 | 461.03 | 463.655 | 2398872.0 |
| 2026-07-31 12:30:00 | MSFT | Stock | 463.61 | 464.38 | 461.6 | 461.9201 | 1562148.0 |
> showing 50 of 100,997 rows — these rows as CSV