PREVIEW / etf_daily / 2024-12-04
file: by_date/etf_daily/2024/2024-12-04.parquet size: 145 KB rows: 3,805
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-12-04 | SPY | ETF | 605.63 | 607.91 | 604.95 | 607.66 | 41251425.0 |
| 2024-12-04 | QQQ | ETF | 520.32 | 523.52 | 519.6 | 523.26 | 26086222.0 |
| 2024-12-04 | IWM | ETF | 240.28 | 241.67 | 239.21 | 240.89 | 19412220.0 |
| 2024-12-04 | DIA | ETF | 449.85 | 451.55 | 448.78 | 450.94 | 3661538.0 |
| 2024-12-04 | GLD | ETF | 244.93 | 245.34 | 244.365 | 244.67 | 4599745.0 |
| 2024-12-04 | TLT | ETF | 92.61 | 94.19 | 92.54 | 94.06 | 34643896.0 |
| 2024-12-04 | AAA | ETF | 25.11 | 25.12 | 25.04 | 25.11 | 18180.0 |
| 2024-12-04 | AAAU | ETF | 26.22 | 26.27 | 26.1699 | 26.2 | 3230163.0 |
| 2024-12-04 | AADR | ETF | 68.725 | 68.82 | 68.52 | 68.52 | 430.0 |
| 2024-12-04 | AAPB | ETF | 32.04 | 32.3 | 31.66 | 32.04 | 78132.0 |
| 2024-12-04 | AAPD | ETF | 15.85 | 15.96 | 15.78 | 15.86 | 161134.0 |
| 2024-12-04 | AAPR | ETF | 26.48 | 26.5256 | 26.48 | 26.5256 | 107.0 |
| 2024-12-04 | AAPU | ETF | 40.54 | 40.89 | 39.9816 | 40.52 | 421267.0 |
| 2024-12-04 | AAPX | ETF | 36.81 | 37.0122 | 36.3 | 36.829 | 26553.0 |
| 2024-12-04 | AAPY | ETF | 28.2 | 28.24 | 28.1382 | 28.1661 | 2010.0 |
| 2024-12-04 | AAXJ | ETF | 74.86 | 74.96 | 74.63 | 74.85 | 556334.0 |
| 2024-12-04 | ABCS | ETF | 30.54 | 30.54 | 30.32 | 30.4384 | 1401.0 |
| 2024-12-04 | ABEQ | ETF | 32.97 | 33.0209 | 32.9501 | 32.9977 | 1186.0 |
| 2024-12-04 | ABNY | ETF | 79.0 | 80.1075 | 78.35 | 80.05 | 2962.0 |
| 2024-12-04 | ACES | ETF | 27.81 | 27.86 | 27.2982 | 27.41 | 88307.0 |
| 2024-12-04 | ACIO | ETF | 41.29 | 41.4 | 41.2307 | 41.38 | 183515.0 |
| 2024-12-04 | ACSI | ETF | 63.1146 | 63.1146 | 63.1146 | 63.1146 | 93.0 |
| 2024-12-04 | ACT | ETF | 35.43 | 35.59 | 35.13 | 35.28 | 488809.0 |
| 2024-12-04 | ACTV | ETF | 34.29 | 34.5397 | 34.29 | 34.5397 | 7618.0 |
| 2024-12-04 | ACVF | ETF | 45.96 | 46.1 | 45.9 | 46.1 | 9590.0 |
| 2024-12-04 | ACWI | ETF | 122.66 | 122.955 | 122.48 | 122.9 | 1985618.0 |
| 2024-12-04 | ACWV | ETF | 115.2 | 115.2194 | 114.87 | 115.07 | 68289.0 |
| 2024-12-04 | ACWX | ETF | 54.95 | 55.0 | 54.825 | 54.89 | 1013566.0 |
| 2024-12-04 | ADFI | ETF | 8.59 | 8.62 | 8.58 | 8.6009 | 19046.0 |
| 2024-12-04 | ADIV | ETF | 15.765 | 15.775 | 15.765 | 15.775 | 441.0 |
| 2024-12-04 | ADME | ETF | 48.24 | 48.4099 | 48.18 | 48.32 | 67583.0 |
| 2024-12-04 | ADPV | ETF | 38.0 | 38.02 | 37.625 | 37.8426 | 13154.0 |
| 2024-12-04 | ADVE | ETF | 34.4295 | 34.4295 | 34.4295 | 34.4295 | 2.0 |
| 2024-12-04 | AESR | ETF | 18.0164 | 18.12 | 18.0164 | 18.0937 | 21879.0 |
| 2024-12-04 | AETH | ETF | 47.23 | 49.39 | 47.1695 | 49.39 | 9634.0 |
| 2024-12-04 | AFIF | ETF | 9.17 | 9.21 | 9.17 | 9.18 | 17686.0 |
| 2024-12-04 | AFK | ETF | 16.27 | 16.4244 | 16.075 | 16.3 | 9489.0 |
| 2024-12-04 | AFLG | ETF | 36.35 | 36.44 | 36.2868 | 36.4354 | 14481.0 |
| 2024-12-04 | AFMC | ETF | 34.67 | 34.67 | 34.3272 | 34.53 | 1902.0 |
| 2024-12-04 | AFSM | ETF | 33.09 | 33.185 | 32.8272 | 33.1 | 2027.0 |
| 2024-12-04 | AGG | ETF | 98.52 | 99.09 | 98.484 | 99.03 | 7342108.0 |
| 2024-12-04 | AGGH | ETF | 20.95 | 20.99 | 20.89 | 20.95 | 123377.0 |
| 2024-12-04 | AGGS | ETF | 41.52 | 41.62 | 41.52 | 41.62 | 309.0 |
| 2024-12-04 | AGGY | ETF | 43.75 | 44.0399 | 43.745 | 44.01 | 66891.0 |
| 2024-12-04 | AGIH | ETF | 24.76 | 24.76 | 24.76 | 24.76 | 4.0 |
| 2024-12-04 | AGIX | ETF | 29.48 | 29.9 | 29.455 | 29.9 | 9076.0 |
| 2024-12-04 | AGMI | ETF | 27.9578 | 27.9578 | 27.9578 | 27.9578 | 7.0 |
| 2024-12-04 | AGNG | ETF | 31.73 | 31.8 | 31.68 | 31.72 | 2674.0 |
| 2024-12-04 | AGOX | ETF | 29.8071 | 30.0 | 29.6736 | 30.0 | 10772.0 |
| 2024-12-04 | AGQ | ETF | 39.78 | 40.5283 | 39.56 | 39.96 | 1633757.0 |
> showing 50 of 3,805 rows — these rows as CSV