PREVIEW / etf_daily / 2024-12-02
file: by_date/etf_daily/2024/2024-12-02.parquet size: 145 KB rows: 3,796
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-02 | SPY | ETF | 602.97 | 604.32 | 602.47 | 603.63 | 30962745.0 |
| 2024-12-02 | QQQ | ETF | 511.01 | 516.26 | 510.62 | 515.29 | 25147165.0 |
| 2024-12-02 | IWM | ETF | 242.24 | 242.66 | 240.01 | 241.75 | 22724343.0 |
| 2024-12-02 | DIA | ETF | 450.61 | 451.0 | 447.93 | 448.74 | 2636225.0 |
| 2024-12-02 | GLD | ETF | 244.46 | 244.5805 | 243.14 | 243.44 | 4558442.0 |
| 2024-12-02 | TLT | ETF | 93.27 | 94.1475 | 93.0 | 93.87 | 39258246.0 |
| 2024-12-02 | AAA | ETF | 25.01 | 25.1199 | 25.01 | 25.085 | 15438.0 |
| 2024-12-02 | AAAU | ETF | 26.17 | 26.195 | 26.0349 | 26.07 | 2927372.0 |
| 2024-12-02 | AADR | ETF | 69.06 | 69.06 | 69.06 | 69.06 | 161.0 |
| 2024-12-02 | AAPB | ETF | 30.58 | 31.48 | 30.58 | 31.21 | 55933.0 |
| 2024-12-02 | AAPD | ETF | 16.22 | 16.22 | 15.9979 | 16.08 | 262853.0 |
| 2024-12-02 | AAPR | ETF | 26.42 | 26.4745 | 26.42 | 26.4709 | 887.0 |
| 2024-12-02 | AAPU | ETF | 38.71 | 39.83 | 38.66 | 39.43 | 583955.0 |
| 2024-12-02 | AAPX | ETF | 35.22 | 36.19 | 35.09 | 35.8 | 55439.0 |
| 2024-12-02 | AAPY | ETF | 27.85 | 27.88 | 27.825 | 27.8297 | 2623.0 |
| 2024-12-02 | AAXJ | ETF | 74.41 | 74.65 | 74.16 | 74.51 | 553142.0 |
| 2024-12-02 | ABCS | ETF | 30.6 | 30.6349 | 30.58 | 30.6058 | 1300.0 |
| 2024-12-02 | ABEQ | ETF | 33.0483 | 33.1397 | 33.0483 | 33.126 | 600.0 |
| 2024-12-02 | ABNY | ETF | 79.4 | 79.4 | 78.544 | 79.199 | 4157.0 |
| 2024-12-02 | ACES | ETF | 28.25 | 28.55 | 27.99 | 28.48 | 62363.0 |
| 2024-12-02 | ACIO | ETF | 41.08 | 41.2 | 41.08 | 41.17 | 133801.0 |
| 2024-12-02 | ACSI | ETF | 62.7082 | 62.7082 | 62.7082 | 62.7082 | 35.0 |
| 2024-12-02 | ACT | ETF | 35.12 | 35.535 | 34.78 | 35.22 | 373893.0 |
| 2024-12-02 | ACTV | ETF | 34.26 | 34.65 | 34.22 | 34.35 | 6346.0 |
| 2024-12-02 | ACVF | ETF | 46.03 | 46.03 | 45.83 | 45.9129 | 7728.0 |
| 2024-12-02 | ACWI | ETF | 121.9 | 122.165 | 121.63 | 122.03 | 2235622.0 |
| 2024-12-02 | ACWV | ETF | 115.51 | 115.56 | 114.845 | 115.13 | 825863.0 |
| 2024-12-02 | ACWX | ETF | 54.51 | 54.655 | 54.205 | 54.59 | 985301.0 |
| 2024-12-02 | ADFI | ETF | 8.6 | 8.61 | 8.55 | 8.5948 | 14931.0 |
| 2024-12-02 | ADIV | ETF | 15.62 | 15.76 | 15.62 | 15.67 | 1930.0 |
| 2024-12-02 | ADME | ETF | 48.045 | 48.13 | 48.0309 | 48.07 | 12014.0 |
| 2024-12-02 | ADPV | ETF | 38.02 | 38.02 | 37.4 | 37.4385 | 13639.0 |
| 2024-12-02 | ADVE | ETF | 34.3399 | 34.4546 | 34.3399 | 34.4546 | 4373.0 |
| 2024-12-02 | AESR | ETF | 17.86 | 17.91 | 17.86 | 17.91 | 21014.0 |
| 2024-12-02 | AETH | ETF | 46.19 | 46.73 | 45.72 | 45.86 | 5911.0 |
| 2024-12-02 | AFIF | ETF | 9.2 | 9.2 | 9.16 | 9.175 | 24865.0 |
| 2024-12-02 | AFK | ETF | 16.2 | 16.2499 | 16.0 | 16.18 | 4624.0 |
| 2024-12-02 | AFLG | ETF | 36.1832 | 36.2399 | 36.16 | 36.16 | 16170.0 |
| 2024-12-02 | AFMC | ETF | 34.57 | 34.66 | 34.57 | 34.58 | 4622.0 |
| 2024-12-02 | AFSM | ETF | 33.07 | 33.11 | 32.85 | 32.9879 | 9442.0 |
| 2024-12-02 | AGG | ETF | 99.39 | 99.6 | 98.58 | 98.9 | 18294844.0 |
| 2024-12-02 | AGGH | ETF | 20.95 | 20.96 | 20.8001 | 20.87 | 75516.0 |
| 2024-12-02 | AGGS | ETF | 41.58 | 41.73 | 41.58 | 41.585 | 12115.0 |
| 2024-12-02 | AGGY | ETF | 43.64 | 43.98 | 43.64 | 43.94 | 69474.0 |
| 2024-12-02 | AGIH | ETF | 24.7755 | 24.7755 | 24.7755 | 24.7755 | 4.0 |
| 2024-12-02 | AGIX | ETF | 28.27 | 28.71 | 28.27 | 28.63 | 15334.0 |
| 2024-12-02 | AGMI | ETF | 27.33 | 27.33 | 27.23 | 27.2518 | 201.0 |
| 2024-12-02 | AGNG | ETF | 31.84 | 31.84 | 31.66 | 31.73 | 5818.0 |
| 2024-12-02 | AGOX | ETF | 29.75 | 29.75 | 29.47 | 29.6513 | 20614.0 |
| 2024-12-02 | AGQ | ETF | 37.99 | 38.03 | 37.33 | 37.84 | 957495.0 |
> showing 50 of 3,796 rows — these rows as CSV