PREVIEW / etf_30min / 2026-07-30
file: by_date/etf_30min/2026/2026-07-30.parquet size: 1.1 MB rows: 48,194
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-30 04:00:00 | SPY | ETF | 730.72 | 732.7952 | 729.88 | 732.25 | 113772.0 |
| 2026-07-30 04:30:00 | SPY | ETF | 732.29 | 732.45 | 731.54 | 731.88 | 22250.0 |
| 2026-07-30 05:00:00 | SPY | ETF | 731.86 | 733.11 | 731.8 | 732.91 | 33082.0 |
| 2026-07-30 05:30:00 | SPY | ETF | 732.9 | 733.38 | 732.03 | 732.03 | 21852.0 |
| 2026-07-30 06:00:00 | SPY | ETF | 732.0 | 733.4 | 731.82 | 733.25 | 31642.0 |
| 2026-07-30 06:30:00 | SPY | ETF | 733.23 | 733.8 | 733.07 | 733.11 | 45864.0 |
| 2026-07-30 07:00:00 | SPY | ETF | 733.07 | 734.31 | 733.07 | 734.3 | 119698.0 |
| 2026-07-30 07:30:00 | SPY | ETF | 734.291 | 734.71 | 733.99 | 734.54 | 229871.0 |
| 2026-07-30 08:00:00 | SPY | ETF | 734.52 | 735.05 | 734.13 | 734.695 | 196020.0 |
| 2026-07-30 08:30:00 | SPY | ETF | 734.93 | 735.13 | 733.93 | 734.38 | 262838.0 |
| 2026-07-30 09:00:00 | SPY | ETF | 734.41 | 736.07 | 734.35 | 736.05 | 315400.0 |
| 2026-07-30 09:30:00 | SPY | ETF | 736.05 | 738.66 | 734.63 | 738.625 | 6790062.0 |
| 2026-07-30 10:00:00 | SPY | ETF | 738.62 | 739.3 | 737.38 | 738.64 | 3946241.0 |
| 2026-07-30 10:30:00 | SPY | ETF | 738.66 | 739.11 | 735.6099 | 736.23 | 3250593.0 |
| 2026-07-30 11:00:00 | SPY | ETF | 736.23 | 736.82 | 734.59 | 734.8 | 2945722.0 |
| 2026-07-30 11:30:00 | SPY | ETF | 734.84 | 737.67 | 734.68 | 737.13 | 2065375.0 |
| 2026-07-30 12:00:00 | SPY | ETF | 737.15 | 739.22 | 736.87 | 738.76 | 1771569.0 |
| 2026-07-30 12:30:00 | SPY | ETF | 738.77 | 739.17 | 737.755 | 738.985 | 1555272.0 |
| 2026-07-30 13:00:00 | SPY | ETF | 738.98 | 740.24 | 738.9799 | 739.76 | 1593195.0 |
| 2026-07-30 13:30:00 | SPY | ETF | 739.765 | 740.38 | 739.19 | 739.78 | 1496924.0 |
| 2026-07-30 14:00:00 | SPY | ETF | 739.785 | 740.44 | 739.705 | 740.38 | 1514599.0 |
| 2026-07-30 14:30:00 | SPY | ETF | 740.4 | 740.83 | 740.03 | 740.77 | 1950706.0 |
| 2026-07-30 15:00:00 | SPY | ETF | 740.75 | 742.45 | 740.74 | 741.78 | 2797588.0 |
| 2026-07-30 15:30:00 | SPY | ETF | 741.77 | 742.1 | 741.0 | 741.71 | 9038322.0 |
| 2026-07-30 16:00:00 | SPY | ETF | 741.71 | 743.7 | 741.33 | 743.58 | 2585666.0 |
| 2026-07-30 16:30:00 | SPY | ETF | 743.57 | 744.2 | 741.8 | 742.04 | 335448.0 |
| 2026-07-30 17:00:00 | SPY | ETF | 742.0 | 742.4 | 741.51 | 741.63 | 89091.0 |
| 2026-07-30 17:30:00 | SPY | ETF | 741.63 | 742.35 | 741.44 | 742.1878 | 167451.0 |
| 2026-07-30 18:00:00 | SPY | ETF | 742.04 | 742.5531 | 741.31 | 742.02 | 68580.0 |
| 2026-07-30 18:30:00 | SPY | ETF | 742.01 | 743.02 | 741.81 | 742.98 | 23555.0 |
| 2026-07-30 19:00:00 | SPY | ETF | 743.0 | 743.44 | 742.59 | 742.84 | 16632.0 |
| 2026-07-30 19:30:00 | SPY | ETF | 742.75 | 743.69 | 742.712 | 743.33 | 24592.0 |
| 2026-07-30 04:00:00 | QQQ | ETF | 664.95 | 666.66 | 661.78 | 665.9 | 286888.0 |
| 2026-07-30 04:30:00 | QQQ | ETF | 665.81 | 666.23 | 664.75 | 665.27 | 37068.0 |
| 2026-07-30 05:00:00 | QQQ | ETF | 665.37 | 667.47 | 665.02 | 666.93 | 70221.0 |
| 2026-07-30 05:30:00 | QQQ | ETF | 666.95 | 667.72 | 665.93 | 666.07 | 59728.0 |
| 2026-07-30 06:00:00 | QQQ | ETF | 665.9 | 668.72 | 665.46 | 668.41 | 104344.0 |
| 2026-07-30 06:30:00 | QQQ | ETF | 668.46 | 669.25 | 668.34 | 668.5599 | 98494.0 |
| 2026-07-30 07:00:00 | QQQ | ETF | 668.48 | 671.11 | 668.42 | 670.82 | 328178.0 |
| 2026-07-30 07:30:00 | QQQ | ETF | 670.9 | 671.6 | 669.92 | 671.15 | 279973.0 |
| 2026-07-30 08:00:00 | QQQ | ETF | 671.11 | 672.1 | 670.37 | 671.55 | 335673.0 |
| 2026-07-30 08:30:00 | QQQ | ETF | 671.38 | 673.4 | 670.91 | 673.08 | 293571.0 |
| 2026-07-30 09:00:00 | QQQ | ETF | 673.18 | 674.87 | 672.76 | 674.87 | 540002.0 |
| 2026-07-30 09:30:00 | QQQ | ETF | 674.75 | 681.65 | 673.3 | 681.515 | 6791253.0 |
| 2026-07-30 10:00:00 | QQQ | ETF | 681.49 | 683.64 | 679.4105 | 683.3 | 3686346.0 |
| 2026-07-30 10:30:00 | QQQ | ETF | 683.26 | 683.73 | 678.36 | 679.53 | 2842704.0 |
| 2026-07-30 11:00:00 | QQQ | ETF | 679.56 | 681.16 | 677.75 | 678.13 | 2672545.0 |
| 2026-07-30 11:30:00 | QQQ | ETF | 678.16 | 681.11 | 677.9 | 679.79 | 2048523.0 |
| 2026-07-30 12:00:00 | QQQ | ETF | 679.77 | 682.55 | 679.32 | 681.35 | 2260155.0 |
| 2026-07-30 12:30:00 | QQQ | ETF | 681.355 | 681.49 | 679.25 | 680.96 | 1838902.0 |
> showing 50 of 48,194 rows — these rows as CSV