Spreadsheet: 810182d1671589031-combine-data-in-2-rows-into-1-single-row-bbl_data_2-rows-merge
Sheet: BBL_2015_2016_Match_Odds

DATE | EVENT_PATH | MENU_HINT | EVENT_ID | EVENT_NAME | SELECTION_ID | SELECTION_NAME | RESULT | PREPLAY_LAST_TRADED_PRICE | PREPLAY_MIN_PRICE | PREPLAY_MAX_PRICE | PREPLAY_WAP | INPLAY_MIN_PRICE | INPLAY_MAX_PRICE | INPLAY_WAP | PREPLAY_VOLUME_AUD | INPLAY_VOLUME_AUD
2015-12-17 00:00:00 | Big Bash League 2015/16/Fixtures 17 December / [NAME] Sydney Sixers | Fixtures 17 December / [NAME] Sydney Sixers | 101342783 | Match Odds | 5728190 | [NAME] | W | 1.88 | 1.85 | 2.5 | 2 | 1.01 | 2.4 | 1.48 | 1104385.04 | 25538566.07
2015-12-17 00:00:00 | Big Bash League 2015/16/Fixtures 17 December / [NAME] Sydney Sixers | Fixtures 17 December / [NAME] Sydney Sixers | 101342783 | Match Odds | 5728225 | [NAME] | L | 2.14 | 1.51 | 2.16 | 1.91 | 1.72 | 1000 | 2.46 | 776795.73 | 7942063.23
2015-12-18 00:00:00 | Big Bash League 2015/16/Fixtures 18 December / Adelaide v Melbourne Stars | Fixtures 18 December / Adelaide v Melbourne Stars | 101342784 | Match Odds | 5728187 | [NAME] | L | 1.57 | 1.53 | 1.73 | 1.6 | 1.23 | 1000 | 1.95 | 1438890.31 | 15187092.95
2015-12-18 00:00:00 | Big Bash League 2015/16/Fixtures 18 December / Adelaide v Melbourne Stars | Fixtures 18 December / Adelaide v Melbourne Stars | 101342784 | Match Odds | 5728191 | Adealide Strikers | W | 2.76 | 2.1 | 2.9 | 2.62 | 1.01 | 5.2 | 1.81 | 185019.02 | 27452219.56
2015-12-19 00:00:00 | Big Bash League 2015/16/Fixtures 19 December / Brisbane v Melbourne Renegades | Fixtures 19 December / Brisbane v Melbourne Renegades | 101342785 | Match Odds | 5728194 | [NAME] | L | 2.58 | 2.18 | 2.64 | 2.47 | 1.43 | 1000 | 2.1 | 211787.32 | 18002956.82
2015-12-19 00:00:00 | Big Bash League 2015/16/Fixtures 19 December / Brisbane v Melbourne Renegades | Fixtures 19 December / Brisbane v Melbourne Renegades | 101342785 | Match Odds | 5728189 | Melbourne Renegades | W | 1.63 | 1.59 | 1.85 | 1.67 | 1.01 | 3.25 | 1.67 | 1340922.59 | 22102892.73
2015-12-20 00:00:00 | Big Bash League 2015/16/Fixtures 20 December / [NAME] v [NAME] | Fixtures 20 December / [NAME] v [NAME] | 101342786 | Match Odds | 5728193 | [NAME] | L | 2 | 1.96 | 2.34 | 2.02 | 1.56 | 1000 | 3.3 | 281655.86 | 5335410.23
2015-12-20 00:00:00 | Big Bash League 2015/16/Fixtures 20 December / [NAME] v [NAME] | Fixtures 20 December / [NAME] v [NAME] | 101342786 | Match Odds | 5728225 | [NAME] | W | 1.99 | 1.66 | 2.04 | 1.96 | 1.01 | 2.7 | 1.38 | 528297.43 | 24363374.99
2015-12-20 00:00:00 | Big Bash League 2015/16/Fixtures 20 December / Melbourne Stars v [NAME] | Fixtures 20 December / Melbourne Stars v [NAME] | 101342787 | Match Odds | 5728187 | [NAME] | L | 1.6 | 1.48 | 1.73 | 1.65 | 1.1 | 20 | 1.58 | 1155107.67 | 22932571.46
2015-12-20 00:00:00 | Big Bash League 2015/16/Fixtures 20 December / Melbourne Stars v [NAME] | Fixtures 20 December / Melbourne Stars v [NAME] | 101342787 | Match Odds | 5728190 | [NAME] | W | 2.66 | 2.36 | 3.05 | 2.51 | 1.01 | 11 | 1.66 | 260585.65 | 18728783.44
2015-12-21 00:00:00 | Big Bash League 2015/16/Fixtures 21 December / Perth v Adelaide | Fixtures 21 December / Perth v Adelaide | 101342788 | Match Odds | 5728188 | [NAME] | L | 1.61 | 1.48 | 1.7 | 1.6 | 1.46 | 1000 | 1.98 | 1593042.93 | 22539648.3
2015-12-21 00:00:00 | Big Bash League 2015/16/Fixtures 21 December / Perth v Adelaide | Fixtures 21 December / Perth v Adelaide | 101342788 | Match Odds | 5728253 | Adelaide Strikers | W | 2.64 | 2.42 | 3 | 2.66 | 1.01 | 3.15 | 1.71 | 225124.78 | 29865130.72
2015-12-22 00:00:00 | Group C/Big Bash League 2015/16/Fixtures 22 December/Hobart v Brisbane | Fixtures 22 December / Hobart v Brisbane | 101356021 | Match Odds | 5728194 | [NAME] | L | 2.38 | 2.06 | 2.48 | 2.29 | 1.94 | 1000 | 3.23 | 173578.7 | 11425187.82
2015-12-22 00:00:00 | Group C/Big Bash League 2015/16/Fixtures 22 December/Hobart v Brisbane | Fixtures 22 December / Hobart v Brisbane | 101356021 | Match Odds | 5728193 | [NAME] | W | 1.73 | 1.52 | 1.94 | 1.75 | 1.01 | 2.08 | 1.39 | 1182296.94 | 44031639.79