PREVIEW / etf_1hour / 2025-08-27
file: by_date/etf_1hour/2025/2025-08-27.parquet size: 667 KB rows: 25,459
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-08-27 04:00:00 | SPY | ETF | 645.5 | 645.5 | 644.99 | 645.39 | 12789.0 |
| 2025-08-27 05:00:00 | SPY | ETF | 645.42 | 645.77 | 645.42 | 645.63 | 4882.0 |
| 2025-08-27 06:00:00 | SPY | ETF | 645.61 | 645.78 | 645.57 | 645.64 | 8174.0 |
| 2025-08-27 07:00:00 | SPY | ETF | 645.72 | 645.9 | 645.53 | 645.79 | 39791.0 |
| 2025-08-27 08:00:00 | SPY | ETF | 645.62 | 646.0 | 644.95 | 645.26 | 151840.0 |
| 2025-08-27 09:00:00 | SPY | ETF | 645.23 | 645.53 | 644.41 | 645.35 | 4306457.0 |
| 2025-08-27 10:00:00 | SPY | ETF | 645.35 | 646.41 | 645.2603 | 646.18 | 5028254.0 |
| 2025-08-27 11:00:00 | SPY | ETF | 646.19 | 646.69 | 645.91 | 646.5418 | 3238883.0 |
| 2025-08-27 12:00:00 | SPY | ETF | 646.55 | 646.6 | 645.38 | 646.2993 | 3582953.0 |
| 2025-08-27 13:00:00 | SPY | ETF | 646.29 | 646.82 | 646.04 | 646.76 | 2688046.0 |
| 2025-08-27 14:00:00 | SPY | ETF | 646.755 | 647.355 | 646.58 | 647.04 | 3644571.0 |
| 2025-08-27 15:00:00 | SPY | ETF | 647.035 | 647.37 | 645.82 | 646.62 | 8269504.0 |
| 2025-08-27 16:00:00 | SPY | ETF | 646.61 | 647.64 | 643.15 | 645.68 | 3887384.0 |
| 2025-08-27 17:00:00 | SPY | ETF | 645.46 | 646.2 | 645.46 | 645.75 | 170145.0 |
| 2025-08-27 18:00:00 | SPY | ETF | 645.7 | 645.7 | 644.65 | 644.98 | 122364.0 |
| 2025-08-27 19:00:00 | SPY | ETF | 644.97 | 645.11 | 644.66 | 644.8199 | 43299.0 |
| 2025-08-27 04:00:00 | QQQ | ETF | 573.1 | 573.1 | 572.27 | 572.7 | 85655.0 |
| 2025-08-27 05:00:00 | QQQ | ETF | 572.69 | 573.07 | 572.69 | 572.98 | 18393.0 |
| 2025-08-27 06:00:00 | QQQ | ETF | 572.93 | 573.17 | 572.87 | 573.09 | 17480.0 |
| 2025-08-27 07:00:00 | QQQ | ETF | 573.07 | 573.39 | 573.0 | 573.21 | 31102.0 |
| 2025-08-27 08:00:00 | QQQ | ETF | 573.26 | 573.55 | 572.17 | 572.6 | 235149.0 |
| 2025-08-27 09:00:00 | QQQ | ETF | 572.6 | 572.68 | 570.37 | 571.47 | 4648001.0 |
| 2025-08-27 10:00:00 | QQQ | ETF | 571.47 | 573.4 | 571.28 | 573.042 | 3826629.0 |
| 2025-08-27 11:00:00 | QQQ | ETF | 573.05 | 573.77 | 572.4 | 573.595 | 2517010.0 |
| 2025-08-27 12:00:00 | QQQ | ETF | 573.59 | 573.6195 | 571.65 | 573.06 | 2877154.0 |
| 2025-08-27 13:00:00 | QQQ | ETF | 573.06 | 573.6193 | 572.73 | 573.549 | 1576217.0 |
| 2025-08-27 14:00:00 | QQQ | ETF | 573.54 | 574.405 | 573.39 | 573.68 | 2312356.0 |
| 2025-08-27 15:00:00 | QQQ | ETF | 573.67 | 574.145 | 571.92 | 573.54 | 5134304.0 |
| 2025-08-27 16:00:00 | QQQ | ETF | 573.54 | 575.0 | 568.98 | 571.6 | 1815966.0 |
| 2025-08-27 17:00:00 | QQQ | ETF | 571.53 | 572.25 | 571.0923 | 571.63 | 221949.0 |
| 2025-08-27 18:00:00 | QQQ | ETF | 571.65 | 571.77 | 570.61 | 571.03 | 130633.0 |
| 2025-08-27 19:00:00 | QQQ | ETF | 571.06 | 571.2 | 570.6719 | 570.81 | 74641.0 |
| 2025-08-27 04:00:00 | IWM | ETF | 234.31 | 234.32 | 233.95 | 234.11 | 29340.0 |
| 2025-08-27 05:00:00 | IWM | ETF | 234.09 | 234.38 | 234.08 | 234.12 | 12307.0 |
| 2025-08-27 06:00:00 | IWM | ETF | 234.07 | 234.28 | 233.92 | 234.21 | 15248.0 |
| 2025-08-27 07:00:00 | IWM | ETF | 234.25 | 234.3 | 234.1 | 234.11 | 56259.0 |
| 2025-08-27 08:00:00 | IWM | ETF | 234.19 | 234.61 | 233.68 | 233.89 | 163477.0 |
| 2025-08-27 09:00:00 | IWM | ETF | 233.87 | 235.88 | 233.555 | 235.34 | 3373872.0 |
| 2025-08-27 10:00:00 | IWM | ETF | 235.325 | 235.4799 | 234.69 | 235.39 | 3069847.0 |
| 2025-08-27 11:00:00 | IWM | ETF | 235.39 | 235.82 | 235.27 | 235.53 | 2339163.0 |
| 2025-08-27 12:00:00 | IWM | ETF | 235.525 | 235.865 | 234.985 | 235.775 | 1754843.0 |
| 2025-08-27 13:00:00 | IWM | ETF | 235.77 | 235.9462 | 235.36 | 235.73 | 1412929.0 |
| 2025-08-27 14:00:00 | IWM | ETF | 235.7201 | 235.9999 | 235.485 | 235.99 | 1503337.0 |
| 2025-08-27 15:00:00 | IWM | ETF | 235.99 | 236.12 | 235.53 | 235.95 | 4393066.0 |
| 2025-08-27 16:00:00 | IWM | ETF | 235.94 | 236.3 | 235.01 | 236.3 | 1414491.0 |
| 2025-08-27 17:00:00 | IWM | ETF | 236.16 | 236.3 | 235.79 | 235.82 | 83598.0 |
| 2025-08-27 18:00:00 | IWM | ETF | 236.06 | 236.15 | 235.75 | 235.97 | 37714.0 |
| 2025-08-27 19:00:00 | IWM | ETF | 236.02 | 236.02 | 235.75 | 235.85 | 32814.0 |
| 2025-08-27 04:00:00 | DIA | ETF | 454.83 | 454.87 | 454.47 | 454.51 | 2352.0 |
| 2025-08-27 05:00:00 | DIA | ETF | 454.77 | 454.98 | 454.67 | 454.85 | 1900.0 |
> showing 50 of 25,459 rows — these rows as CSV