PREVIEW / etf_1hour / 2025-11-04
file: by_date/etf_1hour/2025/2025-11-04.parquet size: 742 KB rows: 28,706
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-04 04:00:00 | SPY | ETF | 676.52 | 678.63 | 674.3 | 674.47 | 217757.0 |
| 2025-11-04 05:00:00 | SPY | ETF | 674.44 | 676.6 | 673.77 | 676.47 | 299515.0 |
| 2025-11-04 06:00:00 | SPY | ETF | 676.59 | 677.0 | 676.23 | 676.47 | 244455.0 |
| 2025-11-04 07:00:00 | SPY | ETF | 676.39 | 677.18 | 675.61 | 676.57 | 415101.0 |
| 2025-11-04 08:00:00 | SPY | ETF | 676.5 | 680.03 | 674.2 | 676.01 | 601148.0 |
| 2025-11-04 09:00:00 | SPY | ETF | 675.99 | 678.815 | 674.67 | 678.6817 | 9722841.0 |
| 2025-11-04 10:00:00 | SPY | ETF | 678.71 | 679.96 | 677.63 | 678.18 | 7414331.0 |
| 2025-11-04 11:00:00 | SPY | ETF | 678.18 | 678.82 | 677.44 | 678.19 | 5799405.0 |
| 2025-11-04 12:00:00 | SPY | ETF | 678.19 | 678.205 | 675.68 | 676.01 | 6267190.0 |
| 2025-11-04 13:00:00 | SPY | ETF | 675.98 | 676.42 | 674.71 | 676.15 | 5767112.0 |
| 2025-11-04 14:00:00 | SPY | ETF | 676.11 | 676.68 | 674.58 | 675.17 | 7087243.0 |
| 2025-11-04 15:00:00 | SPY | ETF | 675.19 | 676.535 | 674.615 | 675.35 | 13361618.0 |
| 2025-11-04 16:00:00 | SPY | ETF | 675.35 | 675.82 | 674.55 | 675.61 | 3951042.0 |
| 2025-11-04 17:00:00 | SPY | ETF | 675.64 | 675.77 | 675.12 | 675.12 | 138999.0 |
| 2025-11-04 18:00:00 | SPY | ETF | 675.22 | 675.62 | 674.35 | 674.41 | 174781.0 |
| 2025-11-04 19:00:00 | SPY | ETF | 674.31 | 674.31 | 672.34 | 672.34 | 186017.0 |
| 2025-11-04 20:00:00 | SPY | ETF | 672.33 | 672.33 | 672.33 | 672.33 | 863.0 |
| 2025-11-04 04:00:00 | QQQ | ETF | 625.0 | 625.0 | 621.55 | 621.68 | 431576.0 |
| 2025-11-04 05:00:00 | QQQ | ETF | 621.66 | 624.0 | 620.97 | 623.71 | 359237.0 |
| 2025-11-04 06:00:00 | QQQ | ETF | 623.68 | 624.49 | 623.4 | 623.82 | 243888.0 |
| 2025-11-04 07:00:00 | QQQ | ETF | 623.9 | 624.51 | 622.92 | 623.61 | 480994.0 |
| 2025-11-04 08:00:00 | QQQ | ETF | 624.58 | 631.606 | 621.09 | 622.66 | 1238404.0 |
| 2025-11-04 09:00:00 | QQQ | ETF | 622.63 | 626.67 | 621.3687 | 626.515 | 8580773.0 |
| 2025-11-04 10:00:00 | QQQ | ETF | 626.5 | 626.95 | 623.81 | 624.41 | 6960514.0 |
| 2025-11-04 11:00:00 | QQQ | ETF | 624.41 | 625.21 | 622.83 | 623.6001 | 4547062.0 |
| 2025-11-04 12:00:00 | QQQ | ETF | 623.6 | 623.635 | 620.8899 | 621.77 | 5038471.0 |
| 2025-11-04 13:00:00 | QQQ | ETF | 621.77 | 621.9 | 619.91 | 621.53 | 5059399.0 |
| 2025-11-04 14:00:00 | QQQ | ETF | 621.5 | 621.97 | 619.23 | 619.97 | 4395399.0 |
| 2025-11-04 15:00:00 | QQQ | ETF | 619.97 | 620.83 | 618.455 | 619.24 | 9352944.0 |
| 2025-11-04 16:00:00 | QQQ | ETF | 619.24 | 619.62 | 617.91 | 619.2 | 2162234.0 |
| 2025-11-04 17:00:00 | QQQ | ETF | 619.23 | 619.3 | 618.1 | 618.2448 | 246022.0 |
| 2025-11-04 18:00:00 | QQQ | ETF | 618.4 | 619.04 | 617.43 | 617.46 | 263886.0 |
| 2025-11-04 19:00:00 | QQQ | ETF | 617.4 | 617.4 | 615.1 | 615.19 | 327636.0 |
| 2025-11-04 04:00:00 | IWM | ETF | 242.15 | 242.15 | 241.05 | 241.14 | 98746.0 |
| 2025-11-04 05:00:00 | IWM | ETF | 241.1 | 242.1 | 240.8 | 242.09 | 142327.0 |
| 2025-11-04 06:00:00 | IWM | ETF | 242.14 | 242.31 | 242.05 | 242.1 | 64655.0 |
| 2025-11-04 07:00:00 | IWM | ETF | 242.13 | 242.54 | 241.6 | 242.44 | 219909.0 |
| 2025-11-04 08:00:00 | IWM | ETF | 242.42 | 244.29 | 241.0197 | 242.12 | 490268.0 |
| 2025-11-04 09:00:00 | IWM | ETF | 242.12 | 243.84 | 241.01 | 243.72 | 4543584.0 |
| 2025-11-04 10:00:00 | IWM | ETF | 243.77 | 244.06 | 242.63 | 243.22 | 3166439.0 |
| 2025-11-04 11:00:00 | IWM | ETF | 243.22 | 243.53 | 242.7 | 243.49 | 1956719.0 |
| 2025-11-04 12:00:00 | IWM | ETF | 243.49 | 243.51 | 242.14 | 242.32 | 2596147.0 |
| 2025-11-04 13:00:00 | IWM | ETF | 242.32 | 242.42 | 241.56 | 242.16 | 2504709.0 |
| 2025-11-04 14:00:00 | IWM | ETF | 242.13 | 242.37 | 241.28 | 241.625 | 2213300.0 |
| 2025-11-04 15:00:00 | IWM | ETF | 241.63 | 242.09 | 240.995 | 241.21 | 5444203.0 |
| 2025-11-04 16:00:00 | IWM | ETF | 241.2 | 241.48 | 241.0 | 241.46 | 1805977.0 |
| 2025-11-04 17:00:00 | IWM | ETF | 241.49 | 241.53 | 241.15 | 241.19 | 69247.0 |
| 2025-11-04 18:00:00 | IWM | ETF | 241.2 | 241.48 | 241.04 | 241.07 | 51125.0 |
| 2025-11-04 19:00:00 | IWM | ETF | 241.02 | 241.03 | 240.2 | 240.22 | 87808.0 |
| 2025-11-04 04:00:00 | DIA | ETF | 470.31 | 470.31 | 468.68 | 468.75 | 6576.0 |
> showing 50 of 28,706 rows — these rows as CSV