PREVIEW / etf_daily / 2024-11-29
file: by_date/etf_daily/2024/2024-11-29.parquet size: 143 KB rows: 3,755
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-11-29 | SPY | ETF | 599.66 | 603.35 | 599.3805 | 602.55 | 29846717.0 |
| 2024-11-29 | QQQ | ETF | 505.93 | 510.34 | 505.31 | 509.74 | 15333968.0 |
| 2024-11-29 | IWM | ETF | 242.37 | 243.475 | 241.54 | 241.87 | 16933728.0 |
| 2024-11-29 | DIA | ETF | 448.3 | 451.28 | 448.24 | 450.09 | 3470292.0 |
| 2024-11-29 | GLD | ETF | 245.25 | 245.81 | 244.73 | 245.59 | 2695647.0 |
| 2024-11-29 | TLT | ETF | 93.78 | 93.985 | 93.44 | 93.97 | 31893524.0 |
| 2024-11-29 | AAA | ETF | 25.03 | 25.1052 | 25.03 | 25.095 | 5765.0 |
| 2024-11-29 | AAAU | ETF | 26.265 | 26.3175 | 26.2009 | 26.3 | 1341286.0 |
| 2024-11-29 | AADR | ETF | 67.965 | 68.395 | 67.965 | 68.24 | 2913.0 |
| 2024-11-29 | AAPB | ETF | 30.01 | 30.66 | 29.9 | 30.6 | 60988.0 |
| 2024-11-29 | AAPD | ETF | 16.43 | 16.43 | 16.21 | 16.24 | 232951.0 |
| 2024-11-29 | AAPR | ETF | 26.42 | 26.46 | 26.42 | 26.46 | 286.0 |
| 2024-11-29 | AAPU | ETF | 37.9 | 38.86 | 37.6319 | 38.73 | 209633.0 |
| 2024-11-29 | AAPX | ETF | 35.0 | 35.27 | 35.0 | 35.19 | 3775.0 |
| 2024-11-29 | AAPY | ETF | 27.4899 | 27.607 | 27.4899 | 27.607 | 364.0 |
| 2024-11-29 | AAXJ | ETF | 73.46 | 74.27 | 73.24 | 74.2 | 621432.0 |
| 2024-11-29 | ABCS | ETF | 30.69 | 30.7036 | 30.62 | 30.62 | 1186.0 |
| 2024-11-29 | ABEQ | ETF | 33.27 | 33.28 | 33.26 | 33.28 | 1200.0 |
| 2024-11-29 | ABNY | ETF | 80.5 | 80.5 | 78.5005 | 78.9 | 2849.0 |
| 2024-11-29 | ACES | ETF | 28.08 | 28.29 | 27.96 | 28.15 | 796706.0 |
| 2024-11-29 | ACIO | ETF | 40.95 | 41.15 | 40.9105 | 41.11 | 24325.0 |
| 2024-11-29 | ACSI | ETF | 62.5398 | 62.5398 | 62.5398 | 62.5398 | 6.0 |
| 2024-11-29 | ACT | ETF | 35.45 | 35.5 | 35.135 | 35.21 | 166525.0 |
| 2024-11-29 | ACTV | ETF | 34.4 | 34.4 | 34.155 | 34.155 | 15856.0 |
| 2024-11-29 | ACVF | ETF | 45.86 | 45.9962 | 45.8169 | 45.9264 | 2636.0 |
| 2024-11-29 | ACWI | ETF | 121.09 | 121.915 | 121.0 | 121.77 | 1615412.0 |
| 2024-11-29 | ACWV | ETF | 115.19 | 115.65 | 115.1 | 115.42 | 45620.0 |
| 2024-11-29 | ACWX | ETF | 53.95 | 54.45 | 53.92 | 54.41 | 688698.0 |
| 2024-11-29 | ADFI | ETF | 8.585 | 8.64 | 8.585 | 8.6184 | 25018.0 |
| 2024-11-29 | ADIV | ETF | 15.53 | 15.6114 | 15.53 | 15.6114 | 272.0 |
| 2024-11-29 | ADME | ETF | 47.9 | 48.04 | 47.9 | 48.0096 | 3208.0 |
| 2024-11-29 | ADPV | ETF | 37.93 | 38.11 | 37.92 | 37.9809 | 9890.0 |
| 2024-11-29 | ADVE | ETF | 34.3603 | 34.3603 | 34.3603 | 34.3603 | 93.0 |
| 2024-11-29 | AESR | ETF | 17.7957 | 17.84 | 17.7957 | 17.8107 | 12332.0 |
| 2024-11-29 | AETH | ETF | 45.92 | 46.38 | 45.69 | 45.7 | 24054.0 |
| 2024-11-29 | AFIF | ETF | 9.175 | 9.175 | 9.175 | 9.175 | 1117.0 |
| 2024-11-29 | AFK | ETF | 16.14 | 16.36 | 16.0 | 16.13 | 10367.0 |
| 2024-11-29 | AFLG | ETF | 36.16 | 36.2656 | 36.16 | 36.17 | 9893.0 |
| 2024-11-29 | AFMC | ETF | 34.64 | 34.79 | 34.6318 | 34.6318 | 3709.0 |
| 2024-11-29 | AFSM | ETF | 32.88 | 32.923 | 32.8495 | 32.8591 | 3516.0 |
| 2024-11-29 | AGG | ETF | 99.15 | 99.215 | 99.08 | 99.2 | 9386062.0 |
| 2024-11-29 | AGGH | ETF | 20.98 | 20.98 | 20.85 | 20.87 | 16232.0 |
| 2024-11-29 | AGGS | ETF | 41.699 | 41.699 | 41.699 | 41.699 | 0.0 |
| 2024-11-29 | AGGY | ETF | 43.82 | 43.915 | 43.82 | 43.9 | 29917.0 |
| 2024-11-29 | AGIH | ETF | 24.7798 | 24.7798 | 24.7798 | 24.7798 | 2.0 |
| 2024-11-29 | AGIX | ETF | 28.07 | 28.255 | 28.07 | 28.23 | 705.0 |
| 2024-11-29 | AGMI | ETF | 27.7 | 27.7 | 27.5747 | 27.5747 | 212.0 |
| 2024-11-29 | AGNG | ETF | 31.867 | 31.9534 | 31.867 | 31.9534 | 370.0 |
| 2024-11-29 | AGOX | ETF | 29.6 | 29.6 | 29.43 | 29.55 | 5121.0 |
| 2024-11-29 | AGQ | ETF | 38.32 | 38.4 | 37.92 | 38.19 | 871287.0 |
> showing 50 of 3,755 rows — these rows as CSV