PREVIEW / etf_30min / 2025-09-26
file: by_date/etf_30min/2025/2025-09-26.parquet size: 1.0 MB rows: 42,165
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-26 04:00:00 | SPY | ETF | 657.36 | 659.4 | 657.36 | 659.03 | 23478.0 |
| 2025-09-26 04:30:00 | SPY | ETF | 659.12 | 659.12 | 658.24 | 658.3 | 9212.0 |
| 2025-09-26 05:00:00 | SPY | ETF | 658.14 | 658.65 | 657.85 | 658.19 | 7362.0 |
| 2025-09-26 05:30:00 | SPY | ETF | 658.16 | 658.67 | 658.14 | 658.66 | 5542.0 |
| 2025-09-26 06:00:00 | SPY | ETF | 658.29 | 658.34 | 658.12 | 658.12 | 5958.0 |
| 2025-09-26 06:30:00 | SPY | ETF | 658.1 | 658.15 | 657.93 | 658.15 | 3200.0 |
| 2025-09-26 07:00:00 | SPY | ETF | 658.16 | 658.6 | 657.9 | 658.08 | 17879.0 |
| 2025-09-26 07:30:00 | SPY | ETF | 658.2 | 659.0 | 658.03 | 658.71 | 48257.0 |
| 2025-09-26 08:00:00 | SPY | ETF | 658.67 | 659.5 | 657.6 | 659.19 | 132938.0 |
| 2025-09-26 08:30:00 | SPY | ETF | 659.1 | 661.1 | 659.07 | 660.24 | 570314.0 |
| 2025-09-26 09:00:00 | SPY | ETF | 660.28 | 660.31 | 659.41 | 659.51 | 184175.0 |
| 2025-09-26 09:30:00 | SPY | ETF | 659.51 | 661.9 | 658.92 | 661.79 | 8171981.0 |
| 2025-09-26 10:00:00 | SPY | ETF | 661.8 | 662.37 | 657.88 | 658.781 | 6329601.0 |
| 2025-09-26 10:30:00 | SPY | ETF | 658.79 | 659.96 | 658.12 | 658.45 | 3473135.0 |
| 2025-09-26 11:00:00 | SPY | ETF | 658.44 | 659.93 | 658.05 | 659.93 | 2414169.0 |
| 2025-09-26 11:30:00 | SPY | ETF | 659.915 | 660.06 | 658.635 | 658.67 | 2388040.0 |
| 2025-09-26 12:00:00 | SPY | ETF | 658.68 | 660.76 | 658.5 | 660.4534 | 2359852.0 |
| 2025-09-26 12:30:00 | SPY | ETF | 660.4499 | 661.495 | 660.07 | 661.33 | 2272056.0 |
| 2025-09-26 13:00:00 | SPY | ETF | 661.33 | 661.74 | 661.14 | 661.625 | 2024916.0 |
| 2025-09-26 13:30:00 | SPY | ETF | 661.63 | 661.755 | 660.76 | 661.35 | 2034089.0 |
| 2025-09-26 14:00:00 | SPY | ETF | 661.34 | 662.02 | 660.85 | 661.725 | 2570469.0 |
| 2025-09-26 14:30:00 | SPY | ETF | 661.74 | 662.14 | 661.47 | 661.92 | 2219627.0 |
| 2025-09-26 15:00:00 | SPY | ETF | 661.915 | 662.01 | 661.3 | 661.6 | 1884036.0 |
| 2025-09-26 15:30:00 | SPY | ETF | 661.602 | 661.95 | 661.15 | 661.75 | 6541020.0 |
| 2025-09-26 16:00:00 | SPY | ETF | 661.75 | 662.34 | 661.65 | 662.34 | 2586477.0 |
| 2025-09-26 16:30:00 | SPY | ETF | 662.35 | 662.37 | 661.77 | 661.85 | 415158.0 |
| 2025-09-26 17:00:00 | SPY | ETF | 661.85 | 661.98 | 661.84 | 661.98 | 20222.0 |
| 2025-09-26 17:30:00 | SPY | ETF | 661.9273 | 661.98 | 661.5 | 661.65 | 22081.0 |
| 2025-09-26 18:00:00 | SPY | ETF | 661.7 | 662.05 | 661.6657 | 662.02 | 11557.0 |
| 2025-09-26 18:30:00 | SPY | ETF | 662.06 | 662.1 | 661.95 | 661.99 | 5619.0 |
| 2025-09-26 19:00:00 | SPY | ETF | 662.02 | 662.15 | 662.02 | 662.1086 | 6879.0 |
| 2025-09-26 19:30:00 | SPY | ETF | 662.1114 | 662.1492 | 662.02 | 662.11 | 5817.0 |
| 2025-09-26 04:00:00 | QQQ | ETF | 593.72 | 594.34 | 593.2 | 593.89 | 23159.0 |
| 2025-09-26 04:30:00 | QQQ | ETF | 593.96 | 593.96 | 592.62 | 592.62 | 29390.0 |
| 2025-09-26 05:00:00 | QQQ | ETF | 592.62 | 593.29 | 592.26 | 592.75 | 32538.0 |
| 2025-09-26 05:30:00 | QQQ | ETF | 592.81 | 593.44 | 592.5 | 593.36 | 21419.0 |
| 2025-09-26 06:00:00 | QQQ | ETF | 593.42 | 593.64 | 592.71 | 592.83 | 128913.0 |
| 2025-09-26 06:30:00 | QQQ | ETF | 592.85 | 592.96 | 592.63 | 592.96 | 28606.0 |
| 2025-09-26 07:00:00 | QQQ | ETF | 592.94 | 593.65 | 592.78 | 593.19 | 34306.0 |
| 2025-09-26 07:30:00 | QQQ | ETF | 593.21 | 594.28 | 593.06 | 593.92 | 33199.0 |
| 2025-09-26 08:00:00 | QQQ | ETF | 593.93 | 594.63 | 592.38 | 594.2201 | 142618.0 |
| 2025-09-26 08:30:00 | QQQ | ETF | 594.21 | 596.57 | 594.14 | 595.3 | 434218.0 |
| 2025-09-26 09:00:00 | QQQ | ETF | 595.31 | 595.38 | 594.3 | 594.36 | 177061.0 |
| 2025-09-26 09:30:00 | QQQ | ETF | 594.35 | 595.765 | 592.96 | 595.525 | 6269704.0 |
| 2025-09-26 10:00:00 | QQQ | ETF | 595.55 | 596.2 | 591.06 | 592.23 | 5395814.0 |
| 2025-09-26 10:30:00 | QQQ | ETF | 592.25 | 594.01 | 591.54 | 592.18 | 3899461.0 |
| 2025-09-26 11:00:00 | QQQ | ETF | 592.18 | 593.8 | 591.72 | 593.77 | 2745596.0 |
| 2025-09-26 11:30:00 | QQQ | ETF | 593.77 | 593.87 | 592.44 | 592.565 | 2245633.0 |
| 2025-09-26 12:00:00 | QQQ | ETF | 592.585 | 594.945 | 592.27 | 594.48 | 2290210.0 |
| 2025-09-26 12:30:00 | QQQ | ETF | 594.48 | 595.39 | 594.02 | 595.175 | 1998228.0 |
> showing 50 of 42,165 rows — these rows as CSV