PREVIEW / etf_daily / 2024-06-06
file: by_date/etf_daily/2024/2024-06-06.parquet size: 120 KB rows: 3,373
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-06 | SPY | ETF | 534.98 | 535.42 | 532.68 | 534.66 | 30808500.0 |
| 2024-06-06 | QQQ | ETF | 464.22 | 464.54 | 462.19 | 463.37 | 21966820.0 |
| 2024-06-06 | IWM | ETF | 204.18 | 204.81 | 202.99 | 203.59 | 17335500.0 |
| 2024-06-06 | DIA | ETF | 388.81 | 390.59 | 387.79 | 389.33 | 2241900.0 |
| 2024-06-06 | GLD | ETF | 218.36 | 219.97 | 218.1 | 219.43 | 5283900.0 |
| 2024-06-06 | TLT | ETF | 92.92 | 93.43 | 92.86 | 93.21 | 22891900.0 |
| 2024-06-06 | AAA | ETF | 25.16 | 25.16 | 25.071 | 25.08 | 15100.0 |
| 2024-06-06 | AAAU | ETF | 23.34 | 23.53 | 23.34 | 23.47 | 3024800.0 |
| 2024-06-06 | AADR | ETF | 63.78 | 63.78 | 63.26 | 63.26 | 1300.0 |
| 2024-06-06 | AAPB | ETF | 22.29 | 22.3998 | 21.89 | 21.92 | 104280.0 |
| 2024-06-06 | AAPD | ETF | 19.89 | 20.06 | 19.85 | 20.04 | 78106.0 |
| 2024-06-06 | AAPR | ETF | 25.0192 | 25.05 | 24.9917 | 25.04 | 52109.0 |
| 2024-06-06 | AAPU | ETF | 28.68 | 28.9 | 28.23 | 28.32 | 513017.0 |
| 2024-06-06 | AAPX | ETF | 25.96 | 26.03 | 25.55 | 25.57 | 10865.0 |
| 2024-06-06 | AAXJ | ETF | 71.8 | 71.82 | 71.47 | 71.79 | 580900.0 |
| 2024-06-06 | ABCS | ETF | 25.71 | 26.3701 | 25.71 | 26.3001 | 2209.0 |
| 2024-06-06 | ABEQ | ETF | 30.48 | 30.551 | 30.47 | 30.53 | 13700.0 |
| 2024-06-06 | ACES | ETF | 31.56 | 31.75 | 31.25 | 31.55 | 18600.0 |
| 2024-06-06 | ACIO | ETF | 36.88 | 36.9 | 36.762 | 36.87 | 118100.0 |
| 2024-06-06 | ACSI | ETF | 54.024 | 54.024 | 54.024 | 54.024 | 100.0 |
| 2024-06-06 | ACT | ETF | 30.39 | 30.7026 | 29.85 | 30.03 | 224645.0 |
| 2024-06-06 | ACTV | ETF | 33.06 | 33.06 | 32.89 | 33.001 | 7500.0 |
| 2024-06-06 | ACVF | ETF | 40.59 | 40.59 | 40.43 | 40.498 | 9600.0 |
| 2024-06-06 | ACWF | ETF | 42.49 | 42.49 | 42.31 | 42.4002 | 11183.0 |
| 2024-06-06 | ACWI | ETF | 112.76 | 112.76 | 112.19 | 112.54 | 2458000.0 |
| 2024-06-06 | ACWV | ETF | 105.1 | 105.41 | 105.04 | 105.25 | 111200.0 |
| 2024-06-06 | ACWX | ETF | 54.74 | 54.86 | 54.66 | 54.86 | 332800.0 |
| 2024-06-06 | ADFI | ETF | 8.51 | 8.57 | 8.5 | 8.55 | 7100.0 |
| 2024-06-06 | ADIV | ETF | 14.82 | 14.82 | 14.82 | 14.82 | 100.0 |
| 2024-06-06 | ADME | ETF | 42.76 | 42.81 | 42.74 | 42.81 | 13100.0 |
| 2024-06-06 | ADPV | ETF | 30.52 | 30.55 | 29.84 | 29.9408 | 28346.0 |
| 2024-06-06 | AEMB | ETF | 38.497 | 38.56 | 38.45 | 38.45 | 2500.0 |
| 2024-06-06 | AESR | ETF | 16.05 | 16.05 | 15.99 | 16.02 | 27600.0 |
| 2024-06-06 | AETH | ETF | 50.48 | 50.5 | 49.701 | 49.7223 | 9231.0 |
| 2024-06-06 | AFIF | ETF | 9.21 | 9.21 | 9.13 | 9.15 | 2300.0 |
| 2024-06-06 | AFK | ETF | 15.68 | 15.79 | 15.55 | 15.69 | 3900.0 |
| 2024-06-06 | AFLG | ETF | 31.265 | 31.288 | 31.128 | 31.128 | 1200.0 |
| 2024-06-06 | AFMC | ETF | 29.31 | 29.324 | 29.31 | 29.324 | 300.0 |
| 2024-06-06 | AFSM | ETF | 28.83 | 28.83 | 28.56 | 28.56 | 1300.0 |
| 2024-06-06 | AFTY | ETF | 14.5 | 14.5 | 14.5 | 14.5 | 100.0 |
| 2024-06-06 | AGG | ETF | 97.31 | 97.5 | 97.31 | 97.48 | 6568700.0 |
| 2024-06-06 | AGGH | ETF | 21.0 | 21.0 | 20.96 | 21.0 | 41014.0 |
| 2024-06-06 | AGGY | ETF | 43.19 | 43.28 | 43.19 | 43.26 | 52300.0 |
| 2024-06-06 | AGMI | ETF | 27.01 | 27.6799 | 27.01 | 27.6133 | 875.0 |
| 2024-06-06 | AGNG | ETF | 30.32 | 30.39 | 30.32 | 30.39 | 1800.0 |
| 2024-06-06 | AGOX | ETF | 27.54 | 27.54 | 27.02 | 27.121 | 15100.0 |
| 2024-06-06 | AGQ | ETF | 41.39 | 43.75 | 40.93 | 43.53 | 1505900.0 |
| 2024-06-06 | AGQI | ETF | 14.49 | 14.51 | 14.47 | 14.51 | 9471.0 |
| 2024-06-06 | AGZ | ETF | 107.74 | 107.92 | 107.72 | 107.92 | 11200.0 |
| 2024-06-06 | AGZD | ETF | 22.3 | 22.31 | 22.23 | 22.29 | 15800.0 |
> showing 50 of 3,373 rows — these rows as CSV