PREVIEW / etf_1hour / 2025-11-21
file: by_date/etf_1hour/2025/2025-11-21.parquet size: 724 KB rows: 28,539
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-21 04:00:00 | SPY | ETF | 654.64 | 655.25 | 652.09 | 652.16 | 157827.0 |
| 2025-11-21 05:00:00 | SPY | ETF | 652.08 | 653.0 | 649.45 | 652.97 | 238419.0 |
| 2025-11-21 06:00:00 | SPY | ETF | 653.0 | 654.09 | 651.35 | 652.1 | 253922.0 |
| 2025-11-21 07:00:00 | SPY | ETF | 652.2 | 656.54 | 650.02 | 655.44 | 1209511.0 |
| 2025-11-21 08:00:00 | SPY | ETF | 652.17 | 656.75 | 649.47 | 655.97 | 1199603.0 |
| 2025-11-21 09:00:00 | SPY | ETF | 655.86 | 656.47 | 653.13 | 654.52 | 11547167.0 |
| 2025-11-21 10:00:00 | SPY | ETF | 654.57 | 655.94 | 650.85 | 652.77 | 15899161.0 |
| 2025-11-21 11:00:00 | SPY | ETF | 652.72 | 660.695 | 651.08 | 660.64 | 11510135.0 |
| 2025-11-21 12:00:00 | SPY | ETF | 660.63 | 661.5118 | 659.36 | 660.16 | 9756424.0 |
| 2025-11-21 13:00:00 | SPY | ETF | 660.21 | 664.09 | 656.88 | 662.25 | 10682154.0 |
| 2025-11-21 14:00:00 | SPY | ETF | 662.2352 | 664.55 | 660.95 | 661.75 | 9400916.0 |
| 2025-11-21 15:00:00 | SPY | ETF | 661.73 | 662.2 | 658.23 | 659.06 | 16988213.0 |
| 2025-11-21 16:00:00 | SPY | ETF | 659.08 | 660.04 | 658.86 | 659.77 | 3867729.0 |
| 2025-11-21 17:00:00 | SPY | ETF | 659.81 | 660.03 | 659.03 | 659.6 | 429922.0 |
| 2025-11-21 18:00:00 | SPY | ETF | 659.55 | 659.8392 | 659.27 | 659.37 | 72432.0 |
| 2025-11-21 19:00:00 | SPY | ETF | 659.57 | 660.1752 | 659.41 | 660.1375 | 35810.0 |
| 2025-11-21 04:00:00 | QQQ | ETF | 587.0 | 587.83 | 583.29 | 583.4 | 378608.0 |
| 2025-11-21 05:00:00 | QQQ | ETF | 583.45 | 584.85 | 580.27 | 584.75 | 592639.0 |
| 2025-11-21 06:00:00 | QQQ | ETF | 584.8 | 586.25 | 582.8 | 583.83 | 720343.0 |
| 2025-11-21 07:00:00 | QQQ | ETF | 583.93 | 588.88 | 581.38 | 587.14 | 1981644.0 |
| 2025-11-21 08:00:00 | QQQ | ETF | 583.43 | 589.63 | 580.36 | 588.45 | 1883557.0 |
| 2025-11-21 09:00:00 | QQQ | ETF | 588.38 | 589.77 | 585.02 | 586.892 | 10179014.0 |
| 2025-11-21 10:00:00 | QQQ | ETF | 586.91 | 588.1 | 580.74 | 583.04 | 16780278.0 |
| 2025-11-21 11:00:00 | QQQ | ETF | 583.02 | 591.6156 | 580.95 | 591.59 | 10176911.0 |
| 2025-11-21 12:00:00 | QQQ | ETF | 591.59 | 592.61 | 589.96 | 591.01 | 7270000.0 |
| 2025-11-21 13:00:00 | QQQ | ETF | 591.04 | 596.03 | 587.46 | 594.05 | 8637760.0 |
| 2025-11-21 14:00:00 | QQQ | ETF | 594.08 | 596.98 | 592.86 | 593.64 | 8021123.0 |
| 2025-11-21 15:00:00 | QQQ | ETF | 593.63 | 594.56 | 589.44 | 590.16 | 11708150.0 |
| 2025-11-21 16:00:00 | QQQ | ETF | 590.13 | 591.2 | 589.663 | 590.94 | 2607410.0 |
| 2025-11-21 17:00:00 | QQQ | ETF | 590.96 | 591.1 | 590.81 | 590.85 | 49113.0 |
| 2025-11-21 18:00:00 | QQQ | ETF | 590.85 | 591.4 | 590.52 | 591.33 | 44289.0 |
| 2025-11-21 19:00:00 | QQQ | ETF | 591.2104 | 592.07 | 591.2 | 592.06 | 34649.0 |
| 2025-11-21 04:00:00 | IWM | ETF | 230.38 | 230.45 | 229.03 | 229.18 | 62476.0 |
| 2025-11-21 05:00:00 | IWM | ETF | 228.99 | 229.35 | 228.17 | 229.32 | 71202.0 |
| 2025-11-21 06:00:00 | IWM | ETF | 229.34 | 229.88 | 228.72 | 229.0 | 97829.0 |
| 2025-11-21 07:00:00 | IWM | ETF | 228.95 | 231.6 | 228.23 | 231.33 | 537860.0 |
| 2025-11-21 08:00:00 | IWM | ETF | 228.98 | 231.53 | 228.23 | 231.03 | 550706.0 |
| 2025-11-21 09:00:00 | IWM | ETF | 231.02 | 231.35 | 229.58 | 230.86 | 7005577.0 |
| 2025-11-21 10:00:00 | IWM | ETF | 230.86 | 231.98 | 229.67 | 231.27 | 13685394.0 |
| 2025-11-21 11:00:00 | IWM | ETF | 231.26 | 235.67 | 230.57 | 235.65 | 11162938.0 |
| 2025-11-21 12:00:00 | IWM | ETF | 235.65 | 236.07 | 235.01 | 235.63 | 8351923.0 |
| 2025-11-21 13:00:00 | IWM | ETF | 235.63 | 236.65 | 234.45 | 235.95 | 8949370.0 |
| 2025-11-21 14:00:00 | IWM | ETF | 235.95 | 237.11 | 235.89 | 236.29 | 6720025.0 |
| 2025-11-21 15:00:00 | IWM | ETF | 236.28 | 236.57 | 235.33 | 235.61 | 11477791.0 |
| 2025-11-21 16:00:00 | IWM | ETF | 235.62 | 235.96 | 235.44 | 235.95 | 1360364.0 |
| 2025-11-21 17:00:00 | IWM | ETF | 235.85 | 236.0 | 235.6801 | 235.86 | 3094.0 |
| 2025-11-21 18:00:00 | IWM | ETF | 235.89 | 236.17 | 235.73 | 236.09 | 5661.0 |
| 2025-11-21 19:00:00 | IWM | ETF | 235.73 | 236.34 | 235.73 | 236.29 | 5484.0 |
| 2025-11-21 04:00:00 | DIA | ETF | 459.61 | 459.61 | 459.07 | 459.22 | 2868.0 |
| 2025-11-21 05:00:00 | DIA | ETF | 458.83 | 459.36 | 457.69 | 459.33 | 3788.0 |
> showing 50 of 28,539 rows — these rows as CSV