PREVIEW / etf_daily / 2022-04-14
file: by_date/etf_daily/2022/2022-04-14.parquet size: 100 KB rows: 2,690
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-04-14 | SPY | ETF | 443.55 | 444.73 | 437.68 | 437.79 | 97869500.0 |
| 2022-04-14 | QQQ | ETF | 346.44 | 346.97 | 338.21 | 338.43 | 73519367.0 |
| 2022-04-14 | IWM | ETF | 201.11 | 202.37 | 198.87 | 198.96 | 27107000.0 |
| 2022-04-14 | DIA | ETF | 346.71 | 348.73 | 344.25 | 344.29 | 4179600.0 |
| 2022-04-14 | GLD | ETF | 184.28 | 184.41 | 182.88 | 184.04 | 11567200.0 |
| 2022-04-14 | TLT | ETF | 122.86 | 122.93 | 120.38 | 120.75 | 34274500.0 |
| 2022-04-14 | AAA | ETF | 24.8655 | 24.8655 | 24.86 | 24.86 | 494.0 |
| 2022-04-14 | AAAU | ETF | 19.63 | 19.63 | 19.49 | 19.59 | 592400.0 |
| 2022-04-14 | AADR | ETF | 58.12 | 58.12 | 58.12 | 58.12 | 400.0 |
| 2022-04-14 | AAXJ | ETF | 73.98 | 74.01 | 73.29 | 73.29 | 1211600.0 |
| 2022-04-14 | ABEQ | ETF | 30.109 | 30.24 | 30.085 | 30.13 | 20800.0 |
| 2022-04-14 | ACES | ETF | 58.45 | 58.45 | 57.15 | 57.19 | 28100.0 |
| 2022-04-14 | ACIO | ETF | 31.18 | 31.18 | 30.93 | 31.01 | 47500.0 |
| 2022-04-14 | ACSI | ETF | 49.5639 | 49.5639 | 49.5639 | 49.5639 | 140.0 |
| 2022-04-14 | ACT | ETF | 21.63 | 22.18 | 21.63 | 22.1 | 69692.0 |
| 2022-04-14 | ACTV | ETF | 35.58 | 35.58 | 35.04 | 35.1 | 15687.0 |
| 2022-04-14 | ACTX | ETF | 1.25 | 1.25 | 0.9999 | 1.0 | 595.0 |
| 2022-04-14 | ACVF | ETF | 33.5 | 33.5 | 32.83 | 32.944 | 4500.0 |
| 2022-04-14 | ACWF | ETF | 36.42 | 36.42 | 36.0884 | 36.0884 | 4030.0 |
| 2022-04-14 | ACWI | ETF | 98.23 | 98.34 | 97.1 | 97.11 | 2237300.0 |
| 2022-04-14 | ACWV | ETF | 106.17 | 106.31 | 105.49 | 105.56 | 207400.0 |
| 2022-04-14 | ACWX | ETF | 51.53 | 51.58 | 51.1641 | 51.19 | 3454214.0 |
| 2022-04-14 | ADFI | ETF | 8.85 | 8.85 | 8.82 | 8.825 | 2400.0 |
| 2022-04-14 | ADIV | ETF | 15.377 | 15.377 | 15.377 | 15.377 | 100.0 |
| 2022-04-14 | ADME | ETF | 40.19 | 40.19 | 39.8 | 39.84 | 31900.0 |
| 2022-04-14 | ADRE | ETF | 42.96 | 42.96 | 42.04 | 42.04 | 16840.0 |
| 2022-04-14 | AEMB | ETF | 42.02 | 42.02 | 41.883 | 41.883 | 1700.0 |
| 2022-04-14 | AESR | ETF | 13.11 | 13.11 | 13.01 | 13.01 | 8600.0 |
| 2022-04-14 | AFIF | ETF | 9.21 | 9.21 | 9.17 | 9.17 | 17301.0 |
| 2022-04-14 | AFK | ETF | 21.39 | 21.43 | 21.25 | 21.28 | 7245.0 |
| 2022-04-14 | AFLG | ETF | 26.36 | 26.36 | 26.263 | 26.263 | 100.0 |
| 2022-04-14 | AFSM | ETF | 25.19 | 25.19 | 25.151 | 25.151 | 100.0 |
| 2022-04-14 | AFTY | ETF | 18.45 | 18.45 | 18.433 | 18.433 | 2900.0 |
| 2022-04-14 | AGG | ETF | 104.73 | 104.74 | 103.93 | 103.97 | 8510100.0 |
| 2022-04-14 | AGGY | ETF | 46.5 | 46.558 | 46.14 | 46.24 | 104400.0 |
| 2022-04-14 | AGNG | ETF | 28.92 | 28.92 | 28.79 | 28.79 | 900.0 |
| 2022-04-14 | AGOV | ETF | 81.98 | 81.98 | 81.71 | 81.71 | 154.0 |
| 2022-04-14 | AGOX | ETF | 23.341 | 23.46 | 23.2 | 23.209 | 17400.0 |
| 2022-04-14 | AGQ | ETF | 40.95 | 41.09 | 40.0 | 40.98 | 724700.0 |
| 2022-04-14 | AGZ | ETF | 111.59 | 111.59 | 111.015 | 111.08 | 33609.0 |
| 2022-04-14 | AGZD | ETF | 23.12 | 23.31 | 23.1 | 23.15 | 154600.0 |
| 2022-04-14 | AHHX | ETF | 9.229 | 9.245 | 9.2118 | 9.245 | 6059.0 |
| 2022-04-14 | AHYB | ETF | 46.441 | 46.441 | 46.441 | 46.441 | 200.0 |
| 2022-04-14 | AIA | ETF | 66.85 | 66.92 | 66.05 | 66.05 | 73608.0 |
| 2022-04-14 | AIEQ | ETF | 36.18 | 36.365 | 36.057 | 36.057 | 7000.0 |
| 2022-04-14 | AIQ | ETF | 25.53 | 25.53 | 24.89 | 24.91 | 24883.0 |
| 2022-04-14 | AIRR | ETF | 41.16 | 41.16 | 40.655 | 40.68 | 29500.0 |
| 2022-04-14 | AIVI | ETF | 39.87 | 39.89 | 39.77 | 39.78 | 13900.0 |
| 2022-04-14 | AIVL | ETF | 99.07 | 99.28 | 98.76 | 98.76 | 1700.0 |
| 2022-04-14 | ALTL | ETF | 45.18 | 45.32 | 44.99 | 45.01 | 47492.0 |
> showing 50 of 2,690 rows — these rows as CSV