PREVIEW / etf_daily / 2024-07-19
file: by_date/etf_daily/2024/2024-07-19.parquet size: 130 KB rows: 3,395
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-19 | SPY | ETF | 552.42 | 554.08 | 547.91 | 548.99 | 66178205.0 |
| 2024-07-19 | QQQ | ETF | 479.15 | 481.69 | 473.94 | 475.24 | 42042856.0 |
| 2024-07-19 | IWM | ETF | 217.63 | 218.65 | 215.85 | 216.84 | 37866702.0 |
| 2024-07-19 | DIA | ETF | 405.37 | 406.06 | 401.95 | 402.95 | 4266362.0 |
| 2024-07-19 | GLD | ETF | 221.52 | 222.68 | 221.41 | 221.73 | 8654941.0 |
| 2024-07-19 | TLT | ETF | 93.04 | 93.16 | 92.82 | 92.92 | 32122099.0 |
| 2024-07-19 | AAA | ETF | 25.12 | 25.135 | 25.12 | 25.135 | 370.0 |
| 2024-07-19 | AAAU | ETF | 23.7 | 23.8201 | 23.69 | 23.73 | 2346281.0 |
| 2024-07-19 | AADR | ETF | 61.59 | 61.861 | 61.59 | 61.74 | 2186.0 |
| 2024-07-19 | AAPB | ETF | 28.64 | 29.1174 | 28.24 | 28.51 | 128792.0 |
| 2024-07-19 | AAPD | ETF | 17.1 | 17.2101 | 16.95 | 17.14 | 220098.0 |
| 2024-07-19 | AAPR | ETF | 25.44 | 25.45 | 25.43 | 25.44 | 3615.0 |
| 2024-07-19 | AAPU | ETF | 36.68 | 37.35 | 36.2267 | 36.52 | 578923.0 |
| 2024-07-19 | AAPX | ETF | 33.51 | 33.81 | 33.0 | 33.1068 | 29817.0 |
| 2024-07-19 | AAPY | ETF | 27.25 | 27.25 | 27.22 | 27.2469 | 1035.0 |
| 2024-07-19 | AAXJ | ETF | 72.38 | 72.485 | 71.905 | 71.97 | 1441538.0 |
| 2024-07-19 | ABCS | ETF | 26.81 | 26.95 | 26.8 | 26.8863 | 1763.0 |
| 2024-07-19 | ABEQ | ETF | 31.13 | 31.14 | 30.99 | 30.99 | 5575.0 |
| 2024-07-19 | ABNY | ETF | 103.0 | 103.2 | 101.7 | 101.9605 | 563.0 |
| 2024-07-19 | ACES | ETF | 30.14 | 30.27 | 29.72 | 29.84 | 156665.0 |
| 2024-07-19 | ACIO | ETF | 38.28 | 38.28 | 38.06 | 38.091 | 20193.0 |
| 2024-07-19 | ACSI | ETF | 55.472 | 55.472 | 55.472 | 55.472 | 9.0 |
| 2024-07-19 | ACT | ETF | 33.41 | 33.64 | 33.105 | 33.4 | 149837.0 |
| 2024-07-19 | ACTV | ETF | 33.1 | 33.2111 | 32.99 | 33.2111 | 3618.0 |
| 2024-07-19 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 272.0 |
| 2024-07-19 | ACVF | ETF | 41.84 | 41.84 | 41.4754 | 41.4754 | 3931.0 |
| 2024-07-19 | ACWI | ETF | 114.11 | 114.31 | 113.33 | 113.49 | 3837434.0 |
| 2024-07-19 | ACWV | ETF | 107.6 | 107.74 | 106.95 | 107.07 | 95877.0 |
| 2024-07-19 | ACWX | ETF | 54.02 | 54.05 | 53.74 | 53.8 | 2173468.0 |
| 2024-07-19 | ADFI | ETF | 8.52 | 8.54 | 8.51 | 8.525 | 51501.0 |
| 2024-07-19 | ADIV | ETF | 14.51 | 14.54 | 14.47 | 14.47 | 615.0 |
| 2024-07-19 | ADME | ETF | 44.275 | 44.325 | 44.1888 | 44.1888 | 1287.0 |
| 2024-07-19 | ADPV | ETF | 30.62 | 31.05 | 30.62 | 30.9452 | 12636.0 |
| 2024-07-19 | AEMB | ETF | 38.43 | 38.505 | 38.43 | 38.505 | 842.0 |
| 2024-07-19 | AESR | ETF | 16.39 | 16.39 | 16.2371 | 16.2371 | 52092.0 |
| 2024-07-19 | AETH | ETF | 45.38 | 46.1791 | 45.19 | 46.11 | 10015.0 |
| 2024-07-19 | AFIF | ETF | 9.1119 | 9.14 | 9.1119 | 9.1248 | 6309.0 |
| 2024-07-19 | AFK | ETF | 15.97 | 16.3799 | 15.81 | 16.1 | 28078.0 |
| 2024-07-19 | AFLG | ETF | 32.19 | 32.19 | 31.89 | 31.9331 | 4245.0 |
| 2024-07-19 | AFMC | ETF | 30.39 | 30.39 | 30.3105 | 30.3105 | 1213.0 |
| 2024-07-19 | AFSM | ETF | 29.97 | 29.97 | 29.8 | 29.8463 | 4586.0 |
| 2024-07-19 | AFTY | ETF | 14.46 | 14.46 | 14.4333 | 14.4333 | 215.0 |
| 2024-07-19 | AGG | ETF | 98.04 | 98.0969 | 97.97 | 98.05 | 7728452.0 |
| 2024-07-19 | AGGH | ETF | 21.14 | 21.14 | 21.02 | 21.07 | 60111.0 |
| 2024-07-19 | AGGY | ETF | 43.52 | 43.52 | 43.45 | 43.46 | 45005.0 |
| 2024-07-19 | AGIX | ETF | 24.8 | 24.83 | 24.6251 | 24.6251 | 25358.0 |
| 2024-07-19 | AGMI | ETF | 27.12 | 27.6097 | 27.12 | 27.6097 | 4737.0 |
| 2024-07-19 | AGNG | ETF | 30.81 | 30.837 | 30.81 | 30.837 | 574.0 |
| 2024-07-19 | AGOX | ETF | 27.94 | 28.08 | 27.89 | 27.9703 | 22327.0 |
| 2024-07-19 | AGQ | ETF | 36.13 | 37.08 | 36.03 | 36.89 | 1764682.0 |
> showing 50 of 3,395 rows — these rows as CSV