PREVIEW / etf_daily / 2024-01-25
file: by_date/etf_daily/2024/2024-01-25.parquet size: 116 KB rows: 3,227
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-25 | SPY | ETF | 487.58 | 488.31 | 485.39 | 488.03 | 72525000.0 |
| 2024-01-25 | QQQ | ETF | 428.36 | 429.04 | 423.98 | 426.35 | 44367205.0 |
| 2024-01-25 | IWM | ETF | 197.1 | 197.66 | 194.41 | 195.97 | 37659500.0 |
| 2024-01-25 | DIA | ETF | 379.07 | 380.56 | 377.92 | 380.48 | 3539100.0 |
| 2024-01-25 | GLD | ETF | 187.34 | 187.64 | 186.46 | 187.14 | 4651000.0 |
| 2024-01-25 | TLT | ETF | 94.0 | 94.22 | 93.57 | 93.96 | 57019400.0 |
| 2024-01-25 | AAA | ETF | 25.16 | 25.163 | 25.125 | 25.125 | 3800.0 |
| 2024-01-25 | AAAU | ETF | 20.02 | 20.05 | 19.93 | 20.01 | 1990700.0 |
| 2024-01-25 | AADR | ETF | 55.51 | 55.71 | 55.51 | 55.71 | 600.0 |
| 2024-01-25 | AAPB | ETF | 23.4 | 23.5699 | 22.88 | 23.09 | 28572.0 |
| 2024-01-25 | AAPD | ETF | 19.95 | 20.16 | 19.85 | 20.06 | 177680.0 |
| 2024-01-25 | AAPU | ETF | 27.77 | 28.0 | 27.34 | 27.55 | 101527.0 |
| 2024-01-25 | AAPY | ETF | 26.73 | 26.73 | 26.6252 | 26.6252 | 247.0 |
| 2024-01-25 | AAXJ | ETF | 64.22 | 64.38 | 63.89 | 64.04 | 1098400.0 |
| 2024-01-25 | ABCS | ETF | 24.895 | 25.0101 | 24.895 | 25.0101 | 1002.0 |
| 2024-01-25 | ABEQ | ETF | 28.45 | 28.521 | 28.45 | 28.521 | 1300.0 |
| 2024-01-25 | ACES | ETF | 29.93 | 29.94 | 29.185 | 29.69 | 68000.0 |
| 2024-01-25 | ACIO | ETF | 33.89 | 33.95 | 33.8 | 33.95 | 45400.0 |
| 2024-01-25 | ACSI | ETF | 49.775 | 49.775 | 49.775 | 49.775 | 100.0 |
| 2024-01-25 | ACT | ETF | 28.41 | 28.48 | 28.155 | 28.32 | 688277.0 |
| 2024-01-25 | ACTV | ETF | 32.55 | 32.77 | 32.55 | 32.767 | 7300.0 |
| 2024-01-25 | ACVF | ETF | 37.5 | 37.5 | 37.3 | 37.43 | 14400.0 |
| 2024-01-25 | ACWF | ETF | 38.63 | 38.665 | 38.52 | 38.6324 | 3239.0 |
| 2024-01-25 | ACWI | ETF | 102.76 | 102.8 | 102.3 | 102.79 | 4227600.0 |
| 2024-01-25 | ACWV | ETF | 101.37 | 101.61 | 101.14 | 101.61 | 158400.0 |
| 2024-01-25 | ACWX | ETF | 50.21 | 50.22 | 49.96 | 50.18 | 1233500.0 |
| 2024-01-25 | ADFI | ETF | 8.51 | 8.53 | 8.51 | 8.525 | 13500.0 |
| 2024-01-25 | ADIV | ETF | 13.707 | 13.707 | 13.707 | 13.707 | 100.0 |
| 2024-01-25 | ADME | ETF | 39.21 | 39.37 | 39.21 | 39.36 | 6200.0 |
| 2024-01-25 | ADPV | ETF | 25.13 | 25.1385 | 25.0801 | 25.1385 | 4155.0 |
| 2024-01-25 | ADVE | ETF | 31.27 | 31.27 | 31.18 | 31.19 | 1402.0 |
| 2024-01-25 | AEMB | ETF | 37.521 | 37.63 | 37.48 | 37.63 | 700.0 |
| 2024-01-25 | AESR | ETF | 14.35 | 14.37 | 14.29 | 14.36 | 23500.0 |
| 2024-01-25 | AETH | ETF | 30.3015 | 30.39 | 29.8 | 30.39 | 4310.0 |
| 2024-01-25 | AFIF | ETF | 9.08 | 9.11 | 9.06 | 9.11 | 12400.0 |
| 2024-01-25 | AFK | ETF | 13.6 | 13.75 | 13.39 | 13.58 | 7900.0 |
| 2024-01-25 | AFLG | ETF | 28.081 | 28.081 | 28.081 | 28.081 | 100.0 |
| 2024-01-25 | AFMC | ETF | 26.81 | 26.81 | 26.793 | 26.793 | 1000.0 |
| 2024-01-25 | AFSM | ETF | 27.01 | 27.09 | 27.01 | 27.065 | 1500.0 |
| 2024-01-25 | AFTY | ETF | 13.28 | 13.28 | 13.154 | 13.154 | 600.0 |
| 2024-01-25 | AGG | ETF | 98.01 | 98.2 | 97.96 | 98.18 | 16521600.0 |
| 2024-01-25 | AGGH | ETF | 21.56 | 21.74 | 21.56 | 21.66 | 52097.0 |
| 2024-01-25 | AGGY | ETF | 43.39 | 43.46 | 43.35 | 43.39 | 158700.0 |
| 2024-01-25 | AGNG | ETF | 28.027 | 28.19 | 28.027 | 28.159 | 2600.0 |
| 2024-01-25 | AGOX | ETF | 24.39 | 24.39 | 24.21 | 24.32 | 26500.0 |
| 2024-01-25 | AGQ | ETF | 24.88 | 25.17 | 24.51 | 24.87 | 1078700.0 |
| 2024-01-25 | AGQI | ETF | 13.34 | 13.4 | 13.34 | 13.4 | 14614.0 |
| 2024-01-25 | AGRH | ETF | 25.93 | 25.93 | 25.91 | 25.91 | 345.0 |
| 2024-01-25 | AGZ | ETF | 108.23 | 108.3 | 108.17 | 108.27 | 13100.0 |
| 2024-01-25 | AGZD | ETF | 21.99 | 22.0 | 21.88 | 21.93 | 12700.0 |
> showing 50 of 3,227 rows — these rows as CSV