PREVIEW / etf_daily / 2024-09-25
file: by_date/etf_daily/2024/2024-09-25.parquet size: 135 KB rows: 3,549
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-25 | SPY | ETF | 571.14 | 571.89 | 568.91 | 570.04 | 38330885.0 |
| 2024-09-25 | QQQ | ETF | 484.74 | 487.79 | 484.56 | 485.82 | 26549866.0 |
| 2024-09-25 | IWM | ETF | 220.32 | 220.61 | 217.54 | 217.69 | 22223884.0 |
| 2024-09-25 | DIA | ETF | 422.44 | 422.94 | 418.38 | 419.12 | 2041615.0 |
| 2024-09-25 | GLD | ETF | 246.19 | 246.47 | 244.79 | 245.73 | 7380401.0 |
| 2024-09-25 | TLT | ETF | 98.26 | 98.32 | 97.79 | 97.83 | 36491971.0 |
| 2024-09-25 | AAA | ETF | 25.09 | 25.09 | 25.03 | 25.085 | 1601.0 |
| 2024-09-25 | AAAU | ETF | 26.35 | 26.38 | 26.2079 | 26.31 | 2591660.0 |
| 2024-09-25 | AADR | ETF | 63.79 | 63.79 | 62.46 | 62.46 | 676.0 |
| 2024-09-25 | AAPB | ETF | 28.1 | 28.5582 | 27.8001 | 28.38 | 158190.0 |
| 2024-09-25 | AAPD | ETF | 16.99 | 17.085 | 16.85 | 16.91 | 201832.0 |
| 2024-09-25 | AAPR | ETF | 26.18 | 26.2001 | 26.18 | 26.2001 | 2018.0 |
| 2024-09-25 | AAPU | ETF | 35.62 | 36.23 | 35.22 | 35.93 | 670916.0 |
| 2024-09-25 | AAPX | ETF | 32.49 | 32.995 | 32.165 | 32.68 | 20181.0 |
| 2024-09-25 | AAXJ | ETF | 76.84 | 76.99 | 76.435 | 76.47 | 470752.0 |
| 2024-09-25 | ABCS | ETF | 28.22 | 28.22 | 27.99 | 27.99 | 2522.0 |
| 2024-09-25 | ABEQ | ETF | 32.7301 | 32.7301 | 32.67 | 32.67 | 16923.0 |
| 2024-09-25 | ABNY | ETF | 83.05 | 83.45 | 82.95 | 83.0105 | 299.0 |
| 2024-09-25 | ACES | ETF | 28.97 | 28.97 | 28.48 | 28.49 | 24292.0 |
| 2024-09-25 | ACIO | ETF | 39.68 | 39.7092 | 39.55 | 39.62 | 545051.0 |
| 2024-09-25 | ACSI | ETF | 58.0004 | 58.0004 | 58.0004 | 58.0004 | 36.0 |
| 2024-09-25 | ACT | ETF | 35.98 | 36.14 | 35.8 | 35.99 | 339763.0 |
| 2024-09-25 | ACTV | ETF | 33.49 | 33.49 | 33.01 | 33.01 | 4230.0 |
| 2024-09-25 | ACVF | ETF | 43.52 | 43.54 | 43.4 | 43.4129 | 3914.0 |
| 2024-09-25 | ACWI | ETF | 119.01 | 119.11 | 118.42 | 118.52 | 1967050.0 |
| 2024-09-25 | ACWV | ETF | 114.45 | 114.68 | 113.94 | 114.02 | 110031.0 |
| 2024-09-25 | ACWX | ETF | 56.91 | 56.91 | 56.425 | 56.45 | 673950.0 |
| 2024-09-25 | ADFI | ETF | 8.7796 | 8.78 | 8.765 | 8.765 | 2265.0 |
| 2024-09-25 | ADIV | ETF | 16.1 | 16.1 | 15.965 | 15.965 | 1749.0 |
| 2024-09-25 | ADME | ETF | 46.09 | 46.09 | 45.9 | 45.9539 | 17308.0 |
| 2024-09-25 | ADPV | ETF | 31.73 | 31.73 | 31.5404 | 31.5404 | 5320.0 |
| 2024-09-25 | ADVE | ETF | 35.51 | 35.51 | 35.4556 | 35.4556 | 116.0 |
| 2024-09-25 | AEMB | ETF | 39.355 | 39.355 | 39.15 | 39.15 | 594.0 |
| 2024-09-25 | AESR | ETF | 16.91 | 16.92 | 16.86 | 16.8902 | 4132.0 |
| 2024-09-25 | AETH | ETF | 33.845 | 33.845 | 33.174 | 33.174 | 875.0 |
| 2024-09-25 | AFIF | ETF | 9.22 | 9.22 | 9.19 | 9.205 | 37992.0 |
| 2024-09-25 | AFK | ETF | 17.0 | 17.1 | 16.8 | 16.82 | 19626.0 |
| 2024-09-25 | AFLG | ETF | 33.95 | 33.96 | 33.88 | 33.88 | 8990.0 |
| 2024-09-25 | AFMC | ETF | 31.88 | 31.88 | 31.7523 | 31.7523 | 458.0 |
| 2024-09-25 | AFSM | ETF | 30.4808 | 30.6 | 30.204 | 30.2153 | 7734.0 |
| 2024-09-25 | AFTY | ETF | 14.88 | 14.88 | 14.8199 | 14.82 | 4818.0 |
| 2024-09-25 | AGG | ETF | 101.42 | 101.4265 | 101.19 | 101.19 | 9137465.0 |
| 2024-09-25 | AGGH | ETF | 21.75 | 21.76 | 21.6201 | 21.63 | 49513.0 |
| 2024-09-25 | AGGY | ETF | 44.8 | 44.809 | 44.7202 | 44.725 | 88762.0 |
| 2024-09-25 | AGIX | ETF | 25.48 | 25.48 | 25.41 | 25.4208 | 5059.0 |
| 2024-09-25 | AGMI | ETF | 30.02 | 30.08 | 29.74 | 29.74 | 1482.0 |
| 2024-09-25 | AGNG | ETF | 32.92 | 33.62 | 32.64 | 32.66 | 4877.0 |
| 2024-09-25 | AGOX | ETF | 28.65 | 29.237 | 28.65 | 28.9884 | 18183.0 |
| 2024-09-25 | AGQ | ETF | 42.52 | 43.435 | 41.6166 | 42.32 | 2982700.0 |
| 2024-09-25 | AGQI | ETF | 14.7 | 14.7 | 14.6405 | 14.6405 | 4423.0 |
> showing 50 of 3,549 rows — these rows as CSV