PREVIEW / etf_daily / 2024-09-16
file: by_date/etf_daily/2024/2024-09-16.parquet size: 134 KB rows: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-16 | SPY | ETF | 561.74 | 563.11 | 559.9 | 562.84 | 36138682.0 |
| 2024-09-16 | QQQ | ETF | 473.19 | 473.8599 | 469.89 | 473.24 | 22585596.0 |
| 2024-09-16 | IWM | ETF | 217.63 | 218.285 | 216.14 | 217.61 | 23219748.0 |
| 2024-09-16 | DIA | ETF | 416.45 | 418.55 | 415.65 | 417.38 | 3872014.0 |
| 2024-09-16 | GLD | ETF | 238.73 | 239.278 | 238.05 | 238.66 | 4720384.0 |
| 2024-09-16 | TLT | ETF | 100.63 | 101.37 | 100.41 | 101.33 | 30820522.0 |
| 2024-09-16 | AAA | ETF | 25.07 | 25.1 | 25.03 | 25.07 | 10026.0 |
| 2024-09-16 | AAAU | ETF | 25.555 | 25.605 | 25.475 | 25.545 | 936587.0 |
| 2024-09-16 | AADR | ETF | 63.2435 | 63.2435 | 63.2435 | 63.2435 | 9.0 |
| 2024-09-16 | AAPB | ETF | 26.05 | 26.2 | 25.44 | 25.97 | 136392.0 |
| 2024-09-16 | AAPD | ETF | 17.83 | 18.02 | 17.78 | 17.85 | 376074.0 |
| 2024-09-16 | AAPR | ETF | 26.02 | 26.045 | 25.96 | 26.045 | 1363.0 |
| 2024-09-16 | AAPU | ETF | 33.33 | 33.5238 | 32.47 | 33.26 | 964762.0 |
| 2024-09-16 | AAPX | ETF | 30.27 | 30.2918 | 29.44 | 30.03 | 24267.0 |
| 2024-09-16 | AAPY | ETF | 26.16 | 26.2269 | 26.1269 | 26.2269 | 896.0 |
| 2024-09-16 | AAXJ | ETF | 72.43 | 72.5 | 72.125 | 72.42 | 89450.0 |
| 2024-09-16 | ABCS | ETF | 27.86 | 27.86 | 27.77 | 27.8548 | 2663.0 |
| 2024-09-16 | ABEQ | ETF | 32.61 | 32.67 | 32.53 | 32.67 | 3849.0 |
| 2024-09-16 | ABNY | ETF | 81.55 | 81.55 | 79.45 | 79.7465 | 845.0 |
| 2024-09-16 | ACES | ETF | 28.58 | 28.73 | 28.08 | 28.52 | 205802.0 |
| 2024-09-16 | ACIO | ETF | 39.21 | 39.21 | 39.03 | 39.2 | 111802.0 |
| 2024-09-16 | ACSI | ETF | 57.18 | 57.2701 | 57.18 | 57.2701 | 155.0 |
| 2024-09-16 | ACT | ETF | 36.26 | 36.64 | 36.26 | 36.5 | 298206.0 |
| 2024-09-16 | ACTV | ETF | 32.735 | 32.99 | 32.735 | 32.92 | 10641.0 |
| 2024-09-16 | ACVF | ETF | 42.78 | 42.98 | 42.78 | 42.9519 | 7070.0 |
| 2024-09-16 | ACWI | ETF | 116.33 | 116.665 | 115.95 | 116.61 | 3171767.0 |
| 2024-09-16 | ACWV | ETF | 113.81 | 114.33 | 113.81 | 114.31 | 133863.0 |
| 2024-09-16 | ACWX | ETF | 55.23 | 55.405 | 55.05 | 55.38 | 2240244.0 |
| 2024-09-16 | ADFI | ETF | 8.83 | 8.86 | 8.83 | 8.86 | 10982.0 |
| 2024-09-16 | ADIV | ETF | 15.164 | 15.2159 | 15.164 | 15.2159 | 821.0 |
| 2024-09-16 | ADME | ETF | 45.38 | 45.49 | 45.27 | 45.48 | 12410.0 |
| 2024-09-16 | ADPV | ETF | 31.7 | 31.9774 | 31.7 | 31.9774 | 737.0 |
| 2024-09-16 | AEMB | ETF | 39.38 | 39.5174 | 39.33 | 39.5174 | 2771.0 |
| 2024-09-16 | AESR | ETF | 16.57 | 16.6 | 16.53 | 16.5994 | 23274.0 |
| 2024-09-16 | AETH | ETF | 29.76 | 29.76 | 29.3 | 29.4034 | 5464.0 |
| 2024-09-16 | AFIF | ETF | 9.2318 | 9.26 | 9.2318 | 9.245 | 61307.0 |
| 2024-09-16 | AFK | ETF | 16.21 | 16.2999 | 16.01 | 16.2184 | 16638.0 |
| 2024-09-16 | AFLG | ETF | 33.1701 | 33.21 | 33.17 | 33.21 | 539.0 |
| 2024-09-16 | AFMC | ETF | 31.12 | 31.2623 | 31.12 | 31.2623 | 815.0 |
| 2024-09-16 | AFSM | ETF | 29.94 | 30.045 | 29.9301 | 30.045 | 9947.0 |
| 2024-09-16 | AFTY | ETF | 13.51 | 13.54 | 13.51 | 13.54 | 140.0 |
| 2024-09-16 | AGG | ETF | 101.83 | 102.04 | 101.7482 | 101.98 | 8398932.0 |
| 2024-09-16 | AGGH | ETF | 21.76 | 21.96 | 21.76 | 21.91 | 78546.0 |
| 2024-09-16 | AGGS | ETF | 42.83 | 42.83 | 42.81 | 42.8178 | 1702.0 |
| 2024-09-16 | AGGY | ETF | 45.06 | 45.18 | 45.03 | 45.16 | 47373.0 |
| 2024-09-16 | AGIX | ETF | 24.63 | 24.63 | 24.3413 | 24.5362 | 3444.0 |
| 2024-09-16 | AGMI | ETF | 27.87 | 27.87 | 27.8438 | 27.8438 | 130.0 |
| 2024-09-16 | AGNG | ETF | 33.11 | 33.12 | 33.0996 | 33.0996 | 1329.0 |
| 2024-09-16 | AGOX | ETF | 28.59 | 28.675 | 28.27 | 28.62 | 21895.0 |
| 2024-09-16 | AGQ | ETF | 40.31 | 40.39 | 39.32 | 39.77 | 1448896.0 |
> showing 50 of 3,512 rows — these rows as CSV