PREVIEW / etf_daily / 2024-06-20
file: by_date/etf_daily/2024/2024-06-20.parquet size: 122 KB rows: 3,420
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-06-20 | SPY | ETF | 549.44 | 550.12 | 545.18 | 547.0 | 70328200.0 |
| 2024-06-20 | QQQ | ETF | 486.42 | 486.8387 | 479.62 | 481.47 | 33918683.0 |
| 2024-06-20 | IWM | ETF | 200.32 | 201.86 | 199.22 | 199.9 | 27999700.0 |
| 2024-06-20 | DIA | ETF | 388.74 | 393.11 | 388.38 | 392.07 | 3588000.0 |
| 2024-06-20 | GLD | ETF | 216.32 | 218.74 | 216.15 | 218.16 | 7290500.0 |
| 2024-06-20 | TLT | ETF | 93.41 | 94.0 | 93.34 | 93.96 | 30246300.0 |
| 2024-06-20 | AAA | ETF | 25.155 | 25.165 | 25.09 | 25.14 | 6900.0 |
| 2024-06-20 | AAAU | ETF | 23.13 | 23.39 | 23.12 | 23.35 | 1422700.0 |
| 2024-06-20 | AADR | ETF | 62.62 | 62.62 | 62.1 | 62.22 | 600.0 |
| 2024-06-20 | AAPB | ETF | 26.24 | 26.28 | 24.99 | 25.16 | 518543.0 |
| 2024-06-20 | AAPD | ETF | 18.14 | 18.5708 | 18.14 | 18.5 | 371512.0 |
| 2024-06-20 | AAPR | ETF | 25.3 | 25.32 | 25.2171 | 25.27 | 35834.0 |
| 2024-06-20 | AAPU | ETF | 33.93 | 34.01 | 32.29 | 32.54 | 1761169.0 |
| 2024-06-20 | AAPX | ETF | 30.54 | 30.61 | 29.16 | 29.32 | 54707.0 |
| 2024-06-20 | AAPY | ETF | 26.56 | 26.5699 | 26.52 | 26.5277 | 1290.0 |
| 2024-06-20 | AAXJ | ETF | 72.94 | 72.94 | 72.24 | 72.59 | 358200.0 |
| 2024-06-20 | ABCS | ETF | 26.06 | 26.15 | 26.02 | 26.15 | 27313.0 |
| 2024-06-20 | ABEQ | ETF | 30.15 | 30.211 | 30.13 | 30.211 | 900.0 |
| 2024-06-20 | ACES | ETF | 29.0 | 29.0 | 28.461 | 28.53 | 52800.0 |
| 2024-06-20 | ACIO | ETF | 37.79 | 37.83 | 37.635 | 37.72 | 299900.0 |
| 2024-06-20 | ACSI | ETF | 54.794 | 54.804 | 54.794 | 54.804 | 300.0 |
| 2024-06-20 | ACT | ETF | 29.97 | 30.35 | 29.97 | 30.32 | 151067.0 |
| 2024-06-20 | ACTV | ETF | 31.91 | 31.934 | 31.7 | 31.72 | 8700.0 |
| 2024-06-20 | ACVF | ETF | 41.84 | 41.84 | 41.527 | 41.55 | 5400.0 |
| 2024-06-20 | ACWF | ETF | 42.58 | 42.58 | 42.39 | 42.435 | 1528.0 |
| 2024-06-20 | ACWI | ETF | 112.98 | 113.08 | 112.21 | 112.6 | 3286100.0 |
| 2024-06-20 | ACWV | ETF | 104.27 | 104.79 | 104.27 | 104.76 | 154900.0 |
| 2024-06-20 | ACWX | ETF | 53.15 | 53.31 | 53.04 | 53.2 | 776900.0 |
| 2024-06-20 | ADFI | ETF | 8.49 | 8.579 | 8.46 | 8.54 | 36200.0 |
| 2024-06-20 | ADIV | ETF | 15.03 | 15.03 | 14.93 | 14.935 | 3200.0 |
| 2024-06-20 | ADME | ETF | 43.89 | 43.95 | 43.71 | 43.796 | 13300.0 |
| 2024-06-20 | ADPV | ETF | 30.2201 | 30.26 | 29.96 | 30.0115 | 2335.0 |
| 2024-06-20 | AEMB | ETF | 38.48 | 38.48 | 38.48 | 38.48 | 100.0 |
| 2024-06-20 | AESR | ETF | 16.52 | 16.52 | 16.39 | 16.439 | 39000.0 |
| 2024-06-20 | AETH | ETF | 46.4 | 46.4 | 45.691 | 45.9981 | 5586.0 |
| 2024-06-20 | AFIF | ETF | 9.2 | 9.2 | 9.1 | 9.12 | 21600.0 |
| 2024-06-20 | AFK | ETF | 15.98 | 15.98 | 15.69 | 15.95 | 7700.0 |
| 2024-06-20 | AFLG | ETF | 32.14 | 32.14 | 31.76 | 31.761 | 600.0 |
| 2024-06-20 | AFMC | ETF | 29.5 | 29.5 | 29.162 | 29.198 | 8200.0 |
| 2024-06-20 | AFSM | ETF | 28.25 | 28.25 | 27.935 | 27.935 | 800.0 |
| 2024-06-20 | AFTY | ETF | 14.0 | 14.043 | 14.0 | 14.043 | 1300.0 |
| 2024-06-20 | AGG | ETF | 97.55 | 97.77 | 97.52 | 97.75 | 5621600.0 |
| 2024-06-20 | AGGH | ETF | 21.11 | 21.11 | 21.0001 | 21.06 | 71473.0 |
| 2024-06-20 | AGGY | ETF | 43.28 | 43.34 | 43.26 | 43.34 | 83500.0 |
| 2024-06-20 | AGMI | ETF | 26.13 | 26.6753 | 26.13 | 26.6753 | 455.0 |
| 2024-06-20 | AGNG | ETF | 29.88 | 30.043 | 29.84 | 30.043 | 3300.0 |
| 2024-06-20 | AGOX | ETF | 28.74 | 28.74 | 27.93 | 28.059 | 34400.0 |
| 2024-06-20 | AGQ | ETF | 39.94 | 41.69 | 39.69 | 41.36 | 1940400.0 |
| 2024-06-20 | AGQI | ETF | 14.44 | 14.4755 | 14.4 | 14.4228 | 22686.0 |
| 2024-06-20 | AGRH | ETF | 25.93 | 25.95 | 25.86 | 25.86 | 2218.0 |
> showing 50 of 3,420 rows — these rows as CSV