PREVIEW / etf_1hour / 2025-11-24
file: by_date/etf_1hour/2025/2025-11-24.parquet size: 717 KB rows: 28,067
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-24 04:00:00 | SPY | ETF | 662.5 | 663.75 | 659.46 | 660.74 | 107195.0 |
| 2025-11-24 05:00:00 | SPY | ETF | 660.64 | 661.08 | 659.5 | 660.27 | 103333.0 |
| 2025-11-24 06:00:00 | SPY | ETF | 660.35 | 661.49 | 659.6 | 661.42 | 157999.0 |
| 2025-11-24 07:00:00 | SPY | ETF | 661.4 | 662.85 | 660.88 | 662.62 | 190918.0 |
| 2025-11-24 08:00:00 | SPY | ETF | 661.12 | 663.72 | 659.03 | 662.24 | 548848.0 |
| 2025-11-24 09:00:00 | SPY | ETF | 662.21 | 665.53 | 661.59 | 664.04 | 8478829.0 |
| 2025-11-24 10:00:00 | SPY | ETF | 664.04 | 667.2 | 663.93 | 666.53 | 9786546.0 |
| 2025-11-24 11:00:00 | SPY | ETF | 666.54 | 668.4897 | 666.53 | 667.465 | 6157048.0 |
| 2025-11-24 12:00:00 | SPY | ETF | 667.47 | 669.38 | 666.9 | 669.08 | 4741921.0 |
| 2025-11-24 13:00:00 | SPY | ETF | 669.07 | 669.75 | 668.78 | 669.235 | 3910216.0 |
| 2025-11-24 14:00:00 | SPY | ETF | 669.24 | 669.81 | 667.87 | 668.3 | 6237514.0 |
| 2025-11-24 15:00:00 | SPY | ETF | 668.3 | 670.06 | 668.19 | 668.8 | 15508997.0 |
| 2025-11-24 16:00:00 | SPY | ETF | 668.8 | 669.6101 | 668.56 | 669.39 | 5073148.0 |
| 2025-11-24 17:00:00 | SPY | ETF | 669.4 | 669.48 | 668.99 | 669.48 | 258303.0 |
| 2025-11-24 18:00:00 | SPY | ETF | 669.31 | 669.63 | 669.05 | 669.08 | 178083.0 |
| 2025-11-24 19:00:00 | SPY | ETF | 669.07 | 669.2671 | 668.5 | 669.1911 | 72577.0 |
| 2025-11-24 04:00:00 | QQQ | ETF | 596.0 | 596.23 | 591.49 | 592.88 | 328199.0 |
| 2025-11-24 05:00:00 | QQQ | ETF | 592.73 | 593.22 | 591.41 | 592.35 | 182368.0 |
| 2025-11-24 06:00:00 | QQQ | ETF | 592.43 | 593.78 | 591.78 | 593.61 | 274066.0 |
| 2025-11-24 07:00:00 | QQQ | ETF | 593.55 | 595.08 | 592.84 | 594.91 | 450629.0 |
| 2025-11-24 08:00:00 | QQQ | ETF | 594.82 | 596.29 | 591.789 | 594.69 | 845842.0 |
| 2025-11-24 09:00:00 | QQQ | ETF | 594.66 | 600.06 | 594.61 | 599.19 | 8352486.0 |
| 2025-11-24 10:00:00 | QQQ | ETF | 599.19 | 602.3798 | 598.69 | 601.47 | 8599463.0 |
| 2025-11-24 11:00:00 | QQQ | ETF | 601.484 | 604.15 | 601.475 | 603.1 | 5754851.0 |
| 2025-11-24 12:00:00 | QQQ | ETF | 603.1 | 605.37 | 602.68 | 604.9 | 4368720.0 |
| 2025-11-24 13:00:00 | QQQ | ETF | 604.9 | 605.7 | 604.74 | 605.04 | 3817310.0 |
| 2025-11-24 14:00:00 | QQQ | ETF | 605.01 | 605.89 | 604.24 | 604.73 | 3718552.0 |
| 2025-11-24 15:00:00 | QQQ | ETF | 604.73 | 606.68 | 604.72 | 605.31 | 9717424.0 |
| 2025-11-24 16:00:00 | QQQ | ETF | 605.31 | 606.25 | 605.06 | 606.0 | 2864649.0 |
| 2025-11-24 17:00:00 | QQQ | ETF | 605.95 | 606.76 | 605.95 | 606.49 | 327847.0 |
| 2025-11-24 18:00:00 | QQQ | ETF | 606.41 | 606.58 | 605.72 | 605.96 | 358197.0 |
| 2025-11-24 19:00:00 | QQQ | ETF | 605.9 | 605.99 | 604.94 | 605.85 | 141651.0 |
| 2025-11-24 04:00:00 | IWM | ETF | 237.04 | 237.08 | 235.18 | 236.0 | 43860.0 |
| 2025-11-24 05:00:00 | IWM | ETF | 235.92 | 236.13 | 235.48 | 235.64 | 28875.0 |
| 2025-11-24 06:00:00 | IWM | ETF | 235.64 | 236.05 | 235.36 | 236.0 | 55801.0 |
| 2025-11-24 07:00:00 | IWM | ETF | 236.01 | 236.5 | 235.74 | 236.39 | 144423.0 |
| 2025-11-24 08:00:00 | IWM | ETF | 237.04 | 237.3 | 235.26 | 236.21 | 274565.0 |
| 2025-11-24 09:00:00 | IWM | ETF | 236.2 | 238.155 | 235.48 | 238.15 | 6084256.0 |
| 2025-11-24 10:00:00 | IWM | ETF | 238.15 | 238.84 | 237.46 | 238.73 | 3536112.0 |
| 2025-11-24 11:00:00 | IWM | ETF | 238.72 | 239.42 | 238.64 | 239.04 | 2649601.0 |
| 2025-11-24 12:00:00 | IWM | ETF | 239.06 | 239.975 | 238.86 | 239.86 | 2016974.0 |
| 2025-11-24 13:00:00 | IWM | ETF | 239.86 | 239.94 | 239.54 | 239.8 | 1582203.0 |
| 2025-11-24 14:00:00 | IWM | ETF | 239.8 | 240.14 | 239.19 | 239.24 | 2504988.0 |
| 2025-11-24 15:00:00 | IWM | ETF | 239.23 | 240.385 | 239.23 | 239.895 | 5857588.0 |
| 2025-11-24 16:00:00 | IWM | ETF | 239.89 | 240.4 | 239.81 | 240.29 | 1482966.0 |
| 2025-11-24 17:00:00 | IWM | ETF | 240.2 | 240.44 | 239.99 | 240.3 | 30062.0 |
| 2025-11-24 18:00:00 | IWM | ETF | 240.3 | 240.37 | 240.11 | 240.11 | 22060.0 |
| 2025-11-24 19:00:00 | IWM | ETF | 240.01 | 240.01 | 239.71 | 239.87 | 43748.0 |
| 2025-11-24 04:00:00 | DIA | ETF | 463.59 | 464.23 | 461.83 | 462.34 | 9050.0 |
| 2025-11-24 05:00:00 | DIA | ETF | 462.58 | 462.63 | 462.04 | 462.43 | 2227.0 |
> showing 50 of 28,067 rows — these rows as CSV