PREVIEW / etf_daily / 2022-12-22
file: by_date/etf_daily/2022/2022-12-22.parquet size: 107 KB rows: 2,904
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-12-22 | SPY | ETF | 383.05 | 386.21 | 374.77 | 380.72 | 100120900.0 |
| 2022-12-22 | QQQ | ETF | 270.38 | 270.5149 | 262.455 | 266.76 | 60278377.0 |
| 2022-12-22 | IWM | ETF | 174.33 | 174.49 | 170.67 | 173.6 | 21297600.0 |
| 2022-12-22 | DIA | ETF | 331.5 | 331.85 | 325.65 | 330.26 | 4876900.0 |
| 2022-12-22 | GLD | ETF | 167.76 | 167.76 | 166.06 | 166.76 | 5672700.0 |
| 2022-12-22 | TLT | ETF | 103.67 | 104.12 | 103.38 | 103.68 | 11322500.0 |
| 2022-12-22 | AAA | ETF | 24.39 | 24.39 | 24.39 | 24.39 | 5.0 |
| 2022-12-22 | AAAU | ETF | 17.9 | 17.9 | 17.71 | 17.78 | 598800.0 |
| 2022-12-22 | AADR | ETF | 47.87 | 48.45 | 47.77 | 48.45 | 2900.0 |
| 2022-12-22 | AAPB | ETF | 15.94 | 15.98 | 15.57 | 15.98 | 5636.0 |
| 2022-12-22 | AAPD | ETF | 29.29 | 30.1299 | 29.247 | 29.71 | 324484.0 |
| 2022-12-22 | AAPU | ETF | 17.55 | 17.5864 | 16.7741 | 17.16 | 129332.0 |
| 2022-12-22 | AAXJ | ETF | 65.12 | 65.17 | 64.15 | 64.62 | 558000.0 |
| 2022-12-22 | ABEQ | ETF | 27.86 | 27.87 | 27.72 | 27.87 | 3800.0 |
| 2022-12-22 | ACES | ETF | 48.15 | 48.15 | 45.91 | 46.75 | 168300.0 |
| 2022-12-22 | ACIO | ETF | 28.81 | 28.9 | 28.61 | 28.84 | 83700.0 |
| 2022-12-22 | ACSI | ETF | 41.54 | 41.6784 | 41.54 | 41.6784 | 101.0 |
| 2022-12-22 | ACT | ETF | 24.52 | 24.52 | 23.805 | 23.91 | 82218.0 |
| 2022-12-22 | ACTV | ETF | 28.54 | 28.793 | 28.27 | 28.793 | 20078.0 |
| 2022-12-22 | ACTX | ETF | 0.4014 | 0.4014 | 0.4014 | 0.4014 | 223.0 |
| 2022-12-22 | ACVF | ETF | 29.5 | 29.62 | 29.45 | 29.618 | 3400.0 |
| 2022-12-22 | ACWF | ETF | 31.64 | 31.64 | 31.22 | 31.5495 | 50314.0 |
| 2022-12-22 | ACWI | ETF | 85.15 | 85.19 | 83.59 | 84.67 | 5524900.0 |
| 2022-12-22 | ACWV | ETF | 95.08 | 95.08 | 94.11 | 94.92 | 339500.0 |
| 2022-12-22 | ACWX | ETF | 45.71 | 45.71 | 45.09 | 45.46 | 2235327.0 |
| 2022-12-22 | ADFI | ETF | 8.401 | 8.42 | 8.36 | 8.405 | 254400.0 |
| 2022-12-22 | ADIV | ETF | 12.937 | 12.937 | 12.937 | 12.937 | 200.0 |
| 2022-12-22 | ADME | ETF | 33.86 | 33.87 | 33.74 | 33.83 | 23200.0 |
| 2022-12-22 | ADPV | ETF | 25.1 | 25.11 | 25.05 | 25.07 | 28495.0 |
| 2022-12-22 | ADRE | ETF | 37.96 | 37.96 | 37.21 | 37.29 | 6475.0 |
| 2022-12-22 | AEMB | ETF | 39.21 | 39.21 | 37.868 | 37.925 | 300.0 |
| 2022-12-22 | AESR | ETF | 11.45 | 11.58 | 11.26 | 11.4 | 2358600.0 |
| 2022-12-22 | AFIF | ETF | 8.805 | 8.82 | 8.8 | 8.805 | 18555.0 |
| 2022-12-22 | AFK | ETF | 16.29 | 16.29 | 16.02 | 16.08 | 14176.0 |
| 2022-12-22 | AFLG | ETF | 22.95 | 23.239 | 22.95 | 23.239 | 100.0 |
| 2022-12-22 | AFMC | ETF | 21.93 | 22.251 | 21.93 | 22.251 | 100.0 |
| 2022-12-22 | AFSM | ETF | 22.5 | 22.784 | 22.5 | 22.784 | 300.0 |
| 2022-12-22 | AFTY | ETF | 15.438 | 15.438 | 15.438 | 15.438 | 100.0 |
| 2022-12-22 | AGG | ETF | 98.32 | 98.47 | 98.22 | 98.31 | 8267800.0 |
| 2022-12-22 | AGGH | ETF | 22.7899 | 22.7899 | 22.7456 | 22.7456 | 239.0 |
| 2022-12-22 | AGGY | ETF | 43.32 | 43.39 | 43.31 | 43.34 | 163400.0 |
| 2022-12-22 | AGNG | ETF | 26.08 | 26.226 | 25.67 | 26.226 | 4000.0 |
| 2022-12-22 | AGOV | ETF | 81.0 | 81.5 | 81.0 | 81.5 | 370.0 |
| 2022-12-22 | AGOX | ETF | 20.62 | 20.62 | 20.15 | 20.42 | 147400.0 |
| 2022-12-22 | AGQ | ETF | 30.92 | 31.29 | 30.47 | 30.96 | 867500.0 |
| 2022-12-22 | AGZ | ETF | 107.23 | 107.38 | 107.17 | 107.17 | 27560.0 |
| 2022-12-22 | AGZD | ETF | 21.87 | 21.87 | 21.76 | 21.845 | 559400.0 |
| 2022-12-22 | AHHX | ETF | 8.422 | 8.422 | 8.33 | 8.3951 | 848800.0 |
| 2022-12-22 | AHYB | ETF | 43.3 | 43.3 | 43.192 | 43.196 | 400.0 |
| 2022-12-22 | AIA | ETF | 57.16 | 57.27 | 56.27 | 56.66 | 30788.0 |
> showing 50 of 2,904 rows — these rows as CSV