PREVIEW / etf_daily / 2025-06-27
file: by_date/etf_daily/2025/2025-06-27.parquet size: 159 KB rows: 4,193
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 |
|---|---|---|---|---|---|---|---|
| 2025-06-27 | SPY | ETF | 612.88 | 616.39 | 610.83 | 614.91 | 86224405.0 |
| 2025-06-27 | QQQ | ETF | 547.26 | 549.99 | 544.545 | 548.09 | 57577147.0 |
| 2025-06-27 | IWM | ETF | 216.05 | 217.405 | 214.125 | 215.48 | 47693069.0 |
| 2025-06-27 | DIA | ETF | 435.15 | 439.5599 | 435.1 | 438.0 | 3619558.0 |
| 2025-06-27 | GLD | ETF | 300.03 | 302.36 | 299.89 | 301.22 | 13298412.0 |
| 2025-06-27 | TLT | ETF | 87.57 | 88.16 | 87.235 | 87.39 | 74979933.0 |
| 2025-06-27 | AAA | ETF | 25.0758 | 25.0758 | 25.02 | 25.07 | 3734.0 |
| 2025-06-27 | AAAU | ETF | 32.16 | 32.425 | 32.15 | 32.3 | 3655524.0 |
| 2025-06-27 | AADR | ETF | 79.72 | 79.72 | 78.05 | 78.33 | 7612.0 |
| 2025-06-27 | AAPB | ETF | 19.49 | 19.7452 | 19.23 | 19.41 | 236067.0 |
| 2025-06-27 | AAPD | ETF | 17.84 | 17.94 | 17.7 | 17.9 | 780172.0 |
| 2025-06-27 | AAPR | ETF | 27.205 | 27.2499 | 27.15 | 27.2237 | 21582.0 |
| 2025-06-27 | AAPU | ETF | 21.27 | 21.54 | 20.99 | 21.1 | 4355040.0 |
| 2025-06-27 | AAPW | ETF | 35.35 | 35.58 | 35.186 | 35.2251 | 24249.0 |
| 2025-06-27 | AAPX | ETF | 18.36 | 18.5682 | 18.16 | 18.16 | 154664.0 |
| 2025-06-27 | AAPY | ETF | 21.155 | 21.18 | 21.0532 | 21.0532 | 2152.0 |
| 2025-06-27 | AAVM | ETF | 27.15 | 27.15 | 27.0577 | 27.0577 | 370.0 |
| 2025-06-27 | AAXJ | ETF | 82.65 | 82.84 | 82.38 | 82.65 | 402791.0 |
| 2025-06-27 | ABCS | ETF | 28.61 | 28.76 | 28.55 | 28.6613 | 3205.0 |
| 2025-06-27 | ABEQ | ETF | 34.18 | 34.18 | 33.97 | 34.05 | 10190.0 |
| 2025-06-27 | ABFL | ETF | 69.89 | 70.4999 | 69.89 | 70.18 | 35464.0 |
| 2025-06-27 | ABLD | ETF | 28.52 | 28.57 | 28.35 | 28.4609 | 11171.0 |
| 2025-06-27 | ABLG | ETF | 30.9284 | 30.9284 | 30.9284 | 30.9284 | 41.0 |
| 2025-06-27 | ABNY | ETF | 57.75 | 58.2 | 57.5005 | 57.994 | 8744.0 |
| 2025-06-27 | ABOT | ETF | 38.3507 | 38.3507 | 38.3507 | 38.3507 | 44.0 |
| 2025-06-27 | ABXB | ETF | 19.51 | 19.51 | 19.48 | 19.501 | 7307.0 |
| 2025-06-27 | ACES | ETF | 26.18 | 26.18 | 25.426 | 25.72 | 11334.0 |
| 2025-06-27 | ACGR | ETF | 59.4 | 59.4 | 59.3979 | 59.3979 | 307.0 |
| 2025-06-27 | ACIO | ETF | 41.07 | 41.89 | 41.0636 | 41.22 | 173262.0 |
| 2025-06-27 | ACLC | ETF | 71.88 | 72.0599 | 71.43 | 71.8899 | 4537.0 |
| 2025-06-27 | ACSI | ETF | 63.0569 | 63.0569 | 63.0569 | 63.0569 | 138.0 |
| 2025-06-27 | ACT | ETF | 36.85 | 37.18 | 36.62 | 36.78 | 712236.0 |
| 2025-06-27 | ACTV | ETF | 31.49 | 31.55 | 31.245 | 31.5303 | 2324.0 |
| 2025-06-27 | ACVF | ETF | 46.66 | 47.01 | 46.66 | 46.8327 | 4991.0 |
| 2025-06-27 | ACVT | ETF | 26.09 | 26.09 | 26.09 | 26.09 | 203.0 |
| 2025-06-27 | ACWI | ETF | 127.77 | 128.44 | 127.36 | 128.04 | 3146900.0 |
| 2025-06-27 | ACWV | ETF | 117.59 | 118.14 | 117.32 | 117.74 | 243150.0 |
| 2025-06-27 | ACWX | ETF | 60.84 | 61.03 | 60.5765 | 60.82 | 1139806.0 |
| 2025-06-27 | ADBG | ETF | 13.78 | 14.0623 | 13.7201 | 13.83 | 53205.0 |
| 2025-06-27 | ADFI | ETF | 8.51 | 8.58 | 8.49 | 8.4981 | 13945.0 |
| 2025-06-27 | ADIV | ETF | 17.61 | 17.6293 | 17.5734 | 17.6126 | 4092.0 |
| 2025-06-27 | ADME | ETF | 47.84 | 47.96 | 47.66 | 47.8971 | 14814.0 |
| 2025-06-27 | ADPV | ETF | 36.4125 | 36.58 | 36.2 | 36.42 | 10343.0 |
| 2025-06-27 | ADVE | ETF | 35.79 | 35.8672 | 35.79 | 35.8672 | 178.0 |
| 2025-06-27 | AESR | ETF | 18.97 | 18.97 | 18.77 | 18.9142 | 6850.0 |
| 2025-06-27 | AETH | ETF | 35.63 | 35.63 | 35.63 | 35.63 | 252.0 |
| 2025-06-27 | AFIF | ETF | 9.2997 | 9.31 | 9.29 | 9.3 | 23964.0 |
| 2025-06-27 | AFIX | ETF | 24.891 | 24.891 | 24.891 | 24.891 | 109.0 |
| 2025-06-27 | AFK | ETF | 20.16 | 20.225 | 20.0218 | 20.1 | 12211.0 |
| 2025-06-27 | AFLG | ETF | 36.02 | 36.2282 | 35.93 | 36.13 | 112307.0 |
> showing 50 of 4,193 rows — these rows as CSV