calculations.matches_1_odds_prematch

Captures the first- and last-seen prematch decimal odds (i.e. is_in_play = 0) for home/draw/away. One row per event.

Lineage

flowchart LR
od[/sources.odds/] --> me[/calculations.matches_1_odds_prematch/]
me --> m11[/matches_11_probability/]
me --> m15[/matches_15_strat_expected_value/]
me --> m16[/matches_16_strat_kelly_criterion/]
me --> m17[/matches_17_strat_predicted/]
me --> m18[/matches_18_strat_bet/]
me --> mart[/mart.matches/]
click od "/sources/odds/" "Open"
click m11 "/calculations/matches_11_probability/" "Open"
click m15 "/calculations/matches_15_strat_expected_value/" "Open"
click m16 "/calculations/matches_16_strat_kelly_criterion/" "Open"
click m17 "/calculations/matches_17_strat_predicted/" "Open"
click m18 "/calculations/matches_18_strat_bet/" "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
odds_prematch_first_home	Earliest prematch home odd.	first_value(home_odd) over (partition by event_id order by odd_add_time)
odds_prematch_last_home	Latest prematch home odd.	first_value(home_odd) over (partition by event_id order by odd_add_time desc)
odds_prematch_first_draw	Earliest prematch draw odd.	first_value(draw_odd) over (partition by event_id order by odd_add_time)
odds_prematch_last_draw	Latest prematch draw odd.	first_value(draw_odd) over (partition by event_id order by odd_add_time desc)
odds_prematch_first_away	Earliest prematch away odd.	first_value(away_odd) over (partition by event_id order by odd_add_time)
odds_prematch_last_away	Latest prematch away odd.	first_value(away_odd) over (partition by event_id order by odd_add_time desc)

Filtered to is_in_play = 0 and home_odd is not null before the window calculation.