PREVIEW / etf_daily / 2021-10-11
file: by_date/etf_daily/2021/2021-10-11.parquet size: 95 KB rows: 2,510
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-10-11 | SPY | ETF | 437.16 | 440.26 | 434.62 | 434.69 | 65233300.0 |
| 2021-10-11 | QQQ | ETF | 359.58 | 363.2 | 358.3 | 358.39 | 34847182.0 |
| 2021-10-11 | IWM | ETF | 221.83 | 223.55 | 220.25 | 220.31 | 15929800.0 |
| 2021-10-11 | DIA | ETF | 347.66 | 349.56 | 344.86 | 344.98 | 4098400.0 |
| 2021-10-11 | GLD | ETF | 164.04 | 164.58 | 163.91 | 163.92 | 3820100.0 |
| 2021-10-11 | TLT | ETF | 141.6 | 141.9 | 141.45 | 141.52 | 7213400.0 |
| 2021-10-11 | AAA | ETF | 25.0 | 25.0 | 24.995 | 24.995 | 720.0 |
| 2021-10-11 | AAAU | ETF | 17.46 | 17.51 | 17.43 | 17.43 | 71500.0 |
| 2021-10-11 | AADR | ETF | 63.92 | 63.92 | 63.51 | 63.51 | 600.0 |
| 2021-10-11 | AAXJ | ETF | 85.92 | 86.23 | 85.34 | 85.34 | 826000.0 |
| 2021-10-11 | ABEQ | ETF | 27.505 | 27.505 | 27.235 | 27.235 | 1100.0 |
| 2021-10-11 | ACES | ETF | 65.51 | 67.994 | 65.51 | 66.91 | 60300.0 |
| 2021-10-11 | ACIO | ETF | 30.51 | 30.52 | 30.24 | 30.24 | 24800.0 |
| 2021-10-11 | ACSI | ETF | 50.2 | 50.2 | 49.6736 | 49.6736 | 336.0 |
| 2021-10-11 | ACT | ETF | 20.73 | 21.49 | 20.36 | 20.45 | 357360.0 |
| 2021-10-11 | ACTV | ETF | 39.36 | 39.36 | 38.7271 | 38.7271 | 10943.0 |
| 2021-10-11 | ACTX | ETF | 0.9001 | 1.1 | 0.9 | 0.9 | 4092.0 |
| 2021-10-11 | ACVF | ETF | 32.47 | 32.83 | 32.46 | 32.47 | 8700.0 |
| 2021-10-11 | ACWF | ETF | 37.15 | 37.15 | 36.9014 | 36.9014 | 3096.0 |
| 2021-10-11 | ACWI | ETF | 101.45 | 101.98 | 100.85 | 100.85 | 1972800.0 |
| 2021-10-11 | ACWV | ETF | 103.17 | 103.62 | 102.78 | 102.78 | 49200.0 |
| 2021-10-11 | ACWX | ETF | 55.88 | 56.04 | 55.56 | 55.58 | 705170.0 |
| 2021-10-11 | ADFI | ETF | 9.61 | 9.615 | 9.61 | 9.615 | 900.0 |
| 2021-10-11 | ADIV | ETF | 17.06 | 17.06 | 17.06 | 17.06 | 100.0 |
| 2021-10-11 | ADME | ETF | 40.3 | 40.3 | 39.81 | 39.81 | 25200.0 |
| 2021-10-11 | ADRE | ETF | 50.06 | 50.21 | 49.54 | 49.55 | 7710.0 |
| 2021-10-11 | AEMB | ETF | 48.54 | 48.548 | 48.54 | 48.548 | 200.0 |
| 2021-10-11 | AESR | ETF | 13.9 | 13.93 | 13.76 | 13.76 | 3500.0 |
| 2021-10-11 | AFIF | ETF | 9.6143 | 9.615 | 9.61 | 9.615 | 4277.0 |
| 2021-10-11 | AFK | ETF | 21.32 | 21.35 | 21.12 | 21.15 | 6820.0 |
| 2021-10-11 | AFLG | ETF | 25.79 | 25.79 | 25.591 | 25.591 | 500.0 |
| 2021-10-11 | AFMC | ETF | 25.149 | 25.149 | 25.149 | 25.149 | 100.0 |
| 2021-10-11 | AFSM | ETF | 26.43 | 26.43 | 26.251 | 26.251 | 200.0 |
| 2021-10-11 | AFTY | ETF | 21.25 | 21.35 | 21.14 | 21.204 | 11800.0 |
| 2021-10-11 | AGG | ETF | 114.01 | 114.07 | 113.94 | 113.95 | 2178400.0 |
| 2021-10-11 | AGGY | ETF | 51.58 | 51.64 | 51.58 | 51.62 | 42000.0 |
| 2021-10-11 | AGNG | ETF | 28.85 | 28.978 | 28.686 | 28.686 | 2100.0 |
| 2021-10-11 | AGOV | ETF | 98.83 | 98.83 | 98.61 | 98.66 | 5476.0 |
| 2021-10-11 | AGOX | ETF | 26.3 | 26.3 | 25.93 | 25.93 | 14900.0 |
| 2021-10-11 | AGQ | ETF | 33.46 | 33.97 | 33.23 | 33.23 | 780700.0 |
| 2021-10-11 | AGZ | ETF | 117.96 | 118.04 | 117.94 | 117.94 | 36380.0 |
| 2021-10-11 | AGZD | ETF | 23.47 | 23.47 | 23.42 | 23.435 | 10000.0 |
| 2021-10-11 | AIA | ETF | 79.94 | 80.08 | 79.06 | 79.06 | 27452.0 |
| 2021-10-11 | AIEQ | ETF | 41.95 | 42.279 | 41.867 | 41.9 | 6800.0 |
| 2021-10-11 | AIQ | ETF | 30.58 | 30.76 | 30.44 | 30.44 | 13306.0 |
| 2021-10-11 | AIRR | ETF | 41.9 | 42.086 | 41.44 | 41.44 | 20000.0 |
| 2021-10-11 | AIVI | ETF | 41.11 | 41.2 | 40.94 | 40.94 | 5600.0 |
| 2021-10-11 | ALTL | ETF | 41.49 | 41.94 | 41.26 | 41.26 | 21520.0 |
| 2021-10-11 | ALTY | ETF | 13.36 | 13.42 | 13.29 | 13.311 | 10300.0 |
| 2021-10-11 | AMJ | ETF | 19.21 | 19.37 | 19.11 | 19.13 | 269277.0 |
> showing 50 of 2,510 rows — these rows as CSV