PREVIEW / etf_daily / 2024-10-02
file: by_date/etf_daily/2024/2024-10-02.parquet size: 136 KB rows: 3,558
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-10-02 | SPY | ETF | 567.71 | 569.9 | 565.27 | 568.86 | 38353837.0 |
| 2024-10-02 | QQQ | ETF | 480.36 | 483.88 | 477.72 | 481.95 | 23744049.0 |
| 2024-10-02 | IWM | ETF | 216.99 | 218.75 | 216.21 | 217.59 | 14432534.0 |
| 2024-10-02 | DIA | ETF | 421.83 | 422.5 | 419.58 | 421.91 | 2578187.0 |
| 2024-10-02 | GLD | ETF | 245.61 | 246.07 | 243.99 | 245.66 | 6790018.0 |
| 2024-10-02 | TLT | ETF | 97.36 | 97.73 | 97.06 | 97.66 | 35630078.0 |
| 2024-10-02 | AAA | ETF | 25.035 | 25.045 | 25.03 | 25.03 | 1961.0 |
| 2024-10-02 | AAAU | ETF | 26.3 | 26.3421 | 26.125 | 26.3 | 2682966.0 |
| 2024-10-02 | AADR | ETF | 63.47 | 63.55 | 63.47 | 63.55 | 245.0 |
| 2024-10-02 | AAPB | ETF | 28.15 | 28.51 | 27.52 | 28.41 | 47968.0 |
| 2024-10-02 | AAPD | ETF | 16.94 | 17.1501 | 16.8484 | 16.89 | 176299.0 |
| 2024-10-02 | AAPR | ETF | 26.16 | 26.175 | 26.1304 | 26.175 | 1407.0 |
| 2024-10-02 | AAPU | ETF | 35.7 | 36.1595 | 34.84 | 36.0 | 478829.0 |
| 2024-10-02 | AAPX | ETF | 32.2748 | 32.889 | 31.79 | 32.82 | 16954.0 |
| 2024-10-02 | AAPY | ETF | 27.02 | 27.1761 | 27.02 | 27.1761 | 493.0 |
| 2024-10-02 | AAXJ | ETF | 80.87 | 81.24 | 80.29 | 81.24 | 854239.0 |
| 2024-10-02 | ABCS | ETF | 27.94 | 28.0338 | 27.94 | 28.0338 | 2403.0 |
| 2024-10-02 | ABEQ | ETF | 32.78 | 32.81 | 32.6201 | 32.6983 | 3958.0 |
| 2024-10-02 | ABNY | ETF | 79.85 | 81.002 | 79.85 | 81.002 | 1026.0 |
| 2024-10-02 | ACES | ETF | 28.54 | 28.54 | 28.21 | 28.39 | 55118.0 |
| 2024-10-02 | ACIO | ETF | 39.5 | 39.6 | 39.37 | 39.57 | 323382.0 |
| 2024-10-02 | ACSI | ETF | 57.81 | 57.9369 | 57.81 | 57.9369 | 162.0 |
| 2024-10-02 | ACT | ETF | 36.08 | 36.29 | 35.825 | 36.03 | 300699.0 |
| 2024-10-02 | ACTV | ETF | 33.58 | 33.61 | 33.5391 | 33.5997 | 7266.0 |
| 2024-10-02 | ACVF | ETF | 43.26 | 43.35 | 43.2196 | 43.35 | 7633.0 |
| 2024-10-02 | ACWI | ETF | 118.7 | 119.19 | 118.31 | 119.07 | 5192366.0 |
| 2024-10-02 | ACWV | ETF | 114.55 | 114.59 | 114.14 | 114.55 | 61372.0 |
| 2024-10-02 | ACWX | ETF | 57.3 | 57.365 | 57.01 | 57.19 | 8188511.0 |
| 2024-10-02 | ADFI | ETF | 8.77 | 8.77 | 8.76 | 8.76 | 22211.0 |
| 2024-10-02 | ADIV | ETF | 16.85 | 16.9262 | 16.85 | 16.9262 | 868.0 |
| 2024-10-02 | ADME | ETF | 45.71 | 45.92 | 45.71 | 45.92 | 7324.0 |
| 2024-10-02 | ADPV | ETF | 31.655 | 31.71 | 31.61 | 31.6568 | 6174.0 |
| 2024-10-02 | ADVE | ETF | 36.6644 | 36.7806 | 36.655 | 36.7806 | 321.0 |
| 2024-10-02 | AESR | ETF | 16.93 | 16.94 | 16.86 | 16.89 | 28785.0 |
| 2024-10-02 | AETH | ETF | 31.22 | 31.679 | 30.455 | 30.5554 | 5166.0 |
| 2024-10-02 | AFIF | ETF | 9.21 | 9.225 | 9.21 | 9.225 | 21361.0 |
| 2024-10-02 | AFK | ETF | 17.1 | 17.156 | 16.785 | 16.8 | 5683.0 |
| 2024-10-02 | AFLG | ETF | 33.83 | 33.95 | 33.83 | 33.91 | 23975.0 |
| 2024-10-02 | AFMC | ETF | 32.04 | 32.04 | 31.9099 | 31.9123 | 15141.0 |
| 2024-10-02 | AFSM | ETF | 30.4542 | 30.51 | 30.3421 | 30.3543 | 18384.0 |
| 2024-10-02 | AFTY | ETF | 16.45 | 16.48 | 16.35 | 16.42 | 69265.0 |
| 2024-10-02 | AGG | ETF | 100.88 | 101.1056 | 100.805 | 101.02 | 11296702.0 |
| 2024-10-02 | AGGH | ETF | 21.72 | 21.72 | 21.59 | 21.64 | 199676.0 |
| 2024-10-02 | AGGS | ETF | 42.4 | 42.4 | 42.3759 | 42.3759 | 122.0 |
| 2024-10-02 | AGGY | ETF | 44.72 | 44.835 | 44.7 | 44.8244 | 115637.0 |
| 2024-10-02 | AGIH | ETF | 25.15 | 25.15 | 25.1409 | 25.1409 | 103.0 |
| 2024-10-02 | AGIX | ETF | 24.98 | 25.1199 | 24.98 | 25.085 | 4865.0 |
| 2024-10-02 | AGMI | ETF | 29.835 | 29.835 | 29.7404 | 29.7404 | 130.0 |
| 2024-10-02 | AGNG | ETF | 32.78 | 32.78 | 32.55 | 32.67 | 5153.0 |
| 2024-10-02 | AGOX | ETF | 28.71 | 28.82 | 28.48 | 28.81 | 24542.0 |
> showing 50 of 3,558 rows — these rows as CSV