PREVIEW / etf_1hour / 2025-07-10
file: by_date/etf_1hour/2025/2025-07-10.parquet size: 666 KB rows: 25,290
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-07-10 04:00:00 | SPY | ETF | 622.79 | 623.53 | 622.73 | 623.41 | 75781.0 |
| 2025-07-10 05:00:00 | SPY | ETF | 623.43 | 623.54 | 622.92 | 623.24 | 21771.0 |
| 2025-07-10 06:00:00 | SPY | ETF | 623.29 | 623.75 | 623.17 | 623.61 | 32953.0 |
| 2025-07-10 07:00:00 | SPY | ETF | 623.61 | 624.49 | 623.5 | 624.3 | 77004.0 |
| 2025-07-10 08:00:00 | SPY | ETF | 623.65 | 624.49 | 622.31 | 623.63 | 282893.0 |
| 2025-07-10 09:00:00 | SPY | ETF | 623.65 | 624.4181 | 623.12 | 623.395 | 4754392.0 |
| 2025-07-10 10:00:00 | SPY | ETF | 623.395 | 625.1 | 623.01 | 624.865 | 7404687.0 |
| 2025-07-10 11:00:00 | SPY | ETF | 624.86 | 625.785 | 624.83 | 625.7 | 4441185.0 |
| 2025-07-10 12:00:00 | SPY | ETF | 625.7 | 625.78 | 625.025 | 625.54 | 3816572.0 |
| 2025-07-10 13:00:00 | SPY | ETF | 625.54 | 626.77 | 625.53 | 626.585 | 4512478.0 |
| 2025-07-10 14:00:00 | SPY | ETF | 626.58 | 626.8701 | 626.09 | 626.26 | 4603070.0 |
| 2025-07-10 15:00:00 | SPY | ETF | 626.26 | 626.675 | 625.21 | 625.84 | 10851058.0 |
| 2025-07-10 16:00:00 | SPY | ETF | 625.82 | 625.9026 | 625.27 | 625.51 | 2013303.0 |
| 2025-07-10 17:00:00 | SPY | ETF | 625.55 | 625.66 | 625.47 | 625.55 | 38994.0 |
| 2025-07-10 18:00:00 | SPY | ETF | 625.53 | 626.13 | 625.5 | 626.13 | 86588.0 |
| 2025-07-10 19:00:00 | SPY | ETF | 626.13 | 626.37 | 626.01 | 626.31 | 24381.0 |
| 2025-07-10 04:00:00 | QQQ | ETF | 555.58 | 556.21 | 555.49 | 556.18 | 31595.0 |
| 2025-07-10 05:00:00 | QQQ | ETF | 556.16 | 556.26 | 555.4 | 555.77 | 34890.0 |
| 2025-07-10 06:00:00 | QQQ | ETF | 555.67 | 556.34 | 555.67 | 556.13 | 38020.0 |
| 2025-07-10 07:00:00 | QQQ | ETF | 556.11 | 556.91 | 556.02 | 556.8 | 57318.0 |
| 2025-07-10 08:00:00 | QQQ | ETF | 556.16 | 556.8996 | 554.69 | 556.3 | 220181.0 |
| 2025-07-10 09:00:00 | QQQ | ETF | 556.32 | 557.3 | 553.66 | 554.16 | 3723238.0 |
| 2025-07-10 10:00:00 | QQQ | ETF | 554.16 | 554.8 | 552.75 | 554.2407 | 5171031.0 |
| 2025-07-10 11:00:00 | QQQ | ETF | 554.23 | 555.695 | 553.69 | 555.685 | 2928578.0 |
| 2025-07-10 12:00:00 | QQQ | ETF | 555.68 | 555.69 | 554.235 | 554.92 | 2731976.0 |
| 2025-07-10 13:00:00 | QQQ | ETF | 554.92 | 556.09 | 554.86 | 555.99 | 2084720.0 |
| 2025-07-10 14:00:00 | QQQ | ETF | 555.99 | 556.29 | 555.7 | 556.0006 | 1946494.0 |
| 2025-07-10 15:00:00 | QQQ | ETF | 556.0 | 556.16 | 554.89 | 555.47 | 3799212.0 |
| 2025-07-10 16:00:00 | QQQ | ETF | 555.45 | 555.69 | 555.05 | 555.34 | 864545.0 |
| 2025-07-10 17:00:00 | QQQ | ETF | 555.38 | 555.45 | 555.31 | 555.3614 | 7501.0 |
| 2025-07-10 18:00:00 | QQQ | ETF | 555.35 | 556.02 | 555.29 | 556.02 | 94193.0 |
| 2025-07-10 19:00:00 | QQQ | ETF | 556.01 | 556.23 | 555.82 | 556.13 | 67700.0 |
| 2025-07-10 04:00:00 | IWM | ETF | 223.14 | 223.45 | 223.03 | 223.45 | 9537.0 |
| 2025-07-10 05:00:00 | IWM | ETF | 223.49 | 223.57 | 223.32 | 223.51 | 9183.0 |
| 2025-07-10 06:00:00 | IWM | ETF | 223.76 | 223.86 | 223.48 | 223.82 | 41349.0 |
| 2025-07-10 07:00:00 | IWM | ETF | 223.77 | 224.2 | 223.71 | 224.14 | 54226.0 |
| 2025-07-10 08:00:00 | IWM | ETF | 224.02 | 224.18 | 222.98 | 223.32 | 177421.0 |
| 2025-07-10 09:00:00 | IWM | ETF | 223.28 | 223.745 | 222.86 | 223.53 | 2669796.0 |
| 2025-07-10 10:00:00 | IWM | ETF | 223.54 | 224.785 | 223.46 | 224.71 | 3858377.0 |
| 2025-07-10 11:00:00 | IWM | ETF | 224.7 | 225.155 | 224.59 | 225.12 | 3441201.0 |
| 2025-07-10 12:00:00 | IWM | ETF | 225.11 | 225.52 | 225.04 | 225.22 | 2276519.0 |
| 2025-07-10 13:00:00 | IWM | ETF | 225.22 | 226.05 | 225.21 | 225.79 | 2253368.0 |
| 2025-07-10 14:00:00 | IWM | ETF | 225.79 | 225.79 | 225.08 | 225.14 | 2987582.0 |
| 2025-07-10 15:00:00 | IWM | ETF | 225.15 | 225.62 | 224.64 | 224.78 | 4847179.0 |
| 2025-07-10 16:00:00 | IWM | ETF | 224.78 | 224.95 | 224.63 | 224.79 | 1400706.0 |
| 2025-07-10 17:00:00 | IWM | ETF | 224.77 | 224.87 | 224.77 | 224.85 | 19449.0 |
| 2025-07-10 18:00:00 | IWM | ETF | 224.87 | 225.06 | 224.83 | 225.0402 | 11351.0 |
| 2025-07-10 19:00:00 | IWM | ETF | 225.0313 | 225.21 | 225.0 | 225.14 | 7096.0 |
| 2025-07-10 04:00:00 | DIA | ETF | 443.53 | 443.72 | 443.53 | 443.71 | 500.0 |
| 2025-07-10 05:00:00 | DIA | ETF | 443.61 | 443.62 | 443.51 | 443.62 | 2278.0 |
> showing 50 of 25,290 rows — these rows as CSV