PREVIEW / etf_1hour / 2025-01-28
file: by_date/etf_1hour/2025/2025-01-28.parquet size: 628 KB rows: 23,581
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-28 04:00:00 | SPY | ETF | 601.0 | 601.57 | 600.95 | 601.55 | 23889.0 |
| 2025-01-28 05:00:00 | SPY | ETF | 601.77 | 602.1 | 601.67 | 601.67 | 21679.0 |
| 2025-01-28 06:00:00 | SPY | ETF | 601.84 | 602.02 | 600.69 | 600.83 | 45810.0 |
| 2025-01-28 07:00:00 | SPY | ETF | 600.83 | 600.91 | 599.5 | 600.62 | 318666.0 |
| 2025-01-28 08:00:00 | SPY | ETF | 599.97 | 601.39 | 598.85 | 600.25 | 194665.0 |
| 2025-01-28 09:00:00 | SPY | ETF | 600.27 | 600.78 | 597.25 | 598.9351 | 3930543.0 |
| 2025-01-28 10:00:00 | SPY | ETF | 598.9 | 603.09 | 598.842 | 603.06 | 4863943.0 |
| 2025-01-28 11:00:00 | SPY | ETF | 603.06 | 603.57 | 600.95 | 602.57 | 2841494.0 |
| 2025-01-28 12:00:00 | SPY | ETF | 602.565 | 604.08 | 602.4 | 603.8308 | 2127745.0 |
| 2025-01-28 13:00:00 | SPY | ETF | 603.85 | 604.79 | 603.56 | 603.8002 | 1901379.0 |
| 2025-01-28 14:00:00 | SPY | ETF | 603.79 | 605.26 | 603.23 | 605.14 | 2302420.0 |
| 2025-01-28 15:00:00 | SPY | ETF | 605.14 | 605.37 | 604.36 | 604.49 | 7167852.0 |
| 2025-01-28 16:00:00 | SPY | ETF | 604.47 | 604.64 | 603.475 | 604.0 | 3472730.0 |
| 2025-01-28 17:00:00 | SPY | ETF | 604.05 | 604.05 | 603.93 | 603.97 | 58870.0 |
| 2025-01-28 18:00:00 | SPY | ETF | 603.78 | 604.24 | 603.53 | 603.6 | 92297.0 |
| 2025-01-28 19:00:00 | SPY | ETF | 603.6 | 604.1 | 603.6 | 604.1 | 39944.0 |
| 2025-01-28 04:00:00 | QQQ | ETF | 517.42 | 517.67 | 516.27 | 517.5 | 88065.0 |
| 2025-01-28 05:00:00 | QQQ | ETF | 517.4 | 518.1 | 517.31 | 517.36 | 107320.0 |
| 2025-01-28 06:00:00 | QQQ | ETF | 517.52 | 517.82 | 515.87 | 516.14 | 125220.0 |
| 2025-01-28 07:00:00 | QQQ | ETF | 516.19 | 516.3 | 514.16 | 515.25 | 270878.0 |
| 2025-01-28 08:00:00 | QQQ | ETF | 514.28 | 517.5096 | 513.825 | 515.18 | 417039.0 |
| 2025-01-28 09:00:00 | QQQ | ETF | 515.1 | 515.63 | 511.78 | 514.75 | 3637191.0 |
| 2025-01-28 10:00:00 | QQQ | ETF | 514.82 | 519.55 | 514.73 | 518.9 | 4870901.0 |
| 2025-01-28 11:00:00 | QQQ | ETF | 518.96 | 519.4616 | 517.2934 | 519.35 | 2585866.0 |
| 2025-01-28 12:00:00 | QQQ | ETF | 519.33 | 521.52 | 519.28 | 521.03 | 2074311.0 |
| 2025-01-28 13:00:00 | QQQ | ETF | 521.04 | 521.9873 | 520.52 | 520.92 | 1424367.0 |
| 2025-01-28 14:00:00 | QQQ | ETF | 520.92 | 523.0 | 520.32 | 522.76 | 2277064.0 |
| 2025-01-28 15:00:00 | QQQ | ETF | 522.78 | 522.95 | 521.37 | 521.86 | 4534726.0 |
| 2025-01-28 16:00:00 | QQQ | ETF | 521.84 | 521.87 | 521.23 | 521.29 | 1574151.0 |
| 2025-01-28 17:00:00 | QQQ | ETF | 521.33 | 521.45 | 521.02 | 521.3 | 57452.0 |
| 2025-01-28 18:00:00 | QQQ | ETF | 521.33 | 521.8596 | 520.81 | 521.07 | 81607.0 |
| 2025-01-28 19:00:00 | QQQ | ETF | 521.01 | 521.72 | 520.92 | 521.64 | 48873.0 |
| 2025-01-28 04:00:00 | IWM | ETF | 226.34 | 226.74 | 226.34 | 226.52 | 10610.0 |
| 2025-01-28 05:00:00 | IWM | ETF | 226.53 | 226.75 | 226.35 | 226.35 | 9183.0 |
| 2025-01-28 06:00:00 | IWM | ETF | 226.49 | 226.49 | 226.16 | 226.26 | 10900.0 |
| 2025-01-28 07:00:00 | IWM | ETF | 226.24 | 226.6 | 226.08 | 226.55 | 34052.0 |
| 2025-01-28 08:00:00 | IWM | ETF | 226.4286 | 226.62 | 225.23 | 226.26 | 37434.0 |
| 2025-01-28 09:00:00 | IWM | ETF | 226.27 | 227.21 | 225.88 | 226.27 | 1856082.0 |
| 2025-01-28 10:00:00 | IWM | ETF | 226.27 | 227.29 | 226.04 | 226.81 | 2116292.0 |
| 2025-01-28 11:00:00 | IWM | ETF | 226.825 | 227.115 | 225.18 | 225.62 | 1930291.0 |
| 2025-01-28 12:00:00 | IWM | ETF | 225.595 | 226.4 | 225.56 | 225.72 | 1093811.0 |
| 2025-01-28 13:00:00 | IWM | ETF | 225.73 | 226.57 | 225.73 | 225.93 | 1235611.0 |
| 2025-01-28 14:00:00 | IWM | ETF | 225.93 | 227.15 | 225.78 | 227.0 | 1322918.0 |
| 2025-01-28 15:00:00 | IWM | ETF | 227.015 | 227.56 | 226.65 | 226.77 | 2833543.0 |
| 2025-01-28 16:00:00 | IWM | ETF | 226.75 | 226.76 | 226.59 | 226.68 | 483694.0 |
| 2025-01-28 17:00:00 | IWM | ETF | 226.66 | 226.74 | 226.27 | 226.6 | 4390.0 |
| 2025-01-28 18:00:00 | IWM | ETF | 226.63 | 226.86 | 226.56 | 226.63 | 14072.0 |
| 2025-01-28 19:00:00 | IWM | ETF | 226.66 | 226.94 | 226.63 | 226.9394 | 19407.0 |
| 2025-01-28 04:00:00 | DIA | ETF | 447.54 | 447.58 | 447.38 | 447.54 | 1318.0 |
| 2025-01-28 05:00:00 | DIA | ETF | 447.7 | 447.79 | 447.66 | 447.67 | 3369.0 |
> showing 50 of 23,581 rows — these rows as CSV