PREVIEW / etf_30min / 2026-04-01
file: by_date/etf_30min/2026/2026-04-01.parquet size: 1016 KB rows: 42,813
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-01 04:00:00 | SPY | ETF | 654.0 | 655.51 | 651.3 | 653.45 | 190881.0 |
| 2026-04-01 04:30:00 | SPY | ETF | 653.51 | 654.07 | 652.33 | 653.36 | 138713.0 |
| 2026-04-01 05:00:00 | SPY | ETF | 653.43 | 653.74 | 651.97 | 652.42 | 77091.0 |
| 2026-04-01 05:30:00 | SPY | ETF | 652.67 | 654.01 | 652.58 | 653.57 | 52287.0 |
| 2026-04-01 06:00:00 | SPY | ETF | 653.52 | 653.96 | 653.18 | 653.53 | 55887.0 |
| 2026-04-01 06:30:00 | SPY | ETF | 653.7 | 655.09 | 653.39 | 655.02 | 104495.0 |
| 2026-04-01 07:00:00 | SPY | ETF | 654.84 | 655.62 | 650.34 | 655.32 | 234096.0 |
| 2026-04-01 07:30:00 | SPY | ETF | 655.36 | 656.26 | 655.25 | 656.04 | 264877.0 |
| 2026-04-01 08:00:00 | SPY | ETF | 655.99 | 656.05 | 654.21 | 654.8 | 312516.0 |
| 2026-04-01 08:30:00 | SPY | ETF | 654.77 | 657.5 | 650.34 | 652.8395 | 2114070.0 |
| 2026-04-01 09:00:00 | SPY | ETF | 652.88 | 653.88 | 652.29 | 653.83 | 1142737.0 |
| 2026-04-01 09:30:00 | SPY | ETF | 653.88 | 656.05 | 653.0 | 654.29 | 12067727.0 |
| 2026-04-01 10:00:00 | SPY | ETF | 654.3 | 655.47 | 653.89 | 655.03 | 6024266.0 |
| 2026-04-01 10:30:00 | SPY | ETF | 655.03 | 656.85 | 653.58 | 656.5 | 6252419.0 |
| 2026-04-01 11:00:00 | SPY | ETF | 656.5 | 657.07 | 656.31 | 656.33 | 4153643.0 |
| 2026-04-01 11:30:00 | SPY | ETF | 656.33 | 658.095 | 655.93 | 657.82 | 4055496.0 |
| 2026-04-01 12:00:00 | SPY | ETF | 657.815 | 658.0896 | 657.12 | 657.175 | 3422240.0 |
| 2026-04-01 12:30:00 | SPY | ETF | 657.185 | 657.97 | 656.84 | 657.81 | 2758298.0 |
| 2026-04-01 13:00:00 | SPY | ETF | 657.82 | 658.52 | 657.7 | 658.3 | 2585229.0 |
| 2026-04-01 13:30:00 | SPY | ETF | 658.31 | 658.44 | 656.77 | 656.79 | 3352443.0 |
| 2026-04-01 14:00:00 | SPY | ETF | 656.79 | 656.94 | 653.83 | 654.23 | 6863470.0 |
| 2026-04-01 14:30:00 | SPY | ETF | 654.225 | 655.5 | 653.667 | 654.41 | 5454006.0 |
| 2026-04-01 15:00:00 | SPY | ETF | 654.39 | 656.3401 | 654.255 | 656.1 | 4976600.0 |
| 2026-04-01 15:30:00 | SPY | ETF | 656.1 | 656.75 | 654.72 | 655.17 | 10560643.0 |
| 2026-04-01 16:00:00 | SPY | ETF | 655.17 | 655.72 | 654.88 | 655.0 | 3479723.0 |
| 2026-04-01 16:30:00 | SPY | ETF | 655.01 | 655.39 | 655.0 | 655.01 | 160569.0 |
| 2026-04-01 17:00:00 | SPY | ETF | 655.05 | 655.4 | 655.0194 | 655.25 | 43313.0 |
| 2026-04-01 17:30:00 | SPY | ETF | 655.21 | 655.32 | 654.9 | 655.0 | 62466.0 |
| 2026-04-01 18:00:00 | SPY | ETF | 655.0 | 655.46 | 654.67 | 655.0 | 63952.0 |
| 2026-04-01 18:30:00 | SPY | ETF | 655.0 | 655.12 | 654.32 | 654.5848 | 32908.0 |
| 2026-04-01 19:00:00 | SPY | ETF | 654.6 | 655.17 | 654.46 | 655.1426 | 10499.0 |
| 2026-04-01 19:30:00 | SPY | ETF | 655.06 | 655.0896 | 654.32 | 654.75 | 27740.0 |
| 2026-04-01 04:00:00 | QQQ | ETF | 580.77 | 583.7 | 578.86 | 581.31 | 377377.0 |
| 2026-04-01 04:30:00 | QQQ | ETF | 581.32 | 581.78 | 580.0 | 581.07 | 165305.0 |
| 2026-04-01 05:00:00 | QQQ | ETF | 581.06 | 581.35 | 579.49 | 580.0 | 97288.0 |
| 2026-04-01 05:30:00 | QQQ | ETF | 580.14 | 581.52 | 580.11 | 580.99 | 103745.0 |
| 2026-04-01 06:00:00 | QQQ | ETF | 581.03 | 581.45 | 580.59 | 580.99 | 84891.0 |
| 2026-04-01 06:30:00 | QQQ | ETF | 581.23 | 582.71 | 580.9 | 582.43 | 120291.0 |
| 2026-04-01 07:00:00 | QQQ | ETF | 582.41 | 583.32 | 582.326 | 583.0 | 219430.0 |
| 2026-04-01 07:30:00 | QQQ | ETF | 583.02 | 584.3 | 582.92 | 583.9737 | 303680.0 |
| 2026-04-01 08:00:00 | QQQ | ETF | 583.95 | 584.06 | 576.748 | 582.78 | 335699.0 |
| 2026-04-01 08:30:00 | QQQ | ETF | 582.84 | 585.19 | 580.56 | 580.84 | 937112.0 |
| 2026-04-01 09:00:00 | QQQ | ETF | 580.86 | 581.98 | 580.26 | 581.54 | 470697.0 |
| 2026-04-01 09:30:00 | QQQ | ETF | 581.49 | 584.026 | 580.42 | 582.1798 | 7723885.0 |
| 2026-04-01 10:00:00 | QQQ | ETF | 582.18 | 584.36 | 581.95 | 583.83 | 4812545.0 |
| 2026-04-01 10:30:00 | QQQ | ETF | 583.84 | 585.8 | 582.52 | 585.57 | 5694643.0 |
| 2026-04-01 11:00:00 | QQQ | ETF | 585.57 | 586.22 | 585.295 | 585.31 | 4186970.0 |
| 2026-04-01 11:30:00 | QQQ | ETF | 585.32 | 587.18 | 584.85 | 586.875 | 3905100.0 |
| 2026-04-01 12:00:00 | QQQ | ETF | 586.88 | 587.26 | 586.44 | 586.665 | 2925777.0 |
| 2026-04-01 12:30:00 | QQQ | ETF | 586.68 | 587.31 | 586.27 | 587.0374 | 2033562.0 |
> showing 50 of 42,813 rows — these rows as CSV