PREVIEW / etf_daily / 2025-07-15
file: by_date/etf_daily/2025/2025-07-15.parquet size: 152 KB rows: 4,067
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-07-15 | SPY | ETF | 627.52 | 627.86 | 622.06 | 622.14 | 74317260.0 |
| 2025-07-15 | QQQ | ETF | 560.25 | 560.8 | 556.66 | 556.72 | 43277661.0 |
| 2025-07-15 | IWM | ETF | 224.07 | 224.23 | 218.79 | 218.82 | 44215375.0 |
| 2025-07-15 | DIA | ETF | 444.58 | 445.17 | 440.14 | 440.15 | 3810728.0 |
| 2025-07-15 | GLD | ETF | 307.73 | 308.74 | 305.79 | 306.73 | 8149008.0 |
| 2025-07-15 | TLT | ETF | 85.89 | 85.91 | 84.9 | 85.01 | 40454986.0 |
| 2025-07-15 | AAA | ETF | 24.91 | 24.9817 | 24.9 | 24.9465 | 6236.0 |
| 2025-07-15 | AAAU | ETF | 32.97 | 33.1002 | 32.7933 | 32.895 | 2603236.0 |
| 2025-07-15 | AADR | ETF | 78.58 | 79.29 | 78.54 | 78.54 | 1390.0 |
| 2025-07-15 | AAPB | ETF | 20.87 | 21.35 | 20.79 | 20.82 | 239501.0 |
| 2025-07-15 | AAPD | ETF | 17.23 | 17.24 | 17.0 | 17.23 | 804659.0 |
| 2025-07-15 | AAPR | ETF | 27.32 | 27.32 | 27.31 | 27.3145 | 407.0 |
| 2025-07-15 | AAPU | ETF | 22.71 | 23.26 | 22.635 | 22.65 | 3500022.0 |
| 2025-07-15 | AAPW | ETF | 35.75 | 36.17 | 35.67 | 35.74 | 46592.0 |
| 2025-07-15 | AAPX | ETF | 19.64 | 20.09 | 19.55 | 19.57 | 114947.0 |
| 2025-07-15 | AAPY | ETF | 21.8601 | 21.9999 | 21.845 | 21.845 | 6297.0 |
| 2025-07-15 | AAVM | ETF | 26.74 | 26.74 | 26.44 | 26.44 | 360.0 |
| 2025-07-15 | AAXJ | ETF | 83.97 | 83.97 | 83.5 | 83.69 | 434072.0 |
| 2025-07-15 | ABCS | ETF | 29.125 | 29.125 | 28.6838 | 28.6838 | 2118.0 |
| 2025-07-15 | ABEQ | ETF | 34.07 | 34.0793 | 33.89 | 33.954 | 3843.0 |
| 2025-07-15 | ABFL | ETF | 69.91 | 69.91 | 68.9581 | 68.9581 | 18270.0 |
| 2025-07-15 | ABLD | ETF | 29.06 | 29.07 | 28.6924 | 28.6924 | 2044.0 |
| 2025-07-15 | ABLG | ETF | 30.42 | 30.44 | 30.42 | 30.4363 | 259.0 |
| 2025-07-15 | ABNY | ETF | 60.0 | 60.0 | 59.05 | 59.115 | 991.0 |
| 2025-07-15 | ABOT | ETF | 38.0379 | 38.0379 | 38.0379 | 38.0379 | 14.0 |
| 2025-07-15 | ABXB | ETF | 19.4197 | 19.4197 | 19.4197 | 19.4197 | 102.0 |
| 2025-07-15 | ACES | ETF | 27.63 | 27.8 | 27.4365 | 27.4512 | 10467.0 |
| 2025-07-15 | ACGR | ETF | 60.2309 | 60.2309 | 60.2309 | 60.2309 | 25.0 |
| 2025-07-15 | ACIO | ETF | 41.71 | 41.71 | 41.42 | 41.42 | 404764.0 |
| 2025-07-15 | ACLC | ETF | 73.0 | 73.0 | 72.488 | 72.488 | 9415.0 |
| 2025-07-15 | ACSI | ETF | 62.9801 | 62.9801 | 62.8852 | 62.8852 | 500.0 |
| 2025-07-15 | ACT | ETF | 35.1 | 35.39 | 34.35 | 34.39 | 281272.0 |
| 2025-07-15 | ACTV | ETF | 31.835 | 31.9101 | 31.71 | 31.81 | 9965.0 |
| 2025-07-15 | ACVF | ETF | 47.55 | 47.55 | 47.28 | 47.2839 | 16855.0 |
| 2025-07-15 | ACWI | ETF | 129.98 | 130.04 | 128.83 | 128.84 | 1498836.0 |
| 2025-07-15 | ACWV | ETF | 117.41 | 117.44 | 116.44 | 116.44 | 141536.0 |
| 2025-07-15 | ACWX | ETF | 61.1 | 61.1 | 60.4847 | 60.51 | 677915.0 |
| 2025-07-15 | ADBG | ETF | 12.2376 | 12.4198 | 12.14 | 12.16 | 52151.0 |
| 2025-07-15 | ADFI | ETF | 8.46 | 8.48 | 8.43 | 8.4516 | 10453.0 |
| 2025-07-15 | ADIV | ETF | 17.83 | 17.89 | 17.82 | 17.8667 | 1158.0 |
| 2025-07-15 | ADME | ETF | 48.46 | 48.57 | 48.2005 | 48.2005 | 8317.0 |
| 2025-07-15 | ADPV | ETF | 39.27 | 39.7 | 39.2369 | 39.2782 | 36394.0 |
| 2025-07-15 | ADVE | ETF | 35.8867 | 35.8867 | 35.8867 | 35.8867 | 117.0 |
| 2025-07-15 | AESR | ETF | 19.16 | 19.17 | 19.0601 | 19.0601 | 18871.0 |
| 2025-07-15 | AETH | ETF | 41.38 | 42.315 | 40.95 | 41.5861 | 3683.0 |
| 2025-07-15 | AFIF | ETF | 9.3 | 9.32 | 9.3 | 9.3 | 14563.0 |
| 2025-07-15 | AFIX | ETF | 24.75 | 24.78 | 24.7247 | 24.75 | 32785.0 |
| 2025-07-15 | AFK | ETF | 20.62 | 20.73 | 20.501 | 20.55 | 15637.0 |
| 2025-07-15 | AFLG | ETF | 36.66 | 36.66 | 36.19 | 36.22 | 35690.0 |
| 2025-07-15 | AFMC | ETF | 32.73 | 32.73 | 31.949 | 31.95 | 5659.0 |
> showing 50 of 4,067 rows — these rows as CSV