PREVIEW / etf_daily / 2022-08-11
file: by_date/etf_daily/2022/2022-08-11.parquet size: 103 KB rows: 2,775
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-11 | SPY | ETF | 422.99 | 424.95 | 419.21 | 419.99 | 59489700.0 |
| 2022-08-11 | QQQ | ETF | 328.305 | 330.36 | 323.36 | 324.08 | 45897650.0 |
| 2022-08-11 | IWM | ETF | 197.42 | 199.53 | 196.04 | 196.35 | 23727600.0 |
| 2022-08-11 | DIA | ETF | 335.82 | 336.8 | 333.18 | 333.71 | 2401600.0 |
| 2022-08-11 | GLD | ETF | 167.16 | 167.66 | 166.31 | 166.34 | 4446000.0 |
| 2022-08-11 | TLT | ETF | 116.87 | 117.06 | 114.09 | 114.39 | 20663800.0 |
| 2022-08-11 | AAA | ETF | 24.3113 | 24.3584 | 24.3113 | 24.335 | 852.0 |
| 2022-08-11 | AAAU | ETF | 17.8 | 17.85 | 17.72 | 17.73 | 662800.0 |
| 2022-08-11 | AADR | ETF | 52.67 | 53.05 | 52.43 | 52.45 | 1800.0 |
| 2022-08-11 | AAPB | ETF | 26.546 | 26.546 | 25.8916 | 25.8916 | 3428.0 |
| 2022-08-11 | AAPD | ETF | 24.29 | 24.4821 | 24.19 | 24.4821 | 15281.0 |
| 2022-08-11 | AAPU | ETF | 26.56 | 26.56 | 25.85 | 25.85 | 15008.0 |
| 2022-08-11 | AAXJ | ETF | 68.93 | 69.59 | 68.57 | 68.67 | 599100.0 |
| 2022-08-11 | ABEQ | ETF | 27.58 | 27.58 | 27.495 | 27.495 | 1000.0 |
| 2022-08-11 | ACES | ETF | 67.02 | 67.02 | 65.05 | 65.07 | 50900.0 |
| 2022-08-11 | ACIO | ETF | 31.0 | 31.1 | 30.885 | 30.92 | 15100.0 |
| 2022-08-11 | ACSI | ETF | 47.5831 | 47.5831 | 47.5831 | 47.5831 | 23.0 |
| 2022-08-11 | ACT | ETF | 26.69 | 27.0 | 26.64 | 26.74 | 177319.0 |
| 2022-08-11 | ACTV | ETF | 32.67 | 32.81 | 32.272 | 32.272 | 10575.0 |
| 2022-08-11 | ACTX | ETF | 0.55 | 0.55 | 0.55 | 0.55 | 4149.0 |
| 2022-08-11 | ACVF | ETF | 31.81 | 31.85 | 31.522 | 31.522 | 4300.0 |
| 2022-08-11 | ACWF | ETF | 33.81 | 34.0101 | 33.69 | 33.69 | 4508.0 |
| 2022-08-11 | ACWI | ETF | 91.93 | 92.42 | 91.23 | 91.39 | 2771500.0 |
| 2022-08-11 | ACWV | ETF | 99.05 | 99.48 | 98.53 | 98.6 | 102600.0 |
| 2022-08-11 | ACWX | ETF | 47.15 | 47.42 | 46.87 | 46.96 | 4552379.0 |
| 2022-08-11 | ADFI | ETF | 8.75 | 8.76 | 8.709 | 8.709 | 1400.0 |
| 2022-08-11 | ADIV | ETF | 13.973 | 13.973 | 13.973 | 13.973 | 100.0 |
| 2022-08-11 | ADME | ETF | 37.235 | 37.235 | 37.035 | 37.07 | 11100.0 |
| 2022-08-11 | ADRE | ETF | 40.55 | 40.8701 | 40.34 | 40.54 | 3591.0 |
| 2022-08-11 | AEMB | ETF | 39.71 | 39.71 | 39.34 | 39.358 | 700.0 |
| 2022-08-11 | AESR | ETF | 12.21 | 12.222 | 12.11 | 12.11 | 7600.0 |
| 2022-08-11 | AFIF | ETF | 8.992 | 8.992 | 8.96 | 8.97 | 4797.0 |
| 2022-08-11 | AFK | ETF | 18.0 | 18.39 | 17.9 | 18.1 | 12457.0 |
| 2022-08-11 | AFLG | ETF | 24.763 | 24.763 | 24.763 | 24.763 | 100.0 |
| 2022-08-11 | AFSM | ETF | 24.406 | 24.406 | 24.406 | 24.406 | 100.0 |
| 2022-08-11 | AFTY | ETF | 17.58 | 17.58 | 17.43 | 17.43 | 1600.0 |
| 2022-08-11 | AGG | ETF | 103.38 | 103.63 | 102.62 | 102.66 | 8518200.0 |
| 2022-08-11 | AGGH | ETF | 23.7324 | 23.7324 | 23.675 | 23.675 | 125.0 |
| 2022-08-11 | AGGY | ETF | 45.82 | 45.91 | 45.46 | 45.49 | 52500.0 |
| 2022-08-11 | AGNG | ETF | 26.685 | 26.685 | 26.499 | 26.499 | 700.0 |
| 2022-08-11 | AGOV | ETF | 83.51 | 83.51 | 83.1552 | 83.1552 | 185.0 |
| 2022-08-11 | AGOX | ETF | 22.51 | 22.58 | 22.35 | 22.35 | 13900.0 |
| 2022-08-11 | AGQ | ETF | 24.68 | 24.95 | 24.08 | 24.12 | 840000.0 |
| 2022-08-11 | AGZ | ETF | 110.45 | 110.45 | 110.06 | 110.1 | 9741.0 |
| 2022-08-11 | AGZD | ETF | 22.97 | 23.055 | 22.97 | 23.045 | 35000.0 |
| 2022-08-11 | AHHX | ETF | 8.875 | 8.885 | 8.8107 | 8.8472 | 2406.0 |
| 2022-08-11 | AHYB | ETF | 45.17 | 45.17 | 45.17 | 45.17 | 100.0 |
| 2022-08-11 | AIA | ETF | 60.51 | 61.29 | 60.33 | 60.42 | 434541.0 |
| 2022-08-11 | AIEQ | ETF | 36.03 | 36.405 | 35.595 | 35.638 | 5100.0 |
| 2022-08-11 | AIQ | ETF | 23.52 | 23.8362 | 23.255 | 23.4 | 37655.0 |
> showing 50 of 2,775 rows — these rows as CSV