PREVIEW / etf_daily / 2024-02-23
file: by_date/etf_daily/2024/2024-02-23.parquet size: 117 KB rows: 3,246
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-02-23 | SPY | ETF | 509.27 | 510.13 | 507.1 | 507.85 | 61321800.0 |
| 2024-02-23 | QQQ | ETF | 439.65 | 440.59 | 435.79 | 436.78 | 39853861.0 |
| 2024-02-23 | IWM | ETF | 199.6 | 201.14 | 198.57 | 199.89 | 37667700.0 |
| 2024-02-23 | DIA | ETF | 391.77 | 392.84 | 390.92 | 391.28 | 3451600.0 |
| 2024-02-23 | GLD | ETF | 187.56 | 189.18 | 187.46 | 188.62 | 6827300.0 |
| 2024-02-23 | TLT | ETF | 92.75 | 94.0 | 92.75 | 93.87 | 38406700.0 |
| 2024-02-23 | AAA | ETF | 25.155 | 25.19 | 25.121 | 25.165 | 8000.0 |
| 2024-02-23 | AAAU | ETF | 20.05 | 20.22 | 20.04 | 20.16 | 1620900.0 |
| 2024-02-23 | AADR | ETF | 57.86 | 58.12 | 57.86 | 58.12 | 800.0 |
| 2024-02-23 | AAPB | ETF | 20.78 | 20.78 | 20.2 | 20.24 | 17847.0 |
| 2024-02-23 | AAPD | ETF | 21.11 | 21.43 | 21.11 | 21.41 | 101599.0 |
| 2024-02-23 | AAPU | ETF | 25.5 | 25.5 | 24.97 | 25.03 | 92513.0 |
| 2024-02-23 | AAPX | ETF | 24.28 | 24.28 | 23.6527 | 23.709 | 4454.0 |
| 2024-02-23 | AAXJ | ETF | 66.92 | 67.09 | 66.71 | 66.97 | 270600.0 |
| 2024-02-23 | ABCS | ETF | 25.6 | 25.6633 | 25.6 | 25.6633 | 1100.0 |
| 2024-02-23 | ABEQ | ETF | 29.07 | 29.122 | 29.07 | 29.122 | 500.0 |
| 2024-02-23 | ACES | ETF | 28.97 | 29.0 | 28.41 | 28.53 | 281100.0 |
| 2024-02-23 | ACIO | ETF | 35.285 | 35.325 | 35.141 | 35.19 | 57300.0 |
| 2024-02-23 | ACSI | ETF | 50.23 | 50.23 | 50.23 | 50.23 | 100.0 |
| 2024-02-23 | ACT | ETF | 26.73 | 27.12 | 26.62 | 26.94 | 260519.0 |
| 2024-02-23 | ACTV | ETF | 33.28 | 33.433 | 33.28 | 33.433 | 3700.0 |
| 2024-02-23 | ACVF | ETF | 39.05 | 39.17 | 39.01 | 39.093 | 8200.0 |
| 2024-02-23 | ACWF | ETF | 40.3 | 40.3 | 40.16 | 40.1783 | 2154.0 |
| 2024-02-23 | ACWI | ETF | 106.95 | 107.11 | 106.59 | 106.77 | 1867900.0 |
| 2024-02-23 | ACWV | ETF | 103.68 | 104.22 | 103.68 | 104.02 | 139500.0 |
| 2024-02-23 | ACWX | ETF | 52.07 | 52.1 | 51.92 | 52.03 | 350900.0 |
| 2024-02-23 | ADFI | ETF | 8.45 | 8.5 | 8.45 | 8.475 | 17800.0 |
| 2024-02-23 | ADIV | ETF | 14.241 | 14.241 | 14.241 | 14.241 | 100.0 |
| 2024-02-23 | ADME | ETF | 41.08 | 41.08 | 40.97 | 40.99 | 9300.0 |
| 2024-02-23 | ADPV | ETF | 27.06 | 27.0616 | 27.02 | 27.0616 | 7258.0 |
| 2024-02-23 | AEMB | ETF | 37.895 | 37.895 | 37.895 | 37.895 | 200.0 |
| 2024-02-23 | AESR | ETF | 15.11 | 15.11 | 15.05 | 15.084 | 17900.0 |
| 2024-02-23 | AETH | ETF | 40.47 | 40.47 | 39.89 | 40.3648 | 8339.0 |
| 2024-02-23 | AFIF | ETF | 9.07 | 9.1 | 9.05 | 9.1 | 4600.0 |
| 2024-02-23 | AFK | ETF | 13.05 | 13.28 | 12.84 | 13.11 | 133800.0 |
| 2024-02-23 | AFLG | ETF | 29.474 | 29.474 | 29.474 | 29.474 | 100.0 |
| 2024-02-23 | AFMC | ETF | 27.92 | 28.002 | 27.92 | 28.002 | 200.0 |
| 2024-02-23 | AFSM | ETF | 27.82 | 27.982 | 27.76 | 27.982 | 1500.0 |
| 2024-02-23 | AFTY | ETF | 13.94 | 13.955 | 13.94 | 13.955 | 900.0 |
| 2024-02-23 | AGG | ETF | 96.99 | 97.39 | 96.99 | 97.34 | 7737900.0 |
| 2024-02-23 | AGGH | ETF | 21.48 | 21.55 | 21.43 | 21.43 | 55667.0 |
| 2024-02-23 | AGGY | ETF | 42.96 | 43.125 | 42.96 | 43.11 | 53800.0 |
| 2024-02-23 | AGNG | ETF | 29.45 | 29.563 | 29.45 | 29.488 | 3400.0 |
| 2024-02-23 | AGOX | ETF | 24.97 | 25.19 | 24.93 | 25.028 | 15800.0 |
| 2024-02-23 | AGQ | ETF | 24.28 | 24.85 | 24.03 | 24.73 | 1191800.0 |
| 2024-02-23 | AGQI | ETF | 13.7 | 13.72 | 13.69 | 13.7104 | 12798.0 |
| 2024-02-23 | AGRH | ETF | 25.81 | 25.88 | 25.81 | 25.8551 | 5919.0 |
| 2024-02-23 | AGZ | ETF | 107.43 | 107.74 | 107.32 | 107.66 | 12600.0 |
| 2024-02-23 | AGZD | ETF | 22.04 | 22.08 | 21.89 | 22.06 | 508500.0 |
| 2024-02-23 | AHLT | ETF | 23.42 | 23.42 | 23.06 | 23.06 | 4628.0 |
> showing 50 of 3,246 rows — these rows as CSV