PREVIEW / etf_1hour / 2025-05-27
file: by_date/etf_1hour/2025/2025-05-27.parquet size: 638 KB rows: 25,188
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-05-27 04:00:00 | SPY | ETF | 585.12 | 588.32 | 585.12 | 587.6 | 107385.0 |
| 2025-05-27 05:00:00 | SPY | ETF | 587.57 | 588.4 | 587.5 | 588.0 | 58677.0 |
| 2025-05-27 06:00:00 | SPY | ETF | 588.02 | 588.38 | 587.47 | 587.61 | 100158.0 |
| 2025-05-27 07:00:00 | SPY | ETF | 587.45 | 587.88 | 586.9 | 587.49 | 340372.0 |
| 2025-05-27 08:00:00 | SPY | ETF | 587.27 | 588.66 | 584.01 | 586.65 | 537278.0 |
| 2025-05-27 09:00:00 | SPY | ETF | 586.62 | 587.47 | 584.37 | 586.13 | 7035781.0 |
| 2025-05-27 10:00:00 | SPY | ETF | 586.17 | 588.59 | 586.14 | 588.04 | 7744340.0 |
| 2025-05-27 11:00:00 | SPY | ETF | 588.04 | 589.12 | 587.94 | 588.965 | 5314013.0 |
| 2025-05-27 12:00:00 | SPY | ETF | 588.96 | 590.67 | 588.89 | 589.93 | 6040978.0 |
| 2025-05-27 13:00:00 | SPY | ETF | 589.9483 | 591.08 | 578.43 | 591.01 | 3758207.0 |
| 2025-05-27 14:00:00 | SPY | ETF | 591.0 | 591.31 | 590.35 | 590.4 | 5021671.0 |
| 2025-05-27 15:00:00 | SPY | ETF | 590.39 | 591.08 | 589.88 | 591.06 | 14008977.0 |
| 2025-05-27 16:00:00 | SPY | ETF | 591.06 | 591.77 | 590.5009 | 591.48 | 2952654.0 |
| 2025-05-27 17:00:00 | SPY | ETF | 591.4717 | 591.75 | 591.4 | 591.53 | 107403.0 |
| 2025-05-27 18:00:00 | SPY | ETF | 591.51 | 591.51 | 591.05 | 591.39 | 81558.0 |
| 2025-05-27 19:00:00 | SPY | ETF | 591.29 | 591.62 | 591.25 | 591.3 | 92724.0 |
| 2025-05-27 04:00:00 | QQQ | ETF | 517.85 | 518.29 | 514.8 | 517.5 | 145883.0 |
| 2025-05-27 05:00:00 | QQQ | ETF | 517.47 | 518.43 | 517.46 | 517.97 | 115639.0 |
| 2025-05-27 06:00:00 | QQQ | ETF | 517.85 | 518.38 | 517.22 | 517.28 | 65705.0 |
| 2025-05-27 07:00:00 | QQQ | ETF | 517.21 | 517.39 | 516.47 | 517.06 | 174190.0 |
| 2025-05-27 08:00:00 | QQQ | ETF | 516.71 | 518.49 | 508.859 | 516.62 | 383060.0 |
| 2025-05-27 09:00:00 | QQQ | ETF | 516.64 | 517.52 | 514.59 | 516.9901 | 5172410.0 |
| 2025-05-27 10:00:00 | QQQ | ETF | 517.03 | 519.31 | 516.98 | 518.496 | 5619837.0 |
| 2025-05-27 11:00:00 | QQQ | ETF | 518.49 | 519.71 | 518.44 | 519.56 | 3429232.0 |
| 2025-05-27 12:00:00 | QQQ | ETF | 519.57 | 520.99 | 519.47 | 520.31 | 3967263.0 |
| 2025-05-27 13:00:00 | QQQ | ETF | 520.31 | 521.49 | 520.31 | 521.42 | 3271722.0 |
| 2025-05-27 14:00:00 | QQQ | ETF | 521.42 | 521.71 | 520.55 | 520.59 | 3490611.0 |
| 2025-05-27 15:00:00 | QQQ | ETF | 520.58 | 521.28 | 519.91 | 521.21 | 7922975.0 |
| 2025-05-27 16:00:00 | QQQ | ETF | 521.2 | 521.7 | 520.66 | 521.42 | 1725347.0 |
| 2025-05-27 17:00:00 | QQQ | ETF | 521.48 | 521.7 | 521.45 | 521.7 | 96388.0 |
| 2025-05-27 18:00:00 | QQQ | ETF | 521.5 | 521.5 | 520.93 | 521.3 | 69208.0 |
| 2025-05-27 19:00:00 | QQQ | ETF | 521.28 | 521.6388 | 521.26 | 521.32 | 95260.0 |
| 2025-05-27 04:00:00 | IWM | ETF | 205.99 | 206.0 | 205.68 | 205.86 | 27702.0 |
| 2025-05-27 05:00:00 | IWM | ETF | 205.88 | 206.0 | 205.74 | 205.97 | 58086.0 |
| 2025-05-27 06:00:00 | IWM | ETF | 205.96 | 206.36 | 205.86 | 206.03 | 29543.0 |
| 2025-05-27 07:00:00 | IWM | ETF | 205.95 | 206.01 | 205.63 | 205.79 | 72252.0 |
| 2025-05-27 08:00:00 | IWM | ETF | 205.88 | 206.26 | 204.5 | 205.7 | 171433.0 |
| 2025-05-27 09:00:00 | IWM | ETF | 205.69 | 206.23 | 204.16 | 204.8 | 3947895.0 |
| 2025-05-27 10:00:00 | IWM | ETF | 204.82 | 206.45 | 204.81 | 206.34 | 4048081.0 |
| 2025-05-27 11:00:00 | IWM | ETF | 206.35 | 206.96 | 206.31 | 206.88 | 2178998.0 |
| 2025-05-27 12:00:00 | IWM | ETF | 206.875 | 207.67 | 206.84 | 207.305 | 2261222.0 |
| 2025-05-27 13:00:00 | IWM | ETF | 207.315 | 207.75 | 207.05 | 207.705 | 2028097.0 |
| 2025-05-27 14:00:00 | IWM | ETF | 207.7 | 207.74 | 207.295 | 207.31 | 1824365.0 |
| 2025-05-27 15:00:00 | IWM | ETF | 207.3 | 207.705 | 207.13 | 207.7 | 4194026.0 |
| 2025-05-27 16:00:00 | IWM | ETF | 207.7 | 207.94 | 207.54 | 207.9 | 1254393.0 |
| 2025-05-27 17:00:00 | IWM | ETF | 207.91 | 208.09 | 207.6 | 207.98 | 71098.0 |
| 2025-05-27 18:00:00 | IWM | ETF | 207.89 | 207.89 | 207.63 | 207.76 | 27324.0 |
| 2025-05-27 19:00:00 | IWM | ETF | 207.82 | 207.88 | 207.78 | 207.83 | 53727.0 |
| 2025-05-27 04:00:00 | DIA | ETF | 422.01 | 422.01 | 421.55 | 421.69 | 3150.0 |
| 2025-05-27 05:00:00 | DIA | ETF | 421.74 | 421.95 | 421.67 | 421.91 | 1000.0 |
> showing 50 of 25,188 rows — these rows as CSV