PREVIEW / etf_daily / 2024-04-02
file: by_date/etf_daily/2024/2024-04-02.parquet size: 119 KB rows: 3,332
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-04-02 | SPY | ETF | 518.24 | 518.98 | 516.48 | 518.84 | 74230300.0 |
| 2024-04-02 | QQQ | ETF | 440.08 | 441.43 | 438.03 | 441.11 | 44259665.0 |
| 2024-04-02 | IWM | ETF | 205.75 | 205.88 | 203.4 | 204.49 | 36632100.0 |
| 2024-04-02 | DIA | ETF | 391.97 | 392.14 | 390.28 | 391.63 | 4034900.0 |
| 2024-04-02 | GLD | ETF | 209.07 | 211.03 | 208.36 | 210.89 | 13421100.0 |
| 2024-04-02 | TLT | ETF | 91.57 | 92.2 | 91.34 | 92.04 | 43086300.0 |
| 2024-04-02 | AAA | ETF | 25.06 | 25.139 | 25.01 | 25.121 | 7800.0 |
| 2024-04-02 | AAAU | ETF | 22.35 | 22.57 | 22.28 | 22.55 | 5542600.0 |
| 2024-04-02 | AADR | ETF | 61.17 | 61.32 | 61.17 | 61.24 | 600.0 |
| 2024-04-02 | AAPB | ETF | 17.06 | 17.07 | 16.9 | 17.03 | 129060.0 |
| 2024-04-02 | AAPD | ETF | 23.01 | 23.1 | 22.97 | 23.03 | 85586.0 |
| 2024-04-02 | AAPR | ETF | 24.73 | 24.75 | 24.67 | 24.74 | 144091.0 |
| 2024-04-02 | AAPU | ETF | 21.97 | 22.0299 | 21.77 | 21.93 | 295756.0 |
| 2024-04-02 | AAPX | ETF | 19.96 | 19.96 | 19.72 | 19.8601 | 32758.0 |
| 2024-04-02 | AAXJ | ETF | 68.24 | 68.54 | 68.24 | 68.31 | 653200.0 |
| 2024-04-02 | ABCS | ETF | 26.8001 | 26.8001 | 26.699 | 26.6998 | 2635.0 |
| 2024-04-02 | ABEQ | ETF | 30.34 | 30.34 | 30.218 | 30.246 | 6900.0 |
| 2024-04-02 | ACES | ETF | 28.89 | 28.89 | 28.45 | 28.58 | 92500.0 |
| 2024-04-02 | ACIO | ETF | 35.67 | 35.773 | 35.61 | 35.77 | 615200.0 |
| 2024-04-02 | ACSI | ETF | 51.199 | 51.199 | 51.199 | 51.199 | 100.0 |
| 2024-04-02 | ACT | ETF | 30.68 | 30.88 | 30.48 | 30.67 | 212797.0 |
| 2024-04-02 | ACTV | ETF | 34.48 | 34.48 | 34.17 | 34.24 | 19900.0 |
| 2024-04-02 | ACVF | ETF | 40.02 | 40.02 | 39.765 | 39.914 | 8700.0 |
| 2024-04-02 | ACWF | ETF | 40.93 | 40.9551 | 40.82 | 40.9551 | 4445.0 |
| 2024-04-02 | ACWI | ETF | 109.05 | 109.26 | 108.87 | 109.22 | 1836400.0 |
| 2024-04-02 | ACWV | ETF | 104.56 | 104.79 | 104.43 | 104.48 | 194000.0 |
| 2024-04-02 | ACWX | ETF | 53.04 | 53.13 | 52.93 | 53.06 | 1761200.0 |
| 2024-04-02 | ADFI | ETF | 8.45 | 8.5 | 8.45 | 8.49 | 19000.0 |
| 2024-04-02 | ADIV | ETF | 14.055 | 14.055 | 14.053 | 14.053 | 800.0 |
| 2024-04-02 | ADME | ETF | 41.55 | 41.67 | 41.5 | 41.639 | 16700.0 |
| 2024-04-02 | ADPV | ETF | 29.12 | 29.5981 | 29.11 | 29.5981 | 10678.0 |
| 2024-04-02 | AEMB | ETF | 38.255 | 38.255 | 38.255 | 38.255 | 100.0 |
| 2024-04-02 | AESR | ETF | 15.4 | 15.45 | 15.36 | 15.45 | 26500.0 |
| 2024-04-02 | AETH | ETF | 44.03 | 44.03 | 42.91 | 43.5265 | 6750.0 |
| 2024-04-02 | AFIF | ETF | 9.12 | 9.14 | 9.11 | 9.14 | 195000.0 |
| 2024-04-02 | AFK | ETF | 14.76 | 14.98 | 14.61 | 14.98 | 5800.0 |
| 2024-04-02 | AFLG | ETF | 30.549 | 30.577 | 30.549 | 30.577 | 2300.0 |
| 2024-04-02 | AFMC | ETF | 30.02 | 30.02 | 29.49 | 29.614 | 2700.0 |
| 2024-04-02 | AFSM | ETF | 28.85 | 28.85 | 28.55 | 28.557 | 500.0 |
| 2024-04-02 | AFTY | ETF | 14.14 | 14.145 | 14.14 | 14.145 | 700.0 |
| 2024-04-02 | AGG | ETF | 96.66 | 96.89 | 96.54 | 96.87 | 10624600.0 |
| 2024-04-02 | AGGH | ETF | 21.28 | 21.28 | 21.04 | 21.18 | 106578.0 |
| 2024-04-02 | AGGY | ETF | 42.94 | 43.04 | 42.88 | 43.02 | 146700.0 |
| 2024-04-02 | AGNG | ETF | 29.67 | 29.73 | 29.5 | 29.5 | 9800.0 |
| 2024-04-02 | AGOX | ETF | 25.273 | 25.34 | 25.15 | 25.25 | 9500.0 |
| 2024-04-02 | AGQ | ETF | 30.22 | 31.58 | 29.98 | 31.47 | 2192400.0 |
| 2024-04-02 | AGQI | ETF | 13.85 | 13.89 | 13.85 | 13.885 | 48743.0 |
| 2024-04-02 | AGZ | ETF | 107.49 | 107.49 | 107.11 | 107.3 | 23800.0 |
| 2024-04-02 | AGZD | ETF | 22.15 | 22.26 | 22.14 | 22.21 | 146200.0 |
| 2024-04-02 | AHLT | ETF | 24.58 | 24.6139 | 24.58 | 24.6139 | 662.0 |
> showing 50 of 3,332 rows — these rows as CSV