PREVIEW / etf_1hour / 2025-08-11
file: by_date/etf_1hour/2025/2025-08-11.parquet size: 665 KB rows: 26,094
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-08-11 04:00:00 | SPY | ETF | 637.98 | 638.32 | 636.85 | 637.24 | 107400.0 |
| 2025-08-11 05:00:00 | SPY | ETF | 637.25 | 637.85 | 637.18 | 637.78 | 27002.0 |
| 2025-08-11 06:00:00 | SPY | ETF | 637.71 | 638.14 | 637.67 | 638.09 | 6496.0 |
| 2025-08-11 07:00:00 | SPY | ETF | 638.06 | 638.4 | 637.97 | 638.32 | 84171.0 |
| 2025-08-11 08:00:00 | SPY | ETF | 638.11 | 638.66 | 637.18 | 637.69 | 249280.0 |
| 2025-08-11 09:00:00 | SPY | ETF | 637.68 | 637.78 | 636.88 | 637.69 | 4482701.0 |
| 2025-08-11 10:00:00 | SPY | ETF | 637.68 | 637.97 | 636.57 | 636.78 | 5312520.0 |
| 2025-08-11 11:00:00 | SPY | ETF | 636.77 | 637.89 | 636.53 | 637.86 | 4010483.0 |
| 2025-08-11 12:00:00 | SPY | ETF | 637.87 | 638.95 | 637.32 | 637.3301 | 5013553.0 |
| 2025-08-11 13:00:00 | SPY | ETF | 637.33 | 637.61 | 636.4 | 636.8019 | 3810290.0 |
| 2025-08-11 14:00:00 | SPY | ETF | 636.81 | 636.88 | 635.56 | 636.51 | 5670065.0 |
| 2025-08-11 15:00:00 | SPY | ETF | 636.5 | 636.64 | 634.66 | 635.83 | 11870390.0 |
| 2025-08-11 16:00:00 | SPY | ETF | 635.84 | 635.99 | 635.32 | 635.44 | 1802758.0 |
| 2025-08-11 17:00:00 | SPY | ETF | 635.47 | 635.6 | 635.3764 | 635.57 | 34920.0 |
| 2025-08-11 18:00:00 | SPY | ETF | 635.52 | 635.85 | 635.19 | 635.8 | 60444.0 |
| 2025-08-11 19:00:00 | SPY | ETF | 635.85 | 635.92 | 635.5003 | 635.75 | 77615.0 |
| 2025-08-11 04:00:00 | QQQ | ETF | 575.48 | 575.48 | 573.55 | 574.36 | 51148.0 |
| 2025-08-11 05:00:00 | QQQ | ETF | 574.37 | 575.07 | 574.35 | 574.86 | 29241.0 |
| 2025-08-11 06:00:00 | QQQ | ETF | 574.9 | 575.35 | 574.58 | 575.0 | 38990.0 |
| 2025-08-11 07:00:00 | QQQ | ETF | 574.94 | 575.27 | 574.82 | 575.19 | 57034.0 |
| 2025-08-11 08:00:00 | QQQ | ETF | 575.18 | 575.76 | 573.66 | 574.86 | 197403.0 |
| 2025-08-11 09:00:00 | QQQ | ETF | 574.89 | 575.38 | 573.83 | 575.36 | 3355092.0 |
| 2025-08-11 10:00:00 | QQQ | ETF | 575.38 | 575.925 | 574.765 | 574.95 | 3168674.0 |
| 2025-08-11 11:00:00 | QQQ | ETF | 574.94 | 575.83 | 574.65 | 575.825 | 2397016.0 |
| 2025-08-11 12:00:00 | QQQ | ETF | 575.825 | 576.8 | 575.15 | 575.185 | 2691640.0 |
| 2025-08-11 13:00:00 | QQQ | ETF | 575.18 | 575.58 | 574.03 | 574.245 | 2236554.0 |
| 2025-08-11 14:00:00 | QQQ | ETF | 574.25 | 574.33 | 573.12 | 573.98 | 2783294.0 |
| 2025-08-11 15:00:00 | QQQ | ETF | 573.98 | 574.07 | 571.57 | 572.76 | 5969400.0 |
| 2025-08-11 16:00:00 | QQQ | ETF | 572.77 | 573.02 | 572.24 | 572.48 | 1112015.0 |
| 2025-08-11 17:00:00 | QQQ | ETF | 572.58 | 572.98 | 572.52 | 572.7738 | 35577.0 |
| 2025-08-11 18:00:00 | QQQ | ETF | 572.75 | 573.05 | 572.246 | 572.85 | 59046.0 |
| 2025-08-11 19:00:00 | QQQ | ETF | 572.84 | 572.96 | 572.52 | 572.71 | 27833.0 |
| 2025-08-11 04:00:00 | IWM | ETF | 221.04 | 221.38 | 220.87 | 221.14 | 39662.0 |
| 2025-08-11 05:00:00 | IWM | ETF | 221.13 | 221.3 | 221.1 | 221.24 | 9885.0 |
| 2025-08-11 06:00:00 | IWM | ETF | 221.24 | 221.24 | 221.05 | 221.24 | 27351.0 |
| 2025-08-11 07:00:00 | IWM | ETF | 221.2 | 221.28 | 221.05 | 221.18 | 29447.0 |
| 2025-08-11 08:00:00 | IWM | ETF | 221.1001 | 221.49 | 220.83 | 220.9306 | 206535.0 |
| 2025-08-11 09:00:00 | IWM | ETF | 220.9 | 221.68 | 220.48 | 221.23 | 2832806.0 |
| 2025-08-11 10:00:00 | IWM | ETF | 221.23 | 221.442 | 220.05 | 220.06 | 2990859.0 |
| 2025-08-11 11:00:00 | IWM | ETF | 220.06 | 220.82 | 219.97 | 220.795 | 2227442.0 |
| 2025-08-11 12:00:00 | IWM | ETF | 220.8 | 221.2465 | 220.23 | 220.37 | 2179364.0 |
| 2025-08-11 13:00:00 | IWM | ETF | 220.37 | 220.495 | 219.91 | 220.285 | 2092837.0 |
| 2025-08-11 14:00:00 | IWM | ETF | 220.29 | 220.405 | 219.86 | 220.22 | 2487497.0 |
| 2025-08-11 15:00:00 | IWM | ETF | 220.22 | 220.37 | 219.81 | 220.29 | 5030624.0 |
| 2025-08-11 16:00:00 | IWM | ETF | 220.27 | 220.36 | 220.1 | 220.16 | 909528.0 |
| 2025-08-11 17:00:00 | IWM | ETF | 220.25 | 220.29 | 220.12 | 220.26 | 4898.0 |
| 2025-08-11 18:00:00 | IWM | ETF | 220.29 | 220.38 | 220.08 | 220.38 | 18322.0 |
| 2025-08-11 19:00:00 | IWM | ETF | 220.38 | 220.49 | 220.25 | 220.374 | 21813.0 |
| 2025-08-11 04:00:00 | DIA | ETF | 442.36 | 442.78 | 442.35 | 442.66 | 5106.0 |
| 2025-08-11 05:00:00 | DIA | ETF | 442.63 | 442.84 | 442.63 | 442.82 | 1200.0 |
> showing 50 of 26,094 rows — these rows as CSV