PREVIEW / etf_daily / 2021-04-13
file: by_date/etf_daily/2021/2021-04-13.parquet size: 88 KB rows: 2,321
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-13 | SPY | ETF | 411.53 | 413.53 | 411.12 | 412.86 | 56551000.0 |
| 2021-04-13 | QQQ | ETF | 338.24 | 341.08 | 338.02 | 340.6 | 30374033.0 |
| 2021-04-13 | IWM | ETF | 221.48 | 222.57 | 218.83 | 221.14 | 24608400.0 |
| 2021-04-13 | DIA | ETF | 336.63 | 337.42 | 335.49 | 336.79 | 3391700.0 |
| 2021-04-13 | GLD | ETF | 163.18 | 163.85 | 163.03 | 163.43 | 6995900.0 |
| 2021-04-13 | TLT | ETF | 137.3 | 138.51 | 137.2 | 138.48 | 13232800.0 |
| 2021-04-13 | AAA | ETF | 25.05 | 25.05 | 25.03 | 25.04 | 5256.0 |
| 2021-04-13 | AAAU | ETF | 17.33 | 17.4 | 17.32 | 17.37 | 406900.0 |
| 2021-04-13 | AADR | ETF | 62.44 | 63.06 | 62.44 | 63.02 | 36800.0 |
| 2021-04-13 | AAXJ | ETF | 92.51 | 93.08 | 92.35 | 92.88 | 1985800.0 |
| 2021-04-13 | ABEQ | ETF | 26.8 | 26.876 | 26.8 | 26.845 | 4500.0 |
| 2021-04-13 | ACES | ETF | 74.6 | 75.44 | 73.85 | 75.44 | 70200.0 |
| 2021-04-13 | ACIO | ETF | 29.29 | 29.37 | 29.169 | 29.33 | 39900.0 |
| 2021-04-13 | ACSI | ETF | 48.2375 | 48.2375 | 48.2375 | 48.2375 | 245.0 |
| 2021-04-13 | ACTV | ETF | 36.035 | 36.0957 | 35.82 | 36.0957 | 3127.0 |
| 2021-04-13 | ACTX | ETF | 4.7 | 4.7 | 4.7 | 4.7 | 752.0 |
| 2021-04-13 | ACVF | ETF | 30.73 | 30.79 | 30.63 | 30.735 | 2100.0 |
| 2021-04-13 | ACWF | ETF | 37.33 | 37.43 | 37.29 | 37.42 | 8020.0 |
| 2021-04-13 | ACWI | ETF | 98.04 | 98.52 | 97.98 | 98.42 | 1240400.0 |
| 2021-04-13 | ACWV | ETF | 99.89 | 100.21 | 99.7 | 100.11 | 139800.0 |
| 2021-04-13 | ACWX | ETF | 56.16 | 56.39 | 56.08 | 56.37 | 844127.0 |
| 2021-04-13 | ADFI | ETF | 9.669 | 9.69 | 9.66 | 9.69 | 1300.0 |
| 2021-04-13 | ADIV | ETF | 18.56 | 18.674 | 18.56 | 18.674 | 200.0 |
| 2021-04-13 | ADME | ETF | 38.24 | 38.27 | 38.05 | 38.17 | 31700.0 |
| 2021-04-13 | ADRE | ETF | 56.57 | 56.9357 | 56.55 | 56.76 | 7228.0 |
| 2021-04-13 | AESR | ETF | 13.076 | 13.142 | 13.076 | 13.142 | 8100.0 |
| 2021-04-13 | AFIF | ETF | 9.7145 | 9.74 | 9.7145 | 9.735 | 26723.0 |
| 2021-04-13 | AFK | ETF | 21.35 | 21.47 | 21.35 | 21.38 | 6600.0 |
| 2021-04-13 | AFLG | ETF | 24.75 | 24.75 | 24.675 | 24.738 | 3400.0 |
| 2021-04-13 | AFMC | ETF | 24.788 | 24.788 | 24.788 | 24.788 | 100.0 |
| 2021-04-13 | AFSM | ETF | 25.613 | 25.613 | 25.613 | 25.613 | 100.0 |
| 2021-04-13 | AFTY | ETF | 21.83 | 22.0 | 21.83 | 21.96 | 5700.0 |
| 2021-04-13 | AGG | ETF | 114.12 | 114.48 | 114.11 | 114.48 | 4040500.0 |
| 2021-04-13 | AGGY | ETF | 51.54 | 51.75 | 51.54 | 51.72 | 126600.0 |
| 2021-04-13 | AGNG | ETF | 28.11 | 28.34 | 28.11 | 28.318 | 1700.0 |
| 2021-04-13 | AGQ | ETF | 44.2 | 44.68 | 44.01 | 44.14 | 721800.0 |
| 2021-04-13 | AGZ | ETF | 117.89 | 118.13 | 117.89 | 118.13 | 60996.0 |
| 2021-04-13 | AGZD | ETF | 23.58 | 23.605 | 23.58 | 23.595 | 37400.0 |
| 2021-04-13 | AIA | ETF | 93.34 | 93.67 | 92.97 | 93.29 | 1860230.0 |
| 2021-04-13 | AIEQ | ETF | 39.17 | 39.49 | 39.111 | 39.49 | 27500.0 |
| 2021-04-13 | AIQ | ETF | 29.76 | 29.99 | 29.76 | 29.93 | 43622.0 |
| 2021-04-13 | AIRR | ETF | 41.4 | 41.4 | 40.5 | 40.806 | 95000.0 |
| 2021-04-13 | AIVI | ETF | 42.67 | 42.87 | 42.67 | 42.87 | 2200.0 |
| 2021-04-13 | ALTL | ETF | 39.82 | 39.82 | 39.2449 | 39.5233 | 16435.0 |
| 2021-04-13 | ALTY | ETF | 13.01 | 13.05 | 12.924 | 13.05 | 11900.0 |
| 2021-04-13 | AMJ | ETF | 16.8 | 16.82 | 16.585 | 16.78 | 466593.0 |
| 2021-04-13 | AMLP | ETF | 30.89 | 31.03 | 30.57 | 30.94 | 1855400.0 |
| 2021-04-13 | AMNA | ETF | 29.6827 | 29.6827 | 29.6827 | 29.6827 | 1.0 |
| 2021-04-13 | AMND | ETF | 31.5621 | 31.5621 | 31.5621 | 31.5621 | 16.0 |
| 2021-04-13 | AMOM | ETF | 34.97 | 34.97 | 34.95 | 34.95 | 1100.0 |
> showing 50 of 2,321 rows — these rows as CSV