PREVIEW / etf_1hour / 2025-01-15
file: by_date/etf_1hour/2025/2025-01-15.parquet size: 623 KB rows: 23,373
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-01-15 04:00:00 | SPY | ETF | 582.11 | 583.15 | 582.11 | 582.96 | 34615.0 |
| 2025-01-15 05:00:00 | SPY | ETF | 582.92 | 583.22 | 582.7 | 583.21 | 37261.0 |
| 2025-01-15 06:00:00 | SPY | ETF | 583.25 | 584.57 | 583.2 | 584.39 | 39394.0 |
| 2025-01-15 07:00:00 | SPY | ETF | 584.26 | 584.6 | 583.8 | 584.06 | 284927.0 |
| 2025-01-15 08:00:00 | SPY | ETF | 584.27 | 591.78 | 582.19 | 590.9001 | 2314996.0 |
| 2025-01-15 09:00:00 | SPY | ETF | 590.87 | 592.14 | 589.195 | 591.93 | 6122613.0 |
| 2025-01-15 10:00:00 | SPY | ETF | 591.95 | 592.97 | 591.09 | 591.17 | 5163347.0 |
| 2025-01-15 11:00:00 | SPY | ETF | 591.17 | 592.0 | 589.5 | 590.0268 | 3539944.0 |
| 2025-01-15 12:00:00 | SPY | ETF | 590.03 | 591.95 | 589.92 | 591.0 | 2173012.0 |
| 2025-01-15 13:00:00 | SPY | ETF | 591.0 | 592.66 | 591.0 | 592.53 | 1596365.0 |
| 2025-01-15 14:00:00 | SPY | ETF | 592.53 | 593.72 | 592.44 | 593.4 | 3303058.0 |
| 2025-01-15 15:00:00 | SPY | ETF | 593.4 | 593.94 | 592.68 | 592.78 | 10391123.0 |
| 2025-01-15 16:00:00 | SPY | ETF | 592.74 | 593.15 | 592.0474 | 592.68 | 3947937.0 |
| 2025-01-15 17:00:00 | SPY | ETF | 592.67 | 593.0 | 592.52 | 592.87 | 98054.0 |
| 2025-01-15 18:00:00 | SPY | ETF | 592.87 | 593.32 | 592.6 | 593.22 | 61577.0 |
| 2025-01-15 19:00:00 | SPY | ETF | 593.33 | 594.02 | 593.26 | 593.66 | 64458.0 |
| 2025-01-15 04:00:00 | QQQ | ETF | 505.44 | 506.34 | 505.44 | 506.14 | 25031.0 |
| 2025-01-15 05:00:00 | QQQ | ETF | 506.07 | 506.3 | 505.55 | 506.3 | 11178.0 |
| 2025-01-15 06:00:00 | QQQ | ETF | 506.33 | 507.39 | 506.28 | 507.07 | 23156.0 |
| 2025-01-15 07:00:00 | QQQ | ETF | 506.97 | 507.41 | 506.53 | 506.88 | 156815.0 |
| 2025-01-15 08:00:00 | QQQ | ETF | 507.18 | 514.88 | 505.0 | 513.75 | 1497554.0 |
| 2025-01-15 09:00:00 | QQQ | ETF | 513.72 | 515.25 | 511.46 | 514.82 | 4760628.0 |
| 2025-01-15 10:00:00 | QQQ | ETF | 514.87 | 516.73 | 514.64 | 514.65 | 3989881.0 |
| 2025-01-15 11:00:00 | QQQ | ETF | 514.72 | 515.85 | 512.925 | 513.56 | 2774038.0 |
| 2025-01-15 12:00:00 | QQQ | ETF | 513.48 | 515.72 | 513.31 | 514.6801 | 1769367.0 |
| 2025-01-15 13:00:00 | QQQ | ETF | 514.72 | 516.47 | 514.72 | 516.09 | 1322471.0 |
| 2025-01-15 14:00:00 | QQQ | ETF | 516.09 | 517.42 | 516.0537 | 517.025 | 1952131.0 |
| 2025-01-15 15:00:00 | QQQ | ETF | 517.02 | 517.85 | 516.44 | 516.53 | 4521836.0 |
| 2025-01-15 16:00:00 | QQQ | ETF | 516.48 | 516.73 | 515.9 | 516.02 | 2900550.0 |
| 2025-01-15 17:00:00 | QQQ | ETF | 516.12 | 516.89 | 516.1 | 516.7 | 84462.0 |
| 2025-01-15 18:00:00 | QQQ | ETF | 516.7 | 517.13 | 516.17 | 516.92 | 88438.0 |
| 2025-01-15 19:00:00 | QQQ | ETF | 517.02 | 517.69 | 516.92 | 517.33 | 104726.0 |
| 2025-01-15 04:00:00 | IWM | ETF | 220.52 | 220.91 | 220.5 | 220.8 | 16344.0 |
| 2025-01-15 05:00:00 | IWM | ETF | 220.79 | 220.99 | 220.59 | 220.91 | 16775.0 |
| 2025-01-15 06:00:00 | IWM | ETF | 220.92 | 221.35 | 220.81 | 221.35 | 16058.0 |
| 2025-01-15 07:00:00 | IWM | ETF | 221.26 | 221.26 | 220.55 | 220.63 | 138261.0 |
| 2025-01-15 08:00:00 | IWM | ETF | 221.01 | 226.8 | 220.26 | 226.0582 | 2241247.0 |
| 2025-01-15 09:00:00 | IWM | ETF | 226.04 | 226.06 | 224.06 | 225.29 | 4429757.0 |
| 2025-01-15 10:00:00 | IWM | ETF | 225.325 | 225.4 | 223.76 | 223.88 | 3074411.0 |
| 2025-01-15 11:00:00 | IWM | ETF | 223.95 | 224.33 | 223.0 | 223.3 | 2105530.0 |
| 2025-01-15 12:00:00 | IWM | ETF | 223.305 | 223.99 | 223.27 | 223.44 | 1317421.0 |
| 2025-01-15 13:00:00 | IWM | ETF | 223.5 | 224.09 | 223.2032 | 224.02 | 1288979.0 |
| 2025-01-15 14:00:00 | IWM | ETF | 223.99 | 224.72 | 223.81 | 224.3 | 1712199.0 |
| 2025-01-15 15:00:00 | IWM | ETF | 224.31 | 224.87 | 224.04 | 224.09 | 4369080.0 |
| 2025-01-15 16:00:00 | IWM | ETF | 224.08 | 224.26 | 224.01 | 224.17 | 1580983.0 |
| 2025-01-15 17:00:00 | IWM | ETF | 224.16 | 224.23 | 224.09 | 224.22 | 9839.0 |
| 2025-01-15 18:00:00 | IWM | ETF | 224.22 | 224.53 | 224.18 | 224.43 | 25238.0 |
| 2025-01-15 19:00:00 | IWM | ETF | 224.48 | 224.85 | 224.39 | 224.7 | 25445.0 |
| 2025-01-15 06:00:00 | DIA | ETF | 426.19 | 427.6 | 426.17 | 427.36 | 26990.0 |
| 2025-01-15 07:00:00 | DIA | ETF | 427.4 | 427.58 | 426.971 | 427.27 | 10832.0 |
> showing 50 of 23,373 rows — these rows as CSV