PREVIEW / etf_daily / 2024-12-30
file: by_date/etf_daily/2024/2024-12-30.parquet size: 145 KB rows: 3,866
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-30 | SPY | ETF | 587.89 | 591.74 | 584.41 | 588.22 | 56320461.0 |
| 2024-12-30 | QQQ | ETF | 515.51 | 519.36 | 511.83 | 515.61 | 34584028.0 |
| 2024-12-30 | IWM | ETF | 220.67 | 221.81 | 217.85 | 220.68 | 25796543.0 |
| 2024-12-30 | DIA | ETF | 425.47 | 427.66 | 422.52 | 425.77 | 3554155.0 |
| 2024-12-30 | GLD | ETF | 241.08 | 241.08 | 239.58 | 240.63 | 3260818.0 |
| 2024-12-30 | TLT | ETF | 87.83 | 88.035 | 87.67 | 87.8 | 48656287.0 |
| 2024-12-30 | AAA | ETF | 25.06 | 25.13 | 25.0501 | 25.11 | 14026.0 |
| 2024-12-30 | AAAU | ETF | 25.83 | 25.83 | 25.6603 | 25.77 | 1923373.0 |
| 2024-12-30 | AADR | ETF | 69.26 | 69.44 | 69.26 | 69.2608 | 1874.0 |
| 2024-12-30 | AAPB | ETF | 34.3 | 34.6399 | 33.91 | 34.24 | 81616.0 |
| 2024-12-30 | AAPD | ETF | 15.15 | 15.2401 | 15.085 | 15.16 | 926612.0 |
| 2024-12-30 | AAPR | ETF | 26.37 | 26.44 | 26.37 | 26.4077 | 1490.0 |
| 2024-12-30 | AAPU | ETF | 38.27 | 38.61 | 37.81 | 38.18 | 373251.0 |
| 2024-12-30 | AAPX | ETF | 32.65 | 32.96 | 32.4132 | 32.8 | 16869.0 |
| 2024-12-30 | AAPY | ETF | 27.33 | 27.44 | 27.155 | 27.35 | 10362.0 |
| 2024-12-30 | AAXJ | ETF | 72.47 | 72.5677 | 72.11 | 72.33 | 159680.0 |
| 2024-12-30 | ABCS | ETF | 28.27 | 28.5 | 28.27 | 28.45 | 3577.0 |
| 2024-12-30 | ABEQ | ETF | 31.31 | 31.4999 | 31.31 | 31.4302 | 1990.0 |
| 2024-12-30 | ABFL | ETF | 66.6 | 67.0056 | 66.29 | 66.7552 | 20732.0 |
| 2024-12-30 | ABHY | ETF | 19.03 | 19.06 | 19.03 | 19.06 | 204.0 |
| 2024-12-30 | ABLD | ETF | 27.71 | 27.918 | 27.71 | 27.918 | 555.0 |
| 2024-12-30 | ABLG | ETF | 27.5 | 28.69 | 27.5 | 28.6305 | 17691.0 |
| 2024-12-30 | ABNY | ETF | 75.0 | 75.4 | 74.0 | 74.75 | 1968.0 |
| 2024-12-30 | ABOT | ETF | 36.43 | 36.6 | 36.14 | 36.465 | 5192.0 |
| 2024-12-30 | ACES | ETF | 26.32 | 26.38 | 25.89 | 26.26 | 144313.0 |
| 2024-12-30 | ACGR | ETF | 58.75 | 58.75 | 57.965 | 58.3641 | 1475.0 |
| 2024-12-30 | ACIO | ETF | 40.31 | 40.44 | 40.1 | 40.3 | 199349.0 |
| 2024-12-30 | ACLC | ETF | 70.6 | 71.25 | 70.6 | 71.0712 | 4311.0 |
| 2024-12-30 | ACSI | ETF | 61.24 | 61.25 | 61.1089 | 61.1089 | 283.0 |
| 2024-12-30 | ACT | ETF | 32.26 | 32.57 | 32.05 | 32.39 | 183353.0 |
| 2024-12-30 | ACTV | ETF | 32.0533 | 32.5489 | 32.0533 | 32.4939 | 7419.0 |
| 2024-12-30 | ACVF | ETF | 44.0 | 44.17 | 43.665 | 43.89 | 6790.0 |
| 2024-12-30 | ACWI | ETF | 117.91 | 118.415 | 117.23 | 117.82 | 2432528.0 |
| 2024-12-30 | ACWV | ETF | 109.3 | 109.36 | 108.69 | 109.08 | 87032.0 |
| 2024-12-30 | ACWX | ETF | 52.3 | 52.39 | 52.01 | 52.21 | 1773686.0 |
| 2024-12-30 | ADFI | ETF | 8.32 | 8.46 | 8.32 | 8.4029 | 13438.0 |
| 2024-12-30 | ADIV | ETF | 15.4024 | 15.4024 | 15.3702 | 15.3702 | 317.0 |
| 2024-12-30 | ADME | ETF | 46.8 | 47.2081 | 46.72 | 47.008 | 16684.0 |
| 2024-12-30 | ADPV | ETF | 35.46 | 36.17 | 35.46 | 35.9501 | 8593.0 |
| 2024-12-30 | ADVE | ETF | 32.12 | 32.12 | 32.03 | 32.1006 | 1733.0 |
| 2024-12-30 | AESR | ETF | 17.3 | 17.46 | 17.29 | 17.36 | 10783.0 |
| 2024-12-30 | AETH | ETF | 37.06 | 37.1 | 37.01 | 37.0554 | 10881.0 |
| 2024-12-30 | AFIF | ETF | 9.14 | 9.15 | 9.115 | 9.135 | 22641.0 |
| 2024-12-30 | AFIX | ETF | 24.55 | 24.55 | 24.5423 | 24.5423 | 310.0 |
| 2024-12-30 | AFK | ETF | 15.58 | 15.58 | 15.355 | 15.55 | 64502.0 |
| 2024-12-30 | AFLG | ETF | 34.69 | 34.85 | 34.415 | 34.7 | 1518449.0 |
| 2024-12-30 | AFMC | ETF | 31.6268 | 31.73 | 31.603 | 31.603 | 4742.0 |
| 2024-12-30 | AFSM | ETF | 29.83 | 30.21 | 29.62 | 30.035 | 16979.0 |
| 2024-12-30 | AGG | ETF | 97.0 | 97.08 | 96.96 | 97.02 | 10141089.0 |
| 2024-12-30 | AGGH | ETF | 20.36 | 20.6199 | 20.36 | 20.61 | 386788.0 |
> showing 50 of 3,866 rows — these rows as CSV