PREVIEW / etf_1hour / 2025-12-29
file: by_date/etf_1hour/2025/2025-12-29.parquet size: 728 KB rows: 28,263
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-12-29 04:00:00 | SPY | ETF | 690.02 | 690.02 | 688.36 | 688.75 | 27572.0 |
| 2025-12-29 05:00:00 | SPY | ETF | 688.87 | 689.09 | 688.65 | 688.69 | 10583.0 |
| 2025-12-29 06:00:00 | SPY | ETF | 688.77 | 689.08 | 688.46 | 689.0 | 21411.0 |
| 2025-12-29 07:00:00 | SPY | ETF | 689.05 | 689.07 | 688.04 | 688.39 | 88559.0 |
| 2025-12-29 08:00:00 | SPY | ETF | 688.39 | 690.05 | 687.02 | 687.6488 | 467128.0 |
| 2025-12-29 09:00:00 | SPY | ETF | 687.67 | 689.2 | 686.67 | 687.56 | 7066590.0 |
| 2025-12-29 10:00:00 | SPY | ETF | 687.56 | 688.4 | 686.82 | 687.35 | 6249381.0 |
| 2025-12-29 11:00:00 | SPY | ETF | 687.35 | 687.6376 | 686.69 | 687.08 | 4625604.0 |
| 2025-12-29 12:00:00 | SPY | ETF | 687.08 | 687.23 | 686.07 | 686.99 | 3807645.0 |
| 2025-12-29 13:00:00 | SPY | ETF | 686.99 | 687.89 | 686.79 | 687.225 | 4307707.0 |
| 2025-12-29 14:00:00 | SPY | ETF | 687.22 | 688.46 | 686.87 | 688.3 | 6442347.0 |
| 2025-12-29 15:00:00 | SPY | ETF | 688.3 | 688.62 | 687.4 | 687.84 | 12031124.0 |
| 2025-12-29 16:00:00 | SPY | ETF | 687.84 | 688.02 | 687.54 | 687.98 | 1535663.0 |
| 2025-12-29 17:00:00 | SPY | ETF | 687.99 | 688.05 | 687.87 | 687.931 | 45516.0 |
| 2025-12-29 18:00:00 | SPY | ETF | 687.98 | 688.0 | 687.4 | 687.48 | 51315.0 |
| 2025-12-29 19:00:00 | SPY | ETF | 687.46 | 687.76 | 687.33 | 687.34 | 11484.0 |
| 2025-12-29 04:00:00 | QQQ | ETF | 620.96 | 622.85 | 620.77 | 621.44 | 95024.0 |
| 2025-12-29 05:00:00 | QQQ | ETF | 621.36 | 621.6 | 621.0 | 621.04 | 23597.0 |
| 2025-12-29 06:00:00 | QQQ | ETF | 621.0 | 621.71 | 620.8 | 621.57 | 33984.0 |
| 2025-12-29 07:00:00 | QQQ | ETF | 621.6 | 621.79 | 620.8 | 621.08 | 103373.0 |
| 2025-12-29 08:00:00 | QQQ | ETF | 621.02 | 624.357 | 619.01 | 619.78 | 472362.0 |
| 2025-12-29 09:00:00 | QQQ | ETF | 619.81 | 622.78 | 618.92 | 620.48 | 5905248.0 |
| 2025-12-29 10:00:00 | QQQ | ETF | 620.48 | 621.69 | 619.03 | 620.02 | 4942912.0 |
| 2025-12-29 11:00:00 | QQQ | ETF | 620.01 | 620.38 | 619.485 | 619.86 | 2593584.0 |
| 2025-12-29 12:00:00 | QQQ | ETF | 619.86 | 620.13 | 618.73 | 619.95 | 2658250.0 |
| 2025-12-29 13:00:00 | QQQ | ETF | 619.94 | 620.66 | 619.5 | 619.84 | 2138557.0 |
| 2025-12-29 14:00:00 | QQQ | ETF | 619.83 | 621.695 | 619.59 | 621.49 | 2737721.0 |
| 2025-12-29 15:00:00 | QQQ | ETF | 621.495 | 621.51 | 620.61 | 620.88 | 3921250.0 |
| 2025-12-29 16:00:00 | QQQ | ETF | 620.88 | 621.03 | 620.58 | 620.96 | 589242.0 |
| 2025-12-29 17:00:00 | QQQ | ETF | 620.96 | 620.98 | 620.75 | 620.7812 | 16535.0 |
| 2025-12-29 18:00:00 | QQQ | ETF | 620.85 | 620.92 | 620.081 | 620.09 | 71423.0 |
| 2025-12-29 19:00:00 | QQQ | ETF | 620.08 | 620.52 | 619.91 | 619.9564 | 44369.0 |
| 2025-12-29 04:00:00 | IWM | ETF | 251.24 | 251.48 | 251.17 | 251.38 | 25239.0 |
| 2025-12-29 05:00:00 | IWM | ETF | 251.38 | 251.53 | 251.23 | 251.36 | 7322.0 |
| 2025-12-29 06:00:00 | IWM | ETF | 251.29 | 251.45 | 251.19 | 251.39 | 7497.0 |
| 2025-12-29 07:00:00 | IWM | ETF | 251.4 | 251.41 | 250.55 | 250.67 | 37169.0 |
| 2025-12-29 08:00:00 | IWM | ETF | 251.19 | 251.72 | 250.24 | 250.64 | 102359.0 |
| 2025-12-29 09:00:00 | IWM | ETF | 250.57 | 251.5 | 250.0806 | 250.275 | 2366032.0 |
| 2025-12-29 10:00:00 | IWM | ETF | 250.27 | 250.335 | 249.49 | 249.55 | 2962663.0 |
| 2025-12-29 11:00:00 | IWM | ETF | 249.55 | 250.14 | 249.46 | 249.84 | 2296321.0 |
| 2025-12-29 12:00:00 | IWM | ETF | 249.844 | 249.92 | 249.35 | 249.795 | 1504008.0 |
| 2025-12-29 13:00:00 | IWM | ETF | 249.795 | 250.0474 | 249.54 | 249.56 | 1708266.0 |
| 2025-12-29 14:00:00 | IWM | ETF | 249.55 | 249.965 | 249.4 | 249.86 | 2024943.0 |
| 2025-12-29 15:00:00 | IWM | ETF | 249.85 | 250.165 | 249.56 | 249.87 | 6078674.0 |
| 2025-12-29 16:00:00 | IWM | ETF | 249.88 | 249.91 | 249.72 | 249.85 | 718797.0 |
| 2025-12-29 17:00:00 | IWM | ETF | 249.86 | 249.9 | 249.76 | 249.9 | 8103.0 |
| 2025-12-29 18:00:00 | IWM | ETF | 249.89 | 249.94 | 249.79 | 249.82 | 13463.0 |
| 2025-12-29 19:00:00 | IWM | ETF | 249.87 | 249.97 | 249.81 | 249.81 | 12069.0 |
| 2025-12-29 04:00:00 | DIA | ETF | 486.72 | 486.98 | 486.67 | 486.98 | 1030.0 |
| 2025-12-29 05:00:00 | DIA | ETF | 487.06 | 487.25 | 487.06 | 487.12 | 404.0 |
> showing 50 of 28,263 rows — these rows as CSV