PREVIEW / etf_30min / 2026-04-07
file: by_date/etf_30min/2026/2026-04-07.parquet size: 1.1 MB rows: 49,391
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-04-07 04:00:00 | SPY | ETF | 656.45 | 659.11 | 655.41 | 658.4 | 93763.0 |
| 2026-04-07 04:30:00 | SPY | ETF | 658.29 | 659.5212 | 658.19 | 659.31 | 18194.0 |
| 2026-04-07 05:00:00 | SPY | ETF | 659.32 | 660.33 | 659.03 | 660.0 | 31527.0 |
| 2026-04-07 05:30:00 | SPY | ETF | 660.04 | 660.36 | 659.46 | 660.0 | 16607.0 |
| 2026-04-07 06:00:00 | SPY | ETF | 659.9 | 660.09 | 657.76 | 658.85 | 255261.0 |
| 2026-04-07 06:30:00 | SPY | ETF | 658.82 | 659.01 | 655.11 | 655.5 | 392825.0 |
| 2026-04-07 07:00:00 | SPY | ETF | 655.48 | 656.8 | 655.4 | 656.19 | 409928.0 |
| 2026-04-07 07:30:00 | SPY | ETF | 656.24 | 656.269 | 654.84 | 655.75 | 267793.0 |
| 2026-04-07 08:00:00 | SPY | ETF | 655.75 | 656.53 | 653.91 | 656.3204 | 924408.0 |
| 2026-04-07 08:30:00 | SPY | ETF | 656.31 | 657.68 | 655.31 | 656.12 | 219760.0 |
| 2026-04-07 09:00:00 | SPY | ETF | 656.12 | 656.82 | 655.77 | 656.55 | 392579.0 |
| 2026-04-07 09:30:00 | SPY | ETF | 656.57 | 657.58 | 654.16 | 654.56 | 3780911.0 |
| 2026-04-07 10:00:00 | SPY | ETF | 654.56 | 654.78 | 651.92 | 653.81 | 4940893.0 |
| 2026-04-07 10:30:00 | SPY | ETF | 653.8 | 655.34 | 652.88 | 652.95 | 3686251.0 |
| 2026-04-07 11:00:00 | SPY | ETF | 652.95 | 653.86 | 651.06 | 652.88 | 4988631.0 |
| 2026-04-07 11:30:00 | SPY | ETF | 652.92 | 654.4 | 652.57 | 653.6302 | 2010847.0 |
| 2026-04-07 12:00:00 | SPY | ETF | 653.64 | 657.0 | 653.56 | 655.995 | 3763511.0 |
| 2026-04-07 12:30:00 | SPY | ETF | 656.0 | 656.87 | 655.34 | 656.39 | 1465327.0 |
| 2026-04-07 13:00:00 | SPY | ETF | 656.4 | 656.88 | 655.48 | 655.6803 | 1391606.0 |
| 2026-04-07 13:30:00 | SPY | ETF | 655.68 | 658.4 | 655.57 | 656.78 | 2464119.0 |
| 2026-04-07 14:00:00 | SPY | ETF | 656.77 | 657.02 | 656.03 | 656.24 | 1472620.0 |
| 2026-04-07 14:30:00 | SPY | ETF | 656.24 | 656.34 | 653.4301 | 653.99 | 2825010.0 |
| 2026-04-07 15:00:00 | SPY | ETF | 653.96 | 658.17 | 653.4122 | 656.845 | 5541590.0 |
| 2026-04-07 15:30:00 | SPY | ETF | 656.83 | 659.2 | 655.89 | 658.54 | 8199159.0 |
| 2026-04-07 16:00:00 | SPY | ETF | 658.54 | 660.4 | 658.51 | 659.54 | 3946125.0 |
| 2026-04-07 16:30:00 | SPY | ETF | 659.56 | 660.99 | 659.35 | 660.05 | 703982.0 |
| 2026-04-07 17:00:00 | SPY | ETF | 660.05 | 660.54 | 659.92 | 660.0 | 381162.0 |
| 2026-04-07 17:30:00 | SPY | ETF | 660.04 | 661.09 | 660.04 | 660.9 | 233024.0 |
| 2026-04-07 18:00:00 | SPY | ETF | 660.88 | 666.95 | 660.85 | 664.7621 | 1066816.0 |
| 2026-04-07 18:30:00 | SPY | ETF | 664.82 | 672.14 | 656.0 | 671.72 | 2514632.0 |
| 2026-04-07 19:00:00 | SPY | ETF | 671.72 | 675.15 | 671.65 | 674.26 | 1287170.0 |
| 2026-04-07 19:30:00 | SPY | ETF | 674.2516 | 674.48 | 670.28 | 673.87 | 625286.0 |
| 2026-04-07 20:00:00 | SPY | ETF | 673.87 | 673.99 | 673.55 | 673.6406 | 9054.0 |
| 2026-04-07 04:00:00 | QQQ | ETF | 585.52 | 588.6 | 584.69 | 587.86 | 194553.0 |
| 2026-04-07 04:30:00 | QQQ | ETF | 587.83 | 589.0 | 587.74 | 588.51 | 51129.0 |
| 2026-04-07 05:00:00 | QQQ | ETF | 588.62 | 589.69 | 588.29 | 589.46 | 83634.0 |
| 2026-04-07 05:30:00 | QQQ | ETF | 589.44 | 589.9 | 588.74 | 589.23 | 40410.0 |
| 2026-04-07 06:00:00 | QQQ | ETF | 589.22 | 589.24 | 586.94 | 588.2 | 131180.0 |
| 2026-04-07 06:30:00 | QQQ | ETF | 588.26 | 588.36 | 584.21 | 584.6885 | 190372.0 |
| 2026-04-07 07:00:00 | QQQ | ETF | 584.64 | 585.95 | 584.45 | 585.3729 | 217736.0 |
| 2026-04-07 07:30:00 | QQQ | ETF | 585.44 | 585.47 | 584.0 | 584.93 | 174241.0 |
| 2026-04-07 08:00:00 | QQQ | ETF | 584.91 | 585.5 | 582.97 | 585.3 | 505864.0 |
| 2026-04-07 08:30:00 | QQQ | ETF | 585.31 | 586.46 | 584.1 | 584.97 | 264433.0 |
| 2026-04-07 09:00:00 | QQQ | ETF | 584.99 | 585.75 | 584.54 | 585.73 | 291885.0 |
| 2026-04-07 09:30:00 | QQQ | ETF | 585.67 | 587.06 | 583.119 | 583.32 | 3876113.0 |
| 2026-04-07 10:00:00 | QQQ | ETF | 583.32 | 583.41 | 579.69 | 581.72 | 4463298.0 |
| 2026-04-07 10:30:00 | QQQ | ETF | 581.74 | 583.24 | 580.37 | 580.44 | 2543223.0 |
| 2026-04-07 11:00:00 | QQQ | ETF | 580.44 | 581.88 | 578.4001 | 580.98 | 3143868.0 |
| 2026-04-07 11:30:00 | QQQ | ETF | 580.98 | 582.98 | 580.83 | 582.22 | 1650313.0 |
| 2026-04-07 12:00:00 | QQQ | ETF | 582.21 | 585.54 | 582.18 | 584.42 | 2731225.0 |
> showing 50 of 49,391 rows — these rows as CSV