PREVIEW / etf_daily / 2024-05-24
file: by_date/etf_daily/2024/2024-05-24.parquet size: 119 KB rows: 3,324
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-24 | SPY | ETF | 527.85 | 530.27 | 526.88 | 529.44 | 41258400.0 |
| 2024-05-24 | QQQ | ETF | 455.29 | 459.23 | 453.5674 | 457.95 | 29669461.0 |
| 2024-05-24 | IWM | ETF | 204.79 | 205.68 | 203.96 | 205.44 | 19905800.0 |
| 2024-05-24 | DIA | ETF | 391.22 | 392.25 | 390.16 | 390.64 | 2071000.0 |
| 2024-05-24 | GLD | ETF | 216.96 | 217.21 | 215.74 | 215.92 | 4208800.0 |
| 2024-05-24 | TLT | ETF | 90.97 | 91.47 | 90.9 | 91.38 | 19151400.0 |
| 2024-05-24 | AAA | ETF | 25.23 | 25.23 | 25.13 | 25.16 | 2100.0 |
| 2024-05-24 | AAAU | ETF | 23.22 | 23.24 | 23.08 | 23.11 | 1773000.0 |
| 2024-05-24 | AADR | ETF | 62.83 | 63.83 | 62.83 | 63.67 | 400.0 |
| 2024-05-24 | AAPB | ETF | 20.628 | 21.13 | 20.62 | 20.99 | 77910.0 |
| 2024-05-24 | AAPD | ETF | 20.59 | 20.6874 | 20.41 | 20.47 | 97106.0 |
| 2024-05-24 | AAPR | ETF | 24.88 | 24.9087 | 24.83 | 24.86 | 46415.0 |
| 2024-05-24 | AAPU | ETF | 26.81 | 27.2693 | 26.58 | 27.12 | 291061.0 |
| 2024-05-24 | AAPX | ETF | 24.139 | 24.619 | 24.109 | 24.4861 | 10375.0 |
| 2024-05-24 | AAXJ | ETF | 71.99 | 72.31 | 71.99 | 72.16 | 589800.0 |
| 2024-05-24 | ABCS | ETF | 26.59 | 26.59 | 26.48 | 26.543 | 1650.0 |
| 2024-05-24 | ABEQ | ETF | 30.41 | 30.41 | 30.34 | 30.357 | 8800.0 |
| 2024-05-24 | ACES | ETF | 30.38 | 31.51 | 30.27 | 31.49 | 62700.0 |
| 2024-05-24 | ACIO | ETF | 36.46 | 36.52 | 36.385 | 36.47 | 102000.0 |
| 2024-05-24 | ACSI | ETF | 53.482 | 53.482 | 53.482 | 53.482 | 100.0 |
| 2024-05-24 | ACT | ETF | 30.84 | 31.19 | 30.81 | 30.9 | 167700.0 |
| 2024-05-24 | ACTV | ETF | 33.2 | 33.225 | 33.195 | 33.195 | 2300.0 |
| 2024-05-24 | ACVF | ETF | 40.03 | 40.21 | 40.03 | 40.106 | 91600.0 |
| 2024-05-24 | ACWF | ETF | 42.09 | 42.31 | 42.09 | 42.17 | 756.0 |
| 2024-05-24 | ACWI | ETF | 111.37 | 111.86 | 111.24 | 111.7 | 927600.0 |
| 2024-05-24 | ACWV | ETF | 104.82 | 105.01 | 104.75 | 104.81 | 144000.0 |
| 2024-05-24 | ACWX | ETF | 54.35 | 54.65 | 54.35 | 54.55 | 501400.0 |
| 2024-05-24 | ADFI | ETF | 8.41 | 8.469 | 8.401 | 8.459 | 15300.0 |
| 2024-05-24 | ADIV | ETF | 14.77 | 14.77 | 14.765 | 14.765 | 600.0 |
| 2024-05-24 | ADME | ETF | 42.34 | 42.36 | 42.236 | 42.236 | 8400.0 |
| 2024-05-24 | ADPV | ETF | 31.5824 | 31.6899 | 31.58 | 31.585 | 9618.0 |
| 2024-05-24 | AEMB | ETF | 38.37 | 38.56 | 38.37 | 38.41 | 1100.0 |
| 2024-05-24 | AESR | ETF | 15.78 | 15.85 | 15.78 | 15.83 | 16500.0 |
| 2024-05-24 | AETH | ETF | 49.06 | 49.34 | 48.21 | 49.3042 | 18889.0 |
| 2024-05-24 | AFIF | ETF | 9.09 | 9.1 | 9.08 | 9.1 | 13400.0 |
| 2024-05-24 | AFK | ETF | 15.73 | 16.0 | 15.55 | 15.94 | 69700.0 |
| 2024-05-24 | AFLG | ETF | 31.069 | 31.069 | 31.069 | 31.069 | 100.0 |
| 2024-05-24 | AFMC | ETF | 29.881 | 29.881 | 29.881 | 29.881 | 200.0 |
| 2024-05-24 | AFSM | ETF | 29.028 | 29.028 | 29.028 | 29.028 | 100.0 |
| 2024-05-24 | AFTY | ETF | 14.49 | 14.49 | 14.45 | 14.465 | 1400.0 |
| 2024-05-24 | AGG | ETF | 96.43 | 96.62 | 96.39 | 96.58 | 3072100.0 |
| 2024-05-24 | AGGH | ETF | 20.84 | 20.84 | 20.68 | 20.8 | 71081.0 |
| 2024-05-24 | AGGS | ETF | 40.6096 | 40.64 | 40.6096 | 40.64 | 200.0 |
| 2024-05-24 | AGGY | ETF | 42.65 | 42.78 | 42.65 | 42.76 | 94700.0 |
| 2024-05-24 | AGMI | ETF | 28.23 | 28.23 | 27.9705 | 27.9705 | 102.0 |
| 2024-05-24 | AGNG | ETF | 29.734 | 29.75 | 29.68 | 29.75 | 3300.0 |
| 2024-05-24 | AGOX | ETF | 26.37 | 26.59 | 26.18 | 26.54 | 10800.0 |
| 2024-05-24 | AGQ | ETF | 42.08 | 42.29 | 41.16 | 41.55 | 1064900.0 |
| 2024-05-24 | AGQI | ETF | 14.29 | 14.38 | 14.29 | 14.35 | 19527.0 |
| 2024-05-24 | AGRH | ETF | 26.0 | 26.0 | 25.985 | 25.985 | 746.0 |
> showing 50 of 3,324 rows — these rows as CSV