PREVIEW / etf_daily / 2024-01-16
file: by_date/etf_daily/2024/2024-01-16.parquet size: 116 KB rows: 3,263
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-16 | SPY | ETF | 475.26 | 476.61 | 473.06 | 474.93 | 85014900.0 |
| 2024-01-16 | QQQ | ETF | 408.31 | 411.12 | 406.83 | 409.52 | 43903027.0 |
| 2024-01-16 | IWM | ETF | 191.72 | 193.26 | 190.11 | 190.84 | 42213000.0 |
| 2024-01-16 | DIA | ETF | 374.97 | 375.53 | 372.04 | 373.66 | 4471600.0 |
| 2024-01-16 | GLD | ETF | 189.15 | 189.26 | 187.54 | 187.91 | 6548100.0 |
| 2024-01-16 | TLT | ETF | 95.62 | 95.79 | 94.51 | 94.82 | 61716700.0 |
| 2024-01-16 | AAA | ETF | 25.08 | 25.15 | 25.05 | 25.085 | 6800.0 |
| 2024-01-16 | AAAU | ETF | 20.22 | 20.22 | 20.05 | 20.09 | 2549300.0 |
| 2024-01-16 | AADR | ETF | 54.29 | 54.45 | 54.11 | 54.11 | 1200.0 |
| 2024-01-16 | AAPB | ETF | 20.72 | 21.07 | 20.45 | 20.99 | 46074.0 |
| 2024-01-16 | AAPD | ETF | 21.35 | 21.48 | 21.12 | 21.19 | 459647.0 |
| 2024-01-16 | AAPU | ETF | 25.14 | 25.5141 | 24.85 | 25.39 | 127617.0 |
| 2024-01-16 | AAPX | ETF | 24.0 | 24.2852 | 24.0 | 24.2852 | 671.0 |
| 2024-01-16 | AAXJ | ETF | 63.4 | 63.4 | 62.8 | 62.86 | 546600.0 |
| 2024-01-16 | ABCS | ETF | 24.7 | 24.71 | 24.64 | 24.6513 | 13275.0 |
| 2024-01-16 | ABEQ | ETF | 28.33 | 28.41 | 28.23 | 28.26 | 5300.0 |
| 2024-01-16 | ACES | ETF | 31.01 | 31.01 | 30.16 | 30.33 | 225600.0 |
| 2024-01-16 | ACIO | ETF | 33.22 | 33.31 | 33.121 | 33.2 | 130000.0 |
| 2024-01-16 | ACSI | ETF | 48.83 | 48.83 | 48.83 | 48.83 | 1000.0 |
| 2024-01-16 | ACT | ETF | 28.1 | 28.1 | 27.59 | 27.7 | 155631.0 |
| 2024-01-16 | ACTV | ETF | 32.12 | 32.16 | 32.03 | 32.148 | 13000.0 |
| 2024-01-16 | ACVF | ETF | 36.68 | 36.68 | 36.47 | 36.557 | 14700.0 |
| 2024-01-16 | ACWF | ETF | 37.9 | 37.99 | 37.7037 | 37.7917 | 3632.0 |
| 2024-01-16 | ACWI | ETF | 100.79 | 100.98 | 100.23 | 100.56 | 5238500.0 |
| 2024-01-16 | ACWV | ETF | 100.99 | 101.15 | 100.64 | 100.79 | 379200.0 |
| 2024-01-16 | ACWX | ETF | 49.74 | 49.84 | 49.46 | 49.56 | 3863500.0 |
| 2024-01-16 | ADFI | ETF | 8.56 | 8.56 | 8.54 | 8.54 | 15700.0 |
| 2024-01-16 | ADIV | ETF | 13.5 | 13.5 | 13.438 | 13.438 | 500.0 |
| 2024-01-16 | ADME | ETF | 38.45 | 38.45 | 38.34 | 38.42 | 7200.0 |
| 2024-01-16 | ADPV | ETF | 24.36 | 24.36 | 24.33 | 24.352 | 3279.0 |
| 2024-01-16 | AEMB | ETF | 37.65 | 37.66 | 37.63 | 37.66 | 600.0 |
| 2024-01-16 | AESR | ETF | 13.81 | 13.86 | 13.788 | 13.822 | 32600.0 |
| 2024-01-16 | AETH | ETF | 35.42 | 35.78 | 34.45 | 35.6211 | 24266.0 |
| 2024-01-16 | AFIF | ETF | 9.08 | 9.11 | 9.07 | 9.1 | 25300.0 |
| 2024-01-16 | AFK | ETF | 13.65 | 13.86 | 13.6 | 13.6 | 14500.0 |
| 2024-01-16 | AFLG | ETF | 27.281 | 27.341 | 27.281 | 27.341 | 600.0 |
| 2024-01-16 | AFMC | ETF | 26.27 | 26.35 | 26.27 | 26.274 | 88400.0 |
| 2024-01-16 | AFSM | ETF | 26.28 | 26.293 | 26.28 | 26.293 | 36400.0 |
| 2024-01-16 | AFTY | ETF | 12.832 | 12.832 | 12.832 | 12.832 | 100.0 |
| 2024-01-16 | AGG | ETF | 98.72 | 98.85 | 98.27 | 98.36 | 14489800.0 |
| 2024-01-16 | AGGH | ETF | 21.98 | 21.989 | 21.81 | 21.92 | 52648.0 |
| 2024-01-16 | AGGY | ETF | 43.79 | 43.84 | 43.6 | 43.645 | 183000.0 |
| 2024-01-16 | AGNG | ETF | 28.67 | 28.67 | 28.485 | 28.52 | 3300.0 |
| 2024-01-16 | AGOX | ETF | 23.91 | 24.06 | 23.9 | 24.054 | 56700.0 |
| 2024-01-16 | AGQ | ETF | 25.41 | 25.49 | 24.91 | 25.04 | 1529500.0 |
| 2024-01-16 | AGQI | ETF | 13.1542 | 13.1751 | 13.09 | 13.11 | 20713.0 |
| 2024-01-16 | AGZ | ETF | 108.5 | 108.57 | 108.21 | 108.26 | 49100.0 |
| 2024-01-16 | AGZD | ETF | 21.9 | 21.96 | 21.77 | 21.92 | 71200.0 |
| 2024-01-16 | AHLT | ETF | 21.98 | 21.99 | 21.7931 | 21.8344 | 5926.0 |
| 2024-01-16 | AHYB | ETF | 45.435 | 45.435 | 45.29 | 45.29 | 500.0 |
> showing 50 of 3,263 rows — these rows as CSV