PREVIEW / etf_daily / 2024-01-05
file: by_date/etf_daily/2024/2024-01-05.parquet size: 116 KB rows: 3,229
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-05 | SPY | ETF | 467.49 | 470.44 | 466.43 | 467.92 | 86060800.0 |
| 2024-01-05 | QQQ | ETF | 396.45 | 399.56 | 395.34 | 396.75 | 44922810.0 |
| 2024-01-05 | IWM | ETF | 192.69 | 195.46 | 192.29 | 193.25 | 40945900.0 |
| 2024-01-05 | DIA | ETF | 374.43 | 376.25 | 373.21 | 374.64 | 5380300.0 |
| 2024-01-05 | GLD | ETF | 189.68 | 191.26 | 189.08 | 189.35 | 7481200.0 |
| 2024-01-05 | TLT | ETF | 96.5 | 97.68 | 96.21 | 96.29 | 45883000.0 |
| 2024-01-05 | AAA | ETF | 25.04 | 25.04 | 25.0 | 25.02 | 5600.0 |
| 2024-01-05 | AAAU | ETF | 20.28 | 20.44 | 20.2 | 20.24 | 3090700.0 |
| 2024-01-05 | AADR | ETF | 54.87 | 55.01 | 54.87 | 55.01 | 200.0 |
| 2024-01-05 | AAPB | ETF | 20.72 | 20.8544 | 20.4 | 20.57 | 26951.0 |
| 2024-01-05 | AAPD | ETF | 21.37 | 21.5699 | 21.27 | 21.46 | 253910.0 |
| 2024-01-05 | AAPU | ETF | 25.12 | 25.27 | 24.75 | 24.96 | 164405.0 |
| 2024-01-05 | AAPY | ETF | 25.28 | 25.28 | 25.28 | 25.28 | 316.0 |
| 2024-01-05 | AAXJ | ETF | 64.95 | 65.32 | 64.77 | 64.82 | 585300.0 |
| 2024-01-05 | ABCS | ETF | 24.95 | 24.95 | 24.8857 | 24.8857 | 3701.0 |
| 2024-01-05 | ABEQ | ETF | 28.68 | 28.68 | 28.604 | 28.604 | 1200.0 |
| 2024-01-05 | ACES | ETF | 33.05 | 34.035 | 32.96 | 33.1 | 263900.0 |
| 2024-01-05 | ACIO | ETF | 32.82 | 32.89 | 32.66 | 32.77 | 73800.0 |
| 2024-01-05 | ACSI | ETF | 49.055 | 49.055 | 49.055 | 49.055 | 100.0 |
| 2024-01-05 | ACT | ETF | 28.51 | 28.81 | 28.38 | 28.43 | 155986.0 |
| 2024-01-05 | ACTV | ETF | 32.55 | 32.95 | 32.55 | 32.76 | 9100.0 |
| 2024-01-05 | ACVF | ETF | 36.03 | 36.13 | 35.92 | 36.04 | 5400.0 |
| 2024-01-05 | ACWF | ETF | 37.4897 | 37.4897 | 37.295 | 37.3312 | 2133.0 |
| 2024-01-05 | ACWI | ETF | 99.97 | 100.73 | 99.86 | 100.08 | 3524100.0 |
| 2024-01-05 | ACWV | ETF | 100.38 | 100.79 | 100.12 | 100.35 | 50800.0 |
| 2024-01-05 | ACWX | ETF | 50.16 | 50.59 | 50.07 | 50.21 | 1448100.0 |
| 2024-01-05 | ADFI | ETF | 8.48 | 8.55 | 8.48 | 8.495 | 36800.0 |
| 2024-01-05 | ADIV | ETF | 13.6 | 13.615 | 13.55 | 13.55 | 3900.0 |
| 2024-01-05 | ADME | ETF | 38.02 | 38.034 | 37.77 | 37.9 | 7900.0 |
| 2024-01-05 | ADPV | ETF | 23.79 | 23.94 | 23.79 | 23.9289 | 10541.0 |
| 2024-01-05 | AEMB | ETF | 37.52 | 37.52 | 37.45 | 37.45 | 600.0 |
| 2024-01-05 | AESR | ETF | 13.39 | 13.54 | 13.39 | 13.485 | 58800.0 |
| 2024-01-05 | AETH | ETF | 30.8431 | 31.31 | 30.68 | 31.0532 | 1208.0 |
| 2024-01-05 | AFIF | ETF | 9.05 | 9.05 | 9.04 | 9.05 | 20100.0 |
| 2024-01-05 | AFK | ETF | 13.99 | 14.07 | 13.9 | 13.97 | 4400.0 |
| 2024-01-05 | AFLG | ETF | 26.881 | 26.881 | 26.881 | 26.881 | 100.0 |
| 2024-01-05 | AFMC | ETF | 26.176 | 26.184 | 26.086 | 26.086 | 600.0 |
| 2024-01-05 | AFSM | ETF | 26.666 | 26.666 | 26.632 | 26.632 | 400.0 |
| 2024-01-05 | AFTY | ETF | 13.087 | 13.087 | 13.087 | 13.087 | 100.0 |
| 2024-01-05 | AGG | ETF | 98.13 | 98.69 | 98.07 | 98.2 | 9038700.0 |
| 2024-01-05 | AGGH | ETF | 21.91 | 21.98 | 21.74 | 21.74 | 162015.0 |
| 2024-01-05 | AGGY | ETF | 43.47 | 43.725 | 43.47 | 43.49 | 152000.0 |
| 2024-01-05 | AGNG | ETF | 28.34 | 28.49 | 28.27 | 28.27 | 1400.0 |
| 2024-01-05 | AGOX | ETF | 24.08 | 24.18 | 23.99 | 24.057 | 42700.0 |
| 2024-01-05 | AGQ | ETF | 25.5 | 26.41 | 25.23 | 25.67 | 1248200.0 |
| 2024-01-05 | AGQI | ETF | 13.12 | 13.215 | 13.12 | 13.1385 | 42104.0 |
| 2024-01-05 | AGZ | ETF | 107.98 | 108.31 | 107.93 | 107.95 | 15900.0 |
| 2024-01-05 | AGZD | ETF | 21.92 | 21.98 | 21.8 | 21.9 | 63400.0 |
| 2024-01-05 | AHLT | ETF | 21.82 | 21.82 | 21.6999 | 21.7152 | 14366.0 |
| 2024-01-05 | AHYB | ETF | 45.095 | 45.13 | 45.005 | 45.005 | 1200.0 |
> showing 50 of 3,229 rows — these rows as CSV