PREVIEW / etf_1hour / 2025-11-20
file: by_date/etf_1hour/2025/2025-11-20.parquet size: 732 KB rows: 28,584
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-20 04:00:00 | SPY | ETF | 670.98 | 670.99 | 669.01 | 669.34 | 56619.0 |
| 2025-11-20 05:00:00 | SPY | ETF | 669.32 | 671.0 | 668.91 | 670.86 | 129079.0 |
| 2025-11-20 06:00:00 | SPY | ETF | 670.86 | 670.86 | 669.4 | 669.75 | 87922.0 |
| 2025-11-20 07:00:00 | SPY | ETF | 669.8 | 671.169 | 669.01 | 671.06 | 310565.0 |
| 2025-11-20 08:00:00 | SPY | ETF | 669.95 | 673.67 | 669.02 | 673.22 | 1306599.0 |
| 2025-11-20 09:00:00 | SPY | ETF | 673.24 | 675.02 | 672.47 | 674.91 | 11411336.0 |
| 2025-11-20 10:00:00 | SPY | ETF | 674.92 | 675.56 | 672.74 | 672.76 | 11300794.0 |
| 2025-11-20 11:00:00 | SPY | ETF | 672.78 | 672.82 | 659.39 | 660.2 | 26413004.0 |
| 2025-11-20 12:00:00 | SPY | ETF | 660.19 | 662.38 | 655.45 | 657.26 | 26225996.0 |
| 2025-11-20 13:00:00 | SPY | ETF | 657.29 | 661.97 | 654.12 | 655.06 | 16017831.0 |
| 2025-11-20 14:00:00 | SPY | ETF | 655.04 | 658.25 | 653.86 | 658.11 | 11669434.0 |
| 2025-11-20 15:00:00 | SPY | ETF | 658.12 | 658.13 | 651.89 | 652.53 | 23290273.0 |
| 2025-11-20 16:00:00 | SPY | ETF | 652.52 | 652.83 | 651.69 | 651.87 | 5321886.0 |
| 2025-11-20 17:00:00 | SPY | ETF | 651.88 | 652.31 | 651.72 | 652.28 | 330036.0 |
| 2025-11-20 18:00:00 | SPY | ETF | 652.28 | 653.7 | 650.7 | 653.12 | 495903.0 |
| 2025-11-20 19:00:00 | SPY | ETF | 653.24 | 654.71 | 652.87 | 654.3985 | 230432.0 |
| 2025-11-20 04:00:00 | QQQ | ETF | 610.5 | 611.0 | 607.73 | 607.99 | 175512.0 |
| 2025-11-20 05:00:00 | QQQ | ETF | 608.1 | 609.56 | 607.13 | 609.28 | 143406.0 |
| 2025-11-20 06:00:00 | QQQ | ETF | 609.24 | 609.6 | 607.72 | 608.73 | 320201.0 |
| 2025-11-20 07:00:00 | QQQ | ETF | 608.67 | 610.32 | 608.01 | 610.3 | 268380.0 |
| 2025-11-20 08:00:00 | QQQ | ETF | 610.28 | 612.91 | 600.319 | 612.0884 | 1637268.0 |
| 2025-11-20 09:00:00 | QQQ | ETF | 612.09 | 613.5601 | 610.03 | 613.16 | 9961166.0 |
| 2025-11-20 10:00:00 | QQQ | ETF | 613.19 | 614.03 | 610.34 | 610.48 | 10503327.0 |
| 2025-11-20 11:00:00 | QQQ | ETF | 610.49 | 610.53 | 594.74 | 595.765 | 18927247.0 |
| 2025-11-20 12:00:00 | QQQ | ETF | 595.75 | 597.91 | 589.83 | 591.9344 | 18041355.0 |
| 2025-11-20 13:00:00 | QQQ | ETF | 591.94 | 596.8901 | 588.1 | 589.16 | 12704911.0 |
| 2025-11-20 14:00:00 | QQQ | ETF | 589.13 | 592.1 | 587.34 | 591.98 | 8946244.0 |
| 2025-11-20 15:00:00 | QQQ | ETF | 591.96 | 591.96 | 584.75 | 585.6728 | 11344646.0 |
| 2025-11-20 16:00:00 | QQQ | ETF | 585.69 | 585.74 | 584.13 | 584.25 | 2254012.0 |
| 2025-11-20 17:00:00 | QQQ | ETF | 584.29 | 584.36 | 583.42 | 584.24 | 264367.0 |
| 2025-11-20 18:00:00 | QQQ | ETF | 584.28 | 586.3599 | 582.8 | 585.57 | 681432.0 |
| 2025-11-20 19:00:00 | QQQ | ETF | 585.55 | 587.26 | 585.1 | 586.82 | 266622.0 |
| 2025-11-20 04:00:00 | IWM | ETF | 235.48 | 235.7 | 234.7 | 234.78 | 41781.0 |
| 2025-11-20 05:00:00 | IWM | ETF | 234.84 | 235.45 | 234.76 | 235.36 | 15997.0 |
| 2025-11-20 06:00:00 | IWM | ETF | 235.28 | 235.3 | 234.49 | 234.69 | 25859.0 |
| 2025-11-20 07:00:00 | IWM | ETF | 234.77 | 235.57 | 234.5 | 235.57 | 120551.0 |
| 2025-11-20 08:00:00 | IWM | ETF | 234.7297 | 236.77 | 234.5299 | 236.46 | 711659.0 |
| 2025-11-20 09:00:00 | IWM | ETF | 236.49 | 238.53 | 236.49 | 238.38 | 7009132.0 |
| 2025-11-20 10:00:00 | IWM | ETF | 238.39 | 239.1 | 237.3 | 237.3001 | 7073758.0 |
| 2025-11-20 11:00:00 | IWM | ETF | 237.31 | 237.38 | 232.5 | 232.75 | 13071942.0 |
| 2025-11-20 12:00:00 | IWM | ETF | 232.75 | 233.755 | 230.77 | 231.52 | 15624960.0 |
| 2025-11-20 13:00:00 | IWM | ETF | 231.52 | 233.545 | 230.25 | 230.59 | 9534058.0 |
| 2025-11-20 14:00:00 | IWM | ETF | 230.6 | 231.66 | 230.21 | 231.61 | 7776137.0 |
| 2025-11-20 15:00:00 | IWM | ETF | 231.61 | 231.61 | 228.9 | 229.13 | 13629098.0 |
| 2025-11-20 16:00:00 | IWM | ETF | 229.15 | 229.4 | 228.81 | 228.97 | 1626602.0 |
| 2025-11-20 17:00:00 | IWM | ETF | 228.92 | 229.05 | 228.62 | 228.79 | 74983.0 |
| 2025-11-20 18:00:00 | IWM | ETF | 228.81 | 229.37 | 228.44 | 229.22 | 111331.0 |
| 2025-11-20 19:00:00 | IWM | ETF | 229.25 | 229.98 | 229.11 | 229.88 | 58584.0 |
| 2025-11-20 04:00:00 | DIA | ETF | 464.3 | 464.38 | 463.76 | 463.76 | 695.0 |
| 2025-11-20 05:00:00 | DIA | ETF | 463.79 | 464.43 | 463.79 | 464.37 | 962.0 |
> showing 50 of 28,584 rows — these rows as CSV