PREVIEW / etf_daily / 2022-04-07
file: by_date/etf_daily/2022/2022-04-07.parquet size: 101 KB rows: 2,693
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-07 | SPY | ETF | 445.59 | 450.69 | 443.53 | 448.77 | 78097200.0 |
| 2022-04-07 | QQQ | ETF | 352.24 | 356.35 | 348.69 | 354.1 | 63777373.0 |
| 2022-04-07 | IWM | ETF | 200.11 | 201.23 | 196.68 | 199.46 | 29291200.0 |
| 2022-04-07 | DIA | ETF | 343.77 | 347.1 | 341.89 | 345.97 | 4599900.0 |
| 2022-04-07 | GLD | ETF | 179.87 | 180.88 | 179.8 | 180.34 | 10140600.0 |
| 2022-04-07 | TLT | ETF | 126.11 | 126.67 | 125.41 | 126.49 | 23458800.0 |
| 2022-04-07 | AAA | ETF | 24.82 | 24.835 | 24.8 | 24.835 | 3686.0 |
| 2022-04-07 | AAAU | ETF | 19.16 | 19.26 | 19.15 | 19.19 | 348900.0 |
| 2022-04-07 | AADR | ETF | 58.11 | 58.44 | 58.11 | 58.44 | 900.0 |
| 2022-04-07 | AAXJ | ETF | 74.87 | 75.02 | 74.28 | 74.68 | 1894900.0 |
| 2022-04-07 | ABEQ | ETF | 29.75 | 29.95 | 29.742 | 29.92 | 8900.0 |
| 2022-04-07 | ACES | ETF | 60.86 | 61.23 | 59.04 | 60.45 | 203400.0 |
| 2022-04-07 | ACIO | ETF | 31.24 | 31.487 | 31.21 | 31.43 | 14200.0 |
| 2022-04-07 | ACSI | ETF | 49.9072 | 49.9072 | 49.9072 | 49.9072 | 76.0 |
| 2022-04-07 | ACT | ETF | 21.25 | 21.985 | 20.76 | 21.03 | 93038.0 |
| 2022-04-07 | ACTV | ETF | 35.43 | 35.43 | 34.88 | 35.2873 | 12735.0 |
| 2022-04-07 | ACTX | ETF | 0.885 | 1.0 | 0.885 | 1.0 | 261.0 |
| 2022-04-07 | ACVF | ETF | 33.52 | 33.795 | 33.35 | 33.687 | 2400.0 |
| 2022-04-07 | ACWF | ETF | 36.35 | 36.66 | 36.21 | 36.5343 | 4252.0 |
| 2022-04-07 | ACWI | ETF | 98.65 | 99.44 | 98.05 | 99.01 | 4303700.0 |
| 2022-04-07 | ACWV | ETF | 105.84 | 106.99 | 105.84 | 106.7 | 112400.0 |
| 2022-04-07 | ACWX | ETF | 51.74 | 51.95 | 51.38 | 51.79 | 3223540.0 |
| 2022-04-07 | ADFI | ETF | 8.92 | 8.92 | 8.915 | 8.915 | 1800.0 |
| 2022-04-07 | ADIV | ETF | 15.51 | 15.51 | 15.46 | 15.5 | 600.0 |
| 2022-04-07 | ADME | ETF | 40.453 | 40.728 | 40.289 | 40.554 | 70900.0 |
| 2022-04-07 | ADRE | ETF | 43.1497 | 43.69 | 43.0 | 43.6 | 5522.0 |
| 2022-04-07 | AEMB | ETF | 42.786 | 42.786 | 42.786 | 42.786 | 100.0 |
| 2022-04-07 | AESR | ETF | 13.03 | 13.24 | 13.03 | 13.17 | 7200.0 |
| 2022-04-07 | AFIF | ETF | 9.26 | 9.265 | 9.24 | 9.255 | 19994.0 |
| 2022-04-07 | AFK | ETF | 21.01 | 21.15 | 21.01 | 21.115 | 12317.0 |
| 2022-04-07 | AFLG | ETF | 26.678 | 26.678 | 26.678 | 26.678 | 100.0 |
| 2022-04-07 | AFTY | ETF | 18.36 | 18.36 | 18.319 | 18.319 | 200.0 |
| 2022-04-07 | AGG | ETF | 105.38 | 105.51 | 105.13 | 105.26 | 7922500.0 |
| 2022-04-07 | AGGY | ETF | 47.0 | 47.1 | 46.94 | 46.98 | 251200.0 |
| 2022-04-07 | AGNG | ETF | 29.26 | 29.515 | 29.13 | 29.49 | 3000.0 |
| 2022-04-07 | AGOV | ETF | 83.1 | 83.1 | 83.0 | 83.035 | 578.0 |
| 2022-04-07 | AGOX | ETF | 23.33 | 23.52 | 23.138 | 23.42 | 382700.0 |
| 2022-04-07 | AGQ | ETF | 36.78 | 37.95 | 36.65 | 37.69 | 553700.0 |
| 2022-04-07 | AGZ | ETF | 111.36 | 111.46 | 111.28 | 111.37 | 31454.0 |
| 2022-04-07 | AGZD | ETF | 23.245 | 23.275 | 23.215 | 23.235 | 709400.0 |
| 2022-04-07 | AHHX | ETF | 9.34 | 9.39 | 9.33 | 9.365 | 460791.0 |
| 2022-04-07 | AHYB | ETF | 46.9 | 46.9 | 46.74 | 46.741 | 700.0 |
| 2022-04-07 | AIA | ETF | 68.01 | 68.09 | 67.3414 | 67.59 | 46370.0 |
| 2022-04-07 | AIEQ | ETF | 36.14 | 36.46 | 35.8 | 36.299 | 7300.0 |
| 2022-04-07 | AIQ | ETF | 26.19 | 26.28 | 25.71 | 26.15 | 230174.0 |
| 2022-04-07 | AIRR | ETF | 40.87 | 40.96 | 40.29 | 40.76 | 106700.0 |
| 2022-04-07 | AIVI | ETF | 39.66 | 39.83 | 39.49 | 39.73 | 3400.0 |
| 2022-04-07 | AIVL | ETF | 98.99 | 99.79 | 98.8 | 99.6 | 3200.0 |
| 2022-04-07 | ALTL | ETF | 45.15 | 45.42 | 44.8676 | 45.29 | 194486.0 |
| 2022-04-07 | ALTY | ETF | 12.825 | 12.87 | 12.78 | 12.83 | 17600.0 |
> showing 50 of 2,693 rows — these rows as CSV