PREVIEW / etf_daily / 2024-08-19
file: by_date/etf_daily/2024/2024-08-19.parquet size: 132 KB rows: 3,462
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-08-19 | SPY | ETF | 554.73 | 559.61 | 553.86 | 559.61 | 39878232.0 |
| 2024-08-19 | QQQ | ETF | 475.17 | 481.31 | 473.37 | 481.27 | 23737674.0 |
| 2024-08-19 | IWM | ETF | 212.96 | 215.21 | 212.82 | 215.2 | 16436623.0 |
| 2024-08-19 | DIA | ETF | 407.36 | 409.32 | 407.26 | 409.11 | 1991832.0 |
| 2024-08-19 | GLD | ETF | 230.15 | 231.78 | 229.74 | 231.61 | 5060485.0 |
| 2024-08-19 | TLT | ETF | 97.42 | 98.155 | 97.405 | 97.89 | 24734263.0 |
| 2024-08-19 | AAA | ETF | 25.04 | 25.145 | 25.0272 | 25.13 | 15884.0 |
| 2024-08-19 | AAAU | ETF | 24.64 | 24.805 | 24.59 | 24.79 | 1466645.0 |
| 2024-08-19 | AADR | ETF | 62.6 | 62.73 | 62.3701 | 62.73 | 916.0 |
| 2024-08-19 | AAPB | ETF | 28.5 | 28.59 | 27.92 | 28.59 | 132241.0 |
| 2024-08-19 | AAPD | ETF | 17.04 | 17.23 | 17.02 | 17.03 | 244851.0 |
| 2024-08-19 | AAPR | ETF | 25.69 | 25.7662 | 25.69 | 25.7662 | 1385.0 |
| 2024-08-19 | AAPU | ETF | 36.505 | 36.64 | 35.71 | 36.64 | 1042506.0 |
| 2024-08-19 | AAPX | ETF | 32.8214 | 33.19 | 32.4212 | 33.14 | 15837.0 |
| 2024-08-19 | AAPY | ETF | 27.41 | 27.5094 | 27.2901 | 27.5094 | 1928.0 |
| 2024-08-19 | AAXJ | ETF | 73.2 | 73.705 | 73.15 | 73.62 | 142680.0 |
| 2024-08-19 | ABCS | ETF | 27.32 | 27.4359 | 27.32 | 27.4359 | 1405.0 |
| 2024-08-19 | ABEQ | ETF | 31.8792 | 31.9 | 31.81 | 31.8696 | 9795.0 |
| 2024-08-19 | ABNY | ETF | 80.35 | 81.35 | 80.0 | 81.35 | 150389.0 |
| 2024-08-19 | ACES | ETF | 28.28 | 28.78 | 28.1916 | 28.71 | 55083.0 |
| 2024-08-19 | ACIO | ETF | 38.77 | 39.05 | 38.7688 | 39.02 | 146216.0 |
| 2024-08-19 | ACSI | ETF | 56.14 | 56.3659 | 56.14 | 56.3659 | 1086.0 |
| 2024-08-19 | ACT | ETF | 34.07 | 34.47 | 34.07 | 34.41 | 173123.0 |
| 2024-08-19 | ACTV | ETF | 32.2 | 32.53 | 32.2 | 32.53 | 7567.0 |
| 2024-08-19 | ACVF | ETF | 42.24 | 42.62 | 42.1501 | 42.62 | 9285.0 |
| 2024-08-19 | ACWI | ETF | 115.205 | 115.955 | 115.04 | 115.95 | 2268793.0 |
| 2024-08-19 | ACWV | ETF | 110.77 | 111.4 | 110.77 | 111.39 | 127882.0 |
| 2024-08-19 | ACWX | ETF | 54.86 | 55.205 | 54.83 | 55.16 | 472621.0 |
| 2024-08-19 | ADFI | ETF | 8.69 | 8.72 | 8.67 | 8.718 | 20132.0 |
| 2024-08-19 | ADIV | ETF | 15.2066 | 15.2066 | 15.2066 | 15.2066 | 8.0 |
| 2024-08-19 | ADME | ETF | 44.86 | 45.2 | 44.86 | 45.2 | 3893.0 |
| 2024-08-19 | ADPV | ETF | 31.1295 | 31.3028 | 31.0895 | 31.3028 | 505.0 |
| 2024-08-19 | AEMB | ETF | 39.5434 | 39.5434 | 39.5434 | 39.5434 | 0.0 |
| 2024-08-19 | AESR | ETF | 16.53 | 16.6689 | 16.4601 | 16.6689 | 20856.0 |
| 2024-08-19 | AETH | ETF | 33.77 | 33.87 | 33.31 | 33.87 | 3683.0 |
| 2024-08-19 | AFIF | ETF | 9.14 | 9.17 | 9.14 | 9.165 | 14196.0 |
| 2024-08-19 | AFK | ETF | 16.29 | 16.4399 | 16.15 | 16.4212 | 18403.0 |
| 2024-08-19 | AFLG | ETF | 32.56 | 32.76 | 32.45 | 32.76 | 13569.0 |
| 2024-08-19 | AFMC | ETF | 30.61 | 30.75 | 30.61 | 30.7475 | 1487.0 |
| 2024-08-19 | AFSM | ETF | 29.54 | 29.7571 | 29.54 | 29.7571 | 530.0 |
| 2024-08-19 | AFTY | ETF | 14.2599 | 14.2599 | 14.235 | 14.235 | 124.0 |
| 2024-08-19 | AGG | ETF | 100.07 | 100.3374 | 100.04 | 100.23 | 4683553.0 |
| 2024-08-19 | AGGH | ETF | 21.62 | 21.62 | 21.5025 | 21.61 | 37074.0 |
| 2024-08-19 | AGGY | ETF | 44.3 | 44.44 | 44.3 | 44.38 | 46086.0 |
| 2024-08-19 | AGIX | ETF | 24.86 | 25.1338 | 24.71 | 25.1338 | 1829.0 |
| 2024-08-19 | AGMI | ETF | 26.181 | 27.0424 | 26.181 | 27.0424 | 161.0 |
| 2024-08-19 | AGNG | ETF | 32.2 | 32.3023 | 32.2 | 32.3023 | 2213.0 |
| 2024-08-19 | AGOX | ETF | 29.35 | 29.6552 | 28.91 | 29.57 | 36514.0 |
| 2024-08-19 | AGQ | ETF | 35.84 | 36.99 | 35.6294 | 36.84 | 1623023.0 |
| 2024-08-19 | AGQI | ETF | 14.425 | 14.45 | 14.425 | 14.435 | 2958.0 |
> showing 50 of 3,462 rows — these rows as CSV