PREVIEW / etf_daily / 2024-08-30
file: by_date/etf_daily/2024/2024-08-30.parquet size: 134 KB rows: 3,465
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-08-30 | SPY | ETF | 560.77 | 564.2 | 557.14 | 563.68 | 61641915.0 |
| 2024-08-30 | QQQ | ETF | 475.04 | 476.9 | 470.51 | 476.27 | 33466473.0 |
| 2024-08-30 | IWM | ETF | 219.71 | 220.5 | 217.4 | 220.08 | 22551757.0 |
| 2024-08-30 | DIA | ETF | 414.51 | 416.55 | 412.1212 | 416.21 | 2281918.0 |
| 2024-08-30 | GLD | ETF | 232.53 | 232.86 | 230.5501 | 231.29 | 5644069.0 |
| 2024-08-30 | TLT | ETF | 97.68 | 97.985 | 96.47 | 96.49 | 42825103.0 |
| 2024-08-30 | AAA | ETF | 25.02 | 25.035 | 25.0011 | 25.035 | 4927.0 |
| 2024-08-30 | AAAU | ETF | 24.89 | 24.9155 | 24.67 | 24.755 | 2008976.0 |
| 2024-08-30 | AADR | ETF | 63.0539 | 63.0539 | 63.0539 | 63.0539 | 46.0 |
| 2024-08-30 | AAPB | ETF | 29.6 | 29.6 | 28.95 | 29.26 | 184443.0 |
| 2024-08-30 | AAPD | ETF | 16.75 | 16.95 | 16.7487 | 16.86 | 177829.0 |
| 2024-08-30 | AAPR | ETF | 25.84 | 25.9252 | 25.84 | 25.9252 | 622.0 |
| 2024-08-30 | AAPU | ETF | 37.88 | 37.8909 | 36.97 | 37.45 | 937215.0 |
| 2024-08-30 | AAPX | ETF | 34.49 | 34.49 | 33.5401 | 33.84 | 17838.0 |
| 2024-08-30 | AAPY | ETF | 27.42 | 27.5487 | 27.42 | 27.5487 | 380.0 |
| 2024-08-30 | AAXJ | ETF | 73.31 | 73.31 | 72.63 | 73.01 | 249626.0 |
| 2024-08-30 | ABCS | ETF | 27.9861 | 28.0833 | 27.89 | 28.0833 | 2498.0 |
| 2024-08-30 | ABEQ | ETF | 32.4902 | 32.7254 | 32.4902 | 32.7254 | 6331.0 |
| 2024-08-30 | ABNY | ETF | 80.975 | 81.25 | 80.35 | 80.9905 | 1674.0 |
| 2024-08-30 | ACES | ETF | 29.06 | 29.0909 | 28.68 | 28.88 | 72887.0 |
| 2024-08-30 | ACIO | ETF | 39.07 | 39.29 | 38.8773 | 39.24 | 104400.0 |
| 2024-08-30 | ACSI | ETF | 57.1548 | 57.1548 | 57.1548 | 57.1548 | 57.0 |
| 2024-08-30 | ACT | ETF | 35.21 | 35.6 | 35.21 | 35.55 | 222331.0 |
| 2024-08-30 | ACTV | ETF | 32.99 | 33.0515 | 32.7407 | 33.0515 | 2924.0 |
| 2024-08-30 | ACVF | ETF | 42.83 | 42.9504 | 42.5822 | 42.9504 | 9505.0 |
| 2024-08-30 | ACWI | ETF | 116.6 | 117.09 | 115.905 | 116.98 | 1105290.0 |
| 2024-08-30 | ACWV | ETF | 113.32 | 113.58 | 112.81 | 113.47 | 199474.0 |
| 2024-08-30 | ACWX | ETF | 55.94 | 55.94 | 55.475 | 55.75 | 1006958.0 |
| 2024-08-30 | ADFI | ETF | 8.724 | 8.75 | 8.69 | 8.6968 | 13208.0 |
| 2024-08-30 | ADIV | ETF | 15.31 | 15.3255 | 15.31 | 15.3255 | 406.0 |
| 2024-08-30 | ADME | ETF | 45.27 | 45.64 | 45.0981 | 45.64 | 17060.0 |
| 2024-08-30 | ADPV | ETF | 31.87 | 32.0621 | 31.712 | 32.0621 | 2276.0 |
| 2024-08-30 | AEMB | ETF | 39.87 | 39.87 | 39.6467 | 39.6467 | 135.0 |
| 2024-08-30 | AESR | ETF | 16.64 | 16.73 | 16.54 | 16.73 | 30335.0 |
| 2024-08-30 | AETH | ETF | 32.68 | 32.8525 | 31.6 | 32.4437 | 6369.0 |
| 2024-08-30 | AFIF | ETF | 9.15 | 9.1963 | 9.15 | 9.195 | 8707.0 |
| 2024-08-30 | AFK | ETF | 16.36 | 16.58 | 16.25 | 16.35 | 9716.0 |
| 2024-08-30 | AFLG | ETF | 33.17 | 33.33 | 33.04 | 33.3 | 15225.0 |
| 2024-08-30 | AFMC | ETF | 31.215 | 31.5912 | 31.18 | 31.5912 | 4161.0 |
| 2024-08-30 | AFSM | ETF | 30.36 | 30.5494 | 30.35 | 30.5494 | 3692.0 |
| 2024-08-30 | AFTY | ETF | 14.1866 | 14.1866 | 14.1866 | 14.1866 | 4.0 |
| 2024-08-30 | AGG | ETF | 100.51 | 100.64 | 100.22 | 100.25 | 7145684.0 |
| 2024-08-30 | AGGH | ETF | 21.36 | 21.5375 | 21.022 | 21.37 | 86194.0 |
| 2024-08-30 | AGGY | ETF | 44.38 | 44.39 | 44.23 | 44.25 | 64284.0 |
| 2024-08-30 | AGIX | ETF | 24.47 | 24.565 | 24.355 | 24.565 | 545.0 |
| 2024-08-30 | AGMI | ETF | 26.39 | 26.39 | 26.2861 | 26.2861 | 146.0 |
| 2024-08-30 | AGNG | ETF | 33.24 | 33.24 | 33.05 | 33.17 | 3091.0 |
| 2024-08-30 | AGOX | ETF | 28.23 | 28.3299 | 27.68 | 28.18 | 69182.0 |
| 2024-08-30 | AGQ | ETF | 36.17 | 36.58 | 34.8541 | 35.27 | 1960262.0 |
| 2024-08-30 | AGQI | ETF | 14.6 | 14.63 | 14.51 | 14.63 | 4914.0 |
> showing 50 of 3,465 rows — these rows as CSV