PREVIEW / etf_daily / 2025-10-27
file: by_date/etf_daily/2025/2025-10-27.parquet size: 164 KB rows: 4,354
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-10-27 | SPY | ETF | 682.73 | 685.54 | 682.115 | 685.24 | 63323493.0 |
| 2025-10-27 | QQQ | ETF | 624.52 | 628.55 | 624.03 | 628.09 | 54098611.0 |
| 2025-10-27 | IWM | ETF | 251.78 | 252.21 | 249.5 | 250.3 | 31771572.0 |
| 2025-10-27 | DIA | ETF | 474.755 | 475.62 | 473.71 | 475.35 | 4718103.0 |
| 2025-10-27 | GLD | ETF | 371.13 | 371.59 | 365.34 | 367.01 | 23655133.0 |
| 2025-10-27 | TLT | ETF | 91.32 | 91.79 | 91.0944 | 91.78 | 30028405.0 |
| 2025-10-27 | AAA | ETF | 25.07 | 25.1 | 25.041 | 25.065 | 23425.0 |
| 2025-10-27 | AAAU | ETF | 39.82 | 39.85 | 39.2 | 39.38 | 5598115.0 |
| 2025-10-27 | AADR | ETF | 84.53 | 84.74 | 83.91 | 84.54 | 5123.0 |
| 2025-10-27 | AAPB | ETF | 32.1 | 33.16 | 32.1 | 33.1299 | 145115.0 |
| 2025-10-27 | AAPD | ETF | 13.47 | 13.47 | 13.245 | 13.25 | 2116549.0 |
| 2025-10-27 | AAPR | ETF | 28.1399 | 28.1399 | 28.1 | 28.1 | 2836.0 |
| 2025-10-27 | AAPU | ETF | 34.62 | 35.74 | 34.62 | 35.67 | 1918991.0 |
| 2025-10-27 | AAPW | ETF | 41.7 | 42.36 | 41.54 | 42.36 | 21989.0 |
| 2025-10-27 | AAPX | ETF | 30.05 | 30.91 | 29.99 | 30.84 | 111331.0 |
| 2025-10-27 | AAPY | ETF | 24.38 | 24.5902 | 24.3348 | 24.57 | 2479.0 |
| 2025-10-27 | AAVM | ETF | 29.02 | 29.0712 | 29.02 | 29.0712 | 115.0 |
| 2025-10-27 | AAXJ | ETF | 95.74 | 95.78 | 95.385 | 95.73 | 340594.0 |
| 2025-10-27 | ABCS | ETF | 30.4252 | 30.4252 | 30.29 | 30.326 | 2769.0 |
| 2025-10-27 | ABEQ | ETF | 35.0 | 35.02 | 34.91 | 35.02 | 15238.0 |
| 2025-10-27 | ABFL | ETF | 73.22 | 73.25 | 72.87 | 73.25 | 95253.0 |
| 2025-10-27 | ABLD | ETF | 28.83 | 28.8448 | 28.8032 | 28.8448 | 2869.0 |
| 2025-10-27 | ABLG | ETF | 31.37 | 31.41 | 31.3652 | 31.3652 | 1612.0 |
| 2025-10-27 | ABNY | ETF | 49.55 | 49.575 | 48.65 | 49.55 | 2011.0 |
| 2025-10-27 | ABOT | ETF | 40.9972 | 40.9972 | 40.9972 | 40.9972 | 138.0 |
| 2025-10-27 | ABXB | ETF | 19.7729 | 19.7729 | 19.7729 | 19.7729 | 151.0 |
| 2025-10-27 | ACES | ETF | 36.33 | 36.33 | 35.49 | 35.58 | 49431.0 |
| 2025-10-27 | ACGR | ETF | 66.96 | 67.3913 | 66.96 | 67.3913 | 1068.0 |
| 2025-10-27 | ACIO | ETF | 44.28 | 44.43 | 44.26 | 44.42 | 248383.0 |
| 2025-10-27 | ACLC | ETF | 78.88 | 79.1857 | 78.8 | 79.1857 | 5777.0 |
| 2025-10-27 | ACSG | ETF | 41.81 | 41.8383 | 41.81 | 41.8383 | 684.0 |
| 2025-10-27 | ACSI | ETF | 67.16 | 67.3335 | 67.16 | 67.3335 | 526.0 |
| 2025-10-27 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 5007.0 |
| 2025-10-27 | ACVF | ETF | 50.08 | 50.22 | 50.06 | 50.2187 | 9922.0 |
| 2025-10-27 | ACWI | ETF | 141.83 | 142.415 | 141.83 | 142.34 | 2005415.0 |
| 2025-10-27 | ACWV | ETF | 120.48 | 120.74 | 120.251 | 120.72 | 91002.0 |
| 2025-10-27 | ACWX | ETF | 67.04 | 67.0669 | 66.875 | 67.05 | 981564.0 |
| 2025-10-27 | ADBG | ETF | 10.95 | 11.09 | 10.7412 | 11.07 | 491049.0 |
| 2025-10-27 | ADFI | ETF | 8.76 | 8.76 | 8.66 | 8.6856 | 31467.0 |
| 2025-10-27 | ADIV | ETF | 18.48 | 18.4999 | 18.34 | 18.43 | 11566.0 |
| 2025-10-27 | ADME | ETF | 52.02 | 52.2 | 51.99 | 52.2 | 8071.0 |
| 2025-10-27 | ADPV | ETF | 44.13 | 44.13 | 43.67 | 44.112 | 11835.0 |
| 2025-10-27 | ADVE | ETF | 39.38 | 39.4203 | 39.38 | 39.4203 | 364.0 |
| 2025-10-27 | AESR | ETF | 21.13 | 21.2 | 21.11 | 21.2 | 19366.0 |
| 2025-10-27 | AETH | ETF | 43.01 | 43.104 | 43.0 | 43.0545 | 2130.0 |
| 2025-10-27 | AFIF | ETF | 9.4211 | 9.45 | 9.42 | 9.43 | 22093.0 |
| 2025-10-27 | AFIX | ETF | 25.4755 | 25.4755 | 25.4755 | 25.4755 | 116.0 |
| 2025-10-27 | AFK | ETF | 24.21 | 24.21 | 23.6 | 23.93 | 88162.0 |
| 2025-10-27 | AFLG | ETF | 39.45 | 39.5 | 39.385 | 39.5 | 28363.0 |
| 2025-10-27 | AFMC | ETF | 34.3953 | 34.4 | 34.18 | 34.23 | 13210.0 |
> showing 50 of 4,354 rows — these rows as CSV