SPY Options History — October 2007

In October 2007, SPY traded between $149.67 and $156.48. ATM implied volatility averaged 16.9%, placing in the 44.4% IV rank vs the trailing year. The 30-day expected move averaged 4.9%. IV traded above realized volatility by 3.6% (HV 20d: 13.3%). Max pain ranged from $152.00 to $155.00. Net GEX was positive for 4 of 23 trading days. Term structure was in contango for 19 of 23 days. Put/call ratio averaged 1.83.

Notable Days

  • 2007-10-19: Highest Volume — 1,389,089 contracts
  • 2007-10-11: Largest IV spike — 26.6% change
  • 2007-10-19: Highest IV Rank — 64.0%
  • 2007-10-19: Largest Expected Move — 5.9%

Monthly Statistics

MetricAvgMinMaxOpenClose
Price$153.87$149.67$156.48$154.30$154.65
Max Pain$153.91$152.00$155.00$152.00$154.00
ATM IV16.9%13.0%20.7%15.3%16.1%
Expected Move4.9%4.3%5.9%4.4%4.6%
HV 20d13.3%9.5%14.7%14.7%14.5%
HV 60d18.3%16.8%19.0%19.0%16.8%
IV Rank44.4%24.9%64.0%36.6%40.4%
IV Percentile73.3%52.9%87.1%69.5%68.9%
Term Structure0.5%-0.9%1.9%1.1%0.6%
VWIV17.8%15.3%21.0%16.1%17.0%
Skew 25d5.7%4.8%6.8%5.3%5.4%
Skew 10d11.0%9.5%12.5%10.6%9.9%
Call IV 25d14.3%12.3%17.4%12.5%13.8%
Put IV 25d20.1%17.5%24.2%17.8%19.2%
Bid-Ask Spread %3.522.065.773.052.41
Gamma HHI0.050.040.290.040.04
Net GEX-483.2M-2.10B210.8M-208.1M-510.1M
Net DEX-7.54B-16.49B7.61B-10.86B-9.05B
Net VEX-190.0M-207.6M-169.9M-169.9M-201.4M
Div Yield0.0%0.0%0.0%0.0%0.0%
P/C Ratio1.831.092.451.812.17
Total Volume621,110.435257,1221,389,089523,824852,730
Total OI8,963,337.4787,978,2819,926,2907,978,2819,438,406

Daily Data (23 trading days)

DatePriceMax PainATM IVExp MoveHV 20dIV RankVWIVSkew 25dTerm StrGEXDEXVEXP/CSpread %Call WallPut WallCall VolPut VolCall OIPut OI
2007-10-01$154.30$152.0015.3%4.4%14.7%36.6%16.1%5.3%1.1%-208.1M-10.86B-169.9M1.813.05N/AN/A186,139337,6852,787,5245,190,757
2007-10-02$154.09$152.0015.5%4.4%14.5%37.4%15.5%5.3%1.5%-256.1M-10.12B-175.8M1.203.77N/AN/A216,933261,2292,846,7905,287,272
2007-10-03$153.78$152.0015.0%4.3%14.1%35.1%15.3%5.2%1.9%-280.4M-9.17B-179.0M1.273.39N/AN/A211,042267,9492,929,5255,360,893
2007-10-04$154.02$152.0015.2%4.4%14.1%36.1%15.7%4.8%1.7%-275.4M-9.68B-179.9M1.673.69N/AN/A121,177202,8082,962,9705,440,883
2007-10-05$155.85$153.0013.0%4.4%13.1%24.9%16.7%5.5%0.5%94.3M-14.76B-174.8M1.914.61N/AN/A252,279481,4753,013,2895,494,951
2007-10-08$155.02$154.0014.4%4.6%13.4%31.9%16.9%5.7%0.2%-158.2M-12.34B-180.6M2.192.95N/AN/A80,655176,4673,110,5345,776,893
2007-10-09$156.48$154.0013.6%4.3%13.2%27.6%16.0%5.2%0.7%210.8M-16.49B-173.8M2.044.00N/AN/A128,606262,6493,124,6335,817,305
2007-10-10$156.22$154.0013.7%4.4%13.3%28.4%15.8%5.3%0.8%72.6M-15.12B-177.9M2.453.70N/AN/A93,707229,5053,154,6015,917,472
2007-10-11$155.47$155.0017.4%5.0%13.4%47.0%17.4%5.7%0.4%-221.5M-12.14B-186.2M1.795.77N/AN/A269,518482,1183,162,1685,973,204
2007-10-12$156.33$155.0016.0%4.6%13.5%40.1%17.0%5.3%0.6%94.4M-15.02B-183.2M1.693.10N/AN/A155,468262,3783,235,0216,148,647
2007-10-15$155.01$155.0017.9%5.1%13.8%49.6%17.6%5.7%0.4%-271.6M-10.49B-188.7M1.093.28N/AN/A339,782369,7373,283,0786,194,136
2007-10-16$153.78$155.0018.2%5.2%10.0%51.4%18.7%5.9%0.5%-679.1M-6.73B-192.9M1.663.87N/AN/A241,455401,9513,392,6086,282,044
2007-10-17$154.25$155.0016.7%4.8%9.8%43.5%16.8%5.5%1.1%-627.0M-8.33B-192.4M1.503.26N/AN/A336,755503,4863,450,6186,329,606
2007-10-18$153.69$155.0016.7%4.8%9.5%43.4%17.3%5.6%1.2%-831.6M-6.83B-193.0M2.253.34N/AN/A157,235353,1693,501,6186,386,109
2007-10-19$149.67$155.0020.7%5.9%13.5%64.0%20.2%6.8%-0.6%-2.10B7.61B-195.8M2.224.97N/AN/A431,522957,5673,509,8856,416,405
2007-10-22$150.54$155.0019.6%5.6%13.7%58.3%20.2%6.5%0.1%-841.2M2.51B-198.6M2.103.22N/AN/A263,796552,9842,985,1695,108,734
2007-10-23$151.76$154.0018.1%5.2%14.0%50.8%18.4%6.3%0.5%-860.0M51.1M-201.5M1.942.86N/AN/A186,156361,3013,078,5535,320,942
2007-10-24$151.48$154.0019.2%5.5%13.9%56.6%20.1%6.5%0.1%-824.1M432.6M-203.4M2.033.70N/AN/A333,881676,6563,146,7635,404,419
2007-10-25$151.84$154.0019.4%5.6%13.7%57.6%21.0%6.4%-0.1%-794.8M-338.7M-207.6M2.194.38N/AN/A225,361493,6213,230,4435,557,208
2007-10-26$153.62$154.0017.5%5.0%14.3%47.5%18.8%6.0%0.6%-620.0M-5.31B-205.7M1.163.16N/AN/A282,865328,3263,298,7965,697,482
2007-10-29$154.13$153.0018.4%5.3%13.8%52.1%19.4%5.8%-0.2%-521.4M-7.20B-202.3M1.372.06N/AN/A176,936242,1343,378,2725,764,413
2007-10-30$153.06$154.0020.1%5.8%14.0%60.8%21.0%6.3%-0.9%-700.6M-3.98B-206.1M2.372.42N/AN/A159,213377,1343,416,6885,849,035
2007-10-31$154.65$154.0016.1%4.6%14.5%40.4%17.0%5.4%0.6%-510.1M-9.05B-201.4M2.172.41N/AN/A269,243583,4873,464,9065,973,500