PREVIEW / etf_daily / 2022-10-06
file: by_date/etf_daily/2022/2022-10-06.parquet size: 104 KB rows: 2,813
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-10-06 | SPY | ETF | 375.62 | 378.72 | 372.68 | 373.2 | 82333500.0 |
| 2022-10-06 | QQQ | ETF | 280.96 | 284.18 | 279.43 | 279.76 | 53489411.0 |
| 2022-10-06 | IWM | ETF | 173.85 | 176.17 | 172.91 | 173.72 | 22635900.0 |
| 2022-10-06 | DIA | ETF | 301.47 | 303.31 | 298.61 | 299.23 | 3081700.0 |
| 2022-10-06 | GLD | ETF | 159.41 | 159.94 | 158.95 | 159.63 | 5712600.0 |
| 2022-10-06 | TLT | ETF | 102.59 | 102.84 | 101.53 | 101.98 | 13965700.0 |
| 2022-10-06 | AAA | ETF | 24.11 | 24.11 | 24.11 | 24.11 | 14.0 |
| 2022-10-06 | AAAU | ETF | 16.99 | 17.03 | 16.95 | 17.02 | 85200.0 |
| 2022-10-06 | AADR | ETF | 46.23 | 46.23 | 45.88 | 45.96 | 3600.0 |
| 2022-10-06 | AAPB | ETF | 19.94 | 19.94 | 19.66 | 19.66 | 1017.0 |
| 2022-10-06 | AAPD | ETF | 27.82 | 27.98 | 27.605 | 27.98 | 81225.0 |
| 2022-10-06 | AAPU | ETF | 20.44 | 20.8 | 20.34 | 20.43 | 24186.0 |
| 2022-10-06 | AAXJ | ETF | 60.97 | 61.32 | 60.75 | 60.76 | 628600.0 |
| 2022-10-06 | ABEQ | ETF | 26.06 | 26.06 | 25.671 | 25.73 | 8000.0 |
| 2022-10-06 | ACES | ETF | 56.65 | 57.8 | 55.22 | 55.42 | 146700.0 |
| 2022-10-06 | ACIO | ETF | 28.81 | 28.949 | 28.81 | 28.84 | 31100.0 |
| 2022-10-06 | ACSI | ETF | 42.7284 | 42.7284 | 42.7284 | 42.7284 | 20.0 |
| 2022-10-06 | ACT | ETF | 23.29 | 23.55 | 23.05 | 23.47 | 144657.0 |
| 2022-10-06 | ACTV | ETF | 28.02 | 28.15 | 27.92 | 28.041 | 4702.0 |
| 2022-10-06 | ACTX | ETF | 0.45 | 0.5 | 0.33 | 0.5 | 6199.0 |
| 2022-10-06 | ACVF | ETF | 28.43 | 28.43 | 28.11 | 28.149 | 2800.0 |
| 2022-10-06 | ACWF | ETF | 30.78 | 30.8 | 30.61 | 30.6384 | 5239.0 |
| 2022-10-06 | ACWI | ETF | 81.58 | 82.13 | 80.96 | 81.08 | 2955500.0 |
| 2022-10-06 | ACWV | ETF | 90.97 | 91.28 | 90.15 | 90.29 | 283600.0 |
| 2022-10-06 | ACWX | ETF | 41.69 | 41.84 | 41.34 | 41.39 | 3034830.0 |
| 2022-10-06 | ADFI | ETF | 8.27 | 8.27 | 8.265 | 8.265 | 1700.0 |
| 2022-10-06 | ADIV | ETF | 12.185 | 12.185 | 12.185 | 12.185 | 100.0 |
| 2022-10-06 | ADME | ETF | 33.52 | 33.94 | 33.52 | 33.73 | 67500.0 |
| 2022-10-06 | ADRE | ETF | 36.6 | 36.81 | 36.465 | 36.52 | 7305.0 |
| 2022-10-06 | AEMB | ETF | 35.98 | 35.98 | 35.875 | 35.875 | 100.0 |
| 2022-10-06 | AESR | ETF | 11.04 | 11.14 | 11.02 | 11.07 | 12100.0 |
| 2022-10-06 | AFIF | ETF | 8.67 | 8.71 | 8.66 | 8.6801 | 21669.0 |
| 2022-10-06 | AFK | ETF | 15.5 | 15.69 | 15.44 | 15.44 | 2829.0 |
| 2022-10-06 | AFLG | ETF | 22.61 | 22.61 | 22.46 | 22.497 | 300.0 |
| 2022-10-06 | AFMC | ETF | 21.28 | 21.28 | 21.195 | 21.195 | 100.0 |
| 2022-10-06 | AFSM | ETF | 21.912 | 22.0 | 21.9 | 21.9 | 1100.0 |
| 2022-10-06 | AFTY | ETF | 16.22 | 16.22 | 16.149 | 16.149 | 600.0 |
| 2022-10-06 | AGG | ETF | 96.59 | 96.71 | 96.21 | 96.28 | 5625100.0 |
| 2022-10-06 | AGGY | ETF | 42.47 | 42.49 | 42.16 | 42.307 | 1164700.0 |
| 2022-10-06 | AGNG | ETF | 24.117 | 24.117 | 24.117 | 24.117 | 100.0 |
| 2022-10-06 | AGOV | ETF | 77.23 | 78.36 | 77.23 | 78.275 | 201.0 |
| 2022-10-06 | AGOX | ETF | 20.305 | 20.34 | 20.122 | 20.194 | 18500.0 |
| 2022-10-06 | AGQ | ETF | 24.06 | 24.54 | 23.76 | 24.46 | 1217600.0 |
| 2022-10-06 | AGZ | ETF | 106.46 | 106.565 | 106.315 | 106.32 | 17669.0 |
| 2022-10-06 | AGZD | ETF | 22.9 | 22.905 | 22.81 | 22.85 | 130600.0 |
| 2022-10-06 | AHHX | ETF | 8.31 | 8.31 | 8.27 | 8.2994 | 1581.0 |
| 2022-10-06 | AHYB | ETF | 42.47 | 42.558 | 42.436 | 42.436 | 700.0 |
| 2022-10-06 | AIA | ETF | 52.82 | 53.12 | 52.62 | 52.75 | 91321.0 |
| 2022-10-06 | AIEQ | ETF | 31.0 | 31.38 | 30.78 | 30.881 | 5600.0 |
| 2022-10-06 | AIQ | ETF | 20.22 | 20.45 | 20.13 | 20.13 | 19366.0 |
> showing 50 of 2,813 rows — these rows as CSV