PREVIEW / etf_daily / 2025-08-01
file: by_date/etf_daily/2025/2025-08-01.parquet size: 161 KB rows: 4,236
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-08-01 | SPY | ETF | 626.3 | 626.34 | 619.29 | 621.72 | 140073695.0 |
| 2025-08-01 | QQQ | ETF | 558.83 | 559.02 | 551.68 | 553.88 | 69400789.0 |
| 2025-08-01 | IWM | ETF | 216.22 | 216.56 | 212.34 | 214.92 | 63832456.0 |
| 2025-08-01 | DIA | ETF | 437.75 | 437.76 | 433.4 | 435.72 | 5978139.0 |
| 2025-08-01 | GLD | ETF | 308.61 | 309.55 | 307.45 | 309.11 | 12838790.0 |
| 2025-08-01 | TLT | ETF | 87.56 | 87.93 | 87.515 | 87.82 | 63432055.0 |
| 2025-08-01 | AAA | ETF | 24.96 | 25.03 | 24.93 | 25.03 | 6951.0 |
| 2025-08-01 | AAAU | ETF | 33.09 | 33.19 | 32.97 | 33.15 | 4025783.0 |
| 2025-08-01 | AADR | ETF | 77.04 | 77.3697 | 76.84 | 77.3576 | 2278.0 |
| 2025-08-01 | AAPB | ETF | 21.05 | 21.59 | 19.2299 | 19.37 | 1019537.0 |
| 2025-08-01 | AAPD | ETF | 17.12 | 17.9 | 16.91 | 17.84 | 1570572.0 |
| 2025-08-01 | AAPR | ETF | 27.37 | 27.39 | 27.33 | 27.366 | 1068.0 |
| 2025-08-01 | AAPU | ETF | 22.95 | 23.5 | 20.9288 | 21.09 | 10162504.0 |
| 2025-08-01 | AAPW | ETF | 35.18 | 35.58 | 33.3 | 33.56 | 54762.0 |
| 2025-08-01 | AAPX | ETF | 19.76 | 20.27 | 18.06 | 18.2 | 798782.0 |
| 2025-08-01 | AAPY | ETF | 21.86 | 21.88 | 21.07 | 21.1696 | 6237.0 |
| 2025-08-01 | AAVM | ETF | 26.57 | 26.605 | 26.57 | 26.605 | 302.0 |
| 2025-08-01 | AAXJ | ETF | 83.12 | 83.19 | 82.53 | 82.9 | 364015.0 |
| 2025-08-01 | ABCS | ETF | 28.3799 | 28.49 | 28.19 | 28.426 | 4782.0 |
| 2025-08-01 | ABEQ | ETF | 34.18 | 34.18 | 34.0675 | 34.14 | 3731.0 |
| 2025-08-01 | ABFL | ETF | 68.75 | 68.75 | 68.24 | 68.3409 | 9503.0 |
| 2025-08-01 | ABLD | ETF | 28.41 | 28.525 | 28.41 | 28.525 | 2002.0 |
| 2025-08-01 | ABLG | ETF | 29.03 | 29.0984 | 28.99 | 29.0984 | 931.0 |
| 2025-08-01 | ABNY | ETF | 54.55 | 54.6965 | 53.5375 | 53.75 | 3473.0 |
| 2025-08-01 | ABOT | ETF | 37.8104 | 37.8308 | 37.8104 | 37.8308 | 481.0 |
| 2025-08-01 | ABXB | ETF | 19.53 | 19.5487 | 19.53 | 19.5487 | 110.0 |
| 2025-08-01 | ACES | ETF | 26.82 | 27.02 | 26.41 | 26.59 | 64790.0 |
| 2025-08-01 | ACGR | ETF | 60.6541 | 60.6541 | 60.6541 | 60.6541 | 19.0 |
| 2025-08-01 | ACIO | ETF | 41.38 | 41.4451 | 41.18 | 41.26 | 142934.0 |
| 2025-08-01 | ACLC | ETF | 72.81 | 72.81 | 72.354 | 72.354 | 2053.0 |
| 2025-08-01 | ACSI | ETF | 62.9061 | 62.9061 | 62.9061 | 62.9061 | 70.0 |
| 2025-08-01 | ACTV | ETF | 31.84 | 31.96 | 31.72 | 31.8787 | 13445.0 |
| 2025-08-01 | ACVF | ETF | 47.45 | 47.45 | 47.0306 | 47.1936 | 5030.0 |
| 2025-08-01 | ACWI | ETF | 129.13 | 129.13 | 127.77 | 128.32 | 8375029.0 |
| 2025-08-01 | ACWV | ETF | 116.71 | 116.96 | 116.4 | 116.79 | 106552.0 |
| 2025-08-01 | ACWX | ETF | 60.1 | 60.1 | 59.67 | 60.01 | 1482695.0 |
| 2025-08-01 | ADBG | ETF | 11.48 | 11.5174 | 10.96 | 10.9914 | 80243.0 |
| 2025-08-01 | ADFI | ETF | 8.52 | 8.6 | 8.49 | 8.545 | 21994.0 |
| 2025-08-01 | ADIV | ETF | 17.17 | 17.66 | 17.17 | 17.6137 | 15621.0 |
| 2025-08-01 | ADME | ETF | 48.2688 | 48.34 | 48.09 | 48.1824 | 3774.0 |
| 2025-08-01 | ADPV | ETF | 39.29 | 39.8 | 38.59 | 39.3 | 73546.0 |
| 2025-08-01 | ADVE | ETF | 35.6167 | 35.6167 | 35.6167 | 35.6167 | 20.0 |
| 2025-08-01 | AESR | ETF | 19.07 | 19.07 | 18.9399 | 18.96 | 16562.0 |
| 2025-08-01 | AETH | ETF | 49.73 | 49.73 | 47.7005 | 47.7005 | 3089.0 |
| 2025-08-01 | AFIF | ETF | 9.3396 | 9.35 | 9.3293 | 9.3429 | 8412.0 |
| 2025-08-01 | AFIX | ETF | 25.01 | 25.07 | 25.01 | 25.0685 | 1017.0 |
| 2025-08-01 | AFK | ETF | 20.88 | 20.94 | 20.75 | 20.86 | 8398.0 |
| 2025-08-01 | AFLG | ETF | 36.5 | 36.5 | 36.23 | 36.333 | 37892.0 |
| 2025-08-01 | AFMC | ETF | 31.68 | 31.97 | 31.68 | 31.8586 | 2304.0 |
| 2025-08-01 | AFSC | ETF | 28.12 | 28.365 | 28.12 | 28.3075 | 1173.0 |
> showing 50 of 4,236 rows — these rows as CSV