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:code = mlft×endpoint = /api/option-trades/multi-leg×ticker = PCG×

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
01a0c54c-d3ef-7bc1-a998-253bd4978865	PCG	2026-09-21 14:48	call_ratio_spread	2	1	15000	770000.00	long	ask	13.0500	0.1200	["15","20"]	["0.5017","0.5104"]	["15.53","28.94"]	["XPHO"]	15.0000	20.0000	88	88	false	true	false	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-21T18:49:04Z"}	2026-09-21	2026-09-21 17:15	2026-09-21 17:15
01a0b4d5-db97-7b40-b1a0-ef8d934a9401	PCG	2026-09-18 10:05	call_vertical_spread	2	1	4166	141644.00	short	bid	13.3050	0.4500	["18","21"]	["0.5986","0.6913"]	["18.10"]	["XPHO"]	18.0000	21.0000	63	63	false	true	false	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T14:05:15Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a08c9e-d090-72c3-a8a3-d7448fed6912	PCG	2026-09-10 14:40	other	4	1	1048	398148.00	unknown	—	14.0450	1.4900	["15.5","16","16.5","17"]	["1.4816","1.8234","2.2186","3.3892"]	[]	["XBOX"]	15.5000	17.0000	1	1	false	false	false	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-10T18:40:22Z"}	2026-09-10	2026-09-10 17:15	2026-09-10 17:15
01a08c04-22e8-7511-a8d6-8fb51116ed60	PCG	2026-09-10 11:51	call_vertical_spread	2	1	5000	1020000.00	long	ask	14.2350	0.3800	["15","20"]	["0.6224","0.6349"]	["16.12"]	["SPHR"]	15.0000	20.0000	99	99	false	true	false	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-10T15:51:34Z"}	2026-09-10	2026-09-10 17:15	2026-09-10 17:15
01a08bbb-cf49-71d3-809f-99994d88b0b5	PCG	2026-09-10 10:32	other	3	1	7890	1149310.00	unknown	—	14.3050	0.4200	["11","17","20"]	["0.6232","0.6541","0.6185"]	[]	["SPHR"]	11.0000	20.0000	99	99	false	true	false	true	true	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-10T14:32:47Z"}	2026-09-10	2026-09-10 17:15	2026-09-10 17:15
01a08bac-5270-7302-946e-ae11d5873a5b	PCG	2026-09-10 10:15	call_ratio_spread	2	1	40000	5220000.00	long	ask	14.2650	0.2400	["15","20"]	["0.6340","0.6461"]	["15.65","24.35"]	["SPHR"]	15.0000	20.0000	99	99	false	true	false	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-10T14:15:27Z"}	2026-09-10	2026-09-10 17:15	2026-09-10 17:15
01a0871f-9e60-77b2-8270-d1dfdf1e2baa	PCG	2026-09-09 13:03	other	2	1	40886	11652510.00	unknown	—	14.4450	0.2200	["16"]	["0.6584"]	[]	["XPHO"]	16.0000	16.0000	72	128	false	true	true	false	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-09T17:03:21Z"}	2026-09-09	2026-09-09 17:15	2026-09-09 17:15
01a081db-ee90-7ca2-88be-fade789c2dd2	PCG	2026-09-08 12:31	call_calendar	2	2	10000	3195000.00	long	bid	14.7800	0.1800	["16"]	["0.6613"]	[]	["ARCO"]	16.0000	16.0000	73	129	false	true	true	false	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-08T16:31:24Z"}	2026-09-08	2026-09-08 21:50	2026-09-08 21:50