PREVIEW / etf_daily / 2024-10-21
file: by_date/etf_daily/2024/2024-10-21.parquet size: 142 KB rows: 3,742
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-10-21 | SPY | ETF | 583.85 | 584.85 | 580.6001 | 583.63 | 36373744.0 |
| 2024-10-21 | QQQ | ETF | 493.25 | 496.23 | 491.31 | 495.42 | 30336549.0 |
| 2024-10-21 | IWM | ETF | 225.63 | 225.69 | 221.53 | 222.1 | 24161742.0 |
| 2024-10-21 | DIA | ETF | 432.43 | 433.04 | 428.76 | 429.37 | 2688593.0 |
| 2024-10-21 | GLD | ETF | 252.74 | 253.14 | 250.73 | 251.22 | 9235047.0 |
| 2024-10-21 | TLT | ETF | 93.02 | 93.09 | 92.23 | 92.23 | 49362415.0 |
| 2024-10-21 | AAA | ETF | 25.12 | 25.13 | 25.105 | 25.115 | 934.0 |
| 2024-10-21 | AAAU | ETF | 27.06 | 27.0999 | 26.845 | 26.89 | 2699420.0 |
| 2024-10-21 | AADR | ETF | 65.7 | 65.7 | 65.7 | 65.7 | 76.0 |
| 2024-10-21 | AAPB | ETF | 30.21 | 30.76 | 30.21 | 30.7 | 54065.0 |
| 2024-10-21 | AAPD | ETF | 16.37 | 16.37 | 16.2 | 16.22 | 157298.0 |
| 2024-10-21 | AAPR | ETF | 26.22 | 26.2653 | 26.22 | 26.2653 | 6240.0 |
| 2024-10-21 | AAPU | ETF | 38.22 | 38.98 | 38.22 | 38.89 | 501484.0 |
| 2024-10-21 | AAPX | ETF | 34.78 | 35.3896 | 34.78 | 35.31 | 17764.0 |
| 2024-10-21 | AAPY | ETF | 28.229 | 28.2389 | 28.225 | 28.2389 | 740.0 |
| 2024-10-21 | AAXJ | ETF | 77.81 | 78.09 | 77.465 | 77.93 | 345501.0 |
| 2024-10-21 | ABCS | ETF | 28.72 | 28.72 | 28.5122 | 28.5122 | 1249.0 |
| 2024-10-21 | ABEQ | ETF | 33.17 | 33.17 | 33.06 | 33.0673 | 2754.0 |
| 2024-10-21 | ABNY | ETF | 82.5 | 82.85 | 82.2 | 82.35 | 6928.0 |
| 2024-10-21 | ACES | ETF | 28.33 | 28.46 | 27.91 | 28.14 | 37307.0 |
| 2024-10-21 | ACIO | ETF | 40.37 | 40.395 | 40.19 | 40.37 | 86815.0 |
| 2024-10-21 | ACSI | ETF | 58.6875 | 58.6875 | 58.6875 | 58.6875 | 10.0 |
| 2024-10-21 | ACT | ETF | 36.63 | 36.725 | 35.97 | 36.02 | 197067.0 |
| 2024-10-21 | ACTV | ETF | 34.6572 | 34.6572 | 34.0738 | 34.0738 | 1868.0 |
| 2024-10-21 | ACVF | ETF | 44.56 | 44.56 | 44.3488 | 44.4166 | 5159.0 |
| 2024-10-21 | ACWI | ETF | 120.0 | 120.435 | 119.58 | 120.07 | 2487711.0 |
| 2024-10-21 | ACWV | ETF | 114.89 | 115.07 | 114.225 | 114.39 | 146827.0 |
| 2024-10-21 | ACWX | ETF | 56.08 | 56.15 | 55.705 | 55.88 | 340487.0 |
| 2024-10-21 | ADFI | ETF | 8.62 | 8.63 | 8.56 | 8.6 | 29001.0 |
| 2024-10-21 | ADIV | ETF | 16.21 | 16.21 | 16.058 | 16.0761 | 2110.0 |
| 2024-10-21 | ADME | ETF | 47.03 | 47.03 | 46.75 | 46.97 | 11793.0 |
| 2024-10-21 | ADPV | ETF | 33.2 | 33.3099 | 32.9027 | 32.9027 | 5376.0 |
| 2024-10-21 | ADVE | ETF | 35.16 | 35.16 | 35.1238 | 35.1238 | 223.0 |
| 2024-10-21 | AESR | ETF | 17.26 | 17.49 | 17.2329 | 17.38 | 40370.0 |
| 2024-10-21 | AETH | ETF | 34.439 | 34.47 | 34.1116 | 34.3946 | 4367.0 |
| 2024-10-21 | AFIF | ETF | 9.22 | 9.22 | 9.16 | 9.17 | 38391.0 |
| 2024-10-21 | AFK | ETF | 17.19 | 17.19 | 16.71 | 17.0 | 6460.0 |
| 2024-10-21 | AFLG | ETF | 34.79 | 34.79 | 34.5157 | 34.64 | 10797.0 |
| 2024-10-21 | AFMC | ETF | 32.92 | 32.92 | 32.4 | 32.4005 | 660.0 |
| 2024-10-21 | AFSM | ETF | 30.831 | 30.89 | 30.8 | 30.8 | 9039.0 |
| 2024-10-21 | AGG | ETF | 99.18 | 99.205 | 98.83 | 98.83 | 6868707.0 |
| 2024-10-21 | AGGH | ETF | 21.18 | 21.18 | 21.0301 | 21.05 | 98285.0 |
| 2024-10-21 | AGGS | ETF | 41.5167 | 41.5167 | 41.5167 | 41.5167 | 2.0 |
| 2024-10-21 | AGGY | ETF | 44.02 | 44.03 | 43.825 | 43.85 | 49866.0 |
| 2024-10-21 | AGIH | ETF | 24.7404 | 24.7404 | 24.7404 | 24.7404 | 9.0 |
| 2024-10-21 | AGIX | ETF | 26.41 | 26.41 | 26.22 | 26.3466 | 461.0 |
| 2024-10-21 | AGMI | ETF | 32.0 | 32.65 | 32.0 | 32.07 | 503.0 |
| 2024-10-21 | AGNG | ETF | 32.93 | 32.93 | 32.57 | 32.6231 | 112977.0 |
| 2024-10-21 | AGOX | ETF | 29.36 | 29.6099 | 29.2 | 29.5768 | 19486.0 |
| 2024-10-21 | AGQ | ETF | 48.16 | 48.4 | 46.22 | 47.25 | 3612608.0 |
> showing 50 of 3,742 rows — these rows as CSV