PREVIEW / etf_daily / 2024-08-08
file: by_date/etf_daily/2024/2024-08-08.parquet size: 132 KB rows: 3,449
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-08-08 | SPY | ETF | 523.91 | 531.29 | 521.84 | 530.65 | 63092247.0 |
| 2024-08-08 | QQQ | ETF | 441.06 | 448.99 | 437.15 | 448.07 | 47890071.0 |
| 2024-08-08 | IWM | ETF | 204.42 | 207.0 | 203.17 | 206.89 | 26156132.0 |
| 2024-08-08 | DIA | ETF | 389.51 | 395.14 | 389.24 | 394.52 | 2987010.0 |
| 2024-08-08 | GLD | ETF | 222.73 | 224.25 | 222.515 | 224.01 | 6303172.0 |
| 2024-08-08 | TLT | ETF | 95.115 | 95.4 | 94.84 | 95.32 | 36246638.0 |
| 2024-08-08 | AAA | ETF | 25.08 | 25.08 | 24.95 | 24.96 | 9874.0 |
| 2024-08-08 | AAAU | ETF | 23.835 | 23.9901 | 23.815 | 23.97 | 1629692.0 |
| 2024-08-08 | AADR | ETF | 57.96 | 58.6905 | 57.95 | 58.37 | 2827.0 |
| 2024-08-08 | AAPB | ETF | 25.5 | 25.6899 | 24.61 | 25.53 | 114438.0 |
| 2024-08-08 | AAPD | ETF | 18.04 | 18.4 | 17.95 | 18.02 | 358169.0 |
| 2024-08-08 | AAPR | ETF | 25.21 | 25.3399 | 25.21 | 25.29 | 10678.0 |
| 2024-08-08 | AAPU | ETF | 32.62 | 32.96 | 31.39 | 32.74 | 418185.0 |
| 2024-08-08 | AAPX | ETF | 29.49 | 29.8301 | 28.59 | 29.5073 | 17806.0 |
| 2024-08-08 | AAPY | ETF | 25.81 | 25.982 | 25.81 | 25.982 | 336.0 |
| 2024-08-08 | AAXJ | ETF | 69.715 | 70.395 | 69.47 | 70.35 | 289334.0 |
| 2024-08-08 | ABCS | ETF | 26.35 | 26.5069 | 26.32 | 26.5069 | 3433.0 |
| 2024-08-08 | ABEQ | ETF | 30.96 | 31.0233 | 30.94 | 31.0233 | 5508.0 |
| 2024-08-08 | ABNY | ETF | 76.8495 | 78.3 | 76.8495 | 77.491 | 1314.0 |
| 2024-08-08 | ACES | ETF | 27.26 | 28.1382 | 27.16 | 27.92 | 39220.0 |
| 2024-08-08 | ACIO | ETF | 37.18 | 37.4599 | 37.0831 | 37.43 | 158408.0 |
| 2024-08-08 | ACSI | ETF | 54.2864 | 54.2864 | 54.2864 | 54.2864 | 71.0 |
| 2024-08-08 | ACT | ETF | 32.96 | 33.2 | 32.88 | 33.14 | 132971.0 |
| 2024-08-08 | ACTV | ETF | 31.69 | 31.78 | 31.5325 | 31.6949 | 5827.0 |
| 2024-08-08 | ACVF | ETF | 39.89 | 40.37 | 39.76 | 40.35 | 9882.0 |
| 2024-08-08 | ACWI | ETF | 108.75 | 110.19 | 108.41 | 110.04 | 2608984.0 |
| 2024-08-08 | ACWV | ETF | 107.27 | 107.95 | 107.04 | 107.84 | 86495.0 |
| 2024-08-08 | ACWX | ETF | 52.01 | 52.4401 | 51.79 | 52.42 | 420620.0 |
| 2024-08-08 | ADFI | ETF | 8.63 | 8.64 | 8.625 | 8.64 | 4307.0 |
| 2024-08-08 | ADIV | ETF | 14.3804 | 14.3804 | 14.3804 | 14.3804 | 18.0 |
| 2024-08-08 | ADME | ETF | 43.08 | 43.26 | 42.68 | 43.26 | 11308.0 |
| 2024-08-08 | ADPV | ETF | 29.08 | 29.5797 | 29.08 | 29.5797 | 368.0 |
| 2024-08-08 | AEMB | ETF | 38.65 | 38.8169 | 38.62 | 38.8169 | 851.0 |
| 2024-08-08 | AESR | ETF | 15.6225 | 15.7336 | 15.6225 | 15.7336 | 4197.0 |
| 2024-08-08 | AETH | ETF | 32.1 | 33.71 | 31.7595 | 33.4228 | 9022.0 |
| 2024-08-08 | AFIF | ETF | 9.1612 | 9.165 | 9.16 | 9.16 | 5105.0 |
| 2024-08-08 | AFK | ETF | 15.06 | 15.27 | 14.96 | 15.18 | 39279.0 |
| 2024-08-08 | AFLG | ETF | 31.01 | 31.24 | 30.9965 | 31.211 | 3482.0 |
| 2024-08-08 | AFMC | ETF | 29.7399 | 29.83 | 29.675 | 29.83 | 12589.0 |
| 2024-08-08 | AFSM | ETF | 28.5567 | 28.71 | 28.5567 | 28.6889 | 1743.0 |
| 2024-08-08 | AFTY | ETF | 13.8998 | 13.8998 | 13.8998 | 13.8998 | 93.0 |
| 2024-08-08 | AGG | ETF | 99.11 | 99.28 | 99.07 | 99.2 | 5450761.0 |
| 2024-08-08 | AGGH | ETF | 21.25 | 21.3948 | 21.25 | 21.37 | 36764.0 |
| 2024-08-08 | AGGY | ETF | 43.81 | 43.89 | 43.775 | 43.89 | 63690.0 |
| 2024-08-08 | AGIX | ETF | 22.835 | 22.9692 | 22.835 | 22.9692 | 403.0 |
| 2024-08-08 | AGMI | ETF | 24.36 | 24.46 | 24.32 | 24.3688 | 7847.0 |
| 2024-08-08 | AGNG | ETF | 30.69 | 31.31 | 30.69 | 31.162 | 19744.0 |
| 2024-08-08 | AGOX | ETF | 26.9 | 27.2 | 26.69 | 27.1381 | 28069.0 |
| 2024-08-08 | AGQ | ETF | 31.37 | 32.58 | 31.215 | 32.15 | 2134644.0 |
| 2024-08-08 | AGQI | ETF | 13.76 | 13.895 | 13.76 | 13.87 | 9208.0 |
> showing 50 of 3,449 rows — these rows as CSV