PREVIEW / etf_daily / 2024-05-22
file: by_date/etf_daily/2024/2024-05-22.parquet size: 120 KB rows: 3,337
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-22 | SPY | ETF | 530.65 | 531.38 | 527.6 | 529.83 | 48390000.0 |
| 2024-05-22 | QQQ | ETF | 456.06 | 456.82 | 453.08 | 455.71 | 25120040.0 |
| 2024-05-22 | IWM | ETF | 207.53 | 208.22 | 205.8 | 206.58 | 20853100.0 |
| 2024-05-22 | DIA | ETF | 397.95 | 398.85 | 395.51 | 396.66 | 2647200.0 |
| 2024-05-22 | GLD | ETF | 223.09 | 223.24 | 219.74 | 220.11 | 8903100.0 |
| 2024-05-22 | TLT | ETF | 91.27 | 91.78 | 91.26 | 91.7 | 38073700.0 |
| 2024-05-22 | AAA | ETF | 25.17 | 25.2 | 25.1 | 25.126 | 2700.0 |
| 2024-05-22 | AAAU | ETF | 23.87 | 23.88 | 23.51 | 23.56 | 3958300.0 |
| 2024-05-22 | AADR | ETF | 64.7 | 64.7 | 63.78 | 63.78 | 1000.0 |
| 2024-05-22 | AAPB | ETF | 21.55 | 21.6705 | 21.135 | 21.29 | 72375.0 |
| 2024-05-22 | AAPD | ETF | 20.23 | 20.4109 | 20.175 | 20.36 | 62565.0 |
| 2024-05-22 | AAPR | ETF | 24.89 | 24.93 | 24.86 | 24.895 | 36168.0 |
| 2024-05-22 | AAPU | ETF | 27.86 | 27.97 | 27.23 | 27.43 | 215599.0 |
| 2024-05-22 | AAPX | ETF | 25.1365 | 25.1365 | 24.62 | 24.75 | 10115.0 |
| 2024-05-22 | AAPY | ETF | 25.36 | 25.36 | 25.2143 | 25.2143 | 9493.0 |
| 2024-05-22 | AAXJ | ETF | 72.71 | 72.73 | 72.27 | 72.43 | 469300.0 |
| 2024-05-22 | ABCS | ETF | 26.775 | 26.775 | 26.655 | 26.7043 | 2900.0 |
| 2024-05-22 | ABEQ | ETF | 30.598 | 30.598 | 30.586 | 30.59 | 1500.0 |
| 2024-05-22 | ACES | ETF | 29.75 | 31.43 | 29.75 | 31.16 | 374100.0 |
| 2024-05-22 | ACIO | ETF | 36.66 | 36.67 | 36.475 | 36.58 | 112700.0 |
| 2024-05-22 | ACSI | ETF | 53.756 | 53.756 | 53.756 | 53.756 | 100.0 |
| 2024-05-22 | ACT | ETF | 31.12 | 31.47 | 31.03 | 31.44 | 211673.0 |
| 2024-05-22 | ACTV | ETF | 33.77 | 33.81 | 33.467 | 33.527 | 5100.0 |
| 2024-05-22 | ACVF | ETF | 40.35 | 40.35 | 40.08 | 40.097 | 5600.0 |
| 2024-05-22 | ACWF | ETF | 42.25 | 42.26 | 42.085 | 42.13 | 2080.0 |
| 2024-05-22 | ACWI | ETF | 112.0 | 112.07 | 111.32 | 111.72 | 2051000.0 |
| 2024-05-22 | ACWV | ETF | 105.52 | 105.95 | 105.52 | 105.62 | 91600.0 |
| 2024-05-22 | ACWX | ETF | 54.64 | 54.73 | 54.38 | 54.52 | 388400.0 |
| 2024-05-22 | ADFI | ETF | 8.455 | 8.49 | 8.45 | 8.475 | 12100.0 |
| 2024-05-22 | ADIV | ETF | 14.857 | 14.857 | 14.857 | 14.857 | 100.0 |
| 2024-05-22 | ADME | ETF | 42.45 | 42.498 | 42.25 | 42.37 | 5800.0 |
| 2024-05-22 | ADPV | ETF | 31.84 | 31.84 | 31.0101 | 31.15 | 17333.0 |
| 2024-05-22 | AEMB | ETF | 38.466 | 38.466 | 38.466 | 38.466 | 100.0 |
| 2024-05-22 | AESR | ETF | 15.83 | 15.865 | 15.72 | 15.749 | 27900.0 |
| 2024-05-22 | AETH | ETF | 48.54 | 49.66 | 48.44 | 49.2298 | 13407.0 |
| 2024-05-22 | AFIF | ETF | 9.09 | 9.1 | 9.08 | 9.1 | 6900.0 |
| 2024-05-22 | AFK | ETF | 16.28 | 16.28 | 15.92 | 15.96 | 8500.0 |
| 2024-05-22 | AFLG | ETF | 31.14 | 31.14 | 30.975 | 30.975 | 700.0 |
| 2024-05-22 | AFMC | ETF | 29.961 | 30.02 | 29.821 | 29.821 | 400.0 |
| 2024-05-22 | AFSM | ETF | 29.18 | 29.18 | 29.058 | 29.058 | 300.0 |
| 2024-05-22 | AFTY | ETF | 14.76 | 14.76 | 14.76 | 14.76 | 200.0 |
| 2024-05-22 | AGG | ETF | 96.66 | 96.89 | 96.65 | 96.74 | 3823600.0 |
| 2024-05-22 | AGGH | ETF | 20.98 | 20.9898 | 20.91 | 20.91 | 27473.0 |
| 2024-05-22 | AGGS | ETF | 40.73 | 40.73 | 40.7279 | 40.7279 | 303.0 |
| 2024-05-22 | AGGY | ETF | 42.95 | 43.02 | 42.94 | 42.95 | 42700.0 |
| 2024-05-22 | AGMI | ETF | 28.91 | 28.91 | 28.0737 | 28.0737 | 356.0 |
| 2024-05-22 | AGNG | ETF | 30.13 | 30.15 | 30.04 | 30.15 | 2800.0 |
| 2024-05-22 | AGOX | ETF | 26.2 | 26.2 | 25.73 | 25.83 | 19200.0 |
| 2024-05-22 | AGQ | ETF | 45.73 | 45.75 | 42.7 | 43.02 | 2473400.0 |
| 2024-05-22 | AGQI | ETF | 14.36 | 14.38 | 14.31 | 14.365 | 14275.0 |
> showing 50 of 3,337 rows — these rows as CSV