PREVIEW / etf_daily / 2024-11-25
file: by_date/etf_daily/2024/2024-11-25.parquet size: 144 KB rows: 3,797
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-25 | SPY | ETF | 599.52 | 600.86 | 595.2 | 597.53 | 41892286.0 |
| 2024-11-25 | QQQ | ETF | 509.9 | 511.4525 | 504.2625 | 506.59 | 26375166.0 |
| 2024-11-25 | IWM | ETF | 241.49 | 244.98 | 241.39 | 242.4 | 33289691.0 |
| 2024-11-25 | DIA | ETF | 446.61 | 448.4 | 445.4 | 447.56 | 2875696.0 |
| 2024-11-25 | GLD | ETF | 244.27 | 244.3999 | 241.48 | 242.48 | 10174260.0 |
| 2024-11-25 | TLT | ETF | 92.2 | 92.78 | 91.985 | 92.73 | 56302988.0 |
| 2024-11-25 | AAA | ETF | 25.11 | 25.1799 | 25.0599 | 25.115 | 8645.0 |
| 2024-11-25 | AAAU | ETF | 26.16 | 26.16 | 25.8599 | 25.965 | 4188385.0 |
| 2024-11-25 | AADR | ETF | 67.5501 | 67.5501 | 67.42 | 67.42 | 782.0 |
| 2024-11-25 | AAPB | ETF | 29.15 | 29.59 | 28.77 | 29.49 | 135571.0 |
| 2024-11-25 | AAPD | ETF | 16.6 | 16.7401 | 16.5007 | 16.53 | 279842.0 |
| 2024-11-25 | AAPR | ETF | 26.4 | 26.4 | 26.34 | 26.385 | 735.0 |
| 2024-11-25 | AAPU | ETF | 36.865 | 37.4299 | 36.331 | 37.29 | 471574.0 |
| 2024-11-25 | AAPX | ETF | 33.46 | 33.99 | 33.14 | 33.98 | 16636.0 |
| 2024-11-25 | AAPY | ETF | 27.51 | 27.51 | 26.8601 | 27.1518 | 1290.0 |
| 2024-11-25 | AAXJ | ETF | 74.31 | 74.38 | 73.865 | 74.11 | 700450.0 |
| 2024-11-25 | ABCS | ETF | 30.755 | 30.86 | 30.7001 | 30.78 | 1601.0 |
| 2024-11-25 | ABEQ | ETF | 33.12 | 33.12 | 32.97 | 32.9984 | 5079.0 |
| 2024-11-25 | ABNY | ETF | 79.75 | 81.05 | 79.55 | 81.05 | 4586.0 |
| 2024-11-25 | ACES | ETF | 27.71 | 28.3871 | 27.71 | 28.15 | 132981.0 |
| 2024-11-25 | ACIO | ETF | 40.84 | 40.89 | 40.6189 | 40.79 | 130731.0 |
| 2024-11-25 | ACSI | ETF | 61.9361 | 61.9361 | 61.9361 | 61.9361 | 9.0 |
| 2024-11-25 | ACT | ETF | 34.91 | 35.73 | 34.91 | 35.37 | 250421.0 |
| 2024-11-25 | ACTV | ETF | 33.88 | 34.28 | 33.88 | 33.99 | 7550.0 |
| 2024-11-25 | ACVF | ETF | 45.8 | 45.89 | 45.64 | 45.6839 | 13692.0 |
| 2024-11-25 | ACWI | ETF | 121.33 | 121.44 | 120.44 | 120.86 | 1232535.0 |
| 2024-11-25 | ACWV | ETF | 114.48 | 114.64 | 114.1343 | 114.35 | 49080.0 |
| 2024-11-25 | ACWX | ETF | 54.11 | 54.2 | 53.82 | 53.96 | 1481473.0 |
| 2024-11-25 | ADFI | ETF | 8.52 | 8.61 | 8.52 | 8.5836 | 17363.0 |
| 2024-11-25 | ADIV | ETF | 15.52 | 15.55 | 15.47 | 15.515 | 1633.0 |
| 2024-11-25 | ADME | ETF | 47.82 | 47.82 | 47.47 | 47.62 | 25186.0 |
| 2024-11-25 | ADPV | ETF | 38.4 | 38.4 | 37.69 | 37.7395 | 16385.0 |
| 2024-11-25 | ADVE | ETF | 34.03 | 34.0301 | 34.0268 | 34.0268 | 1565.0 |
| 2024-11-25 | AESR | ETF | 17.74 | 17.74 | 17.59 | 17.63 | 10186.0 |
| 2024-11-25 | AETH | ETF | 44.46 | 45.1887 | 43.3599 | 44.4861 | 11605.0 |
| 2024-11-25 | AFIF | ETF | 9.1601 | 9.17 | 9.16 | 9.17 | 14421.0 |
| 2024-11-25 | AFK | ETF | 16.18 | 16.2 | 15.992 | 16.05 | 8164.0 |
| 2024-11-25 | AFLG | ETF | 35.9974 | 36.0022 | 35.805 | 35.89 | 14787.0 |
| 2024-11-25 | AFMC | ETF | 34.8667 | 35.09 | 34.79 | 34.79 | 8862.0 |
| 2024-11-25 | AFSM | ETF | 33.32 | 33.51 | 33.1764 | 33.1764 | 43413.0 |
| 2024-11-25 | AGG | ETF | 98.53 | 98.7 | 98.43 | 98.69 | 9230574.0 |
| 2024-11-25 | AGGH | ETF | 20.7 | 20.84 | 20.6889 | 20.807 | 23221.0 |
| 2024-11-25 | AGGS | ETF | 41.4787 | 41.4787 | 41.4787 | 41.4787 | 0.0 |
| 2024-11-25 | AGGY | ETF | 43.57 | 43.669 | 43.54 | 43.66 | 93412.0 |
| 2024-11-25 | AGIH | ETF | 24.7103 | 24.7103 | 24.7103 | 24.7103 | 2.0 |
| 2024-11-25 | AGIX | ETF | 28.66 | 28.72 | 28.26 | 28.33 | 7764.0 |
| 2024-11-25 | AGMI | ETF | 27.71 | 27.71 | 27.4044 | 27.4044 | 818.0 |
| 2024-11-25 | AGNG | ETF | 31.3 | 31.4 | 31.28 | 31.35 | 2481.0 |
| 2024-11-25 | AGOX | ETF | 29.39 | 29.5793 | 29.3 | 29.52 | 20405.0 |
| 2024-11-25 | AGQ | ETF | 37.68 | 37.7199 | 36.75 | 37.42 | 2283729.0 |
> showing 50 of 3,797 rows — these rows as CSV