PREVIEW / etf_daily / 2022-04-25
file: by_date/etf_daily/2022/2022-04-25.parquet size: 98 KB rows: 2,656
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-25 | SPY | ETF | 423.67 | 428.69 | 418.84 | 428.51 | 119647700.0 |
| 2022-04-25 | QQQ | ETF | 323.73 | 329.9 | 322.43 | 329.58 | 101755856.0 |
| 2022-04-25 | IWM | ETF | 190.99 | 194.11 | 189.21 | 193.85 | 35556500.0 |
| 2022-04-25 | DIA | ETF | 336.45 | 341.08 | 333.2 | 340.56 | 6806600.0 |
| 2022-04-25 | GLD | ETF | 177.17 | 177.51 | 176.48 | 177.05 | 13073700.0 |
| 2022-04-25 | TLT | ETF | 121.38 | 122.19 | 121.13 | 121.19 | 25418900.0 |
| 2022-04-25 | AAA | ETF | 24.83 | 24.8303 | 24.6 | 24.6 | 2327.0 |
| 2022-04-25 | AAAU | ETF | 18.87 | 18.9 | 18.79 | 18.86 | 1903600.0 |
| 2022-04-25 | AADR | ETF | 54.9 | 55.76 | 54.9 | 55.76 | 600.0 |
| 2022-04-25 | AAXJ | ETF | 69.36 | 70.08 | 69.15 | 69.99 | 3038200.0 |
| 2022-04-25 | ABEQ | ETF | 28.827 | 29.17 | 28.827 | 29.16 | 18200.0 |
| 2022-04-25 | ACES | ETF | 51.47 | 52.55 | 51.31 | 52.55 | 42700.0 |
| 2022-04-25 | ACIO | ETF | 30.83 | 30.83 | 30.166 | 30.55 | 73400.0 |
| 2022-04-25 | ACSI | ETF | 47.81 | 48.1715 | 47.81 | 48.1715 | 188.0 |
| 2022-04-25 | ACT | ETF | 22.97 | 23.38 | 22.53 | 23.34 | 74208.0 |
| 2022-04-25 | ACTV | ETF | 34.011 | 34.665 | 33.95 | 34.665 | 8917.0 |
| 2022-04-25 | ACTX | ETF | 0.9999 | 1.0 | 0.76 | 0.99 | 1719.0 |
| 2022-04-25 | ACVF | ETF | 32.0 | 32.111 | 31.519 | 32.1 | 4000.0 |
| 2022-04-25 | ACWF | ETF | 34.95 | 35.2 | 34.6 | 35.2 | 25136.0 |
| 2022-04-25 | ACWI | ETF | 93.62 | 94.57 | 92.76 | 94.53 | 3617900.0 |
| 2022-04-25 | ACWV | ETF | 102.03 | 103.0 | 101.46 | 102.78 | 223700.0 |
| 2022-04-25 | ACWX | ETF | 49.09 | 49.47 | 48.75 | 49.41 | 3505410.0 |
| 2022-04-25 | ADFI | ETF | 8.78 | 8.82 | 8.78 | 8.8 | 4400.0 |
| 2022-04-25 | ADIV | ETF | 14.71 | 14.82 | 14.71 | 14.82 | 600.0 |
| 2022-04-25 | ADME | ETF | 38.747 | 39.0 | 38.551 | 38.96 | 44900.0 |
| 2022-04-25 | ADRE | ETF | 39.04 | 39.65 | 38.89 | 39.65 | 3076.0 |
| 2022-04-25 | AESR | ETF | 12.6 | 12.7 | 12.48 | 12.69 | 17700.0 |
| 2022-04-25 | AFIF | ETF | 9.22 | 9.28 | 9.22 | 9.25 | 74303.0 |
| 2022-04-25 | AFK | ETF | 19.92 | 19.92 | 19.56 | 19.9 | 16332.0 |
| 2022-04-25 | AFLG | ETF | 25.38 | 25.38 | 25.38 | 25.38 | 600.0 |
| 2022-04-25 | AFMC | ETF | 23.58 | 23.58 | 23.5 | 23.5 | 500.0 |
| 2022-04-25 | AFSM | ETF | 24.272 | 24.378 | 24.123 | 24.378 | 700.0 |
| 2022-04-25 | AFTY | ETF | 16.56 | 16.56 | 16.43 | 16.48 | 1200.0 |
| 2022-04-25 | AGG | ETF | 103.47 | 103.93 | 103.47 | 103.63 | 8777500.0 |
| 2022-04-25 | AGGH | ETF | 24.0299 | 24.0299 | 24.0299 | 24.0299 | 316.0 |
| 2022-04-25 | AGGY | ETF | 45.71 | 45.95 | 45.68 | 45.75 | 268800.0 |
| 2022-04-25 | AGNG | ETF | 27.545 | 27.9 | 27.43 | 27.86 | 12300.0 |
| 2022-04-25 | AGOV | ETF | 80.3005 | 80.96 | 78.95 | 80.8 | 2402.0 |
| 2022-04-25 | AGOX | ETF | 22.33 | 22.54 | 22.0 | 22.54 | 93500.0 |
| 2022-04-25 | AGQ | ETF | 34.32 | 34.86 | 33.92 | 34.61 | 987300.0 |
| 2022-04-25 | AGZ | ETF | 110.89 | 111.129 | 110.75 | 110.75 | 25695.0 |
| 2022-04-25 | AGZD | ETF | 23.05 | 23.08 | 22.97 | 22.97 | 145400.0 |
| 2022-04-25 | AHHX | ETF | 9.21 | 9.22 | 9.19 | 9.191 | 1710.0 |
| 2022-04-25 | AHYB | ETF | 45.97 | 45.99 | 45.97 | 45.99 | 900.0 |
| 2022-04-25 | AIA | ETF | 62.11 | 62.89 | 61.81 | 62.89 | 37150.0 |
| 2022-04-25 | AIEQ | ETF | 34.68 | 35.185 | 34.382 | 35.185 | 9400.0 |
| 2022-04-25 | AIQ | ETF | 23.48 | 24.0 | 23.461 | 24.0 | 27661.0 |
| 2022-04-25 | AIRR | ETF | 39.58 | 39.76 | 38.801 | 39.711 | 28800.0 |
| 2022-04-25 | AIVI | ETF | 38.68 | 39.04 | 38.57 | 39.0 | 23500.0 |
| 2022-04-25 | AIVL | ETF | 96.79 | 97.71 | 95.93 | 97.7 | 4800.0 |
> showing 50 of 2,656 rows — these rows as CSV