PREVIEW / etf_daily / 2024-01-03
file: by_date/etf_daily/2024/2024-01-03.parquet size: 116 KB rows: 3,233
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-03 | SPY | ETF | 470.43 | 471.19 | 468.17 | 468.79 | 103585900.0 |
| 2024-01-03 | QQQ | ETF | 399.93 | 401.0 | 397.89 | 398.33 | 47002803.0 |
| 2024-01-03 | IWM | ETF | 197.4 | 197.67 | 193.78 | 194.2 | 57532500.0 |
| 2024-01-03 | DIA | ETF | 375.57 | 376.12 | 373.9 | 374.21 | 6393600.0 |
| 2024-01-03 | GLD | ETF | 188.77 | 189.86 | 188.16 | 189.13 | 8661600.0 |
| 2024-01-03 | TLT | ETF | 97.38 | 98.85 | 97.15 | 98.72 | 58159500.0 |
| 2024-01-03 | AAA | ETF | 25.02 | 25.08 | 24.984 | 25.025 | 7500.0 |
| 2024-01-03 | AAAU | ETF | 20.18 | 20.29 | 20.11 | 20.22 | 2110100.0 |
| 2024-01-03 | AADR | ETF | 54.33 | 54.51 | 54.33 | 54.39 | 700.0 |
| 2024-01-03 | AAPB | ETF | 21.2 | 21.4101 | 21.13 | 21.23 | 41369.0 |
| 2024-01-03 | AAPD | ETF | 21.1 | 21.17 | 20.9 | 21.08 | 373589.0 |
| 2024-01-03 | AAPU | ETF | 25.61 | 25.92 | 25.45 | 25.62 | 120653.0 |
| 2024-01-03 | AAXJ | ETF | 64.91 | 65.36 | 64.78 | 65.22 | 423900.0 |
| 2024-01-03 | ABCS | ETF | 24.97 | 24.9916 | 24.8107 | 24.8107 | 1800.0 |
| 2024-01-03 | ABEQ | ETF | 28.49 | 28.547 | 28.48 | 28.547 | 2600.0 |
| 2024-01-03 | ACES | ETF | 34.98 | 34.98 | 33.65 | 34.17 | 26500.0 |
| 2024-01-03 | ACIO | ETF | 32.89 | 32.97 | 32.88 | 32.88 | 53600.0 |
| 2024-01-03 | ACSI | ETF | 49.198 | 49.198 | 49.198 | 49.198 | 100.0 |
| 2024-01-03 | ACT | ETF | 28.52 | 28.65 | 28.3 | 28.42 | 139197.0 |
| 2024-01-03 | ACTV | ETF | 33.22 | 33.22 | 32.595 | 32.647 | 6200.0 |
| 2024-01-03 | ACVF | ETF | 36.08 | 36.11 | 35.98 | 35.98 | 8300.0 |
| 2024-01-03 | ACWF | ETF | 37.41 | 37.4381 | 37.27 | 37.2936 | 3030.0 |
| 2024-01-03 | ACWI | ETF | 100.27 | 100.54 | 99.94 | 100.1 | 3666800.0 |
| 2024-01-03 | ACWV | ETF | 100.17 | 100.67 | 100.17 | 100.31 | 350700.0 |
| 2024-01-03 | ACWX | ETF | 50.04 | 50.24 | 49.88 | 50.09 | 1868100.0 |
| 2024-01-03 | ADFI | ETF | 8.56 | 8.565 | 8.53 | 8.565 | 1700.0 |
| 2024-01-03 | ADIV | ETF | 13.623 | 13.629 | 13.623 | 13.629 | 100.0 |
| 2024-01-03 | ADME | ETF | 38.13 | 38.16 | 38.0 | 38.0 | 44400.0 |
| 2024-01-03 | ADPV | ETF | 23.87 | 23.87 | 23.8039 | 23.8039 | 11171.0 |
| 2024-01-03 | AEMB | ETF | 37.505 | 37.606 | 37.505 | 37.606 | 1200.0 |
| 2024-01-03 | AESR | ETF | 13.5 | 13.55 | 13.46 | 13.46 | 163700.0 |
| 2024-01-03 | AETH | ETF | 30.57 | 30.92 | 30.19 | 30.6853 | 6975.0 |
| 2024-01-03 | AFIF | ETF | 9.03 | 9.05 | 9.01 | 9.03 | 427700.0 |
| 2024-01-03 | AFK | ETF | 13.92 | 13.92 | 13.86 | 13.86 | 3400.0 |
| 2024-01-03 | AFLG | ETF | 27.16 | 27.16 | 26.955 | 26.955 | 500.0 |
| 2024-01-03 | AFMC | ETF | 26.101 | 26.101 | 26.101 | 26.101 | 100.0 |
| 2024-01-03 | AFSM | ETF | 26.99 | 26.99 | 26.707 | 26.707 | 300.0 |
| 2024-01-03 | AFTY | ETF | 13.24 | 13.241 | 13.24 | 13.241 | 300.0 |
| 2024-01-03 | AGG | ETF | 98.45 | 98.94 | 98.31 | 98.83 | 10002100.0 |
| 2024-01-03 | AGGH | ETF | 21.97 | 22.08 | 21.885 | 22.08 | 45773.0 |
| 2024-01-03 | AGGY | ETF | 43.64 | 43.82 | 43.6 | 43.81 | 230100.0 |
| 2024-01-03 | AGNG | ETF | 28.45 | 28.45 | 28.36 | 28.41 | 1500.0 |
| 2024-01-03 | AGOX | ETF | 24.18 | 24.21 | 24.065 | 24.15 | 38300.0 |
| 2024-01-03 | AGQ | ETF | 25.37 | 25.71 | 24.96 | 25.36 | 3092700.0 |
| 2024-01-03 | AGQI | ETF | 13.1 | 13.175 | 13.0822 | 13.1243 | 23708.0 |
| 2024-01-03 | AGZ | ETF | 108.08 | 108.35 | 108.07 | 108.33 | 56300.0 |
| 2024-01-03 | AGZD | ETF | 21.87 | 21.93 | 21.8 | 21.83 | 29000.0 |
| 2024-01-03 | AHLT | ETF | 21.735 | 21.8001 | 21.7094 | 21.736 | 16004.0 |
| 2024-01-03 | AHYB | ETF | 44.926 | 45.085 | 44.926 | 45.073 | 1100.0 |
| 2024-01-03 | AIA | ETF | 56.1 | 56.75 | 56.1 | 56.71 | 31000.0 |
> showing 50 of 3,233 rows — these rows as CSV