PREVIEW / etf_1hour / 2026-05-28
file: by_date/etf_1hour/2026/2026-05-28.parquet size: 717 KB rows: 28,612
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 |
|---|---|---|---|---|---|---|---|
| 2026-05-28 04:00:00 | SPY | ETF | 748.67 | 750.1 | 747.38 | 749.98 | 63367.0 |
| 2026-05-28 05:00:00 | SPY | ETF | 749.94 | 750.23 | 749.48 | 749.87 | 15343.0 |
| 2026-05-28 06:00:00 | SPY | ETF | 749.85 | 749.9 | 748.2 | 748.57 | 61930.0 |
| 2026-05-28 07:00:00 | SPY | ETF | 748.59 | 749.12 | 748.38 | 748.88 | 220894.0 |
| 2026-05-28 08:00:00 | SPY | ETF | 748.94 | 750.6196 | 748.77 | 750.52 | 186847.0 |
| 2026-05-28 09:00:00 | SPY | ETF | 750.56 | 751.08 | 749.23 | 750.17 | 2942681.0 |
| 2026-05-28 10:00:00 | SPY | ETF | 750.2 | 754.07 | 749.99 | 752.8799 | 5995623.0 |
| 2026-05-28 11:00:00 | SPY | ETF | 752.87 | 754.29 | 752.75 | 754.08 | 3114137.0 |
| 2026-05-28 12:00:00 | SPY | ETF | 754.08 | 754.8501 | 753.69 | 754.72 | 2074795.0 |
| 2026-05-28 13:00:00 | SPY | ETF | 754.73 | 754.93 | 754.1 | 754.7 | 2253427.0 |
| 2026-05-28 14:00:00 | SPY | ETF | 754.68 | 754.89 | 754.18 | 754.24 | 2991253.0 |
| 2026-05-28 15:00:00 | SPY | ETF | 754.22 | 755.15 | 754.11 | 754.64 | 6485790.0 |
| 2026-05-28 16:00:00 | SPY | ETF | 754.61 | 756.0 | 754.45 | 755.22 | 2440233.0 |
| 2026-05-28 17:00:00 | SPY | ETF | 755.22 | 755.45 | 755.0 | 755.15 | 148886.0 |
| 2026-05-28 18:00:00 | SPY | ETF | 755.3 | 755.65 | 754.96 | 755.031 | 86971.0 |
| 2026-05-28 19:00:00 | SPY | ETF | 755.09 | 755.5 | 754.94 | 755.1 | 38992.0 |
| 2026-05-28 04:00:00 | QQQ | ETF | 727.0 | 728.25 | 722.76 | 728.01 | 316399.0 |
| 2026-05-28 05:00:00 | QQQ | ETF | 727.99 | 728.32 | 726.9772 | 727.71 | 77700.0 |
| 2026-05-28 06:00:00 | QQQ | ETF | 727.82 | 727.83 | 725.33 | 725.6213 | 124137.0 |
| 2026-05-28 07:00:00 | QQQ | ETF | 725.629 | 726.95 | 725.27 | 726.57 | 236541.0 |
| 2026-05-28 08:00:00 | QQQ | ETF | 726.57 | 730.02 | 726.54 | 729.74 | 428575.0 |
| 2026-05-28 09:00:00 | QQQ | ETF | 729.86 | 731.12 | 726.41 | 728.12 | 4293794.0 |
| 2026-05-28 10:00:00 | QQQ | ETF | 728.12 | 732.94 | 727.4701 | 732.857 | 5181156.0 |
| 2026-05-28 11:00:00 | QQQ | ETF | 732.85 | 735.41 | 732.6914 | 734.71 | 3626270.0 |
| 2026-05-28 12:00:00 | QQQ | ETF | 734.7201 | 736.3 | 734.1001 | 736.225 | 1809487.0 |
| 2026-05-28 13:00:00 | QQQ | ETF | 736.24 | 736.6 | 735.16 | 736.03 | 2580770.0 |
| 2026-05-28 14:00:00 | QQQ | ETF | 736.07 | 736.48 | 735.095 | 735.38 | 1791828.0 |
| 2026-05-28 15:00:00 | QQQ | ETF | 735.38 | 736.25 | 734.92 | 735.54 | 3105438.0 |
| 2026-05-28 16:00:00 | QQQ | ETF | 735.55 | 736.45 | 735.25 | 735.89 | 1225000.0 |
| 2026-05-28 17:00:00 | QQQ | ETF | 735.81 | 736.42 | 735.65 | 736.174 | 76697.0 |
| 2026-05-28 18:00:00 | QQQ | ETF | 736.25 | 736.94 | 735.23 | 735.4201 | 134622.0 |
| 2026-05-28 19:00:00 | QQQ | ETF | 735.74 | 736.18 | 735.43 | 735.56 | 46138.0 |
| 2026-05-28 04:00:00 | IWM | ETF | 288.27 | 289.88 | 287.87 | 289.82 | 63335.0 |
| 2026-05-28 05:00:00 | IWM | ETF | 289.83 | 289.99 | 289.6 | 289.88 | 24194.0 |
| 2026-05-28 06:00:00 | IWM | ETF | 289.84 | 289.86 | 288.83 | 289.04 | 102361.0 |
| 2026-05-28 07:00:00 | IWM | ETF | 288.97 | 289.3 | 288.9 | 289.22 | 168453.0 |
| 2026-05-28 08:00:00 | IWM | ETF | 289.16 | 290.48 | 289.05 | 290.449 | 130502.0 |
| 2026-05-28 09:00:00 | IWM | ETF | 290.44 | 290.5856 | 288.1 | 288.54 | 3303847.0 |
| 2026-05-28 10:00:00 | IWM | ETF | 288.57 | 291.115 | 287.98 | 290.42 | 4336501.0 |
| 2026-05-28 11:00:00 | IWM | ETF | 290.43 | 292.14 | 290.36 | 291.92 | 2310542.0 |
| 2026-05-28 12:00:00 | IWM | ETF | 291.915 | 292.59 | 291.7 | 292.54 | 1281045.0 |
| 2026-05-28 13:00:00 | IWM | ETF | 292.55 | 292.58 | 291.685 | 291.985 | 1224875.0 |
| 2026-05-28 14:00:00 | IWM | ETF | 291.99 | 292.52 | 291.98 | 292.405 | 1582909.0 |
| 2026-05-28 15:00:00 | IWM | ETF | 292.42 | 292.74 | 292.01 | 292.02 | 2974798.0 |
| 2026-05-28 16:00:00 | IWM | ETF | 292.03 | 292.26 | 291.37 | 291.6 | 1108364.0 |
| 2026-05-28 17:00:00 | IWM | ETF | 291.62 | 291.98 | 291.46 | 291.86 | 163540.0 |
| 2026-05-28 18:00:00 | IWM | ETF | 291.86 | 291.99 | 291.62 | 291.67 | 111165.0 |
| 2026-05-28 19:00:00 | IWM | ETF | 291.77 | 291.92 | 291.65 | 291.74 | 9731.0 |
| 2026-05-28 04:00:00 | DIA | ETF | 505.89 | 506.97 | 505.83 | 506.41 | 1624.0 |
| 2026-05-28 05:00:00 | DIA | ETF | 506.7 | 506.711 | 506.6 | 506.66 | 2243.0 |
> showing 50 of 28,612 rows — these rows as CSV