PREVIEW / etf_daily / 2024-08-12
file: by_date/etf_daily/2024/2024-08-12.parquet size: 133 KB rows: 3,462
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-12 | SPY | ETF | 534.21 | 535.73 | 530.95 | 533.27 | 42382737.0 |
| 2024-08-12 | QQQ | ETF | 451.39 | 454.37 | 448.5546 | 451.38 | 27795006.0 |
| 2024-08-12 | IWM | ETF | 206.61 | 206.98 | 203.82 | 204.6 | 20293775.0 |
| 2024-08-12 | DIA | ETF | 395.95 | 396.04 | 392.61 | 393.77 | 1890951.0 |
| 2024-08-12 | GLD | ETF | 226.14 | 228.535 | 225.965 | 228.41 | 5314929.0 |
| 2024-08-12 | TLT | ETF | 96.03 | 96.82 | 95.88 | 96.61 | 24218401.0 |
| 2024-08-12 | AAA | ETF | 25.0782 | 25.0782 | 24.97 | 25.024 | 6996.0 |
| 2024-08-12 | AAAU | ETF | 24.19 | 24.46 | 24.18 | 24.44 | 1647093.0 |
| 2024-08-12 | AADR | ETF | 59.5314 | 59.58 | 59.5314 | 59.58 | 307.0 |
| 2024-08-12 | AAPB | ETF | 26.25 | 27.0223 | 26.14 | 26.58 | 74090.0 |
| 2024-08-12 | AAPD | ETF | 17.78 | 17.81 | 17.5 | 17.65 | 303786.0 |
| 2024-08-12 | AAPR | ETF | 25.335 | 25.385 | 25.33 | 25.343 | 7394.0 |
| 2024-08-12 | AAPU | ETF | 33.61 | 34.66 | 33.5 | 34.06 | 788659.0 |
| 2024-08-12 | AAPX | ETF | 30.55 | 31.2616 | 30.39 | 30.7448 | 60292.0 |
| 2024-08-12 | AAXJ | ETF | 70.72 | 71.155 | 70.66 | 70.96 | 477444.0 |
| 2024-08-12 | ABCS | ETF | 26.5 | 26.5 | 26.28 | 26.3055 | 1466.0 |
| 2024-08-12 | ABEQ | ETF | 31.1004 | 31.1378 | 31.02 | 31.03 | 2052.0 |
| 2024-08-12 | ABNY | ETF | 77.65 | 78.3 | 77.367 | 77.367 | 862.0 |
| 2024-08-12 | ACES | ETF | 27.33 | 27.33 | 26.74 | 26.84 | 162033.0 |
| 2024-08-12 | ACIO | ETF | 37.61 | 37.6799 | 37.4358 | 37.57 | 78964.0 |
| 2024-08-12 | ACSI | ETF | 54.5424 | 54.5424 | 54.5424 | 54.5424 | 53.0 |
| 2024-08-12 | ACT | ETF | 33.21 | 33.33 | 32.89 | 33.0 | 257172.0 |
| 2024-08-12 | ACTV | ETF | 31.34 | 31.34 | 30.73 | 30.76 | 5468.0 |
| 2024-08-12 | ACVF | ETF | 40.425 | 40.6454 | 40.3425 | 40.4398 | 7419.0 |
| 2024-08-12 | ACWI | ETF | 110.79 | 111.07 | 110.19 | 110.61 | 3016260.0 |
| 2024-08-12 | ACWV | ETF | 108.31 | 108.52 | 107.84 | 108.07 | 171493.0 |
| 2024-08-12 | ACWX | ETF | 52.61 | 52.82 | 52.505 | 52.68 | 922497.0 |
| 2024-08-12 | ADFI | ETF | 8.63 | 8.65 | 8.6 | 8.65 | 14099.0 |
| 2024-08-12 | ADIV | ETF | 14.5003 | 14.5003 | 14.5003 | 14.5003 | 31.0 |
| 2024-08-12 | ADME | ETF | 43.1583 | 43.46 | 43.1583 | 43.3307 | 9989.0 |
| 2024-08-12 | ADPV | ETF | 29.8138 | 29.94 | 29.7 | 29.7429 | 1395.0 |
| 2024-08-12 | AEMB | ETF | 39.0236 | 39.2496 | 38.83 | 39.2496 | 1345.0 |
| 2024-08-12 | AESR | ETF | 15.83 | 15.92 | 15.8 | 15.8108 | 17978.0 |
| 2024-08-12 | AETH | ETF | 35.0 | 35.17 | 34.31 | 34.4759 | 6017.0 |
| 2024-08-12 | AFIF | ETF | 9.1777 | 9.18 | 9.16 | 9.17 | 18638.0 |
| 2024-08-12 | AFK | ETF | 15.41 | 15.4999 | 15.29 | 15.4072 | 24232.0 |
| 2024-08-12 | AFLG | ETF | 31.45 | 31.49 | 31.3 | 31.37 | 17230.0 |
| 2024-08-12 | AFMC | ETF | 29.6235 | 29.68 | 29.54 | 29.5855 | 1562.0 |
| 2024-08-12 | AFSM | ETF | 28.59 | 28.5996 | 28.41 | 28.43 | 4897.0 |
| 2024-08-12 | AFTY | ETF | 13.8905 | 13.8905 | 13.8905 | 13.8905 | 0.0 |
| 2024-08-12 | AGG | ETF | 99.47 | 99.78 | 99.41 | 99.72 | 7277386.0 |
| 2024-08-12 | AGGH | ETF | 21.45 | 21.59 | 21.37 | 21.59 | 36348.0 |
| 2024-08-12 | AGGY | ETF | 43.98 | 44.0899 | 43.96 | 44.07 | 52022.0 |
| 2024-08-12 | AGIX | ETF | 23.41 | 23.41 | 23.195 | 23.2066 | 1770.0 |
| 2024-08-12 | AGMI | ETF | 24.62 | 24.72 | 24.62 | 24.72 | 504.0 |
| 2024-08-12 | AGNG | ETF | 31.18 | 31.37 | 31.08 | 31.19 | 9189.0 |
| 2024-08-12 | AGOX | ETF | 27.36 | 27.36 | 26.84 | 26.985 | 13394.0 |
| 2024-08-12 | AGQ | ETF | 33.05 | 33.59 | 32.36 | 33.38 | 1807103.0 |
| 2024-08-12 | AGQI | ETF | 13.94 | 13.98 | 13.915 | 13.94 | 10137.0 |
| 2024-08-12 | AGRH | ETF | 25.73 | 25.78 | 25.73 | 25.7649 | 2477.0 |
> showing 50 of 3,462 rows — these rows as CSV