calculations.matches_2_odds_inplay_home

Per-event aggregates for the home in-play odd: max and min (with the minute and score they occurred at), plus count, first, last, mean and standard deviation across the in-play minute series.

Lineage

flowchart LR
i1[/calculations.inplay_1_by_minute/] --> me[/calculations.matches_2_odds_inplay_home/]
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_home_odd_minute_id	Minute at which home_odd reached its maximum (latest minute on tie).	dense_rank() over (partition by event_id order by home_odd DESC, minute_id DESC) = 1
max_home_odd_short_score	Score string at that minute.	tied row above
max_home_odd	Max home odd seen in-play.	tied row above
min_home_odd_minute_id	Minute at which home_odd reached its minimum (latest minute on tie).	dense_rank() over (partition by event_id order by home_odd, minute_id DESC) = 1
min_home_odd_short_score	Score string at that minute.	tied row above
min_home_odd	Min home odd seen in-play.	tied row above
odds_inplay_count_home	Number of minute rows.	count(*) over (partition by event_id)
odds_inplay_first_home	Home odd at the earliest minute.	first_value(home_odd) over (partition by event_id order by minute_id)
odds_inplay_last_home	Home odd at the latest minute.	first_value(home_odd) over (partition by event_id order by minute_id desc)
odds_inplay_avg_home	Mean home odd across minutes.	avg(home_odd) over (partition by event_id)
odds_inplay_std_home	Standard deviation across minutes.	STD(home_odd) over (partition by event_id)