PREVIEW / etf_daily / 2024-08-28
file: by_date/etf_daily/2024/2024-08-28.parquet size: 133 KB rows: 3,449
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-28 | SPY | ETF | 561.21 | 561.65 | 555.04 | 558.3 | 40387917.0 |
| 2024-08-28 | QQQ | ETF | 476.29 | 477.02 | 467.89 | 471.35 | 37372436.0 |
| 2024-08-28 | IWM | ETF | 217.87 | 219.115 | 216.27 | 217.26 | 18632187.0 |
| 2024-08-28 | DIA | ETF | 412.66 | 413.93 | 408.71 | 411.34 | 2719345.0 |
| 2024-08-28 | GLD | ETF | 232.0 | 232.02 | 230.73 | 231.75 | 4893769.0 |
| 2024-08-28 | TLT | ETF | 98.01 | 98.2 | 97.725 | 97.85 | 18481237.0 |
| 2024-08-28 | AAA | ETF | 25.14 | 25.18 | 25.1363 | 25.1363 | 2072.0 |
| 2024-08-28 | AAAU | ETF | 24.84 | 24.84 | 24.69 | 24.81 | 1206173.0 |
| 2024-08-28 | AADR | ETF | 61.8 | 61.8 | 61.8 | 61.8 | 110.0 |
| 2024-08-28 | AAPB | ETF | 29.1 | 29.53 | 28.5599 | 28.69 | 54591.0 |
| 2024-08-28 | AAPD | ETF | 16.91 | 17.05 | 16.7601 | 17.02 | 270784.0 |
| 2024-08-28 | AAPR | ETF | 25.845 | 25.87 | 25.8 | 25.87 | 1571.0 |
| 2024-08-28 | AAPU | ETF | 37.23 | 37.8099 | 36.47 | 36.66 | 470057.0 |
| 2024-08-28 | AAPX | ETF | 33.77 | 34.25 | 33.19 | 33.23 | 13926.0 |
| 2024-08-28 | AAPY | ETF | 27.5372 | 27.5372 | 27.2449 | 27.296 | 568.0 |
| 2024-08-28 | AAXJ | ETF | 72.99 | 73.02 | 72.39 | 72.61 | 96543.0 |
| 2024-08-28 | ABCS | ETF | 27.8 | 27.86 | 27.624 | 27.7691 | 1350.0 |
| 2024-08-28 | ABEQ | ETF | 32.33 | 32.55 | 32.33 | 32.4657 | 4073.0 |
| 2024-08-28 | ABNY | ETF | 81.65 | 81.65 | 79.975 | 80.842 | 1818.0 |
| 2024-08-28 | ACES | ETF | 29.15 | 29.155 | 28.46 | 28.65 | 11613.0 |
| 2024-08-28 | ACIO | ETF | 39.18 | 39.18 | 38.8209 | 38.99 | 378503.0 |
| 2024-08-28 | ACSI | ETF | 56.6775 | 56.6775 | 56.6775 | 56.6775 | 46.0 |
| 2024-08-28 | ACT | ETF | 35.19 | 35.395 | 34.835 | 35.05 | 314590.0 |
| 2024-08-28 | ACTV | ETF | 32.775 | 32.83 | 32.54 | 32.6737 | 4602.0 |
| 2024-08-28 | ACVF | ETF | 42.77 | 42.82 | 42.3508 | 42.6097 | 11070.0 |
| 2024-08-28 | ACWI | ETF | 116.62 | 116.654 | 115.48 | 116.06 | 1113446.0 |
| 2024-08-28 | ACWV | ETF | 112.92 | 113.3639 | 112.697 | 112.95 | 195270.0 |
| 2024-08-28 | ACWX | ETF | 55.69 | 55.75 | 55.3 | 55.49 | 258254.0 |
| 2024-08-28 | ADFI | ETF | 8.72 | 8.78 | 8.71 | 8.74 | 4287.0 |
| 2024-08-28 | ADIV | ETF | 15.39 | 15.39 | 15.2847 | 15.2847 | 861.0 |
| 2024-08-28 | ADME | ETF | 45.4 | 45.41 | 44.975 | 45.165 | 19083.0 |
| 2024-08-28 | ADPV | ETF | 31.58 | 31.5801 | 31.498 | 31.498 | 1745.0 |
| 2024-08-28 | AEMB | ETF | 39.6059 | 39.6059 | 39.6059 | 39.6059 | 1.0 |
| 2024-08-28 | AESR | ETF | 16.66 | 16.66 | 16.47 | 16.567 | 8083.0 |
| 2024-08-28 | AETH | ETF | 32.55 | 32.85 | 31.88 | 32.5195 | 4526.0 |
| 2024-08-28 | AFIF | ETF | 9.15 | 9.19 | 9.15 | 9.182 | 16331.0 |
| 2024-08-28 | AFK | ETF | 16.56 | 16.57 | 16.36 | 16.4035 | 12044.0 |
| 2024-08-28 | AFLG | ETF | 33.09 | 33.09 | 32.87 | 32.98 | 3437.0 |
| 2024-08-28 | AFMC | ETF | 31.16 | 31.2374 | 31.14 | 31.2374 | 547.0 |
| 2024-08-28 | AFSM | ETF | 30.065 | 30.165 | 30.065 | 30.1355 | 1443.0 |
| 2024-08-28 | AFTY | ETF | 14.05 | 14.05 | 14.05 | 14.05 | 31.0 |
| 2024-08-28 | AGG | ETF | 100.71 | 100.77 | 100.6 | 100.62 | 6954368.0 |
| 2024-08-28 | AGGH | ETF | 21.61 | 21.61 | 21.4671 | 21.47 | 68318.0 |
| 2024-08-28 | AGGS | ETF | 42.29 | 42.29 | 42.2525 | 42.2525 | 182.0 |
| 2024-08-28 | AGGY | ETF | 44.42 | 44.4578 | 44.38 | 44.4 | 66311.0 |
| 2024-08-28 | AGIX | ETF | 24.19 | 24.3124 | 24.19 | 24.3124 | 1247.0 |
| 2024-08-28 | AGMI | ETF | 26.7 | 26.7 | 26.1915 | 26.1915 | 501.0 |
| 2024-08-28 | AGNG | ETF | 33.01 | 33.14 | 32.91 | 33.13 | 4784.0 |
| 2024-08-28 | AGOX | ETF | 29.35 | 29.35 | 28.66 | 28.88 | 40068.0 |
| 2024-08-28 | AGQ | ETF | 36.79 | 36.8 | 35.88 | 36.29 | 1354392.0 |
> showing 50 of 3,449 rows — these rows as CSV