PREVIEW / etf_daily / 2024-10-31
file: by_date/etf_daily/2024/2024-10-31.parquet size: 143 KB rows: 3,751
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-10-31 | SPY | ETF | 575.56 | 575.63 | 568.44 | 568.64 | 59797090.0 |
| 2024-10-31 | QQQ | ETF | 492.38 | 492.43 | 483.75 | 483.85 | 41245248.0 |
| 2024-10-31 | IWM | ETF | 221.22 | 221.77 | 217.63 | 217.76 | 23717308.0 |
| 2024-10-31 | DIA | ETF | 419.23 | 419.93 | 417.02 | 417.67 | 4059297.0 |
| 2024-10-31 | GLD | ETF | 255.52 | 255.6 | 252.201 | 253.51 | 9924781.0 |
| 2024-10-31 | TLT | ETF | 92.2 | 92.94 | 91.87 | 92.45 | 51989313.0 |
| 2024-10-31 | AAA | ETF | 25.06 | 25.06 | 25.02 | 25.035 | 7673.0 |
| 2024-10-31 | AAAU | ETF | 27.36 | 27.3601 | 27.0099 | 27.155 | 1682809.0 |
| 2024-10-31 | AADR | ETF | 63.67 | 64.02 | 63.67 | 64.02 | 4634.0 |
| 2024-10-31 | AAPB | ETF | 28.74 | 28.87 | 27.79 | 27.8 | 134539.0 |
| 2024-10-31 | AAPD | ETF | 16.74 | 17.04 | 16.72 | 17.04 | 809096.0 |
| 2024-10-31 | AAPR | ETF | 26.1104 | 26.12 | 26.077 | 26.077 | 2426.0 |
| 2024-10-31 | AAPU | ETF | 36.4 | 36.52 | 35.2 | 35.31 | 743307.0 |
| 2024-10-31 | AAPX | ETF | 32.84 | 33.171 | 32.04 | 32.04 | 24789.0 |
| 2024-10-31 | AAPY | ETF | 27.28 | 27.28 | 26.84 | 26.95 | 2550.0 |
| 2024-10-31 | AAXJ | ETF | 76.02 | 76.02 | 75.37 | 75.94 | 198143.0 |
| 2024-10-31 | ABCS | ETF | 28.5 | 28.5 | 28.2069 | 28.2069 | 1306.0 |
| 2024-10-31 | ABEQ | ETF | 32.73 | 32.73 | 32.5897 | 32.5897 | 6201.0 |
| 2024-10-31 | ABNY | ETF | 82.3 | 82.3 | 81.7095 | 81.7095 | 672.0 |
| 2024-10-31 | ACES | ETF | 27.78 | 28.11 | 27.73 | 27.79 | 253436.0 |
| 2024-10-31 | ACIO | ETF | 39.86 | 39.86 | 39.5 | 39.5 | 210633.0 |
| 2024-10-31 | ACSI | ETF | 57.9688 | 57.9688 | 57.9688 | 57.9688 | 85.0 |
| 2024-10-31 | ACT | ETF | 34.86 | 34.86 | 34.08 | 34.09 | 336374.0 |
| 2024-10-31 | ACTV | ETF | 32.48 | 32.48 | 32.16 | 32.16 | 924.0 |
| 2024-10-31 | ACVF | ETF | 43.86 | 43.86 | 43.303 | 43.303 | 2860.0 |
| 2024-10-31 | ACWI | ETF | 118.18 | 118.21 | 116.985 | 117.05 | 2207394.0 |
| 2024-10-31 | ACWV | ETF | 112.04 | 112.31 | 111.7201 | 111.84 | 104866.0 |
| 2024-10-31 | ACWX | ETF | 54.8 | 54.8 | 54.1589 | 54.56 | 2242515.0 |
| 2024-10-31 | ADFI | ETF | 8.4964 | 8.61 | 8.496 | 8.58 | 19501.0 |
| 2024-10-31 | ADIV | ETF | 15.7323 | 15.7323 | 15.7323 | 15.7323 | 43.0 |
| 2024-10-31 | ADME | ETF | 46.08 | 46.08 | 45.8 | 45.8 | 10614.0 |
| 2024-10-31 | ADPV | ETF | 33.2 | 33.2 | 32.8856 | 32.8856 | 6604.0 |
| 2024-10-31 | ADVE | ETF | 34.5565 | 34.5565 | 34.5565 | 34.5565 | 4.0 |
| 2024-10-31 | AESR | ETF | 17.02 | 17.05 | 16.92 | 16.93 | 36087.0 |
| 2024-10-31 | AETH | ETF | 33.43 | 33.51 | 32.0831 | 32.0944 | 9297.0 |
| 2024-10-31 | AFIF | ETF | 9.15 | 9.16 | 9.14 | 9.145 | 5562.0 |
| 2024-10-31 | AFK | ETF | 16.73 | 17.0899 | 16.31 | 16.4305 | 31046.0 |
| 2024-10-31 | AFLG | ETF | 34.0 | 34.0 | 33.8577 | 33.8577 | 15681.0 |
| 2024-10-31 | AFMC | ETF | 31.9643 | 31.9643 | 31.9643 | 31.9643 | 21.0 |
| 2024-10-31 | AFSM | ETF | 30.185 | 30.35 | 30.1401 | 30.1482 | 4686.0 |
| 2024-10-31 | AGG | ETF | 98.32 | 98.5789 | 98.1501 | 98.42 | 12622251.0 |
| 2024-10-31 | AGGH | ETF | 20.74 | 20.75 | 20.61 | 20.61 | 70929.0 |
| 2024-10-31 | AGGS | ETF | 41.27 | 41.39 | 41.2578 | 41.3398 | 1613.0 |
| 2024-10-31 | AGGY | ETF | 43.48 | 43.578 | 43.3808 | 43.51 | 83608.0 |
| 2024-10-31 | AGIH | ETF | 24.6254 | 24.6254 | 24.6254 | 24.6254 | 67.0 |
| 2024-10-31 | AGIX | ETF | 25.89 | 25.89 | 25.77 | 25.79 | 729.0 |
| 2024-10-31 | AGMI | ETF | 30.68 | 30.8439 | 30.45 | 30.8439 | 1113.0 |
| 2024-10-31 | AGNG | ETF | 32.05 | 32.1109 | 32.01 | 32.01 | 1300.0 |
| 2024-10-31 | AGOX | ETF | 28.13 | 28.13 | 27.84 | 27.93 | 11283.0 |
| 2024-10-31 | AGQ | ETF | 45.51 | 45.5484 | 43.32 | 43.83 | 3655746.0 |
> showing 50 of 3,751 rows — these rows as CSV