PREVIEW / etf_1hour / 2025-05-22
file: by_date/etf_1hour/2025/2025-05-22.parquet size: 626 KB rows: 24,510
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-22 04:00:00 | SPY | ETF | 584.0 | 584.44 | 583.63 | 584.05 | 40651.0 |
| 2025-05-22 05:00:00 | SPY | ETF | 584.0 | 584.28 | 583.48 | 583.95 | 30097.0 |
| 2025-05-22 06:00:00 | SPY | ETF | 583.81 | 584.17 | 583.33 | 583.62 | 40042.0 |
| 2025-05-22 07:00:00 | SPY | ETF | 583.62 | 584.64 | 580.98 | 581.02 | 283705.0 |
| 2025-05-22 08:00:00 | SPY | ETF | 581.02 | 591.9255 | 580.0 | 583.1 | 910338.0 |
| 2025-05-22 09:00:00 | SPY | ETF | 583.13 | 584.35 | 581.405 | 584.18 | 6380500.0 |
| 2025-05-22 10:00:00 | SPY | ETF | 584.19 | 585.17 | 581.51 | 582.9 | 7502418.0 |
| 2025-05-22 11:00:00 | SPY | ETF | 582.92 | 584.37 | 582.3499 | 584.25 | 5706309.0 |
| 2025-05-22 12:00:00 | SPY | ETF | 584.25 | 585.61 | 583.02 | 583.12 | 4937705.0 |
| 2025-05-22 13:00:00 | SPY | ETF | 583.13 | 585.83 | 582.63 | 585.39 | 4901617.0 |
| 2025-05-22 14:00:00 | SPY | ETF | 585.38 | 586.1 | 584.89 | 585.84 | 4959465.0 |
| 2025-05-22 15:00:00 | SPY | ETF | 585.845 | 586.62 | 582.58 | 583.03 | 13786955.0 |
| 2025-05-22 16:00:00 | SPY | ETF | 583.02 | 584.1 | 582.81 | 583.94 | 2373802.0 |
| 2025-05-22 17:00:00 | SPY | ETF | 583.9384 | 584.1 | 583.88 | 584.08 | 70138.0 |
| 2025-05-22 18:00:00 | SPY | ETF | 584.1 | 584.3 | 582.3 | 582.48 | 82589.0 |
| 2025-05-22 19:00:00 | SPY | ETF | 582.47 | 583.2 | 582.22 | 583.11 | 52100.0 |
| 2025-05-22 04:00:00 | QQQ | ETF | 514.25 | 514.99 | 514.0 | 514.39 | 63099.0 |
| 2025-05-22 05:00:00 | QQQ | ETF | 514.33 | 514.78 | 513.93 | 514.56 | 81523.0 |
| 2025-05-22 06:00:00 | QQQ | ETF | 514.41 | 514.63 | 513.75 | 514.14 | 114915.0 |
| 2025-05-22 07:00:00 | QQQ | ETF | 514.11 | 515.45 | 511.52 | 511.54 | 324882.0 |
| 2025-05-22 08:00:00 | QQQ | ETF | 514.87 | 515.4 | 510.51 | 514.17 | 675571.0 |
| 2025-05-22 09:00:00 | QQQ | ETF | 514.22 | 516.62 | 512.3 | 516.5 | 6080542.0 |
| 2025-05-22 10:00:00 | QQQ | ETF | 516.52 | 517.54 | 513.58 | 515.17 | 6991647.0 |
| 2025-05-22 11:00:00 | QQQ | ETF | 515.1491 | 516.34 | 514.38 | 516.14 | 4995921.0 |
| 2025-05-22 12:00:00 | QQQ | ETF | 516.13 | 517.39 | 514.63 | 514.81 | 4110587.0 |
| 2025-05-22 13:00:00 | QQQ | ETF | 514.83 | 517.06 | 514.31 | 516.6202 | 3585519.0 |
| 2025-05-22 14:00:00 | QQQ | ETF | 516.63 | 517.24 | 516.07 | 516.95 | 3277313.0 |
| 2025-05-22 15:00:00 | QQQ | ETF | 516.96 | 517.71 | 513.5913 | 514.02 | 8152255.0 |
| 2025-05-22 16:00:00 | QQQ | ETF | 514.01 | 514.75 | 513.81 | 514.75 | 832766.0 |
| 2025-05-22 17:00:00 | QQQ | ETF | 514.73 | 515.249 | 513.9 | 515.21 | 157407.0 |
| 2025-05-22 18:00:00 | QQQ | ETF | 515.03 | 515.25 | 513.04 | 513.2392 | 210415.0 |
| 2025-05-22 19:00:00 | QQQ | ETF | 513.24 | 513.96 | 512.91 | 513.87 | 91355.0 |
| 2025-05-22 04:00:00 | IWM | ETF | 203.56 | 203.8 | 203.38 | 203.57 | 30991.0 |
| 2025-05-22 05:00:00 | IWM | ETF | 203.48 | 203.66 | 203.09 | 203.18 | 99166.0 |
| 2025-05-22 06:00:00 | IWM | ETF | 203.15 | 203.2 | 202.75 | 202.75 | 39174.0 |
| 2025-05-22 07:00:00 | IWM | ETF | 202.83 | 203.19 | 201.47 | 201.47 | 162536.0 |
| 2025-05-22 08:00:00 | IWM | ETF | 202.45 | 203.85 | 200.95 | 202.39 | 507049.0 |
| 2025-05-22 09:00:00 | IWM | ETF | 202.28 | 202.8 | 201.53 | 202.53 | 3788347.0 |
| 2025-05-22 10:00:00 | IWM | ETF | 202.52 | 203.095 | 201.945 | 202.53 | 3797861.0 |
| 2025-05-22 11:00:00 | IWM | ETF | 202.55 | 203.465 | 202.53 | 203.44 | 2566080.0 |
| 2025-05-22 12:00:00 | IWM | ETF | 203.46 | 203.925 | 202.73 | 202.82 | 4623173.0 |
| 2025-05-22 13:00:00 | IWM | ETF | 202.82 | 203.94 | 202.72 | 203.805 | 1969900.0 |
| 2025-05-22 14:00:00 | IWM | ETF | 203.8017 | 204.06 | 203.65 | 203.965 | 1688243.0 |
| 2025-05-22 15:00:00 | IWM | ETF | 203.97 | 204.37 | 203.11 | 203.23 | 4746381.0 |
| 2025-05-22 16:00:00 | IWM | ETF | 203.235 | 203.54 | 203.04 | 203.54 | 1067312.0 |
| 2025-05-22 17:00:00 | IWM | ETF | 203.54 | 203.78 | 203.43 | 203.77 | 22151.0 |
| 2025-05-22 18:00:00 | IWM | ETF | 203.67 | 203.73 | 202.94 | 203.04 | 24670.0 |
| 2025-05-22 19:00:00 | IWM | ETF | 203.0 | 203.32 | 202.9 | 203.32 | 13974.0 |
| 2025-05-22 04:00:00 | DIA | ETF | 418.73 | 418.73 | 418.73 | 418.73 | 100.0 |
| 2025-05-22 05:00:00 | DIA | ETF | 418.62 | 418.68 | 418.3 | 418.43 | 5406.0 |
> showing 50 of 24,510 rows — these rows as CSV