Multi-leg option trades

core.multileg_trades

Class E accrual with a 24-hour vendor cap - the shortest window in the project.

367,592 rowsCSV — whole table, not this view

Sources in this table

uw_multileg367,592 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:strategy = put_diagonal_spread×ticker = XLF×sorted by executed_at ↑×

idtext	tickertext	executed_at ↑timestamp with time zone	strategytext	leg_countinteger	txnsinteger	sizebigint	total_premiumnumeric	directiontext	net_sidetext	underlying_pricenumeric	bid_ask_spreadnumeric	strikesjsonb	ivsjsonb	breakevensjsonb	uniq_exchangesjsonb	min_strikenumeric	max_strikenumeric	min_dteinteger	max_dteinteger	all_opening_legsboolean	all_otmboolean	diff_expirationsboolean	diff_strikesboolean	diff_typesboolean	codetext	kept_bytext	sourcetext	endpointtext	request_paramsjsonb	as_ofdate	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone
01a0a5ec-55de-7a21-ab99-1f9f76b8c6da	XLF	2026-09-15 12:35	put_diagonal_spread	2	1	867	47684.00	long	bid	56.6100	0.1000	["56","57"]	["0.2380","0.1584"]	[]	["XMIO"]	56.0000	57.0000	0	2	false	false	true	true	false	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-15T16:35:51Z"}	2026-09-15	2026-09-15 19:28	2026-09-15 19:28
01a0a685-4635-7c92-9e84-425ddd53682c	XLF	2026-09-15 15:22	put_diagonal_spread	2	2	1086	94435.00	unknown	—	56.8900	0.1400	["55.5","57"]	["0.2004","0.2052"]	[]	["AMXO"]	55.5000	57.0000	3	17	false	false	true	true	false	mlft	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-15T19:22:46Z"}	2026-09-15	2026-09-15 19:28	2026-09-15 19:28
01a0abc7-c243-7993-bb51-a814a8e98068	XLF	2026-09-16 15:53	put_diagonal_spread	2	1	10000	150000.00	long	ask	55.8850	0.0600	["55","55.5"]	["0.2692","1.6420"]	[]	["SPHR"]	55.0000	55.5000	0	2	false	true	true	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-16T19:53:11Z"}	2026-09-16	2026-09-16 17:15	2026-09-16 17:15
01a0b5fd-8318-7510-833c-a2ec900819cb	XLF	2026-09-18 15:28	put_diagonal_spread	2	1	1109	168568.00	long	bid	55.8950	0.0500	["56","57"]	["0.1662","1.5501"]	[]	["XBOX"]	56.0000	57.0000	0	4	false	false	true	true	false	mlat	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T19:28:25Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a0c4c4-fe7e-7573-82c4-a90fbcf9449d	XLF	2026-09-21 12:20	put_diagonal_spread	2	1	270	28080.00	unknown	ask	55.9100	0.0400	["50","55"]	["0.2050","0.1782"]	[]	["EDGO"]	50.0000	55.0000	116	179	false	true	true	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-21T16:20:46Z"}	2026-09-21	2026-09-21 17:15	2026-09-21 17:15
01a0c4e6-fd9f-7820-b4f5-a6068f452a75	XLF	2026-09-21 12:57	put_diagonal_spread	2	1	152	68172.00	unknown	bid	55.9150	0.2700	["54","56"]	["0.1813","0.2105"]	[]	["EDGO"]	54.0000	56.0000	179	487	false	false	true	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-21T16:58:17Z"}	2026-09-21	2026-09-21 17:15	2026-09-21 17:15
01a0c4fc-0857-7332-86ed-53ff5816848f	XLF	2026-09-21 13:20	put_diagonal_spread	2	3	188	84122.00	unknown	ask	56.0350	0.2200	["54","56"]	["0.1833","0.2120"]	[]	["AMXO","XCBO","XPHO"]	54.0000	56.0000	179	487	false	true	true	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-21T17:20:47Z"}	2026-09-21	2026-09-21 17:15	2026-09-21 17:15
01a0c537-9287-7662-8da5-e3326a1d29b9	XLF	2026-09-21 14:25	put_diagonal_spread	2	1	537	56564.00	unknown	ask	55.9150	0.0600	["50","55"]	["0.2061","0.1797"]	[]	["XCBO"]	50.0000	55.0000	116	179	false	true	true	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-21T18:25:59Z"}	2026-09-21	2026-09-21 17:15	2026-09-21 17:15