PREVIEW / etf_daily / 2024-07-31
file: by_date/etf_daily/2024/2024-07-31.parquet size: 134 KB rows: 3,473
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-31 | SPY | ETF | 548.98 | 553.5 | 547.5799 | 550.81 | 65275737.0 |
| 2024-07-31 | QQQ | ETF | 467.87 | 472.79 | 466.41 | 471.07 | 44552134.0 |
| 2024-07-31 | IWM | ETF | 223.71 | 228.63 | 221.98 | 223.86 | 52273583.0 |
| 2024-07-31 | DIA | ETF | 407.46 | 412.01 | 406.49 | 408.49 | 5630189.0 |
| 2024-07-31 | GLD | ETF | 223.73 | 226.6 | 223.64 | 226.55 | 7213587.0 |
| 2024-07-31 | TLT | ETF | 94.53 | 94.84 | 94.24 | 94.81 | 47339699.0 |
| 2024-07-31 | AAA | ETF | 25.0374 | 25.045 | 25.02 | 25.045 | 2731.0 |
| 2024-07-31 | AAAU | ETF | 23.94 | 24.25 | 23.935 | 24.24 | 2974521.0 |
| 2024-07-31 | AADR | ETF | 62.0416 | 62.27 | 62.0416 | 62.17 | 1180.0 |
| 2024-07-31 | AAPB | ETF | 27.71 | 28.272 | 27.6 | 27.81 | 79630.0 |
| 2024-07-31 | AAPD | ETF | 17.39 | 17.42 | 17.21 | 17.34 | 256652.0 |
| 2024-07-31 | AAPR | ETF | 25.464 | 25.49 | 25.4506 | 25.474 | 1534.0 |
| 2024-07-31 | AAPU | ETF | 35.53 | 36.2399 | 35.32 | 35.65 | 665141.0 |
| 2024-07-31 | AAPX | ETF | 32.18 | 32.8 | 32.14 | 32.35 | 28579.0 |
| 2024-07-31 | AAPY | ETF | 26.8254 | 26.9699 | 26.8254 | 26.8939 | 544.0 |
| 2024-07-31 | AAXJ | ETF | 72.25 | 72.525 | 72.07 | 72.27 | 367412.0 |
| 2024-07-31 | ABCS | ETF | 27.691 | 27.975 | 27.69 | 27.7384 | 2200.0 |
| 2024-07-31 | ABEQ | ETF | 31.4 | 31.74 | 31.4 | 31.5989 | 10343.0 |
| 2024-07-31 | ABNY | ETF | 98.225 | 98.225 | 97.609 | 97.609 | 220.0 |
| 2024-07-31 | ACES | ETF | 29.85 | 30.72 | 29.85 | 30.06 | 37266.0 |
| 2024-07-31 | ACIO | ETF | 38.1 | 38.3091 | 38.02 | 38.1492 | 62215.0 |
| 2024-07-31 | ACSI | ETF | 55.7614 | 55.7614 | 55.7614 | 55.7614 | 21.0 |
| 2024-07-31 | ACT | ETF | 34.31 | 34.58 | 33.98 | 34.03 | 249448.0 |
| 2024-07-31 | ACTV | ETF | 34.65 | 34.9 | 34.25 | 34.47 | 5051.0 |
| 2024-07-31 | ACVF | ETF | 41.66 | 41.9199 | 41.65 | 41.8311 | 5972.0 |
| 2024-07-31 | ACWI | ETF | 113.79 | 114.69 | 113.63 | 114.13 | 2361519.0 |
| 2024-07-31 | ACWV | ETF | 108.97 | 108.99 | 108.46 | 108.63 | 174126.0 |
| 2024-07-31 | ACWX | ETF | 54.25 | 54.53 | 54.13 | 54.28 | 595859.0 |
| 2024-07-31 | ADFI | ETF | 8.52 | 8.7748 | 8.52 | 8.63 | 10870.0 |
| 2024-07-31 | ADIV | ETF | 14.5301 | 14.58 | 14.5301 | 14.58 | 179.0 |
| 2024-07-31 | ADME | ETF | 44.2397 | 44.4 | 44.104 | 44.27 | 9680.0 |
| 2024-07-31 | ADPV | ETF | 31.28 | 31.51 | 31.09 | 31.1406 | 9827.0 |
| 2024-07-31 | ADVE | ETF | 33.5803 | 33.5803 | 33.5562 | 33.5562 | 160.0 |
| 2024-07-31 | AEMB | ETF | 39.04 | 39.09 | 38.9527 | 38.9527 | 2643.0 |
| 2024-07-31 | AESR | ETF | 16.18 | 16.32 | 16.17 | 16.2825 | 35751.0 |
| 2024-07-31 | AETH | ETF | 43.3 | 43.5037 | 42.4625 | 42.4625 | 8231.0 |
| 2024-07-31 | AFIF | ETF | 9.159 | 9.16 | 9.1491 | 9.155 | 21508.0 |
| 2024-07-31 | AFK | ETF | 16.12 | 16.29 | 16.01 | 16.27 | 24362.0 |
| 2024-07-31 | AFLG | ETF | 32.33 | 32.34 | 32.201 | 32.26 | 5214.0 |
| 2024-07-31 | AFMC | ETF | 31.57 | 31.74 | 30.97 | 31.47 | 625660.0 |
| 2024-07-31 | AFSM | ETF | 31.09 | 31.28 | 30.95 | 31.016 | 11834.0 |
| 2024-07-31 | AFTY | ETF | 14.06 | 14.08 | 14.06 | 14.08 | 388.0 |
| 2024-07-31 | AGG | ETF | 98.81 | 99.12 | 98.6493 | 99.11 | 11752918.0 |
| 2024-07-31 | AGGH | ETF | 21.06 | 21.21 | 21.06 | 21.19 | 49047.0 |
| 2024-07-31 | AGGY | ETF | 43.59 | 43.69 | 43.545 | 43.68 | 85132.0 |
| 2024-07-31 | AGIX | ETF | 24.19 | 24.3898 | 24.19 | 24.3898 | 3445.0 |
| 2024-07-31 | AGMI | ETF | 28.07 | 28.14 | 27.9599 | 28.0798 | 1700.0 |
| 2024-07-31 | AGNG | ETF | 31.135 | 31.27 | 31.0994 | 31.0994 | 868.0 |
| 2024-07-31 | AGOX | ETF | 28.2 | 28.2406 | 27.975 | 28.1268 | 28500.0 |
| 2024-07-31 | AGQ | ETF | 35.53 | 36.2941 | 35.13 | 36.01 | 1435661.0 |
> showing 50 of 3,473 rows — these rows as CSV