PREVIEW / etf_daily / 2022-04-26
file: by_date/etf_daily/2022/2022-04-26.parquet size: 101 KB rows: 2,720
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-26 | SPY | ETF | 425.83 | 426.04 | 416.07 | 416.1 | 103996300.0 |
| 2022-04-26 | QQQ | ETF | 327.47 | 327.66 | 316.855 | 317.14 | 105819629.0 |
| 2022-04-26 | IWM | ETF | 192.32 | 192.71 | 187.48 | 187.74 | 40513600.0 |
| 2022-04-26 | DIA | ETF | 338.03 | 339.05 | 332.27 | 332.45 | 7619800.0 |
| 2022-04-26 | GLD | ETF | 177.95 | 178.3 | 176.92 | 177.32 | 9042400.0 |
| 2022-04-26 | TLT | ETF | 122.44 | 123.03 | 121.76 | 122.41 | 26931300.0 |
| 2022-04-26 | AAA | ETF | 24.8452 | 24.855 | 24.8452 | 24.855 | 528.0 |
| 2022-04-26 | AAAU | ETF | 18.94 | 18.99 | 18.84 | 18.87 | 707800.0 |
| 2022-04-26 | AADR | ETF | 55.0 | 55.0 | 54.19 | 54.32 | 24900.0 |
| 2022-04-26 | AAXJ | ETF | 69.53 | 69.65 | 68.5 | 68.5 | 2357500.0 |
| 2022-04-26 | ABEQ | ETF | 29.13 | 29.13 | 28.772 | 28.772 | 5100.0 |
| 2022-04-26 | ACES | ETF | 52.25 | 52.25 | 50.472 | 50.53 | 43400.0 |
| 2022-04-26 | ACIO | ETF | 30.23 | 30.373 | 30.15 | 30.153 | 98000.0 |
| 2022-04-26 | ACSI | ETF | 46.57 | 46.57 | 46.57 | 46.57 | 13.0 |
| 2022-04-26 | ACT | ETF | 23.04 | 23.525 | 23.02 | 23.22 | 77090.0 |
| 2022-04-26 | ACTV | ETF | 34.3 | 34.3 | 33.59 | 33.6294 | 11383.0 |
| 2022-04-26 | ACTX | ETF | 0.755 | 1.0 | 0.755 | 1.0 | 1293.0 |
| 2022-04-26 | ACVF | ETF | 32.12 | 32.12 | 31.375 | 31.375 | 3600.0 |
| 2022-04-26 | ACWF | ETF | 35.0 | 35.1 | 34.475 | 34.475 | 46447.0 |
| 2022-04-26 | ACWI | ETF | 93.91 | 93.92 | 91.89 | 91.92 | 3346500.0 |
| 2022-04-26 | ACWV | ETF | 102.31 | 102.69 | 101.14 | 101.14 | 297100.0 |
| 2022-04-26 | ACWX | ETF | 49.05 | 49.065 | 48.14 | 48.14 | 3925323.0 |
| 2022-04-26 | ADFI | ETF | 8.82 | 8.82 | 8.79 | 8.81 | 8200.0 |
| 2022-04-26 | ADIV | ETF | 14.62 | 14.62 | 14.54 | 14.54 | 1100.0 |
| 2022-04-26 | ADME | ETF | 38.77 | 38.77 | 38.43 | 38.43 | 31200.0 |
| 2022-04-26 | ADRE | ETF | 38.96 | 38.9917 | 38.71 | 38.71 | 3201.0 |
| 2022-04-26 | AESR | ETF | 12.57 | 12.6 | 12.31 | 12.31 | 27800.0 |
| 2022-04-26 | AFIF | ETF | 9.22 | 9.23 | 9.2 | 9.22 | 22952.0 |
| 2022-04-26 | AFK | ETF | 19.91 | 19.94 | 19.4 | 19.43 | 6311.0 |
| 2022-04-26 | AFLG | ETF | 25.258 | 25.258 | 25.258 | 25.258 | 100.0 |
| 2022-04-26 | AFMC | ETF | 23.73 | 23.73 | 23.464 | 23.464 | 1000.0 |
| 2022-04-26 | AFSM | ETF | 23.929 | 23.929 | 23.929 | 23.929 | 100.0 |
| 2022-04-26 | AFTY | ETF | 16.56 | 16.568 | 16.46 | 16.475 | 6500.0 |
| 2022-04-26 | AGG | ETF | 104.13 | 104.13 | 103.8 | 103.95 | 8535100.0 |
| 2022-04-26 | AGGY | ETF | 46.03 | 46.04 | 45.88 | 46.01 | 141000.0 |
| 2022-04-26 | AGNG | ETF | 27.66 | 27.67 | 27.0 | 27.0 | 13700.0 |
| 2022-04-26 | AGOV | ETF | 79.51 | 80.2385 | 79.49 | 80.2385 | 667.0 |
| 2022-04-26 | AGOX | ETF | 22.34 | 22.34 | 21.985 | 21.985 | 279500.0 |
| 2022-04-26 | AGQ | ETF | 34.56 | 34.84 | 33.75 | 33.92 | 874900.0 |
| 2022-04-26 | AGZ | ETF | 111.17 | 111.2082 | 110.99 | 111.15 | 32131.0 |
| 2022-04-26 | AGZD | ETF | 23.02 | 23.15 | 22.94 | 22.995 | 93200.0 |
| 2022-04-26 | AHHX | ETF | 9.2068 | 9.2068 | 9.191 | 9.2 | 1640.0 |
| 2022-04-26 | AHYB | ETF | 46.06 | 46.121 | 46.038 | 46.038 | 400.0 |
| 2022-04-26 | AIA | ETF | 62.34 | 62.44 | 61.37 | 61.37 | 65500.0 |
| 2022-04-26 | AIEQ | ETF | 34.92 | 34.92 | 34.2 | 34.239 | 6400.0 |
| 2022-04-26 | AIQ | ETF | 23.81 | 23.81 | 23.06 | 23.06 | 224950.0 |
| 2022-04-26 | AIRR | ETF | 39.36 | 39.58 | 38.64 | 38.721 | 99000.0 |
| 2022-04-26 | AIVI | ETF | 38.62 | 38.63 | 38.15 | 38.17 | 28000.0 |
| 2022-04-26 | AIVL | ETF | 97.17 | 97.17 | 95.8 | 95.8 | 6100.0 |
| 2022-04-26 | ALTL | ETF | 44.6 | 44.79 | 44.07 | 44.08 | 79043.0 |
> showing 50 of 2,720 rows — these rows as CSV