PREVIEW / etf_1hour / 2025-07-16
file: by_date/etf_1hour/2025/2025-07-16.parquet size: 666 KB rows: 25,550
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-16 04:00:00 | SPY | ETF | 621.88 | 622.0 | 620.89 | 621.73 | 43392.0 |
| 2025-07-16 05:00:00 | SPY | ETF | 621.85 | 621.85 | 621.31 | 621.75 | 20514.0 |
| 2025-07-16 06:00:00 | SPY | ETF | 621.71 | 622.15 | 621.64 | 622.0 | 34525.0 |
| 2025-07-16 07:00:00 | SPY | ETF | 621.98 | 622.22 | 621.67 | 622.21 | 95652.0 |
| 2025-07-16 08:00:00 | SPY | ETF | 622.21 | 623.93 | 619.8 | 623.65 | 651980.0 |
| 2025-07-16 09:00:00 | SPY | ETF | 623.65 | 624.12 | 622.02 | 622.1101 | 5354281.0 |
| 2025-07-16 10:00:00 | SPY | ETF | 622.12 | 623.37 | 621.51 | 622.17 | 9610668.0 |
| 2025-07-16 11:00:00 | SPY | ETF | 622.17 | 623.36 | 618.05 | 621.96 | 27523832.0 |
| 2025-07-16 12:00:00 | SPY | ETF | 621.95 | 623.135 | 621.04 | 623.1048 | 7182464.0 |
| 2025-07-16 13:00:00 | SPY | ETF | 623.1 | 623.79 | 622.91 | 623.0857 | 3990825.0 |
| 2025-07-16 14:00:00 | SPY | ETF | 623.09 | 624.3599 | 622.72 | 624.3489 | 4352673.0 |
| 2025-07-16 15:00:00 | SPY | ETF | 624.34 | 624.73 | 623.825 | 624.18 | 8856802.0 |
| 2025-07-16 16:00:00 | SPY | ETF | 624.18 | 624.23 | 623.63 | 623.81 | 2397741.0 |
| 2025-07-16 17:00:00 | SPY | ETF | 623.82 | 624.0 | 623.8 | 623.85 | 81136.0 |
| 2025-07-16 18:00:00 | SPY | ETF | 623.9 | 623.92 | 623.08 | 623.19 | 136432.0 |
| 2025-07-16 19:00:00 | SPY | ETF | 623.23 | 623.34 | 623.08 | 623.18 | 45437.0 |
| 2025-07-16 04:00:00 | QQQ | ETF | 555.12 | 555.88 | 554.9 | 555.58 | 38641.0 |
| 2025-07-16 05:00:00 | QQQ | ETF | 555.6 | 555.61 | 555.05 | 555.52 | 22776.0 |
| 2025-07-16 06:00:00 | QQQ | ETF | 555.51 | 556.01 | 555.35 | 555.84 | 44309.0 |
| 2025-07-16 07:00:00 | QQQ | ETF | 555.83 | 556.1 | 555.46 | 556.04 | 95471.0 |
| 2025-07-16 08:00:00 | QQQ | ETF | 555.96 | 557.51 | 553.95 | 557.27 | 424259.0 |
| 2025-07-16 09:00:00 | QQQ | ETF | 557.28 | 557.67 | 554.52 | 554.77 | 3680978.0 |
| 2025-07-16 10:00:00 | QQQ | ETF | 554.78 | 556.3 | 554.31 | 555.27 | 5544376.0 |
| 2025-07-16 11:00:00 | QQQ | ETF | 555.31 | 556.58 | 551.56 | 555.27 | 10999076.0 |
| 2025-07-16 12:00:00 | QQQ | ETF | 555.27 | 556.66 | 554.4 | 556.595 | 3597330.0 |
| 2025-07-16 13:00:00 | QQQ | ETF | 556.59 | 557.11 | 556.0 | 556.1926 | 3208747.0 |
| 2025-07-16 14:00:00 | QQQ | ETF | 556.2 | 557.28 | 555.92 | 557.26 | 2625487.0 |
| 2025-07-16 15:00:00 | QQQ | ETF | 557.27 | 557.94 | 556.92 | 557.34 | 4796558.0 |
| 2025-07-16 16:00:00 | QQQ | ETF | 557.34 | 557.3619 | 556.8799 | 557.01 | 1596502.0 |
| 2025-07-16 17:00:00 | QQQ | ETF | 557.05 | 557.4198 | 556.94 | 557.29 | 84922.0 |
| 2025-07-16 18:00:00 | QQQ | ETF | 557.25 | 557.25 | 556.4 | 556.4 | 67289.0 |
| 2025-07-16 19:00:00 | QQQ | ETF | 556.53 | 556.66 | 556.33 | 556.56 | 24319.0 |
| 2025-07-16 04:00:00 | IWM | ETF | 218.65 | 219.06 | 218.53 | 219.02 | 14389.0 |
| 2025-07-16 05:00:00 | IWM | ETF | 218.85 | 219.16 | 218.83 | 219.14 | 16741.0 |
| 2025-07-16 06:00:00 | IWM | ETF | 219.14 | 219.35 | 219.0 | 219.3 | 54470.0 |
| 2025-07-16 07:00:00 | IWM | ETF | 219.23 | 219.56 | 219.12 | 219.55 | 107263.0 |
| 2025-07-16 08:00:00 | IWM | ETF | 219.56 | 220.98 | 217.83 | 220.19 | 684093.0 |
| 2025-07-16 09:00:00 | IWM | ETF | 220.15 | 220.67 | 219.095 | 219.42 | 4771717.0 |
| 2025-07-16 10:00:00 | IWM | ETF | 219.42 | 220.635 | 219.42 | 219.9 | 4845105.0 |
| 2025-07-16 11:00:00 | IWM | ETF | 219.9 | 220.51 | 216.91 | 219.2 | 12548372.0 |
| 2025-07-16 12:00:00 | IWM | ETF | 219.19 | 220.11 | 218.75 | 220.1 | 3414256.0 |
| 2025-07-16 13:00:00 | IWM | ETF | 220.105 | 220.455 | 219.87 | 220.22 | 1832119.0 |
| 2025-07-16 14:00:00 | IWM | ETF | 220.22 | 220.795 | 219.94 | 220.76 | 1783488.0 |
| 2025-07-16 15:00:00 | IWM | ETF | 220.77 | 221.365 | 220.52 | 221.02 | 5268837.0 |
| 2025-07-16 16:00:00 | IWM | ETF | 221.02 | 221.0605 | 220.73 | 220.8 | 1194380.0 |
| 2025-07-16 17:00:00 | IWM | ETF | 220.78 | 220.95 | 220.77 | 220.84 | 5355.0 |
| 2025-07-16 18:00:00 | IWM | ETF | 220.85 | 220.85 | 220.57 | 220.67 | 9451.0 |
| 2025-07-16 19:00:00 | IWM | ETF | 220.69 | 220.75 | 220.5 | 220.69 | 8663.0 |
| 2025-07-16 04:00:00 | DIA | ETF | 439.91 | 440.55 | 439.91 | 440.41 | 600.0 |
| 2025-07-16 05:00:00 | DIA | ETF | 440.36 | 440.38 | 440.06 | 440.34 | 2200.0 |
> showing 50 of 25,550 rows — these rows as CSV