PREVIEW / etf_daily / 2024-07-26
file: by_date/etf_daily/2024/2024-07-26.parquet size: 132 KB rows: 3,428
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-26 | SPY | ETF | 542.28 | 547.19 | 541.49 | 544.44 | 54500872.0 |
| 2024-07-26 | QQQ | ETF | 462.65 | 465.93 | 459.77 | 462.97 | 39992132.0 |
| 2024-07-26 | IWM | ETF | 223.9 | 225.39 | 221.7 | 224.22 | 40611007.0 |
| 2024-07-26 | DIA | ETF | 401.81 | 407.617 | 401.71 | 405.97 | 2808364.0 |
| 2024-07-26 | GLD | ETF | 219.96 | 221.04 | 219.7 | 220.63 | 6222769.0 |
| 2024-07-26 | TLT | ETF | 92.95 | 93.15 | 92.71 | 92.99 | 35649462.0 |
| 2024-07-26 | AAA | ETF | 25.14 | 25.15 | 25.09 | 25.11 | 6684.0 |
| 2024-07-26 | AAAU | ETF | 23.54 | 23.6525 | 23.515 | 23.605 | 2305517.0 |
| 2024-07-26 | AADR | ETF | 61.5303 | 61.5303 | 61.5303 | 61.5303 | 182.0 |
| 2024-07-26 | AAPB | ETF | 27.07 | 27.1999 | 26.48 | 26.84 | 62912.0 |
| 2024-07-26 | AAPD | ETF | 17.57 | 17.8 | 17.5299 | 17.63 | 212209.0 |
| 2024-07-26 | AAPR | ETF | 25.29 | 25.4218 | 25.29 | 25.34 | 12289.0 |
| 2024-07-26 | AAPU | ETF | 34.69 | 34.88 | 33.8 | 34.43 | 685568.0 |
| 2024-07-26 | AAPX | ETF | 31.44 | 31.6296 | 30.6304 | 31.19 | 26162.0 |
| 2024-07-26 | AAPY | ETF | 26.34 | 26.4519 | 26.34 | 26.4519 | 476.0 |
| 2024-07-26 | AAXJ | ETF | 71.07 | 71.4 | 70.91 | 71.23 | 331902.0 |
| 2024-07-26 | ABCS | ETF | 27.3503 | 27.465 | 27.23 | 27.4157 | 5715.0 |
| 2024-07-26 | ABEQ | ETF | 31.26 | 31.2701 | 31.2393 | 31.2393 | 3278.0 |
| 2024-07-26 | ABNY | ETF | 100.6 | 100.6 | 97.565 | 97.565 | 203.0 |
| 2024-07-26 | ACES | ETF | 30.18 | 30.38 | 29.96 | 30.08 | 22933.0 |
| 2024-07-26 | ACIO | ETF | 37.75 | 38.05 | 37.75 | 37.87 | 70377.0 |
| 2024-07-26 | ACSI | ETF | 55.2425 | 55.2425 | 55.2425 | 55.2425 | 13.0 |
| 2024-07-26 | ACT | ETF | 34.39 | 34.7 | 34.02 | 34.55 | 213739.0 |
| 2024-07-26 | ACTV | ETF | 33.44 | 34.0551 | 33.44 | 34.05 | 9737.0 |
| 2024-07-26 | ACVF | ETF | 41.27 | 41.56 | 41.27 | 41.3075 | 6008.0 |
| 2024-07-26 | ACWI | ETF | 112.34 | 113.185 | 112.2 | 112.77 | 1745164.0 |
| 2024-07-26 | ACWV | ETF | 107.21 | 108.04 | 107.17 | 107.87 | 144856.0 |
| 2024-07-26 | ACWX | ETF | 53.42 | 53.69 | 53.37 | 53.62 | 276885.0 |
| 2024-07-26 | ADFI | ETF | 8.5659 | 8.58 | 8.55 | 8.58 | 9903.0 |
| 2024-07-26 | ADIV | ETF | 14.3512 | 14.3512 | 14.3512 | 14.3512 | 9.0 |
| 2024-07-26 | ADME | ETF | 43.71 | 43.9498 | 43.71 | 43.7794 | 7861.0 |
| 2024-07-26 | ADVE | ETF | 32.939 | 33.01 | 32.91 | 32.9835 | 919.0 |
| 2024-07-26 | AEMB | ETF | 38.83 | 38.83 | 38.702 | 38.702 | 103.0 |
| 2024-07-26 | AESR | ETF | 16.07 | 16.13 | 16.0252 | 16.0252 | 9244.0 |
| 2024-07-26 | AETH | ETF | 42.24 | 42.6657 | 41.95 | 42.6657 | 21920.0 |
| 2024-07-26 | AFIF | ETF | 9.14 | 9.15 | 9.1301 | 9.1449 | 5889.0 |
| 2024-07-26 | AFK | ETF | 15.86 | 15.99 | 15.86 | 15.9449 | 7220.0 |
| 2024-07-26 | AFLG | ETF | 31.87 | 32.07 | 31.87 | 31.9388 | 6208.0 |
| 2024-07-26 | AFMC | ETF | 31.1786 | 31.1786 | 31.1786 | 31.1786 | 190.0 |
| 2024-07-26 | AFSM | ETF | 30.84 | 31.13 | 30.68 | 30.98 | 24069.0 |
| 2024-07-26 | AFTY | ETF | 13.97 | 13.9752 | 13.97 | 13.9752 | 955.0 |
| 2024-07-26 | AGG | ETF | 98.29 | 98.3574 | 98.18 | 98.32 | 4174362.0 |
| 2024-07-26 | AGGH | ETF | 21.04 | 21.05 | 20.95 | 21.02 | 61398.0 |
| 2024-07-26 | AGGY | ETF | 43.37 | 43.41 | 43.33 | 43.37 | 59660.0 |
| 2024-07-26 | AGIX | ETF | 24.23 | 24.23 | 23.93 | 24.0483 | 3667.0 |
| 2024-07-26 | AGMI | ETF | 26.91 | 26.91 | 26.7766 | 26.7766 | 351.0 |
| 2024-07-26 | AGNG | ETF | 30.96 | 31.2 | 30.96 | 31.0 | 6111.0 |
| 2024-07-26 | AGOX | ETF | 27.59 | 27.77 | 27.59 | 27.6449 | 50635.0 |
| 2024-07-26 | AGQ | ETF | 33.3 | 33.69 | 32.86 | 33.54 | 1300866.0 |
| 2024-07-26 | AGQI | ETF | 14.249 | 14.3 | 14.24 | 14.2534 | 6921.0 |
> showing 50 of 3,428 rows — these rows as CSV