PREVIEW / etf_daily / 2024-09-23
file: by_date/etf_daily/2024/2024-09-23.parquet size: 134 KB rows: 3,522
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-09-23 | SPY | ETF | 569.34 | 570.3325 | 568.1 | 569.67 | 44689509.0 |
| 2024-09-23 | QQQ | ETF | 482.95 | 484.14 | 481.6 | 483.04 | 24842972.0 |
| 2024-09-23 | IWM | ETF | 222.69 | 223.11 | 220.02 | 220.76 | 20109061.0 |
| 2024-09-23 | DIA | ETF | 421.12 | 421.7 | 420.0 | 421.11 | 2272997.0 |
| 2024-09-23 | GLD | ETF | 242.97 | 243.46 | 242.585 | 242.68 | 5415747.0 |
| 2024-09-23 | TLT | ETF | 98.5 | 99.09 | 98.02 | 98.67 | 35208929.0 |
| 2024-09-23 | AAA | ETF | 25.0769 | 25.14 | 25.04 | 25.095 | 7371.0 |
| 2024-09-23 | AAAU | ETF | 26.01 | 26.066 | 25.965 | 25.975 | 2005684.0 |
| 2024-09-23 | AADR | ETF | 63.17 | 63.17 | 63.0 | 63.0 | 518.0 |
| 2024-09-23 | AAPB | ETF | 28.58 | 29.11 | 28.27 | 28.38 | 96020.0 |
| 2024-09-23 | AAPD | ETF | 16.99 | 17.09 | 16.83 | 17.04 | 454776.0 |
| 2024-09-23 | AAPR | ETF | 26.17 | 26.1725 | 26.1486 | 26.1725 | 266.0 |
| 2024-09-23 | AAPU | ETF | 36.49 | 37.26 | 36.08 | 36.28 | 792584.0 |
| 2024-09-23 | AAPX | ETF | 33.13 | 33.42 | 32.67 | 32.79 | 8319.0 |
| 2024-09-23 | AAPY | ETF | 27.76 | 27.77 | 27.49 | 27.49 | 3676.0 |
| 2024-09-23 | AAXJ | ETF | 74.46 | 74.88 | 74.37 | 74.69 | 243622.0 |
| 2024-09-23 | ABCS | ETF | 28.67 | 28.67 | 28.255 | 28.34 | 1723.0 |
| 2024-09-23 | ABEQ | ETF | 32.52 | 32.712 | 32.52 | 32.6904 | 7817.0 |
| 2024-09-23 | ABNY | ETF | 83.4 | 83.4 | 81.85 | 81.9 | 16337.0 |
| 2024-09-23 | ACES | ETF | 28.68 | 28.9183 | 28.5 | 28.87 | 56130.0 |
| 2024-09-23 | ACIO | ETF | 39.63 | 39.66 | 39.4901 | 39.6098 | 210330.0 |
| 2024-09-23 | ACSI | ETF | 57.827 | 57.827 | 57.827 | 57.827 | 27.0 |
| 2024-09-23 | ACT | ETF | 36.37 | 36.6 | 36.17 | 36.38 | 191916.0 |
| 2024-09-23 | ACTV | ETF | 33.38 | 33.5 | 33.38 | 33.39 | 9575.0 |
| 2024-09-23 | ACVF | ETF | 43.33 | 43.37 | 43.28 | 43.37 | 4748.0 |
| 2024-09-23 | ACWI | ETF | 118.165 | 118.36 | 117.9401 | 118.21 | 1126877.0 |
| 2024-09-23 | ACWV | ETF | 113.71 | 114.5 | 113.71 | 114.24 | 179580.0 |
| 2024-09-23 | ACWX | ETF | 55.77 | 56.0899 | 55.77 | 56.02 | 255199.0 |
| 2024-09-23 | ADFI | ETF | 8.78 | 8.82 | 8.77 | 8.81 | 12406.0 |
| 2024-09-23 | ADIV | ETF | 15.58 | 15.745 | 15.58 | 15.5933 | 1155.0 |
| 2024-09-23 | ADME | ETF | 45.91 | 46.05 | 45.91 | 45.9927 | 8231.0 |
| 2024-09-23 | ADPV | ETF | 31.995 | 32.14 | 31.995 | 31.9986 | 13158.0 |
| 2024-09-23 | AEMB | ETF | 39.33 | 39.4063 | 39.31 | 39.4063 | 600.0 |
| 2024-09-23 | AESR | ETF | 16.84 | 16.87 | 16.78 | 16.849 | 14938.0 |
| 2024-09-23 | AETH | ETF | 34.11 | 34.7035 | 34.1 | 34.4969 | 2919.0 |
| 2024-09-23 | AFIF | ETF | 9.22 | 9.22 | 9.19 | 9.205 | 39847.0 |
| 2024-09-23 | AFK | ETF | 16.83 | 16.89 | 16.7 | 16.78 | 4490.0 |
| 2024-09-23 | AFLG | ETF | 33.83 | 33.836 | 33.83 | 33.836 | 905.0 |
| 2024-09-23 | AFMC | ETF | 31.99 | 32.0745 | 31.99 | 32.0745 | 219.0 |
| 2024-09-23 | AFSM | ETF | 30.71 | 30.71 | 30.4892 | 30.65 | 5943.0 |
| 2024-09-23 | AFTY | ETF | 13.77 | 13.81 | 13.76 | 13.7727 | 1869.0 |
| 2024-09-23 | AGG | ETF | 101.34 | 101.59 | 101.185 | 101.44 | 7952054.0 |
| 2024-09-23 | AGGH | ETF | 21.95 | 22.0596 | 21.68 | 21.85 | 131336.0 |
| 2024-09-23 | AGGY | ETF | 44.93 | 45.0279 | 44.885 | 44.99 | 244943.0 |
| 2024-09-23 | AGIX | ETF | 25.1 | 25.1973 | 25.1 | 25.1973 | 4895.0 |
| 2024-09-23 | AGMI | ETF | 28.49 | 28.625 | 28.3092 | 28.3092 | 220.0 |
| 2024-09-23 | AGNG | ETF | 32.87 | 32.9 | 32.87 | 32.87 | 1311.0 |
| 2024-09-23 | AGOX | ETF | 29.0 | 29.0 | 28.5301 | 28.82 | 20450.0 |
| 2024-09-23 | AGQ | ETF | 40.11 | 40.29 | 39.26 | 39.44 | 1662731.0 |
| 2024-09-23 | AGQI | ETF | 14.6 | 14.63 | 14.59 | 14.62 | 2342.0 |
> showing 50 of 3,522 rows — these rows as CSV