PREVIEW / etf_1hour / 2025-05-30
file: by_date/etf_1hour/2025/2025-05-30.parquet size: 610 KB rows: 23,749
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-05-30 04:00:00 | SPY | ETF | 589.13 | 589.8 | 588.86 | 589.05 | 16735.0 |
| 2025-05-30 05:00:00 | SPY | ETF | 588.98 | 589.69 | 588.98 | 589.01 | 16747.0 |
| 2025-05-30 06:00:00 | SPY | ETF | 588.79 | 589.55 | 588.67 | 589.28 | 11844.0 |
| 2025-05-30 07:00:00 | SPY | ETF | 589.44 | 590.1 | 589.28 | 589.34 | 104956.0 |
| 2025-05-30 08:00:00 | SPY | ETF | 589.62 | 590.12 | 585.582 | 587.73 | 1488567.0 |
| 2025-05-30 09:00:00 | SPY | ETF | 587.79 | 589.11 | 586.4 | 587.09 | 5048099.0 |
| 2025-05-30 10:00:00 | SPY | ETF | 587.01 | 589.92 | 587.01 | 588.69 | 5993492.0 |
| 2025-05-30 11:00:00 | SPY | ETF | 588.71 | 589.37 | 587.34 | 587.98 | 3928495.0 |
| 2025-05-30 12:00:00 | SPY | ETF | 588.01 | 588.65 | 583.235 | 584.405 | 10834180.0 |
| 2025-05-30 13:00:00 | SPY | ETF | 584.385 | 586.69 | 583.99 | 585.86 | 5201298.0 |
| 2025-05-30 14:00:00 | SPY | ETF | 585.86 | 588.8698 | 585.82 | 588.68 | 6753444.0 |
| 2025-05-30 15:00:00 | SPY | ETF | 588.67 | 591.1299 | 588.58 | 589.47 | 18885254.0 |
| 2025-05-30 16:00:00 | SPY | ETF | 589.47 | 590.44 | 588.53 | 589.28 | 4256901.0 |
| 2025-05-30 17:00:00 | SPY | ETF | 589.3 | 589.4609 | 588.81 | 589.4609 | 58348.0 |
| 2025-05-30 18:00:00 | SPY | ETF | 589.49 | 589.5 | 588.11 | 588.22 | 103756.0 |
| 2025-05-30 19:00:00 | SPY | ETF | 588.25 | 588.4999 | 587.24 | 588.4009 | 51339.0 |
| 2025-05-30 04:00:00 | QQQ | ETF | 518.96 | 519.75 | 518.74 | 518.92 | 37760.0 |
| 2025-05-30 05:00:00 | QQQ | ETF | 518.88 | 519.72 | 518.88 | 518.96 | 50948.0 |
| 2025-05-30 06:00:00 | QQQ | ETF | 518.89 | 519.62 | 518.75 | 519.31 | 41065.0 |
| 2025-05-30 07:00:00 | QQQ | ETF | 519.49 | 520.4 | 519.37 | 519.64 | 87527.0 |
| 2025-05-30 08:00:00 | QQQ | ETF | 519.51 | 520.38 | 515.7 | 518.33 | 1159998.0 |
| 2025-05-30 09:00:00 | QQQ | ETF | 518.3604 | 519.66 | 515.89 | 516.47 | 4399778.0 |
| 2025-05-30 10:00:00 | QQQ | ETF | 516.46 | 519.86 | 516.4 | 518.79 | 6038268.0 |
| 2025-05-30 11:00:00 | QQQ | ETF | 518.8 | 519.35 | 517.16 | 518.005 | 4677217.0 |
| 2025-05-30 12:00:00 | QQQ | ETF | 518.02 | 518.33 | 511.93 | 512.85 | 8037475.0 |
| 2025-05-30 13:00:00 | QQQ | ETF | 512.84 | 515.355 | 512.36 | 514.45 | 4913774.0 |
| 2025-05-30 14:00:00 | QQQ | ETF | 514.45 | 517.64 | 514.43 | 517.48 | 4433837.0 |
| 2025-05-30 15:00:00 | QQQ | ETF | 517.47 | 520.68 | 517.38 | 519.13 | 11103952.0 |
| 2025-05-30 16:00:00 | QQQ | ETF | 519.13 | 520.02 | 516.6725 | 519.16 | 1507421.0 |
| 2025-05-30 17:00:00 | QQQ | ETF | 519.09 | 519.18 | 518.94 | 519.0772 | 21691.0 |
| 2025-05-30 18:00:00 | QQQ | ETF | 519.1 | 519.1375 | 518.5 | 518.5 | 22830.0 |
| 2025-05-30 19:00:00 | QQQ | ETF | 518.45 | 518.6928 | 518.23 | 518.49 | 28034.0 |
| 2025-05-30 04:00:00 | IWM | ETF | 205.75 | 205.85 | 205.32 | 205.66 | 11447.0 |
| 2025-05-30 05:00:00 | IWM | ETF | 205.49 | 205.69 | 205.26 | 205.27 | 33494.0 |
| 2025-05-30 06:00:00 | IWM | ETF | 205.19 | 205.7 | 205.18 | 205.59 | 11645.0 |
| 2025-05-30 07:00:00 | IWM | ETF | 205.66 | 205.95 | 205.57 | 205.71 | 34186.0 |
| 2025-05-30 08:00:00 | IWM | ETF | 205.72 | 205.98 | 204.09 | 204.92 | 492594.0 |
| 2025-05-30 09:00:00 | IWM | ETF | 204.9 | 205.19 | 203.9 | 203.9405 | 2878004.0 |
| 2025-05-30 10:00:00 | IWM | ETF | 204.0 | 205.675 | 203.96 | 205.385 | 3558437.0 |
| 2025-05-30 11:00:00 | IWM | ETF | 205.4 | 205.87 | 205.05 | 205.37 | 2869792.0 |
| 2025-05-30 12:00:00 | IWM | ETF | 205.37 | 205.665 | 203.54 | 203.915 | 4813237.0 |
| 2025-05-30 13:00:00 | IWM | ETF | 203.91 | 205.13 | 203.73 | 204.76 | 2367838.0 |
| 2025-05-30 14:00:00 | IWM | ETF | 204.76 | 205.845 | 204.75 | 205.76 | 3148405.0 |
| 2025-05-30 15:00:00 | IWM | ETF | 205.745 | 206.245 | 205.05 | 205.09 | 7990130.0 |
| 2025-05-30 16:00:00 | IWM | ETF | 205.095 | 205.53 | 204.67 | 204.83 | 4166701.0 |
| 2025-05-30 17:00:00 | IWM | ETF | 204.96 | 204.96 | 204.7536 | 204.85 | 12070.0 |
| 2025-05-30 18:00:00 | IWM | ETF | 204.8007 | 204.88 | 204.55 | 204.64 | 15315.0 |
| 2025-05-30 19:00:00 | IWM | ETF | 204.68 | 205.03 | 204.36 | 204.55 | 9386.0 |
| 2025-05-30 04:00:00 | DIA | ETF | 422.35 | 422.54 | 422.22 | 422.22 | 600.0 |
| 2025-05-30 05:00:00 | DIA | ETF | 422.42 | 422.42 | 422.42 | 422.42 | 100.0 |
> showing 50 of 23,749 rows — these rows as CSV