PREVIEW / etf_30min / 2025-09-25
file: by_date/etf_30min/2025/2025-09-25.parquet size: 1.0 MB rows: 44,336
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-09-25 04:00:00 | SPY | ETF | 661.25 | 661.6 | 661.22 | 661.58 | 4682.0 |
| 2025-09-25 04:30:00 | SPY | ETF | 661.46 | 661.46 | 660.72 | 660.82 | 4410.0 |
| 2025-09-25 05:00:00 | SPY | ETF | 660.94 | 661.1 | 660.72 | 661.02 | 7298.0 |
| 2025-09-25 05:30:00 | SPY | ETF | 660.94 | 661.05 | 660.4 | 660.55 | 10444.0 |
| 2025-09-25 06:00:00 | SPY | ETF | 660.6 | 660.84 | 660.2 | 660.22 | 52106.0 |
| 2025-09-25 06:30:00 | SPY | ETF | 660.25 | 660.68 | 659.96 | 660.27 | 21012.0 |
| 2025-09-25 07:00:00 | SPY | ETF | 660.2 | 660.2 | 659.09 | 659.26 | 63964.0 |
| 2025-09-25 07:30:00 | SPY | ETF | 659.2 | 659.3 | 658.24 | 658.44 | 104662.0 |
| 2025-09-25 08:00:00 | SPY | ETF | 660.09 | 662.38 | 658.27 | 658.73 | 248698.0 |
| 2025-09-25 08:30:00 | SPY | ETF | 658.5 | 658.8 | 657.32 | 657.78 | 463389.0 |
| 2025-09-25 09:00:00 | SPY | ETF | 657.8 | 658.21 | 657.34 | 657.99 | 278646.0 |
| 2025-09-25 09:30:00 | SPY | ETF | 657.98 | 657.98 | 655.08 | 655.64 | 10789771.0 |
| 2025-09-25 10:00:00 | SPY | ETF | 655.64 | 659.15 | 655.55 | 658.48 | 7136388.0 |
| 2025-09-25 10:30:00 | SPY | ETF | 658.48 | 659.1 | 658.24 | 658.79 | 3323481.0 |
| 2025-09-25 11:00:00 | SPY | ETF | 658.79 | 658.81 | 657.19 | 657.46 | 3953847.0 |
| 2025-09-25 11:30:00 | SPY | ETF | 657.46 | 659.4056 | 657.46 | 658.945 | 3593063.0 |
| 2025-09-25 12:00:00 | SPY | ETF | 658.945 | 659.235 | 657.9399 | 658.01 | 2413793.0 |
| 2025-09-25 12:30:00 | SPY | ETF | 658.03 | 658.98 | 657.59 | 657.84 | 2340118.0 |
| 2025-09-25 13:00:00 | SPY | ETF | 657.83 | 658.36 | 656.57 | 657.295 | 2950912.0 |
| 2025-09-25 13:30:00 | SPY | ETF | 657.28 | 657.465 | 655.51 | 655.59 | 3017253.0 |
| 2025-09-25 14:00:00 | SPY | ETF | 655.59 | 657.15 | 654.405 | 656.99 | 6571727.0 |
| 2025-09-25 14:30:00 | SPY | ETF | 656.98 | 658.155 | 656.66 | 657.89 | 4145866.0 |
| 2025-09-25 15:00:00 | SPY | ETF | 657.88 | 658.02 | 657.055 | 657.45 | 3123629.0 |
| 2025-09-25 15:30:00 | SPY | ETF | 657.45 | 658.26 | 657.04 | 657.95 | 6810080.0 |
| 2025-09-25 16:00:00 | SPY | ETF | 657.95 | 658.25 | 657.7 | 658.09 | 1943588.0 |
| 2025-09-25 16:30:00 | SPY | ETF | 658.08 | 658.53 | 657.99 | 658.08 | 150023.0 |
| 2025-09-25 17:00:00 | SPY | ETF | 658.07 | 658.07 | 657.86 | 658.02 | 99466.0 |
| 2025-09-25 17:30:00 | SPY | ETF | 658.0203 | 658.0766 | 657.87 | 658.0 | 40618.0 |
| 2025-09-25 18:00:00 | SPY | ETF | 658.0 | 658.69 | 657.94 | 658.46 | 57227.0 |
| 2025-09-25 18:30:00 | SPY | ETF | 658.33 | 658.66 | 657.95 | 658.1504 | 21070.0 |
| 2025-09-25 19:00:00 | SPY | ETF | 658.1599 | 658.1738 | 657.81 | 657.94 | 107213.0 |
| 2025-09-25 19:30:00 | SPY | ETF | 658.05 | 658.08 | 657.81 | 657.83 | 15826.0 |
| 2025-09-25 04:00:00 | QQQ | ETF | 596.14 | 596.7 | 596.14 | 596.55 | 15908.0 |
| 2025-09-25 04:30:00 | QQQ | ETF | 596.6 | 596.62 | 595.65 | 595.91 | 18387.0 |
| 2025-09-25 05:00:00 | QQQ | ETF | 595.88 | 596.04 | 595.51 | 595.87 | 44655.0 |
| 2025-09-25 05:30:00 | QQQ | ETF | 595.85 | 595.91 | 594.98 | 595.26 | 42265.0 |
| 2025-09-25 06:00:00 | QQQ | ETF | 595.32 | 595.47 | 594.75 | 594.83 | 30442.0 |
| 2025-09-25 06:30:00 | QQQ | ETF | 594.81 | 595.39 | 594.5 | 594.89 | 29107.0 |
| 2025-09-25 07:00:00 | QQQ | ETF | 594.93 | 594.98 | 593.4 | 593.67 | 70333.0 |
| 2025-09-25 07:30:00 | QQQ | ETF | 593.67 | 593.88 | 592.5 | 592.61 | 104868.0 |
| 2025-09-25 08:00:00 | QQQ | ETF | 594.55 | 597.29 | 592.49 | 593.1596 | 280630.0 |
| 2025-09-25 08:30:00 | QQQ | ETF | 593.0 | 593.0 | 591.46 | 592.0 | 533524.0 |
| 2025-09-25 09:00:00 | QQQ | ETF | 591.93 | 592.43 | 591.34 | 592.22 | 423977.0 |
| 2025-09-25 09:30:00 | QQQ | ETF | 592.2 | 592.23 | 588.5 | 589.23 | 9909110.0 |
| 2025-09-25 10:00:00 | QQQ | ETF | 589.23 | 593.79 | 589.07 | 593.25 | 5888483.0 |
| 2025-09-25 10:30:00 | QQQ | ETF | 593.25 | 594.139 | 593.0 | 593.6271 | 3534282.0 |
| 2025-09-25 11:00:00 | QQQ | ETF | 593.63 | 594.12 | 592.39 | 592.75 | 3417284.0 |
| 2025-09-25 11:30:00 | QQQ | ETF | 592.73 | 595.115 | 592.73 | 594.665 | 3153041.0 |
| 2025-09-25 12:00:00 | QQQ | ETF | 594.66 | 595.0 | 593.54 | 593.57 | 2466495.0 |
| 2025-09-25 12:30:00 | QQQ | ETF | 593.57 | 594.51 | 593.1 | 593.3844 | 1881619.0 |
> showing 50 of 44,336 rows — these rows as CSV