PREVIEW / etf_daily / 2024-12-31
file: by_date/etf_daily/2024/2024-12-31.parquet size: 146 KB rows: 3,869
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-31 | SPY | ETF | 589.905 | 590.6399 | 584.42 | 586.08 | 56652905.0 |
| 2024-12-31 | QQQ | ETF | 516.9 | 517.66 | 510.26 | 511.23 | 29117028.0 |
| 2024-12-31 | IWM | ETF | 222.12 | 223.28 | 220.15 | 220.96 | 26118599.0 |
| 2024-12-31 | DIA | ETF | 426.91 | 427.7399 | 424.035 | 425.5 | 2405876.0 |
| 2024-12-31 | GLD | ETF | 241.05 | 242.52 | 241.05 | 242.13 | 2391422.0 |
| 2024-12-31 | TLT | ETF | 88.13 | 88.28 | 87.26 | 87.33 | 31869801.0 |
| 2024-12-31 | AAA | ETF | 25.11 | 25.13 | 25.05 | 25.075 | 43675.0 |
| 2024-12-31 | AAAU | ETF | 25.83 | 25.9743 | 25.82 | 25.935 | 1635356.0 |
| 2024-12-31 | AADR | ETF | 69.27 | 69.34 | 69.0184 | 69.0184 | 39382.0 |
| 2024-12-31 | AAPB | ETF | 34.38 | 34.4025 | 33.57 | 33.77 | 55708.0 |
| 2024-12-31 | AAPD | ETF | 15.15 | 15.3301 | 15.1 | 15.26 | 638750.0 |
| 2024-12-31 | AAPR | ETF | 26.38 | 26.38 | 26.353 | 26.36 | 1124.0 |
| 2024-12-31 | AAPU | ETF | 38.31 | 38.5199 | 37.39 | 37.64 | 296373.0 |
| 2024-12-31 | AAPX | ETF | 32.82 | 32.82 | 32.09 | 32.28 | 14204.0 |
| 2024-12-31 | AAPY | ETF | 27.329 | 27.329 | 27.12 | 27.1287 | 2178.0 |
| 2024-12-31 | AAXJ | ETF | 72.4 | 72.5 | 72.07 | 72.18 | 109215.0 |
| 2024-12-31 | ABCS | ETF | 28.7139 | 28.7139 | 28.58 | 28.58 | 2972.0 |
| 2024-12-31 | ABEQ | ETF | 31.52 | 31.52 | 31.44 | 31.4852 | 1021.0 |
| 2024-12-31 | ABFL | ETF | 66.79 | 66.93 | 66.32 | 66.4664 | 12039.0 |
| 2024-12-31 | ABHY | ETF | 19.07 | 19.07 | 19.02 | 19.0501 | 791.0 |
| 2024-12-31 | ABLD | ETF | 28.12 | 28.12 | 27.97 | 28.0755 | 4880.0 |
| 2024-12-31 | ABLG | ETF | 28.19 | 28.87 | 28.19 | 28.6689 | 35475.0 |
| 2024-12-31 | ABNY | ETF | 74.95 | 75.7 | 74.6655 | 75.05 | 1663.0 |
| 2024-12-31 | ABOT | ETF | 36.46 | 36.46 | 36.2002 | 36.2002 | 767.0 |
| 2024-12-31 | ACES | ETF | 26.48 | 26.79 | 25.975 | 26.04 | 58683.0 |
| 2024-12-31 | ACGR | ETF | 58.3471 | 58.3471 | 57.7516 | 57.7516 | 2314.0 |
| 2024-12-31 | ACIO | ETF | 40.38 | 40.38 | 40.13 | 40.24 | 103259.0 |
| 2024-12-31 | ACLC | ETF | 71.17 | 71.17 | 70.48 | 70.5621 | 11105.0 |
| 2024-12-31 | ACSI | ETF | 60.7998 | 60.7998 | 60.7998 | 60.7998 | 10.0 |
| 2024-12-31 | ACT | ETF | 32.43 | 32.64 | 32.33 | 32.38 | 235051.0 |
| 2024-12-31 | ACTV | ETF | 32.61 | 32.75 | 32.5 | 32.55 | 5369.0 |
| 2024-12-31 | ACVF | ETF | 44.1637 | 44.1637 | 43.71 | 43.72 | 4849.0 |
| 2024-12-31 | ACWI | ETF | 118.27 | 118.38 | 117.28 | 117.5 | 5057550.0 |
| 2024-12-31 | ACWV | ETF | 109.33 | 109.42 | 108.83 | 109.2 | 152429.0 |
| 2024-12-31 | ACWX | ETF | 52.32 | 52.575 | 52.06 | 52.16 | 2883081.0 |
| 2024-12-31 | ADFI | ETF | 8.35 | 8.4942 | 8.3443 | 8.3931 | 14144.0 |
| 2024-12-31 | ADIV | ETF | 15.3097 | 15.3097 | 15.3097 | 15.3097 | 79.0 |
| 2024-12-31 | ADME | ETF | 47.09 | 47.1099 | 46.7141 | 46.7141 | 3302.0 |
| 2024-12-31 | ADPV | ETF | 35.82 | 35.83 | 35.53 | 35.5857 | 3997.0 |
| 2024-12-31 | ADVE | ETF | 32.06 | 32.06 | 32.0 | 32.0153 | 758.0 |
| 2024-12-31 | AESR | ETF | 17.41 | 17.41 | 17.2843 | 17.2843 | 21663.0 |
| 2024-12-31 | AETH | ETF | 37.14 | 37.14 | 37.02 | 37.0623 | 2041.0 |
| 2024-12-31 | AFIF | ETF | 9.1415 | 9.15 | 9.14 | 9.15 | 8076.0 |
| 2024-12-31 | AFIX | ETF | 24.5267 | 24.5267 | 24.5267 | 24.5267 | 2.0 |
| 2024-12-31 | AFK | ETF | 15.59 | 15.7206 | 15.36 | 15.47 | 13265.0 |
| 2024-12-31 | AFLG | ETF | 34.8 | 34.8 | 34.4401 | 34.53 | 98866.0 |
| 2024-12-31 | AFMC | ETF | 31.78 | 31.78 | 31.55 | 31.585 | 23798.0 |
| 2024-12-31 | AFSM | ETF | 30.31 | 30.41 | 30.07 | 30.08 | 2496.0 |
| 2024-12-31 | AGG | ETF | 97.15 | 97.2099 | 96.83 | 96.9 | 11669098.0 |
| 2024-12-31 | AGGH | ETF | 20.61 | 20.6599 | 20.49 | 20.63 | 81431.0 |
> showing 50 of 3,869 rows — these rows as CSV