PREVIEW / etf_1hour / 2024-02-26
file: by_date/etf_1hour/2024/2024-02-26.parquet size: 541 KB rows: 19,930
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-26 04:00:00 | SPY | ETF | 507.32 | 507.7 | 507.06 | 507.68 | 13978.0 |
| 2024-02-26 05:00:00 | SPY | ETF | 507.65 | 508.02 | 507.64 | 507.86 | 32340.0 |
| 2024-02-26 06:00:00 | SPY | ETF | 507.83 | 508.1 | 507.8 | 507.87 | 6196.0 |
| 2024-02-26 07:00:00 | SPY | ETF | 507.91 | 507.96 | 507.56 | 507.62 | 95261.0 |
| 2024-02-26 08:00:00 | SPY | ETF | 507.69 | 508.64 | 507.03 | 508.42 | 198761.0 |
| 2024-02-26 09:00:00 | SPY | ETF | 508.42 | 508.75 | 507.73 | 508.215 | 3410902.0 |
| 2024-02-26 10:00:00 | SPY | ETF | 508.22 | 508.52 | 507.42 | 507.5 | 4797904.0 |
| 2024-02-26 11:00:00 | SPY | ETF | 507.505 | 507.89 | 507.015 | 507.72 | 3945527.0 |
| 2024-02-26 12:00:00 | SPY | ETF | 507.73 | 507.9 | 507.15 | 507.3061 | 2926099.0 |
| 2024-02-26 13:00:00 | SPY | ETF | 507.3099 | 507.595 | 506.02 | 506.885 | 5461177.0 |
| 2024-02-26 14:00:00 | SPY | ETF | 506.8727 | 507.4 | 506.515 | 506.76 | 4540677.0 |
| 2024-02-26 15:00:00 | SPY | ETF | 506.765 | 507.315 | 505.86 | 505.99 | 10182806.0 |
| 2024-02-26 16:00:00 | SPY | ETF | 505.97 | 506.02 | 505.62 | 505.72 | 2104076.0 |
| 2024-02-26 17:00:00 | SPY | ETF | 505.72 | 505.97 | 505.65 | 505.75 | 169077.0 |
| 2024-02-26 18:00:00 | SPY | ETF | 505.69 | 506.07 | 505.61 | 505.911 | 54049.0 |
| 2024-02-26 19:00:00 | SPY | ETF | 505.91 | 505.91 | 505.26 | 505.7396 | 27222.0 |
| 2024-02-26 04:00:00 | QQQ | ETF | 436.38 | 436.99 | 435.9 | 436.99 | 39638.0 |
| 2024-02-26 05:00:00 | QQQ | ETF | 436.95 | 437.17 | 436.77 | 436.98 | 14219.0 |
| 2024-02-26 06:00:00 | QQQ | ETF | 436.87 | 437.24 | 436.77 | 436.87 | 23261.0 |
| 2024-02-26 07:00:00 | QQQ | ETF | 436.9 | 436.97 | 436.56 | 436.66 | 65482.0 |
| 2024-02-26 08:00:00 | QQQ | ETF | 436.7905 | 437.83 | 435.64 | 437.56 | 169494.0 |
| 2024-02-26 09:00:00 | QQQ | ETF | 437.55 | 438.4 | 436.355 | 436.8101 | 4010975.0 |
| 2024-02-26 10:00:00 | QQQ | ETF | 436.81 | 438.155 | 436.42 | 437.5801 | 4068543.0 |
| 2024-02-26 11:00:00 | QQQ | ETF | 437.61 | 438.58 | 436.97 | 438.27 | 3047694.0 |
| 2024-02-26 12:00:00 | QQQ | ETF | 438.295 | 438.6 | 437.59 | 437.82 | 2645524.0 |
| 2024-02-26 13:00:00 | QQQ | ETF | 437.83 | 438.24 | 436.69 | 437.53 | 3101797.0 |
| 2024-02-26 14:00:00 | QQQ | ETF | 437.52 | 438.17 | 437.3 | 437.54 | 2499146.0 |
| 2024-02-26 15:00:00 | QQQ | ETF | 437.55 | 438.02 | 436.52 | 436.63 | 4136454.0 |
| 2024-02-26 16:00:00 | QQQ | ETF | 436.6 | 436.6 | 435.84 | 435.95 | 866549.0 |
| 2024-02-26 17:00:00 | QQQ | ETF | 435.97 | 436.08 | 435.85 | 435.9 | 43450.0 |
| 2024-02-26 18:00:00 | QQQ | ETF | 435.97 | 436.4 | 435.78 | 436.28 | 119377.0 |
| 2024-02-26 19:00:00 | QQQ | ETF | 436.19 | 436.27 | 435.71 | 436.15 | 28734.0 |
| 2024-02-26 04:00:00 | IWM | ETF | 199.2 | 199.32 | 199.0 | 199.27 | 20550.0 |
| 2024-02-26 05:00:00 | IWM | ETF | 199.14 | 199.37 | 199.11 | 199.31 | 9909.0 |
| 2024-02-26 06:00:00 | IWM | ETF | 199.32 | 199.46 | 199.23 | 199.36 | 7215.0 |
| 2024-02-26 07:00:00 | IWM | ETF | 199.3 | 199.47 | 199.12 | 199.18 | 95961.0 |
| 2024-02-26 08:00:00 | IWM | ETF | 199.2493 | 200.14 | 199.0 | 199.93 | 141986.0 |
| 2024-02-26 09:00:00 | IWM | ETF | 199.99 | 201.62 | 199.15 | 201.57 | 3727157.0 |
| 2024-02-26 10:00:00 | IWM | ETF | 201.6 | 201.64 | 200.655 | 201.3 | 3635291.0 |
| 2024-02-26 11:00:00 | IWM | ETF | 201.3 | 201.42 | 200.78 | 201.37 | 2121373.0 |
| 2024-02-26 12:00:00 | IWM | ETF | 201.38 | 201.38 | 200.8801 | 201.1 | 1376045.0 |
| 2024-02-26 13:00:00 | IWM | ETF | 201.1 | 201.13 | 200.09 | 200.6997 | 2926749.0 |
| 2024-02-26 14:00:00 | IWM | ETF | 200.69 | 201.18 | 200.43 | 201.13 | 3114427.0 |
| 2024-02-26 15:00:00 | IWM | ETF | 201.14 | 201.635 | 200.95 | 201.2 | 5594541.0 |
| 2024-02-26 16:00:00 | IWM | ETF | 201.15 | 201.2632 | 200.98 | 201.08 | 1249307.0 |
| 2024-02-26 17:00:00 | IWM | ETF | 201.07 | 201.12 | 200.78 | 200.9 | 29334.0 |
| 2024-02-26 18:00:00 | IWM | ETF | 201.0 | 201.45 | 201.0 | 201.2 | 54267.0 |
| 2024-02-26 19:00:00 | IWM | ETF | 201.15 | 201.15 | 200.8 | 201.1 | 52758.0 |
| 2024-02-26 04:00:00 | DIA | ETF | 390.7 | 390.7 | 390.67 | 390.67 | 472.0 |
| 2024-02-26 05:00:00 | DIA | ETF | 390.92 | 390.97 | 390.92 | 390.97 | 350.0 |
> showing 50 of 19,930 rows — these rows as CSV