Have you tried using partition by in your second one instead of order by? That is:

SUM(Quantity) OVER (PARTITION BY EffectiveDate ORDER BY Holder RANGE UNBOUNDED PRECEDING) AS TQuantity

you may...