Simplify Analytics

← Data Explorer

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

active:code = mlft×ticker = AAPL×

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
01a087a6-79d1-7d71-8700-bf93c619a18d	AAPL	2026-09-09 15:30	straddle	2	2	110	1238600.00	short	bid	315.4800	4.3500	["350"]	["0.2989"]	["237.40","462.60"]	["SPHR"]	350.0000	350.0000	828	828	false	false	false	false	true	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-09T19:30:35Z"}	2026-09-09	2026-09-09 17:15	2026-09-09 17:15
01a08793-8e10-7703-b49b-14eb116a5f9c	AAPL	2026-09-09 15:09	other	4	1	60	120180.00	unknown	—	315.5045	1.4200	["315","322.5","330"]	["0.5788","1.1233","0.2565"]	[]	["SPHR"]	315.0000	330.0000	0	44	false	false	true	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-09T19:10:13Z"}	2026-09-09	2026-09-09 17:15	2026-09-09 17:15
01a08684-ae50-72e2-867f-4a460b53bacc	AAPL	2026-09-09 10:13	ratio_risk_reversal	2	1	360	164700.00	long	bid	316.0650	0.4100	["240","420"]	["0.3254","0.2723"]	["421.42"]	["XPHO"]	240.0000	420.0000	191	191	false	true	false	true	true	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-09T14:14:15Z"}	2026-09-09	2026-09-09 17:15	2026-09-09 17:15
01a08160-bf68-7063-ace0-0cace3167645	AAPL	2026-09-08 10:16	ratio_risk_reversal	2	1	360	177120.00	short	ask	315.5700	0.8400	["240","420"]	["0.3259","0.2671"]	["420.60"]	["AMXO"]	240.0000	420.0000	192	192	false	true	false	true	true	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-08T14:16:44Z"}	2026-09-08	2026-09-08 21:50	2026-09-08 21:50
01a0814e-6c00-70d2-8db1-de28d11a6be0	AAPL	2026-09-08 09:56	put_vertical_spread	2	1	100	276400.00	short	bid	317.2400	0.9500	["290","295"]	["0.2896","0.2866"]	["293.50"]	["SPHR"]	290.0000	295.0000	220	220	false	true	false	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-08T13:56:37Z"}	2026-09-08	2026-09-08 21:50	2026-09-08 21:50
01a06dea-5f86-7cf1-8997-ef90471477a4	AAPL	2026-09-04 15:34	other	2	1	68	48076.00	unknown	—	321.6800	0.3200	["335","345"]	["0.2479","0.2431"]	[]	["XBOX"]	335.0000	345.0000	21	49	false	true	true	true	false	mlft	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-04T19:34:46Z"}	2026-09-04	2026-09-07 00:53	2026-09-07 00:53
01a06d95-59e5-7a83-b4a5-1313ec297d53	AAPL	2026-09-04 14:01	call_calendar	2	1	79	809750.00	short	bid	320.9700	2.0000	["270"]	["3.2136"]	[]	["SPHR"]	270.0000	270.0000	0	7	false	false	true	false	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-04T18:01:50Z"}	2026-09-04	2026-09-07 00:53	2026-09-07 00:53