PREVIEW / etf_daily / 2024-05-16
file: by_date/etf_daily/2024/2024-05-16.parquet size: 120 KB rows: 3,346
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-16 | SPY | ETF | 529.88 | 531.52 | 528.54 | 528.69 | 50244800.0 |
| 2024-05-16 | QQQ | ETF | 452.71 | 454.69 | 451.81 | 451.98 | 34780412.0 |
| 2024-05-16 | IWM | ETF | 208.9 | 209.35 | 207.93 | 207.93 | 26731100.0 |
| 2024-05-16 | DIA | ETF | 399.75 | 401.0 | 399.13 | 399.21 | 2877200.0 |
| 2024-05-16 | GLD | ETF | 220.14 | 220.59 | 219.41 | 220.03 | 4301700.0 |
| 2024-05-16 | TLT | ETF | 92.39 | 92.42 | 91.94 | 92.01 | 37902400.0 |
| 2024-05-16 | AAA | ETF | 25.07 | 25.155 | 25.07 | 25.155 | 1600.0 |
| 2024-05-16 | AAAU | ETF | 23.56 | 23.59 | 23.47 | 23.54 | 1744100.0 |
| 2024-05-16 | AADR | ETF | 64.9 | 65.05 | 64.9 | 65.05 | 200.0 |
| 2024-05-16 | AAPB | ETF | 21.23 | 21.325 | 21.02 | 21.06 | 149528.0 |
| 2024-05-16 | AAPD | ETF | 20.43 | 20.49 | 20.3399 | 20.46 | 110347.0 |
| 2024-05-16 | AAPR | ETF | 24.89 | 24.91 | 24.83 | 24.87 | 49991.0 |
| 2024-05-16 | AAPU | ETF | 27.32 | 27.51 | 27.1 | 27.15 | 267313.0 |
| 2024-05-16 | AAPX | ETF | 24.611 | 24.81 | 24.53 | 24.61 | 19382.0 |
| 2024-05-16 | AAPY | ETF | 25.43 | 25.43 | 25.3101 | 25.3644 | 891.0 |
| 2024-05-16 | AAXJ | ETF | 72.98 | 73.32 | 72.82 | 73.11 | 926300.0 |
| 2024-05-16 | ABCS | ETF | 26.8001 | 26.88 | 26.8001 | 26.8216 | 5160.0 |
| 2024-05-16 | ABEQ | ETF | 30.79 | 30.805 | 30.76 | 30.805 | 3500.0 |
| 2024-05-16 | ACES | ETF | 29.72 | 29.89 | 29.61 | 29.8 | 548800.0 |
| 2024-05-16 | ACIO | ETF | 36.56 | 36.65 | 36.5 | 36.525 | 122500.0 |
| 2024-05-16 | ACSI | ETF | 53.812 | 53.812 | 53.812 | 53.812 | 100.0 |
| 2024-05-16 | ACT | ETF | 31.55 | 31.65 | 31.34 | 31.53 | 149376.0 |
| 2024-05-16 | ACTV | ETF | 34.2 | 34.32 | 34.2 | 34.312 | 5300.0 |
| 2024-05-16 | ACVF | ETF | 40.28 | 40.37 | 40.201 | 40.201 | 3700.0 |
| 2024-05-16 | ACWF | ETF | 42.4 | 42.4 | 42.28 | 42.2934 | 7734.0 |
| 2024-05-16 | ACWI | ETF | 112.18 | 112.36 | 111.87 | 111.9 | 2796900.0 |
| 2024-05-16 | ACWV | ETF | 105.61 | 106.1 | 105.61 | 105.74 | 96900.0 |
| 2024-05-16 | ACWX | ETF | 55.02 | 55.06 | 54.89 | 54.9 | 530700.0 |
| 2024-05-16 | ADFI | ETF | 8.5 | 8.5 | 8.47 | 8.49 | 21100.0 |
| 2024-05-16 | ADIV | ETF | 15.0 | 15.14 | 15.0 | 15.109 | 1100.0 |
| 2024-05-16 | ADME | ETF | 42.44 | 42.49 | 42.3 | 42.3 | 7000.0 |
| 2024-05-16 | ADPV | ETF | 31.8 | 31.8 | 31.282 | 31.282 | 6855.0 |
| 2024-05-16 | AEMB | ETF | 38.73 | 38.73 | 38.675 | 38.675 | 300.0 |
| 2024-05-16 | AESR | ETF | 15.77 | 15.78 | 15.72 | 15.72 | 52300.0 |
| 2024-05-16 | AETH | ETF | 39.23 | 39.24 | 38.689 | 38.741 | 6007.0 |
| 2024-05-16 | AFIF | ETF | 9.09 | 9.1 | 9.08 | 9.09 | 18900.0 |
| 2024-05-16 | AFK | ETF | 16.0 | 16.0 | 15.89 | 15.99 | 4800.0 |
| 2024-05-16 | AFLG | ETF | 31.028 | 31.028 | 31.028 | 31.028 | 200.0 |
| 2024-05-16 | AFMC | ETF | 30.35 | 30.35 | 30.076 | 30.076 | 500.0 |
| 2024-05-16 | AFSM | ETF | 29.224 | 29.224 | 29.224 | 29.224 | 100.0 |
| 2024-05-16 | AFTY | ETF | 14.66 | 14.675 | 14.66 | 14.675 | 700.0 |
| 2024-05-16 | AGG | ETF | 97.23 | 97.27 | 97.01 | 97.08 | 7894400.0 |
| 2024-05-16 | AGGH | ETF | 21.14 | 21.14 | 20.9867 | 21.0191 | 40335.0 |
| 2024-05-16 | AGGS | ETF | 40.87 | 40.87 | 40.7955 | 40.7955 | 300.0 |
| 2024-05-16 | AGGY | ETF | 43.15 | 43.15 | 43.03 | 43.055 | 91000.0 |
| 2024-05-16 | AGMI | ETF | 27.44 | 27.6683 | 27.44 | 27.6683 | 101.0 |
| 2024-05-16 | AGNG | ETF | 30.36 | 30.36 | 30.27 | 30.36 | 2100.0 |
| 2024-05-16 | AGOX | ETF | 26.02 | 26.42 | 25.88 | 25.88 | 17400.0 |
| 2024-05-16 | AGQ | ETF | 39.54 | 40.13 | 39.01 | 39.84 | 1074700.0 |
| 2024-05-16 | AGQI | ETF | 14.39 | 14.41 | 14.3606 | 14.3606 | 12538.0 |
> showing 50 of 3,346 rows — these rows as CSV