calculations.matches_4_odds_inplay_away

Per-event aggregates for the away 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_4_odds_inplay_away/]
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_away_odd_minute_id	Minute of max away odd (latest on tie).	dense_rank() over (partition by event_id order by away_odd DESC, minute_id DESC) = 1
max_away_odd_short_score	Score at that minute.	tied row
max_away_odd	Max away odd in-play.	tied row
min_away_odd_minute_id	Minute of min away odd (latest on tie).	dense_rank() over (partition by event_id order by away_odd, minute_id DESC) = 1
min_away_odd_short_score	Score at that minute.	tied row
min_away_odd	Min away odd in-play.	tied row
odds_inplay_count_away	Number of minute rows.	count(*) over (partition by event_id)
odds_inplay_first_away	Earliest away odd.	first_value(away_odd) over (partition by event_id order by minute_id)
odds_inplay_last_away	Latest away odd.	first_value(away_odd) over (partition by event_id order by minute_id desc)
odds_inplay_avg_away	Mean away odd.	avg(away_odd) over (partition by event_id)
odds_inplay_std_away	StDev across minutes.	STD(away_odd) over (partition by event_id)