PREVIEW / etf_1hour / 2024-08-21
file: by_date/etf_1hour/2024/2024-08-21.parquet size: 541 KB rows: 20,302
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-21 04:00:00 | SPY | ETF | 559.0 | 559.21 | 558.62 | 558.71 | 7959.0 |
| 2024-08-21 05:00:00 | SPY | ETF | 558.64 | 558.96 | 558.6 | 558.6 | 6121.0 |
| 2024-08-21 06:00:00 | SPY | ETF | 558.76 | 559.6 | 558.76 | 559.6 | 32209.0 |
| 2024-08-21 07:00:00 | SPY | ETF | 559.55 | 559.81 | 559.26 | 559.52 | 187511.0 |
| 2024-08-21 08:00:00 | SPY | ETF | 559.52 | 559.98 | 558.99 | 559.6 | 224144.0 |
| 2024-08-21 09:00:00 | SPY | ETF | 559.64 | 560.45 | 559.35 | 560.35 | 2662426.0 |
| 2024-08-21 10:00:00 | SPY | ETF | 560.37 | 562.11 | 558.58 | 559.28 | 5350178.0 |
| 2024-08-21 11:00:00 | SPY | ETF | 559.225 | 560.33 | 558.55 | 558.89 | 2636029.0 |
| 2024-08-21 12:00:00 | SPY | ETF | 558.89 | 560.31 | 557.99 | 560.13 | 2225629.0 |
| 2024-08-21 13:00:00 | SPY | ETF | 560.14 | 560.54 | 559.88 | 560.3999 | 1476542.0 |
| 2024-08-21 14:00:00 | SPY | ETF | 560.43 | 561.71 | 560.18 | 560.75 | 3301543.0 |
| 2024-08-21 15:00:00 | SPY | ETF | 560.74 | 561.05 | 559.22 | 560.7 | 7635270.0 |
| 2024-08-21 16:00:00 | SPY | ETF | 560.7 | 561.07 | 560.22 | 560.79 | 2843562.0 |
| 2024-08-21 17:00:00 | SPY | ETF | 560.79 | 560.91 | 560.62 | 560.75 | 25049.0 |
| 2024-08-21 18:00:00 | SPY | ETF | 560.78 | 561.23 | 560.68 | 561.11 | 16248.0 |
| 2024-08-21 19:00:00 | SPY | ETF | 561.0 | 561.17 | 560.89 | 561.17 | 27641.0 |
| 2024-08-21 04:00:00 | QQQ | ETF | 480.29 | 480.65 | 479.89 | 480.15 | 25410.0 |
| 2024-08-21 05:00:00 | QQQ | ETF | 479.95 | 480.3 | 479.82 | 479.9 | 6927.0 |
| 2024-08-21 06:00:00 | QQQ | ETF | 479.91 | 481.06 | 479.91 | 481.02 | 37074.0 |
| 2024-08-21 07:00:00 | QQQ | ETF | 481.03 | 481.42 | 480.6 | 480.85 | 79502.0 |
| 2024-08-21 08:00:00 | QQQ | ETF | 481.26 | 481.52 | 480.12 | 480.95 | 125937.0 |
| 2024-08-21 09:00:00 | QQQ | ETF | 480.95 | 482.04 | 480.35 | 481.9 | 1944056.0 |
| 2024-08-21 10:00:00 | QQQ | ETF | 481.93 | 484.37 | 480.09 | 480.84 | 5154884.0 |
| 2024-08-21 11:00:00 | QQQ | ETF | 480.81 | 482.28 | 480.07 | 480.58 | 2169205.0 |
| 2024-08-21 12:00:00 | QQQ | ETF | 480.545 | 481.91 | 479.32 | 481.729 | 1494317.0 |
| 2024-08-21 13:00:00 | QQQ | ETF | 481.7452 | 482.3902 | 481.31 | 482.25 | 1390228.0 |
| 2024-08-21 14:00:00 | QQQ | ETF | 482.27 | 483.66 | 481.91 | 482.51 | 2433105.0 |
| 2024-08-21 15:00:00 | QQQ | ETF | 482.47 | 482.93 | 480.75 | 482.53 | 3242425.0 |
| 2024-08-21 16:00:00 | QQQ | ETF | 482.53 | 483.02 | 481.95 | 482.92 | 1153424.0 |
| 2024-08-21 17:00:00 | QQQ | ETF | 482.85 | 482.85 | 482.75 | 482.81 | 14046.0 |
| 2024-08-21 18:00:00 | QQQ | ETF | 482.82 | 483.42 | 482.76 | 483.22 | 38453.0 |
| 2024-08-21 19:00:00 | QQQ | ETF | 483.22 | 483.32 | 483.02 | 483.32 | 41347.0 |
| 2024-08-21 04:00:00 | IWM | ETF | 213.48 | 213.69 | 213.35 | 213.35 | 16250.0 |
| 2024-08-21 05:00:00 | IWM | ETF | 213.53 | 213.65 | 213.48 | 213.57 | 6346.0 |
| 2024-08-21 06:00:00 | IWM | ETF | 213.61 | 214.11 | 213.46 | 214.06 | 53125.0 |
| 2024-08-21 07:00:00 | IWM | ETF | 214.01 | 214.25 | 213.55 | 213.66 | 48574.0 |
| 2024-08-21 08:00:00 | IWM | ETF | 214.07 | 214.2 | 213.27 | 213.92 | 148438.0 |
| 2024-08-21 09:00:00 | IWM | ETF | 213.91 | 214.62 | 213.16 | 213.69 | 1683803.0 |
| 2024-08-21 10:00:00 | IWM | ETF | 213.7 | 214.79 | 212.82 | 213.51 | 3196909.0 |
| 2024-08-21 11:00:00 | IWM | ETF | 213.45 | 214.4699 | 213.15 | 213.78 | 1422961.0 |
| 2024-08-21 12:00:00 | IWM | ETF | 213.78 | 214.38 | 213.435 | 214.29 | 785580.0 |
| 2024-08-21 13:00:00 | IWM | ETF | 214.28 | 215.23 | 214.2 | 214.9 | 1069456.0 |
| 2024-08-21 14:00:00 | IWM | ETF | 214.91 | 215.54 | 214.79 | 215.0559 | 1714598.0 |
| 2024-08-21 15:00:00 | IWM | ETF | 215.04 | 215.66 | 214.65 | 215.46 | 3098246.0 |
| 2024-08-21 16:00:00 | IWM | ETF | 215.46 | 215.76 | 215.46 | 215.55 | 842212.0 |
| 2024-08-21 17:00:00 | IWM | ETF | 215.63 | 215.63 | 215.51 | 215.56 | 9890.0 |
| 2024-08-21 18:00:00 | IWM | ETF | 215.56 | 215.95 | 215.56 | 215.82 | 29324.0 |
| 2024-08-21 19:00:00 | IWM | ETF | 215.73 | 215.86 | 215.6 | 215.8596 | 32082.0 |
| 2024-08-21 06:00:00 | DIA | ETF | 409.1 | 409.1 | 409.1 | 409.1 | 300.0 |
| 2024-08-21 07:00:00 | DIA | ETF | 409.12 | 409.26 | 409.08 | 409.2 | 1725.0 |
> showing 50 of 20,302 rows — these rows as CSV