PREVIEW / etf_1hour / 2025-06-27
file: by_date/etf_1hour/2025/2025-06-27.parquet size: 659 KB rows: 25,379
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-06-27 04:00:00 | SPY | ETF | 613.64 | 613.79 | 613.39 | 613.76 | 60477.0 |
| 2025-06-27 05:00:00 | SPY | ETF | 613.75 | 613.75 | 613.37 | 613.53 | 58125.0 |
| 2025-06-27 06:00:00 | SPY | ETF | 613.67 | 613.67 | 613.35 | 613.51 | 54913.0 |
| 2025-06-27 07:00:00 | SPY | ETF | 613.52 | 614.39 | 613.47 | 614.34 | 163656.0 |
| 2025-06-27 08:00:00 | SPY | ETF | 613.83 | 614.55 | 612.6 | 613.44 | 715308.0 |
| 2025-06-27 09:00:00 | SPY | ETF | 613.43 | 614.6599 | 612.7 | 614.36 | 5197115.0 |
| 2025-06-27 10:00:00 | SPY | ETF | 614.37 | 615.55 | 614.37 | 614.81 | 7162313.0 |
| 2025-06-27 11:00:00 | SPY | ETF | 614.82 | 616.1 | 614.6 | 615.902 | 4376113.0 |
| 2025-06-27 12:00:00 | SPY | ETF | 615.9 | 616.39 | 615.645 | 615.97 | 4166914.0 |
| 2025-06-27 13:00:00 | SPY | ETF | 615.955 | 615.96 | 613.27 | 614.155 | 6628331.0 |
| 2025-06-27 14:00:00 | SPY | ETF | 614.16 | 614.38 | 610.83 | 611.19 | 11544458.0 |
| 2025-06-27 15:00:00 | SPY | ETF | 611.185 | 615.14 | 611.01 | 614.86 | 18395500.0 |
| 2025-06-27 16:00:00 | SPY | ETF | 614.86 | 614.91 | 614.19 | 614.61 | 3345394.0 |
| 2025-06-27 17:00:00 | SPY | ETF | 614.62 | 614.62 | 614.12 | 614.25 | 92054.0 |
| 2025-06-27 18:00:00 | SPY | ETF | 614.23 | 614.3928 | 613.18 | 613.2 | 166112.0 |
| 2025-06-27 19:00:00 | SPY | ETF | 613.2 | 613.64 | 612.86 | 613.43 | 89533.0 |
| 2025-06-27 04:00:00 | QQQ | ETF | 547.67 | 548.33 | 547.67 | 548.33 | 33344.0 |
| 2025-06-27 05:00:00 | QQQ | ETF | 548.31 | 548.31 | 547.84 | 548.19 | 35162.0 |
| 2025-06-27 06:00:00 | QQQ | ETF | 548.26 | 548.27 | 547.79 | 547.95 | 42244.0 |
| 2025-06-27 07:00:00 | QQQ | ETF | 547.9 | 549.0 | 547.87 | 549.0 | 117194.0 |
| 2025-06-27 08:00:00 | QQQ | ETF | 548.14 | 549.19 | 546.84 | 547.84 | 411556.0 |
| 2025-06-27 09:00:00 | QQQ | ETF | 547.815 | 548.72 | 546.74 | 548.598 | 3569062.0 |
| 2025-06-27 10:00:00 | QQQ | ETF | 548.6 | 549.99 | 548.2 | 548.4512 | 5582868.0 |
| 2025-06-27 11:00:00 | QQQ | ETF | 548.46 | 549.93 | 548.1403 | 549.655 | 2865529.0 |
| 2025-06-27 12:00:00 | QQQ | ETF | 549.66 | 549.66 | 548.69 | 549.3 | 3199531.0 |
| 2025-06-27 13:00:00 | QQQ | ETF | 549.28 | 549.37 | 546.95 | 547.89 | 4531532.0 |
| 2025-06-27 14:00:00 | QQQ | ETF | 547.89 | 548.02 | 544.545 | 544.8 | 7050031.0 |
| 2025-06-27 15:00:00 | QQQ | ETF | 544.8 | 548.385 | 544.68 | 548.21 | 7215403.0 |
| 2025-06-27 16:00:00 | QQQ | ETF | 548.2 | 548.2 | 547.42 | 547.99 | 1237839.0 |
| 2025-06-27 17:00:00 | QQQ | ETF | 547.96 | 548.06 | 547.71 | 547.96 | 41010.0 |
| 2025-06-27 18:00:00 | QQQ | ETF | 547.79 | 547.95 | 547.65 | 547.72 | 31038.0 |
| 2025-06-27 19:00:00 | QQQ | ETF | 547.79 | 547.85 | 547.59 | 547.59 | 37827.0 |
| 2025-06-27 04:00:00 | IWM | ETF | 216.0 | 216.24 | 215.85 | 216.22 | 32032.0 |
| 2025-06-27 05:00:00 | IWM | ETF | 216.21 | 216.27 | 216.01 | 216.16 | 7692.0 |
| 2025-06-27 06:00:00 | IWM | ETF | 216.11 | 216.17 | 215.96 | 216.09 | 6828.0 |
| 2025-06-27 07:00:00 | IWM | ETF | 216.08 | 216.58 | 216.08 | 216.57 | 94739.0 |
| 2025-06-27 08:00:00 | IWM | ETF | 216.36 | 216.6 | 215.73 | 215.91 | 188502.0 |
| 2025-06-27 09:00:00 | IWM | ETF | 215.91 | 216.12 | 215.21 | 215.84 | 3269862.0 |
| 2025-06-27 10:00:00 | IWM | ETF | 215.85 | 217.18 | 215.79 | 216.68 | 5831070.0 |
| 2025-06-27 11:00:00 | IWM | ETF | 216.68 | 217.04 | 216.255 | 216.62 | 2869530.0 |
| 2025-06-27 12:00:00 | IWM | ETF | 216.61 | 217.405 | 216.54 | 216.85 | 2910406.0 |
| 2025-06-27 13:00:00 | IWM | ETF | 216.85 | 216.8753 | 215.385 | 215.705 | 3570467.0 |
| 2025-06-27 14:00:00 | IWM | ETF | 215.705 | 215.925 | 214.125 | 214.26 | 4837489.0 |
| 2025-06-27 15:00:00 | IWM | ETF | 214.265 | 215.83 | 214.14 | 215.53 | 9979109.0 |
| 2025-06-27 16:00:00 | IWM | ETF | 215.53 | 215.74 | 215.06 | 215.67 | 3727582.0 |
| 2025-06-27 17:00:00 | IWM | ETF | 215.67 | 215.79 | 215.24 | 215.24 | 35366.0 |
| 2025-06-27 18:00:00 | IWM | ETF | 215.22 | 215.6 | 214.6594 | 215.09 | 21422.0 |
| 2025-06-27 19:00:00 | IWM | ETF | 215.07 | 215.27 | 214.99 | 215.2 | 9312.0 |
| 2025-06-27 04:00:00 | DIA | ETF | 435.2 | 435.25 | 435.08 | 435.25 | 2670.0 |
| 2025-06-27 05:00:00 | DIA | ETF | 435.15 | 435.15 | 435.14 | 435.14 | 300.0 |
> showing 50 of 25,379 rows — these rows as CSV