PREVIEW / etf_1hour / 2025-12-30
file: by_date/etf_1hour/2025/2025-12-30.parquet size: 714 KB rows: 27,792
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-30 04:00:00 | SPY | ETF | 687.93 | 688.13 | 687.77 | 687.92 | 33506.0 |
| 2025-12-30 05:00:00 | SPY | ETF | 688.03 | 688.03 | 687.62 | 687.66 | 6938.0 |
| 2025-12-30 06:00:00 | SPY | ETF | 687.66 | 687.92 | 687.24 | 687.85 | 11146.0 |
| 2025-12-30 07:00:00 | SPY | ETF | 687.8 | 688.13 | 687.5 | 687.7 | 79468.0 |
| 2025-12-30 08:00:00 | SPY | ETF | 687.69 | 688.16 | 686.92 | 687.75 | 317447.0 |
| 2025-12-30 09:00:00 | SPY | ETF | 687.76 | 688.53 | 686.88 | 688.09 | 4379009.0 |
| 2025-12-30 10:00:00 | SPY | ETF | 688.08 | 688.17 | 686.58 | 687.6104 | 5633131.0 |
| 2025-12-30 11:00:00 | SPY | ETF | 687.6 | 688.555 | 687.2 | 687.23 | 4789897.0 |
| 2025-12-30 12:00:00 | SPY | ETF | 687.22 | 687.71 | 686.87 | 687.635 | 3380744.0 |
| 2025-12-30 13:00:00 | SPY | ETF | 687.635 | 687.93 | 687.22 | 687.765 | 2479761.0 |
| 2025-12-30 14:00:00 | SPY | ETF | 687.76 | 687.94 | 687.4 | 687.56 | 4168065.0 |
| 2025-12-30 15:00:00 | SPY | ETF | 687.56 | 687.815 | 686.7 | 686.94 | 9643001.0 |
| 2025-12-30 16:00:00 | SPY | ETF | 686.95 | 687.14 | 686.77 | 686.97 | 1856620.0 |
| 2025-12-30 17:00:00 | SPY | ETF | 687.01 | 687.03 | 686.92 | 686.94 | 26227.0 |
| 2025-12-30 18:00:00 | SPY | ETF | 687.0 | 687.21 | 686.45 | 686.67 | 43428.0 |
| 2025-12-30 19:00:00 | SPY | ETF | 686.65 | 686.66 | 685.73 | 685.85 | 59108.0 |
| 2025-12-30 04:00:00 | QQQ | ETF | 620.87 | 621.25 | 620.73 | 620.95 | 46737.0 |
| 2025-12-30 05:00:00 | QQQ | ETF | 620.97 | 621.12 | 620.56 | 620.7 | 16440.0 |
| 2025-12-30 06:00:00 | QQQ | ETF | 620.62 | 620.9 | 620.12 | 620.87 | 27173.0 |
| 2025-12-30 07:00:00 | QQQ | ETF | 620.82 | 621.08 | 620.34 | 620.69 | 37262.0 |
| 2025-12-30 08:00:00 | QQQ | ETF | 620.64 | 621.24 | 619.67 | 620.34 | 245391.0 |
| 2025-12-30 09:00:00 | QQQ | ETF | 620.34 | 621.75 | 619.38 | 621.32 | 3703677.0 |
| 2025-12-30 10:00:00 | QQQ | ETF | 621.3 | 621.42 | 619.58 | 621.02 | 4425095.0 |
| 2025-12-30 11:00:00 | QQQ | ETF | 621.03 | 622.18 | 620.4 | 620.47 | 3669745.0 |
| 2025-12-30 12:00:00 | QQQ | ETF | 620.46 | 620.92 | 620.01 | 620.7 | 2515872.0 |
| 2025-12-30 13:00:00 | QQQ | ETF | 620.7 | 621.03 | 620.19 | 620.75 | 2078693.0 |
| 2025-12-30 14:00:00 | QQQ | ETF | 620.73 | 620.98 | 620.15 | 620.3 | 2247967.0 |
| 2025-12-30 15:00:00 | QQQ | ETF | 620.3 | 620.44 | 619.215 | 619.42 | 4906912.0 |
| 2025-12-30 16:00:00 | QQQ | ETF | 619.42 | 619.73 | 619.1 | 619.43 | 875073.0 |
| 2025-12-30 17:00:00 | QQQ | ETF | 619.4492 | 619.59 | 619.4 | 619.4503 | 22897.0 |
| 2025-12-30 18:00:00 | QQQ | ETF | 619.5 | 619.68 | 618.69 | 618.9601 | 57264.0 |
| 2025-12-30 19:00:00 | QQQ | ETF | 618.97 | 618.97 | 617.78 | 617.96 | 105762.0 |
| 2025-12-30 04:00:00 | IWM | ETF | 250.1 | 250.26 | 250.05 | 250.26 | 9853.0 |
| 2025-12-30 05:00:00 | IWM | ETF | 250.28 | 250.38 | 250.19 | 250.19 | 7086.0 |
| 2025-12-30 06:00:00 | IWM | ETF | 250.17 | 250.49 | 250.16 | 250.46 | 11468.0 |
| 2025-12-30 07:00:00 | IWM | ETF | 250.429 | 250.43 | 250.26 | 250.28 | 7471.0 |
| 2025-12-30 08:00:00 | IWM | ETF | 250.4307 | 250.48 | 249.75 | 250.12 | 57990.0 |
| 2025-12-30 09:00:00 | IWM | ETF | 250.12 | 250.15 | 249.105 | 249.585 | 2980493.0 |
| 2025-12-30 10:00:00 | IWM | ETF | 249.585 | 249.61 | 248.73 | 249.4178 | 2879032.0 |
| 2025-12-30 11:00:00 | IWM | ETF | 249.42 | 249.655 | 248.98 | 249.13 | 2063892.0 |
| 2025-12-30 12:00:00 | IWM | ETF | 249.12 | 249.305 | 248.915 | 249.095 | 1233318.0 |
| 2025-12-30 13:00:00 | IWM | ETF | 249.09 | 249.3 | 248.94 | 249.0 | 1596615.0 |
| 2025-12-30 14:00:00 | IWM | ETF | 248.99 | 249.065 | 248.55 | 248.64 | 1904926.0 |
| 2025-12-30 15:00:00 | IWM | ETF | 248.63 | 248.73 | 247.95 | 248.04 | 4467261.0 |
| 2025-12-30 16:00:00 | IWM | ETF | 248.03 | 248.19 | 248.0 | 248.15 | 440130.0 |
| 2025-12-30 17:00:00 | IWM | ETF | 248.14 | 248.246 | 248.06 | 248.246 | 9958.0 |
| 2025-12-30 18:00:00 | IWM | ETF | 248.2 | 248.2 | 247.92 | 248.03 | 21865.0 |
| 2025-12-30 19:00:00 | IWM | ETF | 248.01 | 248.03 | 247.61 | 247.6412 | 14637.0 |
| 2025-12-30 04:00:00 | DIA | ETF | 484.59 | 484.65 | 484.48 | 484.48 | 741.0 |
| 2025-12-30 05:00:00 | DIA | ETF | 484.68 | 484.68 | 484.68 | 484.68 | 80.0 |
> showing 50 of 27,792 rows — these rows as CSV