PREVIEW / etf_30min / 2025-11-21
file: by_date/etf_30min/2025/2025-11-21.parquet size: 1.1 MB rows: 46,436
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 |
|---|---|---|---|---|---|---|---|
| 2025-11-21 04:00:00 | SPY | ETF | 654.64 | 655.25 | 653.21 | 653.69 | 82249.0 |
| 2025-11-21 04:30:00 | SPY | ETF | 653.57 | 653.93 | 652.09 | 652.16 | 75578.0 |
| 2025-11-21 05:00:00 | SPY | ETF | 652.08 | 652.21 | 649.45 | 649.5 | 134500.0 |
| 2025-11-21 05:30:00 | SPY | ETF | 649.96 | 653.0 | 649.96 | 652.97 | 103919.0 |
| 2025-11-21 06:00:00 | SPY | ETF | 653.0 | 654.09 | 652.69 | 652.69 | 150455.0 |
| 2025-11-21 06:30:00 | SPY | ETF | 652.77 | 653.13 | 651.35 | 652.1 | 103467.0 |
| 2025-11-21 07:00:00 | SPY | ETF | 652.2 | 652.5 | 650.02 | 650.27 | 264897.0 |
| 2025-11-21 07:30:00 | SPY | ETF | 650.22 | 656.54 | 650.22 | 655.44 | 944614.0 |
| 2025-11-21 08:00:00 | SPY | ETF | 652.17 | 656.75 | 649.47 | 654.96 | 863003.0 |
| 2025-11-21 08:30:00 | SPY | ETF | 655.07 | 656.59 | 655.03 | 655.97 | 336600.0 |
| 2025-11-21 09:00:00 | SPY | ETF | 655.86 | 656.25 | 654.84 | 655.01 | 471980.0 |
| 2025-11-21 09:30:00 | SPY | ETF | 655.03 | 656.47 | 653.13 | 654.52 | 11075187.0 |
| 2025-11-21 10:00:00 | SPY | ETF | 654.57 | 655.94 | 652.34 | 653.08 | 8532264.0 |
| 2025-11-21 10:30:00 | SPY | ETF | 653.09 | 654.39 | 650.85 | 652.77 | 7366897.0 |
| 2025-11-21 11:00:00 | SPY | ETF | 652.72 | 655.97 | 651.08 | 655.93 | 4826610.0 |
| 2025-11-21 11:30:00 | SPY | ETF | 655.92 | 660.695 | 655.22 | 660.64 | 6683525.0 |
| 2025-11-21 12:00:00 | SPY | ETF | 660.63 | 661.19 | 659.36 | 660.38 | 6089207.0 |
| 2025-11-21 12:30:00 | SPY | ETF | 660.3825 | 661.5118 | 659.71 | 660.16 | 3667217.0 |
| 2025-11-21 13:00:00 | SPY | ETF | 660.21 | 660.46 | 656.88 | 658.36 | 4655181.0 |
| 2025-11-21 13:30:00 | SPY | ETF | 658.35 | 664.09 | 658.0 | 662.25 | 6026973.0 |
| 2025-11-21 14:00:00 | SPY | ETF | 662.2352 | 664.55 | 662.11 | 664.23 | 4640495.0 |
| 2025-11-21 14:30:00 | SPY | ETF | 664.21 | 664.52 | 660.95 | 661.75 | 4760421.0 |
| 2025-11-21 15:00:00 | SPY | ETF | 661.73 | 662.2 | 659.62 | 659.63 | 4770626.0 |
| 2025-11-21 15:30:00 | SPY | ETF | 659.6 | 661.25 | 658.23 | 659.06 | 12217587.0 |
| 2025-11-21 16:00:00 | SPY | ETF | 659.08 | 659.98 | 658.86 | 659.17 | 3710896.0 |
| 2025-11-21 16:30:00 | SPY | ETF | 659.18 | 660.04 | 659.03 | 659.77 | 156833.0 |
| 2025-11-21 17:00:00 | SPY | ETF | 659.81 | 660.03 | 659.03 | 659.03 | 135999.0 |
| 2025-11-21 17:30:00 | SPY | ETF | 660.0 | 660.01 | 659.03 | 659.6 | 293923.0 |
| 2025-11-21 18:00:00 | SPY | ETF | 659.55 | 659.8 | 659.42 | 659.74 | 39358.0 |
| 2025-11-21 18:30:00 | SPY | ETF | 659.69 | 659.8392 | 659.27 | 659.37 | 33074.0 |
| 2025-11-21 19:00:00 | SPY | ETF | 659.57 | 659.8494 | 659.41 | 659.74 | 15888.0 |
| 2025-11-21 19:30:00 | SPY | ETF | 659.75 | 660.1752 | 659.72 | 660.1375 | 19922.0 |
| 2025-11-21 04:00:00 | QQQ | ETF | 587.0 | 587.83 | 585.2 | 585.78 | 179044.0 |
| 2025-11-21 04:30:00 | QQQ | ETF | 585.71 | 586.05 | 583.29 | 583.4 | 199564.0 |
| 2025-11-21 05:00:00 | QQQ | ETF | 583.45 | 583.45 | 580.27 | 580.37 | 305912.0 |
| 2025-11-21 05:30:00 | QQQ | ETF | 580.69 | 584.85 | 580.69 | 584.75 | 286727.0 |
| 2025-11-21 06:00:00 | QQQ | ETF | 584.8 | 586.25 | 584.46 | 584.57 | 394955.0 |
| 2025-11-21 06:30:00 | QQQ | ETF | 584.6 | 585.1 | 582.8 | 583.83 | 325388.0 |
| 2025-11-21 07:00:00 | QQQ | ETF | 583.93 | 584.36 | 581.38 | 581.71 | 468071.0 |
| 2025-11-21 07:30:00 | QQQ | ETF | 581.77 | 588.88 | 581.77 | 587.14 | 1513573.0 |
| 2025-11-21 08:00:00 | QQQ | ETF | 583.43 | 589.63 | 580.36 | 587.33 | 1334960.0 |
| 2025-11-21 08:30:00 | QQQ | ETF | 587.36 | 589.31 | 586.66 | 588.45 | 548597.0 |
| 2025-11-21 09:00:00 | QQQ | ETF | 588.38 | 589.01 | 586.951 | 587.5 | 500305.0 |
| 2025-11-21 09:30:00 | QQQ | ETF | 587.47 | 589.77 | 585.02 | 586.892 | 9678709.0 |
| 2025-11-21 10:00:00 | QQQ | ETF | 586.91 | 588.1 | 583.17 | 583.6 | 9124427.0 |
| 2025-11-21 10:30:00 | QQQ | ETF | 583.61 | 585.1 | 580.74 | 583.04 | 7655851.0 |
| 2025-11-21 11:00:00 | QQQ | ETF | 583.02 | 586.845 | 580.95 | 586.78 | 4478478.0 |
| 2025-11-21 11:30:00 | QQQ | ETF | 586.77 | 591.6156 | 585.94 | 591.59 | 5698433.0 |
| 2025-11-21 12:00:00 | QQQ | ETF | 591.59 | 592.055 | 589.96 | 591.24 | 4052746.0 |
| 2025-11-21 12:30:00 | QQQ | ETF | 591.23 | 592.61 | 590.6 | 591.01 | 3217254.0 |
> showing 50 of 46,436 rows — these rows as CSV