PREVIEW / etf_daily / 2024-08-07
file: by_date/etf_daily/2024/2024-08-07.parquet size: 133 KB rows: 3,487
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-07 | SPY | ETF | 528.47 | 531.59 | 518.0519 | 518.66 | 70223043.0 |
| 2024-08-07 | QQQ | ETF | 446.49 | 449.0 | 434.37 | 434.77 | 54929163.0 |
| 2024-08-07 | IWM | ETF | 207.85 | 207.96 | 201.56 | 201.98 | 30393339.0 |
| 2024-08-07 | DIA | ETF | 392.63 | 394.79 | 387.2796 | 387.77 | 3963050.0 |
| 2024-08-07 | GLD | ETF | 221.94 | 222.31 | 220.35 | 220.55 | 5265263.0 |
| 2024-08-07 | TLT | ETF | 95.95 | 96.45 | 95.5 | 95.91 | 51260085.0 |
| 2024-08-07 | AAA | ETF | 24.95 | 25.0799 | 24.95 | 24.951 | 12439.0 |
| 2024-08-07 | AAAU | ETF | 23.76 | 23.7899 | 23.585 | 23.6 | 1369285.0 |
| 2024-08-07 | AADR | ETF | 56.47 | 56.59 | 56.47 | 56.59 | 218.0 |
| 2024-08-07 | AAPB | ETF | 24.03 | 25.5758 | 24.01 | 24.75 | 86800.0 |
| 2024-08-07 | AAPD | ETF | 18.58 | 18.61 | 17.9797 | 18.31 | 530215.0 |
| 2024-08-07 | AAPR | ETF | 25.32 | 25.32 | 25.11 | 25.11 | 27573.0 |
| 2024-08-07 | AAPU | ETF | 30.85 | 32.8 | 30.67 | 31.66 | 581863.0 |
| 2024-08-07 | AAPX | ETF | 27.99 | 29.64 | 27.99 | 28.67 | 125493.0 |
| 2024-08-07 | AAPY | ETF | 25.77 | 25.77 | 25.6064 | 25.6064 | 433.0 |
| 2024-08-07 | AAXJ | ETF | 70.03 | 70.03 | 68.71 | 68.76 | 323345.0 |
| 2024-08-07 | ABCS | ETF | 26.5 | 26.61 | 25.97 | 25.99 | 3209.0 |
| 2024-08-07 | ABEQ | ETF | 30.86 | 30.86 | 30.7023 | 30.7023 | 159.0 |
| 2024-08-07 | ABNY | ETF | 76.4 | 77.797 | 74.55 | 75.8565 | 5961.0 |
| 2024-08-07 | ACES | ETF | 27.89 | 28.14 | 26.92 | 26.98 | 40661.0 |
| 2024-08-07 | ACIO | ETF | 37.42 | 37.49 | 36.8937 | 36.9 | 442549.0 |
| 2024-08-07 | ACSI | ETF | 53.3829 | 53.3829 | 53.3829 | 53.3829 | 92.0 |
| 2024-08-07 | ACT | ETF | 33.03 | 33.2399 | 32.51 | 32.69 | 189734.0 |
| 2024-08-07 | ACTV | ETF | 32.15 | 32.24 | 31.51 | 31.51 | 5087.0 |
| 2024-08-07 | ACVF | ETF | 40.34 | 40.4 | 39.3879 | 39.3879 | 22576.0 |
| 2024-08-07 | ACWI | ETF | 109.56 | 109.99 | 107.65 | 107.77 | 9448790.0 |
| 2024-08-07 | ACWV | ETF | 107.44 | 107.83 | 105.37 | 106.87 | 77022.0 |
| 2024-08-07 | ACWX | ETF | 52.24 | 52.27 | 51.41 | 51.45 | 522930.0 |
| 2024-08-07 | ADFI | ETF | 8.62 | 8.65 | 8.62 | 8.625 | 4337.0 |
| 2024-08-07 | ADIV | ETF | 14.18 | 14.18 | 14.0946 | 14.0946 | 132.0 |
| 2024-08-07 | ADME | ETF | 43.45 | 43.45 | 42.37 | 42.55 | 28143.0 |
| 2024-08-07 | ADPV | ETF | 29.33 | 29.355 | 28.7453 | 28.7453 | 7904.0 |
| 2024-08-07 | AEMB | ETF | 38.6255 | 38.6255 | 38.6255 | 38.6255 | 4.0 |
| 2024-08-07 | AESR | ETF | 15.67 | 15.67 | 15.287 | 15.287 | 4935.0 |
| 2024-08-07 | AETH | ETF | 31.6904 | 31.6904 | 30.498 | 30.59 | 9065.0 |
| 2024-08-07 | AFIF | ETF | 9.26 | 9.26 | 9.17 | 9.175 | 4499.0 |
| 2024-08-07 | AFK | ETF | 15.21 | 15.274 | 14.73 | 14.73 | 27494.0 |
| 2024-08-07 | AFLG | ETF | 31.21 | 31.21 | 30.55 | 30.56 | 9115.0 |
| 2024-08-07 | AFMC | ETF | 29.7995 | 29.7995 | 29.14 | 29.1474 | 35128.0 |
| 2024-08-07 | AFSM | ETF | 28.8999 | 28.8999 | 28.0901 | 28.1427 | 7017.0 |
| 2024-08-07 | AFTY | ETF | 13.7949 | 13.7949 | 13.7949 | 13.7949 | 23.0 |
| 2024-08-07 | AGG | ETF | 99.51 | 99.6142 | 99.24 | 99.35 | 8076784.0 |
| 2024-08-07 | AGGH | ETF | 21.5 | 21.5 | 21.2737 | 21.39 | 51167.0 |
| 2024-08-07 | AGGY | ETF | 43.96 | 44.0171 | 43.83 | 43.87 | 117728.0 |
| 2024-08-07 | AGIX | ETF | 23.04 | 23.04 | 22.158 | 22.158 | 813.0 |
| 2024-08-07 | AGMI | ETF | 25.17 | 25.17 | 24.0514 | 24.0514 | 104.0 |
| 2024-08-07 | AGNG | ETF | 30.72 | 30.87 | 30.31 | 30.45 | 11001.0 |
| 2024-08-07 | AGOX | ETF | 27.34 | 27.34 | 26.55 | 26.6748 | 91899.0 |
| 2024-08-07 | AGQ | ETF | 31.31 | 31.5342 | 30.26 | 30.5 | 1877994.0 |
| 2024-08-07 | AGQI | ETF | 13.82 | 13.86 | 13.64 | 13.64 | 8482.0 |
> showing 50 of 3,487 rows — these rows as CSV