PREVIEW / etf_1hour / 2024-08-02
file: by_date/etf_1hour/2024/2024-08-02.parquet size: 588 KB rows: 22,254
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-08-02 04:00:00 | SPY | ETF | 538.9 | 539.92 | 537.15 | 538.49 | 43492.0 |
| 2024-08-02 05:00:00 | SPY | ETF | 538.4 | 538.4 | 536.9 | 537.0 | 31836.0 |
| 2024-08-02 06:00:00 | SPY | ETF | 537.02 | 537.83 | 536.29 | 537.25 | 63461.0 |
| 2024-08-02 07:00:00 | SPY | ETF | 537.24 | 537.7 | 536.7 | 536.975 | 451751.0 |
| 2024-08-02 08:00:00 | SPY | ETF | 537.21 | 539.55 | 533.06 | 534.68 | 2499742.0 |
| 2024-08-02 09:00:00 | SPY | ETF | 534.66 | 536.99 | 533.89 | 534.13 | 7263800.0 |
| 2024-08-02 10:00:00 | SPY | ETF | 534.13 | 534.96 | 529.02 | 529.26 | 11965710.0 |
| 2024-08-02 11:00:00 | SPY | ETF | 529.27 | 532.82 | 528.6 | 532.18 | 8469727.0 |
| 2024-08-02 12:00:00 | SPY | ETF | 532.19 | 533.52 | 530.57 | 531.255 | 5430930.0 |
| 2024-08-02 13:00:00 | SPY | ETF | 531.24 | 532.02 | 529.66 | 530.2212 | 4040772.0 |
| 2024-08-02 14:00:00 | SPY | ETF | 530.22 | 532.41 | 529.54 | 530.91 | 4739625.0 |
| 2024-08-02 15:00:00 | SPY | ETF | 530.9 | 533.17 | 530.52 | 532.98 | 12180131.0 |
| 2024-08-02 16:00:00 | SPY | ETF | 533.03 | 533.03 | 531.08 | 531.24 | 5091796.0 |
| 2024-08-02 17:00:00 | SPY | ETF | 531.38 | 532.9 | 531.226 | 531.65 | 168952.0 |
| 2024-08-02 18:00:00 | SPY | ETF | 531.65 | 532.26 | 531.41 | 531.91 | 66342.0 |
| 2024-08-02 19:00:00 | SPY | ETF | 531.95 | 531.95 | 531.0 | 531.25 | 47749.0 |
| 2024-08-02 04:00:00 | QQQ | ETF | 453.48 | 453.53 | 451.55 | 452.8 | 119298.0 |
| 2024-08-02 05:00:00 | QQQ | ETF | 452.82 | 452.82 | 451.07 | 451.83 | 122449.0 |
| 2024-08-02 06:00:00 | QQQ | ETF | 451.68 | 453.0 | 450.8 | 452.45 | 135869.0 |
| 2024-08-02 07:00:00 | QQQ | ETF | 452.37 | 452.93 | 451.38 | 451.5 | 301049.0 |
| 2024-08-02 08:00:00 | QQQ | ETF | 452.14 | 454.17 | 447.5 | 449.39 | 2281127.0 |
| 2024-08-02 09:00:00 | QQQ | ETF | 449.41 | 453.57 | 448.285 | 449.1 | 8013392.0 |
| 2024-08-02 10:00:00 | QQQ | ETF | 449.09 | 450.11 | 444.47 | 445.45 | 11637864.0 |
| 2024-08-02 11:00:00 | QQQ | ETF | 445.45 | 450.395 | 444.96 | 449.58 | 7325794.0 |
| 2024-08-02 12:00:00 | QQQ | ETF | 449.56 | 450.49 | 446.89 | 447.46 | 4375645.0 |
| 2024-08-02 13:00:00 | QQQ | ETF | 447.48 | 448.7 | 445.955 | 447.0501 | 2852893.0 |
| 2024-08-02 14:00:00 | QQQ | ETF | 447.056 | 449.4 | 446.14 | 447.31 | 3107164.0 |
| 2024-08-02 15:00:00 | QQQ | ETF | 447.355 | 449.2 | 446.37 | 448.71 | 5679335.0 |
| 2024-08-02 16:00:00 | QQQ | ETF | 448.78 | 448.87 | 447.37 | 447.66 | 2237810.0 |
| 2024-08-02 17:00:00 | QQQ | ETF | 447.56 | 448.75 | 447.55 | 447.71 | 169628.0 |
| 2024-08-02 18:00:00 | QQQ | ETF | 447.6 | 447.99 | 447.31 | 447.73 | 40009.0 |
| 2024-08-02 19:00:00 | QQQ | ETF | 447.65 | 447.74 | 447.4 | 447.5 | 16039.0 |
| 2024-08-02 04:00:00 | IWM | ETF | 214.35 | 215.0 | 212.74 | 213.58 | 81876.0 |
| 2024-08-02 05:00:00 | IWM | ETF | 213.63 | 213.63 | 212.38 | 212.46 | 46346.0 |
| 2024-08-02 06:00:00 | IWM | ETF | 212.59 | 213.13 | 212.25 | 212.57 | 54531.0 |
| 2024-08-02 07:00:00 | IWM | ETF | 212.59 | 213.35 | 212.229 | 213.33 | 492299.0 |
| 2024-08-02 08:00:00 | IWM | ETF | 212.7 | 215.75 | 206.83 | 208.85 | 3357226.0 |
| 2024-08-02 09:00:00 | IWM | ETF | 208.84 | 211.19 | 207.85 | 209.47 | 10285930.0 |
| 2024-08-02 10:00:00 | IWM | ETF | 209.49 | 210.25 | 207.3 | 207.6384 | 9958984.0 |
| 2024-08-02 11:00:00 | IWM | ETF | 207.64 | 209.16 | 206.99 | 208.81 | 6988226.0 |
| 2024-08-02 12:00:00 | IWM | ETF | 208.78 | 210.16 | 208.52 | 209.45 | 4083547.0 |
| 2024-08-02 13:00:00 | IWM | ETF | 209.47 | 209.66 | 208.13 | 208.24 | 2835802.0 |
| 2024-08-02 14:00:00 | IWM | ETF | 208.22 | 209.38 | 207.89 | 208.85 | 3585666.0 |
| 2024-08-02 15:00:00 | IWM | ETF | 208.86 | 209.54 | 208.47 | 209.01 | 7752252.0 |
| 2024-08-02 16:00:00 | IWM | ETF | 209.02 | 209.2 | 208.26 | 208.26 | 2511699.0 |
| 2024-08-02 17:00:00 | IWM | ETF | 208.3 | 208.92 | 208.28 | 208.76 | 148179.0 |
| 2024-08-02 18:00:00 | IWM | ETF | 208.76 | 208.88 | 207.98 | 208.5 | 71037.0 |
| 2024-08-02 19:00:00 | IWM | ETF | 208.4 | 208.465 | 207.72 | 207.89 | 27603.0 |
| 2024-08-02 04:00:00 | DIA | ETF | 401.16 | 401.3 | 400.65 | 401.25 | 9605.0 |
| 2024-08-02 05:00:00 | DIA | ETF | 401.15 | 401.35 | 400.37 | 400.39 | 2761.0 |
> showing 50 of 22,254 rows — these rows as CSV