PREVIEW / etf_daily / 2024-10-01
file: by_date/etf_daily/2024/2024-10-01.parquet size: 136 KB rows: 3,569
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-01 | SPY | ETF | 573.4 | 574.0622 | 566.0 | 568.62 | 72348202.0 |
| 2024-10-01 | QQQ | ETF | 487.7 | 488.0 | 477.4 | 481.27 | 42735424.0 |
| 2024-10-01 | IWM | ETF | 220.17 | 220.34 | 216.3 | 217.89 | 29919447.0 |
| 2024-10-01 | DIA | ETF | 422.42 | 423.15 | 419.29 | 421.5 | 5099606.0 |
| 2024-10-01 | GLD | ETF | 245.2 | 246.98 | 245.06 | 245.61 | 11082200.0 |
| 2024-10-01 | TLT | ETF | 98.8 | 99.33 | 98.385 | 98.49 | 45299850.0 |
| 2024-10-01 | AAA | ETF | 25.04 | 25.05 | 25.0317 | 25.05 | 7162.0 |
| 2024-10-01 | AAAU | ETF | 26.25 | 26.435 | 26.235 | 26.3 | 3503077.0 |
| 2024-10-01 | AADR | ETF | 64.19 | 64.19 | 63.62 | 63.62 | 615.0 |
| 2024-10-01 | AAPB | ETF | 29.03 | 29.03 | 27.6501 | 28.27 | 149024.0 |
| 2024-10-01 | AAPD | ETF | 16.69 | 17.1 | 16.69 | 16.93 | 447061.0 |
| 2024-10-01 | AAPR | ETF | 26.1642 | 26.2023 | 26.14 | 26.185 | 57484.0 |
| 2024-10-01 | AAPU | ETF | 36.94 | 36.94 | 35.0 | 35.8 | 1004472.0 |
| 2024-10-01 | AAPX | ETF | 32.9 | 32.99 | 32.0 | 32.62 | 43748.0 |
| 2024-10-01 | AAPY | ETF | 27.1 | 27.1 | 26.9584 | 26.9584 | 1106.0 |
| 2024-10-01 | AAXJ | ETF | 78.93 | 79.4 | 78.18 | 79.39 | 1047994.0 |
| 2024-10-01 | ABCS | ETF | 28.1147 | 28.1252 | 28.02 | 28.1252 | 1300.0 |
| 2024-10-01 | ABEQ | ETF | 32.678 | 32.81 | 32.678 | 32.7783 | 4724.0 |
| 2024-10-01 | ABNY | ETF | 81.0 | 81.0 | 79.6 | 80.553 | 1357.0 |
| 2024-10-01 | ACES | ETF | 29.31 | 29.31 | 28.43 | 28.71 | 180816.0 |
| 2024-10-01 | ACIO | ETF | 39.71 | 39.71 | 39.37 | 39.5 | 164747.0 |
| 2024-10-01 | ACSI | ETF | 58.1729 | 58.1729 | 58.1729 | 58.1729 | 36.0 |
| 2024-10-01 | ACT | ETF | 36.47 | 36.47 | 35.84 | 36.31 | 311986.0 |
| 2024-10-01 | ACTV | ETF | 33.7 | 33.7 | 33.59 | 33.6209 | 3176.0 |
| 2024-10-01 | ACVF | ETF | 44.0 | 44.0 | 43.1075 | 43.27 | 10699.0 |
| 2024-10-01 | ACWI | ETF | 119.45 | 119.58 | 118.17 | 118.79 | 2632219.0 |
| 2024-10-01 | ACWV | ETF | 114.57 | 114.93 | 114.2944 | 114.65 | 134664.0 |
| 2024-10-01 | ACWX | ETF | 57.33 | 57.33 | 56.73 | 57.11 | 773599.0 |
| 2024-10-01 | ADFI | ETF | 8.8 | 8.82 | 8.792 | 8.7934 | 3016.0 |
| 2024-10-01 | ADIV | ETF | 16.28 | 16.4069 | 16.28 | 16.4069 | 347.0 |
| 2024-10-01 | ADME | ETF | 45.79 | 45.98 | 45.75 | 45.86 | 16383.0 |
| 2024-10-01 | ADPV | ETF | 31.47 | 31.7 | 31.47 | 31.6158 | 6431.0 |
| 2024-10-01 | ADVE | ETF | 36.27 | 36.4114 | 36.27 | 36.4114 | 154.0 |
| 2024-10-01 | AESR | ETF | 16.82 | 16.91 | 16.765 | 16.85 | 8819.0 |
| 2024-10-01 | AETH | ETF | 33.54 | 33.54 | 31.49 | 31.9973 | 3953.0 |
| 2024-10-01 | AFIF | ETF | 9.12 | 9.22 | 9.12 | 9.205 | 6901.0 |
| 2024-10-01 | AFK | ETF | 17.14 | 17.14 | 16.925 | 17.1 | 12276.0 |
| 2024-10-01 | AFLG | ETF | 33.85 | 33.98 | 33.785 | 33.89 | 14111.0 |
| 2024-10-01 | AFMC | ETF | 32.0092 | 32.0285 | 31.9786 | 31.9786 | 912.0 |
| 2024-10-01 | AFSM | ETF | 30.31 | 30.4556 | 30.31 | 30.4556 | 1924.0 |
| 2024-10-01 | AFTY | ETF | 16.6 | 16.6 | 16.3201 | 16.36 | 11057.0 |
| 2024-10-01 | AGG | ETF | 101.27 | 101.445 | 101.15 | 101.23 | 8809260.0 |
| 2024-10-01 | AGGH | ETF | 21.79 | 21.79 | 21.66 | 21.68 | 197478.0 |
| 2024-10-01 | AGGY | ETF | 44.91 | 44.9508 | 44.8627 | 44.9 | 71732.0 |
| 2024-10-01 | AGIX | ETF | 25.2 | 25.2 | 24.7999 | 24.8916 | 3916.0 |
| 2024-10-01 | AGMI | ETF | 29.08 | 29.42 | 28.95 | 29.32 | 1142.0 |
| 2024-10-01 | AGNG | ETF | 32.8 | 32.81 | 32.612 | 32.8 | 2626.0 |
| 2024-10-01 | AGOX | ETF | 28.54 | 28.86 | 28.54 | 28.86 | 53231.0 |
| 2024-10-01 | AGQ | ETF | 41.54 | 42.3 | 40.84 | 40.96 | 1915373.0 |
| 2024-10-01 | AGQI | ETF | 14.65 | 14.65 | 14.51 | 14.5651 | 5387.0 |
> showing 50 of 3,569 rows — these rows as CSV