PREVIEW / etf_1hour / 2025-11-03
file: by_date/etf_1hour/2025/2025-11-03.parquet size: 733 KB rows: 28,352
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-03 04:00:00 | SPY | ETF | 683.65 | 685.12 | 683.61 | 684.45 | 96272.0 |
| 2025-11-03 05:00:00 | SPY | ETF | 684.46 | 684.98 | 684.25 | 684.49 | 36720.0 |
| 2025-11-03 06:00:00 | SPY | ETF | 684.62 | 685.2 | 684.54 | 684.58 | 48497.0 |
| 2025-11-03 07:00:00 | SPY | ETF | 684.55 | 684.93 | 684.01 | 684.05 | 258182.0 |
| 2025-11-03 08:00:00 | SPY | ETF | 684.0 | 685.06 | 682.35 | 684.47 | 288377.0 |
| 2025-11-03 09:00:00 | SPY | ETF | 684.53 | 685.8 | 682.175 | 682.53 | 7435272.0 |
| 2025-11-03 10:00:00 | SPY | ETF | 682.55 | 683.01 | 679.94 | 682.375 | 8973325.0 |
| 2025-11-03 11:00:00 | SPY | ETF | 682.37 | 683.61 | 681.825 | 683.41 | 4330514.0 |
| 2025-11-03 12:00:00 | SPY | ETF | 683.41 | 683.975 | 682.4298 | 683.83 | 3703474.0 |
| 2025-11-03 13:00:00 | SPY | ETF | 683.85 | 684.23 | 683.4 | 683.59 | 2805935.0 |
| 2025-11-03 14:00:00 | SPY | ETF | 683.59 | 683.88 | 682.58 | 683.4 | 4597249.0 |
| 2025-11-03 15:00:00 | SPY | ETF | 683.4 | 683.655 | 682.45 | 683.35 | 9380012.0 |
| 2025-11-03 16:00:00 | SPY | ETF | 683.35 | 684.04 | 683.08 | 683.29 | 2597430.0 |
| 2025-11-03 17:00:00 | SPY | ETF | 683.2511 | 683.44 | 683.04 | 683.16 | 165286.0 |
| 2025-11-03 18:00:00 | SPY | ETF | 683.1 | 683.23 | 682.4 | 682.52 | 97125.0 |
| 2025-11-03 19:00:00 | SPY | ETF | 682.4 | 682.4 | 681.26 | 681.89 | 90997.0 |
| 2025-11-03 04:00:00 | QQQ | ETF | 632.0 | 633.22 | 630.43 | 632.62 | 225870.0 |
| 2025-11-03 05:00:00 | QQQ | ETF | 632.67 | 633.38 | 632.47 | 632.85 | 199978.0 |
| 2025-11-03 06:00:00 | QQQ | ETF | 632.86 | 633.75 | 632.86 | 633.18 | 186419.0 |
| 2025-11-03 07:00:00 | QQQ | ETF | 633.18 | 633.83 | 632.96 | 633.12 | 321542.0 |
| 2025-11-03 08:00:00 | QQQ | ETF | 633.09 | 634.0 | 629.2 | 633.94 | 555307.0 |
| 2025-11-03 09:00:00 | QQQ | ETF | 633.96 | 635.82 | 632.33 | 632.76 | 5144557.0 |
| 2025-11-03 10:00:00 | QQQ | ETF | 632.82 | 633.2 | 629.85 | 631.61 | 5829281.0 |
| 2025-11-03 11:00:00 | QQQ | ETF | 631.62 | 632.51 | 630.505 | 632.305 | 3562899.0 |
| 2025-11-03 12:00:00 | QQQ | ETF | 632.33 | 633.29 | 631.47 | 633.07 | 3142116.0 |
| 2025-11-03 13:00:00 | QQQ | ETF | 633.065 | 633.42 | 632.46 | 632.565 | 2202723.0 |
| 2025-11-03 14:00:00 | QQQ | ETF | 632.555 | 632.81 | 631.0356 | 632.2635 | 2740532.0 |
| 2025-11-03 15:00:00 | QQQ | ETF | 632.28 | 632.46 | 631.1885 | 632.11 | 4025638.0 |
| 2025-11-03 16:00:00 | QQQ | ETF | 632.09 | 633.75 | 631.8103 | 632.08 | 982621.0 |
| 2025-11-03 17:00:00 | QQQ | ETF | 632.1 | 632.4 | 631.74 | 631.74 | 49795.0 |
| 2025-11-03 18:00:00 | QQQ | ETF | 631.68 | 631.83 | 631.0 | 631.13 | 89242.0 |
| 2025-11-03 19:00:00 | QQQ | ETF | 631.1 | 631.1 | 629.08 | 629.78 | 183425.0 |
| 2025-11-03 04:00:00 | IWM | ETF | 246.44 | 247.03 | 246.44 | 246.55 | 42308.0 |
| 2025-11-03 05:00:00 | IWM | ETF | 246.6 | 246.73 | 246.29 | 246.36 | 53478.0 |
| 2025-11-03 06:00:00 | IWM | ETF | 246.4 | 246.86 | 246.35 | 246.64 | 125416.0 |
| 2025-11-03 07:00:00 | IWM | ETF | 246.64 | 246.82 | 246.36 | 246.37 | 51814.0 |
| 2025-11-03 08:00:00 | IWM | ETF | 246.67 | 246.85 | 245.9 | 246.05 | 167315.0 |
| 2025-11-03 09:00:00 | IWM | ETF | 246.05 | 246.5 | 243.91 | 244.95 | 3663511.0 |
| 2025-11-03 10:00:00 | IWM | ETF | 244.99 | 245.17 | 242.485 | 244.09 | 5275161.0 |
| 2025-11-03 11:00:00 | IWM | ETF | 244.08 | 244.755 | 243.96 | 244.59 | 2216421.0 |
| 2025-11-03 12:00:00 | IWM | ETF | 244.59 | 245.27 | 244.09 | 245.15 | 2200187.0 |
| 2025-11-03 13:00:00 | IWM | ETF | 245.155 | 245.17 | 244.37 | 244.7 | 1585171.0 |
| 2025-11-03 14:00:00 | IWM | ETF | 244.72 | 245.445 | 244.58 | 244.915 | 1881084.0 |
| 2025-11-03 15:00:00 | IWM | ETF | 244.92 | 245.44 | 244.665 | 245.42 | 4026248.0 |
| 2025-11-03 16:00:00 | IWM | ETF | 245.44 | 245.97 | 244.7 | 245.82 | 840114.0 |
| 2025-11-03 17:00:00 | IWM | ETF | 245.76 | 245.98 | 245.75 | 245.81 | 20919.0 |
| 2025-11-03 18:00:00 | IWM | ETF | 245.83 | 245.88 | 245.39 | 245.45 | 31541.0 |
| 2025-11-03 19:00:00 | IWM | ETF | 245.43 | 245.43 | 244.87 | 245.27 | 69032.0 |
| 2025-11-03 04:00:00 | DIA | ETF | 476.16 | 476.77 | 476.16 | 476.33 | 6388.0 |
| 2025-11-03 05:00:00 | DIA | ETF | 476.23 | 476.33 | 476.01 | 476.32 | 3951.0 |
> showing 50 of 28,352 rows — these rows as CSV