PREVIEW / etf_1hour / 2025-10-29
file: by_date/etf_1hour/2025/2025-10-29.parquet size: 734 KB rows: 28,441
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-10-29 04:00:00 | SPY | ETF | 688.98 | 689.45 | 688.16 | 688.25 | 28340.0 |
| 2025-10-29 05:00:00 | SPY | ETF | 688.25 | 688.3 | 687.76 | 688.14 | 53805.0 |
| 2025-10-29 06:00:00 | SPY | ETF | 688.11 | 689.0 | 688.0 | 688.44 | 39776.0 |
| 2025-10-29 07:00:00 | SPY | ETF | 688.41 | 689.41 | 688.3 | 688.83 | 176399.0 |
| 2025-10-29 08:00:00 | SPY | ETF | 688.83 | 689.43 | 687.8 | 688.72 | 201086.0 |
| 2025-10-29 09:00:00 | SPY | ETF | 688.77 | 689.69 | 688.15 | 689.57 | 6322141.0 |
| 2025-10-29 10:00:00 | SPY | ETF | 689.59 | 689.7 | 687.81 | 688.35 | 7626845.0 |
| 2025-10-29 11:00:00 | SPY | ETF | 688.36 | 688.8196 | 687.84 | 688.05 | 6442110.0 |
| 2025-10-29 12:00:00 | SPY | ETF | 688.04 | 688.78 | 687.59 | 688.55 | 3114607.0 |
| 2025-10-29 13:00:00 | SPY | ETF | 688.55 | 688.81 | 687.62 | 688.1699 | 3003989.0 |
| 2025-10-29 14:00:00 | SPY | ETF | 688.11 | 688.94 | 682.87 | 686.04 | 15072401.0 |
| 2025-10-29 15:00:00 | SPY | ETF | 686.06 | 687.36 | 684.05 | 687.3 | 12876917.0 |
| 2025-10-29 16:00:00 | SPY | ETF | 687.295 | 689.0 | 685.0 | 686.33 | 3363672.0 |
| 2025-10-29 17:00:00 | SPY | ETF | 686.26 | 686.75 | 685.08 | 685.15 | 174859.0 |
| 2025-10-29 18:00:00 | SPY | ETF | 685.18 | 686.63 | 684.8265 | 685.829 | 77572.0 |
| 2025-10-29 19:00:00 | SPY | ETF | 685.8 | 686.92 | 685.46 | 686.73 | 59470.0 |
| 2025-10-29 04:00:00 | QQQ | ETF | 636.0 | 636.65 | 635.47 | 635.69 | 156496.0 |
| 2025-10-29 05:00:00 | QQQ | ETF | 635.64 | 635.71 | 634.7 | 634.95 | 197003.0 |
| 2025-10-29 06:00:00 | QQQ | ETF | 634.85 | 635.75 | 634.76 | 635.22 | 146470.0 |
| 2025-10-29 07:00:00 | QQQ | ETF | 635.2 | 636.35 | 635.16 | 635.81 | 218044.0 |
| 2025-10-29 08:00:00 | QQQ | ETF | 635.82 | 636.64 | 632.446 | 635.45 | 493121.0 |
| 2025-10-29 09:00:00 | QQQ | ETF | 635.43 | 636.835 | 635.31 | 636.835 | 5017310.0 |
| 2025-10-29 10:00:00 | QQQ | ETF | 636.85 | 637.01 | 635.03 | 635.392 | 5647632.0 |
| 2025-10-29 11:00:00 | QQQ | ETF | 635.42 | 635.84 | 634.4101 | 634.88 | 3757356.0 |
| 2025-10-29 12:00:00 | QQQ | ETF | 634.87 | 635.55 | 634.03 | 635.27 | 3438998.0 |
| 2025-10-29 13:00:00 | QQQ | ETF | 635.27 | 635.59 | 634.43 | 635.3 | 2257356.0 |
| 2025-10-29 14:00:00 | QQQ | ETF | 635.3 | 636.05 | 630.25 | 633.56 | 10197232.0 |
| 2025-10-29 15:00:00 | QQQ | ETF | 633.58 | 635.97 | 631.84 | 635.87 | 8188065.0 |
| 2025-10-29 16:00:00 | QQQ | ETF | 635.865 | 638.18 | 632.91 | 634.47 | 2045025.0 |
| 2025-10-29 17:00:00 | QQQ | ETF | 634.4665 | 634.98 | 632.49 | 632.79 | 237419.0 |
| 2025-10-29 18:00:00 | QQQ | ETF | 632.79 | 635.0 | 632.79 | 634.0096 | 328601.0 |
| 2025-10-29 19:00:00 | QQQ | ETF | 633.8 | 634.9806 | 633.05 | 634.71 | 122513.0 |
| 2025-10-29 04:00:00 | IWM | ETF | 248.97 | 249.27 | 248.47 | 248.55 | 54111.0 |
| 2025-10-29 05:00:00 | IWM | ETF | 248.64 | 248.84 | 248.39 | 248.84 | 43217.0 |
| 2025-10-29 06:00:00 | IWM | ETF | 248.84 | 249.29 | 248.74 | 249.1 | 63753.0 |
| 2025-10-29 07:00:00 | IWM | ETF | 249.08 | 249.36 | 248.99 | 248.99 | 54167.0 |
| 2025-10-29 08:00:00 | IWM | ETF | 248.92 | 249.35 | 248.63 | 248.88 | 118136.0 |
| 2025-10-29 09:00:00 | IWM | ETF | 248.83 | 249.305 | 247.845 | 248.91 | 5127794.0 |
| 2025-10-29 10:00:00 | IWM | ETF | 248.92 | 249.6 | 248.5 | 249.59 | 3032219.0 |
| 2025-10-29 11:00:00 | IWM | ETF | 249.59 | 250.9 | 249.58 | 250.64 | 3625852.0 |
| 2025-10-29 12:00:00 | IWM | ETF | 250.64 | 251.0899 | 250.265 | 250.72 | 2480548.0 |
| 2025-10-29 13:00:00 | IWM | ETF | 250.72 | 250.74 | 249.88 | 250.42 | 2650489.0 |
| 2025-10-29 14:00:00 | IWM | ETF | 250.435 | 251.14 | 245.47 | 247.27 | 10637918.0 |
| 2025-10-29 15:00:00 | IWM | ETF | 247.28 | 247.88 | 244.69 | 246.88 | 12080984.0 |
| 2025-10-29 16:00:00 | IWM | ETF | 246.89 | 247.65 | 246.0 | 246.97 | 1127394.0 |
| 2025-10-29 17:00:00 | IWM | ETF | 246.91 | 247.05 | 246.61 | 246.82 | 71759.0 |
| 2025-10-29 18:00:00 | IWM | ETF | 247.05 | 247.46 | 246.6 | 246.89 | 29650.0 |
| 2025-10-29 19:00:00 | IWM | ETF | 246.85 | 247.7 | 246.81 | 247.63 | 39025.0 |
| 2025-10-29 04:00:00 | DIA | ETF | 477.04 | 477.14 | 476.09 | 476.09 | 2651.0 |
| 2025-10-29 05:00:00 | DIA | ETF | 475.98 | 476.06 | 475.72 | 476.06 | 750.0 |
> showing 50 of 28,441 rows — these rows as CSV