PREVIEW / etf_daily / 2024-07-24
file: by_date/etf_daily/2024/2024-07-24.parquet size: 133 KB rows: 3,446
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-24 | SPY | ETF | 548.86 | 549.17 | 540.29 | 541.23 | 74441585.0 |
| 2024-07-24 | QQQ | ETF | 473.82 | 474.19 | 462.51 | 463.38 | 58818629.0 |
| 2024-07-24 | IWM | ETF | 221.07 | 223.86 | 217.715 | 217.85 | 42563541.0 |
| 2024-07-24 | DIA | ETF | 401.73 | 402.63 | 398.08 | 398.67 | 3699655.0 |
| 2024-07-24 | GLD | ETF | 223.47 | 224.88 | 221.74 | 221.8 | 6670401.0 |
| 2024-07-24 | TLT | ETF | 92.59 | 92.85 | 91.47 | 91.52 | 50632136.0 |
| 2024-07-24 | AAA | ETF | 25.1104 | 25.147 | 25.1 | 25.135 | 6092.0 |
| 2024-07-24 | AAAU | ETF | 23.915 | 24.0606 | 23.725 | 23.73 | 2012270.0 |
| 2024-07-24 | AADR | ETF | 62.4497 | 62.4497 | 61.52 | 61.52 | 160.0 |
| 2024-07-24 | AAPB | ETF | 28.46 | 28.52 | 26.652 | 27.02 | 159518.0 |
| 2024-07-24 | AAPD | ETF | 17.16 | 17.69 | 17.13 | 17.58 | 536664.0 |
| 2024-07-24 | AAPR | ETF | 25.3888 | 25.42 | 25.29 | 25.34 | 10840.0 |
| 2024-07-24 | AAPU | ETF | 36.5 | 36.6407 | 34.1601 | 34.64 | 833319.0 |
| 2024-07-24 | AAPX | ETF | 32.91 | 32.91 | 31.0 | 31.47 | 31146.0 |
| 2024-07-24 | AAPY | ETF | 26.84 | 26.84 | 26.538 | 26.538 | 479.0 |
| 2024-07-24 | AAXJ | ETF | 71.41 | 71.56 | 70.71 | 70.72 | 491806.0 |
| 2024-07-24 | ABCS | ETF | 27.21 | 27.21 | 26.7881 | 26.7881 | 1400.0 |
| 2024-07-24 | ABEQ | ETF | 30.9672 | 31.0242 | 30.8857 | 30.8857 | 1259.0 |
| 2024-07-24 | ABNY | ETF | 102.0 | 102.0 | 99.65 | 100.1665 | 1020.0 |
| 2024-07-24 | ACES | ETF | 30.18 | 30.52 | 29.65 | 29.67 | 80295.0 |
| 2024-07-24 | ACIO | ETF | 37.98 | 38.035 | 37.75 | 37.75 | 59922.0 |
| 2024-07-24 | ACSI | ETF | 54.8094 | 54.8094 | 54.8094 | 54.8094 | 13.0 |
| 2024-07-24 | ACT | ETF | 33.68 | 34.11 | 33.65 | 33.71 | 238766.0 |
| 2024-07-24 | ACTV | ETF | 33.14 | 33.14 | 32.6 | 32.6004 | 10329.0 |
| 2024-07-24 | ACVF | ETF | 41.66 | 41.66 | 41.04 | 41.0584 | 26464.0 |
| 2024-07-24 | ACWI | ETF | 113.5 | 113.55 | 111.89 | 112.02 | 2819354.0 |
| 2024-07-24 | ACWV | ETF | 106.78 | 107.11 | 106.71 | 106.85 | 142434.0 |
| 2024-07-24 | ACWX | ETF | 53.72 | 53.88 | 53.24 | 53.27 | 2011802.0 |
| 2024-07-24 | ADFI | ETF | 8.5699 | 8.5699 | 8.48 | 8.5087 | 8080.0 |
| 2024-07-24 | ADIV | ETF | 14.48 | 14.48 | 14.315 | 14.315 | 1213.0 |
| 2024-07-24 | ADME | ETF | 44.075 | 44.09 | 43.66 | 43.69 | 17133.0 |
| 2024-07-24 | ADPV | ETF | 31.0 | 31.03 | 30.495 | 30.495 | 3634.0 |
| 2024-07-24 | AEMB | ETF | 38.75 | 38.75 | 38.44 | 38.4449 | 1257.0 |
| 2024-07-24 | AESR | ETF | 16.3 | 16.3 | 15.97 | 15.9801 | 21673.0 |
| 2024-07-24 | AETH | ETF | 45.02 | 45.11 | 43.85 | 43.8617 | 26694.0 |
| 2024-07-24 | AFIF | ETF | 9.13 | 9.15 | 9.13 | 9.1348 | 41569.0 |
| 2024-07-24 | AFK | ETF | 16.04 | 16.28 | 15.82 | 15.9 | 198461.0 |
| 2024-07-24 | AFLG | ETF | 31.72 | 31.78 | 31.51 | 31.5211 | 3596.0 |
| 2024-07-24 | AFMC | ETF | 30.69 | 30.77 | 30.2603 | 30.2603 | 395.0 |
| 2024-07-24 | AFSM | ETF | 30.8 | 30.84 | 30.0977 | 30.0977 | 7286.0 |
| 2024-07-24 | AFTY | ETF | 14.12 | 14.1342 | 14.095 | 14.095 | 1890.0 |
| 2024-07-24 | AGG | ETF | 97.82 | 98.19 | 97.7 | 97.7 | 6540040.0 |
| 2024-07-24 | AGGH | ETF | 21.06 | 21.12 | 20.91 | 20.91 | 77849.0 |
| 2024-07-24 | AGGY | ETF | 43.4883 | 43.4963 | 43.295 | 43.32 | 60340.0 |
| 2024-07-24 | AGIX | ETF | 25.05 | 25.05 | 23.9837 | 23.9837 | 13191.0 |
| 2024-07-24 | AGMI | ETF | 27.66 | 27.66 | 27.305 | 27.305 | 908.0 |
| 2024-07-24 | AGNG | ETF | 31.26 | 31.4039 | 31.2 | 31.3 | 4798.0 |
| 2024-07-24 | AGOX | ETF | 28.11 | 28.11 | 27.4663 | 27.4663 | 27950.0 |
| 2024-07-24 | AGQ | ETF | 37.05 | 37.49 | 36.17 | 36.22 | 1414825.0 |
| 2024-07-24 | AGQI | ETF | 14.31 | 14.36 | 14.2295 | 14.2295 | 18461.0 |
> showing 50 of 3,446 rows — these rows as CSV