PREVIEW / etf_daily / 2024-07-09
file: by_date/etf_daily/2024/2024-07-09.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-09 | SPY | ETF | 556.26 | 557.18 | 555.52 | 555.82 | 27251609.0 |
| 2024-07-09 | QQQ | ETF | 498.87 | 500.0 | 496.24 | 497.77 | 25701253.0 |
| 2024-07-09 | IWM | ETF | 201.92 | 202.52 | 200.53 | 201.4 | 17571252.0 |
| 2024-07-09 | DIA | ETF | 393.22 | 395.04 | 391.47 | 392.94 | 3821629.0 |
| 2024-07-09 | GLD | ETF | 218.57 | 219.29 | 217.265 | 218.56 | 3797135.0 |
| 2024-07-09 | TLT | ETF | 92.47 | 92.675 | 91.87 | 92.35 | 30304003.0 |
| 2024-07-09 | AAA | ETF | 25.03 | 25.04 | 25.01 | 25.0302 | 2741.0 |
| 2024-07-09 | AAAU | ETF | 23.38 | 23.46 | 23.249 | 23.385 | 3150706.0 |
| 2024-07-09 | AADR | ETF | 62.86 | 62.86 | 62.86 | 62.86 | 168.0 |
| 2024-07-09 | AAPB | ETF | 29.61 | 29.92 | 29.2049 | 29.79 | 207501.0 |
| 2024-07-09 | AAPD | ETF | 16.86 | 16.97 | 16.7588 | 16.81 | 180569.0 |
| 2024-07-09 | AAPR | ETF | 25.4417 | 25.48 | 25.4116 | 25.45 | 56570.0 |
| 2024-07-09 | AAPU | ETF | 38.05 | 38.4399 | 37.46 | 38.22 | 884096.0 |
| 2024-07-09 | AAPX | ETF | 34.49 | 34.85 | 34.05 | 34.67 | 38239.0 |
| 2024-07-09 | AAPY | ETF | 27.4999 | 27.51 | 27.4682 | 27.5063 | 1317.0 |
| 2024-07-09 | AAXJ | ETF | 73.85 | 74.08 | 73.75 | 74.01 | 151644.0 |
| 2024-07-09 | ABCS | ETF | 25.74 | 25.79 | 25.7157 | 25.7157 | 1489.0 |
| 2024-07-09 | ABEQ | ETF | 30.1068 | 30.2399 | 30.1019 | 30.1019 | 6651.0 |
| 2024-07-09 | ABNY | ETF | 105.1495 | 105.65 | 103.849 | 103.849 | 907.0 |
| 2024-07-09 | ACES | ETF | 29.32 | 29.58 | 29.09 | 29.28 | 64252.0 |
| 2024-07-09 | ACIO | ETF | 38.435 | 38.45 | 38.34 | 38.37 | 53934.0 |
| 2024-07-09 | ACSI | ETF | 56.1614 | 56.1614 | 56.1614 | 56.1614 | 98.0 |
| 2024-07-09 | ACT | ETF | 30.24 | 30.43 | 29.99 | 30.22 | 175326.0 |
| 2024-07-09 | ACTV | ETF | 31.89 | 31.9 | 31.5599 | 31.5599 | 4643.0 |
| 2024-07-09 | ACVF | ETF | 41.79 | 41.8597 | 41.7873 | 41.7873 | 5991.0 |
| 2024-07-09 | ACWI | ETF | 114.8 | 114.87 | 114.51 | 114.63 | 2000566.0 |
| 2024-07-09 | ACWV | ETF | 105.19 | 105.3999 | 104.97 | 105.16 | 145106.0 |
| 2024-07-09 | ACWX | ETF | 54.15 | 54.165 | 53.915 | 54.07 | 345955.0 |
| 2024-07-09 | ADFI | ETF | 8.5 | 8.505 | 8.5 | 8.5 | 2106.0 |
| 2024-07-09 | ADIV | ETF | 14.78 | 14.78 | 14.77 | 14.775 | 865.0 |
| 2024-07-09 | ADME | ETF | 44.75 | 44.76 | 44.6444 | 44.654 | 7476.0 |
| 2024-07-09 | ADPV | ETF | 30.68 | 30.86 | 30.5968 | 30.5968 | 2309.0 |
| 2024-07-09 | AEMB | ETF | 38.405 | 38.405 | 38.405 | 38.405 | 566.0 |
| 2024-07-09 | AESR | ETF | 16.785 | 16.785 | 16.73 | 16.7466 | 5027.0 |
| 2024-07-09 | AETH | ETF | 40.02 | 40.489 | 39.8401 | 40.0632 | 3847.0 |
| 2024-07-09 | AFIF | ETF | 9.11 | 9.16 | 9.11 | 9.16 | 27276.0 |
| 2024-07-09 | AFK | ETF | 16.02 | 16.47 | 16.02 | 16.21 | 39151.0 |
| 2024-07-09 | AFLG | ETF | 32.2 | 32.23 | 32.0 | 32.0033 | 8060.0 |
| 2024-07-09 | AFMC | ETF | 28.9408 | 28.96 | 28.8022 | 28.8022 | 1721.0 |
| 2024-07-09 | AFSM | ETF | 27.935 | 27.935 | 27.9023 | 27.9023 | 983.0 |
| 2024-07-09 | AFTY | ETF | 13.93 | 14.07 | 13.93 | 14.0351 | 2800.0 |
| 2024-07-09 | AGG | ETF | 97.51 | 97.605 | 97.34 | 97.52 | 4969302.0 |
| 2024-07-09 | AGGH | ETF | 21.01 | 21.01 | 20.9 | 20.96 | 72118.0 |
| 2024-07-09 | AGGY | ETF | 43.29 | 43.3 | 43.19 | 43.275 | 113983.0 |
| 2024-07-09 | AGMI | ETF | 27.57 | 27.57 | 27.2203 | 27.2203 | 1608.0 |
| 2024-07-09 | AGNG | ETF | 30.35 | 30.43 | 30.35 | 30.43 | 903.0 |
| 2024-07-09 | AGOX | ETF | 28.76 | 28.79 | 28.41 | 28.6317 | 45133.0 |
| 2024-07-09 | AGQ | ETF | 41.88 | 42.2 | 40.53 | 41.3 | 838335.0 |
| 2024-07-09 | AGQI | ETF | 14.51 | 14.52 | 14.45 | 14.47 | 17778.0 |
| 2024-07-09 | AGZ | ETF | 107.96 | 107.9875 | 107.87 | 107.941 | 10693.0 |
> showing 50 of 3,421 rows — these rows as CSV