PREVIEW / etf_daily / 2022-12-15
file: by_date/etf_daily/2022/2022-12-15.parquet size: 107 KB rows: 2,890
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-15 | SPY | ETF | 394.3 | 395.25 | 387.89 | 389.63 | 117705900.0 |
| 2022-12-15 | QQQ | ETF | 282.33 | 283.01 | 275.67 | 276.89 | 60554119.0 |
| 2022-12-15 | IWM | ETF | 178.03 | 178.6 | 175.04 | 175.68 | 33546700.0 |
| 2022-12-15 | DIA | ETF | 336.58 | 337.37 | 330.78 | 332.8 | 5865600.0 |
| 2022-12-15 | GLD | ETF | 165.73 | 166.21 | 165.1 | 165.35 | 8363000.0 |
| 2022-12-15 | TLT | ETF | 108.39 | 109.12 | 108.16 | 108.32 | 20246200.0 |
| 2022-12-15 | AAA | ETF | 24.38 | 24.38 | 24.38 | 24.38 | 9.0 |
| 2022-12-15 | AAAU | ETF | 17.68 | 17.72 | 17.61 | 17.63 | 224200.0 |
| 2022-12-15 | AADR | ETF | 47.54 | 47.65 | 47.46 | 47.59 | 1600.0 |
| 2022-12-15 | AAPB | ETF | 17.74 | 17.74 | 16.9599 | 16.96 | 2557.0 |
| 2022-12-15 | AAPD | ETF | 28.029 | 29.02 | 27.93 | 28.94 | 156698.0 |
| 2022-12-15 | AAPU | ETF | 19.09 | 19.21 | 18.0563 | 18.16 | 91659.0 |
| 2022-12-15 | AAXJ | ETF | 66.06 | 66.17 | 64.78 | 64.88 | 833700.0 |
| 2022-12-15 | ABEQ | ETF | 27.82 | 27.86 | 27.73 | 27.74 | 5300.0 |
| 2022-12-15 | ACES | ETF | 51.96 | 52.749 | 51.01 | 51.07 | 77600.0 |
| 2022-12-15 | ACIO | ETF | 29.425 | 29.425 | 29.13 | 29.31 | 110300.0 |
| 2022-12-15 | ACSI | ETF | 42.7806 | 42.7806 | 42.7806 | 42.7806 | 14.0 |
| 2022-12-15 | ACT | ETF | 23.83 | 23.83 | 23.44 | 23.61 | 108654.0 |
| 2022-12-15 | ACTV | ETF | 29.9 | 29.929 | 29.6 | 29.63 | 10635.0 |
| 2022-12-15 | ACVF | ETF | 30.63 | 30.63 | 30.08 | 30.168 | 2800.0 |
| 2022-12-15 | ACWF | ETF | 32.21 | 32.21 | 31.9724 | 32.013 | 2603.0 |
| 2022-12-15 | ACWI | ETF | 86.87 | 87.03 | 85.42 | 85.75 | 3598200.0 |
| 2022-12-15 | ACWV | ETF | 96.4 | 96.4 | 95.05 | 95.26 | 785400.0 |
| 2022-12-15 | ACWX | ETF | 46.26 | 46.3 | 45.48 | 45.62 | 3523244.0 |
| 2022-12-15 | ADFI | ETF | 8.49 | 8.51 | 8.48 | 8.5 | 3500.0 |
| 2022-12-15 | ADIV | ETF | 13.06 | 13.06 | 13.06 | 13.06 | 200.0 |
| 2022-12-15 | ADME | ETF | 34.36 | 34.37 | 34.2 | 34.295 | 179700.0 |
| 2022-12-15 | ADPV | ETF | 25.1001 | 25.14 | 25.1 | 25.13 | 21219.0 |
| 2022-12-15 | ADRE | ETF | 38.81 | 38.81 | 37.7 | 37.9655 | 4213.0 |
| 2022-12-15 | AEMB | ETF | 38.25 | 38.25 | 38.135 | 38.135 | 800.0 |
| 2022-12-15 | AESR | ETF | 11.74 | 11.74 | 11.54 | 11.57 | 8000.0 |
| 2022-12-15 | AFIF | ETF | 8.82 | 8.85 | 8.82 | 8.84 | 15196.0 |
| 2022-12-15 | AFK | ETF | 17.03 | 17.03 | 16.55 | 16.7 | 8456.0 |
| 2022-12-15 | AFMC | ETF | 22.464 | 22.464 | 22.464 | 22.464 | 100.0 |
| 2022-12-15 | AFSM | ETF | 22.845 | 22.845 | 22.845 | 22.845 | 100.0 |
| 2022-12-15 | AFTY | ETF | 16.17 | 16.186 | 16.17 | 16.186 | 100.0 |
| 2022-12-15 | AGG | ETF | 99.57 | 99.7 | 99.37 | 99.61 | 9423900.0 |
| 2022-12-15 | AGGH | ETF | 22.8901 | 22.9494 | 22.8901 | 22.9494 | 100.0 |
| 2022-12-15 | AGGY | ETF | 43.95 | 44.005 | 43.86 | 43.97 | 100200.0 |
| 2022-12-15 | AGNG | ETF | 26.71 | 26.71 | 26.32 | 26.32 | 1600.0 |
| 2022-12-15 | AGOV | ETF | 79.49 | 80.9434 | 79.49 | 80.9434 | 100.0 |
| 2022-12-15 | AGOX | ETF | 20.95 | 20.992 | 20.69 | 20.742 | 13300.0 |
| 2022-12-15 | AGQ | ETF | 30.42 | 30.8 | 29.56 | 29.88 | 1277600.0 |
| 2022-12-15 | AGZ | ETF | 107.275 | 107.44 | 107.21 | 107.37 | 35494.0 |
| 2022-12-15 | AGZD | ETF | 21.86 | 21.875 | 21.755 | 21.845 | 149800.0 |
| 2022-12-15 | AHHX | ETF | 8.569 | 8.58 | 8.5 | 8.546 | 7830.0 |
| 2022-12-15 | AHYB | ETF | 43.616 | 43.616 | 43.616 | 43.616 | 300.0 |
| 2022-12-15 | AIA | ETF | 57.73 | 58.01 | 56.36 | 56.48 | 63764.0 |
| 2022-12-15 | AIEQ | ETF | 29.685 | 29.695 | 29.32 | 29.394 | 8600.0 |
| 2022-12-15 | AIQ | ETF | 21.12 | 21.12 | 20.58 | 20.59 | 5695.0 |
> showing 50 of 2,890 rows — these rows as CSV