PREVIEW / etf_daily / 2024-07-25
file: by_date/etf_daily/2024/2024-07-25.parquet size: 132 KB rows: 3,439
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-25 | SPY | ETF | 541.35 | 547.455 | 537.45 | 538.41 | 61018204.0 |
| 2024-07-25 | QQQ | ETF | 463.72 | 467.94 | 455.63 | 458.27 | 59256759.0 |
| 2024-07-25 | IWM | ETF | 218.45 | 224.02 | 218.2 | 220.57 | 44913777.0 |
| 2024-07-25 | DIA | ETF | 398.63 | 404.39 | 398.3713 | 399.49 | 4159971.0 |
| 2024-07-25 | GLD | ETF | 219.02 | 219.2607 | 217.52 | 218.33 | 9753858.0 |
| 2024-07-25 | TLT | ETF | 92.025 | 92.86 | 91.96 | 92.27 | 44946321.0 |
| 2024-07-25 | AAA | ETF | 25.1 | 25.15 | 25.1 | 25.13 | 12750.0 |
| 2024-07-25 | AAAU | ETF | 23.44 | 23.46 | 23.27 | 23.365 | 2869821.0 |
| 2024-07-25 | AADR | ETF | 60.71 | 60.71 | 60.71 | 60.71 | 28.0 |
| 2024-07-25 | AAPB | ETF | 27.09 | 27.5599 | 26.0204 | 26.72 | 105016.0 |
| 2024-07-25 | AAPD | ETF | 17.55 | 17.9001 | 17.405 | 17.67 | 409736.0 |
| 2024-07-25 | AAPR | ETF | 25.2439 | 25.41 | 25.2439 | 25.2779 | 26259.0 |
| 2024-07-25 | AAPU | ETF | 34.72 | 35.349 | 33.38 | 34.3 | 868673.0 |
| 2024-07-25 | AAPX | ETF | 31.39 | 31.999 | 30.311 | 31.08 | 29948.0 |
| 2024-07-25 | AAPY | ETF | 26.55 | 26.7 | 26.4452 | 26.4452 | 2159.0 |
| 2024-07-25 | AAXJ | ETF | 70.34 | 70.96 | 70.16 | 70.43 | 430197.0 |
| 2024-07-25 | ABCS | ETF | 26.79 | 27.35 | 26.79 | 27.0308 | 1500.0 |
| 2024-07-25 | ABEQ | ETF | 31.04 | 31.235 | 30.9601 | 30.9769 | 5119.0 |
| 2024-07-25 | ABNY | ETF | 96.1945 | 98.0 | 96.15 | 97.4415 | 990.0 |
| 2024-07-25 | ACES | ETF | 29.62 | 30.423 | 29.61 | 29.8 | 22886.0 |
| 2024-07-25 | ACIO | ETF | 37.788 | 38.0401 | 37.63 | 37.65 | 292190.0 |
| 2024-07-25 | ACSI | ETF | 54.762 | 54.762 | 54.762 | 54.762 | 41.0 |
| 2024-07-25 | ACT | ETF | 33.81 | 34.69 | 33.81 | 34.2 | 221945.0 |
| 2024-07-25 | ACTV | ETF | 32.89 | 33.28 | 32.89 | 32.94 | 17633.0 |
| 2024-07-25 | ACVF | ETF | 41.0 | 41.53 | 41.0 | 41.0 | 6561.0 |
| 2024-07-25 | ACWI | ETF | 111.61 | 113.02 | 111.115 | 111.45 | 2893401.0 |
| 2024-07-25 | ACWV | ETF | 106.85 | 107.6 | 106.53 | 106.87 | 166140.0 |
| 2024-07-25 | ACWX | ETF | 52.85 | 53.39 | 52.73 | 52.98 | 705812.0 |
| 2024-07-25 | ADFI | ETF | 8.55 | 8.55 | 8.54 | 8.545 | 18126.0 |
| 2024-07-25 | ADIV | ETF | 14.27 | 14.305 | 14.27 | 14.305 | 453.0 |
| 2024-07-25 | ADME | ETF | 43.7 | 44.1219 | 43.52 | 43.54 | 20744.0 |
| 2024-07-25 | ADPV | ETF | 30.51 | 30.975 | 30.43 | 30.6184 | 7697.0 |
| 2024-07-25 | AEMB | ETF | 38.5086 | 38.5086 | 38.5086 | 38.5086 | 3.0 |
| 2024-07-25 | AESR | ETF | 16.05 | 16.05 | 15.8714 | 15.8714 | 17408.0 |
| 2024-07-25 | AETH | ETF | 40.98 | 41.24 | 40.44 | 40.72 | 16947.0 |
| 2024-07-25 | AFIF | ETF | 9.135 | 9.15 | 9.135 | 9.15 | 5475.0 |
| 2024-07-25 | AFK | ETF | 15.71 | 15.9999 | 15.5 | 15.76 | 20736.0 |
| 2024-07-25 | AFLG | ETF | 31.47 | 31.914 | 31.47 | 31.56 | 12475.0 |
| 2024-07-25 | AFMC | ETF | 30.91 | 30.91 | 30.6256 | 30.6256 | 1752.0 |
| 2024-07-25 | AFSM | ETF | 30.188 | 30.88 | 30.188 | 30.4169 | 10426.0 |
| 2024-07-25 | AFTY | ETF | 14.07 | 14.0701 | 14.0502 | 14.0502 | 1593.0 |
| 2024-07-25 | AGG | ETF | 97.84 | 98.135 | 97.82 | 97.97 | 12591604.0 |
| 2024-07-25 | AGGH | ETF | 21.07 | 21.09 | 20.98 | 21.05 | 57116.0 |
| 2024-07-25 | AGGY | ETF | 43.35 | 43.47 | 43.35 | 43.38 | 42611.0 |
| 2024-07-25 | AGIX | ETF | 24.0 | 24.19 | 23.78 | 23.905 | 8942.0 |
| 2024-07-25 | AGMI | ETF | 26.55 | 26.68 | 26.5231 | 26.5231 | 4835.0 |
| 2024-07-25 | AGNG | ETF | 31.17 | 31.2836 | 30.86 | 30.97 | 6552.0 |
| 2024-07-25 | AGOX | ETF | 27.605 | 27.86 | 26.0 | 27.479 | 25366.0 |
| 2024-07-25 | AGQ | ETF | 32.86 | 33.7 | 32.68 | 33.35 | 2574558.0 |
| 2024-07-25 | AGQI | ETF | 14.21 | 14.295 | 14.14 | 14.16 | 11469.0 |
> showing 50 of 3,439 rows — these rows as CSV