PREVIEW / etf_1hour / 2024-07-11
file: by_date/etf_1hour/2024/2024-07-11.parquet size: 566 KB rows: 21,129
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-07-11 04:00:00 | SPY | ETF | 561.1 | 561.36 | 561.1 | 561.13 | 8985.0 |
| 2024-07-11 05:00:00 | SPY | ETF | 561.03 | 561.09 | 561.0 | 561.08 | 6567.0 |
| 2024-07-11 06:00:00 | SPY | ETF | 561.06 | 561.06 | 560.77 | 560.94 | 10955.0 |
| 2024-07-11 07:00:00 | SPY | ETF | 560.93 | 561.02 | 560.78 | 560.79 | 199110.0 |
| 2024-07-11 08:00:00 | SPY | ETF | 560.9298 | 563.52 | 560.52 | 561.24 | 1719908.0 |
| 2024-07-11 09:00:00 | SPY | ETF | 561.24 | 561.97 | 560.89 | 561.95 | 3487825.0 |
| 2024-07-11 10:00:00 | SPY | ETF | 561.95 | 562.33 | 558.4 | 558.47 | 5689419.0 |
| 2024-07-11 11:00:00 | SPY | ETF | 558.47 | 559.24 | 556.43 | 556.74 | 4000377.0 |
| 2024-07-11 12:00:00 | SPY | ETF | 556.73 | 557.77 | 556.0 | 556.3355 | 3709857.0 |
| 2024-07-11 13:00:00 | SPY | ETF | 556.33 | 557.115 | 555.83 | 555.93 | 2679228.0 |
| 2024-07-11 14:00:00 | SPY | ETF | 555.94 | 557.31 | 555.83 | 557.16 | 3204331.0 |
| 2024-07-11 15:00:00 | SPY | ETF | 557.16 | 557.57 | 556.4 | 556.42 | 10562781.0 |
| 2024-07-11 16:00:00 | SPY | ETF | 556.42 | 558.0349 | 556.07 | 556.75 | 3779543.0 |
| 2024-07-11 17:00:00 | SPY | ETF | 556.75 | 556.81 | 556.25 | 556.3999 | 73462.0 |
| 2024-07-11 18:00:00 | SPY | ETF | 556.4 | 556.95 | 556.3211 | 556.85 | 82863.0 |
| 2024-07-11 19:00:00 | SPY | ETF | 556.91 | 557.17 | 556.4 | 556.43 | 19338.0 |
| 2024-07-11 04:00:00 | QQQ | ETF | 502.93 | 503.05 | 502.71 | 502.79 | 40937.0 |
| 2024-07-11 05:00:00 | QQQ | ETF | 502.74 | 502.89 | 502.62 | 502.85 | 23332.0 |
| 2024-07-11 06:00:00 | QQQ | ETF | 502.8 | 502.83 | 502.68 | 502.78 | 10524.0 |
| 2024-07-11 07:00:00 | QQQ | ETF | 502.81 | 502.94 | 502.73 | 502.8 | 185919.0 |
| 2024-07-11 08:00:00 | QQQ | ETF | 502.8 | 505.21 | 502.4254 | 503.05 | 1497660.0 |
| 2024-07-11 09:00:00 | QQQ | ETF | 503.02 | 503.64 | 501.32 | 502.475 | 4313023.0 |
| 2024-07-11 10:00:00 | QQQ | ETF | 502.49 | 502.5101 | 496.02 | 496.101 | 6469569.0 |
| 2024-07-11 11:00:00 | QQQ | ETF | 496.1 | 497.14 | 493.02 | 493.1032 | 6711020.0 |
| 2024-07-11 12:00:00 | QQQ | ETF | 493.12 | 494.57 | 492.12 | 492.31 | 4156043.0 |
| 2024-07-11 13:00:00 | QQQ | ETF | 492.33 | 493.27 | 490.93 | 491.04 | 3561137.0 |
| 2024-07-11 14:00:00 | QQQ | ETF | 491.04 | 492.98 | 490.725 | 492.91 | 2860016.0 |
| 2024-07-11 15:00:00 | QQQ | ETF | 492.94 | 493.54 | 491.84 | 491.91 | 6954941.0 |
| 2024-07-11 16:00:00 | QQQ | ETF | 491.9 | 492.68 | 491.44 | 492.06 | 1800408.0 |
| 2024-07-11 17:00:00 | QQQ | ETF | 492.0 | 492.1 | 491.41 | 491.71 | 163918.0 |
| 2024-07-11 18:00:00 | QQQ | ETF | 491.78 | 492.35 | 491.66 | 492.18 | 161412.0 |
| 2024-07-11 19:00:00 | QQQ | ETF | 492.18 | 492.55 | 491.2999 | 491.49 | 114905.0 |
| 2024-07-11 04:00:00 | IWM | ETF | 203.45 | 203.49 | 203.3 | 203.43 | 15450.0 |
| 2024-07-11 05:00:00 | IWM | ETF | 203.56 | 203.56 | 203.34 | 203.4 | 4757.0 |
| 2024-07-11 06:00:00 | IWM | ETF | 203.42 | 203.42 | 203.11 | 203.12 | 10479.0 |
| 2024-07-11 07:00:00 | IWM | ETF | 203.17 | 203.48 | 203.16 | 203.46 | 52749.0 |
| 2024-07-11 08:00:00 | IWM | ETF | 203.15 | 207.62 | 203.15 | 207.36 | 3973936.0 |
| 2024-07-11 09:00:00 | IWM | ETF | 207.36 | 208.39 | 206.94 | 208.36 | 9110459.0 |
| 2024-07-11 10:00:00 | IWM | ETF | 208.36 | 210.84 | 208.34 | 210.76 | 8788721.0 |
| 2024-07-11 11:00:00 | IWM | ETF | 210.77 | 211.02 | 209.4126 | 209.46 | 4628084.0 |
| 2024-07-11 12:00:00 | IWM | ETF | 209.47 | 210.23 | 209.06 | 210.1 | 3143578.0 |
| 2024-07-11 13:00:00 | IWM | ETF | 210.11 | 210.81 | 209.91 | 210.51 | 2372957.0 |
| 2024-07-11 14:00:00 | IWM | ETF | 210.515 | 210.675 | 210.3 | 210.38 | 2205229.0 |
| 2024-07-11 15:00:00 | IWM | ETF | 210.37 | 211.225 | 209.99 | 210.74 | 7582723.0 |
| 2024-07-11 16:00:00 | IWM | ETF | 210.68 | 211.23 | 210.68 | 211.16 | 2389790.0 |
| 2024-07-11 17:00:00 | IWM | ETF | 211.11 | 211.24 | 210.68 | 211.24 | 63595.0 |
| 2024-07-11 18:00:00 | IWM | ETF | 211.22 | 211.4494 | 210.837 | 211.33 | 101845.0 |
| 2024-07-11 19:00:00 | IWM | ETF | 211.34 | 211.8696 | 211.32 | 211.6 | 120963.0 |
| 2024-07-11 04:00:00 | DIA | ETF | 397.16 | 397.16 | 397.16 | 397.16 | 200.0 |
| 2024-07-11 05:00:00 | DIA | ETF | 396.97 | 396.97 | 396.97 | 396.97 | 500.0 |
> showing 50 of 21,129 rows — these rows as CSV