PREVIEW / etf_daily / 2024-09-11
file: by_date/etf_daily/2024/2024-09-11.parquet size: 134 KB rows: 3,470
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-11 | SPY | ETF | 548.7 | 555.36 | 539.96 | 554.42 | 75150422.0 |
| 2024-09-11 | QQQ | ETF | 459.91 | 469.37 | 451.28 | 468.62 | 57842992.0 |
| 2024-09-11 | IWM | ETF | 207.47 | 209.25 | 204.21 | 208.92 | 27011718.0 |
| 2024-09-11 | DIA | ETF | 407.15 | 409.93 | 400.81 | 409.27 | 3132211.0 |
| 2024-09-11 | GLD | ETF | 231.72 | 232.87 | 231.09 | 232.25 | 4615513.0 |
| 2024-09-11 | TLT | ETF | 100.49 | 101.235 | 100.35 | 100.61 | 39418053.0 |
| 2024-09-11 | AAA | ETF | 25.075 | 25.075 | 25.04 | 25.0558 | 10482.0 |
| 2024-09-11 | AAAU | ETF | 24.81 | 24.9262 | 24.735 | 24.86 | 1162319.0 |
| 2024-09-11 | AADR | ETF | 61.83 | 61.83 | 61.54 | 61.54 | 205.0 |
| 2024-09-11 | AAPB | ETF | 27.25 | 27.69 | 26.49 | 27.59 | 242949.0 |
| 2024-09-11 | AAPD | ETF | 17.44 | 17.71 | 17.31 | 17.34 | 443559.0 |
| 2024-09-11 | AAPR | ETF | 25.78 | 25.873 | 25.78 | 25.873 | 1000.0 |
| 2024-09-11 | AAPU | ETF | 34.88 | 35.41 | 33.84 | 35.13 | 512684.0 |
| 2024-09-11 | AAPX | ETF | 31.7 | 31.96 | 30.71 | 31.96 | 16901.0 |
| 2024-09-11 | AAPY | ETF | 26.47 | 26.9371 | 26.45 | 26.9371 | 2748.0 |
| 2024-09-11 | AAXJ | ETF | 70.78 | 71.435 | 70.12 | 71.38 | 288580.0 |
| 2024-09-11 | ABCS | ETF | 26.6 | 27.0176 | 26.49 | 27.0176 | 2094.0 |
| 2024-09-11 | ABEQ | ETF | 31.97 | 32.1838 | 31.97 | 32.1838 | 7542.0 |
| 2024-09-11 | ABNY | ETF | 77.425 | 78.85 | 77.075 | 78.85 | 521.0 |
| 2024-09-11 | ACES | ETF | 27.29 | 28.29 | 27.25 | 28.26 | 30851.0 |
| 2024-09-11 | ACIO | ETF | 38.5 | 38.83 | 38.14 | 38.83 | 163704.0 |
| 2024-09-11 | ACSI | ETF | 56.4974 | 56.4974 | 56.4974 | 56.4974 | 40.0 |
| 2024-09-11 | ACT | ETF | 35.82 | 35.82 | 34.695 | 35.13 | 298384.0 |
| 2024-09-11 | ACTV | ETF | 31.57 | 31.7271 | 31.18 | 31.7271 | 2126.0 |
| 2024-09-11 | ACVF | ETF | 41.4525 | 42.2818 | 41.22 | 42.2818 | 3349.0 |
| 2024-09-11 | ACWI | ETF | 113.61 | 114.815 | 112.07 | 114.63 | 2511010.0 |
| 2024-09-11 | ACWV | ETF | 112.33 | 112.35 | 110.95 | 112.04 | 126081.0 |
| 2024-09-11 | ACWX | ETF | 54.06 | 54.4 | 53.49 | 54.34 | 946558.0 |
| 2024-09-11 | ADFI | ETF | 8.79 | 8.81 | 8.79 | 8.81 | 13718.0 |
| 2024-09-11 | ADIV | ETF | 15.0047 | 15.0047 | 15.0047 | 15.0047 | 6.0 |
| 2024-09-11 | ADME | ETF | 43.885 | 44.9046 | 43.885 | 44.9046 | 5888.0 |
| 2024-09-11 | ADPV | ETF | 30.6975 | 30.9165 | 30.6431 | 30.9165 | 14901.0 |
| 2024-09-11 | AEMB | ETF | 39.545 | 39.7199 | 39.545 | 39.6352 | 528.0 |
| 2024-09-11 | AESR | ETF | 16.0 | 16.37 | 15.93 | 16.37 | 22137.0 |
| 2024-09-11 | AETH | ETF | 30.06 | 30.4899 | 29.411 | 30.2195 | 5632.0 |
| 2024-09-11 | AFIF | ETF | 9.21 | 9.235 | 9.21 | 9.235 | 5071.0 |
| 2024-09-11 | AFK | ETF | 15.69 | 15.84 | 15.54 | 15.84 | 4401.0 |
| 2024-09-11 | AFLG | ETF | 32.36 | 32.5761 | 31.88 | 32.5761 | 7422.0 |
| 2024-09-11 | AFMC | ETF | 29.4 | 30.0996 | 29.4 | 30.0996 | 1589.0 |
| 2024-09-11 | AFSM | ETF | 28.4295 | 28.7355 | 28.4295 | 28.7355 | 1252.0 |
| 2024-09-11 | AFTY | ETF | 13.565 | 13.565 | 13.565 | 13.565 | 250.0 |
| 2024-09-11 | AGG | ETF | 101.51 | 101.85 | 101.46 | 101.62 | 4155916.0 |
| 2024-09-11 | AGGH | ETF | 21.89 | 21.89 | 21.78 | 21.82 | 69595.0 |
| 2024-09-11 | AGGS | ETF | 42.7199 | 42.7199 | 42.655 | 42.655 | 802.0 |
| 2024-09-11 | AGGY | ETF | 44.9 | 45.035 | 44.9 | 44.98 | 88270.0 |
| 2024-09-11 | AGIX | ETF | 23.58 | 24.26 | 23.58 | 24.2548 | 1030.0 |
| 2024-09-11 | AGMI | ETF | 24.5 | 25.0603 | 24.5 | 25.0603 | 110.0 |
| 2024-09-11 | AGNG | ETF | 32.26 | 32.74 | 32.26 | 32.73 | 4924.0 |
| 2024-09-11 | AGOX | ETF | 27.2026 | 28.49 | 27.09 | 28.08 | 14118.0 |
| 2024-09-11 | AGQ | ETF | 34.33 | 34.71 | 33.18 | 34.5 | 1382623.0 |
> showing 50 of 3,470 rows — these rows as CSV