Quote from Mercor:
In the old days of pit trading all the retail stops would have been run and executed at the top of any large quick move....i would like to see a rundown of the S&P electronic trading during those 3 or 4 minutes.....
Not on Globex... it was as orderly as would be expected.
All Globex T&S data are free on the CME website, but only for the most recent 5-8 trading days:
http://www.cme.com/trading/dta/hist/hftp/ftp_gtimeandsales.html
Download gx070817.zip and unzip into 4 files for various futures and options. I took a look at the ES T&S inside gx070817.iom. The discount rate cut news must have come out at 7:15:04 CT, when ESU7=1419.50. By the end of the next second, 7:15:05, ESU7 already traded as high as 1424.50. The high that minute, 1471.50, was set at 7:15:47. Total volume from 7:15:04 to 7:16:00 (56 seconds) was 47,169 contracts, or about $3.4 Billion worth, in sizes from 1 to 500 (max) lots. That's a whole lotta people plugged into real-time news and, more important, ready to trade instantly...
Here's some of the ES T&S raw data just before and after that moment at 7:15:04 CT:
...
ES 0709F 0714560141925 14154600070817ES22 07081700081E 520070900N ES
ES 0709F 0714570141925 14156000070817ES22 07081700002E 520070900N ES
ES 0709F 0714590141925 14157100070817ES22 07081700076E 520070900N ES
ES 0709F 0715010141925 14158900070817ES22 07081700007E 520070900N ES
ES 0709F 0715030141950 14159800070817ES22 07081700010E 520070900N ES
ES 0709F 0715030141950 14160000070817ES22 07081700016E 520070900N ES
ES 0709F 0715040141950 14160200070817ES22 07081700005E 520070900N ES
ES 0709F 0715040141950 14160400070817ES22 070817<font color=red>00130</font>E 520070900N ES <font color=red> 130-lot... maybe</font>
ES 0709F 0715040141950 14160600070817ES22 07081700001E 520070900N ES
ES 0709F 0715040141975 14161300070817ES22 07081700010E 520070900N ES
ES 0709F 0715040141975 14161400070817ES22 07081700004E 520070900N ES
ES 0709F 0715040141975 14161500070817ES22 07081700016E 520070900N ES
ES 0709F 0715040141950 14161800070817ES22 07081700002E 520070900N ES
ES 0709F 0715040141975 14161900070817ES22 070817<font color=red>00312</font>E 520070900N ES <font color=red>1st 500-lot of many...</font>
ES 0709F 0715040142000 14162000070817ES22 070817<font color=red>00188</font>E 520070900N ES <font color=red>now definitely news-driven</font>
ES 0709F 0715040142000 14162100070817ES22 07081700005E 520070900N ES
ES 0709F 0715040142000 14162200070817ES22 07081700001E 520070900N ES
ES 0709F 0715040142000 14162300070817ES22 07081700010E 520070900N ES
ES 0709F 0715040142000 14163000070817ES22 07081700016E 520070900N ES
ES 0709F 0715040141975 14163100070817ES22 07081700005E 520070900N ES
ES 0709F 0715040142000 14163400070817ES22 07081700500E 520070900N ES
ES 0709F 0715040142000 14163800070817ES22 07081700007E 520070900N ES
ES 0709F 0715040141975 14164000070817ES22 07081700004E 520070900N ES
ES 0709F 0715040141975 14164100070817ES22 07081700004E 520070900N ES
ES 0709F 0715040142000 14164300070817ES22 07081700500E 520070900N ES
ES 0709F 0715040142000 14164500070817ES22 07081700016E 520070900N ES
ES 0709F 0715040142000 14164800070817ES22 07081700010E 520070900N ES
ES 0709F 0715040142000 14165000070817ES22 07081700500E 520070900N ES
ES 0709F 0715040142000 14165100070817ES22 07081700015E 520070900N ES
ES 0709F 0715040142025 14165200070817ES22 07081700001E 520070900N ES
ES 0709F 0715040142025 14165300070817ES22 07081700002E 520070900N ES
ES 0709F 0715040142025 14165400070817ES22 07081700003E 520070900N ES
ES 0709F 0715040142025 14165500070817ES22 07081700010E 520070900N ES
...
Best to open the text file gx070817.iom directly with Excel 2007. Either:
1) use the Text Import Wizard to set your columns and formats correctly;
OR
2) simply open as is, then use, e.g., "MID" and "VALUE" Excel functions, together with the file record layout at the above link, to process and analyze the file content, in any way you want. If you look at T&S often, set up a template... much faster than the manual Text Import Wizard.
If you don't have Excel 2007, to avoid truncating the file gx070817.iom (865,306 rows):
1) open it with Wordpad, Word, etc., then copy & paste a subset of interest into Excel 2003 (or older) or another spreadsheet app. Or even view it in Wordpad, as a quick-and-dirty scan.
OR
2) use freeware like
Text File Cleaver to split the file into smaller pieces (without breaking up any rows... nice), then open with older Excel or another app.