PREVIEW / etf_daily / 2022-05-17
file: by_date/etf_daily/2022/2022-05-17.parquet size: 101 KB rows: 2,711
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-05-17 | SPY | ETF | 406.53 | 408.57 | 402.58 | 408.32 | 83029700.0 |
| 2022-05-17 | QQQ | ETF | 304.45 | 306.56 | 300.55 | 306.17 | 62715293.0 |
| 2022-05-17 | IWM | ETF | 180.41 | 182.84 | 178.99 | 182.64 | 31833700.0 |
| 2022-05-17 | DIA | ETF | 326.83 | 327.37 | 323.46 | 327.1 | 3316800.0 |
| 2022-05-17 | GLD | ETF | 170.44 | 170.53 | 169.14 | 169.33 | 6441100.0 |
| 2022-05-17 | TLT | ETF | 114.71 | 115.35 | 114.36 | 114.46 | 15040800.0 |
| 2022-05-17 | AAA | ETF | 24.555 | 24.555 | 24.555 | 24.555 | 3.0 |
| 2022-05-17 | AAAU | ETF | 18.16 | 18.16 | 18.02 | 18.04 | 1434500.0 |
| 2022-05-17 | AADR | ETF | 54.61 | 54.66 | 54.22 | 54.66 | 3100.0 |
| 2022-05-17 | AAXJ | ETF | 69.69 | 69.91 | 69.04 | 69.66 | 1355800.0 |
| 2022-05-17 | ABEQ | ETF | 29.84 | 29.84 | 28.62 | 28.737 | 15300.0 |
| 2022-05-17 | ACES | ETF | 47.95 | 49.04 | 47.436 | 49.04 | 91600.0 |
| 2022-05-17 | ACIO | ETF | 30.07 | 30.07 | 29.59 | 29.78 | 74400.0 |
| 2022-05-17 | ACSI | ETF | 44.8611 | 44.8611 | 44.8611 | 44.8611 | 80.0 |
| 2022-05-17 | ACT | ETF | 23.51 | 24.455 | 23.34 | 24.0 | 252417.0 |
| 2022-05-17 | ACTV | ETF | 32.6 | 33.01 | 32.42 | 32.8976 | 10334.0 |
| 2022-05-17 | ACTX | ETF | 0.8755 | 0.8755 | 0.8755 | 0.8755 | 200.0 |
| 2022-05-17 | ACVF | ETF | 30.44 | 30.82 | 30.44 | 30.783 | 1900.0 |
| 2022-05-17 | ACWF | ETF | 34.21 | 34.35 | 34.06 | 34.2987 | 25593.0 |
| 2022-05-17 | ACWI | ETF | 90.34 | 90.67 | 89.59 | 90.65 | 2507700.0 |
| 2022-05-17 | ACWV | ETF | 98.62 | 98.62 | 97.73 | 98.4 | 147000.0 |
| 2022-05-17 | ACWX | ETF | 48.2 | 48.29 | 47.91 | 48.28 | 3148427.0 |
| 2022-05-17 | ADFI | ETF | 8.63 | 8.63 | 8.6 | 8.61 | 4400.0 |
| 2022-05-17 | ADIV | ETF | 14.521 | 14.521 | 14.521 | 14.521 | 100.0 |
| 2022-05-17 | ADME | ETF | 37.49 | 37.49 | 36.836 | 37.23 | 35700.0 |
| 2022-05-17 | ADRE | ETF | 39.86 | 39.86 | 39.4 | 39.7 | 11672.0 |
| 2022-05-17 | AESR | ETF | 11.97 | 12.06 | 11.97 | 12.033 | 16100.0 |
| 2022-05-17 | AFIF | ETF | 8.97 | 8.98 | 8.96 | 8.97 | 6191.0 |
| 2022-05-17 | AFK | ETF | 18.95 | 19.14 | 18.79 | 18.93 | 21259.0 |
| 2022-05-17 | AFLG | ETF | 24.65 | 24.677 | 24.65 | 24.654 | 4500.0 |
| 2022-05-17 | AFMC | ETF | 23.08 | 23.36 | 23.08 | 23.35 | 1200.0 |
| 2022-05-17 | AFSM | ETF | 23.9 | 23.933 | 23.9 | 23.933 | 500.0 |
| 2022-05-17 | AFTY | ETF | 16.742 | 16.781 | 16.742 | 16.781 | 1100.0 |
| 2022-05-17 | AGG | ETF | 102.27 | 102.43 | 102.14 | 102.18 | 6559000.0 |
| 2022-05-17 | AGGH | ETF | 23.8299 | 23.8299 | 23.7527 | 23.7527 | 270.0 |
| 2022-05-17 | AGGY | ETF | 45.26 | 45.359 | 45.17 | 45.235 | 184600.0 |
| 2022-05-17 | AGNG | ETF | 25.887 | 25.996 | 25.83 | 25.996 | 1300.0 |
| 2022-05-17 | AGOV | ETF | 79.5 | 79.5 | 78.235 | 78.24 | 4381.0 |
| 2022-05-17 | AGOX | ETF | 21.8 | 21.89 | 21.6 | 21.85 | 42100.0 |
| 2022-05-17 | AGQ | ETF | 28.65 | 28.87 | 28.18 | 28.39 | 758600.0 |
| 2022-05-17 | AGZ | ETF | 110.31 | 110.399 | 110.2104 | 110.2104 | 20949.0 |
| 2022-05-17 | AGZD | ETF | 22.995 | 23.05 | 22.89 | 23.05 | 77800.0 |
| 2022-05-17 | AHHX | ETF | 9.1307 | 9.1402 | 9.12 | 9.1402 | 2097.0 |
| 2022-05-17 | AHYB | ETF | 44.4 | 44.4 | 44.379 | 44.379 | 1300.0 |
| 2022-05-17 | AIA | ETF | 63.56 | 63.92 | 62.85 | 63.42 | 72616.0 |
| 2022-05-17 | AIEQ | ETF | 33.43 | 33.67 | 33.15 | 33.63 | 9100.0 |
| 2022-05-17 | AIQ | ETF | 22.51 | 22.6 | 22.13 | 22.52 | 29296.0 |
| 2022-05-17 | AIRR | ETF | 38.32 | 38.908 | 38.32 | 38.84 | 11900.0 |
| 2022-05-17 | AIVI | ETF | 38.83 | 39.01 | 38.83 | 39.01 | 800.0 |
| 2022-05-17 | AIVL | ETF | 95.23 | 96.1 | 95.21 | 95.95 | 7500.0 |
> showing 50 of 2,711 rows — these rows as CSV