PREVIEW / etf_daily / 2024-08-06
file: by_date/etf_daily/2024/2024-08-06.parquet size: 132 KB rows: 3,476
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-08-06 | SPY | ETF | 519.22 | 529.75 | 517.87 | 522.15 | 84436699.0 |
| 2024-08-06 | QQQ | ETF | 437.23 | 447.07 | 434.56 | 439.53 | 63164429.0 |
| 2024-08-06 | IWM | ETF | 203.01 | 207.25 | 201.2 | 204.4 | 36956110.0 |
| 2024-08-06 | DIA | ETF | 387.56 | 394.52 | 386.26 | 389.96 | 4027388.0 |
| 2024-08-06 | GLD | ETF | 221.5 | 222.14 | 220.11 | 220.7 | 14357106.0 |
| 2024-08-06 | TLT | ETF | 98.15 | 98.41 | 96.59 | 96.59 | 60630021.0 |
| 2024-08-06 | AAA | ETF | 25.04 | 25.0699 | 25.0 | 25.04 | 3862.0 |
| 2024-08-06 | AAAU | ETF | 23.71 | 23.77 | 23.5601 | 23.625 | 1753674.0 |
| 2024-08-06 | AADR | ETF | 56.01 | 57.68 | 56.01 | 57.05 | 4683.0 |
| 2024-08-06 | AAPB | ETF | 23.69 | 24.7298 | 22.71 | 24.06 | 201344.0 |
| 2024-08-06 | AAPD | ETF | 18.71 | 19.08 | 18.31 | 18.56 | 642122.0 |
| 2024-08-06 | AAPR | ETF | 25.235 | 25.27 | 25.21 | 25.2111 | 4666.0 |
| 2024-08-06 | AAPU | ETF | 30.42 | 31.73 | 29.1 | 30.85 | 711661.0 |
| 2024-08-06 | AAPX | ETF | 27.65 | 28.72 | 26.55 | 27.94 | 40270.0 |
| 2024-08-06 | AAPY | ETF | 25.5001 | 25.5001 | 25.2607 | 25.2607 | 654.0 |
| 2024-08-06 | AAXJ | ETF | 67.7 | 68.77 | 67.535 | 68.25 | 342685.0 |
| 2024-08-06 | ABCS | ETF | 26.0 | 26.4068 | 26.0 | 26.2 | 2680.0 |
| 2024-08-06 | ABEQ | ETF | 30.8301 | 30.97 | 30.8254 | 30.8254 | 2682.0 |
| 2024-08-06 | ABNY | ETF | 90.4 | 92.8 | 90.4 | 92.15 | 2533.0 |
| 2024-08-06 | ACES | ETF | 27.64 | 27.82 | 27.11 | 27.43 | 173497.0 |
| 2024-08-06 | ACIO | ETF | 36.98 | 37.453 | 36.76 | 37.08 | 341498.0 |
| 2024-08-06 | ACSI | ETF | 54.195 | 54.195 | 53.6586 | 53.6586 | 127.0 |
| 2024-08-06 | ACT | ETF | 32.31 | 32.79 | 32.19 | 32.76 | 211121.0 |
| 2024-08-06 | ACTV | ETF | 31.63 | 32.0101 | 31.29 | 31.63 | 8797.0 |
| 2024-08-06 | ACVF | ETF | 39.65 | 40.2475 | 39.64 | 39.8315 | 3152.0 |
| 2024-08-06 | ACWI | ETF | 107.28 | 109.24 | 106.96 | 107.97 | 4107187.0 |
| 2024-08-06 | ACWV | ETF | 106.09 | 107.2198 | 105.965 | 106.3 | 293839.0 |
| 2024-08-06 | ACWX | ETF | 50.7 | 51.5 | 50.6 | 51.19 | 1582022.0 |
| 2024-08-06 | ADFI | ETF | 8.64 | 8.65 | 8.6 | 8.6123 | 12716.0 |
| 2024-08-06 | ADIV | ETF | 13.96 | 14.055 | 13.96 | 14.0375 | 267.0 |
| 2024-08-06 | ADME | ETF | 42.67 | 43.139 | 42.67 | 42.75 | 23185.0 |
| 2024-08-06 | ADPV | ETF | 29.13 | 29.1301 | 28.9902 | 28.9959 | 710.0 |
| 2024-08-06 | AEMB | ETF | 38.85 | 38.85 | 38.59 | 38.5952 | 1039.0 |
| 2024-08-06 | AESR | ETF | 15.54 | 15.646 | 15.43 | 15.43 | 29187.0 |
| 2024-08-06 | AETH | ETF | 32.02 | 32.98 | 31.84 | 32.4276 | 5861.0 |
| 2024-08-06 | AFIF | ETF | 9.19 | 9.2 | 9.18 | 9.2 | 20131.0 |
| 2024-08-06 | AFK | ETF | 15.08 | 15.158 | 14.555 | 15.11 | 38664.0 |
| 2024-08-06 | AFLG | ETF | 30.768 | 30.768 | 30.768 | 30.768 | 401.0 |
| 2024-08-06 | AFMC | ETF | 29.17 | 29.67 | 29.17 | 29.5 | 5672.0 |
| 2024-08-06 | AFSM | ETF | 28.41 | 28.74 | 28.41 | 28.58 | 6955.0 |
| 2024-08-06 | AFTY | ETF | 13.818 | 13.818 | 13.818 | 13.818 | 133.0 |
| 2024-08-06 | AGG | ETF | 100.14 | 100.155 | 99.625 | 99.65 | 10887688.0 |
| 2024-08-06 | AGGH | ETF | 21.32 | 21.5044 | 21.32 | 21.39 | 160926.0 |
| 2024-08-06 | AGGY | ETF | 44.23 | 44.24 | 44.02 | 44.02 | 98775.0 |
| 2024-08-06 | AGIX | ETF | 22.61 | 22.63 | 22.4206 | 22.4206 | 430.0 |
| 2024-08-06 | AGMI | ETF | 24.53 | 24.7019 | 24.53 | 24.7019 | 102.0 |
| 2024-08-06 | AGNG | ETF | 30.03 | 30.55 | 30.01 | 30.18 | 130040.0 |
| 2024-08-06 | AGOX | ETF | 26.46 | 27.1 | 26.42 | 26.81 | 17737.0 |
| 2024-08-06 | AGQ | ETF | 30.94 | 31.86 | 30.84 | 31.24 | 1557751.0 |
| 2024-08-06 | AGQI | ETF | 13.55 | 13.75 | 13.5 | 13.6504 | 4827.0 |
> showing 50 of 3,476 rows — these rows as CSV