PREVIEW / etf_daily / 2025-08-18
file: by_date/etf_daily/2025/2025-08-18.parquet size: 161 KB rows: 4,259
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-18 | SPY | ETF | 642.86 | 644.0 | 642.18 | 643.3 | 43956899.0 |
| 2025-08-18 | QQQ | ETF | 576.44 | 577.765 | 575.2412 | 577.11 | 29830957.0 |
| 2025-08-18 | IWM | ETF | 227.21 | 228.46 | 226.94 | 227.96 | 20132187.0 |
| 2025-08-18 | DIA | ETF | 449.35 | 449.97 | 448.63 | 449.05 | 3807101.0 |
| 2025-08-18 | GLD | ETF | 307.79 | 307.89 | 306.625 | 306.95 | 6146406.0 |
| 2025-08-18 | TLT | ETF | 86.5 | 86.54 | 85.985 | 86.15 | 26774611.0 |
| 2025-08-18 | AAA | ETF | 25.0 | 25.0 | 24.9415 | 24.995 | 6697.0 |
| 2025-08-18 | AAAU | ETF | 33.02 | 33.02 | 32.88 | 32.91 | 1052564.0 |
| 2025-08-18 | AADR | ETF | 82.81 | 82.81 | 82.315 | 82.315 | 850.0 |
| 2025-08-18 | AAPB | ETF | 25.26 | 25.55 | 24.92 | 25.1 | 357436.0 |
| 2025-08-18 | AAPD | ETF | 15.53 | 15.63 | 15.4399 | 15.58 | 885339.0 |
| 2025-08-18 | AAPR | ETF | 27.62 | 27.62 | 27.61 | 27.62 | 6628.0 |
| 2025-08-18 | AAPU | ETF | 27.48 | 27.8 | 27.0901 | 27.27 | 2355700.0 |
| 2025-08-18 | AAPW | ETF | 38.56 | 38.56 | 37.92 | 38.07 | 20578.0 |
| 2025-08-18 | AAPX | ETF | 23.65 | 23.94 | 23.3541 | 23.53 | 94863.0 |
| 2025-08-18 | AAPY | ETF | 23.3 | 23.3 | 23.135 | 23.2311 | 6291.0 |
| 2025-08-18 | AAVM | ETF | 27.75 | 27.84 | 27.75 | 27.83 | 656.0 |
| 2025-08-18 | AAXJ | ETF | 86.45 | 86.51 | 86.26 | 86.51 | 224334.0 |
| 2025-08-18 | ABCS | ETF | 29.75 | 29.76 | 29.6963 | 29.6963 | 2560.0 |
| 2025-08-18 | ABEQ | ETF | 34.66 | 34.67 | 34.58 | 34.66 | 7518.0 |
| 2025-08-18 | ABFL | ETF | 68.74 | 68.98 | 68.64 | 68.9756 | 20483.0 |
| 2025-08-18 | ABLD | ETF | 28.49 | 28.49 | 28.42 | 28.4678 | 4641.0 |
| 2025-08-18 | ABLG | ETF | 29.87 | 29.87 | 29.87 | 29.87 | 27.0 |
| 2025-08-18 | ABNY | ETF | 52.8 | 53.1 | 52.6 | 53.05 | 36533.0 |
| 2025-08-18 | ABOT | ETF | 38.5109 | 38.5109 | 38.5109 | 38.5109 | 176.0 |
| 2025-08-18 | ABXB | ETF | 19.66 | 19.66 | 19.66 | 19.66 | 9.0 |
| 2025-08-18 | ACES | ETF | 28.83 | 29.305 | 28.83 | 29.26 | 167539.0 |
| 2025-08-18 | ACGR | ETF | 62.8799 | 62.8799 | 62.8799 | 62.8799 | 106.0 |
| 2025-08-18 | ACIO | ETF | 42.35 | 42.44 | 42.3459 | 42.39 | 101421.0 |
| 2025-08-18 | ACLC | ETF | 74.85 | 74.85 | 74.68 | 74.721 | 346794.0 |
| 2025-08-18 | ACSI | ETF | 65.7615 | 65.7615 | 65.7615 | 65.7615 | 176.0 |
| 2025-08-18 | ACTV | ETF | 32.85 | 32.8781 | 32.85 | 32.8781 | 1645.0 |
| 2025-08-18 | ACVF | ETF | 48.22 | 48.2994 | 48.22 | 48.2759 | 3132.0 |
| 2025-08-18 | ACVT | ETF | 26.49 | 26.5 | 26.49 | 26.5 | 246.0 |
| 2025-08-18 | ACWI | ETF | 133.2 | 133.44 | 133.09 | 133.41 | 4718770.0 |
| 2025-08-18 | ACWV | ETF | 119.3 | 119.51 | 119.2 | 119.3 | 50810.0 |
| 2025-08-18 | ACWX | ETF | 62.95 | 63.0 | 62.79 | 63.0 | 771460.0 |
| 2025-08-18 | ADBG | ETF | 11.41 | 11.5448 | 11.22 | 11.4859 | 143589.0 |
| 2025-08-18 | ADFI | ETF | 8.49 | 8.51 | 8.49 | 8.495 | 8298.0 |
| 2025-08-18 | ADIV | ETF | 18.3 | 18.3 | 18.2354 | 18.2922 | 2964.0 |
| 2025-08-18 | ADME | ETF | 49.4 | 49.6 | 49.4 | 49.6 | 9561.0 |
| 2025-08-18 | ADPV | ETF | 40.49 | 40.54 | 40.14 | 40.47 | 50948.0 |
| 2025-08-18 | ADVE | ETF | 37.1 | 37.1089 | 37.1 | 37.1089 | 116.0 |
| 2025-08-18 | AESR | ETF | 19.675 | 19.71 | 19.65 | 19.67 | 14399.0 |
| 2025-08-18 | AETH | ETF | 53.47 | 53.63 | 52.6858 | 53.5673 | 5186.0 |
| 2025-08-18 | AFIF | ETF | 9.36 | 9.36 | 9.35 | 9.355 | 69699.0 |
| 2025-08-18 | AFIX | ETF | 24.96 | 24.97 | 24.96 | 24.965 | 5754.0 |
| 2025-08-18 | AFK | ETF | 21.88 | 21.88 | 21.63 | 21.7701 | 26814.0 |
| 2025-08-18 | AFLG | ETF | 37.49 | 37.5011 | 37.38 | 37.4519 | 189150.0 |
| 2025-08-18 | AFMC | ETF | 32.92 | 32.92 | 32.8 | 32.8719 | 158337.0 |
> showing 50 of 4,259 rows — these rows as CSV