PREVIEW / etf_1hour / 2026-06-02
file: by_date/etf_1hour/2026/2026-06-02.parquet size: 737 KB rows: 29,069
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-06-02 04:00:00 | SPY | ETF | 756.72 | 758.23 | 755.35 | 757.71 | 63263.0 |
| 2026-06-02 05:00:00 | SPY | ETF | 757.7 | 757.75 | 757.05 | 757.42 | 24271.0 |
| 2026-06-02 06:00:00 | SPY | ETF | 757.31 | 757.49 | 757.04 | 757.04 | 41416.0 |
| 2026-06-02 07:00:00 | SPY | ETF | 757.11 | 757.49 | 756.8 | 756.8 | 80734.0 |
| 2026-06-02 08:00:00 | SPY | ETF | 756.83 | 757.46 | 756.7 | 756.85 | 114403.0 |
| 2026-06-02 09:00:00 | SPY | ETF | 756.9 | 757.77 | 755.41 | 757.62 | 2784367.0 |
| 2026-06-02 10:00:00 | SPY | ETF | 757.63 | 759.73 | 757.23 | 759.72 | 4166267.0 |
| 2026-06-02 11:00:00 | SPY | ETF | 759.71 | 760.4 | 759.375 | 759.69 | 3014201.0 |
| 2026-06-02 12:00:00 | SPY | ETF | 759.7 | 760.01 | 759.1 | 759.865 | 1732709.0 |
| 2026-06-02 13:00:00 | SPY | ETF | 759.865 | 759.97 | 758.78 | 758.875 | 1939532.0 |
| 2026-06-02 14:00:00 | SPY | ETF | 758.88 | 759.35 | 758.625 | 759.04 | 2159082.0 |
| 2026-06-02 15:00:00 | SPY | ETF | 759.06 | 759.69 | 759.055 | 759.45 | 6684173.0 |
| 2026-06-02 16:00:00 | SPY | ETF | 759.47 | 760.14 | 759.32 | 760.02 | 2286813.0 |
| 2026-06-02 17:00:00 | SPY | ETF | 759.91 | 759.9934 | 759.7 | 759.94 | 150557.0 |
| 2026-06-02 18:00:00 | SPY | ETF | 759.95 | 759.95 | 759.25 | 759.27 | 47921.0 |
| 2026-06-02 19:00:00 | SPY | ETF | 759.34 | 759.75 | 757.39 | 759.63 | 124008.0 |
| 2026-06-02 04:00:00 | QQQ | ETF | 740.02 | 742.74 | 737.71 | 742.28 | 246855.0 |
| 2026-06-02 05:00:00 | QQQ | ETF | 742.22 | 743.16 | 741.76 | 742.73 | 80518.0 |
| 2026-06-02 06:00:00 | QQQ | ETF | 742.57 | 742.75 | 741.75 | 741.8 | 67204.0 |
| 2026-06-02 07:00:00 | QQQ | ETF | 741.79 | 742.91 | 741.1665 | 741.8 | 264280.0 |
| 2026-06-02 08:00:00 | QQQ | ETF | 741.92 | 742.55 | 741.63 | 741.75 | 165096.0 |
| 2026-06-02 09:00:00 | QQQ | ETF | 741.84 | 743.6 | 739.23 | 743.52 | 3675429.0 |
| 2026-06-02 10:00:00 | QQQ | ETF | 743.54 | 744.66 | 741.99 | 744.54 | 4265864.0 |
| 2026-06-02 11:00:00 | QQQ | ETF | 744.55 | 745.89 | 743.79 | 745.71 | 2928107.0 |
| 2026-06-02 12:00:00 | QQQ | ETF | 745.69 | 746.23 | 744.52 | 745.7563 | 1980917.0 |
| 2026-06-02 13:00:00 | QQQ | ETF | 745.73 | 746.02 | 743.735 | 744.2 | 2019917.0 |
| 2026-06-02 14:00:00 | QQQ | ETF | 744.2 | 745.08 | 743.5 | 744.4692 | 1402077.0 |
| 2026-06-02 15:00:00 | QQQ | ETF | 744.479 | 746.44 | 744.45 | 746.1 | 3768700.0 |
| 2026-06-02 16:00:00 | QQQ | ETF | 746.1 | 747.44 | 745.89 | 747.07 | 1352865.0 |
| 2026-06-02 17:00:00 | QQQ | ETF | 747.1 | 747.1 | 746.71 | 746.84 | 72988.0 |
| 2026-06-02 18:00:00 | QQQ | ETF | 746.83 | 747.24 | 745.89 | 745.9506 | 143111.0 |
| 2026-06-02 19:00:00 | QQQ | ETF | 746.0 | 746.16 | 742.87 | 746.06 | 309447.0 |
| 2026-06-02 04:00:00 | IWM | ETF | 289.14 | 289.25 | 287.65 | 289.12 | 96740.0 |
| 2026-06-02 05:00:00 | IWM | ETF | 289.01 | 289.01 | 288.5 | 288.82 | 27438.0 |
| 2026-06-02 06:00:00 | IWM | ETF | 288.64 | 288.82 | 288.53 | 288.65 | 15807.0 |
| 2026-06-02 07:00:00 | IWM | ETF | 288.62 | 288.92 | 288.52 | 288.733 | 26943.0 |
| 2026-06-02 08:00:00 | IWM | ETF | 288.74 | 289.5 | 288.74 | 289.02 | 46424.0 |
| 2026-06-02 09:00:00 | IWM | ETF | 289.13 | 291.27 | 288.4 | 290.11 | 2959615.0 |
| 2026-06-02 10:00:00 | IWM | ETF | 290.11 | 291.8 | 289.535 | 291.5 | 2720408.0 |
| 2026-06-02 11:00:00 | IWM | ETF | 291.5 | 291.865 | 290.84 | 291.045 | 1628106.0 |
| 2026-06-02 12:00:00 | IWM | ETF | 291.045 | 291.45 | 290.31 | 290.74 | 967360.0 |
| 2026-06-02 13:00:00 | IWM | ETF | 290.74 | 290.96 | 290.47 | 290.865 | 778502.0 |
| 2026-06-02 14:00:00 | IWM | ETF | 290.87 | 291.48 | 290.82 | 291.4 | 983363.0 |
| 2026-06-02 15:00:00 | IWM | ETF | 291.395 | 291.7 | 291.3 | 291.64 | 2216166.0 |
| 2026-06-02 16:00:00 | IWM | ETF | 291.66 | 291.81 | 291.36 | 291.58 | 907662.0 |
| 2026-06-02 17:00:00 | IWM | ETF | 291.52 | 291.63 | 291.26 | 291.48 | 62172.0 |
| 2026-06-02 18:00:00 | IWM | ETF | 291.55 | 291.73 | 291.02 | 291.06 | 55488.0 |
| 2026-06-02 19:00:00 | IWM | ETF | 291.07 | 291.11 | 289.78 | 290.92 | 89296.0 |
| 2026-06-02 04:00:00 | DIA | ETF | 510.92 | 510.92 | 509.39 | 510.19 | 4259.0 |
| 2026-06-02 05:00:00 | DIA | ETF | 510.06 | 510.06 | 509.3 | 509.47 | 2245.0 |
> showing 50 of 29,069 rows — these rows as CSV