PREVIEW / etf_daily / 2024-08-22
file: by_date/etf_daily/2024/2024-08-22.parquet size: 133 KB rows: 3,453
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-22 | SPY | ETF | 562.56 | 563.18 | 554.98 | 556.22 | 56237104.0 |
| 2024-08-22 | QQQ | ETF | 484.84 | 485.54 | 473.81 | 474.85 | 37739576.0 |
| 2024-08-22 | IWM | ETF | 215.57 | 216.37 | 213.13 | 213.56 | 18038972.0 |
| 2024-08-22 | DIA | ETF | 409.7 | 410.5 | 406.02 | 407.48 | 2352157.0 |
| 2024-08-22 | GLD | ETF | 230.35 | 230.38 | 228.26 | 229.37 | 5746553.0 |
| 2024-08-22 | TLT | ETF | 98.23 | 98.3 | 97.43 | 97.75 | 33421271.0 |
| 2024-08-22 | AAA | ETF | 25.03 | 25.11 | 25.03 | 25.075 | 2799.0 |
| 2024-08-22 | AAAU | ETF | 24.66 | 24.66 | 24.43 | 24.55 | 1382801.0 |
| 2024-08-22 | AADR | ETF | 62.145 | 62.145 | 61.7127 | 61.7847 | 816.0 |
| 2024-08-22 | AAPB | ETF | 29.01 | 29.12 | 28.12 | 28.26 | 78733.0 |
| 2024-08-22 | AAPD | ETF | 16.9 | 17.17 | 16.8595 | 17.14 | 257022.0 |
| 2024-08-22 | AAPR | ETF | 25.87 | 25.87 | 25.74 | 25.7457 | 2777.0 |
| 2024-08-22 | AAPU | ETF | 37.21 | 37.36 | 35.93 | 36.17 | 358953.0 |
| 2024-08-22 | AAPX | ETF | 33.48 | 33.79 | 32.5715 | 32.79 | 23635.0 |
| 2024-08-22 | AAXJ | ETF | 73.19 | 73.19 | 72.31 | 72.46 | 157554.0 |
| 2024-08-22 | ABCS | ETF | 27.415 | 27.415 | 27.3578 | 27.3578 | 1104.0 |
| 2024-08-22 | ABEQ | ETF | 31.9274 | 31.9559 | 31.9274 | 31.9559 | 440.0 |
| 2024-08-22 | ABNY | ETF | 80.545 | 80.545 | 78.8915 | 79.15 | 1150.0 |
| 2024-08-22 | ACES | ETF | 28.71 | 28.71 | 28.1 | 28.2 | 57107.0 |
| 2024-08-22 | ACIO | ETF | 39.23 | 39.265 | 38.8283 | 38.875 | 82302.0 |
| 2024-08-22 | ACSI | ETF | 56.2054 | 56.2054 | 56.2054 | 56.2054 | 81.0 |
| 2024-08-22 | ACT | ETF | 34.82 | 34.945 | 34.48 | 34.86 | 211029.0 |
| 2024-08-22 | ACTV | ETF | 32.66 | 32.66 | 32.22 | 32.24 | 19047.0 |
| 2024-08-22 | ACVF | ETF | 42.91 | 42.91 | 42.2973 | 42.2973 | 13898.0 |
| 2024-08-22 | ACWI | ETF | 116.54 | 116.66 | 115.14 | 115.34 | 2864135.0 |
| 2024-08-22 | ACWV | ETF | 112.12 | 112.35 | 111.59 | 111.84 | 90102.0 |
| 2024-08-22 | ACWX | ETF | 55.42 | 55.42 | 54.83 | 54.89 | 718106.0 |
| 2024-08-22 | ADFI | ETF | 8.7022 | 8.72 | 8.69 | 8.71 | 5233.0 |
| 2024-08-22 | ADIV | ETF | 15.09 | 15.11 | 15.09 | 15.097 | 2008.0 |
| 2024-08-22 | ADME | ETF | 45.41 | 45.42 | 44.9599 | 44.9599 | 2873.0 |
| 2024-08-22 | ADPV | ETF | 31.32 | 31.32 | 31.1536 | 31.1536 | 2668.0 |
| 2024-08-22 | ADVE | ETF | 33.86 | 33.86 | 33.6707 | 33.6707 | 2149.0 |
| 2024-08-22 | AEMB | ETF | 39.3915 | 39.3915 | 39.3915 | 39.3915 | 31.0 |
| 2024-08-22 | AESR | ETF | 16.78 | 16.78 | 16.52 | 16.54 | 18157.0 |
| 2024-08-22 | AETH | ETF | 34.04 | 34.05 | 33.66 | 33.7863 | 2013.0 |
| 2024-08-22 | AFIF | ETF | 9.11 | 9.18 | 9.11 | 9.165 | 16961.0 |
| 2024-08-22 | AFK | ETF | 16.3 | 16.3 | 15.8901 | 16.18 | 6030.0 |
| 2024-08-22 | AFLG | ETF | 32.85 | 32.85 | 32.62 | 32.65 | 4878.0 |
| 2024-08-22 | AFMC | ETF | 31.14 | 31.14 | 30.7596 | 30.7596 | 5919.0 |
| 2024-08-22 | AFSM | ETF | 29.7 | 29.79 | 29.6091 | 29.6091 | 7175.0 |
| 2024-08-22 | AFTY | ETF | 14.125 | 14.13 | 14.125 | 14.13 | 418.0 |
| 2024-08-22 | AGG | ETF | 100.54 | 100.565 | 100.23 | 100.31 | 7528382.0 |
| 2024-08-22 | AGGH | ETF | 21.57 | 21.61 | 21.52 | 21.61 | 25952.0 |
| 2024-08-22 | AGGY | ETF | 44.52 | 44.52 | 44.35 | 44.35 | 42613.0 |
| 2024-08-22 | AGIX | ETF | 25.23 | 25.23 | 24.6059 | 24.6059 | 4832.0 |
| 2024-08-22 | AGMI | ETF | 27.15 | 27.15 | 26.7321 | 26.7321 | 113.0 |
| 2024-08-22 | AGNG | ETF | 32.75 | 32.83 | 32.56 | 32.6522 | 8918.0 |
| 2024-08-22 | AGOX | ETF | 29.5 | 29.545 | 29.01 | 29.1499 | 31687.0 |
| 2024-08-22 | AGQ | ETF | 37.13 | 37.13 | 35.2219 | 35.59 | 1961525.0 |
| 2024-08-22 | AGQI | ETF | 14.4587 | 14.4587 | 14.351 | 14.36 | 3588.0 |
> showing 50 of 3,453 rows — these rows as CSV