PREVIEW / etf_1hour / 2025-04-29
file: by_date/etf_1hour/2025/2025-04-29.parquet size: 623 KB rows: 23,934
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-04-29 04:00:00 | SPY | ETF | 552.81 | 552.83 | 551.4 | 552.3 | 47287.0 |
| 2025-04-29 05:00:00 | SPY | ETF | 552.3 | 552.4 | 551.69 | 552.11 | 16054.0 |
| 2025-04-29 06:00:00 | SPY | ETF | 552.18 | 552.46 | 549.14 | 550.55 | 96657.0 |
| 2025-04-29 07:00:00 | SPY | ETF | 550.62 | 551.36 | 550.48 | 550.88 | 134826.0 |
| 2025-04-29 08:00:00 | SPY | ETF | 550.89 | 553.0 | 549.27 | 549.4 | 721139.0 |
| 2025-04-29 09:00:00 | SPY | ETF | 549.4298 | 551.69 | 547.95 | 550.62 | 3719545.0 |
| 2025-04-29 10:00:00 | SPY | ETF | 550.68 | 553.05 | 549.41 | 552.96 | 4987016.0 |
| 2025-04-29 11:00:00 | SPY | ETF | 552.97 | 553.2918 | 550.872 | 551.73 | 2777812.0 |
| 2025-04-29 12:00:00 | SPY | ETF | 551.7302 | 553.45 | 550.51 | 551.07 | 2624437.0 |
| 2025-04-29 13:00:00 | SPY | ETF | 551.08 | 555.1 | 550.77 | 554.7325 | 4053057.0 |
| 2025-04-29 14:00:00 | SPY | ETF | 554.74 | 555.4406 | 554.12 | 554.33 | 4077543.0 |
| 2025-04-29 15:00:00 | SPY | ETF | 554.34 | 555.45 | 553.82 | 554.14 | 7861326.0 |
| 2025-04-29 16:00:00 | SPY | ETF | 554.15 | 554.8 | 553.5 | 554.13 | 2591802.0 |
| 2025-04-29 17:00:00 | SPY | ETF | 554.12 | 554.12 | 553.7 | 553.81 | 109983.0 |
| 2025-04-29 18:00:00 | SPY | ETF | 553.84 | 554.17 | 553.0 | 553.06 | 94594.0 |
| 2025-04-29 19:00:00 | SPY | ETF | 552.97 | 553.15 | 552.6 | 552.99 | 34650.0 |
| 2025-04-29 04:00:00 | QQQ | ETF | 474.51 | 474.58 | 472.88 | 473.94 | 54607.0 |
| 2025-04-29 05:00:00 | QQQ | ETF | 473.9 | 473.99 | 473.23 | 473.46 | 13373.0 |
| 2025-04-29 06:00:00 | QQQ | ETF | 473.56 | 473.82 | 470.7 | 471.85 | 94778.0 |
| 2025-04-29 07:00:00 | QQQ | ETF | 471.88 | 472.61 | 471.66 | 471.84 | 88259.0 |
| 2025-04-29 08:00:00 | QQQ | ETF | 471.89 | 474.79 | 470.6 | 470.74 | 283815.0 |
| 2025-04-29 09:00:00 | QQQ | ETF | 470.72 | 472.96 | 469.01 | 471.95 | 2874252.0 |
| 2025-04-29 10:00:00 | QQQ | ETF | 471.97 | 474.47 | 471.11 | 474.23 | 3393070.0 |
| 2025-04-29 11:00:00 | QQQ | ETF | 474.24 | 474.62 | 471.92 | 472.81 | 2213365.0 |
| 2025-04-29 12:00:00 | QQQ | ETF | 472.85 | 474.46 | 471.21 | 471.795 | 2573968.0 |
| 2025-04-29 13:00:00 | QQQ | ETF | 471.79 | 475.925 | 471.51 | 475.65 | 3061508.0 |
| 2025-04-29 14:00:00 | QQQ | ETF | 475.6253 | 476.4243 | 475.25 | 475.3875 | 3185893.0 |
| 2025-04-29 15:00:00 | QQQ | ETF | 475.42 | 476.3 | 474.68 | 475.42 | 3408029.0 |
| 2025-04-29 16:00:00 | QQQ | ETF | 475.41 | 475.9104 | 473.551 | 474.61 | 1189335.0 |
| 2025-04-29 17:00:00 | QQQ | ETF | 474.5 | 474.5 | 473.8 | 474.05 | 91130.0 |
| 2025-04-29 18:00:00 | QQQ | ETF | 474.1 | 474.5 | 473.45 | 473.51 | 97312.0 |
| 2025-04-29 19:00:00 | QQQ | ETF | 473.51 | 473.62 | 473.05 | 473.43 | 72449.0 |
| 2025-04-29 04:00:00 | IWM | ETF | 195.37 | 195.49 | 194.95 | 195.35 | 17918.0 |
| 2025-04-29 05:00:00 | IWM | ETF | 195.36 | 195.37 | 195.13 | 195.37 | 3191.0 |
| 2025-04-29 06:00:00 | IWM | ETF | 195.34 | 195.34 | 194.27 | 194.58 | 23286.0 |
| 2025-04-29 07:00:00 | IWM | ETF | 194.65 | 195.23 | 194.65 | 194.95 | 51288.0 |
| 2025-04-29 08:00:00 | IWM | ETF | 194.99 | 195.36 | 194.3 | 194.36 | 181815.0 |
| 2025-04-29 09:00:00 | IWM | ETF | 194.33 | 195.04 | 193.82 | 194.07 | 2279348.0 |
| 2025-04-29 10:00:00 | IWM | ETF | 194.13 | 194.7 | 193.01 | 194.67 | 2263214.0 |
| 2025-04-29 11:00:00 | IWM | ETF | 194.67 | 195.05 | 194.38 | 194.74 | 1019672.0 |
| 2025-04-29 12:00:00 | IWM | ETF | 194.76 | 195.98 | 194.76 | 195.19 | 1418062.0 |
| 2025-04-29 13:00:00 | IWM | ETF | 195.23 | 196.75 | 195.05 | 196.53 | 1395337.0 |
| 2025-04-29 14:00:00 | IWM | ETF | 196.55 | 196.86 | 196.38 | 196.54 | 1530389.0 |
| 2025-04-29 15:00:00 | IWM | ETF | 196.54 | 196.65 | 195.8 | 196.07 | 3384189.0 |
| 2025-04-29 16:00:00 | IWM | ETF | 196.09 | 196.5 | 195.95 | 196.46 | 986571.0 |
| 2025-04-29 17:00:00 | IWM | ETF | 196.35 | 196.44 | 196.0342 | 196.11 | 37695.0 |
| 2025-04-29 18:00:00 | IWM | ETF | 196.18 | 196.33 | 195.91 | 195.91 | 47160.0 |
| 2025-04-29 19:00:00 | IWM | ETF | 195.91 | 196.06 | 195.83 | 195.88 | 12096.0 |
| 2025-04-29 04:00:00 | DIA | ETF | 403.19 | 403.46 | 402.63 | 403.46 | 5119.0 |
| 2025-04-29 05:00:00 | DIA | ETF | 403.12 | 403.12 | 403.12 | 403.12 | 200.0 |
> showing 50 of 23,934 rows — these rows as CSV