PREVIEW / etf_daily / 2024-09-12
file: by_date/etf_daily/2024/2024-09-12.parquet size: 133 KB rows: 3,501
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-12 | SPY | ETF | 555.01 | 559.4 | 552.74 | 559.09 | 51787253.0 |
| 2024-09-12 | QQQ | ETF | 468.65 | 474.04 | 466.8491 | 473.22 | 40175456.0 |
| 2024-09-12 | IWM | ETF | 209.91 | 212.78 | 208.41 | 211.61 | 27335011.0 |
| 2024-09-12 | DIA | ETF | 409.7 | 412.0 | 407.48 | 411.97 | 3130638.0 |
| 2024-09-12 | GLD | ETF | 234.63 | 236.45 | 234.42 | 236.33 | 9922423.0 |
| 2024-09-12 | TLT | ETF | 100.36 | 100.55 | 99.69 | 100.14 | 41610469.0 |
| 2024-09-12 | AAA | ETF | 25.0202 | 25.04 | 25.0202 | 25.04 | 2291.0 |
| 2024-09-12 | AAAU | ETF | 25.12 | 25.3099 | 25.0901 | 25.295 | 1432144.0 |
| 2024-09-12 | AADR | ETF | 62.21 | 62.3698 | 62.21 | 62.3698 | 394.0 |
| 2024-09-12 | AAPB | ETF | 27.51 | 27.8066 | 26.93 | 27.66 | 119283.0 |
| 2024-09-12 | AAPD | ETF | 17.34 | 17.555 | 17.28 | 17.32 | 197271.0 |
| 2024-09-12 | AAPR | ETF | 25.9016 | 25.9016 | 25.9016 | 25.9016 | 791.0 |
| 2024-09-12 | AAPU | ETF | 35.22 | 35.56 | 34.45 | 35.36 | 367786.0 |
| 2024-09-12 | AAPX | ETF | 31.54 | 32.107 | 31.121 | 31.9248 | 7900.0 |
| 2024-09-12 | AAPY | ETF | 26.853 | 26.941 | 26.853 | 26.941 | 337.0 |
| 2024-09-12 | AAXJ | ETF | 71.55 | 72.0 | 71.42 | 71.98 | 186754.0 |
| 2024-09-12 | ABCS | ETF | 27.1 | 27.2105 | 26.925 | 27.2105 | 3810.0 |
| 2024-09-12 | ABEQ | ETF | 32.1801 | 32.3232 | 32.18 | 32.3232 | 844.0 |
| 2024-09-12 | ABNY | ETF | 78.95 | 79.3155 | 78.2 | 79.3155 | 1540.0 |
| 2024-09-12 | ACES | ETF | 28.18 | 28.39 | 27.85 | 28.18 | 114406.0 |
| 2024-09-12 | ACIO | ETF | 38.95 | 39.11 | 38.79 | 39.08 | 171042.0 |
| 2024-09-12 | ACSI | ETF | 56.8 | 56.8 | 56.8 | 56.8 | 183.0 |
| 2024-09-12 | ACT | ETF | 35.32 | 35.635 | 35.18 | 35.52 | 220031.0 |
| 2024-09-12 | ACTV | ETF | 31.83 | 32.105 | 31.8 | 32.0462 | 24058.0 |
| 2024-09-12 | ACVF | ETF | 42.27 | 42.6 | 42.27 | 42.555 | 7632.0 |
| 2024-09-12 | ACWI | ETF | 114.82 | 115.705 | 114.4 | 115.63 | 1991334.0 |
| 2024-09-12 | ACWV | ETF | 112.35 | 113.555 | 112.045 | 113.01 | 73507.0 |
| 2024-09-12 | ACWX | ETF | 54.46 | 54.84 | 54.25 | 54.84 | 336160.0 |
| 2024-09-12 | ADFI | ETF | 8.8 | 8.82 | 8.79 | 8.82 | 9346.0 |
| 2024-09-12 | ADIV | ETF | 14.96 | 15.0752 | 14.96 | 15.0752 | 605.0 |
| 2024-09-12 | ADME | ETF | 45.1 | 45.29 | 45.1 | 45.2034 | 10032.0 |
| 2024-09-12 | ADPV | ETF | 30.9718 | 31.0887 | 30.9718 | 31.0887 | 4007.0 |
| 2024-09-12 | AEMB | ETF | 39.76 | 39.76 | 39.6553 | 39.6553 | 431.0 |
| 2024-09-12 | AESR | ETF | 16.41 | 16.51 | 16.35 | 16.5 | 10087.0 |
| 2024-09-12 | AETH | ETF | 30.32 | 30.4552 | 30.03 | 30.4552 | 5176.0 |
| 2024-09-12 | AFIF | ETF | 9.2101 | 9.23 | 9.2101 | 9.225 | 11069.0 |
| 2024-09-12 | AFK | ETF | 15.85 | 15.95 | 15.72 | 15.78 | 24600.0 |
| 2024-09-12 | AFLG | ETF | 32.669 | 32.88 | 32.6268 | 32.8479 | 6109.0 |
| 2024-09-12 | AFMC | ETF | 30.28 | 30.39 | 30.28 | 30.39 | 449.0 |
| 2024-09-12 | AFSM | ETF | 29.14 | 29.25 | 29.0302 | 29.1049 | 3444.0 |
| 2024-09-12 | AFTY | ETF | 13.49 | 13.49 | 13.4871 | 13.4871 | 407.0 |
| 2024-09-12 | AGG | ETF | 101.56 | 101.65 | 101.38 | 101.53 | 6374584.0 |
| 2024-09-12 | AGGH | ETF | 21.89 | 21.89 | 21.7501 | 21.805 | 87318.0 |
| 2024-09-12 | AGGY | ETF | 44.96 | 44.97 | 44.865 | 44.94 | 40780.0 |
| 2024-09-12 | AGIX | ETF | 24.5325 | 24.5325 | 24.5325 | 24.5325 | 190.0 |
| 2024-09-12 | AGMI | ETF | 25.22 | 26.64 | 25.22 | 26.64 | 106.0 |
| 2024-09-12 | AGNG | ETF | 32.65 | 32.87 | 32.65 | 32.82 | 3699.0 |
| 2024-09-12 | AGOX | ETF | 28.195 | 28.96 | 28.16 | 28.44 | 40789.0 |
| 2024-09-12 | AGQ | ETF | 35.86 | 37.57 | 35.7 | 37.49 | 2368507.0 |
| 2024-09-12 | AGQI | ETF | 14.36 | 14.445 | 14.33 | 14.441 | 8292.0 |
> showing 50 of 3,501 rows — these rows as CSV