PREVIEW / etf_daily / 2022-05-12
file: by_date/etf_daily/2022/2022-05-12.parquet size: 102 KB rows: 2,737
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-12 | SPY | ETF | 389.37 | 395.8 | 385.15 | 392.34 | 125090800.0 |
| 2022-05-12 | QQQ | ETF | 287.45 | 295.75 | 284.94 | 291.15 | 120910850.0 |
| 2022-05-12 | IWM | ETF | 169.83 | 174.34 | 168.9 | 172.6 | 52967400.0 |
| 2022-05-12 | DIA | ETF | 316.6 | 319.43 | 312.53 | 317.64 | 6790800.0 |
| 2022-05-12 | GLD | ETF | 172.07 | 172.4 | 169.9 | 170.17 | 11626800.0 |
| 2022-05-12 | TLT | ETF | 118.02 | 118.89 | 117.66 | 117.72 | 26405700.0 |
| 2022-05-12 | AAA | ETF | 24.63 | 24.64 | 24.63 | 24.64 | 100.0 |
| 2022-05-12 | AAAU | ETF | 18.33 | 18.37 | 18.1 | 18.13 | 2750400.0 |
| 2022-05-12 | AADR | ETF | 50.94 | 51.4 | 50.79 | 51.4 | 1800.0 |
| 2022-05-12 | AAXJ | ETF | 65.93 | 66.76 | 65.43 | 66.21 | 2042800.0 |
| 2022-05-12 | ABEQ | ETF | 27.835 | 28.04 | 27.823 | 28.04 | 20400.0 |
| 2022-05-12 | ACES | ETF | 43.11 | 45.67 | 42.66 | 44.38 | 278300.0 |
| 2022-05-12 | ACIO | ETF | 28.885 | 29.09 | 28.73 | 29.09 | 80600.0 |
| 2022-05-12 | ACSI | ETF | 43.29 | 43.3158 | 43.29 | 43.3158 | 135.0 |
| 2022-05-12 | ACT | ETF | 22.48 | 22.48 | 21.48 | 22.03 | 141725.0 |
| 2022-05-12 | ACTV | ETF | 31.1391 | 31.29 | 30.81 | 31.22 | 5929.0 |
| 2022-05-12 | ACVF | ETF | 29.49 | 29.7 | 29.2 | 29.574 | 12200.0 |
| 2022-05-12 | ACWF | ETF | 32.72 | 32.975 | 32.4953 | 32.8901 | 7624.0 |
| 2022-05-12 | ACWI | ETF | 86.31 | 87.58 | 85.52 | 86.85 | 5135400.0 |
| 2022-05-12 | ACWV | ETF | 95.85 | 96.65 | 95.41 | 96.3 | 282200.0 |
| 2022-05-12 | ACWX | ETF | 45.87 | 46.43 | 45.6 | 46.02 | 3435840.0 |
| 2022-05-12 | ADFI | ETF | 8.63 | 8.67 | 8.63 | 8.647 | 8900.0 |
| 2022-05-12 | ADIV | ETF | 13.96 | 13.96 | 13.942 | 13.942 | 400.0 |
| 2022-05-12 | ADME | ETF | 36.25 | 36.515 | 36.226 | 36.35 | 32900.0 |
| 2022-05-12 | ADRE | ETF | 36.71 | 37.32 | 36.2812 | 36.95 | 4047.0 |
| 2022-05-12 | AEMB | ETF | 40.085 | 40.085 | 40.085 | 40.085 | 100.0 |
| 2022-05-12 | AESR | ETF | 11.41 | 11.66 | 11.35 | 11.54 | 34400.0 |
| 2022-05-12 | AFIF | ETF | 9.085 | 9.1 | 9.08 | 9.1 | 74164.0 |
| 2022-05-12 | AFK | ETF | 18.23 | 18.4074 | 18.09 | 18.32 | 7383.0 |
| 2022-05-12 | AFLG | ETF | 23.492 | 23.776 | 23.492 | 23.776 | 1600.0 |
| 2022-05-12 | AFMC | ETF | 22.32 | 22.32 | 22.28 | 22.28 | 3900.0 |
| 2022-05-12 | AFSM | ETF | 22.74 | 22.74 | 22.74 | 22.74 | 100.0 |
| 2022-05-12 | AFTY | ETF | 16.31 | 16.41 | 16.31 | 16.393 | 1500.0 |
| 2022-05-12 | AGG | ETF | 102.94 | 103.14 | 102.87 | 102.95 | 9015300.0 |
| 2022-05-12 | AGGH | ETF | 24.01 | 24.01 | 23.9625 | 23.9625 | 252.0 |
| 2022-05-12 | AGGY | ETF | 45.65 | 45.674 | 45.45 | 45.57 | 202600.0 |
| 2022-05-12 | AGNG | ETF | 24.7 | 24.9 | 24.61 | 24.9 | 3300.0 |
| 2022-05-12 | AGOV | ETF | 78.09 | 80.17 | 77.05 | 77.775 | 3826.0 |
| 2022-05-12 | AGOX | ETF | 20.665 | 21.01 | 20.6 | 20.86 | 155500.0 |
| 2022-05-12 | AGQ | ETF | 27.18 | 27.2 | 25.82 | 26.14 | 1661200.0 |
| 2022-05-12 | AGZ | ETF | 110.46 | 110.9234 | 110.46 | 110.76 | 10725.0 |
| 2022-05-12 | AGZD | ETF | 22.94 | 22.97 | 22.88 | 22.92 | 198600.0 |
| 2022-05-12 | AHHX | ETF | 9.01 | 9.0222 | 8.95 | 9.0222 | 2182.0 |
| 2022-05-12 | AHYB | ETF | 44.47 | 44.507 | 44.25 | 44.42 | 1100.0 |
| 2022-05-12 | AIA | ETF | 59.59 | 60.28 | 59.03 | 59.68 | 206158.0 |
| 2022-05-12 | AIEQ | ETF | 31.4 | 32.155 | 31.27 | 31.722 | 10300.0 |
| 2022-05-12 | AIQ | ETF | 21.03 | 21.6607 | 20.9 | 21.36 | 26795.0 |
| 2022-05-12 | AIRR | ETF | 36.55 | 37.41 | 36.5 | 37.27 | 20500.0 |
| 2022-05-12 | AIVI | ETF | 37.28 | 37.52 | 37.17 | 37.31 | 4300.0 |
| 2022-05-12 | AIVL | ETF | 91.73 | 92.75 | 91.26 | 92.61 | 12200.0 |
> showing 50 of 2,737 rows — these rows as CSV