PREVIEW / etf_daily / 2024-01-29
file: by_date/etf_daily/2024/2024-01-29.parquet size: 117 KB rows: 3,260
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-29 | SPY | ETF | 487.73 | 491.42 | 487.17 | 491.27 | 61322800.0 |
| 2024-01-29 | QQQ | ETF | 424.27 | 428.35 | 423.61 | 428.15 | 38694724.0 |
| 2024-01-29 | IWM | ETF | 196.16 | 199.41 | 195.09 | 199.41 | 29234400.0 |
| 2024-01-29 | DIA | ETF | 381.0 | 383.41 | 380.54 | 383.31 | 2730900.0 |
| 2024-01-29 | GLD | ETF | 188.31 | 188.54 | 187.19 | 188.33 | 5629700.0 |
| 2024-01-29 | TLT | ETF | 94.31 | 95.17 | 94.12 | 94.86 | 38243600.0 |
| 2024-01-29 | AAA | ETF | 25.15 | 25.15 | 25.11 | 25.11 | 1700.0 |
| 2024-01-29 | AAAU | ETF | 20.14 | 20.15 | 20.01 | 20.13 | 1533700.0 |
| 2024-01-29 | AADR | ETF | 55.95 | 55.95 | 55.95 | 55.95 | 200.0 |
| 2024-01-29 | AAPB | ETF | 22.5 | 22.51 | 22.16 | 22.51 | 24041.0 |
| 2024-01-29 | AAPD | ETF | 20.29 | 20.53 | 20.28 | 20.31 | 202593.0 |
| 2024-01-29 | AAPU | ETF | 27.04 | 27.12 | 26.57 | 27.04 | 330132.0 |
| 2024-01-29 | AAPX | ETF | 26.34 | 26.44 | 25.76 | 26.322 | 12084.0 |
| 2024-01-29 | AAXJ | ETF | 64.14 | 64.31 | 63.72 | 64.08 | 789400.0 |
| 2024-01-29 | ABCS | ETF | 25.2914 | 25.2914 | 25.2914 | 25.2914 | 2.0 |
| 2024-01-29 | ABEQ | ETF | 28.52 | 28.665 | 28.52 | 28.665 | 1900.0 |
| 2024-01-29 | ACES | ETF | 29.62 | 30.86 | 29.36 | 30.85 | 93800.0 |
| 2024-01-29 | ACIO | ETF | 33.95 | 34.17 | 33.92 | 34.13 | 37700.0 |
| 2024-01-29 | ACSI | ETF | 50.191 | 50.191 | 50.191 | 50.191 | 100.0 |
| 2024-01-29 | ACT | ETF | 28.74 | 28.8128 | 28.4 | 28.63 | 277285.0 |
| 2024-01-29 | ACTV | ETF | 32.84 | 33.29 | 32.79 | 33.29 | 10400.0 |
| 2024-01-29 | ACVF | ETF | 37.48 | 37.67 | 37.37 | 37.67 | 7200.0 |
| 2024-01-29 | ACWF | ETF | 38.8 | 38.9314 | 38.6101 | 38.9314 | 1960.0 |
| 2024-01-29 | ACWI | ETF | 102.9 | 103.61 | 102.77 | 103.56 | 5161200.0 |
| 2024-01-29 | ACWV | ETF | 101.63 | 102.06 | 101.56 | 101.99 | 113200.0 |
| 2024-01-29 | ACWX | ETF | 50.37 | 50.64 | 50.25 | 50.59 | 2052400.0 |
| 2024-01-29 | ADFI | ETF | 8.545 | 8.6 | 8.53 | 8.6 | 123300.0 |
| 2024-01-29 | ADIV | ETF | 13.705 | 13.766 | 13.705 | 13.766 | 1100.0 |
| 2024-01-29 | ADME | ETF | 39.41 | 39.64 | 39.41 | 39.64 | 7600.0 |
| 2024-01-29 | ADPV | ETF | 25.252 | 25.5314 | 25.252 | 25.5314 | 2778.0 |
| 2024-01-29 | AEMB | ETF | 37.8 | 37.8 | 37.8 | 37.8 | 100.0 |
| 2024-01-29 | AESR | ETF | 14.31 | 14.41 | 14.31 | 14.402 | 206200.0 |
| 2024-01-29 | AETH | ETF | 31.11 | 31.6448 | 30.704 | 31.6448 | 3271.0 |
| 2024-01-29 | AFIF | ETF | 9.09 | 9.17 | 9.07 | 9.1 | 9200.0 |
| 2024-01-29 | AFK | ETF | 13.27 | 13.5 | 13.27 | 13.49 | 16600.0 |
| 2024-01-29 | AFLG | ETF | 28.24 | 28.24 | 28.24 | 28.24 | 100.0 |
| 2024-01-29 | AFMC | ETF | 27.107 | 27.107 | 27.107 | 27.107 | 100.0 |
| 2024-01-29 | AFSM | ETF | 27.26 | 27.47 | 27.26 | 27.446 | 700.0 |
| 2024-01-29 | AFTY | ETF | 13.02 | 13.066 | 13.02 | 13.066 | 11200.0 |
| 2024-01-29 | AGG | ETF | 98.3 | 98.53 | 98.19 | 98.46 | 6423600.0 |
| 2024-01-29 | AGGH | ETF | 21.61 | 21.67 | 21.55 | 21.67 | 48617.0 |
| 2024-01-29 | AGGY | ETF | 43.49 | 43.568 | 43.445 | 43.52 | 404400.0 |
| 2024-01-29 | AGNG | ETF | 28.14 | 28.386 | 28.01 | 28.386 | 2600.0 |
| 2024-01-29 | AGOX | ETF | 24.24 | 24.42 | 24.09 | 24.332 | 54500.0 |
| 2024-01-29 | AGQ | ETF | 25.05 | 25.59 | 24.6 | 25.54 | 1236000.0 |
| 2024-01-29 | AGQI | ETF | 13.46 | 13.53 | 13.43 | 13.53 | 29118.0 |
| 2024-01-29 | AGZ | ETF | 108.3 | 108.47 | 108.28 | 108.45 | 10500.0 |
| 2024-01-29 | AGZD | ETF | 21.94 | 21.95 | 21.88 | 21.93 | 26200.0 |
| 2024-01-29 | AHLT | ETF | 22.32 | 22.3709 | 22.32 | 22.3709 | 8705.0 |
| 2024-01-29 | AHOY | ETF | 21.93 | 22.0884 | 21.93 | 22.0884 | 383.0 |
> showing 50 of 3,260 rows — these rows as CSV