PREVIEW / etf_1hour / 2026-04-15
file: by_date/etf_1hour/2026/2026-04-15.parquet size: 738 KB rows: 29,481
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 |
|---|---|---|---|---|---|---|---|
| 2026-04-15 04:00:00 | SPY | ETF | 694.6 | 695.37 | 693.88 | 694.85 | 80664.0 |
| 2026-04-15 05:00:00 | SPY | ETF | 694.88 | 694.88 | 693.77 | 693.91 | 35628.0 |
| 2026-04-15 06:00:00 | SPY | ETF | 693.96 | 694.32 | 693.05 | 694.0 | 138792.0 |
| 2026-04-15 07:00:00 | SPY | ETF | 694.0 | 695.6 | 693.98 | 694.78 | 251928.0 |
| 2026-04-15 08:00:00 | SPY | ETF | 694.74 | 695.0 | 694.09 | 694.85 | 160802.0 |
| 2026-04-15 09:00:00 | SPY | ETF | 694.85 | 696.35 | 694.2 | 695.51 | 5039873.0 |
| 2026-04-15 10:00:00 | SPY | ETF | 695.51 | 697.14 | 695.0 | 696.92 | 6126278.0 |
| 2026-04-15 11:00:00 | SPY | ETF | 696.92 | 697.56 | 696.44 | 697.13 | 5063070.0 |
| 2026-04-15 12:00:00 | SPY | ETF | 697.12 | 697.8 | 695.7 | 696.475 | 4729770.0 |
| 2026-04-15 13:00:00 | SPY | ETF | 696.46 | 698.0 | 696.41 | 697.54 | 4097543.0 |
| 2026-04-15 14:00:00 | SPY | ETF | 697.55 | 699.84 | 697.19 | 699.765 | 6776169.0 |
| 2026-04-15 15:00:00 | SPY | ETF | 699.77 | 700.26 | 699.26 | 700.09 | 9736536.0 |
| 2026-04-15 16:00:00 | SPY | ETF | 700.09 | 700.28 | 699.3 | 699.6 | 3886986.0 |
| 2026-04-15 17:00:00 | SPY | ETF | 699.6 | 699.69 | 699.37 | 699.65 | 57756.0 |
| 2026-04-15 18:00:00 | SPY | ETF | 699.55 | 700.34 | 699.28 | 700.228 | 88427.0 |
| 2026-04-15 19:00:00 | SPY | ETF | 700.28 | 700.74 | 700.18 | 700.65 | 55941.0 |
| 2026-04-15 20:00:00 | SPY | ETF | 700.698 | 700.7 | 700.61 | 700.65 | 959.0 |
| 2026-04-15 04:00:00 | QQQ | ETF | 628.93 | 629.78 | 627.72 | 629.43 | 262132.0 |
| 2026-04-15 05:00:00 | QQQ | ETF | 629.41 | 629.5 | 628.05 | 628.12 | 105013.0 |
| 2026-04-15 06:00:00 | QQQ | ETF | 628.05 | 628.46 | 626.95 | 628.2 | 215165.0 |
| 2026-04-15 07:00:00 | QQQ | ETF | 628.12 | 629.6 | 627.91 | 628.544 | 207864.0 |
| 2026-04-15 08:00:00 | QQQ | ETF | 628.552 | 628.72 | 627.62 | 628.52 | 247950.0 |
| 2026-04-15 09:00:00 | QQQ | ETF | 628.51 | 630.15 | 628.1 | 630.04 | 4657091.0 |
| 2026-04-15 10:00:00 | QQQ | ETF | 630.055 | 632.77 | 629.735 | 632.7 | 5456153.0 |
| 2026-04-15 11:00:00 | QQQ | ETF | 632.7 | 633.74 | 631.89 | 633.37 | 4477637.0 |
| 2026-04-15 12:00:00 | QQQ | ETF | 633.375 | 634.57 | 630.95 | 631.97 | 6692785.0 |
| 2026-04-15 13:00:00 | QQQ | ETF | 631.95 | 633.8 | 631.78 | 633.155 | 2843587.0 |
| 2026-04-15 14:00:00 | QQQ | ETF | 633.155 | 636.08 | 632.68 | 635.96 | 4502552.0 |
| 2026-04-15 15:00:00 | QQQ | ETF | 635.96 | 637.63 | 635.54 | 637.48 | 6656342.0 |
| 2026-04-15 16:00:00 | QQQ | ETF | 637.49 | 637.83 | 633.0 | 637.11 | 3664738.0 |
| 2026-04-15 17:00:00 | QQQ | ETF | 637.15 | 637.2 | 636.9 | 636.98 | 68219.0 |
| 2026-04-15 18:00:00 | QQQ | ETF | 637.03 | 637.98 | 636.92 | 637.91 | 177311.0 |
| 2026-04-15 19:00:00 | QQQ | ETF | 637.959 | 638.49 | 637.84 | 638.34 | 134550.0 |
| 2026-04-15 20:00:00 | QQQ | ETF | 638.4 | 638.4 | 638.29 | 638.36 | 5946.0 |
| 2026-04-15 04:00:00 | IWM | ETF | 268.39 | 268.79 | 268.1 | 268.62 | 66129.0 |
| 2026-04-15 05:00:00 | IWM | ETF | 268.64 | 268.65 | 268.2 | 268.27 | 28022.0 |
| 2026-04-15 06:00:00 | IWM | ETF | 268.33 | 268.64 | 267.86 | 268.4 | 56352.0 |
| 2026-04-15 07:00:00 | IWM | ETF | 268.44 | 269.03 | 267.98 | 268.42 | 357130.0 |
| 2026-04-15 08:00:00 | IWM | ETF | 268.42 | 268.82 | 268.1 | 268.75 | 227212.0 |
| 2026-04-15 09:00:00 | IWM | ETF | 268.7 | 269.585 | 268.184 | 268.94 | 2638132.0 |
| 2026-04-15 10:00:00 | IWM | ETF | 268.935 | 269.32 | 268.33 | 268.85 | 1777955.0 |
| 2026-04-15 11:00:00 | IWM | ETF | 268.855 | 269.12 | 268.195 | 268.265 | 2202105.0 |
| 2026-04-15 12:00:00 | IWM | ETF | 268.265 | 268.88 | 267.59 | 267.755 | 2096300.0 |
| 2026-04-15 13:00:00 | IWM | ETF | 267.735 | 268.6 | 267.735 | 268.4 | 1030130.0 |
| 2026-04-15 14:00:00 | IWM | ETF | 268.39 | 269.09 | 268.2 | 269.055 | 1337983.0 |
| 2026-04-15 15:00:00 | IWM | ETF | 269.055 | 269.43 | 268.85 | 269.415 | 2091190.0 |
| 2026-04-15 16:00:00 | IWM | ETF | 269.41 | 269.51 | 269.05 | 269.3 | 1292084.0 |
| 2026-04-15 17:00:00 | IWM | ETF | 269.32 | 269.44 | 269.15 | 269.44 | 10477.0 |
| 2026-04-15 18:00:00 | IWM | ETF | 269.36 | 269.65 | 269.18 | 269.581 | 24798.0 |
| 2026-04-15 19:00:00 | IWM | ETF | 269.67 | 269.833 | 269.58 | 269.791 | 16522.0 |
> showing 50 of 29,481 rows — these rows as CSV