PREVIEW / etf_daily / 2024-08-02
file: by_date/etf_daily/2024/2024-08-02.parquet size: 133 KB rows: 3,492
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-08-02 | SPY | ETF | 535.75 | 536.99 | 528.6 | 532.9 | 82645663.0 |
| 2024-08-02 | QQQ | ETF | 450.89 | 453.57 | 444.47 | 448.75 | 66323244.0 |
| 2024-08-02 | IWM | ETF | 208.85 | 211.19 | 206.99 | 208.92 | 67004553.0 |
| 2024-08-02 | DIA | ETF | 399.93 | 400.38 | 393.56 | 397.13 | 4843844.0 |
| 2024-08-02 | GLD | ETF | 227.95 | 228.76 | 222.865 | 225.34 | 10946390.0 |
| 2024-08-02 | TLT | ETF | 97.0 | 98.37 | 96.8901 | 98.28 | 91753062.0 |
| 2024-08-02 | AAA | ETF | 25.0 | 25.07 | 25.0 | 25.0171 | 2273.0 |
| 2024-08-02 | AAAU | ETF | 24.4 | 24.48 | 23.845 | 24.12 | 4525726.0 |
| 2024-08-02 | AADR | ETF | 57.6 | 57.6 | 57.35 | 57.5628 | 574.0 |
| 2024-08-02 | AAPB | ETF | 27.04 | 28.61 | 26.8 | 27.25 | 502730.0 |
| 2024-08-02 | AAPD | ETF | 17.59 | 17.67 | 17.06 | 17.53 | 1049336.0 |
| 2024-08-02 | AAPR | ETF | 25.33 | 25.42 | 25.22 | 25.3 | 43612.0 |
| 2024-08-02 | AAPU | ETF | 34.67 | 36.716 | 34.27 | 34.9 | 1986139.0 |
| 2024-08-02 | AAPX | ETF | 31.21 | 33.2885 | 31.19 | 31.71 | 62431.0 |
| 2024-08-02 | AAPY | ETF | 26.96 | 26.96 | 26.58 | 26.58 | 2525.0 |
| 2024-08-02 | AAXJ | ETF | 69.93 | 70.075 | 69.58 | 69.99 | 549779.0 |
| 2024-08-02 | ABCS | ETF | 26.625 | 26.74 | 26.3971 | 26.5637 | 2455.0 |
| 2024-08-02 | ABEQ | ETF | 31.16 | 31.1896 | 31.0007 | 31.1896 | 8664.0 |
| 2024-08-02 | ABNY | ETF | 90.0 | 90.7 | 89.8 | 90.5935 | 499.0 |
| 2024-08-02 | ACES | ETF | 28.55 | 28.575 | 27.9571 | 28.08 | 48382.0 |
| 2024-08-02 | ACIO | ETF | 37.56 | 37.73 | 37.4101 | 37.6 | 73764.0 |
| 2024-08-02 | ACSI | ETF | 54.4319 | 54.4319 | 54.4319 | 54.4319 | 7.0 |
| 2024-08-02 | ACT | ETF | 32.7 | 33.28 | 32.26 | 33.03 | 245364.0 |
| 2024-08-02 | ACTV | ETF | 33.12 | 33.12 | 32.42 | 32.6102 | 35555.0 |
| 2024-08-02 | ACVF | ETF | 40.7 | 40.7 | 40.07 | 40.4334 | 18758.0 |
| 2024-08-02 | ACWI | ETF | 110.52 | 110.81 | 109.235 | 110.13 | 3580376.0 |
| 2024-08-02 | ACWV | ETF | 108.46 | 108.86 | 107.4 | 108.37 | 191098.0 |
| 2024-08-02 | ACWX | ETF | 52.35 | 52.365 | 51.77 | 52.16 | 1372356.0 |
| 2024-08-02 | ADFI | ETF | 8.6633 | 8.67 | 8.64 | 8.67 | 4847.0 |
| 2024-08-02 | ADIV | ETF | 14.2525 | 14.2525 | 14.2525 | 14.2525 | 214.0 |
| 2024-08-02 | ADME | ETF | 43.54 | 43.54 | 43.2 | 43.42 | 32672.0 |
| 2024-08-02 | ADPV | ETF | 29.25 | 29.25 | 28.74 | 29.0785 | 12617.0 |
| 2024-08-02 | AEMB | ETF | 38.9921 | 38.9921 | 38.9921 | 38.9921 | 53.0 |
| 2024-08-02 | AESR | ETF | 15.7 | 15.76 | 15.54 | 15.675 | 24462.0 |
| 2024-08-02 | AETH | ETF | 40.86 | 41.0403 | 38.94 | 39.1 | 14365.0 |
| 2024-08-02 | AFIF | ETF | 9.175 | 9.18 | 9.17 | 9.175 | 6804.0 |
| 2024-08-02 | AFK | ETF | 15.8 | 15.94 | 14.9001 | 15.16 | 288966.0 |
| 2024-08-02 | AFLG | ETF | 31.19 | 31.3 | 31.15 | 31.3 | 13747.0 |
| 2024-08-02 | AFMC | ETF | 29.8899 | 30.0199 | 29.8532 | 29.9583 | 1201.0 |
| 2024-08-02 | AFSM | ETF | 29.1957 | 29.3 | 28.85 | 29.05 | 12594.0 |
| 2024-08-02 | AFTY | ETF | 14.0 | 14.0045 | 14.0 | 14.0045 | 522.0 |
| 2024-08-02 | AGG | ETF | 99.88 | 100.37 | 99.8 | 100.33 | 11360546.0 |
| 2024-08-02 | AGGH | ETF | 21.34 | 21.6699 | 21.34 | 21.64 | 60923.0 |
| 2024-08-02 | AGGY | ETF | 44.07 | 44.29 | 44.07 | 44.27 | 112324.0 |
| 2024-08-02 | AGIX | ETF | 23.01 | 23.1 | 22.5 | 22.7737 | 13351.0 |
| 2024-08-02 | AGMI | ETF | 26.73 | 26.73 | 25.6278 | 25.6278 | 1004.0 |
| 2024-08-02 | AGNG | ETF | 31.23 | 31.23 | 30.79 | 31.17 | 4997.0 |
| 2024-08-02 | AGOX | ETF | 26.96 | 27.06 | 26.9001 | 26.998 | 29102.0 |
| 2024-08-02 | AGQ | ETF | 35.99 | 36.15 | 33.55 | 34.94 | 1941560.0 |
| 2024-08-02 | AGQI | ETF | 14.0 | 14.0 | 13.89 | 13.9632 | 4691.0 |
> showing 50 of 3,492 rows — these rows as CSV