PREVIEW / etf_daily / 2025-06-24
file: by_date/etf_daily/2025/2025-06-24.parquet size: 157 KB rows: 4,171
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-24 | SPY | ETF | 604.33 | 607.8499 | 603.41 | 606.78 | 67882281.0 |
| 2025-06-24 | QQQ | ETF | 536.89 | 540.7 | 536.27 | 539.78 | 45441982.0 |
| 2025-06-24 | IWM | ETF | 213.29 | 214.93 | 212.36 | 214.47 | 31753948.0 |
| 2025-06-24 | DIA | ETF | 428.53 | 431.73 | 427.68 | 430.79 | 4954722.0 |
| 2025-06-24 | GLD | ETF | 305.07 | 306.34 | 303.54 | 306.19 | 12030847.0 |
| 2025-06-24 | TLT | ETF | 86.47 | 87.59 | 86.425 | 87.4 | 32954413.0 |
| 2025-06-24 | AAA | ETF | 25.09 | 25.09 | 25.01 | 25.0387 | 13712.0 |
| 2025-06-24 | AAAU | ETF | 32.73 | 32.85 | 32.55 | 32.835 | 4261859.0 |
| 2025-06-24 | AADR | ETF | 76.45 | 78.38 | 76.43 | 77.99 | 5231.0 |
| 2025-06-24 | AAPB | ETF | 19.7 | 19.84 | 19.23 | 19.26 | 314469.0 |
| 2025-06-24 | AAPD | ETF | 17.74 | 18.0 | 17.67 | 17.94 | 1462749.0 |
| 2025-06-24 | AAPR | ETF | 27.115 | 27.115 | 27.115 | 27.115 | 37.0 |
| 2025-06-24 | AAPU | ETF | 21.47 | 21.62 | 20.94 | 20.97 | 5636107.0 |
| 2025-06-24 | AAPW | ETF | 35.64 | 35.67 | 35.1415 | 35.1415 | 18823.0 |
| 2025-06-24 | AAPX | ETF | 18.55 | 18.67 | 18.11 | 18.11 | 208012.0 |
| 2025-06-24 | AAPY | ETF | 21.175 | 21.175 | 20.995 | 20.995 | 1730.0 |
| 2025-06-24 | AAVM | ETF | 26.64 | 26.64 | 26.64 | 26.64 | 14.0 |
| 2025-06-24 | AAXJ | ETF | 81.53 | 82.395 | 81.43 | 82.28 | 681012.0 |
| 2025-06-24 | ABCS | ETF | 28.58 | 28.6632 | 28.5008 | 28.6281 | 6096.0 |
| 2025-06-24 | ABEQ | ETF | 34.3799 | 34.5137 | 34.35 | 34.477 | 6486.0 |
| 2025-06-24 | ABFL | ETF | 69.65 | 70.11 | 69.59 | 70.0793 | 8798.0 |
| 2025-06-24 | ABLD | ETF | 28.675 | 28.73 | 28.61 | 28.6777 | 5240.0 |
| 2025-06-24 | ABLG | ETF | 30.94 | 31.03 | 30.94 | 31.017 | 3229.0 |
| 2025-06-24 | ABNY | ETF | 59.2 | 59.2 | 58.4 | 59.05 | 3769.0 |
| 2025-06-24 | ABOT | ETF | 37.78 | 38.01 | 37.78 | 37.9969 | 295.0 |
| 2025-06-24 | ABXB | ETF | 19.7 | 19.74 | 19.7 | 19.74 | 1579.0 |
| 2025-06-24 | ACES | ETF | 25.15 | 25.63 | 25.055 | 25.51 | 20238.0 |
| 2025-06-24 | ACGR | ETF | 58.37 | 58.48 | 58.3222 | 58.3222 | 1807.0 |
| 2025-06-24 | ACIO | ETF | 40.82 | 40.945 | 40.7126 | 40.885 | 137169.0 |
| 2025-06-24 | ACLC | ETF | 70.81 | 70.963 | 70.81 | 70.963 | 2580.0 |
| 2025-06-24 | ACSI | ETF | 62.5081 | 62.5081 | 62.5081 | 62.5081 | 139.0 |
| 2025-06-24 | ACT | ETF | 37.4 | 37.8552 | 37.312 | 37.435 | 443063.0 |
| 2025-06-24 | ACTV | ETF | 31.3 | 31.39 | 31.245 | 31.3557 | 2934.0 |
| 2025-06-24 | ACVF | ETF | 46.2 | 46.5275 | 46.2 | 46.5275 | 2326.0 |
| 2025-06-24 | ACVT | ETF | 25.925 | 26.0101 | 25.925 | 26.0101 | 200.0 |
| 2025-06-24 | ACWI | ETF | 125.94 | 126.6665 | 125.74 | 126.5 | 6678447.0 |
| 2025-06-24 | ACWV | ETF | 117.35 | 117.89 | 117.05 | 117.7 | 114392.0 |
| 2025-06-24 | ACWX | ETF | 59.85 | 60.2688 | 59.82 | 60.19 | 1429203.0 |
| 2025-06-24 | ADBG | ETF | 13.74 | 13.74 | 13.27 | 13.55 | 85567.0 |
| 2025-06-24 | ADFI | ETF | 8.494 | 8.52 | 8.441 | 8.48 | 15685.0 |
| 2025-06-24 | ADIV | ETF | 17.5826 | 17.6297 | 17.55 | 17.6297 | 1569.0 |
| 2025-06-24 | ADME | ETF | 47.2 | 47.46 | 47.2 | 47.39 | 11915.0 |
| 2025-06-24 | ADPV | ETF | 36.02 | 36.44 | 36.02 | 36.35 | 73557.0 |
| 2025-06-24 | ADVE | ETF | 35.6634 | 35.6634 | 35.6494 | 35.653 | 678.0 |
| 2025-06-24 | AESR | ETF | 18.61 | 18.795 | 18.6 | 18.795 | 21638.0 |
| 2025-06-24 | AETH | ETF | 35.69 | 35.69 | 35.52 | 35.5489 | 2559.0 |
| 2025-06-24 | AFIF | ETF | 9.28 | 9.3 | 9.28 | 9.287 | 5882.0 |
| 2025-06-24 | AFIX | ETF | 24.85 | 24.8699 | 24.85 | 24.8699 | 2186.0 |
| 2025-06-24 | AFK | ETF | 19.55 | 19.75 | 19.4401 | 19.75 | 4725.0 |
| 2025-06-24 | AFLG | ETF | 35.78 | 35.9 | 35.67 | 35.83 | 20583.0 |
> showing 50 of 4,171 rows — these rows as CSV