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 = cbmo×net_side = ask×strategy = put_ratio_spread×

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
01a0c533-be0e-7bd1-8ed0-c35eacb186de	SPX	2026-09-21 14:21	put_ratio_spread	2	1	200	3527500.00	unknown	ask	7764.9200	1.6000	["7650","7830"]	["0.1520","0.1400"]	["7520.11"]	["XCBO"]	7650.0000	7830.0000	88	88	false	false	false	true	false	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-21T18:21:46Z"}	2026-09-21	2026-09-21 17:15	2026-09-21 17:15
01a0b60c-6f67-7242-8f61-62a9afcbefff	SPX	2026-09-18 15:44	put_ratio_spread	2	1	25	37050.00	unknown	ask	7643.7100	0.4000	["7200","7325"]	["0.1915","0.1671"]	["7310.18"]	["XCBO"]	7200.0000	7325.0000	14	14	false	true	false	true	false	cbmo	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T19:44:37Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a0b5fd-dcef-7ac3-8ff5-d01fc873f919	SPX	2026-09-18 15:28	put_ratio_spread	2	1	80	372520.00	unknown	ask	7640.1600	1.0000	["6675","7710"]	["0.2325","0.1411"]	["6654.81"]	["XCBO"]	6675.0000	7710.0000	91	91	false	false	false	true	false	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T19:28:53Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a0b5dd-358f-7362-b94b-31737891a990	SPX	2026-09-18 14:52	put_ratio_spread	2	2	1975	10979450.00	unknown	ask	7642.9000	0.5000	["7350","7400"]	["0.1642","0.1575"]	["7333.80"]	["XCBO"]	7350.0000	7400.0000	28	28	false	true	false	true	false	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T18:52:57Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a0b5cd-62c7-7282-b9ad-f5295f199555	SPX	2026-09-18 14:35	put_ratio_spread	2	1	400	412400.00	unknown	ask	7634.6400	0.4500	["7160","7425"]	["0.2010","0.1497"]	["7383.76"]	["XCBO"]	7160.0000	7425.0000	14	14	false	true	false	true	false	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T18:35:38Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a0b5c7-ffdf-7521-8202-613998ae1c8d	SPX	2026-09-18 14:29	put_ratio_spread	2	1	200	255000.00	unknown	ask	7634.3500	0.4000	["7400","7600"]	["0.1579","0.1125"]	["7549"]	["XCBO"]	7400.0000	7600.0000	7	7	false	true	false	true	false	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T18:29:54Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a0b55d-9997-7122-87b8-57ea70c33ec0	SPX	2026-09-18 12:33	put_ratio_spread	2	1	150	378000.00	unknown	ask	7620.1100	0.4000	["7475","7560"]	["0.1433","0.1247"]	["7509.60"]	["XCBO"]	7475.0000	7560.0000	7	7	false	true	false	true	false	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T16:33:40Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15