PREVIEW / etf_daily / 2024-06-14
file: by_date/etf_daily/2024/2024-06-14.parquet size: 121 KB rows: 3,390
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-14 | SPY | ETF | 540.88 | 542.81 | 539.85 | 542.78 | 40089900.0 |
| 2024-06-14 | QQQ | ETF | 476.52 | 479.26 | 476.05 | 479.19 | 23372620.0 |
| 2024-06-14 | IWM | ETF | 199.56 | 200.04 | 197.94 | 198.73 | 33453700.0 |
| 2024-06-14 | DIA | ETF | 384.62 | 386.54 | 383.63 | 386.46 | 2884300.0 |
| 2024-06-14 | GLD | ETF | 215.34 | 216.04 | 214.98 | 215.73 | 7076500.0 |
| 2024-06-14 | TLT | ETF | 94.42 | 94.84 | 94.24 | 94.67 | 28776700.0 |
| 2024-06-14 | AAA | ETF | 25.08 | 25.15 | 25.08 | 25.081 | 1700.0 |
| 2024-06-14 | AAAU | ETF | 23.04 | 23.11 | 22.99 | 23.08 | 1726500.0 |
| 2024-06-14 | AADR | ETF | 62.63 | 62.68 | 61.61 | 61.95 | 2600.0 |
| 2024-06-14 | AAPB | ETF | 26.24 | 26.55 | 25.6494 | 25.92 | 206862.0 |
| 2024-06-14 | AAPD | ETF | 18.15 | 18.35 | 18.04 | 18.25 | 372087.0 |
| 2024-06-14 | AAPR | ETF | 25.17 | 25.2 | 25.14 | 25.19 | 26834.0 |
| 2024-06-14 | AAPU | ETF | 33.81 | 34.33 | 33.11 | 33.48 | 1188341.0 |
| 2024-06-14 | AAPX | ETF | 30.51 | 30.92 | 29.97 | 30.28 | 43277.0 |
| 2024-06-14 | AAPY | ETF | 27.0 | 27.0 | 26.5001 | 26.534 | 1914.0 |
| 2024-06-14 | AAXJ | ETF | 71.67 | 71.7 | 71.35 | 71.7 | 244200.0 |
| 2024-06-14 | ABCS | ETF | 25.95 | 25.95 | 25.8442 | 25.8442 | 3935.0 |
| 2024-06-14 | ABEQ | ETF | 29.869 | 29.96 | 29.869 | 29.934 | 2000.0 |
| 2024-06-14 | ACES | ETF | 30.43 | 30.56 | 29.85 | 29.86 | 21300.0 |
| 2024-06-14 | ACIO | ETF | 37.268 | 37.43 | 37.265 | 37.43 | 57800.0 |
| 2024-06-14 | ACSI | ETF | 54.378 | 54.378 | 54.378 | 54.378 | 100.0 |
| 2024-06-14 | ACT | ETF | 29.7 | 29.76 | 29.4 | 29.67 | 121143.0 |
| 2024-06-14 | ACTV | ETF | 31.48 | 31.6 | 31.388 | 31.586 | 2200.0 |
| 2024-06-14 | ACVF | ETF | 40.919 | 41.08 | 40.88 | 41.057 | 2100.0 |
| 2024-06-14 | ACWF | ETF | 41.83 | 42.02 | 41.83 | 41.9893 | 3125.0 |
| 2024-06-14 | ACWI | ETF | 111.29 | 111.66 | 111.06 | 111.66 | 1931500.0 |
| 2024-06-14 | ACWV | ETF | 103.27 | 103.6 | 103.13 | 103.54 | 250600.0 |
| 2024-06-14 | ACWX | ETF | 52.59 | 52.73 | 52.4 | 52.73 | 574400.0 |
| 2024-06-14 | ADFI | ETF | 8.5 | 8.55 | 8.5 | 8.54 | 20000.0 |
| 2024-06-14 | ADIV | ETF | 14.807 | 14.807 | 14.807 | 14.807 | 100.0 |
| 2024-06-14 | ADME | ETF | 43.3 | 43.44 | 43.3 | 43.426 | 12600.0 |
| 2024-06-14 | ADPV | ETF | 29.66 | 29.7108 | 29.66 | 29.7108 | 975.0 |
| 2024-06-14 | AEMB | ETF | 38.485 | 38.485 | 38.485 | 38.485 | 100.0 |
| 2024-06-14 | AESR | ETF | 16.23 | 16.28 | 16.21 | 16.28 | 32100.0 |
| 2024-06-14 | AETH | ETF | 46.04 | 46.04 | 44.07 | 44.451 | 4085.0 |
| 2024-06-14 | AFIF | ETF | 9.06 | 9.12 | 9.06 | 9.12 | 8900.0 |
| 2024-06-14 | AFK | ETF | 15.46 | 15.6 | 15.26 | 15.6 | 37800.0 |
| 2024-06-14 | AFLG | ETF | 31.48 | 31.521 | 31.48 | 31.521 | 4200.0 |
| 2024-06-14 | AFMC | ETF | 28.928 | 28.928 | 28.928 | 28.928 | 100.0 |
| 2024-06-14 | AFTY | ETF | 14.12 | 14.134 | 14.111 | 14.134 | 3200.0 |
| 2024-06-14 | AGG | ETF | 97.85 | 98.05 | 97.85 | 97.92 | 6239500.0 |
| 2024-06-14 | AGGH | ETF | 21.115 | 21.17 | 21.087 | 21.17 | 67576.0 |
| 2024-06-14 | AGGY | ETF | 43.44 | 43.461 | 43.405 | 43.435 | 67900.0 |
| 2024-06-14 | AGMI | ETF | 25.41 | 25.64 | 25.36 | 25.56 | 3851.0 |
| 2024-06-14 | AGNG | ETF | 30.01 | 30.15 | 30.01 | 30.15 | 1300.0 |
| 2024-06-14 | AGOX | ETF | 27.91 | 27.91 | 27.6 | 27.81 | 18800.0 |
| 2024-06-14 | AGQ | ETF | 37.5 | 38.58 | 37.13 | 38.57 | 1592900.0 |
| 2024-06-14 | AGQI | ETF | 14.29 | 14.3146 | 14.2654 | 14.29 | 7451.0 |
| 2024-06-14 | AGRH | ETF | 25.9239 | 25.96 | 25.89 | 25.8933 | 625.0 |
| 2024-06-14 | AGZ | ETF | 108.02 | 108.14 | 108.02 | 108.13 | 35800.0 |
> showing 50 of 3,390 rows — these rows as CSV