PREVIEW / etf_daily / 2024-06-27
file: by_date/etf_daily/2024/2024-06-27.parquet size: 121 KB rows: 3,399
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-27 | SPY | ETF | 545.37 | 546.96 | 544.61 | 546.37 | 35041500.0 |
| 2024-06-27 | QQQ | ETF | 480.12 | 483.1 | 479.3 | 481.61 | 26222135.0 |
| 2024-06-27 | IWM | ETF | 200.63 | 202.15 | 199.96 | 202.06 | 17432600.0 |
| 2024-06-27 | DIA | ETF | 390.61 | 392.39 | 390.16 | 391.56 | 1601100.0 |
| 2024-06-27 | GLD | ETF | 214.71 | 215.5 | 214.45 | 214.99 | 4977800.0 |
| 2024-06-27 | TLT | ETF | 93.52 | 93.71 | 93.42 | 93.52 | 23140800.0 |
| 2024-06-27 | AAA | ETF | 25.05 | 25.28 | 25.05 | 25.2 | 23300.0 |
| 2024-06-27 | AAAU | ETF | 22.96 | 23.05 | 22.95 | 23.0 | 1463100.0 |
| 2024-06-27 | AADR | ETF | 61.64 | 61.98 | 61.52 | 61.75 | 2800.0 |
| 2024-06-27 | AAPB | ETF | 26.36 | 26.56 | 25.79 | 26.2 | 227236.0 |
| 2024-06-27 | AAPD | ETF | 17.89 | 18.0612 | 17.8 | 17.94 | 184918.0 |
| 2024-06-27 | AAPR | ETF | 25.28 | 25.29 | 25.22 | 25.29 | 52818.0 |
| 2024-06-27 | AAPU | ETF | 33.87 | 34.17 | 33.111 | 33.67 | 820775.0 |
| 2024-06-27 | AAPX | ETF | 30.74 | 30.9 | 30.11 | 30.55 | 12034.0 |
| 2024-06-27 | AAPY | ETF | 26.475 | 26.55 | 26.4 | 26.4649 | 2337.0 |
| 2024-06-27 | AAXJ | ETF | 72.27 | 72.27 | 71.82 | 71.86 | 162400.0 |
| 2024-06-27 | ABCS | ETF | 25.8 | 25.87 | 25.8 | 25.8591 | 2488.0 |
| 2024-06-27 | ABEQ | ETF | 30.055 | 30.106 | 30.052 | 30.106 | 7100.0 |
| 2024-06-27 | ABNY | ETF | 101.095 | 101.5235 | 100.91 | 101.5235 | 288.0 |
| 2024-06-27 | ACES | ETF | 28.69 | 29.29 | 28.59 | 29.2 | 79400.0 |
| 2024-06-27 | ACIO | ETF | 37.71 | 37.853 | 37.71 | 37.81 | 131200.0 |
| 2024-06-27 | ACSI | ETF | 55.327 | 55.327 | 55.327 | 55.327 | 100.0 |
| 2024-06-27 | ACT | ETF | 30.49 | 30.52 | 30.25 | 30.51 | 103955.0 |
| 2024-06-27 | ACTV | ETF | 31.81 | 31.9 | 31.68 | 31.835 | 6000.0 |
| 2024-06-27 | ACVF | ETF | 41.25 | 41.25 | 41.16 | 41.216 | 5700.0 |
| 2024-06-27 | ACWF | ETF | 42.48 | 42.48 | 42.3561 | 42.3561 | 1355.0 |
| 2024-06-27 | ACWI | ETF | 112.59 | 112.82 | 112.34 | 112.62 | 3234100.0 |
| 2024-06-27 | ACWV | ETF | 104.54 | 104.66 | 104.33 | 104.64 | 222800.0 |
| 2024-06-27 | ACWX | ETF | 53.14 | 53.23 | 52.97 | 53.08 | 580700.0 |
| 2024-06-27 | ADFI | ETF | 8.49 | 8.52 | 8.46 | 8.48 | 45700.0 |
| 2024-06-27 | ADIV | ETF | 14.8 | 14.8 | 14.705 | 14.705 | 1100.0 |
| 2024-06-27 | ADME | ETF | 43.68 | 43.89 | 43.68 | 43.859 | 5800.0 |
| 2024-06-27 | ADPV | ETF | 30.0307 | 30.27 | 30.0307 | 30.2271 | 1691.0 |
| 2024-06-27 | AEMB | ETF | 38.43 | 38.43 | 38.43 | 38.43 | 400.0 |
| 2024-06-27 | AESR | ETF | 16.36 | 16.45 | 16.35 | 16.42 | 45900.0 |
| 2024-06-27 | AETH | ETF | 45.13 | 45.19 | 45.0 | 45.0862 | 1666.0 |
| 2024-06-27 | AFIF | ETF | 9.12 | 9.12 | 9.1 | 9.11 | 7900.0 |
| 2024-06-27 | AFK | ETF | 15.75 | 15.8 | 15.54 | 15.7 | 8600.0 |
| 2024-06-27 | AFLG | ETF | 31.72 | 31.72 | 31.665 | 31.665 | 700.0 |
| 2024-06-27 | AFMC | ETF | 28.969 | 29.057 | 28.969 | 29.057 | 700.0 |
| 2024-06-27 | AFSM | ETF | 28.017 | 28.017 | 28.017 | 28.017 | 100.0 |
| 2024-06-27 | AFTY | ETF | 13.95 | 13.95 | 13.925 | 13.925 | 400.0 |
| 2024-06-27 | AGG | ETF | 97.56 | 97.67 | 97.54 | 97.55 | 5276500.0 |
| 2024-06-27 | AGGH | ETF | 20.91 | 20.91 | 20.81 | 20.91 | 111483.0 |
| 2024-06-27 | AGGY | ETF | 43.15 | 43.16 | 43.107 | 43.13 | 92200.0 |
| 2024-06-27 | AGMI | ETF | 25.65 | 25.74 | 25.574 | 25.574 | 400.0 |
| 2024-06-27 | AGNG | ETF | 30.215 | 30.215 | 30.08 | 30.16 | 2000.0 |
| 2024-06-27 | AGOX | ETF | 28.24 | 28.288 | 28.12 | 28.191 | 9500.0 |
| 2024-06-27 | AGQ | ETF | 37.04 | 37.3 | 36.39 | 36.69 | 826500.0 |
| 2024-06-27 | AGQI | ETF | 14.31 | 14.32 | 14.24 | 14.2661 | 7495.0 |
> showing 50 of 3,399 rows — these rows as CSV