PREVIEW / etf_daily / 2024-11-04
file: by_date/etf_daily/2024/2024-11-04.parquet size: 143 KB rows: 3,765
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-11-04 | SPY | ETF | 571.18 | 572.5 | 567.89 | 569.81 | 36827668.0 |
| 2024-11-04 | QQQ | ETF | 486.82 | 489.38 | 484.2545 | 486.01 | 23291580.0 |
| 2024-11-04 | IWM | ETF | 218.5 | 221.74 | 217.8401 | 220.09 | 20239164.0 |
| 2024-11-04 | DIA | ETF | 419.84 | 420.3 | 416.44 | 418.05 | 3037631.0 |
| 2024-11-04 | GLD | ETF | 253.32 | 253.58 | 252.27 | 252.83 | 4552407.0 |
| 2024-11-04 | TLT | ETF | 92.28 | 92.57 | 91.63 | 92.25 | 48448650.0 |
| 2024-11-04 | AAA | ETF | 25.0596 | 25.06 | 25.0433 | 25.06 | 6677.0 |
| 2024-11-04 | AAAU | ETF | 27.13 | 27.145 | 27.014 | 27.07 | 1358789.0 |
| 2024-11-04 | AADR | ETF | 65.17 | 65.17 | 64.16 | 64.76 | 961.0 |
| 2024-11-04 | AAPB | ETF | 26.72 | 27.0633 | 26.38 | 26.93 | 84625.0 |
| 2024-11-04 | AAPD | ETF | 17.38 | 17.48 | 17.2514 | 17.31 | 240880.0 |
| 2024-11-04 | AAPR | ETF | 26.07 | 26.104 | 26.06 | 26.104 | 18809.0 |
| 2024-11-04 | AAPU | ETF | 33.75 | 34.31 | 33.39 | 34.12 | 292525.0 |
| 2024-11-04 | AAPX | ETF | 30.66 | 31.2432 | 30.56 | 30.951 | 17940.0 |
| 2024-11-04 | AAPY | ETF | 26.58 | 26.61 | 26.5405 | 26.5405 | 4147.0 |
| 2024-11-04 | AAXJ | ETF | 76.98 | 77.16 | 76.56 | 76.56 | 1240090.0 |
| 2024-11-04 | ABCS | ETF | 28.44 | 28.44 | 28.27 | 28.29 | 2034.0 |
| 2024-11-04 | ABEQ | ETF | 32.485 | 32.485 | 32.3 | 32.3901 | 3698.0 |
| 2024-11-04 | ABNY | ETF | 82.55 | 83.3 | 82.4 | 82.95 | 2334.0 |
| 2024-11-04 | ACES | ETF | 28.08 | 29.05 | 28.08 | 28.79 | 14942.0 |
| 2024-11-04 | ACIO | ETF | 39.62 | 39.68 | 39.4698 | 39.55 | 173662.0 |
| 2024-11-04 | ACSI | ETF | 57.6616 | 57.6616 | 57.6616 | 57.6616 | 17.0 |
| 2024-11-04 | ACT | ETF | 32.2 | 32.64 | 32.2 | 32.42 | 763475.0 |
| 2024-11-04 | ACTV | ETF | 32.2 | 32.2 | 32.02 | 32.03 | 3740.0 |
| 2024-11-04 | ACVF | ETF | 43.44 | 43.6 | 43.38 | 43.4055 | 8023.0 |
| 2024-11-04 | ACWI | ETF | 117.81 | 118.09 | 117.195 | 117.48 | 1935730.0 |
| 2024-11-04 | ACWV | ETF | 112.36 | 112.52 | 111.9539 | 112.19 | 84292.0 |
| 2024-11-04 | ACWX | ETF | 55.07 | 55.18 | 54.78 | 54.83 | 575003.0 |
| 2024-11-04 | ADFI | ETF | 8.53 | 8.56 | 8.52 | 8.55 | 19874.0 |
| 2024-11-04 | ADIV | ETF | 15.86 | 15.875 | 15.86 | 15.875 | 1078.0 |
| 2024-11-04 | ADME | ETF | 45.8 | 46.03 | 45.66 | 45.72 | 32309.0 |
| 2024-11-04 | ADPV | ETF | 32.28 | 32.28 | 32.1242 | 32.1242 | 2145.0 |
| 2024-11-04 | ADVE | ETF | 34.6452 | 34.6452 | 34.6452 | 34.6452 | 6.0 |
| 2024-11-04 | AESR | ETF | 16.97 | 16.98 | 16.911 | 16.92 | 22788.0 |
| 2024-11-04 | AETH | ETF | 31.25 | 31.25 | 30.71 | 30.8997 | 8444.0 |
| 2024-11-04 | AFIF | ETF | 9.165 | 9.17 | 9.147 | 9.165 | 13820.0 |
| 2024-11-04 | AFK | ETF | 16.72 | 16.72 | 16.38 | 16.47 | 7280.0 |
| 2024-11-04 | AFLG | ETF | 33.78 | 33.92 | 33.711 | 33.7839 | 18760.0 |
| 2024-11-04 | AFMC | ETF | 32.19 | 32.2 | 31.99 | 32.0 | 6586.0 |
| 2024-11-04 | AFSM | ETF | 30.57 | 30.58 | 30.33 | 30.34 | 9100.0 |
| 2024-11-04 | AGG | ETF | 98.25 | 98.375 | 97.9538 | 98.13 | 6441872.0 |
| 2024-11-04 | AGGH | ETF | 20.68 | 20.75 | 20.6001 | 20.67 | 73502.0 |
| 2024-11-04 | AGGS | ETF | 41.25 | 41.25 | 41.15 | 41.2078 | 400.0 |
| 2024-11-04 | AGGY | ETF | 43.57 | 43.6396 | 43.46 | 43.5395 | 58450.0 |
| 2024-11-04 | AGIH | ETF | 24.53 | 24.53 | 24.53 | 24.53 | 1.0 |
| 2024-11-04 | AGIX | ETF | 25.9 | 26.03 | 25.85 | 25.89 | 8457.0 |
| 2024-11-04 | AGMI | ETF | 30.22 | 30.22 | 30.22 | 30.22 | 108.0 |
| 2024-11-04 | AGNG | ETF | 32.22 | 32.33 | 32.15 | 32.26 | 1371.0 |
| 2024-11-04 | AGOX | ETF | 28.04 | 28.04 | 27.7457 | 27.79 | 49849.0 |
| 2024-11-04 | AGQ | ETF | 43.83 | 44.04 | 42.76 | 43.29 | 1040253.0 |
> showing 50 of 3,765 rows — these rows as CSV