PREVIEW / etf_daily / 2024-09-26
file: by_date/etf_daily/2024/2024-09-26.parquet size: 135 KB rows: 3,556
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-09-26 | SPY | ETF | 574.38 | 574.71 | 569.9 | 572.3 | 48146735.0 |
| 2024-09-26 | QQQ | ETF | 493.37 | 493.7 | 485.8 | 489.47 | 32020206.0 |
| 2024-09-26 | IWM | ETF | 220.49 | 221.13 | 218.38 | 218.85 | 24835282.0 |
| 2024-09-26 | DIA | ETF | 421.24 | 422.12 | 420.2 | 421.62 | 2679107.0 |
| 2024-09-26 | GLD | ETF | 246.44 | 247.37 | 245.19 | 246.98 | 6916495.0 |
| 2024-09-26 | TLT | ETF | 98.07 | 98.245 | 97.42 | 98.06 | 33290528.0 |
| 2024-09-26 | AAA | ETF | 25.06 | 25.1864 | 25.06 | 25.13 | 2837.0 |
| 2024-09-26 | AAAU | ETF | 26.39 | 26.479 | 26.25 | 26.44 | 2628144.0 |
| 2024-09-26 | AADR | ETF | 64.3672 | 64.6 | 64.3672 | 64.6 | 586.0 |
| 2024-09-26 | AAPB | ETF | 28.49 | 28.8589 | 28.26 | 28.67 | 86000.0 |
| 2024-09-26 | AAPD | ETF | 16.84 | 16.98 | 16.755 | 16.81 | 209868.0 |
| 2024-09-26 | AAPR | ETF | 26.24 | 26.24 | 26.1701 | 26.212 | 4249.0 |
| 2024-09-26 | AAPU | ETF | 36.33 | 36.61 | 35.69 | 36.31 | 619782.0 |
| 2024-09-26 | AAPX | ETF | 33.2 | 33.2 | 32.57 | 33.15 | 17788.0 |
| 2024-09-26 | AAXJ | ETF | 79.73 | 79.97 | 78.82 | 79.63 | 642785.0 |
| 2024-09-26 | ABCS | ETF | 28.2301 | 28.323 | 28.2 | 28.323 | 3139.0 |
| 2024-09-26 | ABEQ | ETF | 32.61 | 32.7531 | 32.61 | 32.7531 | 9094.0 |
| 2024-09-26 | ABNY | ETF | 82.55 | 83.65 | 82.481 | 82.481 | 651.0 |
| 2024-09-26 | ACES | ETF | 28.99 | 29.48 | 28.94 | 29.14 | 15549.0 |
| 2024-09-26 | ACIO | ETF | 39.92 | 39.92 | 39.5959 | 39.72 | 108206.0 |
| 2024-09-26 | ACSI | ETF | 58.26 | 58.38 | 58.26 | 58.38 | 502.0 |
| 2024-09-26 | ACT | ETF | 36.11 | 36.46 | 36.06 | 36.31 | 394780.0 |
| 2024-09-26 | ACTV | ETF | 33.6596 | 33.7101 | 33.56 | 33.6188 | 24876.0 |
| 2024-09-26 | ACVF | ETF | 43.8 | 43.8 | 43.5 | 43.6477 | 29796.0 |
| 2024-09-26 | ACWI | ETF | 119.91 | 120.19 | 119.415 | 119.84 | 1306618.0 |
| 2024-09-26 | ACWV | ETF | 114.89 | 115.065 | 114.775 | 114.97 | 92461.0 |
| 2024-09-26 | ACWX | ETF | 57.7 | 57.9 | 57.44 | 57.81 | 404353.0 |
| 2024-09-26 | ADFI | ETF | 8.77 | 8.78 | 8.76 | 8.76 | 7054.0 |
| 2024-09-26 | ADIV | ETF | 16.615 | 16.78 | 16.432 | 16.585 | 4745.0 |
| 2024-09-26 | ADME | ETF | 46.03 | 46.17 | 46.01 | 46.17 | 13647.0 |
| 2024-09-26 | ADPV | ETF | 31.77 | 31.77 | 31.61 | 31.6102 | 5872.0 |
| 2024-09-26 | AEMB | ETF | 38.98 | 39.1815 | 38.98 | 39.1815 | 170.0 |
| 2024-09-26 | AESR | ETF | 17.08 | 17.08 | 16.9105 | 16.97 | 17347.0 |
| 2024-09-26 | AETH | ETF | 33.81 | 34.32 | 33.7 | 34.1948 | 8167.0 |
| 2024-09-26 | AFIF | ETF | 9.21 | 9.215 | 9.2002 | 9.205 | 9852.0 |
| 2024-09-26 | AFK | ETF | 17.1 | 17.25 | 17.02 | 17.25 | 9011.0 |
| 2024-09-26 | AFLG | ETF | 34.05 | 34.08 | 33.951 | 33.9977 | 4819.0 |
| 2024-09-26 | AFMC | ETF | 31.96 | 32.06 | 31.96 | 31.9798 | 1685.0 |
| 2024-09-26 | AFSM | ETF | 30.84 | 30.84 | 30.4024 | 30.4982 | 4540.0 |
| 2024-09-26 | AFTY | ETF | 16.16 | 16.24 | 16.0899 | 16.2 | 18959.0 |
| 2024-09-26 | AGG | ETF | 101.32 | 101.35 | 100.08 | 101.21 | 8036884.0 |
| 2024-09-26 | AGGH | ETF | 21.75 | 21.75 | 21.56 | 21.57 | 56256.0 |
| 2024-09-26 | AGGY | ETF | 44.76 | 44.77 | 44.64 | 44.7113 | 87528.0 |
| 2024-09-26 | AGIX | ETF | 25.73 | 25.73 | 25.435 | 25.629 | 2554.0 |
| 2024-09-26 | AGMI | ETF | 30.42 | 30.9099 | 30.42 | 30.9099 | 168.0 |
| 2024-09-26 | AGNG | ETF | 32.89 | 32.89 | 32.7003 | 32.75 | 7444.0 |
| 2024-09-26 | AGOX | ETF | 29.22 | 29.43 | 28.7884 | 29.29 | 20138.0 |
| 2024-09-26 | AGQ | ETF | 43.11 | 43.48 | 42.045 | 42.97 | 3039284.0 |
| 2024-09-26 | AGQI | ETF | 14.7 | 14.755 | 14.66 | 14.74 | 8662.0 |
| 2024-09-26 | AGZ | ETF | 110.57 | 110.72 | 110.4224 | 110.5264 | 13685.0 |
> showing 50 of 3,556 rows — these rows as CSV