PREVIEW / etf_daily / 2024-05-17
file: by_date/etf_daily/2024/2024-05-17.parquet size: 119 KB rows: 3,336
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-17 | SPY | ETF | 528.81 | 529.52 | 527.32 | 529.45 | 59187600.0 |
| 2024-05-17 | QQQ | ETF | 452.11 | 452.72 | 449.5399 | 451.76 | 35803719.0 |
| 2024-05-17 | IWM | ETF | 208.01 | 208.52 | 207.35 | 208.08 | 35219800.0 |
| 2024-05-17 | DIA | ETF | 399.11 | 400.02 | 398.44 | 399.95 | 2702900.0 |
| 2024-05-17 | GLD | ETF | 222.18 | 223.85 | 221.67 | 223.66 | 10481900.0 |
| 2024-05-17 | TLT | ETF | 91.64 | 91.8 | 91.34 | 91.39 | 24755000.0 |
| 2024-05-17 | AAA | ETF | 25.17 | 25.17 | 25.09 | 25.15 | 6300.0 |
| 2024-05-17 | AAAU | ETF | 23.77 | 23.94 | 23.72 | 23.92 | 2843300.0 |
| 2024-05-17 | AADR | ETF | 64.98 | 65.09 | 64.84 | 65.09 | 600.0 |
| 2024-05-17 | AAPB | ETF | 20.95 | 21.22 | 20.94 | 21.04 | 73116.0 |
| 2024-05-17 | AAPD | ETF | 20.53 | 20.54 | 20.4 | 20.46 | 125783.0 |
| 2024-05-17 | AAPR | ETF | 24.88 | 24.8899 | 24.82 | 24.83 | 50615.0 |
| 2024-05-17 | AAPU | ETF | 27.01 | 27.4199 | 26.95 | 27.16 | 205068.0 |
| 2024-05-17 | AAPX | ETF | 24.52 | 24.7 | 24.47 | 24.522 | 6376.0 |
| 2024-05-17 | AAPY | ETF | 25.3783 | 25.3844 | 25.3401 | 25.3844 | 2883.0 |
| 2024-05-17 | AAXJ | ETF | 73.22 | 73.64 | 73.09 | 73.45 | 888000.0 |
| 2024-05-17 | ABCS | ETF | 26.77 | 26.8615 | 26.77 | 26.8615 | 3018.0 |
| 2024-05-17 | ABEQ | ETF | 30.84 | 31.02 | 30.84 | 31.0 | 5500.0 |
| 2024-05-17 | ACES | ETF | 29.79 | 29.94 | 29.47 | 29.73 | 568500.0 |
| 2024-05-17 | ACIO | ETF | 36.485 | 36.55 | 36.46 | 36.55 | 111600.0 |
| 2024-05-17 | ACSI | ETF | 53.971 | 53.971 | 53.971 | 53.971 | 100.0 |
| 2024-05-17 | ACT | ETF | 31.55 | 31.59 | 31.38 | 31.51 | 225247.0 |
| 2024-05-17 | ACTV | ETF | 34.22 | 34.23 | 34.05 | 34.092 | 7900.0 |
| 2024-05-17 | ACVF | ETF | 40.29 | 40.29 | 40.06 | 40.154 | 1500.0 |
| 2024-05-17 | ACWF | ETF | 42.2938 | 42.3368 | 42.2938 | 42.3368 | 852.0 |
| 2024-05-17 | ACWI | ETF | 111.9 | 112.17 | 111.81 | 112.16 | 1785100.0 |
| 2024-05-17 | ACWV | ETF | 106.06 | 106.22 | 105.8 | 106.2 | 121700.0 |
| 2024-05-17 | ACWX | ETF | 54.9 | 55.13 | 54.84 | 55.11 | 379900.0 |
| 2024-05-17 | ADFI | ETF | 8.47 | 8.5 | 8.45 | 8.5 | 22300.0 |
| 2024-05-17 | ADIV | ETF | 15.165 | 15.165 | 15.165 | 15.165 | 100.0 |
| 2024-05-17 | ADME | ETF | 42.273 | 42.35 | 42.273 | 42.315 | 4900.0 |
| 2024-05-17 | ADPV | ETF | 31.28 | 31.51 | 31.27 | 31.338 | 13821.0 |
| 2024-05-17 | AEMB | ETF | 38.565 | 38.565 | 38.565 | 38.565 | 100.0 |
| 2024-05-17 | AESR | ETF | 15.72 | 15.75 | 15.68 | 15.75 | 45000.0 |
| 2024-05-17 | AETH | ETF | 40.47 | 41.06 | 40.379 | 40.6553 | 3989.0 |
| 2024-05-17 | AFIF | ETF | 9.09 | 9.09 | 9.09 | 9.09 | 2200.0 |
| 2024-05-17 | AFK | ETF | 15.98 | 16.0 | 15.88 | 15.88 | 3200.0 |
| 2024-05-17 | AFLG | ETF | 31.053 | 31.053 | 31.053 | 31.053 | 100.0 |
| 2024-05-17 | AFMC | ETF | 30.12 | 30.12 | 30.033 | 30.033 | 200.0 |
| 2024-05-17 | AFSM | ETF | 29.16 | 29.16 | 29.16 | 29.16 | 100.0 |
| 2024-05-17 | AFTY | ETF | 14.89 | 14.89 | 14.88 | 14.88 | 700.0 |
| 2024-05-17 | AGG | ETF | 96.92 | 97.0 | 96.77 | 96.77 | 5267100.0 |
| 2024-05-17 | AGGH | ETF | 21.08 | 21.08 | 20.95 | 21.02 | 37578.0 |
| 2024-05-17 | AGGY | ETF | 43.03 | 43.045 | 42.95 | 42.96 | 186900.0 |
| 2024-05-17 | AGMI | ETF | 28.29 | 29.334 | 28.29 | 29.334 | 1943.0 |
| 2024-05-17 | AGNG | ETF | 30.225 | 30.34 | 30.225 | 30.26 | 1600.0 |
| 2024-05-17 | AGOX | ETF | 26.14 | 26.14 | 25.45 | 25.73 | 11600.0 |
| 2024-05-17 | AGQ | ETF | 42.1 | 45.12 | 41.3 | 45.03 | 3268700.0 |
| 2024-05-17 | AGQI | ETF | 14.39 | 14.4018 | 14.3713 | 14.4 | 7008.0 |
| 2024-05-17 | AGZ | ETF | 107.43 | 107.45 | 107.36 | 107.37 | 21800.0 |
> showing 50 of 3,336 rows — these rows as CSV