PREVIEW / etf_daily / 2024-11-22
file: by_date/etf_daily/2024/2024-11-22.parquet size: 146 KB rows: 3,790
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-11-22 | SPY | ETF | 593.66 | 596.15 | 593.1525 | 595.51 | 38055532.0 |
| 2024-11-22 | QQQ | ETF | 504.42 | 506.53 | 502.78 | 505.79 | 23826644.0 |
| 2024-11-22 | IWM | ETF | 235.64 | 239.235 | 235.33 | 238.77 | 22592712.0 |
| 2024-11-22 | DIA | ETF | 439.59 | 443.57 | 439.32 | 443.16 | 5397190.0 |
| 2024-11-22 | GLD | ETF | 248.2 | 250.39 | 247.86 | 249.84 | 7254083.0 |
| 2024-11-22 | TLT | ETF | 90.51 | 90.7 | 90.15 | 90.39 | 21484372.0 |
| 2024-11-22 | AAA | ETF | 25.09 | 25.125 | 25.0801 | 25.125 | 7338.0 |
| 2024-11-22 | AAAU | ETF | 26.56 | 26.81 | 26.54 | 26.76 | 2975478.0 |
| 2024-11-22 | AADR | ETF | 67.5 | 67.5 | 67.5 | 67.5 | 40.0 |
| 2024-11-22 | AAPB | ETF | 28.37 | 28.95 | 28.37 | 28.72 | 50917.0 |
| 2024-11-22 | AAPD | ETF | 16.815 | 16.815 | 16.6829 | 16.75 | 78470.0 |
| 2024-11-22 | AAPR | ETF | 26.35 | 26.38 | 26.29 | 26.29 | 12139.0 |
| 2024-11-22 | AAPU | ETF | 35.89 | 36.64 | 35.82 | 36.32 | 262008.0 |
| 2024-11-22 | AAPX | ETF | 32.91 | 33.3001 | 32.8 | 33.0834 | 9855.0 |
| 2024-11-22 | AAPY | ETF | 26.7415 | 26.89 | 26.71 | 26.8188 | 1829.0 |
| 2024-11-22 | AAXJ | ETF | 73.84 | 74.03 | 73.74 | 74.0 | 202287.0 |
| 2024-11-22 | ABCS | ETF | 30.15 | 30.3248 | 30.15 | 30.3248 | 2402.0 |
| 2024-11-22 | ABEQ | ETF | 33.06 | 33.0681 | 32.99 | 33.0681 | 3704.0 |
| 2024-11-22 | ABNY | ETF | 78.75 | 79.898 | 78.75 | 78.849 | 5070.0 |
| 2024-11-22 | ACES | ETF | 26.82 | 27.37 | 26.82 | 27.23 | 208257.0 |
| 2024-11-22 | ACIO | ETF | 40.67 | 40.75 | 40.58 | 40.68 | 114494.0 |
| 2024-11-22 | ACSI | ETF | 61.4049 | 61.4564 | 61.4049 | 61.4564 | 334.0 |
| 2024-11-22 | ACT | ETF | 34.31 | 34.81 | 34.29 | 34.76 | 195751.0 |
| 2024-11-22 | ACTV | ETF | 33.37 | 33.53 | 33.37 | 33.4549 | 24779.0 |
| 2024-11-22 | ACVF | ETF | 45.5 | 45.6551 | 45.4636 | 45.626 | 9977.0 |
| 2024-11-22 | ACWI | ETF | 120.01 | 120.53 | 119.95 | 120.44 | 1974125.0 |
| 2024-11-22 | ACWV | ETF | 113.67 | 114.045 | 113.64 | 113.95 | 75414.0 |
| 2024-11-22 | ACWX | ETF | 53.66 | 53.845 | 53.6 | 53.81 | 2440555.0 |
| 2024-11-22 | ADFI | ETF | 8.49 | 8.5 | 8.48 | 8.49 | 9116.0 |
| 2024-11-22 | ADIV | ETF | 15.49 | 15.52 | 15.46 | 15.5123 | 1872.0 |
| 2024-11-22 | ADME | ETF | 47.49 | 47.49 | 47.39 | 47.467 | 8507.0 |
| 2024-11-22 | ADPV | ETF | 37.17 | 37.73 | 37.17 | 37.7167 | 15395.0 |
| 2024-11-22 | ADVE | ETF | 33.9225 | 33.9225 | 33.9225 | 33.9225 | 2.0 |
| 2024-11-22 | AESR | ETF | 17.58 | 17.6676 | 17.58 | 17.66 | 17291.0 |
| 2024-11-22 | AETH | ETF | 42.09 | 42.3604 | 41.75 | 42.0 | 16011.0 |
| 2024-11-22 | AFIF | ETF | 9.16 | 9.16 | 9.15 | 9.16 | 16568.0 |
| 2024-11-22 | AFK | ETF | 16.04 | 16.18 | 16.0 | 16.18 | 12223.0 |
| 2024-11-22 | AFLG | ETF | 35.66 | 35.75 | 35.65 | 35.73 | 28689.0 |
| 2024-11-22 | AFMC | ETF | 34.189 | 34.309 | 34.09 | 34.309 | 5453.0 |
| 2024-11-22 | AFSM | ETF | 32.2 | 32.71 | 32.2 | 32.64 | 5121.0 |
| 2024-11-22 | AGG | ETF | 97.87 | 97.92 | 97.72 | 97.81 | 4989634.0 |
| 2024-11-22 | AGGH | ETF | 20.71 | 20.8254 | 20.63 | 20.76 | 35939.0 |
| 2024-11-22 | AGGS | ETF | 41.1049 | 41.1049 | 41.1049 | 41.1049 | 1.0 |
| 2024-11-22 | AGGY | ETF | 43.39 | 43.43 | 43.34 | 43.38 | 74883.0 |
| 2024-11-22 | AGIH | ETF | 24.5955 | 24.5955 | 24.5955 | 24.5955 | 5.0 |
| 2024-11-22 | AGIX | ETF | 28.23 | 28.3 | 28.19 | 28.3 | 6863.0 |
| 2024-11-22 | AGMI | ETF | 27.99 | 27.99 | 27.99 | 27.99 | 7.0 |
| 2024-11-22 | AGNG | ETF | 31.04 | 31.2 | 31.04 | 31.1229 | 5049.0 |
| 2024-11-22 | AGOX | ETF | 29.12 | 29.4299 | 29.07 | 29.41 | 17576.0 |
| 2024-11-22 | AGQ | ETF | 39.24 | 39.96 | 39.0345 | 39.75 | 1571591.0 |
> showing 50 of 3,790 rows — these rows as CSV