PREVIEW / etf_daily / 2024-08-26
file: by_date/etf_daily/2024/2024-08-26.parquet size: 133 KB rows: 3,477
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-26 | SPY | ETF | 563.18 | 563.91 | 559.05 | 560.79 | 35164187.0 |
| 2024-08-26 | QQQ | ETF | 479.45 | 480.38 | 473.24 | 475.34 | 27452641.0 |
| 2024-08-26 | IWM | ETF | 221.93 | 222.45 | 220.08 | 220.45 | 24729668.0 |
| 2024-08-26 | DIA | ETF | 412.64 | 414.515 | 411.6528 | 412.72 | 3142297.0 |
| 2024-08-26 | GLD | ETF | 233.45 | 233.5 | 232.06 | 232.76 | 3142923.0 |
| 2024-08-26 | TLT | ETF | 98.69 | 98.6975 | 98.08 | 98.14 | 23184794.0 |
| 2024-08-26 | AAA | ETF | 25.12 | 25.16 | 25.05 | 25.09 | 10201.0 |
| 2024-08-26 | AAAU | ETF | 24.99 | 24.99 | 24.835 | 24.91 | 2610205.0 |
| 2024-08-26 | AADR | ETF | 62.16 | 62.1601 | 61.91 | 61.91 | 640.0 |
| 2024-08-26 | AAPB | ETF | 28.84 | 28.9 | 28.05 | 28.9 | 46905.0 |
| 2024-08-26 | AAPD | ETF | 16.96 | 17.1901 | 16.94 | 16.95 | 147651.0 |
| 2024-08-26 | AAPR | ETF | 25.9 | 25.9 | 25.8461 | 25.8461 | 349.0 |
| 2024-08-26 | AAPU | ETF | 36.862 | 36.96 | 35.88 | 36.96 | 589187.0 |
| 2024-08-26 | AAPX | ETF | 33.22 | 33.48 | 32.5 | 33.48 | 15729.0 |
| 2024-08-26 | AAPY | ETF | 27.32 | 27.32 | 27.1 | 27.3152 | 1665.0 |
| 2024-08-26 | AAXJ | ETF | 73.4 | 73.4 | 72.83 | 72.96 | 100066.0 |
| 2024-08-26 | ABCS | ETF | 27.953 | 27.9661 | 27.8865 | 27.8865 | 1000.0 |
| 2024-08-26 | ABEQ | ETF | 32.46 | 32.46 | 32.342 | 32.3648 | 1449.0 |
| 2024-08-26 | ABNY | ETF | 79.999 | 80.0495 | 79.5185 | 79.6085 | 4906.0 |
| 2024-08-26 | ACES | ETF | 29.83 | 30.14 | 29.55 | 29.6 | 86271.0 |
| 2024-08-26 | ACIO | ETF | 39.33 | 39.33 | 38.9957 | 39.1 | 154285.0 |
| 2024-08-26 | ACSI | ETF | 56.64 | 56.88 | 56.64 | 56.79 | 1399.0 |
| 2024-08-26 | ACT | ETF | 35.52 | 35.7 | 35.28 | 35.3 | 231902.0 |
| 2024-08-26 | ACTV | ETF | 33.16 | 33.16 | 33.0545 | 33.0545 | 3571.0 |
| 2024-08-26 | ACVF | ETF | 42.88 | 42.9 | 42.64 | 42.6404 | 5217.0 |
| 2024-08-26 | ACWI | ETF | 116.9 | 117.0 | 116.21 | 116.47 | 2118125.0 |
| 2024-08-26 | ACWV | ETF | 112.86 | 113.23 | 112.38 | 112.86 | 112044.0 |
| 2024-08-26 | ACWX | ETF | 55.82 | 55.875 | 55.535 | 55.6 | 557840.0 |
| 2024-08-26 | ADFI | ETF | 8.72 | 8.75 | 8.71 | 8.74 | 19447.0 |
| 2024-08-26 | ADIV | ETF | 15.39 | 15.47 | 15.39 | 15.41 | 2021.0 |
| 2024-08-26 | ADME | ETF | 45.33 | 45.35 | 45.2299 | 45.35 | 23034.0 |
| 2024-08-26 | ADPV | ETF | 32.08 | 32.08 | 31.7779 | 31.7779 | 3940.0 |
| 2024-08-26 | AEMB | ETF | 39.56 | 39.9 | 39.11 | 39.6879 | 3047.0 |
| 2024-08-26 | AESR | ETF | 16.72 | 16.72 | 16.58 | 16.62 | 25517.0 |
| 2024-08-26 | AETH | ETF | 35.21 | 35.32 | 34.7384 | 34.7384 | 1187.0 |
| 2024-08-26 | AFIF | ETF | 9.1737 | 9.1899 | 9.16 | 9.18 | 18342.0 |
| 2024-08-26 | AFK | ETF | 16.75 | 16.76 | 16.4901 | 16.58 | 9607.0 |
| 2024-08-26 | AFLG | ETF | 33.28 | 33.28 | 33.03 | 33.04 | 5236.0 |
| 2024-08-26 | AFMC | ETF | 31.8 | 31.8 | 31.4291 | 31.4291 | 665.0 |
| 2024-08-26 | AFSM | ETF | 30.656 | 30.656 | 30.442 | 30.442 | 8135.0 |
| 2024-08-26 | AFTY | ETF | 14.2 | 14.2 | 14.2 | 14.2 | 3.0 |
| 2024-08-26 | AGG | ETF | 100.92 | 100.92 | 100.66 | 100.68 | 6644777.0 |
| 2024-08-26 | AGGH | ETF | 22.43 | 22.43 | 21.675 | 21.82 | 86372.0 |
| 2024-08-26 | AGGY | ETF | 44.69 | 44.69 | 44.59 | 44.6026 | 68514.0 |
| 2024-08-26 | AGIX | ETF | 25.0 | 25.0 | 24.58 | 24.6173 | 609.0 |
| 2024-08-26 | AGMI | ETF | 27.39 | 27.39 | 27.2005 | 27.2005 | 287.0 |
| 2024-08-26 | AGNG | ETF | 32.95 | 33.64 | 32.83 | 32.95 | 10442.0 |
| 2024-08-26 | AGOX | ETF | 29.57 | 29.57 | 29.0 | 29.3 | 67686.0 |
| 2024-08-26 | AGQ | ETF | 38.37 | 38.4399 | 37.6 | 38.12 | 1369070.0 |
| 2024-08-26 | AGQI | ETF | 14.5965 | 14.5965 | 14.56 | 14.5632 | 2908.0 |
> showing 50 of 3,477 rows — these rows as CSV