PREVIEW / etf_1hour / 2025-05-21
file: by_date/etf_1hour/2025/2025-05-21.parquet size: 647 KB rows: 24,888
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-21 04:00:00 | SPY | ETF | 590.25 | 590.88 | 589.09 | 589.68 | 51634.0 |
| 2025-05-21 05:00:00 | SPY | ETF | 589.77 | 590.04 | 588.37 | 588.55 | 34006.0 |
| 2025-05-21 06:00:00 | SPY | ETF | 588.58 | 589.02 | 587.6 | 589.02 | 141589.0 |
| 2025-05-21 07:00:00 | SPY | ETF | 589.05 | 590.44 | 589.0 | 590.159 | 136866.0 |
| 2025-05-21 08:00:00 | SPY | ETF | 589.08 | 591.25 | 587.7896 | 589.33 | 344402.0 |
| 2025-05-21 09:00:00 | SPY | ETF | 589.4 | 590.5102 | 587.94 | 589.84 | 5693825.0 |
| 2025-05-21 10:00:00 | SPY | ETF | 589.84 | 591.43 | 588.87 | 590.65 | 6752372.0 |
| 2025-05-21 11:00:00 | SPY | ETF | 590.66 | 592.24 | 590.37 | 591.74 | 5537264.0 |
| 2025-05-21 12:00:00 | SPY | ETF | 591.73 | 592.58 | 591.42 | 591.61 | 4422013.0 |
| 2025-05-21 13:00:00 | SPY | ETF | 591.62 | 591.79 | 583.79 | 586.1665 | 16524785.0 |
| 2025-05-21 14:00:00 | SPY | ETF | 586.16 | 586.39 | 583.78 | 584.02 | 7290493.0 |
| 2025-05-21 15:00:00 | SPY | ETF | 584.03 | 584.62 | 581.82 | 582.96 | 17089632.0 |
| 2025-05-21 16:00:00 | SPY | ETF | 582.98 | 583.214 | 582.2 | 582.9 | 4062390.0 |
| 2025-05-21 17:00:00 | SPY | ETF | 582.92 | 583.26 | 582.74 | 582.9 | 145311.0 |
| 2025-05-21 18:00:00 | SPY | ETF | 582.9 | 583.59 | 582.25 | 582.89 | 146110.0 |
| 2025-05-21 19:00:00 | SPY | ETF | 582.8 | 583.5994 | 582.7101 | 583.111 | 50750.0 |
| 2025-05-21 04:00:00 | QQQ | ETF | 517.79 | 517.93 | 516.6 | 517.32 | 65071.0 |
| 2025-05-21 05:00:00 | QQQ | ETF | 517.33 | 517.64 | 516.0 | 516.09 | 37205.0 |
| 2025-05-21 06:00:00 | QQQ | ETF | 516.16 | 516.8 | 515.0 | 516.73 | 151218.0 |
| 2025-05-21 07:00:00 | QQQ | ETF | 516.75 | 518.4 | 516.69 | 517.77 | 103901.0 |
| 2025-05-21 08:00:00 | QQQ | ETF | 516.75 | 519.88 | 515.245 | 517.07 | 235720.0 |
| 2025-05-21 09:00:00 | QQQ | ETF | 517.13 | 519.3 | 515.91 | 518.57 | 4646559.0 |
| 2025-05-21 10:00:00 | QQQ | ETF | 518.57 | 520.59 | 518.3 | 520.5594 | 5839221.0 |
| 2025-05-21 11:00:00 | QQQ | ETF | 520.54 | 522.43 | 520.32 | 521.96 | 5263849.0 |
| 2025-05-21 12:00:00 | QQQ | ETF | 521.96 | 523.0 | 521.83 | 521.9699 | 3506695.0 |
| 2025-05-21 13:00:00 | QQQ | ETF | 521.96 | 522.15 | 513.38 | 516.0501 | 13807623.0 |
| 2025-05-21 14:00:00 | QQQ | ETF | 516.06 | 516.33 | 513.54 | 513.82 | 6138462.0 |
| 2025-05-21 15:00:00 | QQQ | ETF | 513.83 | 514.82 | 511.24 | 513.05 | 11725211.0 |
| 2025-05-21 16:00:00 | QQQ | ETF | 513.06 | 513.23 | 512.22 | 513.0 | 1312469.0 |
| 2025-05-21 17:00:00 | QQQ | ETF | 512.9988 | 513.14 | 512.89 | 512.97 | 82714.0 |
| 2025-05-21 18:00:00 | QQQ | ETF | 512.9 | 513.7 | 512.23 | 512.9799 | 86942.0 |
| 2025-05-21 19:00:00 | QQQ | ETF | 512.81 | 513.69 | 512.72 | 512.96 | 51475.0 |
| 2025-05-21 04:00:00 | IWM | ETF | 208.01 | 208.03 | 207.33 | 207.48 | 59409.0 |
| 2025-05-21 05:00:00 | IWM | ETF | 207.58 | 207.63 | 207.06 | 207.09 | 35164.0 |
| 2025-05-21 06:00:00 | IWM | ETF | 207.1 | 207.13 | 206.6 | 207.05 | 24382.0 |
| 2025-05-21 07:00:00 | IWM | ETF | 207.08 | 207.7 | 207.05 | 207.41 | 50721.0 |
| 2025-05-21 08:00:00 | IWM | ETF | 207.35 | 208.53 | 206.73 | 206.91 | 160827.0 |
| 2025-05-21 09:00:00 | IWM | ETF | 206.92 | 207.46 | 206.22 | 207.065 | 3199084.0 |
| 2025-05-21 10:00:00 | IWM | ETF | 207.07 | 207.61 | 206.33 | 206.94 | 3317722.0 |
| 2025-05-21 11:00:00 | IWM | ETF | 206.93 | 207.35 | 206.73 | 207.0 | 1987757.0 |
| 2025-05-21 12:00:00 | IWM | ETF | 206.99 | 207.23 | 206.805 | 206.85 | 1188472.0 |
| 2025-05-21 13:00:00 | IWM | ETF | 206.85 | 206.985 | 203.48 | 204.34 | 5538033.0 |
| 2025-05-21 14:00:00 | IWM | ETF | 204.345 | 204.47 | 203.48 | 203.53 | 3601011.0 |
| 2025-05-21 15:00:00 | IWM | ETF | 203.55 | 204.005 | 202.84 | 203.21 | 7662779.0 |
| 2025-05-21 16:00:00 | IWM | ETF | 203.21 | 203.3749 | 203.0 | 203.24 | 1258301.0 |
| 2025-05-21 17:00:00 | IWM | ETF | 203.2 | 203.38 | 203.08 | 203.12 | 30268.0 |
| 2025-05-21 18:00:00 | IWM | ETF | 203.2 | 203.5699 | 202.94 | 203.19 | 65983.0 |
| 2025-05-21 19:00:00 | IWM | ETF | 203.12 | 203.45 | 203.11 | 203.34 | 80683.0 |
| 2025-05-21 04:00:00 | DIA | ETF | 424.82 | 424.83 | 424.29 | 424.35 | 2058.0 |
| 2025-05-21 05:00:00 | DIA | ETF | 424.33 | 424.38 | 424.16 | 424.16 | 3137.0 |
> showing 50 of 24,888 rows — these rows as CSV