PREVIEW / etf_daily / 2024-01-24
file: by_date/etf_daily/2024/2024-01-24.parquet size: 117 KB rows: 3,245
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-24 | SPY | ETF | 487.81 | 488.77 | 484.88 | 485.39 | 81765000.0 |
| 2024-01-24 | QQQ | ETF | 427.44 | 429.85 | 425.33 | 425.83 | 46948016.0 |
| 2024-01-24 | IWM | ETF | 198.38 | 198.46 | 194.12 | 194.36 | 41120100.0 |
| 2024-01-24 | DIA | ETF | 380.21 | 380.62 | 377.94 | 378.09 | 3967200.0 |
| 2024-01-24 | GLD | ETF | 188.33 | 188.37 | 186.32 | 186.4 | 6085400.0 |
| 2024-01-24 | TLT | ETF | 94.51 | 94.54 | 93.1 | 93.35 | 54574900.0 |
| 2024-01-24 | AAA | ETF | 25.12 | 25.16 | 25.08 | 25.125 | 1300.0 |
| 2024-01-24 | AAAU | ETF | 20.13 | 20.13 | 19.92 | 19.93 | 2987600.0 |
| 2024-01-24 | AADR | ETF | 55.17 | 55.17 | 55.17 | 55.17 | 200.0 |
| 2024-01-24 | AAPB | ETF | 23.6432 | 23.6432 | 23.17 | 23.21 | 39272.0 |
| 2024-01-24 | AAPD | ETF | 19.9 | 20.02 | 19.825 | 20.01 | 80652.0 |
| 2024-01-24 | AAPU | ETF | 27.85 | 28.0299 | 27.6 | 27.63 | 96954.0 |
| 2024-01-24 | AAPX | ETF | 27.5182 | 27.58 | 27.1479 | 27.1479 | 6009.0 |
| 2024-01-24 | AAPY | ETF | 26.77 | 26.77 | 26.7002 | 26.7002 | 480.0 |
| 2024-01-24 | AAXJ | ETF | 64.26 | 64.45 | 63.95 | 64.03 | 1333200.0 |
| 2024-01-24 | ABCS | ETF | 25.0 | 25.0 | 24.85 | 24.8715 | 15180.0 |
| 2024-01-24 | ABEQ | ETF | 28.61 | 28.61 | 28.248 | 28.248 | 10900.0 |
| 2024-01-24 | ACES | ETF | 30.98 | 31.07 | 29.72 | 29.81 | 72800.0 |
| 2024-01-24 | ACIO | ETF | 33.912 | 34.01 | 33.79 | 33.81 | 47100.0 |
| 2024-01-24 | ACSI | ETF | 49.663 | 49.663 | 49.663 | 49.663 | 100.0 |
| 2024-01-24 | ACT | ETF | 28.53 | 28.54 | 28.16 | 28.27 | 494003.0 |
| 2024-01-24 | ACTV | ETF | 32.98 | 32.98 | 32.42 | 32.432 | 5000.0 |
| 2024-01-24 | ACVF | ETF | 37.49 | 37.53 | 37.25 | 37.28 | 9400.0 |
| 2024-01-24 | ACWF | ETF | 38.6859 | 38.7239 | 38.5 | 38.5038 | 2146.0 |
| 2024-01-24 | ACWI | ETF | 102.95 | 103.07 | 102.32 | 102.38 | 5796800.0 |
| 2024-01-24 | ACWV | ETF | 101.88 | 101.93 | 101.26 | 101.34 | 287000.0 |
| 2024-01-24 | ACWX | ETF | 50.37 | 50.39 | 50.04 | 50.08 | 1936500.0 |
| 2024-01-24 | ADFI | ETF | 8.51 | 8.53 | 8.51 | 8.51 | 5300.0 |
| 2024-01-24 | ADIV | ETF | 13.78 | 13.789 | 13.74 | 13.74 | 1400.0 |
| 2024-01-24 | ADME | ETF | 39.36 | 39.445 | 39.2 | 39.21 | 19700.0 |
| 2024-01-24 | ADPV | ETF | 25.21 | 25.21 | 24.91 | 24.9324 | 6576.0 |
| 2024-01-24 | ADVE | ETF | 31.2999 | 31.3 | 31.213 | 31.213 | 826.0 |
| 2024-01-24 | AEMB | ETF | 37.311 | 37.311 | 37.311 | 37.311 | 100.0 |
| 2024-01-24 | AESR | ETF | 14.32 | 14.39 | 14.26 | 14.26 | 13200.0 |
| 2024-01-24 | AETH | ETF | 30.53 | 30.57 | 30.1818 | 30.1818 | 4441.0 |
| 2024-01-24 | AFIF | ETF | 9.09 | 9.1 | 9.08 | 9.09 | 29000.0 |
| 2024-01-24 | AFK | ETF | 13.8 | 13.8 | 13.3 | 13.53 | 3300.0 |
| 2024-01-24 | AFLG | ETF | 27.888 | 27.888 | 27.888 | 27.888 | 100.0 |
| 2024-01-24 | AFMC | ETF | 26.861 | 26.861 | 26.606 | 26.606 | 500.0 |
| 2024-01-24 | AFSM | ETF | 27.25 | 27.25 | 26.94 | 26.94 | 3900.0 |
| 2024-01-24 | AFTY | ETF | 13.27 | 13.28 | 13.26 | 13.274 | 1800.0 |
| 2024-01-24 | AGG | ETF | 98.29 | 98.33 | 97.7 | 97.74 | 11278500.0 |
| 2024-01-24 | AGGH | ETF | 21.78 | 21.8 | 21.54 | 21.54 | 84146.0 |
| 2024-01-24 | AGGY | ETF | 43.63 | 43.64 | 43.39 | 43.39 | 192700.0 |
| 2024-01-24 | AGNG | ETF | 28.52 | 28.52 | 28.13 | 28.13 | 1300.0 |
| 2024-01-24 | AGOX | ETF | 24.6 | 24.6 | 24.29 | 24.29 | 39600.0 |
| 2024-01-24 | AGQ | ETF | 24.93 | 24.98 | 24.29 | 24.36 | 2441500.0 |
| 2024-01-24 | AGQI | ETF | 13.38 | 13.405 | 13.31 | 13.3105 | 46153.0 |
| 2024-01-24 | AGZ | ETF | 108.34 | 108.34 | 107.98 | 107.98 | 12900.0 |
| 2024-01-24 | AGZD | ETF | 21.89 | 22.0 | 21.89 | 21.98 | 13800.0 |
> showing 50 of 3,245 rows — these rows as CSV