PREVIEW / etf_daily / 2024-10-03
file: by_date/etf_daily/2024/2024-10-03.parquet size: 136 KB rows: 3,574
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-03 | SPY | ETF | 567.36 | 569.8025 | 565.49 | 567.82 | 40098655.0 |
| 2024-10-03 | QQQ | ETF | 479.74 | 484.545 | 478.99 | 481.59 | 25337220.0 |
| 2024-10-03 | IWM | ETF | 216.23 | 217.23 | 215.08 | 216.13 | 21284662.0 |
| 2024-10-03 | DIA | ETF | 420.34 | 421.1237 | 418.28 | 419.98 | 2528400.0 |
| 2024-10-03 | GLD | ETF | 244.72 | 245.91 | 243.69 | 245.49 | 5668988.0 |
| 2024-10-03 | TLT | ETF | 97.34 | 97.51 | 96.74 | 96.74 | 39628659.0 |
| 2024-10-03 | AAA | ETF | 25.02 | 25.05 | 25.0 | 25.0 | 16418.0 |
| 2024-10-03 | AAAU | ETF | 26.2 | 26.3254 | 26.1 | 26.285 | 1519811.0 |
| 2024-10-03 | AADR | ETF | 63.41 | 63.41 | 63.41 | 63.41 | 22.0 |
| 2024-10-03 | AAPB | ETF | 28.0 | 28.34 | 27.57 | 28.09 | 57217.0 |
| 2024-10-03 | AAPD | ETF | 17.0 | 17.1404 | 16.89 | 16.96 | 202408.0 |
| 2024-10-03 | AAPR | ETF | 26.16 | 26.16 | 26.13 | 26.1485 | 2950.0 |
| 2024-10-03 | AAPU | ETF | 35.43 | 35.9499 | 34.89 | 35.59 | 413860.0 |
| 2024-10-03 | AAPX | ETF | 32.59 | 32.74 | 31.83 | 32.46 | 15956.0 |
| 2024-10-03 | AAPY | ETF | 26.85 | 27.0338 | 26.85 | 27.0338 | 241.0 |
| 2024-10-03 | AAXJ | ETF | 79.53 | 80.45 | 79.46 | 80.09 | 1080858.0 |
| 2024-10-03 | ABCS | ETF | 27.95 | 27.99 | 27.87 | 27.87 | 1783.0 |
| 2024-10-03 | ABEQ | ETF | 32.46 | 32.46 | 32.41 | 32.4113 | 3541.0 |
| 2024-10-03 | ABNY | ETF | 80.8995 | 80.8995 | 79.903 | 80.5905 | 415.0 |
| 2024-10-03 | ACES | ETF | 28.18 | 28.27 | 27.96 | 28.11 | 21931.0 |
| 2024-10-03 | ACIO | ETF | 39.53 | 39.6198 | 39.3951 | 39.53 | 273371.0 |
| 2024-10-03 | ACSI | ETF | 57.3568 | 57.3568 | 57.3568 | 57.3568 | 27.0 |
| 2024-10-03 | ACT | ETF | 36.03 | 36.08 | 35.64 | 35.77 | 288812.0 |
| 2024-10-03 | ACTV | ETF | 33.39 | 33.39 | 33.1716 | 33.28 | 3726.0 |
| 2024-10-03 | ACTX | ETF | 0.0 | 0.0 | 0.0 | 0.0 | 373.0 |
| 2024-10-03 | ACVF | ETF | 43.23 | 43.33 | 43.0851 | 43.1949 | 5669.0 |
| 2024-10-03 | ACWI | ETF | 118.46 | 118.87 | 118.13 | 118.48 | 1284838.0 |
| 2024-10-03 | ACWV | ETF | 113.82 | 113.98 | 113.63 | 113.68 | 47213.0 |
| 2024-10-03 | ACWX | ETF | 56.447 | 56.81 | 56.447 | 56.61 | 358036.0 |
| 2024-10-03 | ADFI | ETF | 9.3 | 9.3 | 8.72 | 8.77 | 28543.0 |
| 2024-10-03 | ADIV | ETF | 16.66 | 16.73 | 16.66 | 16.73 | 600.0 |
| 2024-10-03 | ADME | ETF | 45.89 | 45.89 | 45.69 | 45.88 | 4597.0 |
| 2024-10-03 | ADPV | ETF | 31.53 | 31.53 | 31.42 | 31.4777 | 1370.0 |
| 2024-10-03 | AESR | ETF | 16.85 | 16.89 | 16.785 | 16.869 | 23066.0 |
| 2024-10-03 | AETH | ETF | 30.17 | 30.23 | 29.82 | 30.23 | 5681.0 |
| 2024-10-03 | AFIF | ETF | 9.24 | 9.24 | 9.2 | 9.23 | 33621.0 |
| 2024-10-03 | AFK | ETF | 16.79 | 17.0 | 16.62 | 16.8043 | 7243.0 |
| 2024-10-03 | AFLG | ETF | 33.93 | 33.93 | 33.721 | 33.9 | 13168.0 |
| 2024-10-03 | AFMC | ETF | 31.83 | 31.83 | 31.73 | 31.78 | 899.0 |
| 2024-10-03 | AFSM | ETF | 30.3499 | 30.3499 | 30.12 | 30.1529 | 4266.0 |
| 2024-10-03 | AFTY | ETF | 16.34 | 16.4 | 16.27 | 16.4 | 36931.0 |
| 2024-10-03 | AGG | ETF | 100.85 | 100.8867 | 100.59 | 100.61 | 8747452.0 |
| 2024-10-03 | AGGH | ETF | 21.72 | 21.72 | 21.57 | 21.57 | 121676.0 |
| 2024-10-03 | AGGS | ETF | 42.3 | 42.3 | 42.2313 | 42.2313 | 377.0 |
| 2024-10-03 | AGGY | ETF | 44.73 | 44.74 | 44.62 | 44.62 | 78546.0 |
| 2024-10-03 | AGIX | ETF | 25.17 | 25.17 | 25.03 | 25.1023 | 595.0 |
| 2024-10-03 | AGMI | ETF | 29.3 | 29.4695 | 29.3 | 29.4695 | 151.0 |
| 2024-10-03 | AGNG | ETF | 32.55 | 32.55 | 32.32 | 32.34 | 3079.0 |
| 2024-10-03 | AGOX | ETF | 28.81 | 28.87 | 28.5601 | 28.87 | 11599.0 |
| 2024-10-03 | AGQ | ETF | 41.82 | 43.23 | 41.565 | 42.76 | 1921357.0 |
> showing 50 of 3,574 rows — these rows as CSV