PREVIEW / etf_daily / 2024-07-03
file: by_date/etf_daily/2024/2024-07-03.parquet size: 129 KB rows: 3,375
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-07-03 | SPY | ETF | 548.69 | 551.83 | 548.65 | 551.46 | 32881221.0 |
| 2024-07-03 | QQQ | ETF | 486.22 | 491.17 | 486.22 | 491.04 | 18064880.0 |
| 2024-07-03 | IWM | ETF | 202.25 | 203.28 | 201.63 | 201.83 | 14857882.0 |
| 2024-07-03 | DIA | ETF | 393.73 | 394.055 | 392.1401 | 392.83 | 2319124.0 |
| 2024-07-03 | GLD | ETF | 217.34 | 218.7397 | 217.33 | 217.99 | 5054880.0 |
| 2024-07-03 | TLT | ETF | 91.17 | 91.89 | 91.085 | 91.8 | 38329982.0 |
| 2024-07-03 | AAA | ETF | 25.07 | 25.09 | 25.01 | 25.05 | 11938.0 |
| 2024-07-03 | AAAU | ETF | 23.25 | 23.4011 | 23.25 | 23.325 | 1602953.0 |
| 2024-07-03 | AADR | ETF | 62.3629 | 62.3629 | 62.0 | 62.23 | 2438.0 |
| 2024-07-03 | AAPB | ETF | 27.61 | 27.969 | 27.4119 | 27.96 | 307106.0 |
| 2024-07-03 | AAPD | ETF | 17.45 | 17.53 | 17.34 | 17.34 | 149517.0 |
| 2024-07-03 | AAPR | ETF | 25.305 | 25.39 | 25.29 | 25.37 | 37450.0 |
| 2024-07-03 | AAPU | ETF | 35.38 | 35.89 | 35.1209 | 35.89 | 1079565.0 |
| 2024-07-03 | AAPX | ETF | 32.2 | 32.62 | 31.87 | 32.62 | 48688.0 |
| 2024-07-03 | AAPY | ETF | 26.98 | 26.9905 | 26.8 | 26.9905 | 2156.0 |
| 2024-07-03 | AAXJ | ETF | 72.99 | 73.615 | 72.99 | 73.56 | 148962.0 |
| 2024-07-03 | ABCS | ETF | 25.92 | 25.96 | 25.9126 | 25.9126 | 3182.0 |
| 2024-07-03 | ABEQ | ETF | 30.08 | 30.1399 | 30.042 | 30.0567 | 1499.0 |
| 2024-07-03 | ABNY | ETF | 106.6 | 106.6 | 102.9 | 103.4255 | 828.0 |
| 2024-07-03 | ACES | ETF | 28.35 | 29.19 | 28.35 | 29.1 | 129418.0 |
| 2024-07-03 | ACIO | ETF | 37.95 | 38.16 | 37.95 | 38.14 | 66276.0 |
| 2024-07-03 | ACSI | ETF | 55.7475 | 55.7475 | 55.7475 | 55.7475 | 11.0 |
| 2024-07-03 | ACT | ETF | 30.98 | 31.06 | 30.82 | 30.85 | 83098.0 |
| 2024-07-03 | ACTV | ETF | 31.97 | 32.205 | 31.97 | 31.9904 | 7535.0 |
| 2024-07-03 | ACVF | ETF | 41.42 | 41.5889 | 41.38 | 41.5889 | 3081.0 |
| 2024-07-03 | ACWI | ETF | 113.37 | 114.07 | 113.37 | 114.01 | 691503.0 |
| 2024-07-03 | ACWV | ETF | 104.96 | 105.245 | 104.8203 | 105.03 | 112265.0 |
| 2024-07-03 | ACWX | ETF | 54.5 | 54.84 | 53.71 | 54.02 | 737115.0 |
| 2024-07-03 | ADFI | ETF | 8.47 | 8.4701 | 8.4549 | 8.47 | 16273.0 |
| 2024-07-03 | ADIV | ETF | 14.83 | 14.885 | 14.83 | 14.885 | 212.0 |
| 2024-07-03 | ADME | ETF | 44.1915 | 44.35 | 44.1915 | 44.35 | 3854.0 |
| 2024-07-03 | ADPV | ETF | 30.43 | 30.7148 | 30.43 | 30.7148 | 174.0 |
| 2024-07-03 | AEMB | ETF | 38.43 | 38.43 | 38.3162 | 38.3162 | 517.0 |
| 2024-07-03 | AESR | ETF | 16.5 | 16.575 | 16.5 | 16.575 | 15317.0 |
| 2024-07-03 | AETH | ETF | 43.2463 | 43.3 | 43.02 | 43.2033 | 3370.0 |
| 2024-07-03 | AFIF | ETF | 9.13 | 9.14 | 9.13 | 9.14 | 2189.0 |
| 2024-07-03 | AFK | ETF | 15.71 | 15.87 | 15.58 | 15.83 | 79655.0 |
| 2024-07-03 | AFLG | ETF | 31.7664 | 31.8261 | 31.7298 | 31.8261 | 28143.0 |
| 2024-07-03 | AFMC | ETF | 29.13 | 29.29 | 29.0991 | 29.1137 | 3528.0 |
| 2024-07-03 | AFSM | ETF | 28.4 | 28.42 | 28.19 | 28.2644 | 2251.0 |
| 2024-07-03 | AFTY | ETF | 14.12 | 14.1338 | 14.12 | 14.1338 | 601.0 |
| 2024-07-03 | AGG | ETF | 96.8 | 97.165 | 96.77 | 97.09 | 4045488.0 |
| 2024-07-03 | AGGH | ETF | 20.63 | 20.85 | 20.63 | 20.85 | 67717.0 |
| 2024-07-03 | AGGY | ETF | 43.0 | 43.11 | 42.95 | 43.11 | 128653.0 |
| 2024-07-03 | AGMI | ETF | 26.1 | 26.84 | 26.1 | 26.7242 | 474.0 |
| 2024-07-03 | AGNG | ETF | 30.11 | 30.11 | 29.9 | 30.0033 | 2134.0 |
| 2024-07-03 | AGOX | ETF | 28.23 | 28.37 | 28.12 | 28.325 | 30306.0 |
| 2024-07-03 | AGQ | ETF | 40.19 | 41.05 | 40.1 | 40.59 | 1913284.0 |
| 2024-07-03 | AGQI | ETF | 14.38 | 14.42 | 14.38 | 14.4169 | 2916.0 |
| 2024-07-03 | AGRH | ETF | 25.8001 | 25.87 | 25.8001 | 25.8325 | 430.0 |
> showing 50 of 3,375 rows — these rows as CSV