PREVIEW / etf_1hour / 2024-07-12
file: by_date/etf_1hour/2024/2024-07-12.parquet size: 550 KB rows: 20,550
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-12 04:00:00 | SPY | ETF | 557.09 | 557.55 | 557.09 | 557.55 | 18068.0 |
| 2024-07-12 05:00:00 | SPY | ETF | 557.55 | 557.65 | 557.24 | 557.52 | 4879.0 |
| 2024-07-12 06:00:00 | SPY | ETF | 557.49 | 557.61 | 557.0 | 557.21 | 11957.0 |
| 2024-07-12 07:00:00 | SPY | ETF | 557.2 | 557.32 | 556.8 | 557.24 | 204097.0 |
| 2024-07-12 08:00:00 | SPY | ETF | 557.27 | 557.7 | 555.19 | 557.44 | 215454.0 |
| 2024-07-12 09:00:00 | SPY | ETF | 557.58 | 559.0698 | 557.15 | 558.8799 | 3438618.0 |
| 2024-07-12 10:00:00 | SPY | ETF | 558.85 | 561.3599 | 558.625 | 561.1981 | 4788123.0 |
| 2024-07-12 11:00:00 | SPY | ETF | 561.18 | 561.76 | 560.72 | 560.7693 | 3155027.0 |
| 2024-07-12 12:00:00 | SPY | ETF | 560.79 | 561.655 | 560.13 | 561.64 | 3229566.0 |
| 2024-07-12 13:00:00 | SPY | ETF | 561.64 | 563.67 | 561.51 | 563.05 | 3898595.0 |
| 2024-07-12 14:00:00 | SPY | ETF | 563.03 | 563.41 | 562.6 | 563.24 | 3252963.0 |
| 2024-07-12 15:00:00 | SPY | ETF | 563.24 | 563.295 | 558.95 | 559.9 | 12434826.0 |
| 2024-07-12 16:00:00 | SPY | ETF | 559.91 | 560.34 | 559.25 | 559.73 | 3211247.0 |
| 2024-07-12 17:00:00 | SPY | ETF | 559.75 | 559.75 | 559.4 | 559.53 | 164917.0 |
| 2024-07-12 18:00:00 | SPY | ETF | 559.56 | 559.75 | 559.5093 | 559.71 | 37844.0 |
| 2024-07-12 19:00:00 | SPY | ETF | 559.67 | 559.85 | 559.67 | 559.77 | 22293.0 |
| 2024-07-12 04:00:00 | QQQ | ETF | 491.49 | 492.39 | 491.49 | 492.37 | 78633.0 |
| 2024-07-12 05:00:00 | QQQ | ETF | 492.39 | 492.61 | 491.96 | 492.35 | 44096.0 |
| 2024-07-12 06:00:00 | QQQ | ETF | 492.5 | 492.64 | 491.8 | 492.24 | 65791.0 |
| 2024-07-12 07:00:00 | QQQ | ETF | 492.19 | 492.57 | 491.64 | 492.56 | 94171.0 |
| 2024-07-12 08:00:00 | QQQ | ETF | 492.52 | 493.08 | 490.0 | 492.42 | 399098.0 |
| 2024-07-12 09:00:00 | QQQ | ETF | 492.64 | 495.04 | 492.0 | 494.89 | 3647040.0 |
| 2024-07-12 10:00:00 | QQQ | ETF | 494.91 | 497.695 | 494.4 | 497.12 | 4651395.0 |
| 2024-07-12 11:00:00 | QQQ | ETF | 497.11 | 497.82 | 496.02 | 496.12 | 2231559.0 |
| 2024-07-12 12:00:00 | QQQ | ETF | 496.06 | 497.04 | 495.1743 | 497.0 | 2145481.0 |
| 2024-07-12 13:00:00 | QQQ | ETF | 496.995 | 499.62 | 496.82 | 498.86 | 2863257.0 |
| 2024-07-12 14:00:00 | QQQ | ETF | 498.89 | 499.21 | 498.2 | 498.886 | 1874837.0 |
| 2024-07-12 15:00:00 | QQQ | ETF | 498.89 | 498.94 | 494.1 | 494.84 | 6741183.0 |
| 2024-07-12 16:00:00 | QQQ | ETF | 494.87 | 495.34 | 494.26 | 494.839 | 1650834.0 |
| 2024-07-12 17:00:00 | QQQ | ETF | 494.78 | 494.85 | 494.52 | 494.85 | 1001074.0 |
| 2024-07-12 18:00:00 | QQQ | ETF | 494.8 | 494.95 | 494.8 | 494.95 | 20899.0 |
| 2024-07-12 19:00:00 | QQQ | ETF | 494.95 | 495.15 | 494.85 | 495.1 | 36361.0 |
| 2024-07-12 04:00:00 | IWM | ETF | 212.68 | 212.77 | 212.29 | 212.29 | 82327.0 |
| 2024-07-12 05:00:00 | IWM | ETF | 212.23 | 212.69 | 212.2 | 212.5 | 63294.0 |
| 2024-07-12 06:00:00 | IWM | ETF | 212.54 | 212.73 | 212.49 | 212.65 | 69648.0 |
| 2024-07-12 07:00:00 | IWM | ETF | 212.68 | 213.24 | 212.62 | 213.23 | 225883.0 |
| 2024-07-12 08:00:00 | IWM | ETF | 212.71 | 213.89 | 211.38 | 213.54 | 1675276.0 |
| 2024-07-12 09:00:00 | IWM | ETF | 213.55 | 213.71 | 212.66 | 213.36 | 5716875.0 |
| 2024-07-12 10:00:00 | IWM | ETF | 213.37 | 214.94 | 213.37 | 214.235 | 6548552.0 |
| 2024-07-12 11:00:00 | IWM | ETF | 214.245 | 214.37 | 213.27 | 213.285 | 2876512.0 |
| 2024-07-12 12:00:00 | IWM | ETF | 213.28 | 213.47 | 212.855 | 213.34 | 2396516.0 |
| 2024-07-12 13:00:00 | IWM | ETF | 213.34 | 213.8 | 213.07 | 213.44 | 1903090.0 |
| 2024-07-12 14:00:00 | IWM | ETF | 213.44 | 213.77 | 213.29 | 213.73 | 1619907.0 |
| 2024-07-12 15:00:00 | IWM | ETF | 213.73 | 213.88 | 212.95 | 213.11 | 4885685.0 |
| 2024-07-12 16:00:00 | IWM | ETF | 213.14 | 213.3 | 212.95 | 213.04 | 1902264.0 |
| 2024-07-12 17:00:00 | IWM | ETF | 213.06 | 213.25 | 212.84 | 213.25 | 1203232.0 |
| 2024-07-12 18:00:00 | IWM | ETF | 213.25 | 213.35 | 213.18 | 213.18 | 4901.0 |
| 2024-07-12 19:00:00 | IWM | ETF | 213.25 | 213.58 | 213.23 | 213.58 | 13013.0 |
| 2024-07-12 05:00:00 | DIA | ETF | 398.39 | 398.39 | 398.29 | 398.29 | 803.0 |
| 2024-07-12 06:00:00 | DIA | ETF | 398.28 | 398.97 | 398.16 | 398.18 | 2955.0 |
> showing 50 of 20,550 rows — these rows as CSV