PREVIEW / etf_daily / 2022-11-08
file: by_date/etf_daily/2022/2022-11-08.parquet size: 106 KB rows: 2,872
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-11-08 | SPY | ETF | 381.11 | 385.12 | 377.72 | 382.0 | 84641100.0 |
| 2022-11-08 | QQQ | ETF | 269.14 | 272.85 | 265.52 | 269.54 | 63213785.0 |
| 2022-11-08 | IWM | ETF | 180.23 | 181.95 | 177.36 | 179.56 | 20265200.0 |
| 2022-11-08 | DIA | ETF | 329.47 | 333.56 | 328.29 | 331.71 | 6349000.0 |
| 2022-11-08 | GLD | ETF | 155.99 | 159.87 | 155.98 | 159.45 | 11299600.0 |
| 2022-11-08 | TLT | ETF | 93.8 | 94.96 | 93.77 | 94.3 | 20360600.0 |
| 2022-11-08 | AAA | ETF | 24.125 | 24.125 | 24.125 | 24.125 | 20.0 |
| 2022-11-08 | AAAU | ETF | 16.64 | 17.04 | 16.63 | 16.99 | 3309300.0 |
| 2022-11-08 | AADR | ETF | 48.65 | 48.86 | 48.14 | 48.49 | 11000.0 |
| 2022-11-08 | AAPB | ETF | 17.9 | 18.35 | 17.67 | 17.9376 | 3072.0 |
| 2022-11-08 | AAPD | ETF | 28.54 | 29.09 | 28.3027 | 28.697 | 130693.0 |
| 2022-11-08 | AAPU | ETF | 19.15 | 19.3455 | 18.581 | 18.98 | 100158.0 |
| 2022-11-08 | AAXJ | ETF | 59.69 | 60.33 | 59.53 | 60.07 | 661400.0 |
| 2022-11-08 | ABEQ | ETF | 27.31 | 27.317 | 27.275 | 27.285 | 2100.0 |
| 2022-11-08 | ACES | ETF | 53.05 | 54.053 | 52.57 | 53.435 | 48100.0 |
| 2022-11-08 | ACIO | ETF | 29.155 | 29.41 | 29.1 | 29.29 | 84400.0 |
| 2022-11-08 | ACSI | ETF | 42.68 | 42.7554 | 42.68 | 42.7554 | 1673.0 |
| 2022-11-08 | ACT | ETF | 25.91 | 26.13 | 25.56 | 25.89 | 178964.0 |
| 2022-11-08 | ACTV | ETF | 28.96 | 29.48 | 28.9 | 29.29 | 5371.0 |
| 2022-11-08 | ACTX | ETF | 0.45 | 0.45 | 0.45 | 0.45 | 3067.0 |
| 2022-11-08 | ACVF | ETF | 29.4 | 29.59 | 29.15 | 29.387 | 6300.0 |
| 2022-11-08 | ACWF | ETF | 32.1 | 32.1 | 31.65 | 31.9437 | 5978.0 |
| 2022-11-08 | ACWI | ETF | 83.15 | 84.07 | 82.67 | 83.43 | 5007300.0 |
| 2022-11-08 | ACWV | ETF | 92.79 | 93.96 | 92.73 | 93.46 | 345000.0 |
| 2022-11-08 | ACWX | ETF | 43.11 | 43.55 | 42.99 | 43.33 | 4096833.0 |
| 2022-11-08 | ADFI | ETF | 8.18 | 8.21 | 8.17 | 8.185 | 2300.0 |
| 2022-11-08 | ADIV | ETF | 11.88 | 11.88 | 11.831 | 11.831 | 300.0 |
| 2022-11-08 | ADME | ETF | 34.17 | 34.45 | 34.12 | 34.341 | 59900.0 |
| 2022-11-08 | ADPV | ETF | 25.07 | 25.08 | 25.06 | 25.065 | 23131.0 |
| 2022-11-08 | ADRE | ETF | 34.25 | 34.6579 | 34.25 | 34.57 | 6441.0 |
| 2022-11-08 | AEMB | ETF | 35.74 | 35.74 | 35.74 | 35.74 | 100.0 |
| 2022-11-08 | AESR | ETF | 11.42 | 11.56 | 11.37 | 11.46 | 17600.0 |
| 2022-11-08 | AFIF | ETF | 8.69 | 8.69 | 8.65 | 8.66 | 39262.0 |
| 2022-11-08 | AFK | ETF | 15.94 | 16.41 | 15.94 | 16.31 | 6143.0 |
| 2022-11-08 | AFLG | ETF | 23.405 | 23.405 | 23.405 | 23.405 | 100.0 |
| 2022-11-08 | AFSM | ETF | 23.11 | 23.15 | 23.041 | 23.046 | 500.0 |
| 2022-11-08 | AFTY | ETF | 14.3 | 14.334 | 14.3 | 14.334 | 1800.0 |
| 2022-11-08 | AGG | ETF | 94.24 | 94.61 | 94.22 | 94.44 | 5834900.0 |
| 2022-11-08 | AGGY | ETF | 41.32 | 41.485 | 41.32 | 41.4 | 118000.0 |
| 2022-11-08 | AGNG | ETF | 25.36 | 25.45 | 25.19 | 25.25 | 13600.0 |
| 2022-11-08 | AGOV | ETF | 79.7 | 79.7 | 79.7 | 79.7 | 32.0 |
| 2022-11-08 | AGOX | ETF | 20.64 | 20.78 | 20.571 | 20.625 | 18700.0 |
| 2022-11-08 | AGQ | ETF | 24.83 | 26.57 | 24.73 | 25.92 | 1422500.0 |
| 2022-11-08 | AGRH | ETF | 25.1 | 25.135 | 25.1 | 25.135 | 200.0 |
| 2022-11-08 | AGZ | ETF | 105.23 | 105.395 | 105.15 | 105.29 | 25816.0 |
| 2022-11-08 | AGZD | ETF | 22.8 | 22.93 | 22.8 | 22.83 | 643600.0 |
| 2022-11-08 | AHHX | ETF | 8.37 | 8.44 | 8.34 | 8.3963 | 8606.0 |
| 2022-11-08 | AHYB | ETF | 42.48 | 42.48 | 42.466 | 42.466 | 200.0 |
| 2022-11-08 | AIA | ETF | 50.21 | 50.7022 | 50.0 | 50.55 | 24274.0 |
| 2022-11-08 | AIEQ | ETF | 30.22 | 30.5 | 29.86 | 30.13 | 6600.0 |
> showing 50 of 2,872 rows — these rows as CSV