PREVIEW / etf_1hour / 2025-01-08
file: by_date/etf_1hour/2025/2025-01-08.parquet size: 610 KB rows: 23,510
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-01-08 04:00:00 | SPY | ETF | 589.8 | 590.54 | 589.8 | 590.33 | 22592.0 |
| 2025-01-08 05:00:00 | SPY | ETF | 590.52 | 590.8 | 590.44 | 590.77 | 13450.0 |
| 2025-01-08 06:00:00 | SPY | ETF | 590.84 | 590.84 | 587.05 | 588.8 | 147888.0 |
| 2025-01-08 07:00:00 | SPY | ETF | 588.9 | 588.9 | 586.07 | 586.75 | 453925.0 |
| 2025-01-08 08:00:00 | SPY | ETF | 587.77 | 590.6 | 586.1999 | 589.19 | 686535.0 |
| 2025-01-08 09:00:00 | SPY | ETF | 589.28 | 589.42 | 586.5001 | 587.38 | 3750853.0 |
| 2025-01-08 10:00:00 | SPY | ETF | 587.3 | 588.73 | 586.0 | 588.42 | 4087973.0 |
| 2025-01-08 11:00:00 | SPY | ETF | 588.42 | 589.94 | 587.205 | 589.43 | 2453541.0 |
| 2025-01-08 12:00:00 | SPY | ETF | 589.4254 | 589.4594 | 585.195 | 586.9432 | 2832091.0 |
| 2025-01-08 13:00:00 | SPY | ETF | 586.94 | 589.57 | 586.88 | 587.77 | 2593652.0 |
| 2025-01-08 14:00:00 | SPY | ETF | 587.8 | 590.5799 | 587.09 | 588.53 | 3869502.0 |
| 2025-01-08 15:00:00 | SPY | ETF | 588.54 | 589.79 | 587.88 | 589.42 | 6010827.0 |
| 2025-01-08 16:00:00 | SPY | ETF | 589.415 | 590.0 | 588.59 | 588.96 | 2182075.0 |
| 2025-01-08 17:00:00 | SPY | ETF | 588.91 | 589.14 | 588.91 | 588.95 | 99408.0 |
| 2025-01-08 18:00:00 | SPY | ETF | 588.95 | 589.0655 | 588.41 | 588.41 | 38475.0 |
| 2025-01-08 19:00:00 | SPY | ETF | 588.55 | 588.57 | 587.53 | 588.17 | 91910.0 |
| 2025-01-08 04:00:00 | QQQ | ETF | 516.54 | 517.02 | 516.54 | 516.9 | 16997.0 |
| 2025-01-08 05:00:00 | QQQ | ETF | 516.99 | 517.38 | 516.89 | 517.38 | 11236.0 |
| 2025-01-08 06:00:00 | QQQ | ETF | 517.3 | 517.38 | 513.5 | 515.29 | 165036.0 |
| 2025-01-08 07:00:00 | QQQ | ETF | 515.39 | 515.39 | 511.92 | 512.83 | 357400.0 |
| 2025-01-08 08:00:00 | QQQ | ETF | 514.84 | 517.25 | 511.9393 | 515.58 | 680501.0 |
| 2025-01-08 09:00:00 | QQQ | ETF | 515.62 | 515.89 | 513.41 | 514.8 | 2644508.0 |
| 2025-01-08 10:00:00 | QQQ | ETF | 514.73 | 516.29 | 512.1 | 515.08 | 2947112.0 |
| 2025-01-08 11:00:00 | QQQ | ETF | 515.11 | 516.5703 | 513.41 | 515.83 | 1960725.0 |
| 2025-01-08 12:00:00 | QQQ | ETF | 515.83 | 515.83 | 510.57 | 513.0 | 2627637.0 |
| 2025-01-08 13:00:00 | QQQ | ETF | 512.99 | 516.28 | 512.93 | 514.3701 | 2673814.0 |
| 2025-01-08 14:00:00 | QQQ | ETF | 514.43 | 516.9199 | 513.49 | 514.69 | 2440029.0 |
| 2025-01-08 15:00:00 | QQQ | ETF | 514.71 | 515.69 | 513.85 | 515.3 | 2998875.0 |
| 2025-01-08 16:00:00 | QQQ | ETF | 515.31 | 516.0 | 514.0 | 514.4999 | 1403766.0 |
| 2025-01-08 17:00:00 | QQQ | ETF | 514.47 | 514.5 | 514.23 | 514.5 | 103410.0 |
| 2025-01-08 18:00:00 | QQQ | ETF | 514.46 | 514.88 | 514.2 | 514.2 | 55988.0 |
| 2025-01-08 19:00:00 | QQQ | ETF | 514.3 | 514.34 | 513.14 | 513.9301 | 66802.0 |
| 2025-01-08 04:00:00 | IWM | ETF | 222.96 | 223.04 | 222.8 | 222.88 | 15510.0 |
| 2025-01-08 05:00:00 | IWM | ETF | 222.97 | 222.98 | 222.79 | 222.87 | 9617.0 |
| 2025-01-08 06:00:00 | IWM | ETF | 222.79 | 222.8 | 220.55 | 221.52 | 75871.0 |
| 2025-01-08 07:00:00 | IWM | ETF | 221.5 | 221.5 | 219.98 | 220.53 | 176864.0 |
| 2025-01-08 08:00:00 | IWM | ETF | 221.01 | 223.21 | 220.0702 | 221.35 | 217824.0 |
| 2025-01-08 09:00:00 | IWM | ETF | 221.43 | 221.66 | 219.29 | 219.41 | 3225237.0 |
| 2025-01-08 10:00:00 | IWM | ETF | 219.405 | 220.72 | 219.0121 | 220.63 | 2785687.0 |
| 2025-01-08 11:00:00 | IWM | ETF | 220.65 | 221.54 | 220.06 | 221.27 | 2316989.0 |
| 2025-01-08 12:00:00 | IWM | ETF | 221.27 | 221.35 | 219.76 | 220.48 | 1936773.0 |
| 2025-01-08 13:00:00 | IWM | ETF | 220.47 | 221.8712 | 220.39 | 220.935 | 2282406.0 |
| 2025-01-08 14:00:00 | IWM | ETF | 220.97 | 222.31 | 220.67 | 221.56 | 2867179.0 |
| 2025-01-08 15:00:00 | IWM | ETF | 221.58 | 221.85 | 221.15 | 221.72 | 2733478.0 |
| 2025-01-08 16:00:00 | IWM | ETF | 221.71 | 222.0 | 221.37 | 221.77 | 936963.0 |
| 2025-01-08 17:00:00 | IWM | ETF | 221.62 | 221.79 | 221.61 | 221.63 | 3121.0 |
| 2025-01-08 18:00:00 | IWM | ETF | 221.62 | 221.76 | 221.37 | 221.39 | 16592.0 |
| 2025-01-08 19:00:00 | IWM | ETF | 221.36 | 221.4299 | 221.04 | 221.33 | 7529.0 |
| 2025-01-08 04:00:00 | DIA | ETF | 426.23 | 426.35 | 426.15 | 426.32 | 800.0 |
| 2025-01-08 05:00:00 | DIA | ETF | 426.5 | 426.5 | 426.5 | 426.5 | 200.0 |
> showing 50 of 23,510 rows — these rows as CSV