PREVIEW / etf_daily / 2024-09-17
file: by_date/etf_daily/2024/2024-09-17.parquet size: 134 KB rows: 3,498
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-17 | SPY | ETF | 565.1 | 566.58 | 560.795 | 563.07 | 49258632.0 |
| 2024-09-17 | QQQ | ETF | 476.29 | 477.6 | 470.97 | 473.49 | 30084438.0 |
| 2024-09-17 | IWM | ETF | 219.58 | 221.8 | 218.47 | 219.41 | 35670772.0 |
| 2024-09-17 | DIA | ETF | 418.29 | 419.49 | 415.81 | 417.26 | 2557144.0 |
| 2024-09-17 | GLD | ETF | 238.08 | 238.6 | 236.61 | 237.34 | 5141349.0 |
| 2024-09-17 | TLT | ETF | 101.47 | 101.64 | 100.74 | 100.84 | 31675938.0 |
| 2024-09-17 | AAA | ETF | 25.1045 | 25.1045 | 25.01 | 25.03 | 4350.0 |
| 2024-09-17 | AAAU | ETF | 25.485 | 25.5399 | 25.325 | 25.4 | 2078515.0 |
| 2024-09-17 | AADR | ETF | 62.9034 | 62.9034 | 62.9034 | 62.9034 | 181.0 |
| 2024-09-17 | AAPB | ETF | 25.84 | 26.13 | 25.66 | 26.13 | 83845.0 |
| 2024-09-17 | AAPD | ETF | 17.91 | 18.0 | 17.81 | 17.81 | 214202.0 |
| 2024-09-17 | AAPR | ETF | 26.03 | 26.03 | 26.03 | 26.03 | 333.0 |
| 2024-09-17 | AAPU | ETF | 33.07 | 33.4 | 32.68 | 33.38 | 753593.0 |
| 2024-09-17 | AAPX | ETF | 29.96 | 30.1799 | 29.56 | 30.14 | 21746.0 |
| 2024-09-17 | AAPY | ETF | 26.22 | 26.2627 | 26.22 | 26.2627 | 588.0 |
| 2024-09-17 | AAXJ | ETF | 72.77 | 72.87 | 72.3 | 72.49 | 117869.0 |
| 2024-09-17 | ABCS | ETF | 28.02 | 28.115 | 27.94 | 27.94 | 4104.0 |
| 2024-09-17 | ABEQ | ETF | 32.7699 | 32.7699 | 32.56 | 32.6 | 5623.0 |
| 2024-09-17 | ABNY | ETF | 80.953 | 81.8995 | 80.65 | 81.4255 | 4197.0 |
| 2024-09-17 | ACES | ETF | 28.68 | 29.26 | 28.68 | 29.0 | 14870.0 |
| 2024-09-17 | ACIO | ETF | 39.37 | 39.37 | 39.0601 | 39.19 | 183726.0 |
| 2024-09-17 | ACSI | ETF | 57.1617 | 57.1617 | 57.1617 | 57.1617 | 35.0 |
| 2024-09-17 | ACT | ETF | 36.53 | 36.96 | 36.32 | 36.34 | 209292.0 |
| 2024-09-17 | ACTV | ETF | 33.12 | 33.354 | 33.05 | 33.1553 | 7020.0 |
| 2024-09-17 | ACVF | ETF | 43.15 | 43.17 | 42.81 | 42.8722 | 6929.0 |
| 2024-09-17 | ACWI | ETF | 116.96 | 117.13 | 116.08 | 116.49 | 1548664.0 |
| 2024-09-17 | ACWV | ETF | 114.32 | 114.44 | 113.44 | 113.69 | 113965.0 |
| 2024-09-17 | ACWX | ETF | 55.46 | 55.4851 | 55.03 | 55.19 | 342667.0 |
| 2024-09-17 | ADFI | ETF | 8.83 | 8.86 | 8.83 | 8.86 | 12709.0 |
| 2024-09-17 | ADIV | ETF | 15.28 | 15.28 | 15.26 | 15.26 | 4260.0 |
| 2024-09-17 | ADME | ETF | 45.53 | 45.63 | 45.26 | 45.34 | 5731.0 |
| 2024-09-17 | ADPV | ETF | 32.06 | 32.14 | 31.88 | 31.9233 | 7820.0 |
| 2024-09-17 | AEMB | ETF | 39.4 | 39.4348 | 39.39 | 39.4348 | 791.0 |
| 2024-09-17 | AESR | ETF | 16.7 | 16.7 | 16.55 | 16.5752 | 15825.0 |
| 2024-09-17 | AETH | ETF | 29.94 | 30.741 | 29.7707 | 30.3265 | 2805.0 |
| 2024-09-17 | AFIF | ETF | 9.255 | 9.26 | 9.23 | 9.255 | 10912.0 |
| 2024-09-17 | AFK | ETF | 16.56 | 16.59 | 16.15 | 16.28 | 8290.0 |
| 2024-09-17 | AFLG | ETF | 33.37 | 33.42 | 33.16 | 33.2304 | 8899.0 |
| 2024-09-17 | AFMC | ETF | 31.57 | 31.57 | 31.35 | 31.3599 | 1552.0 |
| 2024-09-17 | AFSM | ETF | 30.44 | 30.4913 | 30.1908 | 30.24 | 1864.0 |
| 2024-09-17 | AFTY | ETF | 13.53 | 13.53 | 13.53 | 13.53 | 19.0 |
| 2024-09-17 | AGG | ETF | 101.99 | 102.0301 | 101.825 | 101.88 | 9246198.0 |
| 2024-09-17 | AGGH | ETF | 22.03 | 22.03 | 21.86 | 22.0 | 67124.0 |
| 2024-09-17 | AGGY | ETF | 45.22 | 45.22 | 45.1101 | 45.17 | 211737.0 |
| 2024-09-17 | AGIX | ETF | 24.67 | 24.67 | 24.42 | 24.4833 | 3622.0 |
| 2024-09-17 | AGMI | ETF | 27.73 | 27.7541 | 27.73 | 27.7541 | 112.0 |
| 2024-09-17 | AGNG | ETF | 33.13 | 33.13 | 32.8459 | 32.8459 | 1828.0 |
| 2024-09-17 | AGOX | ETF | 28.65 | 28.79 | 28.25 | 28.27 | 30234.0 |
| 2024-09-17 | AGQ | ETF | 39.63 | 40.33 | 39.1135 | 39.48 | 1190823.0 |
| 2024-09-17 | AGQI | ETF | 14.55 | 14.58 | 14.48 | 14.49 | 7784.0 |
> showing 50 of 3,498 rows — these rows as CSV