PREVIEW / etf_daily / 2024-06-24
file: by_date/etf_daily/2024/2024-06-24.parquet size: 121 KB rows: 3,391
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-06-24 | SPY | ETF | 544.33 | 546.95 | 542.62 | 542.74 | 45528700.0 |
| 2024-06-24 | QQQ | ETF | 478.18 | 479.93 | 473.82 | 473.96 | 37750969.0 |
| 2024-06-24 | IWM | ETF | 200.69 | 202.69 | 200.53 | 201.22 | 22289600.0 |
| 2024-06-24 | DIA | ETF | 392.47 | 395.59 | 391.9 | 393.98 | 3096600.0 |
| 2024-06-24 | GLD | ETF | 215.55 | 215.94 | 215.2 | 215.63 | 4626900.0 |
| 2024-06-24 | TLT | ETF | 94.05 | 94.34 | 93.74 | 94.34 | 56939100.0 |
| 2024-06-24 | AAA | ETF | 25.16 | 25.163 | 25.085 | 25.105 | 3200.0 |
| 2024-06-24 | AAAU | ETF | 23.06 | 23.1 | 23.02 | 23.08 | 1717100.0 |
| 2024-06-24 | AADR | ETF | 61.99 | 61.99 | 61.75 | 61.86 | 700.0 |
| 2024-06-24 | AAPB | ETF | 24.69 | 25.88 | 24.4485 | 24.82 | 339178.0 |
| 2024-06-24 | AAPD | ETF | 18.7 | 18.79 | 18.245 | 18.64 | 323449.0 |
| 2024-06-24 | AAPR | ETF | 25.28 | 25.2835 | 25.21 | 25.24 | 16607.0 |
| 2024-06-24 | AAPU | ETF | 31.9 | 33.45 | 31.58 | 32.08 | 1591233.0 |
| 2024-06-24 | AAPX | ETF | 28.68 | 30.11 | 28.571 | 28.86 | 36706.0 |
| 2024-06-24 | AAPY | ETF | 26.55 | 26.61 | 26.5318 | 26.5318 | 1215.0 |
| 2024-06-24 | AAXJ | ETF | 72.19 | 72.67 | 72.09 | 72.1 | 268300.0 |
| 2024-06-24 | ABCS | ETF | 26.14 | 26.365 | 26.13 | 26.23 | 3717.0 |
| 2024-06-24 | ABEQ | ETF | 30.54 | 30.55 | 30.49 | 30.55 | 3400.0 |
| 2024-06-24 | ACES | ETF | 28.38 | 28.857 | 28.38 | 28.71 | 56100.0 |
| 2024-06-24 | ACIO | ETF | 37.653 | 37.77 | 37.57 | 37.6 | 122300.0 |
| 2024-06-24 | ACSI | ETF | 55.069 | 55.069 | 55.069 | 55.069 | 100.0 |
| 2024-06-24 | ACT | ETF | 30.5 | 30.9 | 30.4 | 30.73 | 133139.0 |
| 2024-06-24 | ACTV | ETF | 31.98 | 32.42 | 31.98 | 32.26 | 5300.0 |
| 2024-06-24 | ACVF | ETF | 41.5 | 41.54 | 41.334 | 41.334 | 4700.0 |
| 2024-06-24 | ACWF | ETF | 42.45 | 42.53 | 42.2978 | 42.2978 | 6562.0 |
| 2024-06-24 | ACWI | ETF | 112.27 | 113.06 | 112.25 | 112.25 | 3223300.0 |
| 2024-06-24 | ACWV | ETF | 104.79 | 105.7 | 104.79 | 105.43 | 127800.0 |
| 2024-06-24 | ACWX | ETF | 53.24 | 53.51 | 53.21 | 53.24 | 390100.0 |
| 2024-06-24 | ADFI | ETF | 8.51 | 8.525 | 8.5 | 8.525 | 3100.0 |
| 2024-06-24 | ADIV | ETF | 14.77 | 14.82 | 14.75 | 14.781 | 1700.0 |
| 2024-06-24 | ADME | ETF | 43.83 | 43.83 | 43.606 | 43.606 | 7100.0 |
| 2024-06-24 | ADPV | ETF | 30.04 | 30.04 | 29.9201 | 30.0282 | 5825.0 |
| 2024-06-24 | AEMB | ETF | 38.601 | 38.601 | 38.601 | 38.601 | 100.0 |
| 2024-06-24 | AESR | ETF | 16.345 | 16.42 | 16.25 | 16.25 | 21500.0 |
| 2024-06-24 | AETH | ETF | 43.19 | 43.34 | 42.4699 | 42.8513 | 10162.0 |
| 2024-06-24 | AFIF | ETF | 9.11 | 9.12 | 9.1 | 9.11 | 9300.0 |
| 2024-06-24 | AFK | ETF | 15.48 | 15.98 | 15.44 | 15.75 | 9700.0 |
| 2024-06-24 | AFLG | ETF | 31.84 | 31.84 | 31.767 | 31.767 | 300.0 |
| 2024-06-24 | AFMC | ETF | 29.5 | 29.85 | 29.45 | 29.45 | 603200.0 |
| 2024-06-24 | AFSM | ETF | 28.1 | 28.13 | 28.1 | 28.124 | 1000.0 |
| 2024-06-24 | AFTY | ETF | 14.075 | 14.075 | 14.075 | 14.075 | 100.0 |
| 2024-06-24 | AGG | ETF | 97.82 | 97.86 | 97.72 | 97.84 | 5017300.0 |
| 2024-06-24 | AGGH | ETF | 21.13 | 21.18 | 21.01 | 21.1125 | 24306.0 |
| 2024-06-24 | AGGY | ETF | 43.35 | 43.41 | 43.35 | 43.38 | 56500.0 |
| 2024-06-24 | AGMI | ETF | 26.16 | 26.19 | 25.9921 | 25.9921 | 475.0 |
| 2024-06-24 | AGNG | ETF | 30.281 | 30.38 | 30.28 | 30.301 | 1100.0 |
| 2024-06-24 | AGOX | ETF | 29.37 | 29.47 | 27.52 | 28.428 | 34300.0 |
| 2024-06-24 | AGQ | ETF | 38.54 | 38.74 | 38.03 | 38.29 | 787600.0 |
| 2024-06-24 | AGQI | ETF | 14.5 | 14.56 | 14.49 | 14.5476 | 87560.0 |
| 2024-06-24 | AGRH | ETF | 25.9001 | 25.9252 | 25.9001 | 25.9252 | 111.0 |
> showing 50 of 3,391 rows — these rows as CSV