PREVIEW / etf_1hour / 2025-11-28
file: by_date/etf_1hour/2025/2025-11-28.parquet size: 475 KB rows: 17,297
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-11-28 04:00:00 | SPY | ETF | 681.14 | 681.9 | 681.14 | 681.74 | 49096.0 |
| 2025-11-28 05:00:00 | SPY | ETF | 681.7 | 681.74 | 681.35 | 681.35 | 27183.0 |
| 2025-11-28 06:00:00 | SPY | ETF | 681.34 | 681.7 | 681.26 | 681.45 | 53024.0 |
| 2025-11-28 07:00:00 | SPY | ETF | 681.46 | 682.25 | 681.35 | 682.04 | 125992.0 |
| 2025-11-28 08:00:00 | SPY | ETF | 681.99 | 683.41 | 680.189 | 681.16 | 307820.0 |
| 2025-11-28 09:00:00 | SPY | ETF | 681.17 | 681.85 | 680.5 | 681.24 | 4584241.0 |
| 2025-11-28 10:00:00 | SPY | ETF | 681.25 | 682.63 | 681.03 | 682.4601 | 6859637.0 |
| 2025-11-28 11:00:00 | SPY | ETF | 682.46 | 682.94 | 681.65 | 682.755 | 6905361.0 |
| 2025-11-28 12:00:00 | SPY | ETF | 682.755 | 683.665 | 681.88 | 683.39 | 11347253.0 |
| 2025-11-28 13:00:00 | SPY | ETF | 683.4 | 683.7 | 682.82 | 683.0009 | 4621042.0 |
| 2025-11-28 14:00:00 | SPY | ETF | 683.0299 | 683.96 | 673.715 | 683.64 | 1089007.0 |
| 2025-11-28 15:00:00 | SPY | ETF | 683.66 | 683.87 | 683.39 | 683.68 | 74596.0 |
| 2025-11-28 16:00:00 | SPY | ETF | 683.68 | 683.8 | 683.2 | 683.54 | 143956.0 |
| 2025-11-28 04:00:00 | QQQ | ETF | 615.42 | 617.13 | 615.42 | 616.82 | 59967.0 |
| 2025-11-28 05:00:00 | QQQ | ETF | 616.89 | 617.09 | 616.75 | 616.94 | 40657.0 |
| 2025-11-28 06:00:00 | QQQ | ETF | 616.99 | 617.1 | 616.75 | 616.84 | 44910.0 |
| 2025-11-28 07:00:00 | QQQ | ETF | 616.8 | 617.6 | 616.65 | 617.37 | 98546.0 |
| 2025-11-28 08:00:00 | QQQ | ETF | 616.76 | 617.8 | 613.81 | 616.43 | 285913.0 |
| 2025-11-28 09:00:00 | QQQ | ETF | 616.45 | 617.58 | 615.4174 | 616.31 | 3675037.0 |
| 2025-11-28 10:00:00 | QQQ | ETF | 616.31 | 617.57 | 615.91 | 617.295 | 3762082.0 |
| 2025-11-28 11:00:00 | QQQ | ETF | 617.3 | 617.94 | 616.28 | 617.68 | 3754827.0 |
| 2025-11-28 12:00:00 | QQQ | ETF | 617.67 | 619.24 | 616.91 | 619.18 | 5620009.0 |
| 2025-11-28 13:00:00 | QQQ | ETF | 619.18 | 619.49 | 618.74 | 618.8612 | 1338210.0 |
| 2025-11-28 14:00:00 | QQQ | ETF | 618.94 | 619.31 | 618.79 | 619.2987 | 90973.0 |
| 2025-11-28 15:00:00 | QQQ | ETF | 619.3 | 619.51 | 619.06 | 619.06 | 364426.0 |
| 2025-11-28 16:00:00 | QQQ | ETF | 619.06 | 619.25 | 618.8 | 619.11 | 41165.0 |
| 2025-11-28 04:00:00 | IWM | ETF | 248.28 | 248.28 | 247.87 | 247.9 | 11058.0 |
| 2025-11-28 05:00:00 | IWM | ETF | 247.98 | 248.05 | 247.79 | 247.79 | 4750.0 |
| 2025-11-28 06:00:00 | IWM | ETF | 247.79 | 247.89 | 247.66 | 247.76 | 4589.0 |
| 2025-11-28 07:00:00 | IWM | ETF | 247.72 | 248.11 | 247.65 | 248.01 | 10276.0 |
| 2025-11-28 08:00:00 | IWM | ETF | 248.0 | 248.99 | 247.62 | 247.94 | 38752.0 |
| 2025-11-28 09:00:00 | IWM | ETF | 247.97 | 248.36 | 247.07 | 247.81 | 2304708.0 |
| 2025-11-28 10:00:00 | IWM | ETF | 247.81 | 248.55 | 247.74 | 248.33 | 3416450.0 |
| 2025-11-28 11:00:00 | IWM | ETF | 248.32 | 248.515 | 248.08 | 248.29 | 2987659.0 |
| 2025-11-28 12:00:00 | IWM | ETF | 248.3 | 248.76 | 247.8 | 248.69 | 4540330.0 |
| 2025-11-28 13:00:00 | IWM | ETF | 248.69 | 248.81 | 248.0 | 248.48 | 1047486.0 |
| 2025-11-28 14:00:00 | IWM | ETF | 248.5028 | 248.7 | 248.3098 | 248.55 | 27038.0 |
| 2025-11-28 15:00:00 | IWM | ETF | 248.58 | 248.69 | 248.5 | 248.69 | 10219.0 |
| 2025-11-28 16:00:00 | IWM | ETF | 248.63 | 248.7 | 248.55 | 248.7 | 7571.0 |
| 2025-11-28 06:00:00 | DIA | ETF | 475.62 | 475.62 | 475.62 | 475.62 | 80.0 |
| 2025-11-28 07:00:00 | DIA | ETF | 475.68 | 475.88 | 475.67 | 475.73 | 1165.0 |
| 2025-11-28 08:00:00 | DIA | ETF | 475.8485 | 475.94 | 474.5 | 475.31 | 1112.0 |
| 2025-11-28 09:00:00 | DIA | ETF | 475.74 | 475.88 | 474.81 | 475.75 | 309317.0 |
| 2025-11-28 10:00:00 | DIA | ETF | 475.78 | 477.3488 | 475.66 | 477.1601 | 507586.0 |
| 2025-11-28 11:00:00 | DIA | ETF | 477.16 | 477.61 | 476.76 | 477.39 | 506762.0 |
| 2025-11-28 12:00:00 | DIA | ETF | 477.45 | 477.58 | 476.58 | 477.17 | 528715.0 |
| 2025-11-28 13:00:00 | DIA | ETF | 477.19 | 477.35 | 476.93 | 477.31 | 35904.0 |
| 2025-11-28 14:00:00 | DIA | ETF | 476.86 | 477.39 | 476.361 | 477.39 | 571.0 |
| 2025-11-28 15:00:00 | DIA | ETF | 477.2 | 478.4 | 477.18 | 478.4 | 3755.0 |
| 2025-11-28 16:00:00 | DIA | ETF | 477.8175 | 477.8175 | 477.8175 | 477.8175 | 50.0 |
> showing 50 of 17,297 rows — these rows as CSV