Multi-leg option trades

core.multileg_trades

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

508,354 rowsCSV — whole table, not this view

Sources in this table

uw_multileg508,354 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:direction = long×endpoint = /api/option-trades/multi-leg×ticker = XLI×

idtext	tickertext	executed_at ↓timestamp with time zone	strategytext	leg_countinteger	txnsinteger	sizebigint	total_premiumnumeric

01a0d929-02b7-7930-bbc0-7f6db2d71b17	XLI	2026-09-25 11:22	call_calendar	2	3	173	30188.00	long	bid	169.6150	0.3800	["186"]	["0.2073"]	[]	["ARCO","XCBO","XISX"]	186.0000	186.0000	21	84	false	true	true	false	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T15:22:45Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0d8eb-8c57-75b3-b519-f8cbaf21f2b5	XLI	2026-09-25 10:15	call_vertical_spread	2	1	29	33408.00	long	ask	169.5600	0.6000	["171","174"]	["0.1962","0.1936"]	["172.42"]	["BATO"]	171.0000	174.0000	84	84	false	true
01a0d8ce-c13f-7d72-bea4-88f5127f1c8c	XLI	2026-09-25 09:43	call_vertical_spread	2	1	25	30350.00	long	ask	170.2600	1.5000	["171","174"]	["0.2038","0.1837"]	["173.04"]	["AMXO"]	171.0000	174.0000	84	84	false	true
01a0cfd7-7b67-77e1-9740-f87b1f0433ac	XLI	2026-09-23 15:56	ratio_risk_reversal	2	2	76	32928.00	long	bid	170.1300	0.4700	["170","180"]	["0.1883","0.1931"]	["169.7"]	["ARCO","XBOX"]	170.0000	180.0000	58	58	false	true
01a0cf3b-2faf-7bc0-afb2-0aeee8e29d9b	XLI	2026-09-23 13:05	straddle	2	2	96	124896.00	long	ask	170.4400	0.6750	["173"]	["0.1964"]	["159.99","186.01"]	["ARCO","EDGO"]	173.0000	173.0000	86	86	false	false
01a0caad-79cf-78c0-9f7f-3043d6605a74	XLI	2026-09-22 15:52	call_ratio_spread	2	2	172	62780.00	long	ask	170.4600	0.4900	["173","195"]	["0.1929","0.1862"]	["177.72","212.28"]	["ARCO","EDGO"]	173.0000	195.0000	87	87	false	true
01a0caad-71ff-7913-ae5a-e07e939efea8	XLI	2026-09-22 15:52	call_ratio_spread	2	2	180	65880.00	long	ask	170.4650	0.6300	["173","195"]	["0.1934","0.1862"]	["177.74","212.26"]	["C2OX","EDGO"]	173.0000	195.0000	87	87	false	true
01a0caa4-138f-70e2-a391-3c4e280fdaa6	XLI	2026-09-22 15:42	call_ratio_spread	2	4	94	48595.00	long	ask	170.2800	0.6700	["170","195"]	["0.1864","0.1782"]	["176.46","213.54"]	["C2OX","EDGO","XCBO","XISX"]	170.0000	195.0000	115	115	false	false
01a0caa4-138f-70e2-a391-3c3e6239f36e	XLI	2026-09-22 15:42	call_ratio_spread	2	7	116	59845.00	long	ask	170.2800	0.6700	["170","195"]	["0.1861","0.1778"]	["176.46","213.54"]	["ARCO","EMLD","MCRY","SPHR","XBOX","XMIO","XPHO"]	170.0000	195.0000	115	115	false	false
01a0caa4-138f-70e2-a391-3c2f5a7b51a0	XLI	2026-09-22 15:42	call_ratio_spread	2	5	78	39999.00	long	ask	170.2800	0.6700	["170","195"]	["0.1852","0.1771"]	["176.45","213.55"]	["AMXO","ARCO","MCRY","XMIO","XPHO"]	170.0000	195.0000	115	115	false	false
01a0ca24-1dbf-7b71-a30c-2c2bc2bcd9bb	XLI	2026-09-22 13:22	call_diagonal_spread	2	1	10	25520.00	long	ask	169.6000	1.1500	["168","170"]	["0.2019","0.2044"]	[]	["ARCO"]	168.0000	170.0000	87	360	false	false
01a0ca23-cf9f-7fd2-9687-9701bebe1042	XLI	2026-09-22 13:22	call_diagonal_spread	2	2	10	31800.00	long	ask	169.6500	1.2000	["160","168"]	["0.2128","0.2022"]	[]	["ARCO","XPHO"]	160.0000	168.0000	87	360	true	false
01a0c96c-b49e-79d2-96eb-4d80bd19a096	XLI	2026-09-22 10:02	call_ratio_spread	2	4	54	27750.00	long	ask	169.9300	0.6600	["170","195"]	["0.1882","0.1822"]	["176.25","213.75"]	["C2OX","EDGO","XCBO","XISX"]	170.0000	195.0000	115	115	false	true
01a0c96c-b49e-79d2-96eb-4d482db92093	XLI	2026-09-22 10:02	call_ratio_spread	2	5	60	30652.00	long	ask	169.9300	0.6600	["170","195"]	["0.1875","0.1814"]	["176.25","213.75"]	["ARCO","MCRY","SPHR","XBOX","XPHO"]	170.0000	195.0000	115	115	false	true
01a0c58d-d0a6-7a30-b65b-796faa456b0e	XLI	2026-09-21 15:59	call_ratio_spread	2	1	78	28119.00	long	ask	169.9500	0.2300	["173","195"]	["0.1959","0.1892"]	["177.59","212.41"]	["EDGO"]	173.0000	195.0000	88	88	false	true
01a0c58d-d0a6-7a30-b65b-795c13249b88	XLI	2026-09-21 15:59	call_ratio_spread	2	1	120	43200.00	long	ask	169.9400	0.2300	["173","195"]	["0.1960","0.1889"]	["177.60","212.40"]	["EDGO"]	173.0000	195.0000	88	88	false	true
01a0c58b-f7fe-7243-82b5-f72fdb82524e	XLI	2026-09-21 15:57	call_ratio_spread	2	1	220	79090.00	long	ask	169.9900	0.6600	["173","195"]	["0.1944","0.1893"]	["177.55","212.45"]	["EDGO"]	173.0000	195.0000	88	88	false	true
01a0b613-1a70-7953-8d32-d8c64a8121ee	XLI	2026-09-18 15:51	iron_butterfly	4	1	82	61500.00	long	bid	169.8200	0.5800	["155","170","180"]	["0.2372","0.1772","0.1702"]	["164.20","175.80"]	["C2OX"]	155.0000	180.0000	28	28	false	false
01a0b602-883f-7c30-8afb-6201d3a6ac65	XLI	2026-09-18 15:33	put_diagonal_spread	2	1	22500	19620000.00	long	bid	169.4550	0.7500	["160","170"]	["0.2155","0.1975"]	[]	["SPHR"]	160.0000	170.0000	63	119	false	false
01a0b5f1-696f-7e43-a694-64439e3ea41b	XLI	2026-09-18 15:14	put_frontspread	2	3	69	32597.00	long	ask	169.5050	0.5300	["164","172"]	["0.2066","0.1977"]	["153.00","169.50"]	["AMXO","EDGO","XPHO"]	164.0000	172.0000	28	28	false	false
01a0b5f1-696f-7e43-a694-6439befa3b60	XLI	2026-09-18 15:14	put_frontspread	2	2	108	50562.00	long	ask	169.5050	0.5300	["164","172"]	["0.2053","0.1958"]	["152.98","169.51"]	["EDGO","XPHO"]	164.0000	172.0000	28	28	false	false
01a0b4df-e200-7ea1-8122-01e8f739436c	XLI	2026-09-18 10:16	call_diagonal_spread	2	1	66	661518.00	long	ask	168.9900	3.2500	["120","121"]	["0.5246","0.3110"]	[]	["XCBO"]	120.0000	121.0000	63	182	false	false
01a0b4c7-1e27-7a51-aac7-7fe568e7d624	XLI	2026-09-18 09:49	call_ratio_spread	2	2	62	28923.00	long	ask	169.1600	0.3100	["170","195"]	["0.1784","0.1757"]	["175.89","214.11"]	["EDGO","XCBO"]	170.0000	195.0000	119	119	false	true
01a0b4c6-3f7f-7201-8e92-66bea8be6e9f	XLI	2026-09-18 09:48	call_ratio_spread	2	1	196	63308.00	long	ask	169.2400	0.3200	["173","195"]	["0.1836","0.1846"]	["177.14","212.86"]	["EDGO"]	173.0000	195.0000	91	91	false	true
01a0a670-1086-7f40-a335-5bae1a2be84b	XLI	2026-09-15 14:59	straddle	2	1	270	205740.00	long	ask	169.1500	0.4500	["169"]	["0.1936"]	["161.38","176.62"]	["EDGO"]	169.0000	169.0000	31	31	true	false
01a081f1-37c8-7341-abec-8c220c8c26fc	XLI	2026-09-08 12:54	put_frontspread	2	2	372	312101.00	long	ask	175.1300	1.2000	["140","157"]	["0.2553","0.2428"]	["119.42","156.76"]	["XCBO"]	140.0000	157.0000	500	500	true	true
01a06ddf-d065-71f1-9d2c-5a229ee84100	XLI	2026-09-04 15:22	call_backspread	2	1	3000	396000.00	long	bid	175.0100	0.3100	["177.5","180"]	["0.1628","0.1661"]	["182.54"]	["XPHO"]	177.5000	180.0000	14	14	false	true