PREVIEW / etf_daily / 2024-02-02
file: by_date/etf_daily/2024/2024-02-02.parquet size: 118 KB rows: 3,268
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-02-02 | SPY | ETF | 489.65 | 496.05 | 489.3 | 494.35 | 99147700.0 |
| 2024-02-02 | QQQ | ETF | 423.8 | 430.24 | 422.79 | 429.01 | 59602435.0 |
| 2024-02-02 | IWM | ETF | 193.24 | 195.5 | 192.39 | 194.41 | 52825000.0 |
| 2024-02-02 | DIA | ETF | 383.99 | 387.78 | 383.24 | 386.42 | 3344800.0 |
| 2024-02-02 | GLD | ETF | 188.07 | 188.87 | 187.85 | 188.61 | 7337000.0 |
| 2024-02-02 | TLT | ETF | 96.27 | 96.62 | 95.69 | 96.07 | 63803000.0 |
| 2024-02-02 | AAA | ETF | 25.128 | 25.128 | 25.075 | 25.075 | 2200.0 |
| 2024-02-02 | AAAU | ETF | 20.11 | 20.19 | 20.08 | 20.16 | 2897000.0 |
| 2024-02-02 | AADR | ETF | 56.68 | 56.68 | 56.55 | 56.55 | 700.0 |
| 2024-02-02 | AAPB | ETF | 19.76 | 21.379 | 19.6 | 21.1 | 177612.0 |
| 2024-02-02 | AAPD | ETF | 21.63 | 21.69 | 20.81 | 20.95 | 709242.0 |
| 2024-02-02 | AAPU | ETF | 24.57 | 26.04 | 24.4 | 25.75 | 415889.0 |
| 2024-02-02 | AAPX | ETF | 23.02 | 25.05 | 22.98 | 24.8134 | 17561.0 |
| 2024-02-02 | AAPY | ETF | 25.3799 | 25.7144 | 25.3799 | 25.7144 | 146.0 |
| 2024-02-02 | AAXJ | ETF | 63.34 | 63.51 | 63.15 | 63.39 | 2444000.0 |
| 2024-02-02 | ABCS | ETF | 25.11 | 25.11 | 25.1 | 25.1052 | 6118.0 |
| 2024-02-02 | ABEQ | ETF | 28.596 | 28.765 | 28.596 | 28.725 | 9600.0 |
| 2024-02-02 | ACES | ETF | 30.32 | 30.34 | 29.665 | 30.26 | 32100.0 |
| 2024-02-02 | ACIO | ETF | 34.15 | 34.464 | 34.13 | 34.38 | 90900.0 |
| 2024-02-02 | ACSI | ETF | 50.16 | 50.16 | 50.032 | 50.032 | 1000.0 |
| 2024-02-02 | ACT | ETF | 28.23 | 28.265 | 27.95 | 28.0 | 245676.0 |
| 2024-02-02 | ACTV | ETF | 32.751 | 33.13 | 32.751 | 32.96 | 19800.0 |
| 2024-02-02 | ACVF | ETF | 37.7 | 38.09 | 37.69 | 37.86 | 8300.0 |
| 2024-02-02 | ACWF | ETF | 38.96 | 39.0941 | 38.96 | 39.0941 | 3181.0 |
| 2024-02-02 | ACWI | ETF | 103.12 | 103.99 | 102.97 | 103.74 | 5939800.0 |
| 2024-02-02 | ACWV | ETF | 102.24 | 102.31 | 101.71 | 102.06 | 112400.0 |
| 2024-02-02 | ACWX | ETF | 50.3 | 50.35 | 50.09 | 50.3 | 1368000.0 |
| 2024-02-02 | ADFI | ETF | 8.6 | 8.61 | 8.52 | 8.56 | 8500.0 |
| 2024-02-02 | ADIV | ETF | 13.52 | 13.525 | 13.52 | 13.525 | 900.0 |
| 2024-02-02 | ADME | ETF | 39.44 | 40.11 | 39.44 | 39.995 | 8800.0 |
| 2024-02-02 | ADPV | ETF | 25.3734 | 25.73 | 25.3734 | 25.6571 | 4819.0 |
| 2024-02-02 | AEMB | ETF | 37.651 | 37.651 | 37.651 | 37.651 | 100.0 |
| 2024-02-02 | AESR | ETF | 14.38 | 14.59 | 14.32 | 14.55 | 16200.0 |
| 2024-02-02 | AETH | ETF | 31.38 | 31.565 | 31.38 | 31.5185 | 3093.0 |
| 2024-02-02 | AFIF | ETF | 9.12 | 9.14 | 9.11 | 9.12 | 18800.0 |
| 2024-02-02 | AFK | ETF | 13.53 | 13.53 | 13.12 | 13.25 | 8700.0 |
| 2024-02-02 | AFLG | ETF | 28.29 | 28.535 | 28.264 | 28.535 | 600.0 |
| 2024-02-02 | AFMC | ETF | 27.13 | 27.13 | 27.05 | 27.06 | 600.0 |
| 2024-02-02 | AFSM | ETF | 27.047 | 27.21 | 27.047 | 27.084 | 700.0 |
| 2024-02-02 | AFTY | ETF | 12.615 | 12.623 | 12.61 | 12.623 | 700.0 |
| 2024-02-02 | AGG | ETF | 98.49 | 98.62 | 98.26 | 98.46 | 8422500.0 |
| 2024-02-02 | AGGH | ETF | 22.0 | 22.0 | 21.69 | 21.73 | 60736.0 |
| 2024-02-02 | AGGY | ETF | 43.7 | 43.77 | 43.605 | 43.7 | 154400.0 |
| 2024-02-02 | AGNG | ETF | 28.19 | 28.39 | 28.19 | 28.39 | 700.0 |
| 2024-02-02 | AGOX | ETF | 24.45 | 24.69 | 24.44 | 24.575 | 22700.0 |
| 2024-02-02 | AGQ | ETF | 24.0 | 24.46 | 23.74 | 24.31 | 2591700.0 |
| 2024-02-02 | AGQI | ETF | 13.51 | 13.52 | 13.46 | 13.49 | 29356.0 |
| 2024-02-02 | AGZ | ETF | 108.36 | 108.38 | 108.11 | 108.34 | 99200.0 |
| 2024-02-02 | AGZD | ETF | 21.84 | 21.98 | 21.69 | 21.98 | 34900.0 |
| 2024-02-02 | AHLT | ETF | 22.4482 | 22.5368 | 22.4482 | 22.5368 | 722.0 |
> showing 50 of 3,268 rows — these rows as CSV