Raw Data

This page displays the raw data from 11/29/2017 - 11/29/2018 used to make the graphs.


The stock data was sourced using google finance. The option data was sourced from a curated list of option trades output by Trade-alert.com. The option orders are filtered based on a proprietary algorithm designed to find aggressive option order flow. The option orders are assumed to be long calls. Regardless of the assumptions made by the algorithms responsible for the call option data, there is no guarantee any party besides the owner of the options understands the intentions behind the trade. Through careful analysis, I hope to uncover patterns in the data to make informed trading decisions.

Date Sym Close Price Volume Call Volume Total Spent on Calls
2017-11-29SPY262.717751210252230000
2017-11-30SPY265.01127894389262756000
2017-12-01SPY264.46164390902151752000
2017-12-04SPY264.14940405601194000
2017-12-05SPY263.1977994544NULLNULL
2017-12-06SPY263.2475898566254000
2017-12-07SPY264.0777218569211905000
2017-12-08SPY265.51765638733157000
2017-12-11SPY266.3183077533NULLNULL
2017-12-12SPY266.78851957501990000
2017-12-13SPY266.75102905409347000
2017-12-14SPY265.66100666692NULLNULL
2017-12-15SPY266.5114461029091159000
2017-12-18SPY268.28365357272398000
2017-12-19SPY267.1782382876136000
2017-12-20SPY267.0376751500NULLNULL
2017-12-21SPY267.58670323394141000
2017-12-22SPY267.5178720873240000
2017-12-26SPY267.1945244433NULLNULL
2017-12-27SPY267.3257750986163000
2017-12-28SPY267.87451161393149000
2017-12-29SPY266.869600742419000
2018-01-02SPY268.77866557496343000
2018-01-03SPY270.47900704165628000
2018-01-04SPY271.6180636408306070000
2018-01-05SPY273.4283523995235511000
2018-01-08SPY273.92573191929344000
2018-01-09SPY274.5457253957164165000
2018-01-10SPY274.12695743182107000
2018-01-11SPY276.126236145517785000
2018-01-12SPY277.9290816076615772000
2018-01-16SPY276.97106555142101409000
2018-01-17SPY279.6111325879981218000
2018-01-18SPY279.141007280067685000
2018-01-19SPY280.41140920098360000
2018-01-22SPY282.6991322408213577000
2018-01-23SPY283.2997084700131089000
2018-01-24SPY283.18134816117181507000
2018-01-25SPY283.384587313105500000
2018-01-26SPY286.58107743119162975000
2018-01-29SPY284.68901183372491000
2018-01-30SPY281.7613179641991035000
2018-01-31SPY281.911894813171164000
2018-02-01SPY281.589010247092176000
2018-02-02SPY275.45173174790192832000
2018-02-05SPY263.93294681816176945000
2018-02-06SPY269.13355026782147048000
2018-02-07SPY267.671673761002240000
2018-02-08SPY257.6324644950564230000
2018-02-09SPY261.5283565315143498000
2018-02-12SPY265.3414373597641069000
2018-02-13SPY26681223640239000
2018-02-14SPY269.59120735685102807000
2018-02-15SPY273.031112002863751000
2018-02-16SPY273.111604201357878000
2018-02-20SPY271.48636966241089000
2018-02-21SPY270.05988837404628000
2018-02-22SPY270.4110511290131000
2018-02-23SPY274.7192766428191173000
2018-02-26SPY277.9864914063505000
2018-02-27SPY274.4399099165299000
2018-02-28SPY271.651219077678608000
2018-03-01SPY267.71768550772296000
2018-03-02SPY269.08139083217161956000
2018-03-05SPY272.1997307387162899000
2018-03-06SPY272.887921316361320000
2018-03-07SPY272.78870635023204000
2018-03-08SPY274.1669011504419000
2018-03-09SPY278.8711362533591293000
2018-03-12SPY278.52719247932194000
2018-03-13SPY276.72919689371498000
2018-03-14SPY275.3105895079149000
2018-03-15SPY275834330381150000
2018-03-16SPY274.210034367351506000
2018-03-19SPY270.49109208442316396000
2018-03-20SPY270.95597572714717000
2018-03-21SPY270.437870957851196000
2018-03-22SPY263.671487859163258000
2018-03-23SPY258.0518353475171604000
2018-03-26SPY265.11141956102202511000
2018-03-27SPY260.61299414452598000
2018-03-28SPY259.831464523063757000
2018-03-29SPY263.1512424479092561000
2018-04-02SPY257.47186286343133797000
2018-04-03SPY260.77119956861114461000
2018-04-04SPY263.56123715339324911000
2018-04-05SPY265.6482652618NULLNULL
2018-04-06SPY259.7217952120911860000
2018-04-09SPY261105442932192343000
2018-04-10SPY265.15105573736133517000
2018-04-11SPY263.76911402432538000
2018-04-12SPY265.93688904802403000
2018-04-13SPY265.15850791767959000
2018-04-16SPY267.33634052874757000
2018-04-17SPY270.1964682036121907000
2018-04-18SPY270.39573038572159000
2018-04-19SPY268.89776559095391000
2018-04-20SPY266.61999531332137000
2018-04-23SPY266.5765557954NULLNULL
2018-04-24SPY262.981128854522200000
2018-04-25SPY263.631038409484439000
2018-04-26SPY266.3167731942NULLNULL
2018-04-27SPY266.56570536472869000
2018-04-30SPY264.51821823246438000
2018-05-01SPY264.98742033652362000
2018-05-02SPY263.286368943135000
2018-05-03SPY262.6213631147992440000
2018-05-04SPY266.0291222075121609000
2018-05-07SPY266.9255304907NULLNULL
2018-05-08SPY266.9267499247NULLNULL
2018-05-09SPY269.5596661432760000
2018-05-10SPY272.0272063931381000
2018-05-11SPY272.8559871511NULLNULL
2018-05-14SPY272.98547906064683000
2018-05-15SPY271.187036136NULLNULL
2018-05-16SPY272.245394263142771000
2018-05-17SPY272.015653640041078000
2018-05-18SPY271.33643679592937000
2018-05-21SPY273.37580258754278000
2018-05-22SPY272.6152966358NULLNULL
2018-05-23SPY273.36646941846223000
2018-05-24SPY272.8760438271144000
2018-05-25SPY272.15563747553285000
2018-05-29SPY269.021159086076432000
2018-05-30SPY272.61696784493651000
2018-05-31SPY270.94935199414198000
2018-06-01SPY273.67125841163079000
2018-06-04SPY274.9453851664215000
2018-06-05SPY275.1511350381437000
2018-06-06SPY277.46273221511707000
2018-06-07SPY277.37729694021168000
2018-06-08SPY278.19721397192204000
2018-06-11SPY278.5658892515155000
2018-06-12SPY278.92723290282120000
2018-06-13SPY278.03790706103325000
2018-06-14SPY278.7377097620195000
2018-06-15SPY277.131200415625174000
2018-06-18SPY276.56529175812301000
2018-06-19SPY275.5975315102203000
2018-06-20SPY275.97537854864314000
2018-06-21SPY274.247106140412921000
2018-06-22SPY274.74566120033875000
2018-06-25SPY2711378541625453000
2018-06-26SPY271.668683211NULLNULL
2018-06-27SPY271.627258091595000
2018-06-28SPY270.89766505172106000
2018-06-29SPY271.28975924991106000
2018-07-02SPY271.86635547744315000
2018-07-03SPY270.942187071NULLNULL
2018-07-05SPY273.11569259192257000
2018-07-06SPY275.4266493696197000
2018-07-09SPY277.9505503996762000
2018-07-10SPY278.9519668295301000
2018-07-11SPY276.8677054739131226000
2018-07-12SPY279.376012468761057000
2018-07-13SPY279.59482349641488000
2018-07-16SPY279.3448201038NULLNULL
2018-07-17SPY280.4752315500142286000
2018-07-18SPY281.0644593465NULLNULL
2018-07-19SPY280614121173492000
2018-07-20SPY279.6882372729NULLNULL
2018-07-23SPY280.247047565NULLNULL
2018-07-24SPY281.6168026935NULLNULL
2018-07-25SPY284.0178882927NULLNULL
2018-07-26SPY283.3457919495NULLNULL
2018-07-27SPY281.4276783177NULLNULL
2018-07-30SPY279.95637425081929000
2018-07-31SPY281.336857049371327000
2018-08-01SPY280.86538533262117000
2018-08-02SPY282.39634263632291000
2018-08-03SPY283.653935386114000
2018-08-06SPY284.643940088711559000
2018-08-07SPY285.584319664671870000
2018-08-08SPY285.46421145514749000
2018-08-09SPY285.07357169762166000
2018-08-10SPY283.16770760445352000
2018-08-13SPY282.1657329098241000
2018-08-14SPY283.9438420316161000
2018-08-15SPY281.781029253552254000
2018-08-16SPY284.0669967919161567000
2018-08-17SPY285.06656184815890000
2018-08-20SPY285.67398074906262000
2018-08-21SPY286.3467271983152665000
2018-08-22SPY286.1744993333NULLNULL
2018-08-23SPY285.79492048511212000
2018-08-24SPY287.51574873995427000
2018-08-27SPY289.7857072377112271000
2018-08-28SPY289.92469434725308000
2018-08-29SPY291.4861485514151212000
2018-08-30SPY290.36122950161052000
2018-08-31SPY290.3166140838292589000
2018-09-04SPY289.815759436741003000
2018-09-05SPY289.0372452437NULLNULL
2018-09-06SPY288.16659098633235000
2018-09-07SPY287.6735248248466000
2018-09-10SPY288.15021090311448000
2018-09-11SPY289.0550530492NULLNULL
2018-09-12SPY289.12598107586991000
2018-09-13SPY290.83510342223283000
2018-09-14SPY290.8855079875222000
2018-09-17SPY289.34682440435656000
2018-09-18SPY290.9161930407175000
2018-09-19SPY291.2249080562164000
2018-09-20SPY293.581003606463185000
2018-09-21SPY291.9910547965611774000
2018-09-24SPY291.02534096451185000
2018-09-25SPY290.75443700375659000
2018-09-26SPY289.88797396746735000
2018-09-27SPY290.6959249455122268000
2018-09-28SPY290.72700913851510000
2018-10-01SPY291.73620789378492000
2018-10-02SPY291.56472582276760000
2018-10-03SPY291.72646945942510000
2018-10-04SPY289.44111545910212272000
2018-10-05SPY287.821059516988969000
2018-10-08SPY287.8287742172132314000
2018-10-09SPY287.4743389823133000
2018-10-10SPY278.321473104272358000
2018-10-11SPY272.17274840491132745000
2018-10-12SPY275.95183186492101774000
2018-10-15SPY274.41022637175305000
2018-10-16SPY280.41182558345679000
2018-10-17SPY280.4511062598751090000
2018-10-18SPY276.41345575253215000
2018-10-19SPY276.251399016344592000
2018-10-22SPY275.01824158126983000
2018-10-23SPY273.61146352719214205000
2018-10-24SPY265.3217780669781444000
2018-10-25SPY270.08138061545166000
2018-10-26SPY265.33201574596112662000
2018-10-29SPY263.861607491017615000
2018-10-30SPY267.77157115995184021000
2018-10-31SPY270.63128296325268000
2018-11-01SPY273.519949503742130000
2018-11-02SPY271.89122634107410858000
2018-11-05SPY273.39656224822737000
2018-11-06SPY275.12600858945643000
2018-11-07SPY281.011027520995831000
2018-11-08SPY280.56558488661412000
2018-11-09SPY277.76988125618875000
2018-11-12SPY272.579967357451593000
2018-11-13SPY272.06981766103340000
2018-11-14SPY270.21253359318968000
2018-11-15SPY273.02135101437192189000
2018-11-16SPY273.7312666804071196000
2018-11-19SPY269.11030617065341000
2018-11-20SPY264.12136021311205603000
2018-11-21SPY265.027556374381134000
2018-11-23SPY263.254280787841161000
2018-11-26SPY267.5799813626506000
2018-11-27SPY268.47550244131808000
2018-11-28SPY274.58127629633165454000
2018-11-29SPY273.9882346420NULLNULL