PREVIEW / etf_daily / 2024-04-29
file: by_date/etf_daily/2024/2024-04-29.parquet size: 119 KB rows: 3,322
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-04-29 | SPY | ETF | 510.09 | 510.75 | 507.25 | 510.06 | 46415400.0 |
| 2024-04-29 | QQQ | ETF | 433.13 | 433.76 | 429.98 | 432.75 | 30022161.0 |
| 2024-04-29 | IWM | ETF | 199.25 | 200.41 | 198.88 | 199.96 | 20494600.0 |
| 2024-04-29 | DIA | ETF | 383.1 | 384.03 | 382.07 | 383.8 | 3265900.0 |
| 2024-04-29 | GLD | ETF | 216.02 | 217.22 | 215.25 | 216.18 | 6409900.0 |
| 2024-04-29 | TLT | ETF | 88.66 | 89.02 | 88.48 | 88.98 | 39228600.0 |
| 2024-04-29 | AAA | ETF | 25.18 | 25.185 | 25.108 | 25.15 | 4600.0 |
| 2024-04-29 | AAAU | ETF | 23.11 | 23.23 | 23.02 | 23.12 | 3341700.0 |
| 2024-04-29 | AADR | ETF | 61.6 | 61.6 | 61.55 | 61.55 | 700.0 |
| 2024-04-29 | AAPB | ETF | 17.68 | 18.21 | 17.66 | 17.75 | 183815.0 |
| 2024-04-29 | AAPD | ETF | 22.48 | 22.51 | 22.11 | 22.47 | 595362.0 |
| 2024-04-29 | AAPR | ETF | 24.52 | 24.58 | 24.4445 | 24.52 | 62448.0 |
| 2024-04-29 | AAPU | ETF | 22.81 | 23.489 | 22.75 | 22.87 | 707305.0 |
| 2024-04-29 | AAPX | ETF | 20.59 | 21.1943 | 20.59 | 20.65 | 30543.0 |
| 2024-04-29 | AAPY | ETF | 23.87 | 23.87 | 23.7048 | 23.7048 | 277.0 |
| 2024-04-29 | AAXJ | ETF | 68.62 | 69.0 | 68.58 | 68.98 | 209400.0 |
| 2024-04-29 | ABCS | ETF | 26.0501 | 26.19 | 26.0501 | 26.1447 | 1897.0 |
| 2024-04-29 | ABEQ | ETF | 29.98 | 30.01 | 29.93 | 29.961 | 47400.0 |
| 2024-04-29 | ACES | ETF | 27.34 | 27.79 | 27.34 | 27.68 | 22300.0 |
| 2024-04-29 | ACIO | ETF | 35.39 | 35.44 | 35.23 | 35.43 | 95100.0 |
| 2024-04-29 | ACSI | ETF | 51.76 | 51.76 | 51.716 | 51.716 | 800.0 |
| 2024-04-29 | ACT | ETF | 29.99 | 30.155 | 29.9 | 29.93 | 163339.0 |
| 2024-04-29 | ACTV | ETF | 33.28 | 33.374 | 33.21 | 33.374 | 3800.0 |
| 2024-04-29 | ACVF | ETF | 39.1 | 39.1 | 38.89 | 38.992 | 5600.0 |
| 2024-04-29 | ACWF | ETF | 40.5698 | 40.5698 | 40.55 | 40.5574 | 1973.0 |
| 2024-04-29 | ACWI | ETF | 107.74 | 107.93 | 107.37 | 107.85 | 1799800.0 |
| 2024-04-29 | ACWV | ETF | 102.67 | 103.14 | 102.67 | 103.04 | 85900.0 |
| 2024-04-29 | ACWX | ETF | 52.71 | 52.88 | 52.64 | 52.82 | 728700.0 |
| 2024-04-29 | ADFI | ETF | 8.38 | 8.38 | 8.35 | 8.37 | 17700.0 |
| 2024-04-29 | ADIV | ETF | 14.28 | 14.28 | 14.28 | 14.28 | 100.0 |
| 2024-04-29 | ADME | ETF | 40.96 | 40.98 | 40.75 | 40.931 | 5900.0 |
| 2024-04-29 | ADPV | ETF | 29.29 | 29.33 | 29.24 | 29.2669 | 1293.0 |
| 2024-04-29 | AEMB | ETF | 38.221 | 38.221 | 38.221 | 38.221 | 100.0 |
| 2024-04-29 | AESR | ETF | 15.02 | 15.02 | 14.97 | 15.009 | 18200.0 |
| 2024-04-29 | AETH | ETF | 41.39 | 41.905 | 40.9927 | 41.905 | 4689.0 |
| 2024-04-29 | AFIF | ETF | 9.07 | 9.07 | 9.04 | 9.06 | 43100.0 |
| 2024-04-29 | AFK | ETF | 14.9 | 15.1 | 14.79 | 15.09 | 7300.0 |
| 2024-04-29 | AFLG | ETF | 29.76 | 29.799 | 29.76 | 29.799 | 100.0 |
| 2024-04-29 | AFMC | ETF | 28.94 | 28.94 | 28.936 | 28.936 | 100.0 |
| 2024-04-29 | AFSM | ETF | 28.34 | 28.34 | 28.293 | 28.293 | 500.0 |
| 2024-04-29 | AFTY | ETF | 14.43 | 14.52 | 14.43 | 14.52 | 600.0 |
| 2024-04-29 | AGG | ETF | 95.6 | 95.67 | 95.45 | 95.62 | 7384600.0 |
| 2024-04-29 | AGGH | ETF | 20.52 | 20.65 | 20.5001 | 20.51 | 87867.0 |
| 2024-04-29 | AGGY | ETF | 42.28 | 42.328 | 42.23 | 42.3 | 72400.0 |
| 2024-04-29 | AGIH | ETF | 24.15 | 24.15 | 24.15 | 24.15 | 100.0 |
| 2024-04-29 | AGNG | ETF | 28.68 | 28.94 | 28.6 | 28.93 | 2700.0 |
| 2024-04-29 | AGOX | ETF | 24.93 | 25.19 | 24.881 | 25.19 | 26200.0 |
| 2024-04-29 | AGQ | ETF | 33.97 | 34.47 | 33.36 | 33.79 | 895000.0 |
| 2024-04-29 | AGQI | ETF | 13.84 | 13.8637 | 13.8154 | 13.8585 | 18120.0 |
| 2024-04-29 | AGZ | ETF | 106.7 | 106.89 | 106.7 | 106.76 | 11800.0 |
> showing 50 of 3,322 rows — these rows as CSV