PREVIEW / etf_daily / 2024-06-26
file: by_date/etf_daily/2024/2024-06-26.parquet size: 122 KB rows: 3,405
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-26 | SPY | ETF | 543.69 | 546.24 | 543.03 | 545.51 | 38550600.0 |
| 2024-06-26 | QQQ | ETF | 478.55 | 480.92 | 478.13 | 480.37 | 22737105.0 |
| 2024-06-26 | IWM | ETF | 199.33 | 200.58 | 198.81 | 200.03 | 19313500.0 |
| 2024-06-26 | DIA | ETF | 390.09 | 391.73 | 389.01 | 391.24 | 1501900.0 |
| 2024-06-26 | GLD | ETF | 212.39 | 213.11 | 212.12 | 212.58 | 4690300.0 |
| 2024-06-26 | TLT | ETF | 93.28 | 93.47 | 93.11 | 93.15 | 38489100.0 |
| 2024-06-26 | AAA | ETF | 25.18 | 25.18 | 25.16 | 25.17 | 4200.0 |
| 2024-06-26 | AAAU | ETF | 22.73 | 22.8 | 22.7 | 22.75 | 1470600.0 |
| 2024-06-26 | AADR | ETF | 61.93 | 61.93 | 61.93 | 61.93 | 300.0 |
| 2024-06-26 | AAPB | ETF | 25.56 | 26.3894 | 25.4 | 25.99 | 324531.0 |
| 2024-06-26 | AAPD | ETF | 18.14 | 18.22 | 17.8699 | 18.02 | 178594.0 |
| 2024-06-26 | AAPR | ETF | 25.225 | 25.27 | 25.21 | 25.23 | 12527.0 |
| 2024-06-26 | AAPU | ETF | 32.87 | 33.89 | 32.62 | 33.37 | 1473096.0 |
| 2024-06-26 | AAPX | ETF | 29.75 | 30.76 | 29.71 | 30.32 | 39234.0 |
| 2024-06-26 | AAPY | ETF | 26.4091 | 26.4091 | 26.401 | 26.401 | 817.0 |
| 2024-06-26 | AAXJ | ETF | 71.93 | 71.99 | 71.71 | 71.87 | 258700.0 |
| 2024-06-26 | ABCS | ETF | 25.85 | 25.9397 | 25.85 | 25.9397 | 2507.0 |
| 2024-06-26 | ABEQ | ETF | 30.23 | 30.253 | 30.19 | 30.241 | 2100.0 |
| 2024-06-26 | ABNY | ETF | 101.25 | 101.25 | 100.3 | 100.6705 | 1103.0 |
| 2024-06-26 | ACES | ETF | 28.82 | 29.158 | 28.71 | 28.94 | 115200.0 |
| 2024-06-26 | ACIO | ETF | 37.64 | 37.84 | 37.64 | 37.83 | 135200.0 |
| 2024-06-26 | ACSI | ETF | 55.481 | 55.481 | 55.481 | 55.481 | 100.0 |
| 2024-06-26 | ACT | ETF | 30.48 | 31.085 | 30.2 | 30.42 | 116942.0 |
| 2024-06-26 | ACTV | ETF | 31.73 | 31.89 | 31.7 | 31.867 | 9800.0 |
| 2024-06-26 | ACVF | ETF | 41.33 | 41.56 | 41.115 | 41.288 | 9100.0 |
| 2024-06-26 | ACWF | ETF | 42.18 | 42.35 | 42.18 | 42.342 | 530.0 |
| 2024-06-26 | ACWI | ETF | 112.2 | 112.58 | 112.05 | 112.46 | 2970100.0 |
| 2024-06-26 | ACWV | ETF | 104.61 | 104.99 | 104.33 | 104.54 | 195400.0 |
| 2024-06-26 | ACWX | ETF | 52.93 | 53.09 | 52.83 | 52.98 | 876300.0 |
| 2024-06-26 | ADFI | ETF | 8.5 | 8.559 | 8.5 | 8.51 | 23900.0 |
| 2024-06-26 | ADIV | ETF | 14.76 | 14.77 | 14.71 | 14.753 | 13400.0 |
| 2024-06-26 | ADME | ETF | 43.771 | 43.87 | 43.75 | 43.87 | 10400.0 |
| 2024-06-26 | ADPV | ETF | 29.89 | 29.9302 | 29.89 | 29.9302 | 639.0 |
| 2024-06-26 | AEMB | ETF | 38.415 | 38.415 | 38.415 | 38.415 | 100.0 |
| 2024-06-26 | AESR | ETF | 16.38 | 16.409 | 16.3 | 16.4 | 34400.0 |
| 2024-06-26 | AETH | ETF | 44.21 | 44.4308 | 43.47 | 44.4308 | 3011.0 |
| 2024-06-26 | AFIF | ETF | 9.08 | 9.12 | 9.08 | 9.12 | 12600.0 |
| 2024-06-26 | AFK | ETF | 15.73 | 15.8 | 15.54 | 15.8 | 4400.0 |
| 2024-06-26 | AFLG | ETF | 31.66 | 31.764 | 31.6 | 31.764 | 3400.0 |
| 2024-06-26 | AFMC | ETF | 28.91 | 29.09 | 28.87 | 29.03 | 2200.0 |
| 2024-06-26 | AFSM | ETF | 27.962 | 27.99 | 27.8 | 27.946 | 800.0 |
| 2024-06-26 | AFTY | ETF | 13.96 | 13.962 | 13.96 | 13.962 | 700.0 |
| 2024-06-26 | AGG | ETF | 97.43 | 97.49 | 97.37 | 97.39 | 4964100.0 |
| 2024-06-26 | AGGH | ETF | 20.79 | 20.845 | 20.75 | 20.8291 | 68034.0 |
| 2024-06-26 | AGGY | ETF | 43.06 | 43.09 | 43.03 | 43.09 | 131000.0 |
| 2024-06-26 | AGMI | ETF | 25.38 | 25.5519 | 25.38 | 25.5519 | 600.0 |
| 2024-06-26 | AGNG | ETF | 30.27 | 30.375 | 30.185 | 30.245 | 3000.0 |
| 2024-06-26 | AGOX | ETF | 28.05 | 28.3 | 28.02 | 28.167 | 14300.0 |
| 2024-06-26 | AGQ | ETF | 35.99 | 36.75 | 35.77 | 36.33 | 888500.0 |
| 2024-06-26 | AGQI | ETF | 14.426 | 14.4502 | 14.401 | 14.4471 | 9874.0 |
> showing 50 of 3,405 rows — these rows as CSV