PREVIEW / etf_daily / 2024-06-21
file: by_date/etf_daily/2024/2024-06-21.parquet size: 121 KB rows: 3,377
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-06-21 | SPY | ETF | 544.4 | 545.65 | 543.02 | 544.51 | 64513900.0 |
| 2024-06-21 | QQQ | ETF | 481.19 | 482.535 | 478.67 | 480.18 | 39432913.0 |
| 2024-06-21 | IWM | ETF | 199.93 | 200.41 | 198.46 | 200.35 | 37570300.0 |
| 2024-06-21 | DIA | ETF | 391.67 | 392.47 | 390.46 | 391.34 | 2594600.0 |
| 2024-06-21 | GLD | ETF | 217.83 | 217.9 | 214.26 | 214.78 | 8935400.0 |
| 2024-06-21 | TLT | ETF | 94.24 | 94.48 | 93.59 | 93.96 | 22830900.0 |
| 2024-06-21 | AAA | ETF | 25.08 | 25.17 | 25.043 | 25.155 | 9800.0 |
| 2024-06-21 | AAAU | ETF | 23.31 | 23.31 | 22.92 | 22.98 | 2068300.0 |
| 2024-06-21 | AADR | ETF | 61.76 | 61.76 | 61.76 | 61.76 | 100.0 |
| 2024-06-21 | AAPB | ETF | 25.32 | 25.6799 | 24.55 | 24.58 | 325376.0 |
| 2024-06-21 | AAPD | ETF | 18.46 | 18.75 | 18.3299 | 18.75 | 579458.0 |
| 2024-06-21 | AAPR | ETF | 25.25 | 25.26 | 25.21 | 25.26 | 18915.0 |
| 2024-06-21 | AAPU | ETF | 32.7 | 33.19 | 31.75 | 31.77 | 1059804.0 |
| 2024-06-21 | AAPX | ETF | 29.679 | 29.86 | 28.77 | 28.77 | 41218.0 |
| 2024-06-21 | AAPY | ETF | 26.62 | 26.63 | 26.5275 | 26.5275 | 725.0 |
| 2024-06-21 | AAXJ | ETF | 72.38 | 72.38 | 72.11 | 72.13 | 349100.0 |
| 2024-06-21 | ABCS | ETF | 26.12 | 26.12 | 26.025 | 26.05 | 6450.0 |
| 2024-06-21 | ABEQ | ETF | 30.191 | 30.23 | 30.191 | 30.23 | 2000.0 |
| 2024-06-21 | ACES | ETF | 28.46 | 28.535 | 28.23 | 28.34 | 302900.0 |
| 2024-06-21 | ACIO | ETF | 37.7 | 37.73 | 37.591 | 37.66 | 94300.0 |
| 2024-06-21 | ACSI | ETF | 54.862 | 54.862 | 54.862 | 54.862 | 100.0 |
| 2024-06-21 | ACT | ETF | 30.28 | 30.58 | 30.28 | 30.42 | 363722.0 |
| 2024-06-21 | ACTV | ETF | 31.816 | 31.951 | 31.74 | 31.951 | 5700.0 |
| 2024-06-21 | ACVF | ETF | 41.45 | 41.54 | 41.38 | 41.483 | 4100.0 |
| 2024-06-21 | ACWF | ETF | 42.32 | 42.32 | 42.28 | 42.2876 | 360.0 |
| 2024-06-21 | ACWI | ETF | 112.28 | 112.42 | 111.93 | 112.15 | 1707900.0 |
| 2024-06-21 | ACWV | ETF | 104.81 | 104.81 | 104.38 | 104.55 | 206700.0 |
| 2024-06-21 | ACWX | ETF | 52.89 | 52.97 | 52.79 | 52.89 | 505300.0 |
| 2024-06-21 | ADFI | ETF | 8.51 | 8.55 | 8.49 | 8.55 | 21400.0 |
| 2024-06-21 | ADIV | ETF | 14.787 | 14.787 | 14.787 | 14.787 | 200.0 |
| 2024-06-21 | ADME | ETF | 43.74 | 43.805 | 43.64 | 43.699 | 21100.0 |
| 2024-06-21 | ADPV | ETF | 29.81 | 30.0249 | 29.73 | 30.0249 | 3450.0 |
| 2024-06-21 | AEMB | ETF | 38.51 | 38.65 | 38.51 | 38.555 | 1400.0 |
| 2024-06-21 | AESR | ETF | 16.34 | 16.4 | 16.34 | 16.37 | 32300.0 |
| 2024-06-21 | AETH | ETF | 45.67 | 46.09 | 45.59 | 46.09 | 2623.0 |
| 2024-06-21 | AFIF | ETF | 9.1 | 9.12 | 9.09 | 9.12 | 12200.0 |
| 2024-06-21 | AFK | ETF | 15.94 | 15.95 | 15.75 | 15.91 | 7700.0 |
| 2024-06-21 | AFLG | ETF | 31.72 | 31.77 | 31.68 | 31.721 | 1500.0 |
| 2024-06-21 | AFMC | ETF | 29.05 | 29.23 | 29.05 | 29.23 | 2500.0 |
| 2024-06-21 | AFSM | ETF | 27.85 | 27.985 | 27.85 | 27.954 | 1300.0 |
| 2024-06-21 | AFTY | ETF | 13.95 | 13.95 | 13.936 | 13.936 | 300.0 |
| 2024-06-21 | AGG | ETF | 97.89 | 97.98 | 97.65 | 97.76 | 4715500.0 |
| 2024-06-21 | AGGH | ETF | 21.17 | 21.17 | 21.06 | 21.1 | 111697.0 |
| 2024-06-21 | AGGY | ETF | 43.35 | 43.43 | 43.3 | 43.355 | 37100.0 |
| 2024-06-21 | AGMI | ETF | 26.14 | 26.14 | 25.89 | 25.96 | 622.0 |
| 2024-06-21 | AGNG | ETF | 30.09 | 30.229 | 30.04 | 30.19 | 2600.0 |
| 2024-06-21 | AGOX | ETF | 28.01 | 28.23 | 28.01 | 28.05 | 20800.0 |
| 2024-06-21 | AGQ | ETF | 39.95 | 40.03 | 38.12 | 38.27 | 2253800.0 |
| 2024-06-21 | AGQI | ETF | 14.3795 | 14.39 | 14.3601 | 14.389 | 7965.0 |
| 2024-06-21 | AGRH | ETF | 25.9 | 25.905 | 25.87 | 25.87 | 4085.0 |
> showing 50 of 3,377 rows — these rows as CSV