PREVIEW / etf_daily / 2024-08-14
file: by_date/etf_daily/2024/2024-08-14.parquet size: 132 KB rows: 3,437
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-08-14 | SPY | ETF | 542.85 | 544.96 | 540.12 | 543.75 | 42316761.0 |
| 2024-08-14 | QQQ | ETF | 463.51 | 465.1093 | 458.4 | 462.73 | 34733746.0 |
| 2024-08-14 | IWM | ETF | 208.63 | 208.75 | 205.74 | 206.68 | 25316804.0 |
| 2024-08-14 | DIA | ETF | 397.74 | 400.88 | 397.51 | 400.09 | 5237627.0 |
| 2024-08-14 | GLD | ETF | 226.55 | 227.48 | 225.35 | 226.2 | 5458337.0 |
| 2024-08-14 | TLT | ETF | 97.55 | 98.16 | 97.5082 | 97.89 | 30718659.0 |
| 2024-08-14 | AAA | ETF | 25.0082 | 25.08 | 25.0001 | 25.045 | 1790.0 |
| 2024-08-14 | AAAU | ETF | 24.25 | 24.3353 | 24.1201 | 24.21 | 2079183.0 |
| 2024-08-14 | AADR | ETF | 61.15 | 61.16 | 61.1331 | 61.1331 | 480.0 |
| 2024-08-14 | AAPB | ETF | 27.3 | 27.89 | 27.14 | 27.55 | 81067.0 |
| 2024-08-14 | AAPD | ETF | 17.42 | 17.48 | 17.22 | 17.33 | 531886.0 |
| 2024-08-14 | AAPR | ETF | 25.52 | 25.57 | 25.52 | 25.5624 | 6294.0 |
| 2024-08-14 | AAPU | ETF | 34.98 | 35.77 | 34.72 | 35.33 | 504530.0 |
| 2024-08-14 | AAPX | ETF | 31.66 | 32.249 | 31.41 | 31.96 | 30652.0 |
| 2024-08-14 | AAXJ | ETF | 71.5 | 71.53 | 70.92 | 71.17 | 158764.0 |
| 2024-08-14 | ABCS | ETF | 26.75 | 26.75 | 26.6401 | 26.7174 | 1786.0 |
| 2024-08-14 | ABEQ | ETF | 31.2095 | 31.25 | 31.14 | 31.24 | 3713.0 |
| 2024-08-14 | ABNY | ETF | 80.0995 | 80.0995 | 79.175 | 79.175 | 717.0 |
| 2024-08-14 | ACES | ETF | 28.17 | 28.17 | 27.44 | 27.51 | 28367.0 |
| 2024-08-14 | ACIO | ETF | 37.94 | 38.18 | 37.9 | 38.08 | 116627.0 |
| 2024-08-14 | ACSI | ETF | 55.45 | 55.45 | 55.415 | 55.415 | 919.0 |
| 2024-08-14 | ACT | ETF | 33.41 | 33.43 | 33.05 | 33.27 | 144199.0 |
| 2024-08-14 | ACTV | ETF | 31.43 | 31.55 | 31.43 | 31.5206 | 8997.0 |
| 2024-08-14 | ACVF | ETF | 41.33 | 41.35 | 41.27 | 41.3488 | 12243.0 |
| 2024-08-14 | ACWI | ETF | 112.52 | 112.795 | 112.03 | 112.61 | 1620309.0 |
| 2024-08-14 | ACWV | ETF | 108.79 | 109.59 | 108.79 | 109.59 | 186925.0 |
| 2024-08-14 | ACWX | ETF | 53.5 | 53.55 | 53.32 | 53.52 | 544000.0 |
| 2024-08-14 | ADFI | ETF | 8.6906 | 8.73 | 8.686 | 8.719 | 8194.0 |
| 2024-08-14 | ADIV | ETF | 14.6659 | 14.6659 | 14.6659 | 14.6659 | 36.0 |
| 2024-08-14 | ADME | ETF | 43.89 | 44.1651 | 43.89 | 44.1481 | 14156.0 |
| 2024-08-14 | ADPV | ETF | 30.35 | 30.5 | 30.34 | 30.4359 | 10017.0 |
| 2024-08-14 | AEMB | ETF | 39.4 | 39.4 | 39.3128 | 39.3128 | 1673.0 |
| 2024-08-14 | AESR | ETF | 16.37 | 16.37 | 16.12 | 16.22 | 21319.0 |
| 2024-08-14 | AETH | ETF | 35.35 | 35.35 | 34.3001 | 34.6561 | 4471.0 |
| 2024-08-14 | AFIF | ETF | 9.28 | 9.28 | 9.1999 | 9.205 | 19650.0 |
| 2024-08-14 | AFK | ETF | 15.69 | 15.8 | 15.541 | 15.73 | 4462.0 |
| 2024-08-14 | AFLG | ETF | 31.8638 | 31.98 | 31.81 | 31.96 | 14663.0 |
| 2024-08-14 | AFMC | ETF | 30.0 | 30.0 | 29.93 | 29.9777 | 518.0 |
| 2024-08-14 | AFSM | ETF | 28.91 | 28.91 | 28.66 | 28.8177 | 8485.0 |
| 2024-08-14 | AFTY | ETF | 13.87 | 13.87 | 13.87 | 13.87 | 39.0 |
| 2024-08-14 | AGG | ETF | 100.15 | 100.4 | 100.14 | 100.3 | 9871532.0 |
| 2024-08-14 | AGGH | ETF | 21.67 | 21.72 | 21.544 | 21.72 | 65140.0 |
| 2024-08-14 | AGGY | ETF | 44.307 | 44.4 | 44.307 | 44.36 | 55156.0 |
| 2024-08-14 | AGIX | ETF | 24.0 | 24.08 | 23.88 | 24.0716 | 1136.0 |
| 2024-08-14 | AGMI | ETF | 25.19 | 25.3369 | 25.19 | 25.3369 | 100.0 |
| 2024-08-14 | AGNG | ETF | 31.65 | 31.755 | 31.598 | 31.6279 | 1362.0 |
| 2024-08-14 | AGOX | ETF | 28.205 | 28.205 | 27.74 | 28.085 | 33165.0 |
| 2024-08-14 | AGQ | ETF | 32.76 | 33.13 | 31.56 | 32.32 | 1630219.0 |
| 2024-08-14 | AGQI | ETF | 14.1131 | 14.17 | 14.1131 | 14.1618 | 19643.0 |
| 2024-08-14 | AGRH | ETF | 25.855 | 25.88 | 25.855 | 25.855 | 453.0 |
> showing 50 of 3,437 rows — these rows as CSV