PREVIEW / etf_1hour / 2025-10-10
file: by_date/etf_1hour/2025/2025-10-10.parquet size: 741 KB rows: 28,542
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-10-10 04:00:00 | SPY | ETF | 671.94 | 672.42 | 671.9 | 672.25 | 11934.0 |
| 2025-10-10 05:00:00 | SPY | ETF | 672.29 | 672.29 | 670.67 | 670.76 | 26905.0 |
| 2025-10-10 06:00:00 | SPY | ETF | 670.83 | 671.61 | 670.77 | 671.61 | 66185.0 |
| 2025-10-10 07:00:00 | SPY | ETF | 671.63 | 672.19 | 671.59 | 672.15 | 133846.0 |
| 2025-10-10 08:00:00 | SPY | ETF | 672.16 | 672.48 | 670.66 | 671.67 | 180422.0 |
| 2025-10-10 09:00:00 | SPY | ETF | 671.67 | 673.95 | 671.67 | 673.01 | 6663477.0 |
| 2025-10-10 10:00:00 | SPY | ETF | 673.1 | 673.36 | 667.66 | 669.16 | 9778764.0 |
| 2025-10-10 11:00:00 | SPY | ETF | 669.13 | 669.18 | 659.47 | 661.85 | 40278050.0 |
| 2025-10-10 12:00:00 | SPY | ETF | 661.8108 | 662.7556 | 658.91 | 659.12 | 13027969.0 |
| 2025-10-10 13:00:00 | SPY | ETF | 659.11 | 660.93 | 657.74 | 659.59 | 9383342.0 |
| 2025-10-10 14:00:00 | SPY | ETF | 659.63 | 660.09 | 656.78 | 657.18 | 8196490.0 |
| 2025-10-10 15:00:00 | SPY | ETF | 657.18 | 658.26 | 652.84 | 653.11 | 21687529.0 |
| 2025-10-10 16:00:00 | SPY | ETF | 653.11 | 656.6822 | 647.76 | 648.96 | 6770679.0 |
| 2025-10-10 17:00:00 | SPY | ETF | 648.96 | 650.0 | 646.5 | 646.9 | 1090363.0 |
| 2025-10-10 18:00:00 | SPY | ETF | 646.8798 | 651.0 | 646.2 | 650.0 | 864075.0 |
| 2025-10-10 19:00:00 | SPY | ETF | 650.0 | 653.21 | 649.55 | 652.15 | 336076.0 |
| 2025-10-10 04:00:00 | QQQ | ETF | 611.56 | 612.12 | 611.45 | 612.02 | 58818.0 |
| 2025-10-10 05:00:00 | QQQ | ETF | 612.04 | 612.07 | 609.99 | 610.07 | 98801.0 |
| 2025-10-10 06:00:00 | QQQ | ETF | 610.11 | 611.15 | 610.1 | 611.14 | 66378.0 |
| 2025-10-10 07:00:00 | QQQ | ETF | 611.17 | 611.69 | 611.15 | 611.69 | 61123.0 |
| 2025-10-10 08:00:00 | QQQ | ETF | 611.35 | 612.32 | 610.07 | 611.03 | 209145.0 |
| 2025-10-10 09:00:00 | QQQ | ETF | 611.07 | 613.18 | 610.96 | 612.5 | 4094579.0 |
| 2025-10-10 10:00:00 | QQQ | ETF | 612.55 | 612.75 | 606.93 | 608.52 | 4514219.0 |
| 2025-10-10 11:00:00 | QQQ | ETF | 608.47 | 608.54 | 595.93 | 599.74 | 17787118.0 |
| 2025-10-10 12:00:00 | QQQ | ETF | 599.64 | 600.2164 | 595.42 | 595.67 | 6663220.0 |
| 2025-10-10 13:00:00 | QQQ | ETF | 595.64 | 597.89 | 594.33 | 596.18 | 5041178.0 |
| 2025-10-10 14:00:00 | QQQ | ETF | 596.22 | 597.13 | 593.59 | 593.99 | 3557040.0 |
| 2025-10-10 15:00:00 | QQQ | ETF | 594.0 | 595.11 | 589.05 | 589.485 | 11551955.0 |
| 2025-10-10 16:00:00 | QQQ | ETF | 589.47 | 590.58 | 583.68 | 584.98 | 4060662.0 |
| 2025-10-10 17:00:00 | QQQ | ETF | 584.64 | 585.63 | 582.04 | 583.14 | 1600316.0 |
| 2025-10-10 18:00:00 | QQQ | ETF | 583.3 | 588.2 | 583.0801 | 587.53 | 659755.0 |
| 2025-10-10 19:00:00 | QQQ | ETF | 587.5 | 590.56 | 587.5 | 589.93 | 446338.0 |
| 2025-10-10 04:00:00 | IWM | ETF | 245.81 | 246.21 | 245.7 | 246.14 | 37368.0 |
| 2025-10-10 05:00:00 | IWM | ETF | 246.18 | 246.2 | 245.48 | 245.51 | 49623.0 |
| 2025-10-10 06:00:00 | IWM | ETF | 245.53 | 245.89 | 245.51 | 245.86 | 30545.0 |
| 2025-10-10 07:00:00 | IWM | ETF | 245.85 | 246.1 | 245.73 | 246.03 | 60368.0 |
| 2025-10-10 08:00:00 | IWM | ETF | 246.02 | 246.25 | 245.36 | 245.75 | 104024.0 |
| 2025-10-10 09:00:00 | IWM | ETF | 245.76 | 246.885 | 245.59 | 246.19 | 2511384.0 |
| 2025-10-10 10:00:00 | IWM | ETF | 246.16 | 246.38 | 243.26 | 244.01 | 4628465.0 |
| 2025-10-10 11:00:00 | IWM | ETF | 244.0 | 244.04 | 239.68 | 241.395 | 18535274.0 |
| 2025-10-10 12:00:00 | IWM | ETF | 241.4 | 241.93 | 239.98 | 240.11 | 5966205.0 |
| 2025-10-10 13:00:00 | IWM | ETF | 240.08 | 241.41 | 239.28 | 240.48 | 4480373.0 |
| 2025-10-10 14:00:00 | IWM | ETF | 240.49 | 240.805 | 239.305 | 239.42 | 3251901.0 |
| 2025-10-10 15:00:00 | IWM | ETF | 239.41 | 239.92 | 237.56 | 237.8 | 9332828.0 |
| 2025-10-10 16:00:00 | IWM | ETF | 237.78 | 238.46 | 235.22 | 235.34 | 1930459.0 |
| 2025-10-10 17:00:00 | IWM | ETF | 235.49 | 235.71 | 233.39 | 233.7 | 367582.0 |
| 2025-10-10 18:00:00 | IWM | ETF | 233.85 | 236.47 | 233.85 | 235.78 | 156395.0 |
| 2025-10-10 19:00:00 | IWM | ETF | 235.79 | 236.92 | 235.5 | 236.29 | 141278.0 |
| 2025-10-10 04:00:00 | DIA | ETF | 464.12 | 464.28 | 464.12 | 464.15 | 5612.0 |
| 2025-10-10 05:00:00 | DIA | ETF | 464.2 | 464.2 | 463.81 | 463.85 | 2456.0 |
> showing 50 of 28,542 rows — these rows as CSV