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 = call_vertical_spread×ticker = XBI×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
01a08722-78d8-7961-a29e-9f6951f376fc	XBI	2026-09-09 13:06	call_vertical_spread	2	1	55	176000.00	long	ask	160.5100	1.9500	["143","150"]	["0.3095","0.3047"]	["148.78"]	["XPHO"]	143.0000	150.0000	37	37	false	false	false	true	false	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-09T17:07:08Z"}	2026-09-09	2026-09-09 17:15	2026-09-09 17:15
01a0a0d1-d1e8-7c02-9e4f-cd9d5c14306f	XBI	2026-09-14 12:48	call_vertical_spread	2	1	75	207825.00	long	ask	158.4900	1.4500	["143","150"]	["0.2858","0.2979"]	["148.55"]	["XMIO"]	143.0000	150.0000	32	32	false	false	false	true	false	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-14T16:48:28Z"}	2026-09-14	2026-09-14 17:15	2026-09-14 17:15
01a0a157-78c1-74c3-9689-23d569abf996	XBI	2026-09-14 15:14	call_vertical_spread	2	1	81	218457.00	short	bid	157.5300	1.9000	["143","150"]	["0.3352","0.3213"]	["148.53"]	["XCBO"]	143.0000	150.0000	32	32	false	false	false	true	false	mlat	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-14T19:14:49Z"}	2026-09-14	2026-09-14 17:15	2026-09-14 17:15
01a0a5c7-497e-7cb3-8da3-c8aa03b30d4f	XBI	2026-09-15 11:54	call_vertical_spread	2	1	100	111500.00	short	bid	153.3600	1.4500	["148","149"]	["0.4369","0.4219"]	["148.85"]	["XPHO"]	148.0000	149.0000	3	3	false	false	false	true	false	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-15T15:55:00Z"}	2026-09-15	2026-09-15 19:28	2026-09-15 19:28