PREVIEW / etf_daily / 2024-06-17
file: by_date/etf_daily/2024/2024-06-17.parquet size: 121 KB rows: 3,414
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-06-17 | SPY | ETF | 542.08 | 548.53 | 541.61 | 547.1 | 55839500.0 |
| 2024-06-17 | QQQ | ETF | 479.46 | 486.86 | 478.14 | 485.06 | 37054504.0 |
| 2024-06-17 | IWM | ETF | 198.12 | 200.95 | 197.41 | 200.4 | 25538100.0 |
| 2024-06-17 | DIA | ETF | 385.25 | 389.21 | 384.98 | 388.58 | 2025300.0 |
| 2024-06-17 | GLD | ETF | 214.9 | 215.24 | 213.6 | 214.61 | 3877700.0 |
| 2024-06-17 | TLT | ETF | 93.52 | 93.81 | 93.28 | 93.73 | 31040200.0 |
| 2024-06-17 | AAA | ETF | 25.15 | 25.15 | 25.08 | 25.11 | 8300.0 |
| 2024-06-17 | AAAU | ETF | 22.99 | 23.03 | 22.85 | 22.95 | 1619300.0 |
| 2024-06-17 | AADR | ETF | 62.01 | 62.51 | 62.01 | 62.44 | 1700.0 |
| 2024-06-17 | AAPB | ETF | 26.18 | 27.5 | 25.99 | 26.97 | 488079.0 |
| 2024-06-17 | AAPD | ETF | 18.2 | 18.23 | 17.7201 | 17.9 | 335069.0 |
| 2024-06-17 | AAPR | ETF | 25.15 | 25.27 | 25.11 | 25.21 | 24175.0 |
| 2024-06-17 | AAPU | ETF | 33.76 | 35.53 | 33.57 | 34.84 | 1852351.0 |
| 2024-06-17 | AAPX | ETF | 30.425 | 32.01 | 30.38 | 31.35 | 86813.0 |
| 2024-06-17 | AAPY | ETF | 26.534 | 26.66 | 26.52 | 26.5985 | 2926.0 |
| 2024-06-17 | AAXJ | ETF | 71.84 | 72.29 | 71.7 | 72.22 | 288500.0 |
| 2024-06-17 | ABCS | ETF | 25.75 | 26.0447 | 25.75 | 26.0447 | 21957.0 |
| 2024-06-17 | ABEQ | ETF | 29.93 | 30.06 | 29.93 | 29.989 | 5100.0 |
| 2024-06-17 | ACES | ETF | 29.67 | 29.75 | 29.06 | 29.54 | 171100.0 |
| 2024-06-17 | ACIO | ETF | 37.41 | 37.74 | 37.35 | 37.61 | 120500.0 |
| 2024-06-17 | ACSI | ETF | 55.043 | 55.043 | 55.043 | 55.043 | 100.0 |
| 2024-06-17 | ACT | ETF | 29.62 | 29.92 | 29.58 | 29.9 | 163149.0 |
| 2024-06-17 | ACTV | ETF | 31.51 | 31.83 | 31.51 | 31.808 | 4100.0 |
| 2024-06-17 | ACVF | ETF | 41.11 | 41.57 | 41.06 | 41.469 | 5800.0 |
| 2024-06-17 | ACWF | ETF | 42.01 | 42.355 | 42.01 | 42.31 | 6344.0 |
| 2024-06-17 | ACWI | ETF | 111.49 | 112.57 | 111.39 | 112.37 | 999300.0 |
| 2024-06-17 | ACWV | ETF | 103.45 | 104.1 | 103.2 | 104.05 | 280700.0 |
| 2024-06-17 | ACWX | ETF | 52.67 | 52.95 | 52.48 | 52.91 | 1250600.0 |
| 2024-06-17 | ADFI | ETF | 8.49 | 8.53 | 8.48 | 8.51 | 9900.0 |
| 2024-06-17 | ADIV | ETF | 14.9 | 14.9 | 14.9 | 14.9 | 200.0 |
| 2024-06-17 | ADME | ETF | 43.43 | 43.85 | 43.43 | 43.69 | 8000.0 |
| 2024-06-17 | ADPV | ETF | 29.6 | 29.86 | 29.4001 | 29.8376 | 8840.0 |
| 2024-06-17 | AEMB | ETF | 38.7 | 38.7 | 38.18 | 38.51 | 400.0 |
| 2024-06-17 | AESR | ETF | 16.26 | 16.48 | 16.26 | 16.469 | 12400.0 |
| 2024-06-17 | AETH | ETF | 45.8296 | 46.645 | 45.635 | 46.3933 | 4557.0 |
| 2024-06-17 | AFIF | ETF | 9.12 | 9.12 | 9.1 | 9.12 | 6800.0 |
| 2024-06-17 | AFK | ETF | 15.65 | 15.79 | 15.5 | 15.69 | 27700.0 |
| 2024-06-17 | AFLG | ETF | 31.61 | 31.86 | 31.6 | 31.74 | 3500.0 |
| 2024-06-17 | AFMC | ETF | 28.895 | 29.28 | 28.85 | 29.273 | 2500.0 |
| 2024-06-17 | AFSM | ETF | 27.87 | 28.07 | 27.87 | 28.062 | 1900.0 |
| 2024-06-17 | AFTY | ETF | 14.145 | 14.145 | 14.141 | 14.145 | 6000.0 |
| 2024-06-17 | AGG | ETF | 97.57 | 97.6 | 97.45 | 97.57 | 5265000.0 |
| 2024-06-17 | AGGH | ETF | 21.11 | 21.11 | 20.9701 | 21.11 | 28317.0 |
| 2024-06-17 | AGGY | ETF | 43.28 | 43.31 | 43.241 | 43.29 | 46700.0 |
| 2024-06-17 | AGMI | ETF | 25.48 | 25.48 | 25.3568 | 25.3568 | 628.0 |
| 2024-06-17 | AGNG | ETF | 29.85 | 30.0 | 29.85 | 30.0 | 100900.0 |
| 2024-06-17 | AGOX | ETF | 27.87 | 28.1 | 27.775 | 27.85 | 8300.0 |
| 2024-06-17 | AGQ | ETF | 38.26 | 38.37 | 37.3 | 38.31 | 785200.0 |
| 2024-06-17 | AGQI | ETF | 14.2607 | 14.3603 | 14.2607 | 14.3603 | 2483.0 |
| 2024-06-17 | AGRH | ETF | 25.86 | 25.8731 | 25.86 | 25.8731 | 505.0 |
> showing 50 of 3,414 rows — these rows as CSV