PREVIEW / etf_daily / 2024-07-23
file: by_date/etf_daily/2024/2024-07-23.parquet size: 132 KB rows: 3,421
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-07-23 | SPY | ETF | 554.54 | 556.735 | 553.275 | 553.78 | 34305474.0 |
| 2024-07-23 | QQQ | ETF | 481.41 | 484.43 | 480.14 | 480.62 | 23282454.0 |
| 2024-07-23 | IWM | ETF | 219.21 | 223.75 | 219.04 | 222.63 | 44674642.0 |
| 2024-07-23 | DIA | ETF | 404.29 | 405.29 | 403.22 | 403.49 | 1693478.0 |
| 2024-07-23 | GLD | ETF | 222.34 | 222.75 | 221.86 | 222.58 | 4378874.0 |
| 2024-07-23 | TLT | ETF | 92.81 | 93.03 | 92.49 | 92.52 | 23494019.0 |
| 2024-07-23 | AAA | ETF | 25.1 | 25.15 | 25.1 | 25.135 | 1955.0 |
| 2024-07-23 | AAAU | ETF | 23.79 | 23.8399 | 23.74 | 23.825 | 858347.0 |
| 2024-07-23 | AADR | ETF | 63.09 | 63.09 | 63.09 | 63.09 | 53.0 |
| 2024-07-23 | AAPB | ETF | 28.46 | 29.1299 | 28.071 | 28.66 | 113813.0 |
| 2024-07-23 | AAPD | ETF | 17.13 | 17.26 | 16.9496 | 17.09 | 147274.0 |
| 2024-07-23 | AAPR | ETF | 25.54 | 25.54 | 25.46 | 25.4755 | 5405.0 |
| 2024-07-23 | AAPU | ETF | 36.57 | 37.38 | 36.02 | 36.74 | 486309.0 |
| 2024-07-23 | AAPX | ETF | 33.17 | 33.87 | 32.68 | 33.3 | 24731.0 |
| 2024-07-23 | AAXJ | ETF | 71.98 | 71.98 | 71.665 | 71.78 | 437876.0 |
| 2024-07-23 | ABCS | ETF | 27.1498 | 27.2077 | 27.09 | 27.1228 | 1600.0 |
| 2024-07-23 | ABEQ | ETF | 30.87 | 31.01 | 30.84 | 30.9401 | 15976.0 |
| 2024-07-23 | ABNY | ETF | 103.342 | 103.342 | 102.8525 | 102.9505 | 321.0 |
| 2024-07-23 | ACES | ETF | 30.33 | 30.63 | 30.07 | 30.45 | 213571.0 |
| 2024-07-23 | ACIO | ETF | 38.43 | 38.4905 | 38.34 | 38.34 | 54719.0 |
| 2024-07-23 | ACSI | ETF | 55.7927 | 55.7927 | 55.7927 | 55.7927 | 19.0 |
| 2024-07-23 | ACT | ETF | 33.54 | 34.035 | 33.415 | 33.77 | 164431.0 |
| 2024-07-23 | ACTV | ETF | 33.45 | 33.625 | 33.44 | 33.5303 | 9965.0 |
| 2024-07-23 | ACVF | ETF | 41.91 | 42.0997 | 41.8679 | 41.8679 | 14759.0 |
| 2024-07-23 | ACWI | ETF | 114.49 | 114.76 | 114.2 | 114.27 | 1351700.0 |
| 2024-07-23 | ACWV | ETF | 107.32 | 107.39 | 106.96 | 106.98 | 83767.0 |
| 2024-07-23 | ACWX | ETF | 54.1 | 54.1 | 53.8916 | 53.95 | 1175247.0 |
| 2024-07-23 | ADFI | ETF | 8.5567 | 8.57 | 8.541 | 8.541 | 82525.0 |
| 2024-07-23 | ADIV | ETF | 14.5201 | 14.5201 | 14.5201 | 14.5201 | 36.0 |
| 2024-07-23 | ADME | ETF | 44.69 | 44.708 | 44.4745 | 44.4745 | 5957.0 |
| 2024-07-23 | ADPV | ETF | 31.31 | 31.46 | 31.2685 | 31.2685 | 16439.0 |
| 2024-07-23 | ADVE | ETF | 33.2523 | 33.2523 | 33.252 | 33.252 | 300.0 |
| 2024-07-23 | AEMB | ETF | 38.87 | 38.87 | 38.7355 | 38.7355 | 506.0 |
| 2024-07-23 | AESR | ETF | 16.46 | 16.53 | 16.4321 | 16.4321 | 94423.0 |
| 2024-07-23 | AETH | ETF | 45.74 | 45.74 | 44.35 | 44.98 | 32072.0 |
| 2024-07-23 | AFIF | ETF | 9.14 | 9.14 | 9.12 | 9.13 | 18275.0 |
| 2024-07-23 | AFK | ETF | 15.9 | 16.23 | 15.8001 | 16.1 | 112238.0 |
| 2024-07-23 | AFLG | ETF | 32.28 | 32.34 | 32.14 | 32.1602 | 46229.0 |
| 2024-07-23 | AFMC | ETF | 30.48 | 30.8567 | 30.48 | 30.8567 | 1133.0 |
| 2024-07-23 | AFSM | ETF | 30.44 | 31.0 | 30.43 | 30.7802 | 13521.0 |
| 2024-07-23 | AFTY | ETF | 14.0965 | 14.0965 | 14.0965 | 14.0965 | 136.0 |
| 2024-07-23 | AGG | ETF | 98.095 | 98.18 | 97.98 | 98.0 | 7204303.0 |
| 2024-07-23 | AGGH | ETF | 20.96 | 21.18 | 20.9 | 21.04 | 54948.0 |
| 2024-07-23 | AGGY | ETF | 43.46 | 43.51 | 43.44 | 43.4453 | 75986.0 |
| 2024-07-23 | AGIX | ETF | 25.18 | 25.35 | 25.18 | 25.2669 | 3051.0 |
| 2024-07-23 | AGMI | ETF | 27.69 | 27.69 | 27.5699 | 27.5699 | 105.0 |
| 2024-07-23 | AGNG | ETF | 31.09 | 31.2199 | 31.03 | 31.03 | 2981.0 |
| 2024-07-23 | AGOX | ETF | 28.23 | 28.35 | 28.08 | 28.2004 | 44553.0 |
| 2024-07-23 | AGQ | ETF | 36.45 | 36.93 | 36.18 | 36.9 | 644976.0 |
| 2024-07-23 | AGQI | ETF | 14.4 | 14.41 | 14.3916 | 14.3916 | 516.0 |
> showing 50 of 3,421 rows — these rows as CSV