PREVIEW / etf_daily / 2024-05-31
file: by_date/etf_daily/2024/2024-05-31.parquet size: 121 KB rows: 3,370
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-05-31 | SPY | ETF | 523.59 | 527.5 | 518.36 | 527.37 | 90785800.0 |
| 2024-05-31 | QQQ | ETF | 451.78 | 452.48 | 443.055 | 450.71 | 55941301.0 |
| 2024-05-31 | IWM | ETF | 204.95 | 206.28 | 203.08 | 205.77 | 25784900.0 |
| 2024-05-31 | DIA | ETF | 381.98 | 387.61 | 381.27 | 387.53 | 4748400.0 |
| 2024-05-31 | GLD | ETF | 217.77 | 217.96 | 214.65 | 215.3 | 5617200.0 |
| 2024-05-31 | TLT | ETF | 90.48 | 90.66 | 90.25 | 90.45 | 41308800.0 |
| 2024-05-31 | AAA | ETF | 25.046 | 25.16 | 25.04 | 25.04 | 23400.0 |
| 2024-05-31 | AAAU | ETF | 23.3 | 23.31 | 22.97 | 23.04 | 1801800.0 |
| 2024-05-31 | AADR | ETF | 64.48 | 64.79 | 64.33 | 64.79 | 900.0 |
| 2024-05-31 | AAPB | ETF | 21.36 | 21.52 | 20.9648 | 21.49 | 104106.0 |
| 2024-05-31 | AAPD | ETF | 20.35 | 20.5165 | 20.25 | 20.26 | 129617.0 |
| 2024-05-31 | AAPR | ETF | 24.805 | 24.87 | 24.73 | 24.87 | 53588.0 |
| 2024-05-31 | AAPU | ETF | 27.47 | 27.78 | 27.04 | 27.77 | 391175.0 |
| 2024-05-31 | AAPX | ETF | 25.049 | 25.12 | 24.49 | 25.12 | 14088.0 |
| 2024-05-31 | AAPY | ETF | 25.24 | 25.2937 | 25.24 | 25.2937 | 632.0 |
| 2024-05-31 | AAXJ | ETF | 70.09 | 70.15 | 69.54 | 70.15 | 702700.0 |
| 2024-05-31 | ABCS | ETF | 26.3146 | 26.5603 | 26.3 | 26.5603 | 2164.0 |
| 2024-05-31 | ABEQ | ETF | 30.43 | 30.61 | 30.37 | 30.61 | 11500.0 |
| 2024-05-31 | ACES | ETF | 31.89 | 32.1 | 31.05 | 31.62 | 21500.0 |
| 2024-05-31 | ACIO | ETF | 36.22 | 36.4 | 35.96 | 36.4 | 197500.0 |
| 2024-05-31 | ACSI | ETF | 53.698 | 53.698 | 53.698 | 53.698 | 100.0 |
| 2024-05-31 | ACT | ETF | 30.66 | 30.76 | 30.55 | 30.71 | 159241.0 |
| 2024-05-31 | ACTV | ETF | 32.96 | 33.291 | 32.96 | 33.291 | 3700.0 |
| 2024-05-31 | ACVF | ETF | 39.63 | 39.827 | 39.31 | 39.827 | 2500.0 |
| 2024-05-31 | ACWF | ETF | 41.81 | 41.8617 | 41.32 | 41.8617 | 2050.0 |
| 2024-05-31 | ACWI | ETF | 110.49 | 111.1 | 109.57 | 111.08 | 1879700.0 |
| 2024-05-31 | ACWV | ETF | 103.65 | 104.49 | 103.49 | 104.43 | 180500.0 |
| 2024-05-31 | ACWX | ETF | 54.1 | 54.93 | 53.71 | 54.15 | 1898400.0 |
| 2024-05-31 | ADFI | ETF | 8.425 | 8.44 | 8.41 | 8.439 | 7700.0 |
| 2024-05-31 | ADIV | ETF | 14.37 | 14.41 | 14.37 | 14.4 | 1500.0 |
| 2024-05-31 | ADME | ETF | 41.96 | 42.17 | 41.67 | 42.17 | 13600.0 |
| 2024-05-31 | ADPV | ETF | 31.09 | 31.09 | 30.3672 | 30.9638 | 8405.0 |
| 2024-05-31 | AEMB | ETF | 38.352 | 38.43 | 38.352 | 38.43 | 700.0 |
| 2024-05-31 | AESR | ETF | 15.6 | 15.72 | 15.49 | 15.72 | 20000.0 |
| 2024-05-31 | AETH | ETF | 49.82 | 49.91 | 48.831 | 49.7219 | 4200.0 |
| 2024-05-31 | AFIF | ETF | 9.11 | 9.11 | 9.09 | 9.1 | 16100.0 |
| 2024-05-31 | AFK | ETF | 15.92 | 16.02 | 15.59 | 15.78 | 49000.0 |
| 2024-05-31 | AFLG | ETF | 30.5 | 31.002 | 30.5 | 31.002 | 1200.0 |
| 2024-05-31 | AFMC | ETF | 29.66 | 29.963 | 29.65 | 29.963 | 700.0 |
| 2024-05-31 | AFSM | ETF | 28.977 | 28.977 | 28.977 | 28.977 | 100.0 |
| 2024-05-31 | AFTY | ETF | 14.33 | 14.358 | 14.33 | 14.358 | 100.0 |
| 2024-05-31 | AGG | ETF | 96.46 | 96.59 | 96.41 | 96.52 | 8762900.0 |
| 2024-05-31 | AGGH | ETF | 20.73 | 20.79 | 20.64 | 20.72 | 67801.0 |
| 2024-05-31 | AGGY | ETF | 42.68 | 42.77 | 42.67 | 42.77 | 46700.0 |
| 2024-05-31 | AGMI | ETF | 28.875 | 28.875 | 28.31 | 28.4695 | 443.0 |
| 2024-05-31 | AGNG | ETF | 29.65 | 29.81 | 29.57 | 29.71 | 4400.0 |
| 2024-05-31 | AGOX | ETF | 26.46 | 26.46 | 26.09 | 26.4 | 21200.0 |
| 2024-05-31 | AGQ | ETF | 44.43 | 44.73 | 40.81 | 41.29 | 2201900.0 |
| 2024-05-31 | AGQI | ETF | 14.21 | 14.305 | 14.15 | 14.3 | 11519.0 |
| 2024-05-31 | AGZ | ETF | 107.32 | 107.35 | 107.19 | 107.26 | 266600.0 |
> showing 50 of 3,370 rows — these rows as CSV