calculations.matches_3_odds_inplay_draw

Per-event aggregates for the draw in-play odd: max/min (with minute & score), plus count, first, last, mean and standard deviation across minutes.

Lineage

flowchart LR
i1[/calculations.inplay_1_by_minute/] --> me[/calculations.matches_3_odds_inplay_draw/]
me --> mart[/mart.matches/]
click i1 "/calculations/inplay_1_by_minute/" "Open"
click mart "/mart/matches/" "Open"

Columns

Column	Description	Formula
event_id	Bet365 event identifier.	passthrough
event_date	Event date.	passthrough
event_partition_key	ClickHouse partition key.	passthrough
max_draw_odd_minute_id	Minute of max draw odd (latest on tie).	dense_rank() over (partition by event_id order by draw_odd DESC, minute_id DESC) = 1
max_draw_odd_short_score	Score at that minute.	tied row
max_draw_odd	Max draw odd in-play.	tied row
min_draw_odd_minute_id	Minute of min draw odd (latest on tie).	dense_rank() over (partition by event_id order by draw_odd, minute_id DESC) = 1
min_draw_odd_short_score	Score at that minute.	tied row
min_draw_odd	Min draw odd in-play.	tied row
odds_inplay_count_draw	Number of minute rows.	count(*) over (partition by event_id)
odds_inplay_first_draw	Earliest draw odd.	first_value(draw_odd) over (partition by event_id order by minute_id)
odds_inplay_last_draw	Latest draw odd.	first_value(draw_odd) over (partition by event_id order by minute_id desc)
odds_inplay_avg_draw	Mean draw odd.	avg(draw_odd) over (partition by event_id)
odds_inplay_std_draw	StDev across minutes.	STD(draw_odd) over (partition by event_id)