PREVIEW / etf_daily / 2024-08-27
file: by_date/etf_daily/2024/2024-08-27.parquet size: 133 KB rows: 3,463
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-08-27 | SPY | ETF | 559.49 | 562.06 | 558.32 | 561.56 | 31985802.0 |
| 2024-08-27 | QQQ | ETF | 473.69 | 477.84 | 471.71 | 476.76 | 27510003.0 |
| 2024-08-27 | IWM | ETF | 218.91 | 219.37 | 217.71 | 218.74 | 19518063.0 |
| 2024-08-27 | DIA | ETF | 412.29 | 413.07 | 411.36 | 412.89 | 1708398.0 |
| 2024-08-27 | GLD | ETF | 231.69 | 233.47 | 231.5701 | 233.39 | 4324863.0 |
| 2024-08-27 | TLT | ETF | 97.49 | 98.08 | 97.41 | 97.97 | 21463948.0 |
| 2024-08-27 | AAA | ETF | 25.17 | 25.17 | 25.13 | 25.13 | 2059.0 |
| 2024-08-27 | AAAU | ETF | 24.81 | 24.9851 | 24.79 | 24.98 | 1709528.0 |
| 2024-08-27 | AADR | ETF | 62.33 | 62.55 | 62.33 | 62.55 | 470.0 |
| 2024-08-27 | AAPB | ETF | 28.63 | 29.2755 | 28.31 | 29.09 | 94528.0 |
| 2024-08-27 | AAPD | ETF | 17.04 | 17.12 | 16.8325 | 16.89 | 292377.0 |
| 2024-08-27 | AAPR | ETF | 25.845 | 25.88 | 25.845 | 25.8752 | 1218.0 |
| 2024-08-27 | AAPU | ETF | 36.52 | 37.4889 | 36.2 | 37.24 | 413653.0 |
| 2024-08-27 | AAPX | ETF | 33.037 | 33.885 | 32.77 | 33.75 | 13437.0 |
| 2024-08-27 | AAPY | ETF | 27.27 | 27.49 | 27.27 | 27.4396 | 1883.0 |
| 2024-08-27 | AAXJ | ETF | 72.94 | 73.2 | 72.81 | 73.18 | 150553.0 |
| 2024-08-27 | ABCS | ETF | 27.82 | 27.8536 | 27.77 | 27.8536 | 2730.0 |
| 2024-08-27 | ABEQ | ETF | 32.3877 | 32.4604 | 32.3525 | 32.4604 | 2905.0 |
| 2024-08-27 | ABNY | ETF | 80.8 | 80.8 | 79.525 | 80.212 | 2197.0 |
| 2024-08-27 | ACES | ETF | 29.39 | 29.39 | 28.96 | 29.27 | 28467.0 |
| 2024-08-27 | ACIO | ETF | 39.11 | 39.2 | 38.98 | 39.16 | 130648.0 |
| 2024-08-27 | ACSI | ETF | 56.964 | 56.964 | 56.964 | 56.964 | 221.0 |
| 2024-08-27 | ACT | ETF | 35.3 | 35.3879 | 35.03 | 35.24 | 228709.0 |
| 2024-08-27 | ACTV | ETF | 32.88 | 32.97 | 32.85 | 32.93 | 7460.0 |
| 2024-08-27 | ACVF | ETF | 42.6 | 42.85 | 42.6 | 42.8011 | 12112.0 |
| 2024-08-27 | ACWI | ETF | 116.42 | 116.835 | 116.14 | 116.7 | 1466526.0 |
| 2024-08-27 | ACWV | ETF | 112.96 | 113.24 | 112.851 | 113.23 | 78716.0 |
| 2024-08-27 | ACWX | ETF | 55.76 | 55.85 | 55.585 | 55.79 | 273883.0 |
| 2024-08-27 | ADFI | ETF | 8.7299 | 8.76 | 8.72 | 8.745 | 14415.0 |
| 2024-08-27 | ADIV | ETF | 15.37 | 15.455 | 15.37 | 15.455 | 456.0 |
| 2024-08-27 | ADME | ETF | 45.24 | 45.44 | 45.24 | 45.44 | 15168.0 |
| 2024-08-27 | ADPV | ETF | 31.64 | 31.84 | 31.64 | 31.7076 | 16243.0 |
| 2024-08-27 | AEMB | ETF | 39.6988 | 39.6988 | 39.6988 | 39.6988 | 27.0 |
| 2024-08-27 | AESR | ETF | 16.55 | 16.69 | 16.55 | 16.6703 | 19726.0 |
| 2024-08-27 | AETH | ETF | 33.93 | 33.98 | 33.2 | 33.39 | 6470.0 |
| 2024-08-27 | AFIF | ETF | 9.13 | 9.1833 | 9.13 | 9.175 | 4142.0 |
| 2024-08-27 | AFK | ETF | 16.58 | 16.79 | 16.478 | 16.7548 | 9862.0 |
| 2024-08-27 | AFLG | ETF | 33.03 | 33.16 | 33.0299 | 33.13 | 9492.0 |
| 2024-08-27 | AFMC | ETF | 31.2 | 31.37 | 31.2 | 31.345 | 728.0 |
| 2024-08-27 | AFSM | ETF | 30.25 | 30.3206 | 30.2 | 30.3206 | 1687.0 |
| 2024-08-27 | AFTY | ETF | 14.24 | 14.24 | 14.24 | 14.24 | 1.0 |
| 2024-08-27 | AGG | ETF | 100.48 | 100.74 | 100.43 | 100.71 | 7952228.0 |
| 2024-08-27 | AGGH | ETF | 21.97 | 21.97 | 21.46 | 21.61 | 52632.0 |
| 2024-08-27 | AGGS | ETF | 42.218 | 42.31 | 42.218 | 42.298 | 1620.0 |
| 2024-08-27 | AGGY | ETF | 44.31 | 44.4845 | 44.31 | 44.44 | 80713.0 |
| 2024-08-27 | AGIX | ETF | 24.58 | 24.635 | 24.58 | 24.6347 | 297.0 |
| 2024-08-27 | AGMI | ETF | 27.11 | 27.1282 | 26.92 | 27.1282 | 330.0 |
| 2024-08-27 | AGNG | ETF | 32.97 | 33.129 | 32.97 | 33.0654 | 2578.0 |
| 2024-08-27 | AGOX | ETF | 29.44 | 29.44 | 28.77 | 28.87 | 38213.0 |
| 2024-08-27 | AGQ | ETF | 37.87 | 38.49 | 37.45 | 38.23 | 1027640.0 |
> showing 50 of 3,463 rows — these rows as CSV