PREVIEW / etf_daily / 2024-07-02
file: by_date/etf_daily/2024/2024-07-02.parquet size: 131 KB rows: 3,415
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-07-02 | SPY | ETF | 543.7 | 546.51 | 543.65 | 545.73 | 13655110.0 |
| 2024-07-02 | QQQ | ETF | 480.41 | 487.04 | 480.28 | 486.98 | 26723559.0 |
| 2024-07-02 | IWM | ETF | 201.52 | 202.27 | 200.9034 | 201.88 | 17177811.0 |
| 2024-07-02 | DIA | ETF | 390.79 | 393.29 | 390.69 | 393.29 | 1710723.0 |
| 2024-07-02 | GLD | ETF | 215.33 | 216.08 | 214.6204 | 215.56 | 4838801.0 |
| 2024-07-02 | TLT | ETF | 90.69 | 90.805 | 90.08 | 90.145 | 21653058.0 |
| 2024-07-02 | AAA | ETF | 25.07 | 25.07 | 25.0 | 25.05 | 2172.0 |
| 2024-07-02 | AAAU | ETF | 23.04 | 23.11 | 22.965 | 23.06 | 1333886.0 |
| 2024-07-02 | AADR | ETF | 61.42 | 61.42 | 61.42 | 61.42 | 149.0 |
| 2024-07-02 | AAPB | ETF | 26.68 | 27.72 | 26.42 | 27.72 | 276091.0 |
| 2024-07-02 | AAPD | ETF | 17.76 | 17.84 | 17.42 | 17.42 | 318239.0 |
| 2024-07-02 | AAPR | ETF | 25.2999 | 25.31 | 25.24 | 25.3 | 48486.0 |
| 2024-07-02 | AAPU | ETF | 34.22 | 35.56 | 33.9 | 35.54 | 1700305.0 |
| 2024-07-02 | AAPX | ETF | 30.93 | 32.29 | 30.93 | 32.29 | 62003.0 |
| 2024-07-02 | AAXJ | ETF | 72.01 | 72.5551 | 71.97 | 72.55 | 422326.0 |
| 2024-07-02 | ABCS | ETF | 25.88 | 25.92 | 25.8325 | 25.8929 | 3550.0 |
| 2024-07-02 | ABEQ | ETF | 29.86 | 29.921 | 29.8 | 29.921 | 7960.0 |
| 2024-07-02 | ABNY | ETF | 103.45 | 103.8495 | 103.3 | 103.7005 | 821.0 |
| 2024-07-02 | ACES | ETF | 27.95 | 28.45 | 27.86 | 28.16 | 77975.0 |
| 2024-07-02 | ACIO | ETF | 37.66 | 37.99 | 37.66 | 37.94 | 63974.0 |
| 2024-07-02 | ACSI | ETF | 55.57 | 55.7721 | 55.56 | 55.7721 | 1313.0 |
| 2024-07-02 | ACT | ETF | 31.03 | 31.29 | 30.96 | 31.09 | 101584.0 |
| 2024-07-02 | ACTV | ETF | 31.76 | 31.96 | 31.76 | 31.9 | 10672.0 |
| 2024-07-02 | ACVF | ETF | 40.92 | 41.33 | 40.92 | 41.33 | 9350.0 |
| 2024-07-02 | ACWI | ETF | 112.35 | 113.195 | 112.3 | 113.19 | 1169358.0 |
| 2024-07-02 | ACWV | ETF | 104.41 | 104.93 | 104.41 | 104.91 | 291327.0 |
| 2024-07-02 | ACWX | ETF | 53.06 | 53.385 | 53.025 | 53.37 | 815276.0 |
| 2024-07-02 | ADFI | ETF | 8.44 | 8.45 | 8.43 | 8.445 | 36438.0 |
| 2024-07-02 | ADIV | ETF | 14.7401 | 14.7401 | 14.7401 | 14.7401 | 31.0 |
| 2024-07-02 | ADME | ETF | 43.62 | 44.0878 | 43.62 | 44.0878 | 8967.0 |
| 2024-07-02 | ADPV | ETF | 30.06 | 30.3558 | 30.06 | 30.3558 | 26521.0 |
| 2024-07-02 | ADVE | ETF | 32.9199 | 32.9199 | 32.8892 | 32.8892 | 105.0 |
| 2024-07-02 | AEMB | ETF | 37.897 | 38.18 | 37.897 | 38.065 | 1466.0 |
| 2024-07-02 | AESR | ETF | 16.32 | 16.47 | 16.31 | 16.46 | 49089.0 |
| 2024-07-02 | AETH | ETF | 44.8599 | 44.8599 | 44.31 | 44.534 | 1579.0 |
| 2024-07-02 | AFIF | ETF | 9.1287 | 9.1287 | 9.12 | 9.125 | 845.0 |
| 2024-07-02 | AFK | ETF | 15.54 | 15.89 | 15.48 | 15.74 | 88065.0 |
| 2024-07-02 | AFLG | ETF | 31.5 | 31.69 | 31.5 | 31.6818 | 9804.0 |
| 2024-07-02 | AFMC | ETF | 29.06 | 29.07 | 29.0123 | 29.0331 | 8822.0 |
| 2024-07-02 | AFSM | ETF | 28.23 | 28.24 | 28.17 | 28.1845 | 1671.0 |
| 2024-07-02 | AFTY | ETF | 14.12 | 14.15 | 14.1 | 14.12 | 2619.0 |
| 2024-07-02 | AGG | ETF | 96.64 | 96.6702 | 96.441 | 96.57 | 5441686.0 |
| 2024-07-02 | AGGH | ETF | 20.69 | 20.71 | 20.6201 | 20.7 | 60450.0 |
| 2024-07-02 | AGGS | ETF | 40.67 | 40.75 | 40.6649 | 40.6649 | 2002.0 |
| 2024-07-02 | AGGY | ETF | 42.92 | 42.92 | 42.8 | 42.9 | 145479.0 |
| 2024-07-02 | AGMI | ETF | 25.53 | 25.5662 | 25.42 | 25.5662 | 925.0 |
| 2024-07-02 | AGNG | ETF | 29.8611 | 30.06 | 29.8611 | 30.06 | 3920.0 |
| 2024-07-02 | AGOX | ETF | 28.08 | 28.12 | 27.8601 | 28.0627 | 56151.0 |
| 2024-07-02 | AGQ | ETF | 37.78 | 38.8595 | 37.5604 | 38.16 | 1128420.0 |
| 2024-07-02 | AGQI | ETF | 14.25 | 14.34 | 14.25 | 14.3255 | 3868.0 |
> showing 50 of 3,415 rows — these rows as CSV