PREVIEW / etf_daily / 2024-07-22
file: by_date/etf_daily/2024/2024-07-22.parquet size: 132 KB rows: 3,440
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-07-22 | SPY | ETF | 553.0 | 555.27 | 551.02 | 554.65 | 43012467.0 |
| 2024-07-22 | QQQ | ETF | 481.16 | 483.35 | 477.7068 | 482.32 | 40299999.0 |
| 2024-07-22 | IWM | ETF | 217.68 | 220.6499 | 215.38 | 220.29 | 35326163.0 |
| 2024-07-22 | DIA | ETF | 404.04 | 404.73 | 402.22 | 404.15 | 2311902.0 |
| 2024-07-22 | GLD | ETF | 221.58 | 221.92 | 220.4 | 221.8 | 5259903.0 |
| 2024-07-22 | TLT | ETF | 93.4 | 93.52 | 92.3 | 92.65 | 36150293.0 |
| 2024-07-22 | AAA | ETF | 25.1499 | 25.1499 | 25.12 | 25.12 | 3689.0 |
| 2024-07-22 | AAAU | ETF | 23.71 | 23.75 | 23.58 | 23.73 | 1046398.0 |
| 2024-07-22 | AADR | ETF | 62.5731 | 62.91 | 62.5731 | 62.91 | 519.0 |
| 2024-07-22 | AAPB | ETF | 29.22 | 29.33 | 28.19 | 28.4 | 218283.0 |
| 2024-07-22 | AAPD | ETF | 16.92 | 17.235 | 16.8788 | 17.17 | 268740.0 |
| 2024-07-22 | AAPR | ETF | 25.485 | 25.52 | 25.4 | 25.52 | 128649.0 |
| 2024-07-22 | AAPU | ETF | 37.52 | 37.6399 | 36.1799 | 36.43 | 875961.0 |
| 2024-07-22 | AAPX | ETF | 34.0 | 34.0 | 32.85 | 33.09 | 23391.0 |
| 2024-07-22 | AAPY | ETF | 27.39 | 27.4199 | 27.2895 | 27.2895 | 890.0 |
| 2024-07-22 | AAXJ | ETF | 72.28 | 72.55 | 72.15 | 72.45 | 545915.0 |
| 2024-07-22 | ABCS | ETF | 26.7701 | 27.1606 | 26.77 | 27.1606 | 2243.0 |
| 2024-07-22 | ABEQ | ETF | 30.9829 | 31.05 | 30.8302 | 31.05 | 6580.0 |
| 2024-07-22 | ABNY | ETF | 102.05 | 103.8 | 101.65 | 103.333 | 1093.0 |
| 2024-07-22 | ACES | ETF | 30.41 | 30.5 | 29.982 | 30.48 | 179547.0 |
| 2024-07-22 | ACIO | ETF | 38.29 | 38.45 | 38.2216 | 38.36 | 81025.0 |
| 2024-07-22 | ACSI | ETF | 55.8256 | 55.8256 | 55.8256 | 55.8256 | 25.0 |
| 2024-07-22 | ACT | ETF | 33.51 | 33.67 | 33.27 | 33.52 | 143970.0 |
| 2024-07-22 | ACTV | ETF | 33.33 | 33.54 | 33.08 | 33.52 | 14748.0 |
| 2024-07-22 | ACVF | ETF | 41.84 | 42.0 | 41.7261 | 41.9984 | 15699.0 |
| 2024-07-22 | ACWI | ETF | 114.3 | 114.72 | 114.0 | 114.66 | 1559431.0 |
| 2024-07-22 | ACWV | ETF | 107.39 | 107.54 | 107.15 | 107.5 | 124804.0 |
| 2024-07-22 | ACWX | ETF | 54.23 | 54.32 | 54.065 | 54.3 | 1385010.0 |
| 2024-07-22 | ADFI | ETF | 8.56 | 8.5696 | 8.54 | 8.555 | 8060.0 |
| 2024-07-22 | ADIV | ETF | 14.53 | 14.5601 | 14.53 | 14.5601 | 1881.0 |
| 2024-07-22 | ADME | ETF | 44.56 | 44.67 | 44.51 | 44.65 | 13186.0 |
| 2024-07-22 | ADPV | ETF | 31.09 | 31.2 | 31.09 | 31.2 | 1402.0 |
| 2024-07-22 | AEMB | ETF | 38.78 | 38.78 | 38.78 | 38.78 | 416.0 |
| 2024-07-22 | AESR | ETF | 16.45 | 16.51 | 16.36 | 16.51 | 16025.0 |
| 2024-07-22 | AETH | ETF | 45.7 | 45.725 | 45.04 | 45.725 | 12775.0 |
| 2024-07-22 | AFIF | ETF | 9.14 | 9.14 | 9.124 | 9.125 | 17744.0 |
| 2024-07-22 | AFK | ETF | 16.11 | 16.2955 | 16.001 | 16.11 | 16326.0 |
| 2024-07-22 | AFLG | ETF | 32.31 | 32.36 | 32.18 | 32.2937 | 5068.0 |
| 2024-07-22 | AFMC | ETF | 30.5436 | 30.7159 | 30.2452 | 30.7159 | 2425.0 |
| 2024-07-22 | AFSM | ETF | 30.2 | 30.498 | 29.73 | 30.4569 | 13075.0 |
| 2024-07-22 | AFTY | ETF | 14.29 | 14.29 | 14.29 | 14.29 | 280.0 |
| 2024-07-22 | AGG | ETF | 98.12 | 98.2 | 97.8625 | 98.01 | 11653516.0 |
| 2024-07-22 | AGGH | ETF | 21.16 | 21.16 | 20.99 | 20.99 | 132644.0 |
| 2024-07-22 | AGGY | ETF | 43.54 | 43.55 | 43.4 | 43.45 | 303338.0 |
| 2024-07-22 | AGIX | ETF | 25.0 | 25.03 | 24.9304 | 25.025 | 1748.0 |
| 2024-07-22 | AGMI | ETF | 27.53 | 27.7771 | 27.53 | 27.7771 | 121.0 |
| 2024-07-22 | AGNG | ETF | 31.11 | 31.25 | 31.0572 | 31.25 | 881.0 |
| 2024-07-22 | AGOX | ETF | 28.05 | 28.23 | 28.0 | 28.1978 | 41343.0 |
| 2024-07-22 | AGQ | ETF | 36.22 | 36.84 | 35.88 | 36.81 | 1063470.0 |
| 2024-07-22 | AGQI | ETF | 14.39 | 14.44 | 14.39 | 14.42 | 7598.0 |
> showing 50 of 3,440 rows — these rows as CSV